Query editor
-- Un treasury propio de XO tendria pocas contrapartes (los miembros del pool).-- Una hot wallet de CEX tiene miles. Ventana de 1 dia para acotar costo.WITH h AS (SELECT 'HiHaKoKM (destino del barrido)' AS hub, 'IN' AS dir, from_owner AS cp, amount_usdFROM tokens_solana.transfersWHERE block_date = DATE '2026-08-03' AND to_owner = 'HiHaKoKM1vqmydSKwPsxZrWJSLzcif9ZxpSHuR21SCkk'UNION ALLSELECT 'HiHaKoKM (destino del barrido)', 'OUT', to_owner, amount_usdFROM tokens_solana.transfersWHERE block_date = DATE '2026-08-03' AND from_owner = 'HiHaKoKM1vqmydSKwPsxZrWJSLzcif9ZxpSHuR21SCkk'UNION ALLSELECT '5tzFkiKs (fondea al payer)', 'IN', from_owner, amount_usdFROM tokens_solana.transfersWHERE block_date = DATE '2026-08-03' AND to_owner = '5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9'UNION ALLSELECT '5tzFkiKs (fondea al payer)', 'OUT', to_owner, amount_usdFROM tokens_solana.transfersWHERE block_date = DATE '2026-08-03' AND from_owner = '5tzFkiKscXHK5ZXCGbXZxdw7gTjjD1mBwuoFbhUvuAi9')SELECT hub, dir, count(*) AS transfers, count(DISTINCT cp) AS contrapartes,round(sum(amount_usd), 0) AS usd, round(approx_percentile(amount_usd, 0.5), 0) AS medianaFROM h GROUP BY 1, 2 ORDER BY 1, 2