Top Holders NFT Collections

freemartianTop Holders NFT Collections

Updated 53 seconds ago

-- with sapes_api as (

-- SELECT

-- livequery.live.udf_api(

-- 'https://raw.githubusercontent.com/mehdimarjan/Opensea/refs/heads/main/sale.json'

-- ) AS response

-- ),

-- datas AS(

-- SELECT

-- to_timestamp(value:closing_date) AS block_timestamp,

-- value:transaction AS tx_hash,

-- value:event_type AS event,

-- value:protocol_address AS protocol_address,

-- value:nft:identifier AS identifier,

-- value:nft:collection AS collection,

-- value:chain AS chain,

-- value:buyer AS buyer,

-- value:seller AS seller,

-- (value:payment:quantity) / pow(10, 18) AS price,

-- -- ROUND(((value:payment:quantity) / pow(10,18)),8) AS price,

-- value:quantity AS qty

-- FROM

-- sapes_api,

-- LATERAL FLATTEN (input => response:data)

-- GROUP BY

-- ALL

-- ORDER BY

-- 1 DESC

-- ),

-- sellers AS(

-- SELECT

-- seller AS seller,

-- count(tx_hash) AS transactions,

-- -- count(DISTINCT seller) AS seller,

-- -- count(DISTINCT buyer) AS buyer,

-- SUM(price) AS eth_value,

-- SUM(qty) AS quantity

Last run: 1 minute agoAuto-refreshes every 1 hour

	USER_ADDRESS	COLLECTION	Collection NFTs	Kaito NFTs
1	0xe5e83c2347be43eb917715c7385ae2a2cf95453c	kaito-genesis	57	57
2	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	the-dooplicator	68	30
3	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	space-doodles-official	41	30
4	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	memelandpotatoz	36	30
5	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	kaito-genesis	30	30
6	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	gemesis	20	30
7	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	skyborne-genesisimmortals	2	30
8	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	memelandmvp	1	30
9	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	nexusnodes	1	30
10	0x66362b929c1a9aaf14c51aab9b455ad7fb8268c4	pudgypenguins	1	30
11	0x7decd0770371096f135547bdbdf3831799239ccf	kaito-genesis	26	26
12	0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9	kaito-genesis	25	25
13	0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9	milady	1	25
14	0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9	meebits	1	25
15	0x1ad69b711ba2f8eebb8ac8ecaf8af874e48daad9	azuki	1	25
16	0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4	ultiverse-electric-sheep	45	25
17	0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4	kaito-genesis	25	25
18	0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4	bodegacatceo-editions	8	25
19	0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4	renga	5	25
20	0xc4da1707a7a16cf4ac15d75d6a49a684b23ee1e4	es0rigin	4	25

...

1091

74KB

38s

flipside