-- forked from 71c16f52-39bb-4a45-b340-71a2724ea53d with borrows as (select count(*) as p1 , count(distinct borrower_address) as p2 , sum(borrowed_usd) as p3 from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 ) , deposits as (select count(*) as p1 , count(distinct depositor_address) as p2 , sum(supplied_usd) as p3 from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 ) ,borrows_chart as (select count(*) as p1 , count(distinct borrower_address) as p2 , sum(borrowed_usd) as p3 , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 group by d ) , deposits_chart as (select count(*) as p1 , count(distinct depositor_address) as p2 , sum(supplied_usd) as p3 , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 group by d ) , borrows_tokens as (select count(*) as p1 ,count(distinct borrower_address) as p2 , sum(borrowed_usd) as p3 , symbol from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 group by 4 ) , borrows_tokens_chart as (select count(*) as p1 ,count(distinct borrower_address) as p2 , sum(borrowed_usd) as p3 , symbol , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 group by 4 , 5 ) , deposits_tokens as (select count(*) as p1 ,count(distinct depositor_address) as p2 , sum(supplied_usd) as p3 , symbol from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 group by 4 ) , deposits_tokens_chart as (select count(*) as p1 ,count(distinct depositor_address) as p2 , sum(supplied_usd) as p3 , symbol, date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 group by 4 , 5 ) , borrows_count_top10 as (select count(*) as p1 , borrower_address from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 group by 2 order by 1 desc limit 10 ) , borrows_count_top10_chart as (select count(*) as p1 , borrower_address , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 and borrower_address in (select borrower_address from borrows_count_top10) group by 2 , 3 ) , borrows_amount_top10 as (select sum(borrowed_usd) as p1 , borrower_address from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 group by 2 order by 1 desc limit 10 ) , borrows_amount_top10_chart as (select sum(borrowed_usd) as p1 , borrower_address , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_borrows where borrowed_usd < pow(10,15) and borrowed_usd is not null and year(block_timestamp) >= 2022 and borrower_address in (select borrower_address from borrows_amount_top10) group by 2 , 3 ) , deposits_count_top10 as (select count(*) as p1 , depositor_address from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 group by 2 order by 1 desc limit 10 ) , deposits_count_top10_chart as (select count(*) as p1 , depositor_address , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 and depositor_address in (select depositor_address from deposits_count_top10) group by 2 , 3 ) , deposits_amount_top10 as (select sum(supplied_usd) as p1 , depositor_address from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 group by 2 order by 1 desc limit 10 ) , deposits_amount_top10_chart as (select sum(supplied_usd) as p1 , depositor_address , date_trunc('WEEK', block_timestamp) as d from ethereum.aave.ez_deposits where supplied_usd < pow(10,15) and supplied_usd is not null and year(block_timestamp) >= 2022 and depositor_address in (select depositor_address from deposits_amount_top10) group by 2 , 3 ) select 'borrows' as l , p1,p2,p3 from borrows UNION select 'deposits' as l , p1,p2,p3 from deposits

0xmilaad