TX_HASH | TX_FROM_ADDRESS | TX_TO_ADDRESS | |
|---|---|---|---|
1 | 0x0229c9366322bc94d76a898a96f8bf3b04e0a0f13e044c6263f2bf460cdbaf34 | 0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x4e9e3c5fee726151e29121c1588259f4310b89ab |
2 | 0x02453896d23de8b7fa1525be6ef3e193ae9b59842d6aa65d59a071620d3973be | 0xa989f388644d466fc57e79c149ab7a6cbb9816f3 | 0x667900f97b935955c126d249565b527c7bb4d201 |
3 | 0x044ed6668c5ceb0913f3a30a634c8acb76d2b3cea2f317cbcca4e8eeb20495ab | 0xa989f388644d466fc57e79c149ab7a6cbb9816f3 | 0x667900f97b935955c126d249565b527c7bb4d201 |
4 | 0x0665a6b5ae2ed8680a58856d8c9857d70427f697984c9fc2847f6bec32f40f89 | 0x9c7fc6916095d6492fa9fc388e633f7bce3aa9ef | 0x02c05649e2b11caafc12756c722b76d0d42f0131 |
5 | 0x067a55530124a581184c0ef94ffc3b2dba50690e76f16b2b67513e841ea46838 | 0xda28e780472b5754a1144bce6e83af06a33107d2 | 0x7e655b45aa53bdf5d419fc184d2346df0816ed5c |
6 | 0x06b4099de6afcfa6c2dfa49fa5a25a03aa6f8a39143ce4da40736c0eb0a017d0 | 0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x4e9e3c5fee726151e29121c1588259f4310b89ab |
7 | 0x06c3050e92a6704daf3430483ca87a8e035441f54785c9220b31bac08cd69357 | 0x615803c1ab56b5b1314d9a7728729f840e7a51cf | 0xaa4f38aa3970a4db0d268fafe2966e3f6a7fac5d |
8 | 0x0bcea38f8c738969bcb2e0f23f1eaae05bc17d102a079b40cee122d495cd7eac | 0xd2df28330a879b9d80b892ba614ccae85ab742ea | 0xee9d1874b35d40fb13e8a8e6093521f7947d5345 |
9 | 0x0c5b8726282396f292c131e23004c89dd7d7ec3f6e7397a54cfa0f7c3864a261 | 0xda28e780472b5754a1144bce6e83af06a33107d2 | 0x7e655b45aa53bdf5d419fc184d2346df0816ed5c |
10 | 0x0d0a78d7ea99942f2d7e09f19e33edbab00d8af11baf1609d77007c4aef67e1e | 0xda28e780472b5754a1144bce6e83af06a33107d2 | 0x7e655b45aa53bdf5d419fc184d2346df0816ed5c |
11 | 0x0e24a1b9948e6ae5066c5ee071fc9e2908ea8fd0c0962144cfc59924b094cd78 | 0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x4e9e3c5fee726151e29121c1588259f4310b89ab |
12 | 0x0ed0564a3554c45454c2c29a12db222de04944cc7d80fcc9cdff6e3d9253effd | 0x71e6686f6267b454dbdf6db3399e7d6ced2b5313 | 0x72569cf4a53eb1b09784d7ecdc640cc4f5ff7366 |
13 | 0x0f18418f3008feb5fb750f325fde31cc95d43b058c97a9d2080be8d00e48b807 | 0xda28e780472b5754a1144bce6e83af06a33107d2 | 0x7e655b45aa53bdf5d419fc184d2346df0816ed5c |
14 | 0x123c4a2de364c96113d391e001d4be324b7dc19433c1b30da09fbe9881998aed | 0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x4e9e3c5fee726151e29121c1588259f4310b89ab |
15 | 0x147f5c81b52660fd8cadde6e9165156a5e6639eb4e40f248159b64d7b37770eb | 0x71e6686f6267b454dbdf6db3399e7d6ced2b5313 | 0x97d9a98d092c26c489ee7b04b826f5d17cbe2985 |
16 | 0x16b2e0cf39dab561f1fcaf8611d6f06b91e83b96b3047aebb151a8552adedaea | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 0xba782a156129e2d115fb0076eb0f77e45ace654b |
17 | 0x1814f8cf6d1de5ade8e1253db842986d48e733fcaf19b67d0c150a159c78d1e8 | 0x5cf184fa4b21fb4407451de9d0cd879d9ea0d254 | 0xee9d1874b35d40fb13e8a8e6093521f7947d5345 |
18 | 0x19028d21afc37e9c86ced4f58eda6c57af11a264c9d51bf6d535b9c0bbaa5b51 | 0x319763bf57f2218a5e7fd60a9ccb56fdbb3c7953 | 0x4e9e3c5fee726151e29121c1588259f4310b89ab |
19 | 0x1c9bab43a4b321622329df14ddbceb37a472ad7da3ee6266143de454549d5b53 | 0xc9b94c329a02503c1bc38197f55a6c09f25e1be0 | 0xee9d1874b35d40fb13e8a8e6093521f7947d5345 |
20 | 0x1cf7aab970ef255a36ec57ddf7065184bff1dd6e903fba524e9e8ec06f714cb1 | 0x39a578443e2e81190c75a605aca1b2c38ee5c406 | 0xba782a156129e2d115fb0076eb0f77e45ace654b |
datavortextotals
Updated 2025-03-20
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
›
⌄
⌄
SELECT
dt.tx_hash,
ft.from_address AS tx_from_address,
ft.to_address AS tx_to_address
FROM ethereum.core.ez_decoded_traces dt
JOIN ethereum.core.fact_transactions ft
ON dt.tx_hash = ft.tx_hash
WHERE dt.function_name = 'claim'
AND dt.from_address = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
GROUP BY dt.tx_hash, ft.from_address, ft.to_address
ORDER BY dt.tx_hash;
/*
WITH payment_due_dates AS (
SELECT
tx_hash,
MAX(decoded_output_data:paymentDueDate_::INTEGER) AS payment_due_date_unix,
MAX(TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER)) AS converted_payment_due_date,
MAX(TO_CHAR(TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER), 'YYYY-MM-DD')) AS payment_due_date,
MAX(block_timestamp) AS block_timestamp,
MAX(
DATEDIFF(
'day',
DATE_TRUNC('day', block_timestamp),
DATE_TRUNC('day', TO_TIMESTAMP(decoded_output_data:paymentDueDate_::INTEGER))
)
) AS calculated_days
FROM ethereum.core.ez_decoded_traces
WHERE from_address = LOWER('0xdc9b93a8a336fe5dc9db97616ea2118000d70fc0')
AND function_name = 'paymentDueDate'
GROUP BY tx_hash
),
initial_loan AS (
SELECT
DATE_TRUNC('day', block_timestamp) AS transaction_date,
Last run: 2 months ago
...
156
25KB
1s