date_trunc('week', block_timestamp) as week,

pool_name,

count(DISTINCT tx_hash) as events,

sum(AMOUNT_IN_USD) as volume

FROM ethereum.core.ez_dex_swaps

WHERE symbol_in LIKE 'SHIB'

or symbol_out LIKE 'SHIB'

GROUP BY 1,2