when volume < 10 then 'less than 10 UNI'

when volume between 10 and 50 then 'between 10 & 50 UNI'

when volume between 50 and 100 then 'between 50 & 100 UNI'

when volume between 100 and 500 then 'between 100 & 500 UNI'

when volume between 500 and 1000 then 'between 500 & 1K UNI'

when volume between 1000 and 5000 then 'between 1K & 5K UNI'

when volume between 5000 and 10000 then 'between 5K & 10K UNI'

when volume > 10000 then 'more than 10K UNI'

end as type,

count(distinct borrower_address) as borrowers

borrower_address,

sum(borrowed_tokens) as volume,

sum(borrowed_usd) as vol_usd

from ethereum.aave.ez_borrows

where symbol ilike ('UNI')

and aave_version = 'Aave V2'

and block_timestamp::Date >= {{Since}}

and block_timestamp::Date <{{Until}}

group by 1

group by 1