sinahosseinzadehUntitled Query
    Updated 2022-08-10
    WITH TORNADO_CASH_ADDRESSES AS (
    SELECT ADDRESS_NAME, ADDRESS
    FROM flipside_prod_db.crosschain.address_labels
    WHERE PROJECT_NAME='tornado cash'
    )
    SELECT DATE_TRUNC('DAY', BLOCK_TIMESTAMP) AS DAY, COUNT(DISTINCT(TX_HASH)) AS TRANS_COUNT
    FROM ethereum.core.fact_transactions
    WHERE TO_ADDRESS IN (SELECT ADDRESS FROM TORNADO_CASH_ADDRESSES)
    AND BLOCK_TIMESTAMP::DATE > CURRENT_DATE - 360
    GROUP BY DAY
    ORDER BY TRANS_COUNT DESC
    Run a query to Download Data