SELECT

address,

address_name

FROM ethereum.core.dim_labels

WHERE label LIKE 'tornado cash'

SELECT

count(DISTINCT tx_hash) as txn,

count(DISTINCT origin_from_address) as users

FROM ethereum.core.fact_event_logs

LEFT outer JOIN wallets

ON contract_address = wallets.address

WHERE contract_address in (SELECT address FROM wallets)

AND block_timestamp > '2022-08-08'