-- forked from Copy of Copy of Tornado Cash on Arbitrum and Avalanche 37 @ https://flipsidecrypto.xyz/edit/queries/cca217cd-1b55-455b-9063-d5edb0e00f80
with contracts as (
SELECT
address,
address_name
FROM flipside_prod_db.crosschain.address_labels
WHERE project_name LIKE 'tornado cash'
)
SELECT
date_trunc(day, block_timestamp) as day,
address_name,
count(*) as transactions,
count(DISTINCT origin_from_address) as users,
sum(amount) as MATIC_volume
FROM polygon.core.ez_matic_transfers
LEFT outer JOIN contracts
ON address = matic_to_address
WHERE matic_to_address IN (SELECT address FROM contracts )
AND (address_name LIKE '%MATIC%' or address_name LIKE '%matic%')
AND block_timestamp > '2022-06-04'
GROUP BY 1,2