sinahosseinzadehUntitled Query
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
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