drone-mostafaUntitled Query
    Updated 2022-08-10
    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