SELECT

address,

address_name

FROM flipside_prod_db.crosschain.address_labels

WHERE project_name LIKE 'tornado cash'

AND address_name LIKE '%eth'

AND blockchain LIKE 'ethereum'

SELECT

date_trunc('day', block_timestamp) as day,

address_name,

sum(amount_usd) as volume,

FROM ethereum.core.ez_eth_transfers

LEFT outer JOIN contracts

ON address = eth_from_address

WHERE eth_from_address IN (SELECT address from contracts)

AND block_timestamp BETWEEN CURRENT_DATE - {{min_age_day}} AND CURRENT_DATE - {{max_age_day}}

GROUP BY 1,2

HAVING NOT address_name is NULL