cloudr3navax input data
Updated 2024-01-01
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
›
⌄
with
tx_list as (
select
distinct tx_hash
from
avalanche.core.ez_decoded_event_logs
where
1=1
and contract_address='0x152b9d0fdc40c096757f570a51e494bd4b943e50'
and event_name='Mint'
)
select
tx_hash,
ltrim(input_data, '0x') as trimmed_data,
substr(trimmed_data,0,8) as methodID,
substr(trimmed_data,9,64) as item1,
substr(trimmed_data,9+64,64) as item2,
substr(trimmed_data,9+64+64+64,64) as item3,
substr(trimmed_data,9+64+64+64+64,64) as item4,
substr(trimmed_data,9+64+64+64+64+64,64) as item5,
'https://snowtrace.io' as website
from
avalanche.core.fact_transactions
where
tx_hash in (select tx_hash from tx_list)
QueryRunArchived: QueryRun has been archived