Query editor
-- Flujo TW en LiquidMesh: mes x par, ene-2026 -> jul-2026, chains eth/bnb/base.-- Base: query_8218596 (gate directo, swaps limpios + filtro de ANCLA). El ticket-- promedio es vol_in_usd_clean / swaps_clean (la mediana no existe a nivel par:-- la base ya viene agregada por mes x token_in x token_out).with b as (select chain, month, array_join(array_sort(array[coalesce(sym_in, token_in), coalesce(sym_out, token_out)]), ' / ') as pair, swaps_clean as swaps, vol_in_usd_clean as volfrom query_8218596where anchoredand chain in ('ethereum', 'bnb', 'base')and month >= date '2026-01-01' and month < date '2026-08-01'), mp as (select chain, month, pair, sum(swaps) as swaps, sum(vol) as vol from b group by 1, 2, 3), w as (select chain, pair, sum(vol) as vol from mp group by 1, 2), rk as (select chain, pair, row_number() over (partition by chain order by vol desc) as rn from w), lab as (select chain, pair, rn, case when rn <= 15 then pair else '(otros)' end as pair_label from rk), ch as (select chain, sum(vol) as vol_chain from w group by 1), mm as (select mp.chain, mp.month, lab.pair_label, min(lab.rn) as rn_min, sum(mp.swaps) as swaps, sum(mp.vol) as volfrom mp join lab on lab.chain = mp.chain and lab.pair = mp.pairgroup by 1, 2, 3), ww as (select chain, pair_label, min(rn_min) as rn_min, sum(swaps) as swaps, sum(vol) as volfrom mm group by 1, 2)select ww.chain, case when ww.pair_label = '(otros)' then 9999 else ww.rn_min end as rank, ww.pair_label as pair, 'window' as grain, '2026-01..07' as month, ww.swaps, ww.vol as vol_usd, ww.vol / ww.swaps as avg_ticket_usd, 100.0 * ww.vol / ch.vol_chain as share_pct_of_chainfrom ww join ch on ch.chain = ww.chainunion allselect mm.chain, case when mm.pair_label = '(otros)' then 9999 else mm.rn_min end as rank, mm.pair_label as pair, 'month' as grain, date_format(mm.month, '%Y-%m') as month, mm.swaps, mm.vol as vol_usd, mm.vol / mm.swaps as avg_ticket_usd, 100.0 * mm.vol / ch.vol_chain as share_pct_of_chainfrom mm join ch on ch.chain = mm.chainorder by 1, 2, 4 desc, 5