flipside

    Pending Users Withdrawals: Time since Request
    lidoPending Users Withdrawals: Time since Request
    Updated 11 hours 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 11 hours agoAuto-refreshes every 12 hours
    STATUS
    REQUESTOR
    TX_HASH
    Amount, Ξ
    Time of request
    Finalized time
    Waiting time,hours
    1
    		pending
    0x2178e1d614fefb2b304db58f07116d89f948fda1
    		0xe45689f08346f04799314b6abdca017a2899c45d9dc76a3f9c8125171e9a11b91999.1504570632025-04-21 12:26:47.00038
    2
    		pending
    0x262cb1d6932f1fcef8b3352fc808814e200dd996
    		0xe9c1648780b05f3b8f20b36a2fa2abc1204b613a8ca8fcf3670fcc1188d76cad2.8788978812025-04-21 12:31:59.00038
    3
    		pending
    0x63bd3e32a22d9057949944f190508f3d4b6c6291
    		0xc3f4b48022e74ae48d419366ac85638bb26a19dafcd6936c9cdf753235d9b2960.07619784572025-04-21 12:37:35.00038
    4
    		pending
    0xee2826453a4fd5afeb7ceffeef3ffa2320081268
    		0x38c778576857fe7871254234741d3dbe277bd300c16a08a3709fa24438e102305180.8925470522025-04-21 12:40:11.00038
    5
    		pending
    0x4c4e6dd2a0230a66222ab656f0fad1601c9edf7c
    		0x9f71db73f6ed41c44c7353b8ae911184a7dfc0d1ab76b11088ff21674af310120.011214654492025-04-21 12:49:59.00038
    6
    		pending
    0xb6c4056ecf801c94d3883e12527895e0dd8064f2
    		0x11a590db963a0faabffcb732424f12a1dbf37c9e2bbf3ff0604614c7f40dca3d0.055051990262025-04-21 12:56:23.00038
    7
    		pending
    0x2a18550c73e983fc66a3971daaec6d3157fbb824
    		0x7208805e77d2445c76dbca0c61f1053da3da685e13c9010240fb30bb14c9d2930.02996737172025-04-21 13:05:59.00037
    8
    		pending
    0xb2a23d5dce9b3099ad20c2ed910ee84c876d195e
    		0xacb8255b6e461398f0a4f47d2a4529060e31b05f94b7e2ce0e1bf6a71c1c264c1.592019852025-04-21 13:07:35.00037
    9
    		pending
    0x567a498215d2aaa9714d8baab23db7ee737c527f
    		0xa54901b6dc1eb5ec2824fd070d60649fc31f2104c9d95d591df4e2c24d25675412025-04-21 13:09:35.00037
    10
    		pending
    0x7defad05b632ba2cef7ea20731021657e20a7596
    		0xcb9ec876c8c01e952e09ad2cc05bed1afed772f3077d99280a31419aca6bcbf30.010000752892025-04-21 13:13:23.00037
    11
    		pending
    0x686c1394bc109d473f9a56a66c7014be04ac0299
    		0xfdfb41a4859fdfd65f2e0566891a6f3e2a3631c0b9b43754e378e82d0258117d22.8086844132025-04-21 13:26:47.00037
    12
    		pending
    0x70bca9dca9458601fd17e6f3f399900ffe14dcb8
    		0x72a64fe7d3b806812dda19ab7739155687b34e91d9b3f2a76b44ce7fe778d7510.47358534082025-04-21 13:27:59.00037
    13
    		pending
    0x85b78aca6deae198fbf201c82daf6ca21942acc6
    		0xb9d947bb51977b5ad4d25130798bebf4575a005efea5125cadb4f9b8ba33516f190.8117644162025-04-21 13:30:35.00037
    14
    		pending
    0xdb173630e9836c1ee16745c55d69fb21839d7d1d
    		0x8facf8c96815a9e5a8f41c09f8ada6909c3263bf05932cb5107a70d4fa21c38e3.3395587962025-04-21 13:31:47.00037
    15
    		pending
    0x398ced429116257af63bc9350ecb07fb19828b79
    		0x89e3f58d6cba19e9a87c90f28d7eaa451b25a75d35577b929e44fea3b8199c430.5892025-04-21 13:34:35.00037
    16
    		pending
    0x1e0856e492deb65b18c14ece70e5626cd8f0781f
    		0xbab35e380e899c6ba0233907693ed0bf7477595fb328a2674c9d810e2e1587ae5.1099143362025-04-21 13:40:23.00037
    17
    		pending
    0x485c07c5516315881c732c90122ba4de3f356180
    		0xb36c3100f8fed19f88e5f0b54ea2bea5f88f0f5b8f9a76ebb2fe2309d6696630825.4051495842025-04-21 13:43:59.00037
    18
    		pending
    0x3ebcbf1f06dd6fe06f11b081ce3fbf7f83622abd
    		0x9511a62d5a0705d4b597a775efe64eb60dd8003ad94c05122873f92b8c36e1db28.8300899082025-04-21 14:13:47.00036
    19
    		pending
    0xa9595e82f7654e60d93c5400b327f4761c38a6c4
    		0x7c75e34e670667986b0b47b6625d248b7350c15ef3d2025bcb35954f39993e8110.0637947612025-04-21 14:29:47.00036
    20
    		pending
    0x2a587263afc777415b75a85106ff7b85e80cb3e9
    		0xbf3d1e4302d38058f50d91d95217d0264022da4018ff119a77dd883964959cbb100.05542025-04-21 14:37:35.00036
    ...
    188
    31KB
    141s