jackguyTornado Cash on Arbitrum, Optimism, and Avalanche
    Updated 2022-08-16
    with contracts as (
    SELECT
    address,
    address_name
    FROM flipside_prod_db.crosschain.address_labels
    WHERE project_name LIKE 'tornado cash'
    -- AND blockchain LIKE 'avalanche'
    )
    SELECT
    date_trunc(day, block_timestamp) as day1,
    count(*) as transactions1,
    count(DISTINCT origin_from_address) as users1,
    sum(amount) as volume1
    FROM polygon.core.ez_matic_transfers
    LEFT outer JOIN contracts
    ON address = matic_to_address
    WHERE eth_to_address IN (SELECT address FROM contracts )
    GROUP BY 1



    Run a query to Download Data