DEPOSIT_SIZE_CATEGORY | USER_COUNT | TOTAL_OLAS_DEPOSITED | TOTAL_USD_DEPOSITED | |
---|---|---|---|---|
1 | ($1,000 - $5,000) | 1 | 532.398210056 | 1011.556599107 |
2 | ($100 - $500) | 2 | 137.885614772 | 286.308114191 |
3 | ($50 - $100) | 1 | 72.389960956 | 99.89814612 |
4 | (< $50) | 3 | 13.985441455 | 46.487673527 |
5 | (> $5,000) | 13 | 1794980.43898846 | 3420971.54377913 |
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
Last run: about 1 month ago
5
238B
1s