TX_ID | BLOCK_TIMESTAMP | BLOCK_HEIGHT | MOMENT_ID | PLAY_ID | SET_ID | SERIAL_NUMBER | SUBEDITION_ID | EDITION_ID | |
|---|---|---|---|---|---|---|---|---|---|
1 | aee01a282858226af0fd70e693e2a9a1efcb7bead52b7cb603c5f05e46f6e98f | 2020-08-25 20:28:10.268 | 4599184 | 284022 | 184 | 3 | 1 | 3_184 | |
2 | 9645867dd77d8495f4e45f0aa27de47b5868bd2b0e570fea00bfcc5696a173b6 | 2020-08-25 20:29:11.907 | 4599231 | 284025 | 185 | 3 | 1 | 3_185 | |
3 | cf65e5d6015524f530feafa03e20fe4ef44939d3e10de5a6c432f37de949f225 | 2020-08-25 20:32:00.633 | 4599356 | 284028 | 186 | 3 | 1 | 3_186 | |
4 | 55f5c1c9fab711076e4f51858e0c84ae2ac47da8923f43bca20cade47c8367ce | 2020-08-25 20:33:04.545 | 4599404 | 284031 | 187 | 3 | 1 | 3_187 | |
5 | d5faf14a49be42742d3c5b65cc1f3684a1b678616f49dbd4fb3eee723c103030 | 2020-08-25 20:34:18.111 | 4599458 | 284034 | 188 | 3 | 1 | 3_188 | |
6 | 3edb67bf7e148f89c98765081009fb1db2896245bc5f1315d07a806a948be8d4 | 2020-08-25 20:35:01.518 | 4599489 | 284037 | 189 | 3 | 1 | 3_189 | |
7 | 58fee769438dda088fd091de1fed0f674ef8446a46af8be55f94107302fd96b0 | 2020-08-25 20:35:44.235 | 4599522 | 284040 | 190 | 3 | 1 | 3_190 | |
8 | 285bfb22e545c2432450973e2c066e717db37714289e0afc0a2872f2e593be02 | 2020-08-25 20:36:49.256 | 4599570 | 284043 | 191 | 3 | 1 | 3_191 | |
9 | 2d6fc15eddd272632cf6c8424b698ba0c3fefa3db7bee7f756d2514ccce7abcd | 2020-08-25 20:38:07.326 | 4599627 | 284046 | 192 | 3 | 1 | 3_192 | |
10 | bc8d4bc8559739cf71c515c1f0806f4ee9115e6801994d2fc092cc784d4066b0 | 2020-08-25 20:39:30.124 | 4599691 | 284049 | 193 | 3 | 1 | 3_193 | |
11 | da217c1bf2080174c6d46c4e411ab908060911c0ea1596891ca1c05a656d943e | 2020-08-25 20:40:32.421 | 4599738 | 284052 | 194 | 3 | 1 | 3_194 | |
12 | 7177733f585b957d01c90b5f478933e06066b7706886beac0c33b9515e58e7e6 | 2020-08-25 20:41:19.095 | 4599773 | 284055 | 195 | 3 | 1 | 3_195 | |
13 | 09eeb29be3fccb13774d22b13ae4c6cec1f6e4bc8eab9e7d5c78698964ecd02a | 2020-08-25 20:42:58.610 | 4599849 | 284058 | 196 | 3 | 1 | 3_196 | |
14 | 3dbd619aab5067aeb3a2a6cdf85ee2dcaa4e841340e46c809833e1faa7367379 | 2020-08-25 20:43:39.802 | 4599878 | 284061 | 197 | 3 | 1 | 3_197 | |
15 | 9dc8d9573d9622873b9c0174ea8183250d6af150661ba7aba033e8df507b5124 | 2020-08-25 20:44:15.337 | 4599905 | 284064 | 198 | 3 | 1 | 3_198 | |
16 | 09e729f1cc19472e39be638ed280022d06b74dcce26d0c4fe16992a7aaa7402d | 2020-08-25 20:58:59.726 | 4600568 | 284139 | 192 | 2 | 1 | 2_192 | |
17 | fc846b39105e560e7f4712231e022c22ec1b3aad1f30a234c3abcf3d53312e3c | 2020-08-25 20:58:59.726 | 4600568 | 284161 | 197 | 2 | 1 | 2_197 | |
18 | 5d3205e7f6377980299970072b8f43df8a9676198a0a2c186861aa96924eddfd | 2020-08-25 20:59:01.233 | 4600569 | 284290 | 194 | 2 | 1 | 2_194 | |
19 | d0271346f6303846e5638b6dcf33bac0841effb9e9c120ab579e9c7dcccc0a7f | 2020-08-25 20:59:02.663 | 4600570 | 284333 | 194 | 15 | 1 | 15_194 | |
20 | a787885924070b85e40dbe3166498512bc1541e932b2aaf3db4b9d464da28b7f | 2020-08-25 20:59:04.090 | 4600571 | 284531 | 184 | 15 | 1 | 15_184 |
libruaryFirstMintedEventsByEdition
Updated 2025-03-14
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
›
⌄
WITH moment_minted_events AS (
SELECT
tx_id,
block_timestamp,
block_height,
event_data:momentID::STRING AS moment_id,
event_data:playID::STRING AS play_id,
event_data:setID::STRING AS set_id,
event_data:serialNumber::STRING AS serial_number,
event_data:subeditionID::STRING AS subedition_id,
CONCAT(event_data:setID::STRING, '_', event_data:playID::STRING) AS edition_id,
ROW_NUMBER() OVER (
PARTITION BY CONCAT(event_data:setID::STRING, '_', event_data:playID::STRING)
ORDER BY block_height ASC
) AS row_num
FROM FLOW.core.fact_events
WHERE
event_type = 'MomentMinted'
AND event_contract = 'A.0b2a3299cc857e29.TopShot'
AND event_data:serialNumber::STRING = '1'
)
SELECT
tx_id,
block_timestamp,
block_height,
moment_id,
play_id,
set_id,
serial_number,
subedition_id,
edition_id
FROM moment_minted_events
WHERE row_num = 1
ORDER BY block_height ASC;
Last run: 3 months ago
...
8976
1MB
24s