Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
JimB-GA
Helper III
Helper III

Intraday ETF prices in Power BI

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

2 REPLIES 2
JimB-GA
Helper III
Helper III

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

1545851547241.086.74000552.8761652235.97241.39233.76124540382

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...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.