mo115FrensClub Holders
Updated 2024-04-28
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
with fcv as (select PROJECT_NAME
, TOKENID
, (BLOCK_TIMESTAMP) as date
, NFT_TO_ADDRESS
, row_number() over (partition by TOKENID order by date ASC) as row_number
from base.nft.ez_nft_transfers
where NFT_ADDRESS = lower ( '0xd186C9274348CC2201957dE33a256E607B4976A5' )
group by 1,2,3,4)
select *
from FCV
where row_number = 1
QueryRunArchived: QueryRun has been archived