StangFAST04 - supply
    Updated 2023-06-09
    -- forked from 03 - stake @ https://flipsidecrypto.xyz/edit/queries/3c2561b5-8610-4189-a63c-c0509ba8d9a2

    -- forked from 01 - swaps @ https://flipsidecrypto.xyz/edit/queries/e3f108f2-1d4f-4852-bd28-d5e3433398ec

    --- AVAX / USDC -- 0xd446eb1660f766d533beceef890df7a69d26f7d1
    --- Deposit / Withdrawal
    --- Approval /
    with

    token_price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price
    , a.symbol AS symbol
    , a.token_address AS token
    FROM
    avalanche.core.fact_hourly_token_prices a
    GROUP BY
    1 , 3 , 4
    ORDER BY
    1 DESC
    )
    ,
    avax_price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price
    , a.symbol AS symbol
    FROM
    avalanche.core.fact_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY
    1 , 3
    Run a query to Download Data