superflyUntitled Query
Updated 2022-08-10
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
SYMBOL,
ADDRESS,
COUNT(DISTINCT TX_HASH) as transaction_number,
SUM(AMOUNT) as total_amount,
SUM(AMOUNT_USD) as total_amount_usd
FROM
ethereum.core.ez_token_transfers
JOIN
ethereum.core.dim_labels
ON
ethereum.core.ez_token_transfers.ORIGIN_TO_ADDRESS = ethereum.core.dim_labels.ADDRESS
WHERE ADDRESS_NAME LIKE '%tornado.cash%'
AND ORIGIN_TO_ADDRESS IN
(
lower('0x8589427373D6D84E98730D7795D8f6f8731FDA16')
,lower('0x722122dF12D4e14e13Ac3b6895a86e84145b6967')
,lower('0xDD4c48C0B24039969fC16D1cdF626eaB821d3384')
,lower('0xd90e2f925DA726b50C4Ed8D0Fb90Ad053324F31b')
,lower('0xd96f2B1c14Db8458374d9Aca76E26c3D18364307')
,lower('0x4736dCf1b7A3d580672CcE6E7c65cd5cc9cFBa9D')
,lower('0xD4B88Df4D29F5CedD6857912842cff3b20C8Cfa3')
,lower('0x910Cbd523D972eb0a6f4cAe4618aD62622b39DbF')
,lower('0xA160cdAB225685dA1d56aa342Ad8841c3b53f291')
,lower('0xFD8610d20aA15b7B2E3Be39B396a1bC3516c7144')
,lower('0xF60dD140cFf0706bAE9Cd734Ac3ae76AD9eBC32A')
,lower('0x22aaA7720ddd5388A3c0A3333430953C68f1849b')
,lower('0xBA214C1c1928a32Bffe790263E38B4Af9bFCD659')
,lower('0xb1C8094B234DcE6e03f10a5b673c1d8C69739A00')
,lower('0x527653eA119F3E6a1F5BD18fbF4714081D7B31ce')
,lower('0x58E8dCC13BE9780fC42E8723D8EaD4CF46943dF2')
,lower('0xD691F27f38B395864Ea86CfC7253969B409c362d')
Run a query to Download Data