0xtollexflow 2
Updated 2024-05-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
date_trunc(week, block_timestamp) as date,
count(DISTINCT EVENT_DATA:borrower) as Borrower,
count(DISTINCT EVENT_DATA:lender) as lender,
sum(borrower) over (order by date) as Cumulative_borrow,
sum(lender) over (order by date) as Cumulative_lend
FROM flow.core.fact_events
WHERE EVENT_CONTRACT = 'A.5c57f79c6694797f.Flowty' AND EVENT_TYPE = 'FundingAvailable'
AND TX_SUCCEEDED = 'true'
GROUP BY 1
QueryRunArchived: QueryRun has been archived