0xtollexflow 2
    Updated 2024-05-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