TIME | USERS | USER_TYPE | Total | |
|---|---|---|---|---|
1 | 2025-01-10 00:00:00.000 | 103 | New | |
2 | 2025-01-10 00:00:00.000 | 1011 | Returning | 1114 |
3 | 2025-02-11 00:00:00.000 | Returning | 1 | |
4 | 2024-12-15 00:00:00.000 | 216 | New | |
5 | 2024-12-15 00:00:00.000 | 526 | Returning | 742 |
6 | 2024-12-27 00:00:00.000 | 135 | New | |
7 | 2024-12-27 00:00:00.000 | 834 | Returning | 969 |
8 | 2025-01-24 00:00:00.000 | 71 | New | |
9 | 2025-01-24 00:00:00.000 | 836 | Returning | 907 |
10 | 2024-12-18 00:00:00.000 | 48 | New | |
11 | 2024-12-18 00:00:00.000 | 257 | Returning | 305 |
12 | 2025-01-19 00:00:00.000 | 43 | New | |
13 | 2025-01-19 00:00:00.000 | 578 | Returning | 621 |
14 | 2025-01-05 00:00:00.000 | 69 | New | |
15 | 2025-01-05 00:00:00.000 | 613 | Returning | 682 |
16 | 2024-12-11 00:00:00.000 | 231 | New | |
17 | 2025-01-17 00:00:00.000 | 66 | New | |
18 | 2025-01-25 00:00:00.000 | 31 | New | |
19 | 2025-01-25 00:00:00.000 | 582 | Returning | 613 |
20 | 2025-01-17 00:00:00.000 | 925 | Returning | 991 |
hildobbyfantasy.top Users copy
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
›
⌄
⌄
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
FROM blast.core.ez_decoded_event_logs
WHERE contract_address = '0x86b58ca576c24f79ad1e5459aee01d40bea22828'
AND origin_function_signature = '0x1ff7712f'
AND block_timestamp >= date_trunc('day', current_timestamp - interval '3 months') AND block_timestamp < date_trunc('day', current_timestamp)
)
, 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 >= date_trunc('day', current_timestamp - interval '3 months') AND block_timestamp < date_trunc('day', current_timestamp)
)
, fantasy_trades AS (
Last run: about 1 month ago
...
108
5KB
9s