freemartianAll Users Activity
    Updated 4 days ago
    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
    DEPOSIT_TX
    INCREASE_TX
    USER
    AMOUNT
    CREATEDTIMESTAMP
    ENDTIMESTAMP
    NEWTIMESTAMP
    FINAL_END_TIMESTAMP
    LOCK_DAYS
    LABEL
    1
    0xccf5fe0bbf08b2e142137e1f66a8871d9226c85ea442b31912837b956c5fc49dNo Extend Transaction
    0x7028d23e96fabf5bb374513a9b838c6d75bdad84
    22024-06-04 20:59:47.0002024-06-25 20:59:47.0002024-06-25 20:59:47.00021Less Than 1 Month
    2
    0x129ec67c35305438f7c1548aed4ed845c34945532bb6671f9ed3adfe8654c43dNo Extend Transaction
    0x7028d23e96fabf5bb374513a9b838c6d75bdad84
    22024-06-04 21:03:23.0002027-06-04 21:03:23.0002027-06-04 21:03:23.000109536 Months
    3
    0x4e1133c9e3c098c93df532cb426cd4c842c64b1c22324a031e378d4f3036042dNo Extend Transaction
    0xf2327b04521589f505c7074c163805843a4bd6cd
    222024-06-04 21:31:11.0002027-06-04 21:31:11.0002027-06-04 21:31:11.000109536 Months
    4
    0x396487c4d51b947d7dd3d77bf3eb4a5b989797ed0bae2305f090029079decc160xabb1d4831d976097ca2e0286cb4231721c93026839d805bd5cd096b0e766aa22
    0x70f2b379117dd28ee7708d5a31ceb3065a96c096
    30002024-06-04 21:33:11.0002024-09-06 21:33:11.0002027-06-04 21:33:11.0002027-06-04 21:33:11.000109536 Months
    5
    0x1df2ded5784fa01878a8f32af71c272cb289d85ff6fd550f05bf89b3a3ef4e7eNo Extend Transaction
    0x5eb92096e215bf90e10f45a30de438ce98cdf4d1
    22024-06-05 11:11:23.0002024-06-26 11:11:23.0002024-06-26 11:11:23.00021Less Than 1 Month
    6
    0xe93a46f5b00948553f951a9bb3bb63e3cf0f418224283d632a78b2624b112e61No Extend Transaction
    0x75d499b2235cec34d4fa53730b817e3850ca46b6
    82024-06-05 12:45:23.0002024-06-26 12:45:23.0002024-06-26 12:45:23.00021Less Than 1 Month
    7
    0xf269003844017ddc8fe9004eb0d7722156232ece147c245214a14c27e8425981No Extend Transaction
    0xcb58f6eab75e27bc9c5119d4e635a16bd68da301
    92024-06-05 14:10:35.0002024-06-26 14:10:35.0002024-06-26 14:10:35.00021Less Than 1 Month
    8
    0xff43e21c1557452ba510807f5e15a8102f94801cda29ffcc75f38b02ae43ac2bNo Extend Transaction
    0xb6f2944a3b5d26d7c40a42a8eb7d87cc65d46e73
    22024-06-05 14:11:11.0002024-06-26 14:11:11.0002024-06-26 14:11:11.00021Less Than 1 Month
    9
    0x06d1831cd311492d03430e66a4ffcbc2741d95b977c48cf329d6a4d8526fec1aNo Extend Transaction
    0xe0e6a57fcef14eac98ff2518d2e104339ec7578f
    1000002024-06-05 15:49:23.0002027-06-05 15:49:23.0002027-06-05 15:49:23.000109536 Months
    10
    0xf46da8d0eec16dd4d1ffe3ed70aae804747e4b1e8defb6c2a6e3da08b93a94390x1f4d4e89205ff12cee40325f531466cdf4f1541ea772d320a043b7c5a7198452
    0xe0e6a57fcef14eac98ff2518d2e104339ec7578f
    2139092024-06-05 15:51:11.0002024-06-26 15:51:11.0002027-06-05 15:51:11.0002027-06-05 15:51:11.000109536 Months
    11
    0xf46da8d0eec16dd4d1ffe3ed70aae804747e4b1e8defb6c2a6e3da08b93a94390x722be3f8f3c02a06dd52c6f6e694a15592dc7b6c4f0c06bf7a559b08a30e95a2
    0xe0e6a57fcef14eac98ff2518d2e104339ec7578f
    2139092024-06-05 15:51:11.0002024-06-26 15:51:11.0002025-05-15 15:51:11.0002025-05-15 15:51:11.00034411 Months
    12
    0xb310752fa7a807b34096a25992c3f7af1f7f7b419c11037de9d3ecb7712b991dNo Extend Transaction
    0xb105e69f24af18198f7ba1421a04f335df90f8dd
    500002024-06-05 16:09:59.0002027-06-05 16:09:59.0002027-06-05 16:09:59.000109536 Months
    13
    0xfd2bd3054083c8b1704f2bf45baa5270e0ca202b9343c26db81f01310e310af20x21614488c9cc839ac4737940fb2d5e5c0e6edac139f8f40e4e5e18bd86e74a67
    0xb105e69f24af18198f7ba1421a04f335df90f8dd
    660592024-06-05 16:14:23.0002024-07-23 16:14:23.0002025-05-13 16:14:23.0002025-05-13 16:14:23.00034211 Months
    14
    0xfd2bd3054083c8b1704f2bf45baa5270e0ca202b9343c26db81f01310e310af20x2a5c45a1eb9fe0b4372beb3288cdd371a357bab154cff318a24c147fb8c0c5ca
    0xb105e69f24af18198f7ba1421a04f335df90f8dd
    660592024-06-05 16:14:23.0002024-07-23 16:14:23.0002027-06-05 16:14:23.0002027-06-05 16:14:23.000109536 Months
    15
    0x3c289b8175091040eec2d02cf144db8b428791ace09b87d6695b62ad2ca0fc5bNo Extend Transaction
    0xc0d40ed9ebe45f52b485e037a675d1f6a745b5da
    9762024-06-05 16:17:23.0002024-08-04 16:17:23.0002024-08-04 16:17:23.000602 Months
    16
    0xa7209b025107e656a7d0ddda8410cb898d894838564dd59c6aa17705bda412eeNo Extend Transaction
    0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee
    1500002024-06-05 16:18:59.0002027-06-05 16:18:59.0002027-06-05 16:18:59.000109536 Months
    17
    0xa687232f1805248f49d37b5e19f802500852c3e966ceb708c5856d1a5df8bfb30x8953b216e2992c7282256e4f499ae698e3a662c184b87f361fc6edfbeeda6cd1
    0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee
    5978472024-06-05 16:20:59.0002024-06-26 16:20:59.0002027-06-05 16:20:59.0002027-06-05 16:20:59.000109536 Months
    18
    0xa687232f1805248f49d37b5e19f802500852c3e966ceb708c5856d1a5df8bfb30xb190fe14659e881ceccfc87aa8f77eaf4d76505c68146c2a90e9ae2e1f7d8d70
    0xbddb6861b4efc68653bbc4faa4d5df6e411f82ee
    5978472024-06-05 16:20:59.0002024-06-26 16:20:59.0002025-05-15 16:20:59.0002025-05-15 16:20:59.00034411 Months
    19
    0x72bb41291bfb07000c7bc1c33a180ab75cc4a7a1737da9c82c7fe889c1f7b4adNo Extend Transaction
    0x45b9b4ef84e960d9b77c5e7c28967a27a4ad9a34
    500002024-06-05 16:32:11.0002027-06-05 16:32:11.0002027-06-05 16:32:11.000109536 Months
    20
    0xd01599f534253d7469e420e37c4d9b06ac96d728869414934d58a1c38c0f4aa1No Extend Transaction
    0x023d8ca9cdd52a65d0b6df2ecdbc880c0c2ba312
    102024-06-05 17:23:23.0002024-09-13 17:23:23.0002024-09-13 17:23:23.0001003 Months
    ...
    27978
    7MB
    150s