SELECT

date(block_timestamp) as dates,

bond_type,

SUM(asset_amount) as total_asset_amount,

COUNT(DISTINCT from_address) as distinct_address,

CASE

WHEN bond_type = 'bond_paid' THEN SUM(asset_amount)

WHEN bond_type = 'bond_returned' THEN SUM(asset_amount) * -1

END as asset_amount_absolute

FROM thorchain.bond_actions

WHERE (bond_type = 'bond_paid' OR bond_type = 'bond_returned')

AND dates > CURRENT_DATE - 90

GROUP BY dates, bond_type

ORDER BY dates ASC