mehrancrypto-dxoepqUntitled Query
    Updated 2024-04-05
    with tx1 as (select address , ADDRESS_NAME
    from ethereum.core.dim_labels
    where label = 'tornado cash'
    )
    SELECT
    case
    when block_timestamp::date <'2022-08-08' then 'Before sanction'
    when block_timestamp::date >='2022-08-08' then 'After sanction' 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 >='2022-01-01'
    GROUP by 1




    QueryRunArchived: QueryRun has been archived