core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a08216-bd41-7292-be70-eb0c06075b27 | CIEN | 2026-09-08 13:35 | other | 3 | 1 | 20 | 141050.00 | unknown | — | 346.6000 | 6.3000 | ["360","400","440"] | ["0.6985","0.7190","0.7400"] | [] | ["XBOX"] | 360.0000 | 440.0000 | 101 | 101 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:36:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0820e-31c0-7943-badd-fc8ed55ca8fc | CIEN | 2026-09-08 13:26 | other | 3 | 1 | 30 | 211725.00 | unknown | — | 346.3900 | 4.7000 | ["360","400","440"] | ["0.7167","0.7206","0.7240"] | [] | ["BATO"] | 360.0000 | 440.0000 | 101 | 101 | false | true | false | true | false | mlet | |||||||
| 01a081ad-f8f1-7443-be8f-96eb471d248a | CIEN | 2026-09-08 11:40 | call_vertical_spread | 2 | 1 | 15 | 118950.00 | unknown | — | 342.2200 | 5.8000 | ["300","350"] | ["0.6460","0.6466"] | [] | ["XCBO"] | 300.0000 | 350.0000 | 38 | 38 | false | false | false | true | false | mlat | |||||||
| 01a081a5-84e0-7ca1-94e5-4f75a85604de | CIEN | 2026-09-08 11:31 | other | 3 | 1 | 5 | 128780.00 | unknown | — | 342.0300 | 23.2000 | ["300","430","450"] | ["0.6932","0.7556","0.7643"] | [] | ["XMIO"] | 300.0000 | 450.0000 | 101 | 129 | false | false | true | true | false | mlet | |||||||
| 01a0817b-b5c0-7e32-8be9-e05a449b74d0 | CIEN | 2026-09-08 10:46 | put_vertical_spread | 2 | 1 | 7 | 151410.00 | short | bid | 338.3850 | 16.5000 | ["440","450"] | ["1.0565","1.1248"] | ["0","440"] | ["XPHO"] | 440.0000 | 450.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a08173-8030-7193-992d-add7463159f6 | CIEN | 2026-09-08 10:37 | call_vertical_spread | 2 | 1 | 30 | 112680.00 | short | bid | 336.3200 | 9.1000 | ["350","355"] | ["0.6400","0.6414"] | ["351.80"] | ["XMIO"] | 350.0000 | 355.0000 | 31 | 31 | false | true | false | true | false | ||||||||
| 01a08151-4290-73b2-ab73-a7f617468935 | CIEN | 2026-09-08 09:59 | put_vertical_spread | 2 | 1 | 30 | 208440.00 | short | bid | 332.5140 | 7.2000 | ["165","170"] | ["0.7648","0.7629"] | ["168.10"] | ["XCBO"] | 165.0000 | 170.0000 | 829 | 829 | false | true | false | true | false | ||||||||
| 01a06dfe-1665-7610-b570-5780eb3d2278 | CIEN | 2026-09-04 15:56 | put_diagonal_spread_bullish | 2 | 5 | 128 | 759232.00 | short | ask | 320.3500 | 12.4000 | ["340","350"] | ["0.6659","26.0715"] | [] | ["C2OX","EDGO","XCBO","XISX","XPHO"] | 340.0000 | 350.0000 | 0 | 14 | false | false | true | true | false | ||||||||
| 01a06de3-089d-7320-b3b3-971c50f3e587 | CIEN | 2026-09-04 15:26 | put_vertical_spread | 2 | 1 | 10 | 322920.00 | short | bid | 320.1300 | 17.5000 | ["440","450"] | ["0.7420","0.7440"] | ["442.20"] | ["C2OX"] | 440.0000 | 450.0000 | 286 | 286 | false | false | false | true | false | ||||||||
| 01a06de3-089d-7320-b3b3-9704c4ec091a | CIEN | 2026-09-04 15:26 | put_vertical_spread | 2 | 4 | 14 | 445240.00 | short | bid | 320.1300 | 25.8000 | ["440","450"] | ["0.7202","0.7221"] | ["442.20"] | ["ARCO","EMLD","SPHR","XBOX"] | 440.0000 | 450.0000 | 286 | 286 | false | false | false | true | false | ||||||||
| 01a06dcc-c94d-7111-a0dd-f37f30f45537 | CIEN | 2026-09-04 15:02 | other | 4 | 1 | 3 | 100500.00 | unknown | — | 319.8500 | 33.6000 | ["390","410"] | ["0.7371","0.6599"] | [] | ["XBOX"] | 390.0000 | 410.0000 | 35 | 42 | false | false | true | true | false | mlet | |||||||
| 01a06dc2-1705-7f11-98ac-b994d12ad760 | CIEN | 2026-09-04 14:50 | call_vertical_spread | 2 | 1 | 250 | 258750.00 | long | ask | 319.0200 | 1.6000 | ["390","430"] | ["0.6268","0.6371"] | ["393.99"] | ["EDGO"] | 390.0000 | 430.0000 | 42 | 42 | true | true | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:26:12Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:41:19Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:31:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:46:35Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:37:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:59:44Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:56:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:26:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:26:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:02:41Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:50:32Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |