StangFAST002 - action
    Updated 2023-09-20
    with

    final AS
    (
    SELECT
    a.value:"DT"::timestamp AS dt
    , a.value:"TX"::text AS tx
    , a.value:"SG"::text AS sg
    , a.value:"AC"::text AS ac
    , a.value:"AM"::text AS am
    , a.value:"MN"::text AS mn
    , a.value:"SB"::text AS sb
    FROM
    (
    SELECT livequery.live.udf_api( 'https://api.flipsidecrypto.com/api/v2/queries/ef1629cd-cdf1-45c1-837d-107b682cec9e/data/latest' ):"data" AS data
    ) live
    JOIN
    lateral flatten ( input => live.data ) a
    )

    SELECT

    date_trunc( '{{period}}' , a.dt ) AS "date"

    , count( DISTINCT sg ) AS "users"
    , count( DISTINCT tx ) AS "transactions"
    , zeroifnull( sum( am ) ) AS "amount"

    , case
    when a.ac IN ( 'OpenTermLoanDrawdown' , 'LoanDrawdown' ) then 'borrow'
    when a.ac IN ( 'OpenTermLoanFund' , 'LoanFund' ) then 'lend'
    when a.ac IN ( 'OpenTermLoanRepay' , 'LoanMakePayment' ) then 'repay'
    end
    AS "action"

    , sum( "users" ) over ( partition BY "action" ORDER BY "date" ASC ) AS "total users"
    Run a query to Download Data