Top 25 Collection

HadisehTop 25 Collection

Updated 2025-01-26

WITH transaction_summary AS (

SELECT

TX_ID AS transaction_id,

SPLIT(EVENT_DATA:nftType, '.')[2] AS nft_collection,

EVENT_DATA:nftID AS token_id,

BLOCK_TIMESTAMP AS event_timestamp,

-- Determine buyer based on contract and event type

CASE

WHEN EVENT_CONTRACT = 'A.3cdbb3d569211ff3.NFTStorefrontV2'

AND EVENT_TYPE = 'ListingCompleted'

THEN EVENT_DATA:buyer::string

WHEN EVENT_CONTRACT = 'A.b8ea91944fd51c43.OffersV2'

AND EVENT_TYPE = 'OfferCompleted'

THEN EVENT_DATA:offerAddress::string

END AS buyer,

-- Determine seller based on contract and event type

CASE

WHEN EVENT_CONTRACT = 'A.3cdbb3d569211ff3.NFTStorefrontV2'

AND EVENT_TYPE = 'ListingCompleted'

THEN EVENT_DATA:storefrontAddress::string

WHEN EVENT_CONTRACT = 'A.b8ea91944fd51c43.OffersV2'

AND EVENT_TYPE = 'OfferCompleted'

THEN EVENT_DATA:acceptingAddress::string

END AS seller,

-- Determine sale price or offer amount

CASE

WHEN EVENT_CONTRACT = 'A.3cdbb3d569211ff3.NFTStorefrontV2'

AND EVENT_TYPE = 'ListingCompleted'

THEN CAST(EVENT_DATA:salePrice AS FLOAT)

WHEN EVENT_CONTRACT = 'A.b8ea91944fd51c43.OffersV2'

AND EVENT_TYPE = 'OfferCompleted'

THEN CAST(EVENT_DATA:offerAmount AS FLOAT)

END AS sale_value

Last run: about 2 months ago

	COLLECTION	TOTAL_SALES	TOTAL_BUYERS	TOTAL_SELLERS	UNIQUE_NFTS	TOTAL_VOLUME
1	TopShot	575373	3742	3260	481444	3595638.763178
2	AllDay	230257	4504	4637	202994	1402462.195
3	Golazos	2821	170	298	1260	122507.289
4	JollyJokers	1368	747	400	850	117859.2
5	MetadataViews	3074	277	350	0	96333.1
6	UFC_NFT	16873	711	798	12405	86055.9295
7	Gaia	704	91	137	492	66195.71
8	MFLPack	1068	107	205	850	63607.68
9	FlowRewards	1515	1478	1472	44	30612.46
10	SoulMadeMain	185	71	85	57	29824.389
11	MatrixWorldVoucher	22	7	12	22	25023
12	TFCItems	255	152	141	54	15713.482
13	SoulMadeComponent	236	113	107	77	12623.7
14	MFLClub	253	118	123	7	8927.73
15	SturdyItems	98	47	48	80	8433.38
16	DimensionX	986	94	101	459	4268.544
17	Genies	456	55	47	429	3814.98
18	Flovatar	21	20	14	20	3468.5
19	MFLPlayer	434	88	90	423	3150.99
20	aiSportsMinter	269	57	83	262	2380.9

966B

110s

flipside