freemartianCanvas Sales By NFT Daily
Updated 2024-10-05
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from Canvas Sales By NFT @ https://flipsidecrypto.xyz/edit/queries/f5cfe60d-2817-46b2-be42-9c37e914d9d8
-- 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
date_trunc('day', block_timestamp) as time,
-- 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'
group by nft_ID, time
Auto-refreshes every 1 hour
QueryRunArchived: QueryRun has been archived