StangFASTOverall of collection that sale on Hyperspace over time
    Updated 2024-05-08
    --- ez_token_transfers
    --- contract -> origin_to_address -> 0x398baa6ffc99126671ab6be565856105a6118a40
    --- fucntion -> origin_function_signature -> 0xfbee349d [ sale ]
    --- buyers -> origin_from_address
    --- sellers -> to_address
    --- price -> amount_precise
    --- token address -> contract_address


    --- ez_nft_transfers
    --- buyes -> nft_to_address
    --- sellers -> nft_from_address
    --- collection -> project_name
    --- nft id -> tokenid

    with

    price AS
    (
    SELECT
    date_trunc( 'day' , a.hour ) AS date
    , avg( a.price ) AS price
    , a.symbol AS symbol
    , a.token_address AS token_address
    , a.decimals AS token_decimal
    FROM
    avalanche.price.ez_hourly_token_prices a
    GROUP BY 1 , 3 , 4 , 5
    ORDER BY 1 DESC
    )
    ,
    final AS
    (
    SELECT
    a.block_timestamp AS date
    , a.tx_hash AS transaction
    QueryRunArchived: QueryRun has been archived