PredictionDistribution of Prices Across All ASAs on 04/27/22 at Noon
    Updated 2022-05-11
    SELECT case
    when price_usd < 0.00001 then '0$ - 0.00001$'
    when price_usd < 0.0001 then '0.00001$ - 0.0001$'
    when price_usd < 0.001 then '0.0001$ - 0.001$'
    when price_usd < 0.01 then '0.001$ - 0.01$'
    when price_usd < 0.1 then '0.01$ - 0.1$'
    when price_usd < 1 then '0.1$ - 1$'
    when price_usd < 10 then '1$ - 10$'
    else 'Greater than 10$' end as price_range,
    count(*) as quantity_of_ASAs,
    max(price_usd)
    FROM algorand.prices_swap
    WHERE date_trunc('hour',block_hour) = date_trunc('hour',cast('2022-04-27T12:00:00' as date))
    AND swaps_in_hour > 0
    GROUP BY price_range
    ORDER BY price_range asc


    Run a query to Download Data