core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0b000-090b-7332-b437-7ce3bb33bf4f | SOXX | 2026-09-17 11:33 | call_diagonal_spread | 2 | 1 | 2 | 71980.00 | long | bid | 517.9500 | 10.7000 | ["300","400"] | ["6.6192","0.4745"] | [] | ["XISX"] | 300.0000 | 400.0000 | 1 | 183 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:33:20Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afec-61cb-7771-a349-3e097b6f464a | SOXX | 2026-09-17 11:11 | call_diagonal_spread | 2 | 1 | 13 | 66456.00 | long | ask | 518.1500 | 2.0000 | ["520","530"] | ["0.3646","0.3885"] | [] | ["XCBO"] | 520.0000 | 530.0000 | 29 | 64 | false | true | true | true | |||||||||
| 01a0aa8c-63e3-7bd1-995b-adeb8742829a | SOXX | 2026-09-16 10:08 | call_diagonal_spread | 2 | 2 | 4 | 43160.00 | unknown | — | 508.1100 | 6.2000 | ["500","510"] | ["0.3923","0.3914"] | [] | ["EMLD","SPHR"] | 500.0000 | 510.0000 | 121 | 156 | false | false | true | true | false | mlet | |||||||
| 01a0a6a5-459e-71d0-9ada-e6def131b586 | SOXX | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 4 | 31420.00 | unknown | — | 498.3100 | 4.7000 | ["535","540"] | ["0.3746","0.3753"] | [] | ["BATO"] | 535.0000 | 540.0000 | 157 | 185 | false | true | true | true | false | mlet | |||||||
| 01a0a55f-487e-7090-9b39-8080221cf773 | SOXX | 2026-09-15 10:01 | call_diagonal_spread | 2 | 1 | 5 | 45395.00 | long | bid | 504.2264 | 2.8000 | ["435","505"] | ["0.7478","0.3549"] | [] | ["ARCO"] | 435.0000 | 505.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a55f-3cc6-77a3-b68f-773b116632cb | SOXX | 2026-09-15 10:01 | call_diagonal_spread | 2 | 2 | 10 | 90350.00 | long | bid | 504.2400 | 4.1500 | ["435","505"] | ["1.0439","0.3557"] | [] | ["ARCO","XCBO"] | 435.0000 | 505.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a548-de36-7972-9ba3-9003455f65de | SOXX | 2026-09-15 09:36 | call_diagonal_spread | 2 | 1 | 5 | 64550.00 | unknown | — | 501.4500 | 3.6000 | ["375","535"] | ["0.5393","0.4564"] | [] | ["XISX"] | 375.0000 | 535.0000 | 3 | 31 | false | false | true | true | false | mlet | |||||||
| 01a0a115-0120-7af1-8cde-db72090af99c | SOXX | 2026-09-14 14:01 | call_diagonal_spread | 2 | 1 | 6 | 70830.00 | long | ask | 501.5650 | 9.3000 | ["450","580"] | ["0.4180","0.3686"] | [] | ["AMXO"] | 450.0000 | 580.0000 | 95 | 276 | false | false | true | true | |||||||||
| 01a0a0a7-2808-7c01-9b8c-ebdcf654ffbd | SOXX | 2026-09-14 12:01 | call_diagonal_spread | 2 | 1 | 2 | 78582.00 | long | bid | 499.2700 | 8.2000 | ["305","315"] | ["0.6160","0.4899"] | [] | ["BATO"] | 305.0000 | 315.0000 | 67 | 186 | false | false | true | true | |||||||||
| 01a0a0a6-7c28-7521-983a-0ec57d3a5218 | SOXX | 2026-09-14 12:00 | call_diagonal_spread | 2 | 1 | 12 | 473892.00 | short | ask | 499.3950 | 12.8000 | ["305","315"] | ["0.6662","0.5150"] | [] | ["XISX"] | 305.0000 | 315.0000 | 67 | 186 | false | false | true | true | |||||||||
| 01a0a0a4-8058-7e43-82b8-e90f6598e524 | SOXX | 2026-09-14 11:58 | call_diagonal_spread | 2 | 1 | 12 | 496632.00 | short | ask | 500.0600 | 13.5000 | ["295","305"] | ["0.6314","0.5139"] | [] | ["MCRY"] | 295.0000 | 305.0000 | 67 | 186 | false | false | true | true | |||||||||
| 01a0a04b-7b49-7812-902d-99b0470dede1 | SOXX | 2026-09-14 10:21 | call_diagonal_spread | 2 | 1 | 5 | 197400.00 | long | ask | 501.0500 | 12.8000 | ["305","390"] | ["1.8424","0.4554"] | [] | ["XCBO"] | 305.0000 | 390.0000 | 4 | 823 | false | false | true | true | |||||||||
| 01a0912c-6730-7ff3-8ede-74f47b568692 | SOXX | 2026-09-11 11:53 | call_diagonal_spread | 2 | 1 | 10 | 388100.00 | short | ask | 529.3350 | 13.8000 | ["335","345"] | ["0.6773","0.4773"] | [] | ["BATO"] | 335.0000 | 345.0000 | 35 | 126 | false | false | true | true | |||||||||
| 01a08c42-25e8-7ac0-84b0-fdc261ae0c71 | SOXX | 2026-09-10 12:58 | call_diagonal_spread | 2 | 1 | 4 | 172340.00 | long | ask | 520.9400 | 11.7000 | ["305","390"] | ["2.0984","0.4394"] | [] | ["XCBO"] | 305.0000 | 390.0000 | 8 | 827 | false | false | true | true | |||||||||
| 01a08c40-64b0-7c50-89e7-e7c5152da1ee | SOXX | 2026-09-10 12:57 | call_diagonal_spread | 2 | 1 | 2 | 86376.00 | short | bid | 520.7400 | 14.0000 | ["305","390"] | ["2.1344","0.4432"] | [] | ["XCBO"] | 305.0000 | 390.0000 | 8 | 827 | false | false | true | true | |||||||||
| 01a08bd6-5070-7f10-866d-d086d6e59a85 | SOXX | 2026-09-10 11:01 | call_diagonal_spread | 2 | 1 | 10 | 34410.00 | long | ask | 521.2100 | 5.6000 | ["522.5","530"] | ["0.3730","0.3786"] | [] | ["XCBO"] | 522.5000 | 530.0000 | 15 | 29 | false | true | true | true | |||||||||
| 01a087b7-cf51-7792-acb8-72fe7b8e06f9 | SOXX | 2026-09-09 15:49 | call_diagonal_spread | 2 | 1 | 5 | 135350.00 | short | bid | 531.0700 | 12.2000 | ["400","420"] | ["0.9723","0.4476"] | [] | ["XMIO"] | 400.0000 | 420.0000 | 9 | 191 | false | false | true | true | |||||||||
| 01a081d2-1af0-7b22-9834-532304e18237 | SOXX | 2026-09-08 12:20 | call_diagonal_spread | 2 | 1 | 2 | 57160.00 | long | bid | 531.4900 | 10.1000 | ["390","400"] | ["1.0229","0.4827"] | [] | ["ARCO"] | 390.0000 | 400.0000 | 10 | 101 | false | false | true | true | |||||||||
| 01a08138-8a70-7e22-8b85-9c3db4ded433 | SOXX | 2026-09-08 09:32 | call_diagonal_spread | 2 | 2 | 10 | 27690.00 | long | bid | 530.4400 | 6.6000 | ["540","550"] | ["0.3955","0.3869"] | [] | ["XMIO"] | 540.0000 | 550.0000 | 17 | 24 | false | true | true | true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:11:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:09:00Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:57:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:01:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:01:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:37:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:02:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:01:43Z"} |
| 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:01:04Z"} |
| 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-14T15:59:20Z"} |
| 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-14T14:21:41Z"} |
| 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-11T15:53:35Z"} |
| 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-10T16:58:59Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:57:07Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:01:42Z"} |
| 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-09T19:49:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:20:23Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:32:48Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |