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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c565-2a66-77a0-aedf-d1ad5f75157c | NOW | 2026-09-21 15:15 | put_vertical_spread | 2 | 1 | 288 | 137952.00 | unknown | bid | 137.3900 | 0.3400 | ["117","122"] | ["0.5713","0.5641"] | ["117.21"] | ["MCRY"] | 117.0000 | 122.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:16:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55e-2d57-7152-9c09-e3ae769d3fd8 | NOW | 2026-09-21 15:07 | put_vertical_spread | 2 | 6 | 700 | 338004.00 | short | bid | 137.1650 | 0.4000 | ["117","122"] | ["0.5698","0.5617"] | ["120.97"] | ["ARCO","EMLD","MCRY","SPHR"] | 117.0000 | 122.0000 | 32 | 32 | true | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:08:14Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c431-7cc7-7f02-8c9e-cbd839d7032a | NOW | 2026-09-21 09:39 | call_vertical_spread | 2 | 2 | 50 | 288000.00 | short | bid | 136.3700 | 1.7000 | ["100","140"] | ["0.6047","0.5584"] | ["125"] | ["XISX"] | 100.0000 | 140.0000 | 116 | 116 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:39:48Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c428-f91d-7ef2-a5e6-8d05db5bd310 | NOW | 2026-09-21 09:30 | call_calendar | 2 | 1 | 1100 | 1310100.00 | long | bid | 136.8200 | 2.3000 | ["150"] | ["0.5781"] | [] | ["XPHO"] | 150.0000 | 150.0000 | 25 | 60 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:30:06Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5f5-8438-77b1-962c-46f419ef6a64 | NOW | 2026-09-18 15:19 | other | 3 | 1 | 60 | 138070.00 | unknown | bid | 136.4900 | 0.8000 | ["148","150","170"] | ["3.7345","0.5442","0.5428"] | [] | ["XISX"] | 148.0000 | 170.0000 | 0 | 119 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:19:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b522-887f-7a72-8e0a-498b1a16feec | NOW | 2026-09-18 11:28 | call_vertical_spread | 2 | 1 | 50 | 257700.00 | unknown | bid | 137.0900 | 0.8000 | ["110","115"] | ["0.5615","0.5355"] | ["138.27"] | ["BATO"] | 110.0000 | 115.0000 | 28 | 28 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:29:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a6a4-2c5e-7133-8c32-a5aee8723ac3 | NOW | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 98 | 224420.00 | long | bid | 141.8300 | 0.4000 | ["125","150"] | ["0.8111","0.5430"] | [] | ["XMIO"] | 125.0000 | 150.0000 | 3 | 31 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:56:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a557-41ce-7743-876f-6b5c56d7614e | NOW | 2026-09-15 09:52 | call_vertical_spread | 2 | 1 | 50 | 106300.00 | short | bid | 141.0800 | 1.0000 | ["130","150"] | ["0.5560","0.5440"] | ["140.10"] | ["XMIO"] | 130.0000 | 150.0000 | 31 | 31 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:53:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a118-cdc9-7270-b568-0977dd8de1a1 | NOW | 2026-09-14 14:05 | call_diagonal_spread | 2 | 1 | 60 | 541680.00 | short | bid | 142.7800 | 0.7500 | ["100","110"] | ["1.4488","0.5928"] | [] | ["XMIO"] | 100.0000 | 110.0000 | 4 | 276 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:06:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-6ee8-7f10-8f3c-86f8d5a6952e | NOW | 2026-09-14 09:41 | call_diagonal_spread | 2 | 1 | 90 | 120600.00 | short | bid | 140.6200 | 0.7000 | ["150","160"] | ["0.5538","0.5917"] | [] | ["BATO"] | 150.0000 | 160.0000 | 32 | 67 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:41:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09182-10e0-7172-a5f7-26c9c329569d | NOW | 2026-09-11 13:26 | call_vertical_spread | 2 | 2 | 97 | 112908.00 | short | bid | 132.8500 | 0.4200 | ["160","200"] | ["0.5496","0.5574"] | ["165.82"] | ["BATO","EDGO"] | 160.0000 | 200.0000 | 126 | 126 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:26:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08293-28d0-7170-a315-981f37c25a37 | NOW | 2026-09-08 15:51 | put_vertical_spread | 2 | 4 | 36 | 200152.00 | short | bid | 134.1200 | 0.7500 | ["140","170"] | ["0.5837","0.5980"] | ["147.8"] | ["ARCO","EMLD","SPHR","XBOX"] | 140.0000 | 170.0000 | 73 | 73 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:51:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08146-0f60-7f60-bbb5-b4afe0a4e243 | NOW | 2026-09-08 09:47 | put_diagonal_spread | 2 | 1 | 219 | 188340.00 | long | bid | 134.2450 | 0.5000 | ["130","138"] | ["0.5734","0.6722"] | [] | ["XISX"] | 130.0000 | 138.0000 | 3 | 10 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:47:33Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dfe-9366-7673-a207-01d67f621b84 | NOW | 2026-09-04 15:56 | put_vertical_spread | 2 | 1 | 300 | 122400.00 | short | bid | 141.0000 | 0.3100 | ["138","145"] | ["5.1417","6.3189"] | ["141"] | ["XISX"] | 138.0000 | 145.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d7c-0586-7602-84ee-cb84c9339b1d | NOW | 2026-09-04 13:33 | put_diagonal_spread_bullish | 2 | 3 | 420 | 567296.00 | short | bid | 141.3850 | 0.5000 | ["133","135"] | ["0.5467","0.5163"] | [] | ["ARCO","EDGO","XISX"] | 133.0000 | 135.0000 | 42 | 49 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:34:11Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |