StangFAST004 - per buyers [ Number ]
    Updated 2024-01-06


    with
    ---------------------- price ------------------------
    wavax AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    FROM
    avalanche.price.ez_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY 1
    ORDER BY 1 DESC
    )
    ,
    price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.token_address AS tk_add
    , a.symbol AS tk_smb
    , a.decimals AS tk_dec
    FROM
    avalanche.price.ez_hourly_token_prices a
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    skill AS
    (
    SELECT
    to_timestamp_ntz( a.value[0]::numeric / 1000 )::date AS date
    , a.value[1] AS price
    QueryRunArchived: QueryRun has been archived