StangFAST002 - joepegs
    Updated 2023-11-03

    --- joepegs
    --- 0xae079eda901f7727d0715aff8f82ba8295719977

    --- opensea
    --- 0x00000000006c3852cbef3e08e8df289169ede581
    --- 0x00000000000001ad428e4906ae43d8f9852d0dd6
    --- 0x00000000000000adc04c56bf30ac9d3c0aaf14dc

    --- salvor
    --- 0xd106ec6e81e9b7f5bd33a6091a3c3e45b6183dc3


    --- ez_avax_transfers
    --- contract address -> origin_to_address
    --- buyer -> origin_from_address
    --- amount -> avax_to_address [ specify with contract address ]


    --- ez_nft_transfers
    --- collection -> project_name
    ---


    SELECT
    date_trunc( 'day' , a.block_timestamp ) AS "date"
    , count( distinct a.buyer_address ) AS "buyers"
    , count( distinct a.seller_address ) AS "sellers"
    , count( distinct a.tx_hash ) AS "sale count"
    , sum( a.price_usd ) AS "sale volume"
    , 'joepegs' AS "market"
    FROM
    avalanche.nft.ez_nft_sales a
    WHERE
    "date" >= '2023-01-01'
    Run a query to Download Data