select * from flipside_prod_db.crosschain.address_labels

where address_name ilike '%tornado%')

select contract_address, address_name, count(tx_hash), date_trunc('day', block_timestamp::date) as TIME

from ethereum.core.fact_event_logs l

left join tornado_addresses t on t.address = l.contract_address

where origin_to_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b'

and contract_address not in ( -- excluded some token contract addresses, fee manager, router, etc

'0xd90e2f925da726b50c4ed8d0fb90ad053324f31b',

'0x58e8dcc13be9780fc42e8723d8ead4cf46943df2',

'0x6b175474e89094c44da98b954eedeac495271d0f',

'0xdac17f958d2ee523a2206206994597c13d831ec7',

'0xa0b86991c6218b36c1d19d4a2e9eb0ce3606eb48',

'0x2260fac5e5542a773aa44fbcfedf7c193bc2c599',

'0x1522900b6dafac587d499a862861c0869be6e428',

'0x239150ca03b2bd1af76d8747c834e55866a6db97',

'0x5f6c97c6ad7bdd0ae7e0dd4ca33a4ed3fdabd4d7')

and block_timestamp >= '2022-07-30'

and block_timestamp <= CURRENT_DATE

group by contract_address, address_name, TIME

order by 3 DESC