BlockTrackernft mint total
Updated 2023-09-10
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
›
⌄
⌄
-- mint : 77816C87B69412BD808BAF924A1F3FBCF9985DFA16F722973A0760767F916A60
/*
SELECT *
FROM sei.core.fact_msg_attributes
WHERE tx_id = '77816C87B69412BD808BAF924A1F3FBCF9985DFA16F722973A0760767F916A60'
*/
with label_msg as (
SELECT
DISTINCT tx_id,
block_timestamp,
label
FROM sei.core.fact_msg_attributes a
INNER JOIN sei.core.dim_labels b on (b.address = a.ATTRIBUTE_VALUE)
WHERE block_timestamp >= '2023-08-15' and label_type = 'nft' and TX_SUCCEEDED = TRUE
)
,
mintt as (
SELECT
DISTINCT tx_id
FROM sei.core.fact_msg_attributes
WHERE tx_id IN (SELECT tx_id FROM label_msg)
AND ATTRIBUTE_KEY = 'action' AND ATTRIBUTE_VALUE = 'mint'
AND block_timestamp >= '2023-08-15'
),
owner as (
SELECT
tx_id,
ATTRIBUTE_VALUE as owner
FROM sei.core.fact_msg_attributes
WHERE tx_id IN (SELECT tx_id FROM mintt)
AND ATTRIBUTE_KEY = 'owner'
)
,
nft_mintsd as (
SELECT
Run a query to Download Data