select ORIGIN_FROM_ADDRESS

from avalanche.core.ez_token_transfers

where ORIGIN_TO_ADDRESS='0xb866b661db0b1b0f39ed28fc59c77d60983dccbb'

and CONTRACT_ADDRESS=lower('0x31c994AC062C1970C086260Bc61babB708643fAc')

),

tab2 as (

select

ORIGIN_FROM_ADDRESS

,ORIGIN_TO_ADDRESS

,AMOUNT_USD

,FROM_ADDRESS

,TO_ADDRESS

,TX_HASH

from avalanche.core.ez_token_transfers

where CONTRACT_ADDRESS=lower('0x31c994AC062C1970C086260Bc61babB708643fAc')

),

tab3 as (

select ADDRESS

,ADDRESS_NAME

,LABEL_TYPE

,PROJECT_NAME

from avalanche.core.dim_labels

where LABEL_TYPE<>'token')

,tab4 as (

select

,PROJECT_NAME

,sum(AMOUNT_USD) as volume

from tab2

left join tab3

on tab2.ORIGIN_TO_ADDRESS=tab3.ADDRESS

where TO_ADDRESS in (select ORIGIN_FROM_ADDRESS from tab1)

and LABEL_TYPE is not null

group by 1,2),

tab5 as (