KaskoazulBorrowing On Folks - borrow actions
Updated 2022-05-16
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 borrow_txs as (
select distinct tx_group_id
from flipside_prod_db.algorand.transactions
where TRY_BASE64_DECODE_STRING(tx_message:txn:apaa[0]::STRING) = 'b'
),
borrow_amounts as (
select tn.block_timestamp::date as fecha,
tn.tx_group_id,
a.asset_name,
tn.amount,
tn.asset_sender
from flipside_prod_db.algorand.transfers tn
inner join flipside_prod_db.algorand.asset a
on tn.asset_id = a.asset_id
where tn.tx_group_id IN (select tx_group_id from borrow_txs)
and asset_name not like ('Folks%')
),
collateral_amounts as (
select tn.block_timestamp::date as fecha,
tn.tx_group_id,
a.asset_name,
tn.amount,
tn.asset_sender
from flipside_prod_db.algorand.transfers tn
inner join flipside_prod_db.algorand.asset a
on tn.asset_id = a.asset_id
where tn.tx_group_id IN (select tx_group_id from borrow_txs)
and asset_name like ('Folks%')
),
prices as (
select block_hour::date as fecha,
asset_name,
avg (price_usd) as price_usd
Run a query to Download Data