StangFAST024 - marketplaces
    Updated 2024-01-29

    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
    avalanche.nft.ez_nft_transfers a
    Last run: about 1 year ago
    type
    users
    total users
    1
    a : 1 marketplace 24382438
    2
    b : 2 marketplaces 1342572
    3
    c : 3 marketplaces 412613
    4
    d : 4 marketplaces 142627
    4
    131B
    105s