StangFAST008 - overview [ number ]
    Updated 2023-10-24
    --- vault deposit | withdraw | request W | instant W
    ----------------------------------------------------------------------------------------------------------------
    --- WAVAX = 0x866810349B2e28E411669911bB0babb06cc60625 0xb6b55f25 | 0x36ea4344 , 0x7ab7cbb1 , 0x441a3e70
    --- BTC.b = 0x1cd7b33faf4f172146bcbb841c7addc96802e6c4 0xb6b55f25 | 0x36ea4344 , 0x7ab7cbb1 , 0x441a3e70
    --- USDC = 0x11B29AE3037F4526e4AA56952318e0d01ADA836A 0xb6b55f25 | 0x36ea4344 , 0x7ab7cbb1 , 0x441a3e70

    --- Inactive vault
    ----------------------------------------------------------------------------------------------------------------
    --- WAVAX = 0xFC0E57b5F8adCadc5e6E37578bb9Aa30cEe312Af 0xb6b55f25 | 0x745400c9 , 0xfd92bff2 , 0x441a3e70
    --- USDC = 0x86A6391D5d7C02245927E2DC0cBFa3e5F1B9aBC7 0xb6b55f25 | 0x745400c9 , 0xfd92bff2 , 0x441a3e70
    with

    price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.token_address AS address
    , a.symbol AS symbol
    , a.decimals AS decimal
    FROM
    avalanche.price.ez_hourly_token_prices a
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    symbol AS
    (
    SELECT

    a.contract_address
    AS address

    , case
    when a.contract_address = lower( '0x866810349B2e28E411669911bB0babb06cc60625' ) then 'WAVAX'
    when a.contract_address = lower( '0x1cd7b33faf4f172146bcbb841c7addc96802e6c4' ) then 'BTC.b'
    Run a query to Download Data