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