PapasotFolks Finance total net deposit pools
Updated 2022-06-30
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
›
⌄
-- Original analyst Sociocrypto
-- https://app.flipsidecrypto.com/dashboard/borrowing-on-folks-finance-MFjxtO
with deposit as(
SELECT
--date_trunc('day', block_timestamp) as date,
sum (CASE WHEN tx_message:txn:apid = '686498781' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as Algo_amnt_dep,
sum (CASE WHEN tx_message:txn:apid = '694464549' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as gAlgo3_amnt_dep,
sum (CASE WHEN tx_message:txn:apid = '686500029' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as USDC_amnt_dep,
sum (CASE WHEN tx_message:txn:apid = '686500844' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as USDt_amnt_dep,
sum (CASE WHEN tx_message:txn:apid = '686501760' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,8) as goBTC_amnt_dep,
sum (CASE WHEN tx_message:txn:apid = '694405065' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,8) as goETH_amnt_dep
--tx_message:txn:apid,
FROM flipside_prod_db.algorand.transactions
WHERE TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'd'
AND tx_message:txn:apid IN ('686498781','694464549', '686500029', '686500844', '686501760', '694405065')
--GROUP BY date
),
redeems as(
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_red,
sum (CASE WHEN tx_message:txn:apid = '694464549' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as gAlgo3_amnt_red,
sum (CASE WHEN tx_message:txn:apid = '686500029' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as USDC_amnt_red,
sum (CASE WHEN tx_message:txn:apid = '686500844' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,6) as USDt_amnt_red,
sum (CASE WHEN tx_message:txn:apid = '686501760' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,8) as goBTC_amnt_red,
sum (CASE WHEN tx_message:txn:apid = '694405065' THEN tx_message:dt:itx[0]:txn:aamt END)/pow(10,8) as goETH_amnt_red
--tx_message:txn:apid,
FROM flipside_prod_db.algorand.transactions
WHERE TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'r'
AND tx_message:txn:apid IN ('686498781','694464549', '686500029', '686500844', '686501760', '694405065')
)
select
Algo_amnt_dep - Algo_amnt_red,
Run a query to Download Data