superflyUntitled Query
Updated 2022-08-10Copy Reference Fork
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
›
⌄
SELECT
COUNT(DISTINCT FROM_ADDRESS) as adressessNum
FROM
ethereum.core.fact_transactions
JOIN
ethereum.core.dim_labels
ON
ethereum.core.fact_transactions.TO_ADDRESS = ethereum.core.dim_labels.ADDRESS
WHERE ADDRESS_NAME LIKE '%tornado.cash%'
AND ADDRESS IN
(
lower('0xF60dD140cFf0706bAE9Cd734Ac3ae76AD9eBC32A')
,lower('0x22aaA7720ddd5388A3c0A3333430953C68f1849b')
,lower('0xBA214C1c1928a32Bffe790263E38B4Af9bFCD659')
,lower('0xb1C8094B234DcE6e03f10a5b673c1d8C69739A00')
,lower('0x527653eA119F3E6a1F5BD18fbF4714081D7B31ce')
,lower('0x58E8dCC13BE9780fC42E8723D8EaD4CF46943dF2')
,lower('0xD691F27f38B395864Ea86CfC7253969B409c362d')
,lower('0xaEaaC358560e11f52454D997AAFF2c5731B6f8a6')
,lower('0x1356c899D8C9467C7f71C195612F8A395aBf2f0a')
,lower('0x47CE0C6eD5B0Ce3d3A51fdb1C52DC66a7c3c2936')
,lower('0x23773E65ed146A459791799d01336DB287f25334')
,lower('0xD21be7248e0197Ee08E0c20D4a96DEBdaC3D20Af')
,lower('0x610B717796ad172B316836AC95a2ffad065CeaB4')
,lower('0x178169B423a011fff22B9e3F3abeA13414dDD0F1')
,lower('0xbB93e510BbCD0B7beb5A853875f9eC60275CF498')
,lower('0x2717c5e28cf931547B621a5dddb772Ab6A35B701')
,lower('0x03893a7c7463AE47D46bc7f091665f1893656003')
,lower('0xCa0840578f57fE71599D29375e16783424023357')
,lower('0x8589427373D6D84E98730D7795D8f6f8731FDA16')
,lower('0x722122dF12D4e14e13Ac3b6895a86e84145b6967')
,lower('0xDD4c48C0B24039969fC16D1cdF626eaB821d3384')
,lower('0xd90e2f925DA726b50C4Ed8D0Fb90Ad053324F31b')
Run a query to Download Data