StangFAST003 - NFTrade
    Updated 2023-11-03
    --- NFTrade
    --- 0xbf6bfe5d6b86308cf3b7f147dd03ef11f80bfde3


    with

    price 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
    )

    SELECT
    date_trunc( 'day' , a.block_timestamp ) AS "date"
    , count( distinct a.origin_from_address ) AS "buyers"
    , count( distinct b.nft_from_address ) AS "sellers"
    , count( distinct a.tx_hash ) AS "sale count"
    , sum( a.amount * c.price ) AS "sale volume"
    , 'NFTrade' AS "market"
    FROM
    avalanche.core.ez_avax_transfers a
    JOIN
    avalanche.nft.ez_nft_transfers b
    ON a.block_timestamp::date = b.block_timestamp::date
    AND a.tx_hash = b.tx_hash
    JOIN
    price c
    ON a.block_timestamp::date = c.date
    WHERE
    Run a query to Download Data