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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d93-90de-7e61-a9a4-ce5ccfa8685a | FXI | 2026-09-04 13:59 | straddle | 2 | 2 | 5000 | 515000.00 | long | ask | 35.7650 | 0.1600 | ["36"] | ["0.1820"] | ["34.97","37.03"] | ["ARCO"] | 36.0000 | 36.0000 | 14 | 14 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:00:05Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06e07-8c45-7793-b0c5-8b2c27b57ab7 | FXI | 2026-09-04 16:06 | put_vertical_spread | 2 | 1 | 3000 | 2082000.00 | short | bid | 35.9200 | 1.2600 | ["39","40"] | ["0.3985","0.5097"] | ["0","39"] | ["XPHO"] | 39.0000 | 40.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:07:16Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0826d-16b8-7070-9755-8584dccae71d | FXI | 2026-09-08 15:09 | put_vertical_spread | 2 | 1 | 2980 | 2711800.00 | unknown | — | 35.0550 | 0.5500 | ["39","40"] | ["0.4990","0.5840"] | [] | ["XBOX"] | 39.0000 | 40.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:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08678-b7d0-7640-ac7c-ebaef5976d57 | FXI | 2026-09-09 10:00 | call_vertical_spread | 2 | 1 | 15000 | 525000.00 | unknown | — | 34.7500 | 0.2100 | ["36","37"] | ["0.2016","0.2095"] | [] | ["AMXO"] | 36.0000 | 37.0000 | 21 | 21 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:01:02Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08ca0-3408-7930-a1ca-d9438211a5bf | FXI | 2026-09-10 14:41 | put_vertical_spread | 2 | 1 | 24460 | 20546400.00 | unknown | — | 34.3650 | 0.6000 | ["38","39"] | ["0.4838","0.5765"] | [] | ["XBOX"] | 38.0000 | 39.0000 | 8 | 8 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:42:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca6-8538-7500-bde4-7195e7807d23 | FXI | 2026-09-10 14:48 | other | 4 | 1 | 15000 | 13040832.00 | unknown | — | 34.3750 | 0.9400 | ["36","37","38","39"] | ["0.7419","0.4138","0.4701","0.5822"] | [] | ["XBOX"] | 36.0000 | 39.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:49:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca6-a090-7770-8bd7-ecebfcc5d7ff | FXI | 2026-09-10 14:48 | put_vertical_spread | 2 | 1 | 5326 | 4473840.00 | unknown | — | 34.3750 | 0.4100 | ["37","40"] | ["0.3939","0.6774"] | [] | ["XBOX"] | 37.0000 | 40.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:49:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a091e3-e7c0-7e11-977f-2a32cc84e6cc | FXI | 2026-09-11 15:13 | other | 3 | 1 | 9480 | 7563600.00 | unknown | — | 34.4850 | 0.7000 | ["38","39","40"] | ["0.5238","0.5487","0.6373"] | [] | ["XBOX"] | 38.0000 | 40.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:13:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a0a5-2c38-70d1-93e1-552d56366009 | FXI | 2026-09-14 11:59 | call_vertical_spread | 2 | 1 | 7900 | 4487200.00 | short | bid | 34.8800 | 1.5900 | ["34","40"] | ["0.2210","0.2062"] | ["36.62"] | ["SPHR"] | 34.0000 | 40.0000 | 368 | 368 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:00:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a6-f928-7823-afab-67dc8fc01a62 | FXI | 2026-09-14 12:01 | call_vertical_spread | 2 | 1 | 7720 | 3983520.00 | short | bid | 34.8650 | 1.5800 | ["35","40"] | ["0.2196","0.2089"] | ["37.04"] | ["SPHR"] | 35.0000 | 40.0000 | 368 | 368 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:01:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0c0-f198-7e31-a781-3224ef4259ee | FXI | 2026-09-14 12:29 | call_calendar | 2 | 1 | 1000 | 102000.00 | unknown | — | 34.9050 | 0.2100 | ["35"] | ["0.1925"] | [] | ["AMXO"] | 35.0000 | 35.0000 | 11 | 18 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:30:09Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0e3-8140-7081-8a6e-097219b604cb | FXI | 2026-09-14 13:07 | call_vertical_spread | 2 | 1 | 10000 | 265000.00 | unknown | — | 34.9450 | 0.1400 | ["36","37"] | ["0.1879","0.2038"] | [] | ["XPHO"] | 36.0000 | 37.0000 | 16 | 16 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:07:39Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0b0a2-6b5b-70e0-97a3-a6359fecf966 | FXI | 2026-09-17 14:30 | other | 4 | 1 | 15000 | 8332600.00 | unknown | — | 34.2100 | 4.7500 | ["36","38","40"] | ["0.6440","1.2953","2.5467"] | [] | ["XBOX"] | 36.0000 | 40.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:30:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a2-7ee3-7781-80a7-7c8cce9cdd6e | FXI | 2026-09-17 14:30 | put_vertical_spread | 2 | 1 | 1005 | 735660.00 | unknown | — | 34.2100 | 0.5200 | ["35.5","40"] | ["0.7420","2.0350"] | [] | ["XBOX"] | 35.5000 | 40.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:30:58Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0a3-943b-7f31-9754-56665ff4e960 | FXI | 2026-09-17 14:31 | put_ladder | 3 | 1 | 5000 | 4816000.00 | unknown | — | 34.2150 | 0.5000 | ["38","39","40"] | ["1.3155","1.5611","1.8294"] | [] | ["XBOX"] | 38.0000 | 40.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:31:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ec-0eeb-7640-a22f-9c455f7be352 | FXI | 2026-09-17 15:50 | put_diagonal_spread | 2 | 2 | 5846 | 192644.00 | unknown | — | 34.1750 | 1.1000 | ["27","28"] | ["0.2685","0.2592"] | [] | ["AMXO"] | 27.0000 | 28.0000 | 92 | 183 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:51:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |