Crazy_KidNet Bonding Flow
Updated 2022-05-10
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
›
⌄
WITH paid AS (SELECT date_trunc('month',block_timestamp) as month1, sum(asset_usd) as bond_paid
FROM thorchain.bond_actions
WHERE bond_type = 'bond_paid'
GROUP BY month1
ORDER BY month1),
returned AS (SELECT date_trunc('month',block_timestamp) as month2, sum(asset_usd) as bond_returned
FROM thorchain.bond_actions
WHERE bond_type = 'bond_returned'
GROUP BY month2
ORDER BY month2)
SELECT month1 as month, bond_paid, bond_returned
FROM paid JOIN returned ON month1 = month2
Run a query to Download Data