nitsLast x days most value in $ transferring addresses
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
›
⌄
with addr as
(SELECT address as ad, address_name as name from crosschain.address_labels
where address_name ilike '%tornado%eth%' and project_name = 'tornado cash'
),
senders as
(SELECT tx_hash as tx, origin_from_address as sender from ethereum.core.fact_event_logs
where contract_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b' and event_name = 'EncryptedNote' and
date(block_timestamp) >= CURRENT_DATE -{{last_days}}
GROUP by 1,2)
SELECT sender,sum(amount_usd) as total_amt from
(SELECT block_timestamp, tx_hash, amount, amount_usd from ethereum.core.ez_eth_transfers
where tx_hash in
(SELECT tx_hash from ethereum.core.fact_event_logs
where contract_address = '0xd90e2f925da726b50c4ed8d0fb90ad053324f31b' and event_name = 'EncryptedNote' and
date(block_timestamp) >= CURRENT_DATE -{{last_days}} )
GROUP by 1,2,3,4 )
inner join senders
on tx=tx_hash
GROUP by 1
order by 2 desc
limit 10
Run a query to Download Data