TIME | Minters | Minted | Level Ups | Burned | Supply Flow | Supply | |
|---|---|---|---|---|---|---|---|
1 | 2025-01-19 00:00:00.000 | 156 | 843 | 975 | -2163 | -345 | 220653 |
2 | 2025-01-10 00:00:00.000 | 763 | 3641 | 2405 | -5239 | 807 | 220188 |
3 | 2024-12-23 00:00:00.000 | 282 | 791 | 585 | -1329 | 47 | 210504 |
4 | 2025-01-03 00:00:00.000 | 561 | 2458 | 1886 | -4129 | 215 | 217480 |
5 | 2024-12-20 00:00:00.000 | 456 | 1822 | 1383 | -2997 | 208 | 210381 |
6 | 2025-01-22 00:00:00.000 | 72 | 1893 | 1988 | -4273 | -392 | 220030 |
7 | 2025-01-24 00:00:00.000 | 453 | 3653 | 5116 | -10787 | -2018 | 222192 |
8 | 2024-12-15 00:00:00.000 | 244 | 1243 | 1304 | -2791 | -244 | 208325 |
9 | 2025-01-26 00:00:00.000 | 195 | 1034 | 1389 | -3156 | -733 | 220441 |
10 | 2025-01-18 00:00:00.000 | 216 | 1752 | 2311 | -4985 | -922 | 220998 |
11 | 2025-01-27 00:00:00.000 | 151 | 615 | 914 | -2092 | -563 | 219878 |
12 | 2024-12-12 00:00:00.000 | 164 | 661 | 422 | -856 | 227 | 205750 |
13 | 2025-01-23 00:00:00.000 | 884 | 6436 | 1941 | -4197 | 4180 | 224210 |
14 | 2025-01-21 00:00:00.000 | 94 | 1448 | 1227 | -2544 | 131 | 220422 |
15 | 2024-12-25 00:00:00.000 | 64 | 193 | 197 | -430 | -40 | 210639 |
16 | 2024-12-27 00:00:00.000 | 579 | 1965 | 1110 | -2457 | 618 | 214110 |
17 | 2025-01-02 00:00:00.000 | 924 | 4789 | 1293 | -2838 | 3244 | 217265 |
18 | 2024-12-28 00:00:00.000 | 243 | 780 | 726 | -1596 | -90 | 214020 |
19 | 2025-01-20 00:00:00.000 | 164 | 1363 | 1410 | -3135 | -362 | 220291 |
20 | 2024-12-14 00:00:00.000 | 341 | 1616 | 1808 | -3751 | -327 | 208569 |
hildobbyfantasy.top Mints
Updated 2025-03-11
999
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
›
⌄
⌄
-- forked from fantasy.top Mints @ https://flipsidecrypto.xyz/edit/queries/c3f519b9-4cd9-4de2-9faf-1eb38f8f8aa9
WITH fantasy_mints AS (
SELECT block_timestamp
, tx_hash
, 'Mint' AS event
, LTRIM(substr(data, 3, 64), '0') AS mint_config_id
, '0x' || substr(data, 91, 40) AS minter
, utils.udf_hex_to_int(substr(data, 131, 64)) AS total_minted
, utils.udf_hex_to_int(substr(data, 195, 64)) AS first_id
, utils.udf_hex_to_int(substr(data, 259, 64)) AS last_id
, utils.udf_hex_to_int(substr(data, 259, 64))-utils.udf_hex_to_int(substr(data, 195, 64))+1 AS minted
, utils.udf_hex_to_int(substr(data, 323, 64))/1e18 AS price
FROM blast.core.ez_decoded_event_logs
WHERE contract_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'
AND origin_function_signature = '0x1ff7712f'
AND block_timestamp >= '2024-05-01 14:00'
)
, fantasy_level_ups AS (
SELECT block_timestamp
, tx_hash
, 'Level Up' AS event
, '0x' || substr(data, 219, 40) AS minter
, '0x' || substr(data, 156, 40) AS collection
, utils.udf_hex_to_int(substr(data, 67, 64)) AS minted_token_id
, utils.udf_hex_to_int(substr(data, 259, 64)) AS burned_count
/*, [utils.udf_hex_to_int(substr(data, 323, 64))
, utils.udf_hex_to_int(substr(data, 387, 64))
, utils.udf_hex_to_int(substr(data, 451, 64))
, utils.udf_hex_to_int(substr(data, 515, 64))
, utils.udf_hex_to_int(substr(data, 579, 64))] AS burned_tokens*/
FROM blast.core.ez_decoded_event_logs
WHERE contract_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'
AND origin_function_signature = '0xdb24f400'
AND block_timestamp >= '2024-05-01 14:00'
Last run: about 2 months ago
49
3KB
19s