jackguyTornado Cash 6
Updated 2023-11-26
999
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
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'
), tab1 as (
SELECT
users,
min(week) as week
FROM (
SELECT
date_trunc('day', block_timestamp) as week,
'Ethereum' as chain,
SYMBOL as token,
tx_hash as txn,
AMOUNT AS volume,
ORIGIN_FROM_ADDRESS as users
FROM ethereum.core.ez_token_transfers
WHERE to_address in (SELECT address from wallets1)
Run a query to Download Data