Intraday ETF prices in Power BI

[JimB-GA]

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

[JimB-GA]

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

[AlexisOlson]

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:

https://community.powerbi.com/t5/Desktop/Converting-UNIX-time-to-Date-in-PowerBI-for-Desktop/td-p/13...