saeedmzn[Olas bonding ] - over time
Updated 2025-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
›
⌄
select date_trunc(month,block_timestamp )::date date ,
count (DISTINCT OWNER_ADDRESS) num_bonders,
count (DISTINCT iff(IS_REDEEMED,OWNER_ADDRESS,NULL) ) num_bond_redeemers ,
count (DISTINCT tx_hash) Total_bonds ,
sum(Total_bonds) over (order by date) cum_bonds ,
sum (OLAS_AMOUNT) Total_bonded_volume ,
sum (iff(IS_REDEEMED ,OLAS_AMOUNT,0)) Total_redeemed_amount ,
Total_bonded_volume - Total_redeemed_amount net_bonded_olas ,
sum (net_bonded_olas) over (order by date ) cum_net_bonded_olas ,
min (OLAS_AMOUNT) min_bonded_amount ,
max (OLAS_AMOUNT) max_bonded_amount ,
median (OLAS_AMOUNT) median_bond_Unbond_amount ,
sum (OLAS_AMOUNT_usd) Total_bonded_volume_usd ,
sum (iff(IS_REDEEMED ,OLAS_AMOUNT_usd,0)) Total_redeemed_amount_usd ,
Total_bonded_volume_usd - Total_redeemed_amount_usd net_bonded_usd ,
sum (net_bonded_usd) over (order by date ) cum_net_bonded_USD ,
min (OLAS_AMOUNT_usd) min_bonded_amount_usd ,
max (OLAS_AMOUNT_usd) max_bonded_amount_usd ,
median (OLAS_AMOUNT_usd) median_bond_Unbond_amount_usd,
from crosschain.olas.ez_olas_bonding
group by 1
QueryRunArchived: QueryRun has been archived