select min(BLOCK_TIMESTAMP::date) as date

,ORIGIN_FROM_ADDRESS

,ORIGIN_TO_ADDRESS

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS=lower('0x912ce59144191c1204e64559fe8253a0e49e6548')

and SYMBOL='ARB'

group by 2,3),

tab2 as (

select ADDRESS

,PROJECT_NAME

from crosschain.core.address_labels

where LABEL_TYPE='dex')

select

date

,PROJECT_NAME

,count(distinct ORIGIN_FROM_ADDRESS) as new_swappers

from tab1

left join tab2

on tab1.ORIGIN_TO_ADDRESS=tab2.ADDRESS

where PROJECT_NAME is not null

group by 1,2