Multi-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0ac-71c3-7842-93b3-e471ec12042b | LOW | 2026-09-17 14:41 | other | 4 | 1 | 348 | 2639406.00 | unknown | — | 194.5050 | 10.4000 | ["220","230","240"] | ["1.9303","1.4132","0.6185"] | [] | ["XBOX"] | 220.0000 | 240.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:41:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ac-5a53-7240-b75a-f9057c71697f | LOW | 2026-09-17 14:41 | put_ladder | 5 | 1 | 1708 | 10409640.00 | unknown | — | 194.4900 | 10.1000 | ["207.5","210","212.5","220","240"] | ["1.2075","1.2145","1.4887","1.9238","2.6974"] | [] | ["XBOX"] | 207.5000 | 240.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:41:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a8-010a-7c72-98ac-3ae6b3a8bcad | LOW | 2026-09-17 14:36 | other | 6 | 1 | 916 | 6871980.00 | unknown | — | 194.6100 | 14.6000 | ["220","230","240","260","270"] | ["1.9741","2.3998","2.7599","3.5288","4.1558"] | [] | ["XBOX"] | 220.0000 | 270.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:36:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a5-900b-7f01-967e-a91b028d2016 | LOW | 2026-09-17 14:33 | put_ladder | 3 | 1 | 750 | 5745000.00 | unknown | — | 194.7000 | 6.9000 | ["220","230","240"] | ["0.9508","1.2548","1.5402"] | [] | ["XPHO"] | 220.0000 | 240.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:34:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb6-787b-7863-ac1a-f1fdda89404f | LOW | 2026-09-16 15:34 | put_vertical_spread | 2 | 1 | 333 | 2670660.00 | unknown | — | 194.0236 | 4.0000 | ["230","240"] | ["1.7344","2.0403"] | [] | ["XBOX"] | 230.0000 | 240.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abb3-b18b-7bb2-8b5f-b18fda3ffcfc | LOW | 2026-09-16 15:31 | put_vertical_spread | 2 | 1 | 250 | 2055000.00 | unknown | — | 193.9200 | 4.0000 | ["230","240"] | ["1.0269","1.2478"] | [] | ["XPHO"] | 230.0000 | 240.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:31:25Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba7-3253-7891-9b91-947d435650ab | LOW | 2026-09-16 15:17 | put_vertical_spread | 2 | 1 | 280 | 2178400.00 | unknown | — | 194.0600 | 5.2000 | ["230","240"] | ["1.5332","1.6997"] | [] | ["XBOX"] | 230.0000 | 240.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a697-5735-72c2-8026-22989a10bef6 | LOW | 2026-09-15 15:42 | put_vertical_spread | 2 | 1 | 250 | 1987500.00 | unknown | — | 194.9900 | 4.7000 | ["230","240"] | ["1.3494","1.5606"] | [] | ["XPHO"] | 230.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:42:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a68a-0126-7a81-8e85-f0269e895742 | LOW | 2026-09-15 15:27 | put_vertical_spread | 2 | 1 | 333 | 2570760.00 | unknown | — | 195.3850 | 4.7000 | ["230","240"] | ["1.4549","1.6837"] | [] | ["XBOX"] | 230.0000 | 240.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:27:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a173-74d0-7990-8e11-824b9a1ec809 | LOW | 2026-09-14 15:44 | put_vertical_spread | 2 | 1 | 250 | 1810000.00 | unknown | — | 198.6900 | 5.3000 | ["230","240"] | ["1.0972","1.3195"] | [] | ["XPHO"] | 230.0000 | 240.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:45:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091ea-11e1-7260-805b-0764cb1fb7f8 | LOW | 2026-09-11 15:20 | other | 4 | 1 | 584 | 4057580.00 | unknown | — | 196.8900 | 10.2000 | ["220","230","240"] | ["0.5578","0.7230","0.9067"] | [] | ["XBOX"] | 220.0000 | 240.0000 | 7 | 35 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:20:43Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e4-9f59-7ec0-9e91-fffcb2be06a8 | LOW | 2026-09-11 15:14 | other | 3 | 1 | 260 | 1896800.00 | unknown | — | 196.8600 | 8.3000 | ["230","240"] | ["0.7150","0.8960"] | [] | ["XBOX"] | 230.0000 | 240.0000 | 7 | 35 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:14:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc7-c108-7eb1-adb3-cab6569206b3 | LOW | 2026-09-10 15:24 | put_vertical_spread | 2 | 1 | 600 | 4662000.00 | unknown | — | 195.8925 | 5.9000 | ["230","240"] | ["0.8653","1.0434"] | [] | ["XPHO"] | 230.0000 | 240.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:25:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca5-9ec0-7751-8cc3-920dc34842b1 | LOW | 2026-09-10 14:47 | other | 2 | 1 | 21 | 199920.00 | unknown | — | 196.3230 | 5.9000 | ["240","250"] | ["0.5670","1.2809"] | [] | ["XBOX"] | 240.0000 | 250.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:47:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca0-b8d9-7181-b7d9-caffbaa314b8 | LOW | 2026-09-10 14:42 | other | 6 | 1 | 1708 | 11637900.00 | unknown | — | 196.0600 | 17.3000 | ["207.5","210","220","230","240"] | ["1.2396","1.3573","0.6967","0.6968","1.0701"] | [] | ["XBOX"] | 207.5000 | 240.0000 | 1 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:43:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9e-d090-72c3-a8a3-d737d2eaf9e8 | LOW | 2026-09-10 14:40 | other | 3 | 1 | 682 | 5173360.00 | unknown | — | 196.0850 | 8.9000 | ["230","240"] | ["0.8938","1.0242"] | [] | ["XBOX"] | 230.0000 | 240.0000 | 8 | 36 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:40:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c31-97a0-7c03-8608-483e3ddcab4c | LOW | 2026-09-10 12:40 | strangle | 2 | 2 | 281 | 1517382.00 | long | ask | 196.7150 | 1.5000 | ["210","220"] | ["0.3475","0.2848"] | ["156.00","274.00"] | ["XBOX"] | 210.0000 | 220.0000 | 498 | 498 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:41:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08274-0fe0-7760-b947-375e5f38ae4a | LOW | 2026-09-08 15:17 | other | 4 | 1 | 501 | 3445940.00 | unknown | — | 202.1800 | 11.4000 | ["230","240","300"] | ["0.6187","0.7435","0.4685"] | [] | ["XBOX"] | 230.0000 | 300.0000 | 10 | 129 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:17:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826d-ed91-7c52-a84c-9ca6a3fa5087 | LOW | 2026-09-08 15:10 | put_vertical_spread | 2 | 1 | 390 | 2457000.00 | unknown | — | 202.2400 | 4.8000 | ["230","240"] | ["0.6267","0.7708"] | [] | ["XBOX"] | 230.0000 | 240.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |