par_rnOlas 8
Updated 2025-01-21
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
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
QueryRunArchived: QueryRun has been archived