block_timestamp, token_id

from ethereum.nft_events

where contract_address in ('0x059edd72cd353df5106d2b9cc5ab83a52287ac3a', '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270')

and event_type = 'mint'),

project as (select

token_metadata:collection_name::string as Project, token_id

from ethereum.nft_metadata

where contract_address in ('0x059edd72cd353df5106d2b9cc5ab83a52287ac3a', '0xa7d8d9ef8d8ce8992df33d8b8cf4aebabd5bd270')

group by 1,2)

select min(datediff(day, A.block_timestamp, CURRENT_DATE)) as Days_Live, B.project

from vol A

join project B on A.token_id = B.token_id

group by 2

order by 1 desc

limit 25