queninefantasy.top Users copy copy
Updated 2024-05-03
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
›
⌄
⌄
-- forked from hildobby / fantasy.top Users copy @ https://flipsidecrypto.xyz/hildobby/q/Mg37H2mTfKkO/fantasy.top-users-copy
-- forked from fantasy.top Users @ https://flipsidecrypto.xyz/edit/queries/3688887c-ff83-4458-834d-944bd5cbaa14
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 >= '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'
QueryRunArchived: QueryRun has been archived