user_addresses as

select

a.nft_to_address as user_addresses

from

avalanche.nft.ez_nft_transfers a

where

a.nft_address = '0xce4fee23ab35d0d9a4b6b644881ddd8adebeb300'

group by 1

,

min_datetimestamp as

select

min( a.block_timestamp ) as min_date ,

a.from_address as from_addresses

from

avalanche.core.fact_transactions a

right join

user_addresses b

on a.from_address = b.user_addresses

group by 2

order by 1 desc

,

max_datetimestamp as

select

a.from_address as from_addresses ,

b.min_date as min_date ,

max( a.block_timestamp ) as max_date

from

avalanche.core.fact_transactions a

right join