mboveiriTornado 3
    Updated 2022-08-10
    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