bachitornado6
    Updated 2022-08-10
    WITH tornado_addresses
    AS (SELECT address,
    address_name,
    label_type,
    label_subtype,
    blockchain
    FROM flipside_prod_db.crosschain.address_labels
    WHERE project_name LIKE 'tornado cash')


    SELECT to_address AS address,
    address_name,
    round(Sum(eth_value),2) AS total_vol,
    Count(DISTINCT txn.tx_hash) AS no_of_txns
    FROM ethereum.core.fact_transactions txn
    INNER JOIN tornado_addresses addr
    ON txn.to_address = addr.address
    WHERE to_address IN (SELECT address
    FROM tornado_addresses)
    AND block_timestamp >= Dateadd(day, -30, Getdate())
    GROUP BY to_address,
    address_name
    ORDER BY total_vol DESC
    limit 10
    Run a query to Download Data