par_rnOlas 05
    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 depositor,
    COUNT(DISTINCT TX_HASH) AS transactions,
    SUM(olas_amount) AS total_deposit_olas,
    SUM(olas_amount_usd) AS total_deposit_usd
    FROM
    main
    WHERE
    event_name = 'Deposit'
    GROUP BY
    user
    ORDER BY
    total_deposit_usd DESC


    Last run: about 1 month ago
    DEPOSITOR
    TRANSACTIONS
    TOTAL_DEPOSIT_OLAS
    TOTAL_DEPOSIT_USD
    1
    0x91f1bfd331c499d729abf22abcf605a75b9dd8cd19930728.501329631884380.53514494
    2
    0xcbaf750e27a6efa40f4b98cea00203c1bc92f6628229112.964826514477621.571118436
    3
    0xd69a9068ebc98ca6f27ac92f45ffdce4647199426272710.312196406289445.894926136
    4
    0xc8f7030a4e25585624e2fc792255a547255cd77c1170185.847109262140625.518991224
    5
    0xd7242b48f7ffcd9f4792a1c8749d6b0212ddf881253491.413543135127876.546709842
    6
    0x04213bf67204432a4d7ebc1fadf959e9950b0ea1255853.431086249108355.656307324
    7
    0x2f70a60047a6e3590bcc1d099700fdbe6f058ba6448766.387834835105491.495478386
    8
    0xfa1a1d97329c0b5ccd072f3afcdd64f25306f425347082.656354612101778.655454672
    9
    0x4edb5dd988b78b40e1b38592a4761f694e05ef05127395.5303809768488.825952426
    10
    0xbebb5faa55f519f6f6452e977873f2960c26fa28228241.43420732961892.149212378
    11
    0xa94d1199c5c23e1bb8d5d7cb427c96c5db380524112035.54053349925635.701336353
    12
    0xba95718a52b5a3dba749a7641712dc05a3550d4f313827.64321592223898.253009621
    13
    0xf7547bc0dff96c599fcf258d53945b75847660c715548.7763700945480.740137391
    14
    0xd40ab0d4d21f3586f3277a22cfcd4d9e9b851d6d1532.3982100561011.556599107
    15
    0xecff34c282c48095bb00af2cae746f236f5523a8196.28021339169.812990322
    16
    0xda44d2de6bd275365072c8b557db845dde043e55141.605401382116.495123869
    17
    0x3179996a3a7db9efc3469eb4f35781d68fc17d3d172.38996095699.89814612
    18
    0xdf2317fdb466c952614b35c990f35734a8e0e37816.0852490923.960132296
    19
    0x26c632675ccd53018e4c96dee6420c4956f34c6513.83671835716.798042879
    20
    0xc1572a9cee49965611fb2acea686078894302e9114.0634740095.729498352
    20
    2KB
    2s