par_rnOlas 02
    Updated 2025-01-21
    SELECT
    DATE_TRUNC('month',BLOCK_TIMESTAMP) AS date,
    COUNT(DISTINCT TX_HASH) AS total_bonds,
    COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_bonders,
    SUM(OLAS_AMOUNT_USD) AS total_amount_usd,
    AVG(OLAS_AMOUNT_USD) AS average_amount_usd,
    SUM(OLAS_AMOUNT) AS total_olas_amount,
    COUNT(DISTINCT CASE WHEN IS_REDEEMED = 'TRUE' THEN TX_HASH END) AS total_redeemed_bonds,
    SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT END) AS total_redeemed_olas,
    SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT_USD END) AS total_redeemed_usd,
    SUM(OLAS_AMOUNT) - SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT END) AS net_bonded_olas,
    SUM(OLAS_AMOUNT_USD) - SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT_USD END) AS net_bonded_usd
    FROM crosschain.olas.ez_olas_bonding
    GROUP BY 1


    Last run: about 1 month ago
    DATE
    TOTAL_BONDS
    UNIQUE_BONDERS
    TOTAL_AMOUNT_USD
    AVERAGE_AMOUNT_USD
    TOTAL_OLAS_AMOUNT
    TOTAL_REDEEMED_BONDS
    TOTAL_REDEEMED_OLAS
    TOTAL_REDEEMED_USD
    NET_BONDED_OLAS
    NET_BONDED_USD
    1
    2023-09-01 00:00:00.0003012598205.35851619419940.178617206608190.59261693829499847.388077912489475.555065421108343.204539026108729.803450773
    2
    2024-11-01 00:00:00.0003916664365.11289070816609.127822268298957.58817732726180108.59381813394860.496778948118848.994359197269504.61611176
    3
    2024-10-01 00:00:00.00085222033399.999556123922.3529359541133692.1779183768926938.6212086541622720.24331696206753.556709717410679.756239138
    4
    2024-12-01 00:00:00.0001611726994.45918881145437.153699301329909.987671602868987.291438131164502.90136994260922.696233471562491.557818872
    5
    2025-01-01 00:00:00.0001199.8981461299.8981461272.3899609560
    6
    2023-08-01 00:00:00.00071281460440.8918644120569.5900262593749726.93475359713749726.934753591460440.8918644100
    7
    2023-10-01 00:00:00.00045171957267.1767150443494.8261492231964935.10878046391741343.000427981724482.40091543223592.108352486232784.775799612
    8
    2023-11-01 00:00:00.000103415421010.2555780952631.1675298842826817.7620757831949669.204857693583047.85162968877148.5572180091837962.4039484
    9
    2024-01-01 00:00:00.0002219683493.25925077131067.87542049114474.23382829821114468.148579208683469.2991184756.0852490923.960132296
    10
    2024-02-01 00:00:00.000108241076.57936273524107.65793627439391.7086824441039391.708682444241076.57936273500
    11
    2024-03-01 00:00:00.0001681339707.2864503283731.705403145292825.7506908715292821.9139725131339690.488407453.83671835716.798042879
    12
    2024-04-01 00:00:00.000128403724.81341595633643.7344513394698.8050922211294698.805092221403724.81341595600
    13
    2024-05-01 00:00:00.000128124588.21111576310382.35092631437655.9951673021137614.38976592124471.71599189441.605401382116.495123869
    14
    2024-09-01 00:00:00.000115.7294983525.7294983524.0634740090
    14
    2KB
    2s