headitmanagerALGO price
Updated 2022-06-08
9
1
2
3
4
5
6
7
8
›
⌄
select avg(price_usd),BLOCK_HOUR::date ,
case
when BLOCK_HOUR::date='2022-05-11' or BLOCK_HOUR::date='2022-05-12' then 'spike'
else 'otherdate'
end as swap_date
from algorand.prices_swap where BLOCK_HOUR::date>='2022-05-01' and BLOCK_HOUR::date<='2022-05-31'
and asset_id=0
group by 2
Run a query to Download Data