Hadisehnft 22 7
Updated 2023-01-05Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select label,
count(DISTINCT tx_hash) as total_transaction
from ethereum.core.ez_nft_sales a join ethereum.core.dim_labels b on a.nft_address = b.address
where block_timestamp >= '2022-01-01'
and (EVENT_TYPE = 'sale'
or event_type = 'bid_won')
and label <> 'uniswap'
and label <> 'curve finance'
and price_usd > 0
group by label
order by total_transaction desc
limit 5
Run a query to Download Data