DEPOSIT_TX | INCREASE_TX | USER | AMOUNT | CREATEDTIMESTAMP | ENDTIMESTAMP | NEWTIMESTAMP | FINAL_END_TIMESTAMP | LOCK_DAYS | LABEL | |
---|---|---|---|---|---|---|---|---|---|---|
1 | 0xccf5fe0bbf08b2e142137e1f66a8871d9226c85ea442b31912837b956c5fc49d | No Extend Transaction | 0x7028d23e96fabf5bb374513a9b838c6d75bdad84 | 2 | 2024-06-04 20:59:47.000 | 2024-06-25 20:59:47.000 | 2024-06-25 20:59:47.000 | 21 | Less Than 1 Month | |
2 | 0x129ec67c35305438f7c1548aed4ed845c34945532bb6671f9ed3adfe8654c43d | No Extend Transaction | 0x7028d23e96fabf5bb374513a9b838c6d75bdad84 | 2 | 2024-06-04 21:03:23.000 | 2027-06-04 21:03:23.000 | 2027-06-04 21:03:23.000 | 1095 | 36 Months | |
3 | 0x4e1133c9e3c098c93df532cb426cd4c842c64b1c22324a031e378d4f3036042d | No Extend Transaction | 0xf2327b04521589f505c7074c163805843a4bd6cd | 22 | 2024-06-04 21:31:11.000 | 2027-06-04 21:31:11.000 | 2027-06-04 21:31:11.000 | 1095 | 36 Months | |
4 | 0x396487c4d51b947d7dd3d77bf3eb4a5b989797ed0bae2305f090029079decc16 | 0xabb1d4831d976097ca2e0286cb4231721c93026839d805bd5cd096b0e766aa22 | 0x70f2b379117dd28ee7708d5a31ceb3065a96c096 | 3000 | 2024-06-04 21:33:11.000 | 2024-09-06 21:33:11.000 | 2027-06-04 21:33:11.000 | 2027-06-04 21:33:11.000 | 1095 | 36 Months |
5 | 0x1df2ded5784fa01878a8f32af71c272cb289d85ff6fd550f05bf89b3a3ef4e7e | No Extend Transaction | 0x5eb92096e215bf90e10f45a30de438ce98cdf4d1 | 2 | 2024-06-05 11:11:23.000 | 2024-06-26 11:11:23.000 | 2024-06-26 11:11:23.000 | 21 | Less Than 1 Month | |
6 | 0xe93a46f5b00948553f951a9bb3bb63e3cf0f418224283d632a78b2624b112e61 | No Extend Transaction | 0x75d499b2235cec34d4fa53730b817e3850ca46b6 | 8 | 2024-06-05 12:45:23.000 | 2024-06-26 12:45:23.000 | 2024-06-26 12:45:23.000 | 21 | Less Than 1 Month | |
7 | 0xf269003844017ddc8fe9004eb0d7722156232ece147c245214a14c27e8425981 | No Extend Transaction | 0xcb58f6eab75e27bc9c5119d4e635a16bd68da301 | 9 | 2024-06-05 14:10:35.000 | 2024-06-26 14:10:35.000 | 2024-06-26 14:10:35.000 | 21 | Less Than 1 Month | |
8 | 0xff43e21c1557452ba510807f5e15a8102f94801cda29ffcc75f38b02ae43ac2b | No Extend Transaction | 0xb6f2944a3b5d26d7c40a42a8eb7d87cc65d46e73 | 2 | 2024-06-05 14:11:11.000 | 2024-06-26 14:11:11.000 | 2024-06-26 14:11:11.000 | 21 | Less Than 1 Month | |
9 | 0x06d1831cd311492d03430e66a4ffcbc2741d95b977c48cf329d6a4d8526fec1a | No Extend Transaction | 0xe0e6a57fcef14eac98ff2518d2e104339ec7578f | 100000 | 2024-06-05 15:49:23.000 | 2027-06-05 15:49:23.000 | 2027-06-05 15:49:23.000 | 1095 | 36 Months | |
10 | 0xf46da8d0eec16dd4d1ffe3ed70aae804747e4b1e8defb6c2a6e3da08b93a9439 | 0x1f4d4e89205ff12cee40325f531466cdf4f1541ea772d320a043b7c5a7198452 | 0xe0e6a57fcef14eac98ff2518d2e104339ec7578f | 213909 | 2024-06-05 15:51:11.000 | 2024-06-26 15:51:11.000 | 2027-06-05 15:51:11.000 | 2027-06-05 15:51:11.000 | 1095 | 36 Months |
11 | 0xf46da8d0eec16dd4d1ffe3ed70aae804747e4b1e8defb6c2a6e3da08b93a9439 | 0x722be3f8f3c02a06dd52c6f6e694a15592dc7b6c4f0c06bf7a559b08a30e95a2 | 0xe0e6a57fcef14eac98ff2518d2e104339ec7578f | 213909 | 2024-06-05 15:51:11.000 | 2024-06-26 15:51:11.000 | 2025-05-15 15:51:11.000 | 2025-05-15 15:51:11.000 | 344 | 11 Months |
12 | 0xb310752fa7a807b34096a25992c3f7af1f7f7b419c11037de9d3ecb7712b991d | No Extend Transaction | 0xb105e69f24af18198f7ba1421a04f335df90f8dd | 50000 | 2024-06-05 16:09:59.000 | 2027-06-05 16:09:59.000 | 2027-06-05 16:09:59.000 | 1095 | 36 Months | |
13 | 0xfd2bd3054083c8b1704f2bf45baa5270e0ca202b9343c26db81f01310e310af2 | 0x21614488c9cc839ac4737940fb2d5e5c0e6edac139f8f40e4e5e18bd86e74a67 | 0xb105e69f24af18198f7ba1421a04f335df90f8dd | 66059 | 2024-06-05 16:14:23.000 | 2024-07-23 16:14:23.000 | 2025-05-13 16:14:23.000 | 2025-05-13 16:14:23.000 | 342 | 11 Months |
14 | 0xfd2bd3054083c8b1704f2bf45baa5270e0ca202b9343c26db81f01310e310af2 | 0x2a5c45a1eb9fe0b4372beb3288cdd371a357bab154cff318a24c147fb8c0c5ca | 0xb105e69f24af18198f7ba1421a04f335df90f8dd | 66059 | 2024-06-05 16:14:23.000 | 2024-07-23 16:14:23.000 | 2027-06-05 16:14:23.000 | 2027-06-05 16:14:23.000 | 1095 | 36 Months |
15 | 0x3c289b8175091040eec2d02cf144db8b428791ace09b87d6695b62ad2ca0fc5b | No Extend Transaction | 0xc0d40ed9ebe45f52b485e037a675d1f6a745b5da | 976 | 2024-06-05 16:17:23.000 | 2024-08-04 16:17:23.000 | 2024-08-04 16:17:23.000 | 60 | 2 Months | |
16 | 0xa7209b025107e656a7d0ddda8410cb898d894838564dd59c6aa17705bda412ee | No Extend Transaction | 0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee | 150000 | 2024-06-05 16:18:59.000 | 2027-06-05 16:18:59.000 | 2027-06-05 16:18:59.000 | 1095 | 36 Months | |
17 | 0xa687232f1805248f49d37b5e19f802500852c3e966ceb708c5856d1a5df8bfb3 | 0x8953b216e2992c7282256e4f499ae698e3a662c184b87f361fc6edfbeeda6cd1 | 0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee | 597847 | 2024-06-05 16:20:59.000 | 2024-06-26 16:20:59.000 | 2027-06-05 16:20:59.000 | 2027-06-05 16:20:59.000 | 1095 | 36 Months |
18 | 0xa687232f1805248f49d37b5e19f802500852c3e966ceb708c5856d1a5df8bfb3 | 0xb190fe14659e881ceccfc87aa8f77eaf4d76505c68146c2a90e9ae2e1f7d8d70 | 0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee | 597847 | 2024-06-05 16:20:59.000 | 2024-06-26 16:20:59.000 | 2025-05-15 16:20:59.000 | 2025-05-15 16:20:59.000 | 344 | 11 Months |
19 | 0x72bb41291bfb07000c7bc1c33a180ab75cc4a7a1737da9c82c7fe889c1f7b4ad | No Extend Transaction | 0x45b9b4ef84e960d9b77c5e7c28967a27a4ad9a34 | 50000 | 2024-06-05 16:32:11.000 | 2027-06-05 16:32:11.000 | 2027-06-05 16:32:11.000 | 1095 | 36 Months | |
20 | 0xd01599f534253d7469e420e37c4d9b06ac96d728869414934d58a1c38c0f4aa1 | No Extend Transaction | 0x023d8ca9cdd52a65d0b6df2ecdbc880c0c2ba312 | 10 | 2024-06-05 17:23:23.000 | 2024-09-13 17:23:23.000 | 2024-09-13 17:23:23.000 | 100 | 3 Months |
freemartianAll Users Activity
Updated 4 days 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,
DATEDIFF(DAY, createdTimestamp, endTimestamp) AS difference_in_days,
decoded_log:depositIndex AS depositIndex,
decoded_log
FROM ethereum.core.ez_decoded_event_logs
WHERE contract_address = '0x4a3826bd2e8a31956ad0397a49efde5e0d825238'
AND event_name = 'DepositCreated'
AND block_timestamp::date >= '2024-06-01'
),
addtime 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 newTimestamp,
DATEDIFF(DAY, createdTimestamp, newTimestamp) AS difference_in_days,
Last run: 4 days agoAuto-refreshes every 1 hour
...
27978
7MB
150s