Drsimonkem 2
Updated 2024-12-30
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
DATE_TRUNC('{{Time_frame}}', block_timestamp) AS DATE,
count(distinct BUYER_ADDRESS) AS BUYERS ,
count(distinct SELLER_ADDRESS ) * -1 AS SELLERS ,
count(distinct tx_hash) as nft_sales ,
count(distinct tokenid) ,
sum(price) as price_eth,
sum(price_usd) as price_usd
from base.nft.ez_nft_sales
where nft_address = lower('0xee7d1b184be8185adc7052635329152a4d0cdefa')
group by 1
order by 2 desc
Auto-refreshes every 12 hours
QueryRunArchived: QueryRun has been archived