freemartianWayfinder User Activity
    Updated 2 hours 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,
    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
    BLOCK_TIMESTAMP
    TX_HASH
    USER
    AMOUNT
    CREATEDTIMESTAMP
    ENDTIMESTAMP
    DEPOSITINDEX
    FUNCTION
    1
    2024-06-13 19:37:35.0000x0dddd932c57928a14fea027e0f48cbed4d942d989605ca978bbd5099eb63bb3c
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    32024-06-13 19:37:35.0002027-06-13 19:37:35.000
    0
    Deposit
    2
    2024-06-16 00:13:47.0000xbf6ed3a1b0444d96ac0efa410b34b1538e4be9b7e11a18a57d3a6e82aa53272e
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    412024-06-16 00:13:47.0002027-06-16 00:13:47.000
    1
    Deposit
    3
    2024-06-27 03:45:47.0000x66955224c1eebe748db2c74d4a5a2909772322efa9c957131f7ee8d6995c1213
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    24462024-06-27 03:45:47.0002024-07-27 03:45:47.000
    2
    Deposit
    4
    2024-07-25 11:58:35.0000xef995a08d57aadab3d92c388a16f52b2810a857f314ccf446f81f5c146c99375
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    4482024-07-25 11:58:35.0002024-08-24 11:58:35.000
    3
    Deposit
    5
    2024-07-25 12:00:11.0000xa590fcf6300c1ae452a6c66a123e0fa364018377889fade696f56d609c03313f
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    24462024-06-27 03:45:47.0002024-09-25 03:45:47.000
    2
    Extend
    6
    2024-08-24 13:34:59.0000x4cc150087d9811c89cfb383502d3fe9dad9bde7a501161f097510efa407a9ece
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    4482024-08-24 13:34:59.0002024-08-24 13:34:59.000
    [3]
    Withdraw
    7
    2024-09-25 07:37:59.0000xa153cc7a83d8cf449e825323bb6e90e0a7a82745f1f126769405dd2be7afa20a
    0x7a0f25f437124d1be77601d69bb353a3c102988b
    24462024-09-25 07:37:59.0002024-09-25 07:37:59.000
    [2]
    Withdraw
    7
    1KB
    155s