core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d8e8-9a6f-7a43-91a4-f5516856a5e3 | CIEN | 2026-09-25 10:11 | other | 4 | 1 | 630 | 1368360.00 | unknown | — | 361.2950 | 10.7000 | ["317.5","330","352.5","375"] | ["2.7345","0.6488","1.2840","0.7020"] | [] | ["XPHO"] | 317.5000 | 375.0000 | 0 | 7 | false | false | true | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T14:12:12Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0c976-036f-7d42-942d-52fbbbd16fcf | CIEN | 2026-09-22 10:12 | other | 4 | 1 | 45 | 488925.00 | unknown | — | 373.8550 | 24.5000 | ["330","340","360","370"] | ["0.7278","0.6829","0.7301","0.7126"] | [] | ["XCBO"] | 330.0000 | 370.0000 | 24 | 87 | false | true | true | true | |||||||||
| 01a0b524-2e5f-7693-b175-86e31bd8cb28 | CIEN | 2026-09-18 11:30 | other | 4 | 1 | 630 | 735210.00 | unknown | — | 342.7700 | 5.3500 | ["310","317.5","350","352.5"] | ["3.0114","0.6235","0.9463","0.6029"] | [] | ["XPHO"] | 310.0000 | 352.5000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0b0d8-ec7b-7a51-87b2-76a503759aae | CIEN | 2026-09-17 15:29 | other | 3 | 1 | 90 | 763830.00 | unknown | — | 346.2000 | 12.3000 | ["500","550","700"] | ["0.7116","0.7402","0.9604"] | [] | ["XCBO"] | 500.0000 | 700.0000 | 29 | 92 | false | false | true | true | |||||||||
| 01a0aa88-7be3-7ae1-b66f-0873e574088a | CIEN | 2026-09-16 10:04 | other | 4 | 1 | 100 | 1627200.00 | unknown | — | 340.4700 | 39.5000 | ["370","380","385","390"] | ["0.5001","1.2165","0.4974","1.5163"] | [] | ["SPHR"] | 370.0000 | 390.0000 | 2 | 16 | false | false | true | true | |||||||||
| 01a0a5bd-23d6-7461-9631-a4ed1bc0b4b2 | CIEN | 2026-09-15 11:43 | other | 4 | 1 | 10 | 108420.00 | unknown | — | 331.7500 | 23.6000 | ["305","310","365","370"] | ["0.6686","0.6686","0.9723","1.0286"] | [] | ["XCBO"] | 305.0000 | 370.0000 | 3 | 38 | false | false | true | true | |||||||||
| 01a0a178-dba0-7ba3-8402-481dd77faa20 | CIEN | 2026-09-14 15:50 | other | 2 | 1 | 10 | 102150.00 | unknown | — | 319.1100 | 16.0000 | ["360","370"] | ["0.6101","0.5233"] | [] | ["XISX"] | 360.0000 | 370.0000 | 11 | 39 | false | false | true | true | false | ||||||||
| 01a0a0c8-0a00-72c2-a7b2-c0b046371a7e | CIEN | 2026-09-14 12:37 | other | 2 | 1 | 10 | 115660.00 | unknown | — | 326.4400 | 8.0000 | ["350","380"] | ["0.7057","0.6683"] | [] | ["XPHO"] | 350.0000 | 380.0000 | 18 | 95 | false | false | true | true | false | ||||||||
| 01a091f6-46e0-70b3-9fc7-7fccc77c62a6 | CIEN | 2026-09-11 15:33 | other | 4 | 1 | 20 | 231700.00 | unknown | — | 349.5100 | 31.9000 | ["330","350","370","380"] | ["0.6882","0.6742","0.6095","0.6251"] | [] | ["ARCO"] | 330.0000 | 380.0000 | 7 | 49 | false | false | true | true | |||||||||
| 01a08cbb-3a00-7552-b8fb-86c17c7c8e41 | CIEN | 2026-09-10 15:11 | other | 4 | 1 | 630 | 753481.00 | unknown | — | 336.6600 | 3.5500 | ["310","320","350","360"] | ["0.6422","0.7296","0.6427","0.9407"] | [] | ["AMXO"] | 310.0000 | 360.0000 | 1 | 8 | false | true | true | true | |||||||||
| 01a08cb2-77d0-7fd2-8904-8257e843134c | CIEN | 2026-09-10 15:01 | other | 3 | 1 | 35 | 397950.00 | unknown | — | 336.9900 | 22.8000 | ["385","390","422.5"] | ["2.4399","2.5195","3.3381"] | [] | ["XBOX"] | 385.0000 | 422.5000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08c9b-2710-7c81-b2c3-219dff18f9ff | CIEN | 2026-09-10 14:36 | other | 3 | 1 | 41 | 1117410.00 | unknown | — | 337.8800 | 26.3000 | ["390","422.5","560"] | ["2.6931","3.5539","0.4949"] | [] | ["XBOX"] | 390.0000 | 560.0000 | 1 | 36 | false | false | true | true | |||||||||
| 01a08665-37a0-7eb3-8bf7-b402361164e9 | CIEN | 2026-09-09 09:39 | other | 2 | 1 | 10 | 107610.00 | unknown | — | 342.4000 | 18.6000 | ["440","450"] | ["0.6655","1.2315"] | [] | ["XMIO"] | 440.0000 | 450.0000 | 9 | 9 | false | false | false | true | false | ||||||||
| 01a08278-b360-74a2-9ea5-6d99bc55ef07 | CIEN | 2026-09-08 15:22 | other | 4 | 1 | 3 | 105695.00 | unknown | — | 346.2850 | 43.6000 | ["260","350","800","900"] | ["0.7963","0.7536","0.6826","0.6996"] | [] | ["XBOX"] | 260.0000 | 900.0000 | 500 | 829 | false | false | true | true | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:12:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:30:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:30:27Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:04:34Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:43:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:51:02Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:38:24Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:33:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:11:34Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:01:41Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:36:49Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:39:39Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:22:43Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| market_whale |
| 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 |