KaskoazulAlgofi TVL released
    Updated 2022-11-08
    with raw_txs_provide_ALGO as (
    select txs.block_timestamp as fecha,
    txs.tx_group_id,
    txs.tx_id,
    case txs.tx_message:txn:apid
    when 465814065 then 'ALGO'
    --when 465814103 then 'USDC'
    --when 465814149 then 'goBTC'
    --when 465814222 then 'goETH'
    --when 465814278 then 'STBL'
    when 465814318 then 'VAULT'
    else null
    end as lending_pool,
    pt.asset_id,
    pt.amount
    from flipside_prod_db.algorand.application_call_transaction txs
    left join algorand.payment_transaction pt
    on txs.tx_group_id = pt.tx_group_id
    where lending_pool is not null
    and try_base64_decode_string(txs.tx_message:txn:note::string) = 'Market: mt'
    ),

    raw_txs_provide_ASA as (
    select txs.block_timestamp as fecha,
    txs.tx_group_id,
    txs.tx_id,case txs.tx_message:txn:apid
    --when 465814065 then 'ALGO'
    when 465814103 then 'USDC'
    when 465814149 then 'goBTC'
    when 465814222 then 'goETH'
    when 465814278 then 'STBL'
    --when 465814318 then 'VAULT'
    else null
    end as lending_pool,
    att.asset_id,
    att.asset_amount / pow (10, a.decimals) as amount
    Run a query to Download Data