drone-mostafaUntitled Query
Updated 2022-08-10
9
1
2
3
4
5
6
7
8
9
›
⌄
with Tornado as ( select address, address_name
from flipside_prod_db.crosschain.address_labels where project_name like 'tornado cash' and blockchain like 'ethereum' )
select date_trunc('day', block_timestamp) as Time, address_name, count(*) as TXN
from ethereum.core.fact_transactions left outer join Tornado on to_address = address where block_timestamp > current_date - interval'1 months' and to_address in (select address from Tornado) group by Time,address_name
Run a query to Download Data