headitmanagerALGO price
    Updated 2022-06-08
    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