PapasotFolks Finance borrow pools
    Updated 2023-01-03
    -- Original analyst Sociocrypto
    -- https://app.flipsidecrypto.com/dashboard/borrowing-on-folks-finance-MFjxtO

    SELECT
    date_trunc('day', block_timestamp) as date,
    sum (CASE WHEN tx_message:txn:apid = '686498781' THEN tx_message:dt:itx[0]:txn:amt END)/pow(10,6) as Algo_amnt,
    sum (CASE WHEN tx_message:txn:apid = '694464549' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as gAlgo3_amnt,
    sum (CASE WHEN tx_message:txn:apid = '686500029' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as USDC_amnt,
    sum (CASE WHEN tx_message:txn:apid = '686500844' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as USDt_amnt,
    sum (CASE WHEN tx_message:txn:apid = '686501760' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,8) as goBTC_amnt,
    sum (CASE WHEN tx_message:txn:apid = '694405065' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,8) as goETH_amnt
    --tx_message:txn:apid,
    FROM flipside_prod_db.algorand.transactions
    WHERE TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'b'
    AND tx_message:txn:apid IN ('686498781','694464549', '686500029', '686500844', '686501760', '694405065')

    GROUP BY date

    Run a query to Download Data