AnalyticSagesMost Traded Collections
Updated 2024-04-22
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
-- forked from mar1na-catscatscode / Most Traded Collections @ https://flipsidecrypto.xyz/mar1na-catscatscode/q/SD6h9A9QaWPR/most-traded-collections
-- forked from mo115 / o @ https://flipsidecrypto.xyz/mo115/q/BvKteqvdURt_/o
-- forked from i-m copy @ https://flipsidecrypto.xyz/edit/queries/8aab16c8-8bce-4c5a-8d1d-d6c66ef6d910
-- forked from i-m @ https://flipsidecrypto.xyz/edit/queries/4f40dcc0-dedb-40f1-a39d-199b402b2ff4
select
NFT_COLLECTION_NAME as "Collection",
count (distinct TX_ID) as Sales,
count (distinct PURCHASER) as Buyers,
count (distinct SELLER) as Sellers,
count (distinct s.mint) as "Traded NFTs",
sum(SALES_AMOUNT) as Volume
from
solana.nft.fact_nft_sales s
left join solana.nft.dim_nft_metadata d on s.mint = d.mint
where
BLOCK_TIMESTAMP >= current_date -30
and SUCCEEDED = 'TRUE'
and NFT_COLLECTION_NAME is not null
group by
1
order by
SALES DESC
QueryRunArchived: QueryRun has been archived