MLDZMNNFT 1
Updated 2024-04-29
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
-- What are the popular collection that are being traded on the blockchain in the past 30 days?
select
PROJECT_NAME as Collection,
round(sum(price_usd), 2) as "Volume USD",
from
ethereum.nft.ez_nft_sales
where
PROJECT_NAME is not null
and Block_timestamp >= current_date - 30
group by
Collection
order by
"Volume USD" desc
limit
10
QueryRunArchived: QueryRun has been archived