mehrancrypto-dxoepqUntitled Query
    Updated 2024-04-05
    with tx1 as (select address , ADDRESS_NAME
    from ethereum.core.dim_labels
    where label = 'tornado cash'
    )
    , tx2 as (
    SELECT
    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-08-08'
    GROUP by 1
    order by 2 DESC
    limit 10
    )
    , tx3 as(
    SELECT
    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
    GROUP by 1
    order by 2 DESC
    limit 10

    )
    SELECT wallets , number , 'After sanction' as type
    from tx2 A
    UNION
    sELECT wallets , number , 'Before sanction' as type
    from tx3 A
    QueryRunArchived: QueryRun has been archived