SELECT

t."from" AS address,

t.amount_usd,

DATE_TRUNC('day', t.block_timestamp) AS date

FROM $query('9c34be15-06fc-4ab1-a405-abcb5a2146cc') t

),

daily_totals AS (

SELECT

date,

COUNT(DISTINCT address) AS total_users,

SUM(amount_usd) AS total_amount_usd

FROM ethena_funds

GROUP BY date

SELECT

date,

total_users,

total_amount_usd,

SUM(total_amount_usd) OVER (ORDER BY date) AS cumulative_total_usd,

'Ethena' AS project

FROM daily_totals

ORDER BY date;