par_rnOlas 03
    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
    DATE_TRUNC('month',BLOCK_TIMESTAMP) AS date,
    event_name,
    COUNT(DISTINCT TX_HASH) AS total_transactions,
    COUNT(DISTINCT user) AS unique_users,
    SUM(OLAS_AMOUNT) AS total_volume_olas,
    AVG(OLAS_AMOUNT) AS average_volume_olas,
    SUM(OLAS_AMOUNT_USD) AS total_volume_usd,
    AVG(OLAS_AMOUNT_USD) AS average_volume_usd,
    MAX(OLAS_AMOUNT_USD) AS max_volume_usd,
    SUM(CASE WHEN event_name = 'Redeem' THEN olas_amount END) AS total_redeemed_olas,
    SUM(CASE WHEN event_name = 'Redeem' THEN olas_amount_usd END) AS total_redeemed_usd,
    SUM(CASE WHEN event_name = 'Deposit' THEN olas_amount END) AS total_deposit_olas,
    SUM(CASE WHEN event_name = 'Deposit' THEN olas_amount_usd END) AS total_deposit_usd
    FROM
    main
    GROUP BY
    1,2
    ORDER BY
    1

    Last run: about 1 month ago
    DATE
    EVENT_NAME
    TOTAL_TRANSACTIONS
    UNIQUE_USERS
    TOTAL_VOLUME_OLAS
    AVERAGE_VOLUME_OLAS
    TOTAL_VOLUME_USD
    AVERAGE_VOLUME_USD
    MAX_VOLUME_USD
    TOTAL_REDEEMED_OLAS
    TOTAL_REDEEMED_USD
    TOTAL_DEPOSIT_OLAS
    TOTAL_DEPOSIT_USD
    1
    2023-08-01 00:00:00.000Redeem71283749726.9347535952813.0554190651460440.8918644120569.590026259103710.6749934333749726.934753591460440.89186441
    2
    2023-09-01 00:00:00.000Redeem2911499847.38807791217236.116830273489475.55506542116878.46741604990787.967525837499847.388077912489475.555065421
    3
    2023-09-01 00:00:00.000Deposit11108343.204539027108343.204539027108729.803450773108729.803450773108729.803450773108343.204539027108729.803450773
    4
    2023-10-01 00:00:00.000Redeem39151741343.0004279844649.8205237941724482.4009154344217.49745937225905.0190096331741343.000427981724482.40091543
    5
    2023-10-01 00:00:00.000Deposit62223592.10835248637265.351392081232784.77579961238797.46263326979821.661143398223592.108352486232784.775799612
    6
    2023-11-01 00:00:00.000Deposit203877148.55721800943857.42786091837962.403948491898.12019742289379.737778564877148.5572180091837962.4039484
    7
    2023-11-01 00:00:00.000Redeem83401949669.2048576923489.9904199723583047.8516296843169.251224454242596.1401391921949669.204857693583047.85162968
    8
    2024-01-01 00:00:00.000Redeem2118114468.1485792085450.864218058683469.29911847532546.15710088302282.95301248114468.148579208683469.299118475
    9
    2024-01-01 00:00:00.000Deposit116.085249096.0852490923.96013229623.96013229623.9601322966.0852490923.960132296
    10
    2024-02-01 00:00:00.000Redeem10839391.7086824443939.170868244241076.57936273524107.65793627459542.5262717439391.708682444241076.579362735
    11
    2024-03-01 00:00:00.000Redeem157292821.91397251319521.4609315011339690.4884074589312.699227163222980.043041142292821.9139725131339690.48840745
    12
    2024-03-01 00:00:00.000Deposit113.8367183573.83671835716.79804287916.79804287916.7980428793.83671835716.798042879
    13
    2024-04-01 00:00:00.000Redeem12894698.8050922217891.567091018403724.81341595633643.73445133184650.86703393494698.805092221403724.813415956
    14
    2024-05-01 00:00:00.000Deposit1141.60540138241.605401382116.495123869116.495123869116.49512386941.605401382116.495123869
    15
    2024-05-01 00:00:00.000Redeem11737614.389765923419.48997872124471.71599189411315.61054471825067.95530645237614.38976592124471.715991894
    16
    2024-09-01 00:00:00.000Deposit114.0634740094.0634740095.7294983525.7294983525.7294983524.0634740095.729498352
    17
    2024-10-01 00:00:00.000Redeem6820926938.62120865413631.4503118921622720.2433169623863.53298995595970.854143592926938.6212086541622720.24331696
    18
    2024-10-01 00:00:00.000Deposit176206753.55670971712161.973924101410679.75623913824157.63271994996999.991083754206753.556709717410679.756239138
    19
    2024-11-01 00:00:00.000Deposit135118848.9943591979142.230335323269504.6161117620731.12431628967488.783280483118848.994359197269504.61611176
    20
    2024-11-01 00:00:00.000Redeem2613180108.593818136670.688659931394860.49677894814624.46284366566685.317644985180108.59381813394860.496778948
    23
    4KB
    2s