TX_HASH | BLOCK_TIMESTAMP | TOPICS | DATA | PARSED_DATA | TOKEN_ID | QUANTITY | |
|---|---|---|---|---|---|---|---|
1 | 0x482eddc124aa1fd801bca0401de7665eaa215a98d4bdeac878e1b83852b9fb97 | 2025-03-29 11:11:50.000 | ["0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62","0... | 0x00000000000000000000000000000000000000000000000000000000000000b0000000... | [
"00000000000000000000000000000000000000000000000000000000000000b0",
"0000000000000000000000000000000000000000000000000000000000000001"
] | 176 | 1 |
LittlerDataRagnarok landverse genesis mint transaction example
Updated 2025-03-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
›
⌄
select
tx_hash
,block_timestamp
,topics
,data
,REGEXP_SUBSTR_ALL(SUBSTRING(data, 3), '.{64}') as parsed_data
,livequery.utils.udf_hex_to_int(parsed_data[0])::varchar as token_id
,livequery.utils.udf_hex_to_int(parsed_data[1])::int as quantity
,concat('0x', right(topic_3, 40)) as minter_address
from ronin.core.fact_event_logs
where 1=1
-- and block_timestamp > '2025-03-27 17:56:00'
and contract_address = '0xf6fe00893eea4d47f0cba303ef518fe4ab1c9dd6'
--and topic_0 = '0xc3d58168c5ae7397731d063d5bbf3d657854427343f4c083240f7aacaa2d0f62'
and tx_hash = '0x482eddc124aa1fd801bca0401de7665eaa215a98d4bdeac878e1b83852b9fb97'
Last run: 29 days ago
1
653B
7s