Alexaytorn cahs year
    Updated 2022-08-10
    -- tornado cash addresses
    with address as (select address, address_name
    from flipside_prod_db.crosschain.address_labels
    where address_name like '%tornado%cash%' )

    select sum(eth_value) as volume, count(tx_hash) as number_txn, to_address, address_name
    from ethereum.core.fact_transactions
    join address on address.address = ethereum.core.fact_transactions.to_address
    where block_timestamp>=CURRENT_DATE-365 and eth_value>0 and to_address in (select address from address)
    group by to_address, address_name
    having number_txn>1


    Run a query to Download Data