with tab1 as (
SELECT
address,
name
FROM ethereum.core.dim_contracts
WHERE name LIKE '%Tokemak%'
)
SELECT
date_trunc('day', block_timestamp),
name,
SUM(amount_usd)
FROM ethereum.core.ez_token_transfers
LEFT outer JOIN tab1
ON from_address = address
WHERE from_address IN (SELECT address from tab1)
AND block_timestamp > '2022-01-01'
GROUP BY 1,2