StangFAST011 - max , avg , min [ number ]
    Updated 2024-01-29
    --- 0x00000000000000adc04c56bf30ac9d3c0aaf14dc opensea

    with

    price1 AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.token_address AS token
    , a.symbol AS symbol
    , a.decimals AS decimal
    FROM
    avalanche.price.ez_hourly_token_prices a
    WHERE
    a.symbol = 'WAVAX'
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    --- mint
    tab1 AS
    (
    SELECT
    a.block_timestamp
    , a.tx_hash
    , b.origin_to_address
    , b.avax_from_address
    , b.avax_to_address
    , a.nft_from_address
    , a.nft_to_address
    , a.project_name
    , a.tokenid
    , b.amount_precise
    , b.amount_usd
    FROM
    Last run: about 1 year ago
    collection
    avg of maximum price sold
    avg of average price sold
    avg of minimum price sold
    1
    Dokyo2198.484615887.471549592308688.115385
    1
    51B
    89s