MLDZMNcash.sn8
    Updated 2022-08-10
    with tornado as (select
    ADDRESS
    from flipside_prod_db.crosschain.address_labels where PROJECT_NAME= 'tornado cash'
    ),

    total as (select
    a.ORIGIN_FROM_ADDRESS as interactors,
    count(distinct a.tx_hash) as total_trnasactions,
    sum(AMOUNT_USD) as currency_usage


    from ethereum.core.fact_event_logs a join ethereum.core.ez_token_transfers b on a.tx_hash=b.tx_hash
    where a.CONTRACT_ADDRESS in (select ADDRESS from tornado)
    and a.BLOCK_TIMESTAMP>=CURRENT_DATE-30
    group by 1
    )


    select
    case when total_trnasactions<2 then '1 transaction'
    when total_trnasactions between 2 and 5 then '2-5 transactions'
    when total_trnasactions between 5 and 10 then '5-10 transactions'
    when total_trnasactions between 10 and 20 then '10-20 transactions'
    when total_trnasactions>=20 then 'Above 20 transactions'
    end as gp,
    count(distinct interactors) as wallets
    from total
    group by gp having gp is not null
    Run a query to Download Data