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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5c7-6b6f-7490-b90a-e53035c3fcf5 | AVGO | 2026-09-18 14:28 | strangle | 2 | 1 | 700 | 2453500.00 | short | bid | 354.1000 | 0.9000 | ["300","400"] | ["0.4129","0.4021"] | ["264.95","435.05"] | ["SPHR"] | 300.0000 | 400.0000 | 154 | 154 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:29:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b510-96bf-7763-8e79-26fd4ce92b27 | AVGO | 2026-09-18 11:09 | straddle | 2 | 1 | 50 | 138250.00 | short | bid | 357.7950 | 0.5000 | ["360"] | ["0.3491"] | ["332.35","387.65"] | ["XBOX"] | 360.0000 | 360.0000 | 28 | 28 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:09:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d2-e9b0-7a92-bc40-508aebd27ab8 | AVGO | 2026-09-18 10:01 | call_vertical_spread | 2 | 1 | 60 | 387840.00 | short | bid | 359.5395 | 3.5000 | ["340","380"] | ["0.4166","0.4149"] | ["359.02"] | ["AMXO"] | 340.0000 | 380.0000 | 91 | 91 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:02:03Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0ac-46cb-7450-af2c-ece20f176514 | AVGO | 2026-09-17 14:41 | put_vertical_spread | 2 | 1 | 310 | 116560.00 | short | bid | 348.1900 | 0.1800 | ["340","350"] | ["0.3793","0.3278"] | ["347"] | ["XBOX"] | 340.0000 | 350.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 |
| 01a0ab05-7be3-7e91-ac7a-dd9aa2547017 | AVGO | 2026-09-16 12:20 | put_vertical_spread | 2 | 1 | 200 | 285200.00 | short | bid | 341.9500 | 0.2600 | ["300","340"] | ["0.3817","0.3564"] | ["329.46"] | ["XBOX"] | 300.0000 | 340.0000 | 30 | 30 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:21:48Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa0-41d3-7cf2-a0e3-7472493ab02b | AVGO | 2026-09-16 10:30 | call_diagonal_spread | 2 | 1 | 500 | 1605000.00 | short | bid | 341.8186 | 0.6000 | ["380","390"] | ["0.4123","0.4029"] | [] | ["SPHR"] | 380.0000 | 390.0000 | 93 | 121 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:30:39Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a66c-a96e-7ed0-bca3-0c10e71ec1ca | AVGO | 2026-09-15 14:55 | synthetic | 2 | 1 | 75 | 609000.00 | short | ask | 340.3250 | 1.5500 | ["350"] | ["0.4159"] | ["346.30"] | ["XBOX"] | 350.0000 | 350.0000 | 185 | 185 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:55:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a091c5-a990-7130-b352-47f6720e574c | AVGO | 2026-09-11 14:40 | strangle | 2 | 1 | 300 | 1159500.00 | short | bid | 364.7550 | 0.7500 | ["360","380"] | ["0.3784","0.3729"] | ["321.35","418.65"] | ["XPHO"] | 360.0000 | 380.0000 | 70 | 70 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:41:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a086ae-71b8-7140-a6d1-31e229258321 | AVGO | 2026-09-09 10:59 | ratio_risk_reversal | 2 | 1 | 200 | 1064000.00 | short | bid | 362.2900 | 3.6500 | ["330","430"] | ["0.4513","0.4486"] | ["313.60"] | ["XBOX"] | 330.0000 | 430.0000 | 281 | 281 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:00:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08297-62d8-7120-8a4f-e71e97946808 | AVGO | 2026-09-08 15:55 | call_vertical_spread | 2 | 1 | 55 | 1031250.00 | short | bid | 367.5100 | 9.0000 | ["420","430"] | ["0.4596","0.4623"] | ["422.50"] | ["SPHR"] | 420.0000 | 430.0000 | 829 | 829 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:56:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0827d-b888-71f0-8279-03340243c4b4 | AVGO | 2026-09-08 15:27 | call_vertical_spread | 2 | 1 | 60 | 1179360.00 | short | bid | 369.2900 | 5.7000 | ["410","420"] | ["0.4608","0.4637"] | ["412.60"] | ["SPHR"] | 410.0000 | 420.0000 | 829 | 829 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:28:30Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826e-ff01-78d2-9969-28acb05e1e68 | AVGO | 2026-09-08 15:11 | call_vertical_spread | 2 | 1 | 2200 | 1669800.00 | short | bid | 368.8400 | 0.3000 | ["410","460"] | ["0.4003","0.4297"] | ["414.71"] | ["XBOX"] | 410.0000 | 460.0000 | 38 | 38 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:12:42Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd2-14c5-7361-ad91-47faf54d7059 | AVGO | 2026-09-04 15:07 | call_vertical_spread | 2 | 1 | 55 | 919380.00 | short | bid | 356.7200 | 3.2000 | ["430","440"] | ["0.4554","0.4570"] | ["432.50"] | ["SPHR"] | 430.0000 | 440.0000 | 833 | 833 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:08:26Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d86-ac15-7ed3-941f-0da0a348c755 | AVGO | 2026-09-04 13:45 | call_calendar | 2 | 1 | 100 | 651000.00 | short | ask | 354.6450 | 1.3000 | ["360"] | ["0.4087"] | [] | ["SPHR"] | 360.0000 | 360.0000 | 105 | 133 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:45:59Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d83-29a5-79a3-bfb2-b80cc6bf6f99 | AVGO | 2026-09-04 13:41 | put_vertical_spread | 2 | 1 | 100 | 117000.00 | short | bid | 355.3700 | 0.7000 | ["352.5","355"] | ["0.3447","0.3426"] | ["353.88"] | ["SPHR"] | 352.5000 | 355.0000 | 7 | 7 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:42:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |