select

address,

address_name,

label_subtype

from

ethereum.core.dim_labels

where

label like '%tornado cash%'

), transactions as (

select

date(block_timestamp) as day,

to_address,

eth_value

from

ethereum.core.fact_transactions

where

from_address in (select address from addresses)

-- and

-- block_timestamp > CURRENT_DATE-30 and block_timestamp<CURRENT_DATE

select * from transactions