abaDaily sellers and buyers
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
›
⌄
⌄
select date(block_timestamp) date,
count(DISTINCT seller_address) as number_of_sellers,
count(DISTINCT buyer_address) as number_of_buyers
from ethereum.core.ez_nft_sales
where NFT_ADDRESS = '0xb47e3cd837ddf8e4c57f05d70ab865de6e193bbb'
and event_type = 'sale'
and buyer_address != '0x0000000000000000000000000000000000000000'
and price_usd > 0 and price_usd is not null
group by 1
order by 1
/*
select TOKENID,
sum(PRICE_USD) volume
from ethereum.core.ez_nft_sales
where project_name = 'cryptopunks' --cryptopunks
and EVENT_TYPE = 'sale'
and seller_address != '0x0000000000000000000000000000000000000000'
and PRICE_USD > 0 and PRICE_USD is not null
--and tx_hash <> '0x92488a00dfa0746c300c66a716e6cc11ba9c0f9d40d8c58e792cc7fcebf432d0'
group by 1
order by 2 desc
limit 10
*/
Run a query to Download Data