No Data to Display
hildobbyfantasy.top Mints Stats
Updated 2025-03-11
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 decoded_fantasy_mints AS (
SELECT block_timestamp
, tx_hash
, 'Mint' AS event
, regexp_substr_all(SUBSTR(data, 3, len(data)), '.{64}') AS segmented
FROM blast.core.ez_decoded_event_logs
WHERE contract_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'
AND origin_function_signature = '0x1ff7712f'
AND block_timestamp >= date_trunc('hour', current_timestamp - interval '4 days')
)
, fantasy_mints AS (
SELECT block_timestamp
, tx_hash
, 'Mint' AS event
, utils.udf_hex_to_int(segmented[0]) AS mint_config_id
, LTRIM(segmented[1]) AS buyer
, utils.udf_hex_to_int(segmented[2]) AS total_minted
, utils.udf_hex_to_int(segmented[3]) AS first_id
, utils.udf_hex_to_int(segmented[4]) AS last_id
, utils.udf_hex_to_int(segmented[5])::decimal/1e18 AS price
FROM decoded_fantasy_mints
)
, data AS (
SELECT date_trunc('hour', block_timestamp) AS time
, CASE WHEN price = 0 THEN 'Free'
WHEN price = 0.033 THEN '0.033 ETH'
WHEN price = 0.066 THEN '0.066 ETH'
ELSE 'VRGDA'
END AS mint_type
/*, CASE WHEN mint_config_id IN (3, 5, 9, 11, 13, 22, 23) THEN 'Free'
WHEN mint_config_id IN (1, 4, 7, 10, 16) THEN '0.033 ETH'
WHEN mint_config_id IN (2, 6, 8, 12, 15) THEN '0.066 ETH'
WHEN mint_config_id = 17 THEN 'VRGDA'
ELSE CAST(mint_config_id AS string)
Last run: about 2 months ago
0
2B
27s