SOURCE_CHAIN | BONDS | VOL_OLAS | AVG_VOL_OLAS | BONDERS | AVG_BOND_PER_BONDERS | |
|---|---|---|---|---|---|---|
1 | ethereum | 1 | 72.389960956 | 72.389960956 | 1 | 72.389960956 |
2 | base | 7 | 81989.648535694 | 11712.806933671 | 4 | 20497.412133923 |
MLDZMNSource chains
Updated 2025-02-11
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select
p.SOURCE_CHAIN,
count(distinct p.tx_hash) as bonds,
sum(OLAS_AMOUNT) as vol_olas,
avg(OLAS_AMOUNT) as avg_vol_olas,
count(distinct p.ORIGIN_FROM_ADDRESS) as bonders,
vol_olas/bonders as avg_bond_per_bonders
from crosschain.olas.fact_pol_transfers p
left join crosschain.olas.ez_olas_bonding b on b.tx_hash = p.tx_hash
where p.BLOCK_TIMESTAMP >= current_date - 90
group by 1
Last run: about 2 months ago
2
118B
2s