mboveiriTornado 3
Updated 2022-08-10
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with tor as
(select address , address_name from flipside_prod_db.crosschain.address_labels where address_name ilike '%tornado%eth%')
select
date_trunc(month,block_timestamp::date) as month,
right(address_name, len(address_name) - charindex(':', address_name)) as range,
count(tx_hash) as tx_count
from ethereum.core.fact_transactions left join tor on lower(address) = to_address
--where block_timestamp > current_date - 365
and to_address in (select address from tor)
group by 1,2
Run a query to Download Data