Hadisehnft 22 7
    Updated 2023-01-05
    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