sum(Amount) over(order by day) as Cum_Amount,

sum(Amount_USD) over(order by day) as Cum_Amount_USD

from (

select

date_trunc(day, block_timestamp) as day,

COUNT(DISTINCT CASE WHEN unique_user_condition THEN tx2_out END) AS "# Borrowers",

COUNT(DISTINCT CASE WHEN unique_user_condition THEN tx3_out END) AS "# Lenders",

SUM(val2_out) AS amount,

sum(val2_out * price) as Amount_USD,

avg(val2_out) as "Avg Amount (BTC)",

median(val2_out) as "Median Amount (BTC)",

avg(val2_out * price) as "Avg Amount (USD)",

median(val2_out * price) as "Median Amount (USD)"

FROM

(

SELECT

*

FROM

(

SELECT

tx_id,

MAX(block_timestamp) as block_timestamp,

MAX(CASE WHEN input.index = 0 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx1_in,

MAX(CASE WHEN input.index = 1 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx2_in,

MAX(CASE WHEN input.index = 2 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx3_in,

MAX(CASE WHEN input.index = 3 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx4_in,

MAX(CASE WHEN input.index = 4 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx5_in,

MAX(CASE WHEN input.index = 5 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx6_in,

MAX(CASE WHEN input.index = 6 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx7_in,

MAX(CASE WHEN input.index = 7 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx8_in,

MAX(CASE WHEN input.index = 8 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx9_in,

MAX(CASE WHEN input.index = 9 THEN input.PUBKEY_SCRIPT_ADDRESS END) as tx10_in,

MAX(CASE WHEN output.index = 0 THEN output.PUBKEY_SCRIPT_ADDRESS END) as tx1_out,

MAX(CASE WHEN output.index = 0 THEN output.VALUE END) as val1_out,