0-MIDMost Expensive Traded NFT
Updated 2023-11-20
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
›
⌄
with tab1 as (
select NFT_ID
,max(PRICE) as ceiling
from flow.nft.ez_nft_sales
where NFT_COLLECTION='A.87ca73a41bb50ad5.Golazos'
and CURRENCY='A.ead892083b3e2c6c.DapperUtilityCoin'
and TX_SUCCEEDED='true'
and date_trunc('week',BLOCK_TIMESTAMP)>='2023-01-01'
group by 1
order by 2 desc
limit 1),
tab2 as (
select *
from flow.nft.dim_moment_metadata
where NFT_COLLECTION='A.87ca73a41bb50ad5.Golazos'
)
select tab2.*
from tab1
left join tab2
on tab1.NFT_ID=tab2.NFT_ID
Run a query to Download Data