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

    select
    distinct ORIGIN_FROM_ADDRESS as interactors,
    count(distinct a.tx_hash) as total_trnasactions,
    sum(b.ETH_VALUE) as ETH_worth

    from ethereum.core.fact_event_logs a join ethereum.core.fact_transactions b on a.tx_hash=b.tx_hash
    where CONTRACT_ADDRESS in (select ADDRESS from tornado)
    and a.BLOCK_TIMESTAMP<'2022-08-08' and a.BLOCK_TIMESTAMP>=CURRENT_DATE-365
    group by 1
    order by 2 desc
    limit 10


    Run a query to Download Data