"Platform",

"Date",

"Timeline",

sum("Number of Transaction") as "Number of Transaction",

sum("Cumulative Number of Transactions") as "Cumulative Number of Transactions",

sum("Number of Users") as "Number of Users",

("Number of Transaction"/"Number of Users") as "Average Number of Txs per User",

sum("Days Order") as

from (SELECT

'AAVE' as "Platform",

date_trunc('day', block_timestamp::date) as "Date",

case

when "Date" >= '2022-12-16' and "Date" < '2023-01-01' then 'First Time Period'

else 'Second Time Period (Target)' end as "Timeline",

count(distinct TX_HASH) as "Number of Transaction",

sum("Number of Transaction") over (partition by "Platform" order by "Date") as "Cumulative Number of Transactions",

count(distinct BORROWER_ADDRESS) as "Number of Users",

("Number of Transaction"/"Number of Users") as "Average Number of Txs per User",

ROW_number () over (partition by "Platform" order by "Date") as "Days Order"

FROM ethereum.aave.ez_borrows

WHERE block_timestamp >= '2022-12-16'

and block_timestamp <= '2023-01-17'

GROUP by 1 , 2 , 3

order by 2 , 1)

union

(SELECT

'AAVE' as "Platform",

date_trunc('day', block_timestamp::date) as "Date",

case

when "Date" >= '2022-12-16' and "Date" < '2023-01-01' then 'First Time Period'

else 'Second Time Period (Target)' end as "Timeline",

count(distinct TX_HASH) as "Number of Transaction",

sum("Number of Transaction") over (partition by "Platform" order by "Date") as "Cumulative Number of Transactions",

count(distinct DEPOSITOR_ADDRESS) as "Number of Users",

("Number of Transaction"/"Number of Users") as "Average Number of Txs per User",