gokcinby
Updated 2022-09-01
9
1
2
3
4
5
6
›
⌄
select date_trunc (day,block_timestamp) as days, count (distinct tx_hash) as nft_tx_Count, sum (price_usd) as usd_volume,
count (distinct buyer_address) as "CryptoPunk Buyers", count (distinct seller_address) as "CryptoPunk Sellers"
from ethereum.core.ez_nft_sales
where price_usd is not null and project_name = 'cryptopunks' and event_type = 'sale' and days != '2021-10-28'
group by days
order by days
Run a query to Download Data