damidezdistribution of volume
Updated 2024-10-08
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
WITH rango AS (
SELECT
from_address,
SUM(COALESCE(from_amount_usd, to_amount_usd)) AS volume_usd
FROM thorchain.defi.fact_swaps
WHERE affiliate_address = 'rg'
GROUP BY from_address
)
SELECT
COUNT(DISTINCT from_address) AS Users,
CASE
WHEN volume_usd < 200 THEN '<200'
WHEN volume_usd >= 200 AND volume_usd < 500 THEN '$200-$500'
WHEN volume_usd >= 500 AND volume_usd < 1000 THEN '$500-$1000'
WHEN volume_usd >= 1000 AND volume_usd < 2000 THEN '$1000-$2000'
WHEN volume_usd >= 2000 AND volume_usd < 5000 THEN '$2000-$5000'
WHEN volume_usd >= 5000 THEN '>$5000'
END AS Amount_Category
FROM rango
GROUP BY Amount_Category
ORDER BY Amount_Category;
QueryRunArchived: QueryRun has been archived