par_rnOlas 04
    Updated 2025-01-21
    WITH main AS (
    SELECT
    TX_HASH,
    ORIGIN_FROM_ADDRESS AS user,
    BLOCK_TIMESTAMP,
    CASE
    WHEN is_redeemed = 'TRUE' THEN 'Redeem'
    ELSE 'Deposit'
    END AS event_name,
    olas_amount,
    olas_amount_usd
    FROM
    crosschain.olas.ez_olas_bonding
    )
    SELECT
    user AS redeemer,
    COUNT(DISTINCT TX_HASH) AS transactions,
    SUM(olas_amount) AS total_redeemed_olas,
    SUM(olas_amount_usd) AS total_redeemed_usd
    FROM
    main
    WHERE
    event_name = 'Redeem'
    GROUP BY
    user
    ORDER BY
    total_redeemed_usd DESC

    Last run: about 1 month ago
    REDEEMER
    TRANSACTIONS
    TOTAL_REDEEMED_OLAS
    TOTAL_REDEEMED_USD
    1
    0xe2cea50ba5a302a691b93692e74786d6484db295371743557.052251633223340.11721246
    2
    0xbc6a93cc98c8bbb25f3f8da098468406a8f994849654624.985076625718243.735972942
    3
    0x289449151cb83277842daf094945f2432976904111783935.666866312549123.337330306
    4
    0xc8f7030a4e25585624e2fc792255a547255cd77c17150813.683835739507019.878402748
    5
    0xe6f643177cdd835611612aa87330c0968e69d12912365268.975585819443513.086314621
    6
    0x6c4ae9d11b198b21f8e5ccf18aa640acf5f19c004119909.855020047330686.579499789
    7
    0xba95718a52b5a3dba749a7641712dc05a3550d4f13227272.239515578327081.751691749
    8
    0xdbc46c788f7249251fa6b49303babcb1c519f60871416879.57767026314802.792688569
    9
    0x6a3e98f964e93f183a9e5bb607dd9df75110d2ac12146478.253328032306652.599608985
    10
    0xf76eb72a2a5fd523dc965d25c1e07ad0f32a744711412100.567464796304366.239932155
    11
    0xf0268a2d2250a03423cbaee387f22fc38d0e0a31361299.201671814282198.811008176
    12
    0x2eff0710281c464c34602cb41053fe45407dd618592759.132719738228736.074886683
    13
    0xbb0d28a67cb017aae187036eefd11e5e547422263155347.33423501228551.401757036
    14
    0x0d1b37217b0027cd273a49cd77cdb0c1df8e53a912177824.486367066215862.564349166
    15
    0xa94d1199c5c23e1bb8d5d7cb427c96c5db380524446795.091377602213362.72796757
    16
    0x284dc764e16a3b2a102a5db963d3a8b478ba4d8a5299975.260088259212048.860304507
    17
    0x488a231c51cc7840b691af027fc91fa0170fdddb175523.117570145209584.194135543
    18
    0x4f4715ca99c973a55303bc4a5f3e3acbb9ff75db9365815.258822872187425.619058545
    19
    0xd7242b48f7ffcd9f4792a1c8749d6b0212ddf8813118814.074191149179815.201220146
    20
    0xf895a840f4869c36c4bf518c426d6d0df85546f5692549.577300233173731.478304841
    ...
    125
    10KB
    2s