with tab1 as (

select

AMOUNT_USD

,TX_HASH

,ORIGIN_FROM_ADDRESS

from arbitrum.core.ez_token_transfers

where ORIGIN_to_ADDRESS='0x7bc8b1b5aba4df3be9f9a32dae501214dc0e4f3f' --tufu nft market

and BLOCK_TIMESTAMP::date>='2023-09-18' and BLOCK_TIMESTAMP::date <'2023-10-02'

and ORIGIN_FUNCTION_SIGNATURE='0xba847759'

),

tab2 as (

select

,TOKENID

,TX_HASH

from arbitrum.nft.ez_nft_transfers

select

,count(distinct tab2.TX_HASH) as txs

,count(distinct TOKENID) as tokens

,count(distinct ORIGIN_FROM_ADDRESS) as buyers

from tab1

left join tab2

on tab1.TX_HASH=tab2.TX_HASH

where PROJECT_NAME is not null

group by 1

order by 2 desc

limit 5