Cipher009-CpUJ5kNumber of unique wallets that interacted with Tornado Cash
    -- forked from mehrancrypto-dxoepq / Untitled Query @ https://flipsidecrypto.xyz/mehrancrypto-dxoepq/q/syZ5DM1MOsHg/untitled-query

    with tx1 as (select address , ADDRESS_NAME
    from ethereum.core.dim_labels
    where label = 'tornado cash'
    )
    SELECT block_timestamp::date as daily ,
    case
    when daily <'2023-06-11' then 'Before event'
    when daily >='2023-06-29' then 'After event' end as type ,
    count(DISTINCT ORIGIN_FROM_ADDRESS) as wallets , count(tx_hash) as number
    from tx1 A , ethereum.core.fact_event_logs B
    where address = B.origin_TO_ADDRESS
    and B.block_timestamp >='2023-06-01'
    GROUP by 1 , 2