kasadeghUntitled Query
    Updated 2022-08-10
    with Tornado_Cash_Addresses as
    (
    select * from flipside_prod_db.crosschain.address_labels
    where lower(PROJECT_NAME) like '%tornado%'
    )

    select BLOCKCHAIN,
    TO_ADDRESS,
    ADDRESS_NAME,
    sum(ETH_VALUE) as total_volume
    from ethereum.core.fact_transactions as t1
    join Tornado_Cash_Addresses as t2
    on t1.TO_ADDRESS=t2.ADDRESS
    where t1.BLOCK_TIMESTAMP::date >= DATEADD('day',-30,CURRENT_DATE) and STATUS='SUCCESS'
    group by TO_ADDRESS,ADDRESS_NAME,BLOCKCHAIN
    order by total_volume desc
    limit 10
    Run a query to Download Data