primo_dataTornado Cash Sanctions_UserCts
Updated 2022-08-10
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
›
⌄
⌄
/*Tornado Cash is in the news due to the sanctions imposed by the US government and the freezing of $75K of USDC from Circle.
The addresses tied to the service have been publicly posted online. (Hint: we also have them in our crosschain address labels table as well).
What is Tornado Cash and why would it be targeted by the US government? Why might an address interact with the service?
The addresses tied to the service have been publicly posted online. Using those addresses answer the following:
How many addresses are still using the service despite the sanctions?
Which addresses have been interacting the most with Tornado Cash?
Break the addresses down by frequency and volume of tokens and describe how the groups are using the service differently.
Is there anything else interesting about its users?*/
with tornado_addr as
(
select address, replace(address_name, 'tornado.cash', 't.c') address_name
FROM flipside_prod_db.crosschain.address_labels
where address_name ilike '%tornado%'
and blockchain = 'ethereum'
and label_subtype = 'general_contract'
and address != '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b' -- router address
and address != '0x722122df12d4e14e13ac3b6895a86e84145b6967' -- router address
),
eth_usd as (
SELECT date(hour) as dt, avg(price) as eth_price
from flipside_prod_db.ethereum_core.fact_hourly_token_prices
where symbol='WETH'
and dt >= date('2022-01-01')
GROUP BY 1
),
non_eth_transfers as (
select
date(block_timestamp) dt
, row_number() over(partition by tx_hash order by amount_usd desc) rn
, ta.address tornado_address
, ta.address_name tornado_address_name
, to_address
Run a query to Download Data