, 'Uniswap' AS platform

, COUNT(DISTINCT from_address) AS users

FROM optimism.core.fact_transactions

WHERE to_address in (lower('0xE592427A0AEce92De3Edee1F18E0157C05861564'),'0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45')

AND status = 'SUCCESS'

AND block_timestamp >= CURRENT_DATE-30

GROUP BY 1, 2

UNION ALL

SELECT DATE_TRUNC('DAY', block_timestamp) AS date

, '1inch' AS platform

, COUNT(DISTINCT from_address) AS swaps

FROM optimism.core.fact_transactions

WHERE to_address ilike '0x1111111254760F7ab3F16433eea9304126DCd199'

AND status = 'SUCCESS'

AND block_timestamp >= CURRENT_DATE-30

GROUP BY 1, 2

UNION ALL

SELECT DATE_TRUNC('DAY', block_timestamp) AS date

, 'Sushiswap' AS platform

, COUNT(DISTINCT origin_from_address) AS users

FROM optimism.sushi.ez_swaps

WHERE block_timestamp >= CURRENT_DATE-30

GROUP BY 1, 2

UNION ALL

SELECT DATE_TRUNC('DAY', block_timestamp) AS date

,'Velodrome' AS origin_from_address

, COUNT(DISTINCT origin_from_address) AS swaps

FROM optimism.velodrome.ez_swaps

WHERE block_timestamp >= CURRENT_DATE-30

GROUP BY 1, 2