flipside
Insights
Studio
Quests
For Chains
For Analysts
For Explorers
About
Log in
Sign up
flipside
Untitled Query
zakkisyed
Untitled Query
Updated 2021-12-05
Copy Reference
Fork
9
1
2
3
4
5
›
⌄
select
block_timestamp
,
price_usd
,
currency
,
symbol
--date_trunc(day, block_timestamp) as Day
from
terra
.
oracle_prices
where
block_timestamp
>
CURRENT_DATE
-
90
--and currency = 'ust'
Results
Run a query to Download Data