SELECT count(distinct TX_HASH)

FROM ethereum.core.FACT_TRANSACTIONS

left join ethereum.core.dim_labels as labels

on to_address = labels.address

WHERE tx_hash NOT IN (

SELECT tx_hash

FROM (

SELECT tx_hash FROM ethereum.core.EZ_DEX_SWAPS where year(block_timestamp)=2021

UNION

SELECT tx_hash FROM ethereum.core.EZ_ETH_TRANSFERS where year(block_timestamp)=2021

UNION

SELECT tx_hash FROM ethereum.core.EZ_NFT_MINTS where year(block_timestamp)=2021

UNION

SELECT tx_hash FROM ethereum.core.EZ_NFT_SALES where year(block_timestamp)=2021

UNION

SELECT tx_hash FROM ethereum.core.EZ_NFT_TRANSFERS where year(block_timestamp)=2021

UNION

SELECT tx_hash FROM ethereum.core.EZ_TOKEN_TRANSFERS where year(block_timestamp)=2021

) tx_hashes

) and year(block_timestamp)=2021 and status='SUCCESS'

order by COUNT(DISTINCT TX_HASH) desc

limit 1000;