kasadeghUntitled Query
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
with Tornado_Cash_Addresses as
(
select * from flipside_prod_db.crosschain.address_labels
where lower(PROJECT_NAME) like '%tornado%'
)
select BLOCKCHAIN,
TO_ADDRESS,
ADDRESS_NAME,
sum(ETH_VALUE) as total_volume
from ethereum.core.fact_transactions as t1
join Tornado_Cash_Addresses as t2
on t1.TO_ADDRESS=t2.ADDRESS
where t1.BLOCK_TIMESTAMP::date >= DATEADD('day',-30,CURRENT_DATE) and STATUS='SUCCESS'
group by TO_ADDRESS,ADDRESS_NAME,BLOCKCHAIN
order by total_volume desc
limit 10
Run a query to Download Data