SocioCryptoAvax price
    Updated 2023-05-04
    select date_trunc('day', block_timestamp) as hours,
    median(amount_usd/amount) as avax_price,
    sum(amount) as avax_transfer
    from avalanche.core.ez_avax_transfers
    where block_timestamp::date <= CURRENT_DATE-1 AND amount_usd>0
    group by hours
    ORDER BY hours DESC
    Run a query to Download Data