select

p.BLOCK_TIMESTAMP::date as date,

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 - 30

group by 1 , 2