flipside

    Pending Users Withdrawals: Time since Request
    lidoPending Users Withdrawals: Time since Request
    Updated 1 hour ago

    -- retrieves the MIN and MAX IDs which contain finalized withdrawal request
    with finalized_ids AS (
    SELECT
    MIN(DECODED_LOG:from) as min_id
    , MAX(DECODED_LOG:to) as max_id
    FROM ethereum.core.ez_decoded_event_logs
    WHERE CONTRACT_ADDRESS = '0x889edc2edab5f40e902b864ad4d7ade8e412f9b1' --Lido withrawal queue
    AND EVENT_NAME = 'WithdrawalsFinalized'
    )
    -- filters and gets withdrawal requests falling within the range of finalized IDs obtained from the previous CTE
    , requested_time_to_finalize AS (
    SELECT
    BLOCK_TIMESTAMP AS request_time
    , DECODED_LOG:requestId AS requesId
    , DECODED_LOG:amountOfStETH / 1e18 AS amount
    , NULL AS finalized_time
    , TIMESTAMPDIFF(HOUR,BLOCK_TIMESTAMP,CURRENT_TIMESTAMP) AS latency_hours
    , DECODED_LOG:requestor AS requestor
    , TX_HASH
    , 'pending' AS status
    FROM ethereum.core.ez_decoded_event_logs
    WHERE CONTRACT_ADDRESS = '0x889edc2edab5f40e902b864ad4d7ade8e412f9b1'
    AND EVENT_NAME = 'WithdrawalRequested'
    AND DECODED_LOG:requestId > (select max_id from finalized_ids)
    )
    -- aggregates data from previous CTE
    , requests_data as (
    SELECT
    status
    , requestor
    , TX_HASH
    , SUM(amount) AS "Amount, Ξ"
    , MIN(request_time) AS "Time of request"
    , MAX(finalized_time) AS "Finalized time"
    , MAX(latency_hours) AS "Waiting time,hours"
    Last run: about 1 hour agoAuto-refreshes every 12 hours
    STATUS
    REQUESTOR
    TX_HASH
    Amount, Ξ
    Time of request
    Finalized time
    Waiting time,hours
    1
    		pending
    0x43594da5d6a03b2137a04df5685805c676def7cb
    		0xf72ba052cedd82680e3196117d497d2ae6805ab5c2f8af7eea1c464e42ec22ca15334.212025-05-09 16:45:59.000250
    2
    		pending
    0x9b465ebc531cf1abfa683bcf4c8487d5f580ebd0
    		0xcb5f92df3d78f255295107f754f25f7499441d1e6bf3f8e55580803f1008779e30.9191558542025-05-09 16:47:35.000250
    3
    		pending
    0x44d09dfe6b9abdf362f555caacabc8eb93923a21
    		0x9ca1836fc192f5ea96b5dc99664dd546f7c7ccfe06e7922d0350bb7833cb38a72.027352982025-05-09 16:48:35.000250
    4
    		pending
    0x0573071528765abbda7c5c431fb8c8e13daa63ee
    		0xca350a15e2a4b2fb2a0559e5706fbd5013d17ffa7453ca39800da2a04b6a6d4b0.59810132062025-05-09 16:52:35.000250
    5
    		pending
    0x8e0a03de4b802b5bb792af0e7fc876b50436e845
    		0x1bce8e8cefaf1319b5355731da44d9ec11bc55d5ae9852a6919ddacd8119a42b7.204668922025-05-09 17:06:59.000249
    6
    		pending
    0x010d7114114e52ecc9a42eb08b6d58e5dd4f4423
    		0x3b24ba4b743307264e6dfa66b6ec1920b7349f0fb91223513228b0235a1ae64a8.3621773392025-05-09 17:30:47.000249
    7
    		pending
    0x7c0d7919ab6a4546da39787509ff51b0283d53b4
    		0xcda07d5354adc5dad263be392b17474387355b13f95c6c539d03f466714e46cb0.10013835992025-05-09 17:52:23.000249
    8
    		pending
    0xadb73c1fd1d8f5809b414db57db11ddfea03e574
    		0x643d43d7bd46437ee4ea88e5ac186f6931dffe8bdedae82e852c77c25d3c3d9f0.050056994982025-05-09 18:02:59.000248
    9
    		pending
    0x5e97433b6a0534e64952c4e8e3d46098b7769209
    		0x29a6f5c9be3ee7febd959dca7c0f1af29db5728cc5014902acf698b7efeab962102025-05-09 18:29:35.000248
    10
    		pending
    0xa7cedc1ea67ffc357f74a4b5aa72c2873b22d31a
    		0x3cc17620e22af3180ec892eca78f36b3f106b9585ad5155a1b9d131a03b6fa502.1499593272025-05-09 18:31:35.000248
    11
    		pending
    0xcf373168ad5cf3760083b2811aa8532075bff20b
    		0x01c3b4452400d37863b9f57c4d17c2996a5383c8485b08763540607112d48b751.0558466022025-05-09 18:33:47.000248
    12
    		pending
    0x7fb343426af8b9141db49d15477dc0e3983d0b70
    		0x9b1bc522850db2a84bf8f3c04570925c9f517d1908216470b90af40b3214bcdd0.14659114392025-05-09 18:36:11.000248
    13
    		pending
    0xe527f8cb57647b1bb808ffed1c9966453aa84adb
    		0x05bf2679ece92db17eb88cf735d0dedc056dfe94d6e35542daf82254e0a874d62.1663026972025-05-09 18:47:35.000248
    14
    		pending
    0xf62c1bf088bbe28ac4aceb3f1d523e77f17363f4
    		0x9d0d0c283eec2d9f403a50a2c015cfb6791dbff15ea8be04f4362a41feeab57526.0491048832025-05-09 19:03:59.000247
    15
    		pending
    0x1746dcc942d45b4016a1fdc35d725c2a89d08177
    		0xc2e4e4f1a0815024dba6dfb667dce82cc6bb7ac4f22e21efcb15621a80f4832b5.7481536862025-05-09 19:05:11.000247
    16
    		pending
    0x0e11c1fd0da5ed95759d0bdb7dc9cbebd6b0ae28
    		0xeed6d18bedb345c46ec0dcee2f643e12699a94214b098c79934b0ae9fbde4fb24.6919303092025-05-09 19:06:23.000247
    17
    		pending
    0xc5af923849c3956512e24c1cd533ba7d61979920
    		0x742eef9759cb1ac76f8639901c7eab647b6f22eaad1e0ab4699e58d27f2cb26c1.3052610952025-05-09 19:07:47.000247
    18
    		pending
    0x1013290d30062aa543d02db9d652db68a5da6db4
    		0x9af4c33a64925fae9acd56dbfc9b67b6bbc55989ffee4564f08c339523af15184.0045595982025-05-09 19:33:35.000247
    19
    		pending
    0x932f3383472a571ed4602f68e714dad0423a4f6c
    		0x88f9fe6dd381965434c991744801a547271a3d3b5853e690e576992c3a8ea5c40.34190469312025-05-09 20:10:35.000246
    20
    		pending
    0xc1587dd7209491672aadf61944a98cea2916f0c7
    		0x1b40f6022421d0cb717da36abff06d8a1a4743793786601bc154391be33292070.41979889032025-05-09 20:15:11.000246
    ...
    983
    165KB
    146s