par_rnOlas 8
    Updated 2025-01-21
    WITH main AS (
    SELECT
    ORIGIN_FROM_ADDRESS AS user,
    BLOCK_TIMESTAMP,
    OLAS_AMOUNT,
    OLAS_AMOUNT_USD
    FROM
    crosschain.olas.ez_olas_bonding
    WHERE
    is_redeemed = 'FALSE'
    ),
    bucketed_users AS (
    SELECT
    user,
    SUM(OLAS_AMOUNT) AS total_deposited_olas,
    SUM(OLAS_AMOUNT_USD) AS total_deposited_usd,
    CASE
    WHEN SUM(OLAS_AMOUNT_USD) < 50 THEN '(< $50)'
    WHEN SUM(OLAS_AMOUNT_USD) BETWEEN 50 AND 100 THEN '($50 - $100)'
    WHEN SUM(OLAS_AMOUNT_USD) BETWEEN 100 AND 500 THEN '($100 - $500)'
    WHEN SUM(OLAS_AMOUNT_USD) BETWEEN 500 AND 1000 THEN '($500 - $1,000)'
    WHEN SUM(OLAS_AMOUNT_USD) BETWEEN 1000 AND 5000 THEN '($1,000 - $5,000)'
    ELSE '(> $5,000)'
    END AS deposit_size_category
    FROM
    main
    GROUP BY
    user
    )
    SELECT
    deposit_size_category,
    COUNT(DISTINCT user) AS user_count,
    SUM(total_deposited_olas) AS total_olas_deposited,
    SUM(total_deposited_usd) AS total_usd_deposited
    FROM
    bucketed_users
    Last run: about 1 month ago
    DEPOSIT_SIZE_CATEGORY
    USER_COUNT
    TOTAL_OLAS_DEPOSITED
    TOTAL_USD_DEPOSITED
    1
    ($1,000 - $5,000)1532.3982100561011.556599107
    2
    ($100 - $500)2137.885614772286.308114191
    3
    ($50 - $100)172.38996095699.89814612
    4
    (< $50)313.98544145546.487673527
    5
    (> $5,000)131794980.438988463420971.54377913
    5
    238B
    1s