StangFAST01 - hon price
    Updated 2023-08-06
    with

    hon 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 = lower( '0xEd2b42D3C9c6E97e11755BB37df29B6375ede3EB' )
    )

    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price
    , a.symbol AS token
    FROM
    avalanche.core.fact_hourly_token_prices a
    INNER JOIN
    hon b
    ON a.token_address = b.address
    GROUP BY 1 , 3
    ORDER BY 1 DESC
    Run a query to Download Data