Updated 2023-10-13
    -- forked from 003 @ https://flipsidecrypto.xyz/edit/queries/440a05b6-3631-4f39-b90e-e986f3478db0

    -- forked from 002 @ https://flipsidecrypto.xyz/edit/queries/ffd56ac4-a2f5-4e4c-9d0d-41858f744f9f

    with

    token AS
    (
    SELECT
    a.address AS address
    , a.symbol AS symbol
    , a.name AS name
    , a.decimals AS decimals
    FROM
    avalanche.core.dim_contracts a
    WHERE
    a.address in (
    lower( '0xB97EF9Ef8734C71904D8002F8b6Bc66Dd9c48a6E' )
    , lower( '0x9702230A8Ea53601f5cD2dc00fDBc13d4dF4A8c7' )
    , lower( '0x152b9d0FdC40C096757F570A51E494bd4b943E50' )
    , lower( '0x130966628846BFd36ff31a822705796e8cb8C18D' )
    , lower( '0xA7D7079b0FEaD91F3e65f86E8915Cb59c1a4C664' )
    , lower( '0x6e84a6216eA6dACC71eE8E6b0a5B7322EEbC0fDd' )
    , lower( '0xc7198437980c041c805A1EDcbA50c1Ce5db95118' )
    , lower( '0xB31f66AA3C1e785363F0875A1B74E27b85FD66c7' )
    , lower( '0x2F6F07CDcf3588944Bf4C42aC74ff24bF56e7590' )
    )
    OR a.name = 'Joe LP Token'
    )

    SELECT
    date_trunc( '{{period}}' , a.hour ) AS "date"
    , avg( a.price ) AS "price usd"
    , a.symbol AS "symbol"
    FROM
    avalanche.price.ez_hourly_token_prices a
    Run a query to Download Data