rajsUntitled Query
Updated 2022-11-15
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- with prices as
-- (
SELECT
-- *
-- recorded_hour,
count(*),
count(distinct recorded_hour)
from solana.core.fact_token_prices_hourly
where symbol = 'SOL'
and recorded_hour >= CURRENT_DATE - interval '30 days'
-- and recorded_hour = '2022-11-06 06:00:00.000'
-- and provider = 'coinmarketcap'
-- group by 1
-- order by 2 desc
-- )
Run a query to Download Data