mohammadh0000000000000000000000000000
Updated 2022-06-02
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
›
⌄
with algofi_groupids as (
select
tx_group_id,
try_base64_decode_string(tx_message:txn:note::string) as message,
tx_message:txn:apid as app_id,
CASE
when asset_id='31566704' then 'USDC'
when asset_id='312769' then 'USDT'
when asset_id='2757561' then 'rUSD'
when asset_id='465865291' then 'STBL'
END as asset_name,
CASE
WHEN message = 'Market: mt' THEN 'Providing'
WHEN message = 'Market: rcu' THEN 'Withdrawing'
WHEN message = 'Market: b' THEN 'Borrowing'
WHEN message = 'Market: rb' THEN 'Repaying'
END as liquidity_type
from algorand.transactions
where app_id in ('465814065','465814103','465814149','465814222','465814278')
and message in ('Market: mt', 'Market: rcu', 'Market: b', 'Market: rb')
and block_timestamp::date between '2021-12-17' and '2022-02-01'
),
liquidity_txns as (
select
g.asset_name,
g.liquidity_type,
t.block_timestamp,
t.sender,
CASE
WHEN t.tx_message:txn:amt is not null THEN t.tx_message:txn:amt/pow(10,6) -- providing repaying ALGO
WHEN t.tx_message:txn:aamt is not null THEN t.tx_message:txn:aamt/pow(10,6) -- providing repaying Non-ALGO
WHEN t.tx_message:dt:itx[0]:txn:amt is not null THEN t.tx_message:dt:itx[0]:txn:amt/pow(10,6) -- withdrawing borrowing ALGO
WHEN t.tx_message:dt:itx[0]:txn:aamt is not null THEN t.tx_message:dt:itx[0]:txn:aamt/pow(10,6) -- withdrawing borrowing Non-ALGO
END as amount
-- t.*
from algorand.transactions t
Run a query to Download Data