1-- AMM network activity trends
2SELECT 
3    date,
4    amm_amm_count as active_amms,
5    amm_xrp_locked,
6    type_ammcreate as new_pools,
7    type_ammdeposit as deposits
8FROM @xrpscan.xrp_ledger.metrics 
9WHERE date >= '2024-01-01'
10ORDER BY date DESC 
11LIMIT 30;