Deposit Range | Number of Deposits | Total Amount in Range | Unique Users in Range | |
|---|---|---|---|---|
1 | 0-100 LRON | 847 | 20618.675547 | 615 |
2 | 100-500 LRON | 496 | 74290.291531 | 439 |
3 | 500-1000 LRON | 85 | 53491.668 | 73 |
4 | 1000-5000 LRON | 138 | 240360.259 | 122 |
5 | 5000+ LRON | 64 | 4353472.035 | 47 |
superflyconservative-tan
Updated 2025-04-02
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
deposits AS (
SELECT
decoded_log:assets::int / 1e18 as deposit_amount,
origin_from_address as user_address
FROM ronin.core.ez_decoded_event_logs
WHERE
contract_address = LOWER('0xcad9e7aa2c3ef07bad0a7b69f97d059d8f36edd2')
AND event_name = 'Deposit'
),
deposit_distribution AS (
SELECT
CASE
WHEN deposit_amount < 100 THEN '0-100 LRON'
WHEN deposit_amount < 500 THEN '100-500 LRON'
WHEN deposit_amount < 1000 THEN '500-1000 LRON'
WHEN deposit_amount < 5000 THEN '1000-5000 LRON'
ELSE '5000+ LRON'
END as deposit_range,
COUNT(*) as deposit_count,
SUM(deposit_amount) as total_amount,
COUNT(DISTINCT user_address) as unique_users
FROM deposits
GROUP BY 1
)
SELECT
deposit_range as "Deposit Range",
deposit_count as "Number of Deposits",
total_amount as "Total Amount in Range",
unique_users as "Unique Users in Range"
FROM deposit_distribution
ORDER BY
CASE deposit_range
WHEN '0-100 LRON' THEN 1
WHEN '100-500 LRON' THEN 2
WHEN '500-1000 LRON' THEN 3
Last run: 13 days ago
5
180B
3s