core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 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 | false | 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 |
| 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 | 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 | 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 | 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 | true | 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 | 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 | 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 | false | true | |||||||||
| 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 | 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 | 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 | false | true | |||||||||
| 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 | true | true | |||||||||
| 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 | false | true | |||||||||
| 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 | true | 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 | false | true | |||||||||
| 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 | true | 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 | true | 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 | true | false | |||||||||
| 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 | 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 | true | true | |||||||||
| 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 | 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 | false | true | |||||||||
| 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 | false | true | |||||||||
| 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 | false | true | |||||||||
| 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 | false | true |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |