Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b616-1fe0-7a82-976f-15b17cee227e | APP | 2026-09-18 15:54 | put_vertical_spread | 2 | 1 | 386 | 384070.00 | unknown | — | 309.6800 | 0.9000 | ["300","305"] | ["0.4785","0.4785"] | [] | ["XISX"] | 300.0000 | 305.0000 | 7 | 7 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:55:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-4117-7ed1-93a7-cd40ca80e6af | APP | 2026-09-18 11:06 | put_vertical_spread | 2 | 1 | 10 | 253570.00 | long | ask | 314.2350 | 10.6000 | ["340","490"] | ["0.6580","0.6841"] | ["374.53"] | ["BATO"] | 340.0000 | 490.0000 | 182 | 182 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b00a-5d93-71c2-bb9e-116f8d300dae | APP | 2026-09-17 11:44 | put_vertical_spread | 2 | 2 | 13 | 157236.00 | unknown | — | 317.6900 | 3.2308 | ["290","360"] | ["0.6644","0.6598"] | [] | ["ARCO","C2OX"] | 290.0000 | 360.0000 | 183 | 183 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:44:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd3-9623-7592-861d-e0cf29db2ae7 | APP | 2026-09-17 10:44 | put_vertical_spread | 2 | 1 | 200 | 115200.00 | short | bid | 316.7450 | 0.9000 | ["295","297.5"] | ["0.5556","0.5510"] | ["297.02"] | ["XMIO"] | 295.0000 | 297.5000 | 8 | 8 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:44:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc9-b644-7e13-9327-bcdd54e00dc1 | APP | 2026-09-16 15:55 | put_vertical_spread | 2 | 3 | 4 | 446628.00 | short | bid | 326.4000 | 27.1000 | ["880","890"] | ["1.1821","1.1954"] | [] | ["ARCO","SPHR"] | 880.0000 | 890.0000 | 121 | 121 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:55:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa92-536b-75f0-a98f-056ff21acc5c | APP | 2026-09-16 10:15 | put_vertical_spread | 2 | 3 | 7 | 101446.00 | long | ask | 325.4000 | 12.4000 | ["260","300"] | ["0.6915","0.6907"] | ["278.72"] | ["ARCO","EMLD","SPHR"] | 260.0000 | 300.0000 | 639 | 639 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:15:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08ce5-a178-7bd1-b080-d2251ebd91f6 | APP | 2026-09-10 15:57 | put_vertical_spread | 2 | 2 | 2 | 314448.00 | unknown | — | 314.4300 | 25.3000 | ["1100","1110"] | ["1.3350","1.3464"] | [] | ["XBOX"] | 1100.0000 | 1110.0000 | 127 | 127 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:57:49Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c81-2ab8-7032-9d95-a8f5206b848d | APP | 2026-09-10 14:07 | put_vertical_spread | 2 | 1 | 200 | 138000.00 | unknown | — | 315.6900 | 1.2000 | ["285","287.5"] | ["0.5554","0.5489"] | [] | ["XMIO"] | 285.0000 | 287.5000 | 15 | 15 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bd6-9aa8-7132-9774-803e0da34008 | APP | 2026-09-10 11:01 | put_vertical_spread | 2 | 1 | 279 | 103230.00 | short | bid | 315.2401 | 0.7000 | ["287.5","290"] | ["0.5652","0.5590"] | ["289.68"] | ["XISX"] | 287.5000 | 290.0000 | 8 | 8 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:01:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b9d-4eb0-7743-b829-ab6520b67f26 | APP | 2026-09-10 09:58 | put_vertical_spread | 2 | 1 | 10 | 102620.00 | short | bid | 310.6708 | 8.7000 | ["240","250"] | ["0.7031","0.6996"] | ["245.50"] | ["BATO"] | 240.0000 | 250.0000 | 498 | 498 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:58:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087be-dc00-7a40-bb0e-21a5e4b01f0e | APP | 2026-09-09 15:57 | put_vertical_spread | 2 | 2 | 2 | 135006.00 | unknown | — | 305.0834 | 19.2500 | ["640","650"] | ["2.5258","2.8555"] | [] | ["ARCO"] | 640.0000 | 650.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:57:24Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087bc-b538-7582-8e45-f20cf9f02179 | APP | 2026-09-09 15:54 | put_vertical_spread | 2 | 1 | 9 | 322236.00 | short | bid | 304.3900 | 11.5000 | ["470","500"] | ["1.6201","1.8003"] | [] | ["ARCO"] | 470.0000 | 500.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:55:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087b9-03e8-7a81-8916-6d37102df846 | APP | 2026-09-09 15:50 | put_vertical_spread | 2 | 1 | 6 | 208956.00 | short | bid | 305.0000 | 17.5000 | ["460","500"] | ["1.8582","2.1252"] | [] | ["ARCO"] | 460.0000 | 500.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:50:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0877a-7c18-7203-8963-4175895c719c | APP | 2026-09-09 14:42 | put_vertical_spread | 2 | 1 | 120 | 153600.00 | long | ask | 305.9200 | 1.2000 | ["295","300"] | ["0.5357","0.5353"] | ["298.10"] | ["ARCO"] | 295.0000 | 300.0000 | 9 | 9 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:42:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0877a-7c18-7203-8963-4162261e03d0 | APP | 2026-09-09 14:42 | put_vertical_spread | 2 | 3 | 240 | 307440.00 | long | ask | 305.9200 | 1.2000 | ["295","300"] | ["0.5360","0.5355"] | ["298.10"] | ["ARCO","C2OX"] | 295.0000 | 300.0000 | 9 | 9 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:42:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0877a-7c18-7203-8963-415377a55816 | APP | 2026-09-09 14:42 | put_vertical_spread | 2 | 3 | 240 | 306960.00 | long | ask | 305.9200 | 1.2500 | ["295","300"] | ["0.5354","0.5350"] | ["298.10"] | ["C2OX","XPHO"] | 295.0000 | 300.0000 | 9 | 9 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:42:57Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08293-8e60-75e0-bdf0-e9d60b04118a | APP | 2026-09-08 15:51 | put_vertical_spread | 2 | 2 | 2 | 226568.00 | unknown | — | 313.2900 | 27.0000 | ["880","890"] | ["1.0570","1.0708"] | [] | ["XBOX"] | 880.0000 | 890.0000 | 129 | 129 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:51:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0828c-f2f8-7000-9e9d-95a7a0526509 | APP | 2026-09-08 15:44 | put_vertical_spread | 2 | 1 | 3 | 183810.00 | short | bid | 313.2700 | 19.2000 | ["610","630"] | ["1.6171","1.7138"] | [] | ["ARCO"] | 610.0000 | 630.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:44:57Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b0-1400-7fd3-a4ad-64868a0af5bc | APP | 2026-09-08 11:43 | put_vertical_spread | 2 | 1 | 100 | 104000.00 | unknown | — | 313.1460 | 1.1000 | ["260","270"] | ["0.5778","0.5723"] | [] | ["XISX"] | 260.0000 | 270.0000 | 38 | 38 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:43:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |