GROUP_TYPE | MINTS | DISTINCT_NFT_MINTED | MINTERS | SEI_VOLUME | AVG_NFT_PRICE | MAX_NFT_PRICE | LAUNCHPADS | |
|---|---|---|---|---|---|---|---|---|
1 | Public | 1126 | 3069 | 1096 | 0 | 0 | 0 | 1 |
omer93SeiFuckers mints
Updated 2025-04-08
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
30
31
32
33
34
35
36
›
⌄
with
info as (
SELECT
tx_id, count(distinct CASE WHEN msg_type = 'wasm' AND attribute_key = 'token_id' THEN attribute_value END) AS nft_id,
MAX(CASE WHEN msg_type = 'wasm' AND attribute_key = 'owner' THEN attribute_value END) AS minter,
MAX(CASE WHEN msg_type = 'wasm' AND attribute_key = 'price' THEN attribute_value/pow(10,6) END) AS sei_price,
MAX(CASE WHEN msg_type = 'wasm' AND attribute_key = 'group' THEN attribute_value END) AS group_type,
MAX(CASE WHEN msg_type = 'wasm' AND attribute_key = 'minter' THEN attribute_value END) AS launchpad,
MAX(CASE WHEN msg_type = 'wasm' AND attribute_key = 'collection' THEN attribute_value END) AS collection,
MAX(CASE WHEN msg_type = 'wasm' AND attribute_key = 'action' THEN attribute_value END) AS action
FROM
sei.core.fact_msg_attributes
where block_timestamp>'2024-02-28 01:00' and block_timestamp<'2024-03-10'
GROUP BY
tx_id
having collection='sei1lqsrwexmpve6ltu8pga8ss0jzvgx9r88n6ys9fedjk6dqny72h3q7myv5d'
and action ='mint'
)
select
group_type,
count(distinct tx_id) as mints,
sum(nft_id) as distinct_nft_minted,
count(distinct minter) as minters,
sum(sei_price) as sei_volume,
avg(sei_price) as avg_nft_price,
max(sei_price) as max_nft_price,
count(distinct launchpad) as launchpads
from info
group by 1 order by 2 desc
Last run: 17 days ago
1
35B
76s