UNIQUE_MINTERS | NUMBER_OF_MINTS | NFT_CATEGORY | COLLECTION | |
|---|---|---|---|---|
1 | 152 | 7157 | Drill_Club | Drill Club |
2 | 400 | 496 | Seiyans | Seiyans |
bobby_daniel2 NFT big metrics
Updated 2025-04-02
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
26
27
28
29
›
⌄
SELECT -- Number of mints -- Number of minters
count(distinct origin_from_address) as unique_minters,
count (*) as number_of_mints,
'Seiyans' as nft_category,
case when origin_to_address = lower('{{Seiyans}}') then 'Seiyans'
when origin_to_address = '{{Drill_Club}}' then 'Drill Club'
end as Collection
-- concat('nft 1: ', Collection ) as Collection
FROM sei.core_evm.fact_event_logs
WHERE block_timestamp >= '2025-01-01'
AND origin_to_address= lower('{{Seiyans}}') and tx_status='SUCCESS'
group by 3,4
Union all
SELECT
count(distinct origin_from_address) as unique_minters,
count (*) as number_of_mints,
'Drill_Club' as nft_category,
case when origin_to_address = '{{Seiyans}}' then 'Seiyans'
when origin_to_address = '{{Drill_Club}}' then 'Drill Club'
end as Collection
-- concat('nft 2: ', Collection ) as Collection
FROM sei.core_evm.fact_event_logs
WHERE block_timestamp >= '2025-01-01'
AND origin_to_address='{{Drill_Club}}' and tx_status='SUCCESS'
group by 3,4
Order by number_of_mints desc
Last run: about 2 months ago
2
68B
2s