with tab1 as (

select ADDRESS

,PROJECT_NAME

from arbitrum.core.dim_labels

where LABEL_TYPE='dex')

,tab2 as (

select date_trunc('minute',BLOCK_TIMESTAMP)as time

,AMOUNT

,FROM_ADDRESS

,ORIGIN_FROM_ADDRESS

,ORIGIN_TO_ADDRESS

,TO_ADDRESS

,TX_HASH

from arbitrum.core.ez_token_transfers

where CONTRACT_ADDRESS in (lower('0xaf88d065e77c8cC2239327C5EDb3A432268e5831'),lower('0xFF970A61A04b1cA14834A43f5dE4533eBDDB5CC8'))

and ORIGIN_FROM_ADDRESS=TO_ADDRESS)

select date_trunc('month',time)as month

,'ARBITRUM' as chain

,ORIGIN_FROM_ADDRESS

,AMOUNT

,row_number()over(partition by ORIGIN_FROM_ADDRESS order by month) as time_row

from tab1

left join tab2

on tab1.ADDRESS=tab2.ORIGIN_TO_ADDRESS

where month is not null),

act2 as (

with tab1 as (

select ADDRESS

,PROJECT_NAME

from avalanche.core.dim_labels

where LABEL_TYPE='dex')

,tab2 as (

select date_trunc('minute',BLOCK_TIMESTAMP)as time

,AMOUNT