h4wkPrice
Updated 2024-08-05
9
1
2
3
4
5
6
7
›
⌄
select hour::date as price_date,
avg(case when symbol = 'BONKSOL' then price end) as "BonkSOL",
avg(case when symbol = 'BONK' then price end) as "BONK"
from solana.price.ez_prices_hourly
where token_address in ('BonK1YhkXEGLZzwtcvRTip3gAL9nCeQD7ppZBLXhtTs', 'DezXAZ8z7PnrnRJjz3wXBoRgixCa6xjnB7YaB1pPB263')
and price_date >= '2024-05-01'
group by 1
QueryRunArchived: QueryRun has been archived