StangFAST01 - holder overview
    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' )
    )
    ,
    hon_price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS day
    , avg( a.price ) AS price_usd
    , 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
    )
    ,
    sen AS
    (
    SELECT
    a.from_address AS users
    , sum( a.raw_amount / power( 10 , b.decimals ) ) AS volume
    , sum( ( a.raw_amount / power( 10 , b.decimals ) ) * c.price_usd ) AS volume_usd
    Run a query to Download Data