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

    select
    ADDRESS_NAME as Cash_address,
    count(tx_hash) as transaction_count,
    count(distinct FROM_ADDRESS) as interactors,
    sum(ETH_VALUE) as ETH_worth

    from ethereum.core.fact_transactions a
    join flipside_prod_db.crosschain.address_labels b on a.TO_ADDRESS=b.address
    where a.TO_ADDRESS in (select ADDRESS from tornado)
    and BLOCK_TIMESTAMP>=CURRENT_DATE-120 -- stand for the last quarter
    group by 1
    order by 2 desc

    Run a query to Download Data