CATEGORY_OF_VOLUME | USERS | TRANSACTIONS | |
|---|---|---|---|
1 | $10 - $100 | 9138 | 52766 |
2 | Below $10 | 4146 | 6659 |
3 | $100 - $500 | 201 | 7182 |
4 | $1000 - $10000 | 186 | 1870 |
5 | $10000+ | 128 | 886 |
6 | $500 - $1000 | 103 | 752 |
deevhyncategory of volume
Updated 2025-02-24
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
›
⌄
SELECT CASE
WHEN amount_usd>0 AND amount_usd<=10 THEN 'Below $10'
WHEN amount_usd>10 AND amount_usd<=100 THEN '$10 - $100'
WHEN amount_usd>100 AND amount_usd<=500 THEN '$100 - $500'
WHEN amount_usd>500 AND amount_usd<=1000 THEN '$500 - $1000'
WHEN amount_usd>1000 AND amount_usd<=10000 THEN '$1000 - $10000'
ELSE '$10000+'
END AS category_of_volume,
COUNT(DISTINCT source_address) AS Users,
COUNT(DISTINCT tx_hash) AS Transactions
FROM near.defi.ez_bridge_activity
WHERE date_trunc('day', block_timestamp)>=current_date-100
AND platform = 'rainbow'
GROUP BY category_of_volume
ORDER BY Users DESC
Last run: 2 months ago
6
149B
41s