MLDZMNbond_overtime
Updated 2025-02-16
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
DATE_TRUNC('Month', BLOCK_TIMESTAMP) AS date,
count(distinct tx_hash) as no_bonds,
count(distinct ORIGIN_FROM_ADDRESS) as bonders,
sum(OLAS_AMOUNT) as vol_olas,
sum(OLAS_AMOUNT_USD) as vol_usd,
vol_olas/bonders as avg_olas_per_bonder,
avg(OLAS_AMOUNT) as avg_vol_olas
from crosschain.olas.ez_olas_bonding
group by 1
order by 1 desc
QueryRunArchived: QueryRun has been archived