select

date_trunc('month',block_timestamp) as month,

blockchain as chain,

count(distinct(trader)) as n_traders

from crosschain.defi.ez_dex_swaps

where block_timestamp > current_date - 365

group by 1,2

order by 2,1

),

sei as (

SELECT

date_trunc('month',block_timestamp) as month,

'sei' as chain,

count(distinct(swapper)) as n_traders

from sei.defi.fact_dex_swaps

where block_timestamp > current_date - 365

group by 1,2

order by 1

),

aptos as (

with swapTxs as (

SELECT

distinct tx_hash,

block_timestamp,

coalesce(label,'unknown dex') as protocol

FROM aptos.core.fact_events events

left join aptos.core.dim_labels labs

on events.event_address = labs.address

WHERE --event_address = '0x190d44266241744264b964a37b8f09863167a12d3e70cda39376cfb4e3561e12'

event_resource ilike 'swap%'

and block_timestamp > current_date - 365

)

SELECT

date_trunc('month',block_timestamp) as month,

'aptos' as chain,