Simplify AnalyticsMulti-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_sidetext | underlying_pricenumeric | bid_ask_spreadnumeric | strikesjsonb | ivsjsonb | breakevensjsonb | uniq_exchangesjsonb | min_strikenumeric | max_strikenumeric | min_dteinteger | max_dteinteger | all_opening_legsboolean | all_otmboolean | diff_expirationsboolean | diff_strikesboolean | diff_typesboolean | codetext | kept_bytext | sourcetext | endpointtext | request_paramsjsonb | as_ofdate | vintage_tstimestamp with time zone | retrieved_attimestamp with time zone |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c433-edc7-7573-8d35-0132160e5b11 | BE | 2026-09-21 09:42 | call_condor | 4 | 1 | 35 | 867545.00 | long | ask | 271.2750 | 12.0500 | ["200","220","260","290"] | ["0.8524","0.8568","0.8435","0.8502"] | ["201.01","278.99"] | ["XISX"] | 200.0000 | 290.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:42:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0a58e-016e-7802-ba32-577577aa2ea3 | BE | 2026-09-15 10:52 | call_condor | 4 | 1 | 15 | 694440.00 | long | ask | 262.6200 | 13.1000 | ["350","370","380","400"] | ["0.8976","0.8945","0.8963","0.8956"] | ["350.62","399.38"] | ["XCBO"] | 350.0000 | 400.0000 | 857 | 857 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:52:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56c-d156-7a11-8df9-5515f0bbef08 | BE | 2026-09-15 10:16 | call_condor | 4 | 1 | 292 | 2536896.00 | long | ask | 267.2600 | 6.2500 | ["220","230","300","320"] | ["0.8858","0.9923","1.0276","1.0735"] | ["228.60","301.40"] | ["XMIO"] | 220.0000 | 320.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:16:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09114-10b8-7640-838f-35b81cae1fff | BE | 2026-09-11 11:26 | call_condor | 4 | 1 | 200 | 495400.00 | unknown | — | 276.4900 | 1.8900 | ["260","270","280","290"] | ["2.3963","1.0382","1.0205","1.1041"] | [] | ["XISX"] | 260.0000 | 290.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:26:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08190-7641-7d70-b809-b2d02777613a | BE | 2026-09-08 11:08 | call_condor | 4 | 1 | 5 | 273570.00 | unknown | — | 273.2700 | 15.3000 | ["130","150","310","350"] | ["0.9434","0.9397","0.9268","0.9285"] | [] | ["XMIO"] | 130.0000 | 350.0000 | 500 | 500 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:08:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |