(

SELECT trunc(block_timestamp, 'day') as date,COUNT(DISTINCT tx_id) as total_swaps,platform

FROM ethereum.dex_swaps

WHERE platform IN ('uniswap-v3') AND date >= CURRENT_DATE - 90

GROUP BY 1,3

ORDER BY 1 DESC

UNION ALL

SELECT trunc(block_timestamp, 'day') as date,COUNT(DISTINCT tx_id) as total_swaps,platform

FROM ethereum.dex_swaps

WHERE platform IN ('uniswap-v2') AND date >= CURRENT_DATE - 90

GROUP BY 1,3

ORDER BY 1 DESC