StangFAST001 - Hyperspace
    Updated 2024-01-16

    with
    tab0 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.token_address = '0xb31f66aa3c1e785363f0875a1b74e27b85fd66c7'
    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
    avalanche.nft.ez_nft_transfers a
    LEFT OUTER JOIN
    QueryRunArchived: QueryRun has been archived