binhachon4. [Elite] Paradrop Airdrop Assessment - Airdrop worth
    Updated 2021-12-21
    select
    date_trunc('day', hour) as day,
    avg(price) as avg_price,
    10400 * avg_price as tier_3,
    7800 * avg_price as tier_2,
    5200 * avg_price as tier_1
    from
    ethereum.token_prices_hourly
    where symbol ilike 'psp'
    group by day

    Run a query to Download Data