Pine Analyticschosen-gold copy copy
    Updated 2025-03-21
    -- forked from chosen-gold copy @ https://flipsidecrypto.xyz/studio/queries/5466f4a8-b027-41d9-9ade-7298d47cb437

    --select
    -- *
    --from polygon.nft.ez_nft_transfers
    --where contract_address like lower('0x251BE3A17Af4892035C37ebf5890F4a4D889dcAD')
    --and NFT_from_address like '0x0000000000000000000000000000000000000000'
    --and is_mint
    --limit 1000


    select
    count(distinct tx_hash) as sales,
    count(distinct BUYER_ADDRESS) as buyers,
    sum(price) as volume_usd,
    sum(creator_fee) as fee_usd
    from polygon.nft.ez_nft_sales
    --where tx_hash like '0xb156119493238972de2515f56fc89653d32dca8ad41e8c28352c5cdcdbbfd89b'
    where contract_address like lower('0x251be3a17af4892035c37ebf5890f4a4d889dcad')
    --limit 100
    --group by 1


    Last run: 2 months ago
    SALES
    BUYERS
    VOLUME_USD
    FEE_USD
    1
    1218295891160053427.0444883593150.8954326
    1
    48B
    4s