-- FROM ethereum.core.fact_event_logs l INNER JOIN ethereum.core.ez_dex_swaps s ON l.tx_hash = s.tx_hash

-- WHERE l.contract_address = '0x881d40237659c251811cec9c364ef91dc08d300c'

-- GROUP BY 1, 2

SELECT l.block_timestamp::date as date, s.PLATFORM, SUM(s.amount_usd) as swap_volume, COUNT(DISTINCT l.tx_hash) as num_tx

FROM ethereum.core.fact_event_logs l INNER JOIN flipside_prod_db.ethereum.dex_swaps s ON l.tx_hash = s.tx_id

WHERE l.contract_address = '0x881d40237659c251811cec9c364ef91dc08d300c' and amount_usd < 1e8

GROUP BY 1, 2