Query editor
-- Every modeled figure for the chosen snapshot, market, scenario and collateral, by price decline and liquidity condition. For download.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 snapshot, market, scenario, collateral, decline_pct, case liquidity when 'Depth follows price' then 'Depth follows price' when 'Half of depth withdrawn' then 'Half the depth' else 'Ranges stay put' end as liquidity, eligible_accounts, eligible_debt_usd, collateral_held_usd,contract_sized_repayment_usd, contract_sized_seizure_usd, modeled_repayment_usd, collateral_seized_usd, collateral_to_liquidators_usd,protocol_fee_collateral_usd, sale_proceeds_usd, liquidator_profit_usd, stalled_debt_usd, debt_still_below_one_usd, accounts_still_below_one,oracle_value_shortfall_usd, pool_only_recovery_shortfall_usd, liquidations, stock_units_soldfrom dune.paigeisonfire.dataset_stock_market_health_scenarioswhere snapshot = (select snapshot from snap) and ('{{Market}}' = 'All markets' or market = '{{Market}}') and scenario = '{{Scenario}}' and collateral = '{{Collateral}}'order by market, liquidity, decline_pct