core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0da22-85b7-70a3-9ec5-28bcdab81a5a | CLS | 2026-09-25 15:54 | call_vertical_spread | 2 | 1 | 255 | 430185.00 | short | bid | 366.2300 | 6.5500 | ["365","390"] | ["0.6029","0.5871"] | ["374.01"] | ["XCBO"] | 365.0000 | 390.0000 | 7 | 7 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:54:52Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0da1c-0d77-7152-9ea0-e1a878b44546 | CLS | 2026-09-25 15:47 | call_diagonal_spread | 2 | 1 | 9 | 163413.00 | short | ask | 367.7300 | 6.1000 | ["275","280"] | ["30.6160","1.0195"] | [] | ["XCBO"] | 275.0000 | 280.0000 | 0 | 7 | false | false | |||||||||||
| 01a0da1b-9c2f-7bc3-b2fd-dc08826003a6 | CLS | 2026-09-25 15:47 | call_diagonal_spread | 2 | 1 | 8 | 145248.00 | short | ask | 367.6450 | 6.1000 | ["275","280"] | ["30.8175","1.0484"] | [] | ["SPHR"] | 275.0000 | 280.0000 | 0 | 7 | false | false | |||||||||||
| 01a0da1b-4256-75c0-837b-7e3c92d388bc | CLS | 2026-09-25 15:46 | call_diagonal_spread | 2 | 1 | 6 | 108942.00 | short | ask | 367.3850 | 6.1000 | ["275","280"] | ["32.6316","1.1225"] | [] | ["XCBO"] | 275.0000 | 280.0000 | 0 | 7 | false | false | |||||||||||
| 01a0d99c-b7cf-7fa0-b4e0-ff7c39e96503 | CLS | 2026-09-25 13:28 | call_calendar | 2 | 1 | 5 | 163215.00 | short | ask | 373.2200 | 12.0000 | ["320"] | ["0.6983"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 483 | 847 | false | false | |||||||||||
| 01a0d461-fcf7-70f2-89af-d9209fa786ca | CLS | 2026-09-24 13:06 | call_diagonal_spread | 2 | 2 | 22 | 209132.00 | short | ask | 374.7300 | 10.6000 | ["350","355"] | ["0.7310","0.7158"] | [] | ["EDGO","XISX"] | 350.0000 | 355.0000 | 36 | 43 | false | false | |||||||||||
| 01a0d3ba-b0d6-7ca0-87c8-f17c3a4ece24 | CLS | 2026-09-24 10:03 | call_ladder | 3 | 4 | 40 | 225965.00 | short | bid | 363.2000 | 12.6000 | ["350","380","390"] | ["0.6105","0.6215","0.6134"] | ["351.57","418.43"] | ["ARCO","C2OX","EDGO"] | 350.0000 | 390.0000 | 22 | 22 | false | false | |||||||||||
| 01a0ced5-e9e6-7d63-8c4d-f1240b8428b5 | CLS | 2026-09-23 11:15 | call_vertical_spread | 2 | 1 | 15 | 131940.00 | short | bid | 366.0500 | 6.5000 | ["380","420"] | ["0.6732","0.6719"] | ["393.90"] | ["XMIO"] | 380.0000 | 420.0000 | 114 | 114 | false | true | |||||||||||
| 01a0cec7-c0e6-7683-9322-ca74c5197dce | CLS | 2026-09-23 10:59 | call_vertical_spread | 2 | 1 | 11 | 439098.00 | short | bid | 363.5850 | 11.4000 | ["170","175"] | ["0.7946","0.7878"] | ["174.42"] | ["XCBO"] | 170.0000 | 175.0000 | 177 | 177 | false | false | |||||||||||
| 01a0ca40-219e-76c1-9055-d70e8980f427 | CLS | 2026-09-22 13:53 | put_vertical_spread | 2 | 2 | 176 | 545952.00 | short | bid | 355.5600 | 9.1000 | ["350","360"] | ["0.6791","0.6739"] | ["355"] | ["EDGO","XCBO"] | 350.0000 | 360.0000 | 10 | 10 | false | false | |||||||||||
| 01a0ca40-1db7-7902-ab69-ce59285afec2 | CLS | 2026-09-22 13:53 | put_vertical_spread | 2 | 1 | 54 | 168480.00 | short | bid | 355.5600 | 9.5000 | ["350","360"] | ["0.6830","0.6777"] | ["355"] | ["XPHO"] | 350.0000 | 360.0000 | 10 | 10 | false | false | |||||||||||
| 01a0ca3a-8806-7753-bc0f-7d20d00f03b9 | CLS | 2026-09-22 13:47 | put_vertical_spread | 2 | 3 | 38 | 124469.00 | short | bid | 354.2950 | 9.1000 | ["350","360"] | ["0.6933","0.6827"] | ["355.00"] | ["AMXO","ARCO"] | 350.0000 | 360.0000 | 10 | 10 | false | false | |||||||||||
| 01a0c542-b22e-74c2-96fd-650809387c1e | CLS | 2026-09-21 14:37 | call_vertical_spread | 2 | 1 | 20 | 604380.00 | short | bid | 344.3650 | 11.6000 | ["195","200"] | ["0.7320","0.7305"] | ["199.57"] | ["AMXO"] | 195.0000 | 200.0000 | 88 | 88 | false | false | |||||||||||
| 01a0b56c-dbd7-7672-af98-0a7b01a00800 | CLS | 2026-09-18 12:50 | straddle | 2 | 1 | 265 | 6757500.00 | short | bid | 333.4800 | 9.9000 | ["470"] | ["0.6916"] | ["215","725.00"] | ["EDGO"] | 470.0000 | 470.0000 | 490 | 490 | true | false | |||||||||||
| 01a0ab83-d3a3-74b2-9482-d00fd267ce90 | CLS | 2026-09-16 14:38 | call_diagonal_spread | 2 | 3 | 45 | 150328.00 | short | bid | 325.5100 | 3.9000 | ["360","400"] | ["0.6387","0.6800"] | [] | ["AMXO","XCBO","XISX"] | 360.0000 | 400.0000 | 30 | 93 | false | true | |||||||||||
| 01a0aaf1-f3e3-75d2-86a6-14aef200e34b | CLS | 2026-09-16 11:59 | call_calendar | 2 | 1 | 6 | 150624.00 | short | bid | 325.2250 | 7.7000 | ["200"] | ["2.1045"] | [] | ["BATO"] | 200.0000 | 200.0000 | 2 | 30 | false | false | |||||||||||
| 01a0aaf1-c503-7912-aa1e-20326aac03eb | CLS | 2026-09-16 11:59 | call_calendar | 2 | 2 | 16 | 401664.00 | short | bid | 325.3599 | 7.7000 | ["200"] | ["1.9927"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 2 | 30 | false | false | |||||||||||
| 01a0aaf1-9a0b-72a1-9b9e-f998f41e98d9 | CLS | 2026-09-16 11:59 | call_calendar | 2 | 1 | 7 | 175798.00 | short | bid | 325.1850 | 7.9000 | ["200"] | ["2.1356"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 2 | 30 | false | false | |||||||||||
| 01a0aaf1-0983-7a30-994d-95bfccb3d5fc | CLS | 2026-09-16 11:58 | call_calendar | 2 | 1 | 5 | 125690.00 | short | bid | 325.2300 | 9.0000 | ["200"] | ["2.2017"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 2 | 30 | false | false | |||||||||||
| 01a0a5ce-9895-7a32-ba54-23192eddff2c | CLS | 2026-09-15 12:02 | call_vertical_spread | 2 | 1 | 4 | 111832.00 | short | bid | 316.9250 | 12.6000 | ["180","185"] | ["0.7919","0.7842"] | ["184.52"] | ["XCBO"] | 180.0000 | 185.0000 | 94 | 94 | false | false | |||||||||||
| 01a0a0cf-bea8-73f3-ac15-7db351380339 | CLS | 2026-09-14 12:46 | call_calendar | 2 | 1 | 5 | 119955.00 | short | ask | 320.0999 | 12.4000 | ["200"] | ["2.0763"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 4 | 32 | false | false | |||||||||||
| 01a0a0a7-fee0-7f93-a447-75aa24e61ed3 | CLS | 2026-09-14 12:02 | call_vertical_spread | 2 | 1 | 26 | 253994.00 | short | bid | 320.1700 | 9.7000 | ["310","410"] | ["0.7079","0.6958"] | ["343.65"] | ["XISX"] | 310.0000 | 410.0000 | 158 | 158 | false | false | |||||||||||
| 01a09149-3248-7610-99f0-4114e4c2dd23 | CLS | 2026-09-11 12:24 | put_diagonal_spread | 2 | 3 | 74 | 135346.00 | short | bid | 340.0101 | 5.0000 | ["325","330"] | ["0.5927","0.5762"] | [] | ["C2OX","EDGO","XMIO"] | 325.0000 | 330.0000 | 7 | 21 | false | true | |||||||||||
| 01a09110-b170-7bc3-a4a9-b8faeb3d6fc0 | CLS | 2026-09-11 11:23 | put_vertical_spread | 2 | 1 | 10 | 108200.00 | short | bid | 343.6700 | 8.8000 | ["320","340"] | ["0.6684","0.6661"] | ["329.48"] | ["XMIO"] | 320.0000 | 340.0000 | 189 | 189 | false | true | |||||||||||
| 01a08ce3-0198-7eb0-a2d5-627e3e0ca2a4 | CLS | 2026-09-10 15:54 | put_vertical_spread | 2 | 2 | 4 | 119044.00 | short | bid | 325.8400 | 6.6000 | ["470","480"] | ["0.8269","0.9631"] | [] | ["EMLD","SPHR"] | 470.0000 | 480.0000 | 8 | 8 | false | false | |||||||||||
| 01a08786-3be8-7633-9545-0f6bbe768249 | CLS | 2026-09-09 14:55 | call_vertical_spread | 2 | 1 | 100 | 264500.00 | short | bid | 334.9800 | 2.3000 | ["360","400"] | ["0.6375","0.6559"] | ["369.13"] | ["XMIO"] | 360.0000 | 400.0000 | 37 | 37 | false | true | |||||||||||
| 01a08783-3679-7313-a5d7-c21356387cd9 | CLS | 2026-09-09 14:51 | call_vertical_spread | 2 | 1 | 100 | 268100.00 | short | bid | 335.3800 | 2.0000 | ["360","400"] | ["0.6391","0.6570"] | ["369.23"] | ["XMIO"] | 360.0000 | 400.0000 | 37 | 37 | false | true | |||||||||||
| 01a0876e-2009-7742-92e3-d50042d9f5a7 | CLS | 2026-09-09 14:28 | call_vertical_spread | 2 | 1 | 125 | 348750.00 | short | bid | 337.0250 | 1.6000 | ["360","400"] | ["0.6400","0.6563"] | ["369.58"] | ["XMIO"] | 360.0000 | 400.0000 | 37 | 37 | false | true | |||||||||||
| 01a08757-0dc8-7f70-9669-97e8cecacb0a | CLS | 2026-09-09 14:03 | call_vertical_spread | 2 | 1 | 75 | 221700.00 | short | bid | 339.5300 | 1.3000 | ["360","400"] | ["0.6398","0.6556"] | ["370.04"] | ["XMIO"] | 360.0000 | 400.0000 | 37 | 37 | false | true | |||||||||||
| 01a08667-db69-7301-804f-efc2c84d2605 | CLS | 2026-09-09 09:42 | call_diagonal_spread | 2 | 2 | 74 | 139786.00 | short | bid | 339.4300 | 4.2000 | ["340","350"] | ["0.8542","0.7020"] | [] | ["ARCO","C2OX"] | 340.0000 | 350.0000 | 2 | 9 | false | true | |||||||||||
| 01a08188-d138-7e53-9992-09794a4871a4 | CLS | 2026-09-08 11:00 | call_vertical_spread | 2 | 1 | 10 | 109800.00 | short | bid | 327.5500 | 7.0000 | ["340","370"] | ["0.6648","0.6609"] | ["350.90"] | ["AMXO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | |||||||||||
| 01a0814b-3f82-7453-80fb-d0153ea5412c | CLS | 2026-09-08 09:53 | call_vertical_spread | 2 | 1 | 10 | 100810.00 | short | bid | 319.4300 | 9.2000 | ["340","370"] | ["0.6629","0.6599"] | ["350.25"] | ["XMIO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | |||||||||||
| 01a0813f-8b68-75c2-9769-08f200266a4d | CLS | 2026-09-08 09:40 | call_vertical_spread | 2 | 1 | 10 | 100660.00 | short | bid | 320.5000 | 9.4000 | ["340","370"] | ["0.6563","0.6526"] | ["350.40"] | ["EDGO"] | 340.0000 | 370.0000 | 192 | 192 | false | true | |||||||||||
| 01a0813f-21f0-79a3-a938-acadd28e5493 | CLS | 2026-09-08 09:39 | call_vertical_spread | 2 | 1 | 10 | 100710.00 | short | bid | 320.0000 | 9.4000 | ["340","370"] | ["0.6599","0.6552"] | ["350.45"] | ["XMIO"] | 340.0000 | 370.0000 | 192 | 192 | false | true |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:47:55Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:47:30Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:47:06Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:29:14Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:06:29Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:04:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:15:46Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:59:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:53:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:53:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:47:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:38:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:50:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:38:57Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:59:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:59:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:59:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:58:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:02:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:46:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:02:54Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:24:54Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:23:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:54:40Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:55:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:52:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:29:19Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:04:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:42:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:00:46Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:53:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:40:19Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:39:51Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |