freemartianCanvas Sales copy
Updated 2024-05-03
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
-- forked from Canvas Sales @ https://flipsidecrypto.xyz/edit/queries/f8e41e92-3e1d-4347-8409-ca59acbccf6b
-- 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'
QueryRunArchived: QueryRun has been archived