SELECT

DATE_TRUNC('day', BLOCK_TIMESTAMP) AS Date,

COUNT(DISTINCT SWAPPER) AS swappers

FROM aptos.defi.ez_dex_swaps

WHERE EVENT_ADDRESS = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'

GROUP BY 1

),

tb2 AS (

SELECT

MIN(block_timestamp::date) AS Min_date,

SWAPPER AS new_swappers

FROM aptos.defi.ez_dex_swaps

WHERE EVENT_ADDRESS = '0x48271d39d0b05bd6efca2278f22277d6fcc375504f9839fd73f74ace240861af'

GROUP BY 2

),

tb3 AS (

SELECT

Min_date,

COUNT(DISTINCT new_swappers) AS new_swappers_cnt

FROM tb2

GROUP BY 1

SELECT

a.Date,

new_swappers_cnt AS Total_swappers,

'New Swappers' AS swapper_type

FROM tb1 a

JOIN tb3 b ON a.Date = b.Min_date

UNION ALL

SELECT