Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I've asked the question before, but I was unclear.
I would like to download intraday prices for the ETF 'SPY'. The interval can be up to two hours. Can anyone tell me if there is a visual or R script to accomplish this?
Thanks for the advice.
Jim-B
I have been able to retrieve current intraday pricing in an R script
current = quantmod::getQuote('SPY')
when I look at the 'current' table it returns all the information that I need except that the Trade Time shows as a large integer number ( in this case 1545851547). The trade time for this time when I run it in RStudio returns "12/26/2018 14:26"
Is there a conversion factor that I am missing?
Trade Time Last Change % Change Open High Low Volume
1545851547 | 241.08 | 6.7400055 | 2.8761652 | 235.97 | 241.39 | 233.76 | 124540382 |
That looks like an epoch time to me (# of seconds since January 1, 1970).
Check out this thread for converting to a something more readable:
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |