TOTAL_BONDS | UNIQUE_BONDERS | TOTAL_AMOUNT_USD | TOTAL_REDEEMED_BONDS | TOTAL_DEPOSIT_BONDS | TOTAL_DEPOSITED_USD | TOTAL_REDEEMED_USD | NET_BONDED_USD | |
|---|---|---|---|---|---|---|---|---|
1 | 463 | 133 | 15654379.0315494 | 447 | 16 | 448871.577043561 | 15205507.4545058 | 448871.577043561 |
par_rnOlas 01
Updated 2025-02-15
99
1
2
3
4
5
6
7
8
9
10
11
›
⌄
SELECT
COUNT(DISTINCT TX_HASH) AS total_bonds,
COUNT(DISTINCT ORIGIN_FROM_ADDRESS) AS unique_bonders,
SUM(OLAS_AMOUNT_USD) AS total_amount_usd,
COUNT(DISTINCT CASE WHEN IS_REDEEMED = 'TRUE' THEN TX_HASH END) AS total_redeemed_bonds,
COUNT(DISTINCT CASE WHEN IS_REDEEMED = 'FALSE' THEN TX_HASH END) AS total_deposit_bonds,
SUM(CASE WHEN IS_REDEEMED = 'FALSE' THEN OLAS_AMOUNT_USD END) AS total_deposited_usd,
SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT_USD END) AS total_redeemed_usd,
SUM(OLAS_AMOUNT_USD) - SUM(CASE WHEN IS_REDEEMED = 'TRUE' THEN OLAS_AMOUNT_USD END) AS net_bonded_usd
FROM crosschain.olas.ez_olas_bonding
Last run: about 2 months ago
1
86B
1s