BLOCK_TIMESTAMP | TX_HASH | USER | AMOUNT | CREATEDTIMESTAMP | ENDTIMESTAMP | DEPOSITINDEX | FUNCTION | |
|---|---|---|---|---|---|---|---|---|
1 | 2024-06-13 19:37:35.000 | 0x0dddd932c57928a14fea027e0f48cbed4d942d989605ca978bbd5099eb63bb3c | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 3 | 2024-06-13 19:37:35.000 | 2027-06-13 19:37:35.000 | 0 | Deposit |
2 | 2024-06-16 00:13:47.000 | 0xbf6ed3a1b0444d96ac0efa410b34b1538e4be9b7e11a18a57d3a6e82aa53272e | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 41 | 2024-06-16 00:13:47.000 | 2027-06-16 00:13:47.000 | 1 | Deposit |
3 | 2024-06-27 03:45:47.000 | 0x66955224c1eebe748db2c74d4a5a2909772322efa9c957131f7ee8d6995c1213 | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 2446 | 2024-06-27 03:45:47.000 | 2024-07-27 03:45:47.000 | 2 | Deposit |
4 | 2024-07-25 11:58:35.000 | 0xef995a08d57aadab3d92c388a16f52b2810a857f314ccf446f81f5c146c99375 | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 448 | 2024-07-25 11:58:35.000 | 2024-08-24 11:58:35.000 | 3 | Deposit |
5 | 2024-07-25 12:00:11.000 | 0xa590fcf6300c1ae452a6c66a123e0fa364018377889fade696f56d609c03313f | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 2446 | 2024-06-27 03:45:47.000 | 2024-09-25 03:45:47.000 | 2 | Extend |
6 | 2024-08-24 13:34:59.000 | 0x4cc150087d9811c89cfb383502d3fe9dad9bde7a501161f097510efa407a9ece | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 448 | 2024-08-24 13:34:59.000 | 2024-08-24 13:34:59.000 | [3] | Withdraw |
7 | 2024-09-25 07:37:59.000 | 0xa153cc7a83d8cf449e825323bb6e90e0a7a82745f1f126769405dd2be7afa20a | 0x7a0f25f437124d1be77601d69bb353a3c102988b | 2446 | 2024-09-25 07:37:59.000 | 2024-09-25 07:37:59.000 | [2] | Withdraw |
freemartianWayfinder User Activity
Updated 2 hours ago
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
›
⌄
WITH prices AS(
SELECT
hour::date AS price_day,
AVG(price) AS price
FROM ethereum.price.ez_prices_hourly
WHERE token_address = '0xb23d80f5fefcddaa212212f028021b41ded428cf'
AND hour::date >= '2024-06-01'
GROUP BY 1
),
deposits AS (
SELECT
block_timestamp,
tx_hash,
decoded_log:user AS user,
decoded_log:amount / pow(10,18) AS amount,
to_timestamp(decoded_log:createdTimestamp) AS createdTimestamp,
to_timestamp(decoded_log:endTimestamp) AS endTimestamp,
decoded_log:depositIndex AS depositIndex,
'Deposit' AS function,
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
AND event_name = 'DepositCreated'
AND block_timestamp::date >= '2024-06-01'
AND user = LOWER('{{wallet_address}}')
),
addtime AS (
SELECT
el.block_timestamp,
el.tx_hash,
el.decoded_log:user AS user,
d.amount,
to_timestamp(el.decoded_log:createdTimestamp) AS createdTimestamp,
to_timestamp(el.decoded_log:endTimestamp) AS endTimestamp,
el.decoded_log:depositIndex AS depositIndex,
Last run: about 2 hours agoAuto-refreshes every 1 hour
7
1KB
72s