Alexaytorn cahs year
Updated 2022-08-10Copy Reference Fork
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
-- tornado cash addresses
with address as (select address, address_name
from flipside_prod_db.crosschain.address_labels
where address_name like '%tornado%cash%' )
select sum(eth_value) as volume, count(tx_hash) as number_txn, to_address, address_name
from ethereum.core.fact_transactions
join address on address.address = ethereum.core.fact_transactions.to_address
where block_timestamp>=CURRENT_DATE-365 and eth_value>0 and to_address in (select address from address)
group by to_address, address_name
having number_txn>1
Run a query to Download Data