jackguyTornado Cash 2 copy
Updated 2023-11-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- forked from Tornado Cash 2 @ https://flipsidecrypto.xyz/edit/queries/c28bc9c1-9b1b-4004-a18b-06b76374093f
-- forked from Tornado Cash 1 @ https://flipsidecrypto.xyz/edit/queries/7ff1b61c-61e3-4daa-a5c7-43054ebe7b7e
with wallets1 as (
SELECT
address,
address_name
FROM ethereum.core.dim_labels
WHERE label LIKE 'tornado cash'
), wallets2 AS (
SELECT
address,
address_name
FROM bsc.core.dim_labels
WHERE PROJECT_NAME LIKE 'tornado cash'
), wallets3 AS (
SELECT
address,
address_name
FROM avalanche.core.dim_labels
WHERE PROJECT_NAME LIKE 'tornado cash'
)
SELECT
-- chain,
count(DISTINCT users) as users,
sum(volume * price) as volume_usd
FROM (
SELECT
date_trunc('day', block_timestamp) as week,
'Ethereum' as chain,
'ETH' as token,
tx_hash as txn,
AMOUNT AS volume,
Run a query to Download Data