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 |
|---|
| 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 |
|---|
| 01a0ca9f-1a1f-76a0-9fae-e260d3fcc2d8 | AVGO | 2026-09-22 15:36 | call_diagonal_spread | 2 | 1 | 5 | 30475.00 | long | ask | 365.0600 | 1.5500 | ["340","387.5"] | ["0.4353","0.3627"] | [] | ["XISX"] | 340.0000 | 387.5000 | 6 | 178 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:37:23Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e1-f057-7eb3-9c34-b35d4acd3ae5 | AVGO | 2026-09-22 12:10 | risk_reversal | 2 | 2 | 19 | 60230.00 | long | ask | 363.2300 | 0.4500 | ["340","370"] | ["0.3796","0.3903"] | ["379.80"] | ["ARCO","XISX"] | 340.0000 | 370.0000 | 59 | 59 | false | true | false | true | |||||||||
| 01a0c9e1-f057-7eb3-9c34-b336c49ef4cd | AVGO | 2026-09-22 12:10 | risk_reversal | 2 | 2 | 12 | 38040.00 | long | ask | 363.2300 | 0.4500 | ["340","370"] | ["0.3796","0.3903"] | ["379.80"] | ["ARCO","XBOX"] | 340.0000 | 370.0000 | 59 | 59 | false | true | false | true | |||||||||
| 01a0c97d-566f-7eb2-9f58-1c171b056a80 | AVGO | 2026-09-22 10:20 | call_vertical_spread | 2 | 1 | 3 | 62745.00 | long | ask | 362.6850 | 2.7000 | ["310","320"] | ["0.4395","0.4395"] | ["315.25"] | ["XISX"] | 310.0000 | 320.0000 | 486 | 486 | false | false | false | true | |||||||||
| 01a0c97b-1837-71b3-bb8e-03b90bd1db4a | AVGO | 2026-09-22 10:18 | put_diagonal_spread | 2 | 1 | 10 | 136850.00 | long | ask | 362.5100 | 3.4000 | ["400","420"] | ["0.4485","0.4418"] | [] | ["C2OX"] | 400.0000 | 420.0000 | 87 | 268 | false | false | true | true | |||||||||
| 01a0c56f-5bc7-7bd1-a40d-84dafe8c0f41 | AVGO | 2026-09-21 15:26 | call_diagonal_spread | 2 | 1 | 2 | 25680.00 | long | ask | 363.5403 | 2.8000 | ["300","310"] | ["0.9723","0.4500"] | [] | ["AMXO"] | 300.0000 | 310.0000 | 4 | 88 | false | false | true | true | |||||||||
| 01a0c43d-8ab7-7342-a7b6-f61508546b71 | AVGO | 2026-09-21 09:52 | risk_reversal | 2 | 2 | 15 | 37350.00 | long | ask | 356.5850 | 0.8000 | ["340","360"] | ["0.3563","0.3682"] | ["367.60"] | ["AMXO","XPHO"] | 340.0000 | 360.0000 | 39 | 39 | false | true | false | true | |||||||||
| 01a0c43d-8ab7-7342-a7b6-f60e88501bd3 | AVGO | 2026-09-21 09:52 | risk_reversal | 2 | 2 | 19 | 47310.00 | long | ask | 356.5850 | 0.8000 | ["340","360"] | ["0.3555","0.3682"] | ["367.60"] | ["XCBO","XISX"] | 340.0000 | 360.0000 | 39 | 39 | false | true | false | true | |||||||||
| 01a0b4bc-d558-7a73-ad32-3ad6e789f2a0 | AVGO | 2026-09-18 09:37 | put_vertical_spread | 2 | 1 | 4 | 62220.00 | long | ask | 360.5300 | 5.7500 | ["400","420"] | ["0.4427","0.4490"] | ["406.25"] | ["C2OX"] | 400.0000 | 420.0000 | 272 | 272 | false | false | false | true | |||||||||
| 01a0b4b9-bc5f-7b00-96bc-1e82204c9736 | AVGO | 2026-09-18 09:34 | put_calendar | 2 | 1 | 3 | 26055.00 | long | bid | 358.9350 | 3.9000 | ["400"] | ["0.4139"] | [] | ["C2OX"] | 400.0000 | 400.0000 | 21 | 28 | false | false | true | false | |||||||||
| 01a0b0b6-494b-7173-ae21-bce15a63f724 | AVGO | 2026-09-17 14:52 | call_diagonal_spread | 2 | 2 | 24 | 110520.00 | long | ask | 348.0800 | 0.8000 | ["350","370"] | ["0.3964","0.3596"] | [] | ["C2OX"] | 350.0000 | 370.0000 | 64 | 120 | false | true | true | true | |||||||||
| 01a0afc3-6983-7b22-b68e-410867703ced | AVGO | 2026-09-17 10:26 | risk_reversal | 2 | 3 | 12 | 39795.00 | long | bid | 349.4679 | 0.4083 | ["330","420"] | ["0.4100","0.4089"] | ["321.18"] | ["XCBO"] | 330.0000 | 420.0000 | 120 | 120 | false | true | false | true | |||||||||
| 01a0afaf-02da-7741-8c3f-d49a8d92bbaa | AVGO | 2026-09-17 10:04 | call_vertical_spread | 2 | 1 | 20 | 34600.00 | long | ask | 348.2500 | 0.4500 | ["340","342.5"] | ["0.2857","0.2838"] | ["341.9"] | ["XISX"] | 340.0000 | 342.5000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0af8f-9fb3-7d72-a0b9-14c65d32e3c9 | AVGO | 2026-09-17 09:30 | put_vertical_spread | 2 | 1 | 80 | 706400.00 | long | ask | 346.0100 | 5.6500 | ["370","380"] | ["0.4102","0.4152"] | ["373"] | ["C2OX"] | 370.0000 | 380.0000 | 92 | 92 | false | false | false | true | |||||||||
| 01a0a619-8ffe-7ab2-8187-3d7e883827b7 | AVGO | 2026-09-15 13:24 | call_vertical_spread | 2 | 1 | 100 | 55700.00 | long | ask | 338.2400 | 0.1100 | ["500","510"] | ["0.4343","0.4373"] | ["500.39"] | ["XISX"] | 500.0000 | 510.0000 | 122 | 122 | false | true | false | true | |||||||||
| 01a0a160-bbd9-7a01-96a4-0e68239a2fb3 | AVGO | 2026-09-14 15:24 | straddle | 2 | 2 | 10 | 29900.00 | long | ask | 345.2300 | 0.4500 | ["350"] | ["0.3638"] | ["320.10","379.90"] | ["AMXO","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-b7f0-7250-85f1-9bcd659e09e8 | AVGO | 2026-09-14 15:24 | synthetic | 2 | 2 | 11 | 32890.00 | long | bid | 345.2000 | 0.1000 | ["350"] | ["0.3638"] | ["346"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-b7f0-7250-85f1-9bbc0382c1a6 | AVGO | 2026-09-14 15:24 | synthetic | 2 | 2 | 15 | 44850.00 | long | bid | 345.2000 | 0.3500 | ["350"] | ["0.3638"] | ["346"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-5a30-7611-a93c-0090be88bfb3 | AVGO | 2026-09-14 15:23 | synthetic | 2 | 2 | 21 | 62580.00 | long | bid | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | ["346.10"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-5648-7572-9365-d2b68adfa845 | AVGO | 2026-09-14 15:23 | synthetic | 2 | 2 | 15 | 44700.00 | long | bid | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | ["346.10"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0914e-fac0-72d2-9368-58948bee3a34 | AVGO | 2026-09-11 12:31 | call_vertical_spread | 2 | 1 | 5 | 78600.00 | long | ask | 364.4900 | 1.2000 | ["300","500"] | ["0.4541","0.4564"] | ["371.20"] | ["XISX"] | 300.0000 | 500.0000 | 497 | 497 | false | false | false | true | |||||||||
| 01a087b6-e4f0-72d2-88e0-13e32a23ad93 | AVGO | 2026-09-09 15:48 | call_vertical_spread | 2 | 1 | 25 | 200125.00 | long | ask | 364.3750 | 1.9500 | ["400","450"] | ["0.4497","0.4514"] | ["414.55"] | ["C2OX"] | 400.0000 | 450.0000 | 281 | 281 | false | true | false | true | |||||||||
| 01a0866a-d138-79a0-ab6d-291030c606b5 | AVGO | 2026-09-09 09:45 | call_vertical_spread | 2 | 2 | 10 | 34700.00 | long | ask | 362.8800 | 0.6000 | ["360","370"] | ["0.3803","0.3820"] | ["364.60"] | ["C2OX"] | 360.0000 | 370.0000 | 37 | 37 | false | false | false | true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:10:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:10:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:20:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:18:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:27:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:52:44Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:52:44Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:37:49Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:34:34Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:52:35Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:27:01Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:04:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:17Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:25:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:31:17Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:48:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:45:51Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |