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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4f7-e1d7-7832-a03e-6c4182fc44ce | DIA | 2026-09-21 13:16 | put_vertical_spread | 2 | 1 | 20 | 37158.00 | long | ask | 519.6000 | 0.5500 | ["515","520"] | ["0.1436","0.1395"] | ["518.16"] | ["XCBO"] | 515.0000 | 520.0000 | 60 | 60 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:16:41Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5f2-9e07-75d1-9bb8-b415fd5ba792 | DIA | 2026-09-18 15:16 | put_vertical_spread | 2 | 1 | 9 | 35784.00 | long | ask | 516.2620 | 3.4000 | ["505","515"] | ["0.1734","0.1699"] | ["511.62"] | ["XCBO"] | 505.0000 | 515.0000 | 272 | 272 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:16:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b00a-4df3-7172-a9d1-13805e65a78f | DIA | 2026-09-17 11:44 | put_vertical_spread | 2 | 1 | 9 | 32634.00 | long | ask | 518.3600 | 7.3000 | ["515","520"] | ["0.1651","0.1634"] | ["518.08"] | ["XCBO"] | 515.0000 | 520.0000 | 183 | 183 | false | false | false | true | false | mlat | tracked | 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 |
| 01a0afa2-9b13-76f0-8ca7-5cc37570bc38 | DIA | 2026-09-17 09:51 | put_vertical_spread | 2 | 1 | 400 | 56000.00 | long | ask | 518.1450 | 0.1800 | ["490","505"] | ["0.2272","0.1766"] | ["504.24"] | ["XPHO"] | 490.0000 | 505.0000 | 8 | 8 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:51:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a600-c456-7880-abff-83eeb7c7d5fe | DIA | 2026-09-15 12:57 | put_vertical_spread | 2 | 1 | 21 | 43449.00 | long | ask | 520.9500 | 0.4500 | ["500","510"] | ["0.1680","0.1605"] | ["507.41"] | ["XCBO"] | 500.0000 | 510.0000 | 122 | 122 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:57:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a593-ae8e-78f3-89e3-a2454c0e8fe9 | DIA | 2026-09-15 10:58 | put_vertical_spread | 2 | 1 | 400 | 86000.00 | long | ask | 519.4900 | 0.1300 | ["490","505"] | ["0.2381","0.1926"] | ["503.99"] | ["XPHO"] | 490.0000 | 505.0000 | 10 | 10 | true | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:59:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a090fa-00d8-7472-8498-7fae3384156d | DIA | 2026-09-11 10:58 | put_calendar | 2 | 1 | 100 | 135400.00 | long | bid | 524.8400 | 0.6000 | ["527"] | ["0.1380"] | [] | ["XCBO"] | 527.0000 | 527.0000 | 14 | 19 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:58:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a087ad-d888-7912-852e-4ed37323b5d2 | DIA | 2026-09-09 15:38 | call_vertical_spread | 2 | 1 | 50 | 104550.00 | long | ask | 524.7700 | 0.6000 | ["530","535"] | ["0.1314","0.1288"] | ["532.43"] | ["XCBO"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:38:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08157-7480-78a3-9813-766a9ecaabd2 | DIA | 2026-09-08 10:06 | put_calendar | 2 | 1 | 40 | 42880.00 | long | ask | 528.2350 | 0.7000 | ["527"] | ["0.1329"] | [] | ["XCBO"] | 527.0000 | 527.0000 | 17 | 22 | true | true | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:06:46Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |