mercury05-distribution depositors based on deposited volume
    Updated 2023-09-01
    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