-- USDC-USDT univ3 & curve
SELECT
date_trunc('day',block_timestamp) as block_day,
platform,
count(DISTINCT(from_address)) as Users,
SUM(amount_usd) as Volume
FROM ethereum.dex_swaps
WHERE
pool_name like '%USDC%' AND
pool_name like '%DAI%' AND
block_day >= '2021-11-13' AND
platform = 'curve'
GROUP BY block_day,platform
ORDER BY block_day