Query editor
-- Pools considered for selling each stock at the snapshot block, whether each was simulated, and the simulation checks.with snap as (select case when '{{Snapshot}}' = 'Latest' then (select max_by(snapshot, block_number) from dune.paigeisonfire.dataset_stock_market_health_snapshots) else '{{Snapshot}}' end as snapshot)select stock, pool, status, coalesce(cast(reason as varchar), '') as reason, fee_pct, usdc_in_pool, stock_in_pool_usd, coalesce(cast(quoter_checks as varchar), '') as quoter_checks, coalesce(cast(swap_replays as varchar), '') as swap_replaysfrom dune.paigeisonfire.dataset_stock_market_health_poolswhere snapshot = (select snapshot from snap) and ('{{Collateral}}' = 'All' or stock = '{{Collateral}}')order by stock, status desc, usdc_in_pool desc