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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08154-e441-7f43-b61b-3ed28a14fe56 | DIA | 2026-09-08 10:03 | call_diagonal_spread | 2 | 1 | 6 | 38748.00 | short | ask | 528.1900 | 1.0500 | ["495","500"] | ["0.3615","0.1337"] | [] | ["XMIO"] | 495.0000 | 500.0000 | 3 | 38 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08154-eff8-7a22-a572-61b218444057 | DIA | 2026-09-08 10:03 | call_diagonal_spread | 2 | 1 | 102 | 657492.00 | short | ask | 528.1500 | 1.0000 | ["495","500"] | ["0.3530","0.1328"] | [] | ["XMIO"] | 495.0000 | 500.0000 | 3 | 38 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:03:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08b90-cb90-7700-b523-1560904da581 | DIA | 2026-09-10 09:45 | call_diagonal_spread | 2 | 1 | 3 | 54528.00 | short | ask | 522.1600 | 9.3000 | ["460","500"] | ["0.1482","0.1478"] | [] | ["XPHO"] | 460.0000 | 500.0000 | 498 | 827 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:45:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a09196-4c90-7783-b271-152d6249ae8b | DIA | 2026-09-11 13:48 | call_diagonal_spread | 2 | 1 | 10 | 46250.00 | long | ask | 526.5850 | 4.2000 | ["525","530"] | ["0.1482","0.1339"] | [] | ["ARCO"] | 525.0000 | 530.0000 | 126 | 189 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:49:38Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a03c-c5a9-7e01-95cc-e9c333f4a237 | DIA | 2026-09-14 10:05 | call_diagonal_spread | 2 | 1 | 5 | 47145.00 | short | ask | 525.0000 | 6.2000 | ["470","530"] | ["0.2130","0.1341"] | [] | ["XISX"] | 470.0000 | 530.0000 | 95 | 276 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:05:53Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a572-3c0e-7060-be2f-47e22ac612b0 | DIA | 2026-09-15 10:21 | call_diagonal_spread | 2 | 1 | 6 | 86124.00 | unknown | — | 519.6900 | 3.0500 | ["440","470"] | ["0.7920","0.1769"] | [] | ["XISX"] | 440.0000 | 470.0000 | 3 | 185 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:22:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5d7-3f6e-77c3-a3fa-0175f4b911d5 | DIA | 2026-09-15 12:12 | call_diagonal_spread | 2 | 2 | 4 | 68508.00 | unknown | — | 519.6407 | 1.7500 | ["435","440"] | ["0.7835","0.2006"] | [] | ["AMXO","XISX"] | 435.0000 | 440.0000 | 3 | 122 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:12:30Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5de-4836-7bb1-bd65-5458ad2d4405 | DIA | 2026-09-15 12:20 | call_diagonal_spread | 2 | 1 | 2 | 34168.00 | unknown | — | 519.7300 | 2.9500 | ["435","440"] | ["0.8007","0.1862"] | [] | ["XISX"] | 435.0000 | 440.0000 | 3 | 122 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:20:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5ff-35e6-79b0-95c9-a748fc0646c2 | DIA | 2026-09-15 12:55 | call_diagonal_spread | 2 | 1 | 2 | 34650.00 | long | ask | 521.0000 | 3.6000 | ["435","440"] | ["0.8423","0.1897"] | [] | ["XMIO"] | 435.0000 | 440.0000 | 3 | 122 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:56:14Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aa8a-354b-7330-8569-95f9e86ed8f9 | DIA | 2026-09-16 10:06 | call_diagonal_spread | 2 | 1 | 5 | 72540.00 | short | ask | 520.3500 | 2.4000 | ["440","470"] | ["0.9506","0.1603"] | [] | ["XCBO"] | 440.0000 | 470.0000 | 2 | 184 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:06:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa8c-e0e3-76b0-89d5-3f33acf6b2d3 | DIA | 2026-09-16 10:09 | call_diagonal_spread | 2 | 1 | 4 | 58192.00 | short | bid | 520.2050 | 4.1500 | ["450","465"] | ["0.8769","0.1565"] | [] | ["ARCO"] | 450.0000 | 465.0000 | 2 | 274 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:09:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa6-6424-7311-9a51-358b74657be4 | DIA | 2026-09-16 10:37 | call_diagonal_spread | 2 | 1 | 5 | 41005.00 | short | bid | 520.0900 | 1.9000 | ["480","490"] | ["0.4541","0.1524"] | [] | ["AMXO"] | 480.0000 | 490.0000 | 2 | 121 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:37:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa6-603b-74b3-8f71-b78c80764a43 | DIA | 2026-09-16 10:37 | call_diagonal_spread | 2 | 1 | 5 | 41075.00 | short | bid | 520.0900 | 2.1000 | ["480","490"] | ["0.5064","0.1534"] | [] | ["BATO"] | 480.0000 | 490.0000 | 2 | 121 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:37:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaa6-603b-74b3-8f71-b774a24c96a2 | DIA | 2026-09-16 10:37 | call_diagonal_spread | 2 | 1 | 5 | 41075.00 | short | bid | 520.0900 | 3.1000 | ["480","490"] | ["0.5064","0.1534"] | [] | ["EMLD"] | 480.0000 | 490.0000 | 2 | 121 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:37:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaae-72a3-7770-87e2-908ee8a436b2 | DIA | 2026-09-16 10:45 | call_diagonal_spread | 2 | 1 | 75 | 1332150.00 | long | bid | 520.6650 | 4.3500 | ["370","499"] | ["1.9700","0.1536"] | [] | ["SPHR"] | 370.0000 | 499.0000 | 2 | 44 | true | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:46:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaee-9884-7b33-af19-62c061326fdd | DIA | 2026-09-16 11:55 | call_diagonal_spread | 2 | 1 | 4 | 27768.00 | long | ask | 521.6162 | 8.2000 | ["525","530"] | ["0.1346","0.1420"] | [] | ["XISX"] | 525.0000 | 530.0000 | 196 | 457 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:56:33Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab1a-57ba-7440-bdad-c2c5a4a4999d | DIA | 2026-09-16 12:43 | call_diagonal_spread | 2 | 1 | 2 | 25280.00 | long | ask | 520.9800 | 9.2000 | ["520","535"] | ["0.1419","0.1400"] | [] | ["XMIO"] | 520.0000 | 535.0000 | 639 | 821 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:43:46Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-f6b3-7363-b927-b32b9b43fda4 | DIA | 2026-09-16 13:54 | call_diagonal_spread | 2 | 1 | 52 | 66300.00 | short | ask | 521.6450 | 0.3000 | ["515","520"] | ["0.1862","0.1280"] | [] | ["XISX"] | 515.0000 | 520.0000 | 2 | 9 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:55:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5a-fa9b-7023-b6b0-d7ae2077ec4f | DIA | 2026-09-16 13:54 | call_diagonal_spread | 2 | 2 | 26 | 29484.00 | long | bid | 521.6600 | 0.4000 | ["516","521"] | ["0.1835","0.1269"] | [] | ["EMLD","XMIO"] | 516.0000 | 521.0000 | 2 | 9 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:55:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abbf-9c53-7942-9825-4a05a1a55266 | DIA | 2026-09-16 15:44 | call_diagonal_spread | 2 | 2 | 20 | 61470.00 | unknown | — | 513.8000 | 1.3750 | ["500","517"] | ["0.1497","0.1579"] | [] | ["XISX"] | 500.0000 | 517.0000 | 2 | 121 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:44:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aff9-ac23-7e81-9551-49a89676573b | DIA | 2026-09-17 11:26 | call_diagonal_spread | 2 | 1 | 2 | 31124.00 | unknown | — | 517.9700 | 2.0000 | ["440","445"] | ["1.3675","0.1889"] | [] | ["XISX"] | 440.0000 | 445.0000 | 1 | 92 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:26:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b05e-ab9b-7830-ae56-18f2e653d8ac | DIA | 2026-09-17 13:16 | call_diagonal_spread | 2 | 1 | 6 | 54372.00 | short | ask | 518.4000 | 3.5500 | ["460","500"] | ["1.0160","0.1417"] | [] | ["ARCO"] | 460.0000 | 500.0000 | 1 | 120 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:16:54Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b06a-cd13-7a93-bc0a-ec3f819e44ac | DIA | 2026-09-17 13:29 | call_diagonal_spread | 2 | 1 | 3 | 32475.00 | long | bid | 518.2288 | 2.0000 | ["450","490"] | ["1.1157","0.1498"] | [] | ["XMIO"] | 450.0000 | 490.0000 | 1 | 120 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:30:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b078-7913-7470-a111-f583cde19c54 | DIA | 2026-09-17 13:44 | call_diagonal_spread | 2 | 1 | 5 | 50925.00 | short | ask | 518.4500 | 4.0000 | ["455","500"] | ["0.9980","0.1423"] | [] | ["XCBO"] | 455.0000 | 500.0000 | 1 | 183 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:45:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0c4c3-b65f-7463-bc49-b428e8821561 | DIA | 2026-09-21 12:19 | call_diagonal_spread | 2 | 1 | 10 | 152150.00 | short | bid | 518.9800 | 7.8500 | ["450","455"] | ["0.2171","0.1841"] | [] | ["XISX"] | 450.0000 | 455.0000 | 88 | 179 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:19:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |