address,

address_name,

project_name

from polygon.core.dim_labels

where LABEL_TYPE='nft'

and (label_subtype = 'token_contract' or label_subtype = 'general_contract')

),

seller as (

SELECT

from_address,

sum( AMOUNT_USD) as amount

from flipside_prod_db.polygon.udm_events a

join polygon_nft n on a.contract_address = n.address

where EVENT_NAME='transfer'

and AMOUNT_USD>0

group by 1

order by 1 desc

buyer as (select

to_address,

sum( AMOUNT_USD) as amount

from flipside_prod_db.polygon.udm_events a

join polygon_nft n on a.contract_address = n.address

where EVENT_NAME='transfer'

and AMOUNT_USD>0

group by 1

order by 1

)

select