BLOCK_NUMBER | BLOCK_TIMESTAMP | TX_HASH | TX_POSITION | TRACE_INDEX | FROM_ADDRESS | FROM_ADDRESS_NAME | TO_ADDRESS | TO_ADDRESS_NAME | INPUT | OUTPUT | FULL_DECODED_TRACE | FUNCTION_NAME | DECODED_INPUT_DATA | DECODED_OUTPUT_DATA | TYPE | SUB_TRACES | VALUE | VALUE_PRECISE_RAW | VALUE_PRECISE | GAS | GAS_USED | TRACE_SUCCEEDED | ERROR_REASON | TX_SUCCEEDED | EZ_DECODED_TRACES_ID | INSERTED_TIMESTAMP | MODIFIED_TIMESTAMP | IDENTIFIER | TRACE_STATUS | TX_STATUS | FACT_DECODED_TRACES_ID | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 21094940 | 2024-11-01 19:38:23.000 | 0x865229c1edc03b357fcfeae89edc0e2a126fabd55730329e7e1acf5969cfa15f | 128 | 16 | 0x804a6f5f667170f545bf14e5ddb48c70b788390c | 0x5a64417823e8382a7e8957e4411873fe758e73a8 | 0xeaf6e483000000000000000000000000319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x0000000000000000000000000000000000000000000000000000000000000001 | {"decoded_input_data":{"input_1":"0x319763bf57f2218a5e7fd60a9ccb56fdbb3c... | isBorrower | {"input_1":"0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953"} | {"output_1":true} | DELEGATECALL | 0 | 0 | 0 | 0 | 451647 | 2636 | TRUE | TRUE | c053faabc181ddcb67477d00e17b3ac3 | 2025-02-01 17:16:57.994 | 2025-02-01 17:16:57.994 | DELEGATECALL_0_8_0 | SUCCESS | SUCCESS | c053faabc181ddcb67477d00e17b3ac3 | |||
2 | 21094940 | 2024-11-01 19:38:23.000 | 0x865229c1edc03b357fcfeae89edc0e2a126fabd55730329e7e1acf5969cfa15f | 128 | 15 | 0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0 | 0x804a6f5f667170f545bf14e5ddb48c70b788390c | 0xeaf6e483000000000000000000000000319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x0000000000000000000000000000000000000000000000000000000000000001 | {"decoded_input_data":{"input_1":"0x319763bf57f2218a5e7fd60a9ccb56fdbb3c... | isBorrower | {"input_1":"0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953"} | {"output_1":true} | STATICCALL | 1 | 0 | 0 | 0 | 459406 | 3268 | TRUE | TRUE | e02e82533dc45b4c9276999d8dd59ee4 | 2025-02-01 17:16:57.994 | 2025-02-01 17:16:57.994 | STATICCALL_0_8 | SUCCESS | SUCCESS | e02e82533dc45b4c9276999d8dd59ee4 |
datavortexcracked in a way
Updated 2025-03-14
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
›
⌄
⌄
SELECT *
--SUM(DISTINCT decoded_output_data:output_1) / 1e6
FROM ethereum.core.ez_decoded_traces
--where function_name = 'principal'
--where function_name = 'isBorrower'
where from_address = '0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0'
--and date(block_timestamp) = '2025-02-14'
--and tx_hash = '0x865229c1edc03b357fcfeae89edc0e2a126fabd55730329e7e1acf5969cfa15f'
--AND decoded_input_data:from = '0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0'
--AND TYPE = 'DELEGATECALL'
--AND TYPE = 'STATICCALL'
--0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0 bluechip
--0xe3aac29001c769fafcef0df072ca396e310ed13b high yield corporate loans
--0xb50d675f3c6d18ce5ccac691354f92afebd1675e high yeidl secured lending
/*
WITH principal_data AS (
SELECT
decoded_output_data:output_1 AS borrower -- Fixed typo and assuming Snowflake JSON syntax
FROM ethereum.core.ez_decoded_traces
WHERE tx_hash = '0x1541cd6343678f9f841598701e00f057e7959f37a749cd6ce42759fd5450fa43'
AND function_name = 'principal'
),
second_function_data AS (
SELECT
decoded_input_data:amount AS amount
FROM ethereum.core.ez_decoded_traces
WHERE tx_hash = '0x1541cd6343678f9f841598701e00f057e7959f37a749cd6ce42759fd5450fa43'
AND function_name = 'increasePrincipal'
)
-- Final selection
SELECT
principal_data.borrower AS principal_borrower, -- Directly use the extracted value
second_function_data.amount AS increase_principal_amount
Last run: 2 months ago
2
2KB
145s