freemartianCanvas Sales
    Updated 2024-10-05
    -- select * from base.nft.ez_nft_sales
    -- where tx_hash = '0x8b5982b4134efe0dd0a5197e2cdbe858a8f864d47447741ca31e9f5ccbd049f8'

    select
    count(tx_hash) as sale_count,
    count(distinct seller_address) as sellers,
    count(distinct buyer_address) as buyers,
    --tokenid as nft_ID,
    sum(price) as volume,
    sum(platform_fee) as Opensea_Fee,
    sum(creator_fee) as Basepaint_Fee
    from base.nft.ez_nft_sales
    where nft_address = '0xba5e05cb26b78eda3a2f8e3b3814726305dcac83'
    and event_type = 'sale'

    Auto-refreshes every 1 hour
    QueryRunArchived: QueryRun has been archived