mercury05-distribution depositors based on deposited volume
Updated 2023-09-01Copy Reference Fork
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 deposit_groups AS (
SELECT
depositor_address depositor,
SUPPLIED_USD,
CASE
WHEN SUPPLIED_USD < 1 THEN '01- Deposited_Volume<1'
WHEN SUPPLIED_USD >= 1 AND SUPPLIED_USD <= 5 THEN '02- 1<=Deposited_Volume<=5'
WHEN SUPPLIED_USD > 5 AND SUPPLIED_USD <= 10 THEN '03- 5<Deposited_Volume<=10'
WHEN SUPPLIED_USD > 10 AND SUPPLIED_USD <= 50 THEN '04- 10<Deposited_Volume<=50'
WHEN SUPPLIED_USD > 50 AND SUPPLIED_USD <= 100 THEN '05- 50<Deposited_Volume<=100'
WHEN SUPPLIED_USD > 100 AND SUPPLIED_USD <= 500 THEN '06- 100<Deposited_Volume<=500'
WHEN SUPPLIED_USD > 500 AND SUPPLIED_USD <= 1000 THEN '07- 500<Deposited_Volume<=1,000'
WHEN SUPPLIED_USD > 1000 AND SUPPLIED_USD <= 2500 THEN '08- 1,000<Deposited_Volume<=2,500'
WHEN SUPPLIED_USD > 2500 AND SUPPLIED_USD <= 5000 THEN '09- 2,500<Deposited_Volume<=5,000'
WHEN SUPPLIED_USD > 5000 AND SUPPLIED_USD <= 10000 THEN '10- 5,000<Deposited_Volume<=10,000'
WHEN SUPPLIED_USD > 10000 AND SUPPLIED_USD <= 25000 THEN '11- 10,000<Deposited_Volume<=25,000'
WHEN SUPPLIED_USD > 25000 AND SUPPLIED_USD <= 50000 THEN '12- 25,000<Deposited_Volume<=50,000'
WHEN SUPPLIED_USD > 50000 AND SUPPLIED_USD <= 75000 THEN '13- 50,000<Deposited_Volume<=75,000'
WHEN SUPPLIED_USD >75000 AND SUPPLIED_USD <=100000 THEN '14- 75,000<Deposited_Volume<=100,0000'
WHEN SUPPLIED_USD >100000 AND SUPPLIED_USD <=250000 THEN '15- 100,000<Deposited_Volume<=250,000'
WHEN SUPPLIED_USD >250000 AND SUPPLIED_USD <=500000 THEN '16- 250,000<Deposited_Volume<=500,000'
WHEN SUPPLIED_USD >500000 AND SUPPLIED_USD <=750000 THEN '17- 500,000<Deposited_Volume<=750,0000'
WHEN SUPPLIED_USD >750000 AND SUPPLIED_USD <=1000000 THEN '18- 750,000<Deposited_Volume<=1,000,000'
WHEN SUPPLIED_USD >1000000 AND SUPPLIED_USD <=1500000 THEN '19- 1,000,000<Deposited_Volume<=1,500,000'
WHEN SUPPLIED_USD >1500000 AND SUPPLIED_USD <=2000000 THEN '20- 1,500,000<Deposited_Volume<=2,000,000'
WHEN SUPPLIED_USD >2000000 AND SUPPLIED_USD <=2500000 THEN '21- 2,000,000<Deposited_Volume<=2,500,000'
WHEN SUPPLIED_USD >2500000 AND SUPPLIED_USD <=3000000 THEN '22- 2,500,000<Deposited_Volume<=3,000,000'
WHEN SUPPLIED_USD >3000000 AND SUPPLIED_USD <=3500000 THEN '23- 3,000,000<Deposited_Volume<=3,500,000'
WHEN SUPPLIED_USD >3500000 AND SUPPLIED_USD <=4000000 THEN '24- 3,500,000<Deposited_Volume<=4,000,000'
ELSE '25- Deposited_Volume>4,000,000'
END AS Deposit_Group
FROM ethereum.aave.ez_deposits
WHERE BLOCK_TIMESTAMP >= DATEADD(month, -1*{{Month}}, CURRENT_DATE)
)
SELECT Deposit_Group,
COUNT(DISTINCT Depositor) AS Number_of_Depositors,
Run a query to Download Data