core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg541,738 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 |
|---|
| 01a06dfc-d22e-7931-94b8-1e5a81a0220d | AAPL | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 3 | 28920.00 | short | bid | 320.6100 | 4.5500 | ["325","330"] | ["0.2904","0.2927"] | [] | ["XCBO"] | 325.0000 | 330.0000 | 469 | 560 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:54:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-458d-7131-9799-04484e18bc43 | AAPL | 2026-09-04 15:54 | call_diagonal_spread_bearish | 2 | 1 | 10 | 26460.00 | long | ask | 320.6800 | 0.5000 | ["320","325"] | ["0.2446","0.2651"] | [] | ["XCBO"] | 320.0000 | 325.0000 | 42 | 77 | false | false | |||||||||||
| 01a06dfa-af4d-7083-b596-c73be0171814 | AAPL | 2026-09-04 15:52 | call_diagonal_spread_bearish | 2 | 1 | 42 | 95718.00 | short | bid | 320.4700 | 1.0500 | ["315","320"] | ["0.2645","0.2524"] | [] | ["XBOX"] | 315.0000 | 320.0000 | 14 | 49 | false | false | |||||||||||
| 01a06dfa-70ce-73a1-a1de-5b5582bdd2c3 | AAPL | 2026-09-04 15:52 | call_diagonal_spread_bearish | 2 | 3 | 23 | 51701.00 | long | ask | 320.4301 | 0.5500 | ["315","320"] | ["0.2588","0.2495"] | [] | ["BATO","EDGO","XBOX"] | 315.0000 | 320.0000 | 14 | 49 | false | false | |||||||||||
| 01a06dfa-6ce5-7451-8daa-d03776b78ec5 | AAPL | 2026-09-04 15:52 | call_diagonal_spread_bearish | 2 | 1 | 16 | 36304.00 | short | bid | 320.4301 | 1.3000 | ["315","320"] | ["0.2635","0.2518"] | [] | ["C2OX"] | 315.0000 | 320.0000 | 14 | 49 | false | false | |||||||||||
| 01a06df3-21b5-75f0-a3fd-93e93a44d976 | AAPL | 2026-09-04 15:44 | call_diagonal_spread_bearish | 2 | 1 | 7 | 31488.00 | short | bid | 320.6700 | 0.7000 | ["330","350"] | ["0.2718","0.2758"] | [] | ["XCBO"] | 330.0000 | 350.0000 | 168 | 286 | false | true | |||||||||||
| 01a06def-7c1d-76b0-8bb0-0413adec4259 | AAPL | 2026-09-04 15:40 | call_diagonal_spread_bearish | 2 | 2 | 2 | 31078.00 | long | ask | 320.9401 | 5.1000 | ["245","255"] | ["0.4416","0.3169"] | [] | ["XMIO"] | 245.0000 | 255.0000 | 42 | 224 | false | false | |||||||||||
| 01a06dec-43e5-7193-b06c-2879628055be | AAPL | 2026-09-04 15:36 | call_diagonal_spread_bearish | 2 | 2 | 3 | 45928.00 | short | ask | 321.7750 | 2.7500 | ["250","280"] | ["0.3395","0.3077"] | [] | ["XCBO","XISX"] | 250.0000 | 280.0000 | 133 | 504 | false | false | |||||||||||
| 01a06dea-fbc5-7e03-a88f-30df5b3ed4d9 | AAPL | 2026-09-04 15:35 | call_diagonal_spread_bearish | 2 | 1 | 2 | 48664.00 | long | bid | 321.6150 | 2.3000 | ["200","240"] | ["0.4504","0.3342"] | [] | ["XCBO"] | 200.0000 | 240.0000 | 133 | 833 | false | false | |||||||||||
| 01a06de9-425d-7591-8bd9-6ca09032670e | AAPL | 2026-09-04 15:33 | call_diagonal_spread_bearish | 2 | 1 | 3 | 37197.00 | short | ask | 321.7150 | 2.6500 | ["250","280"] | ["0.8201","0.2877"] | [] | ["ARCO"] | 250.0000 | 280.0000 | 14 | 133 | false | false | |||||||||||
| 01a06de6-e8ce-74c3-a729-64350a189419 | AAPL | 2026-09-04 15:30 | call_diagonal_spread_bearish | 2 | 1 | 4 | 44680.00 | long | ask | 321.5700 | 3.4500 | ["270","280"] | ["0.3065","0.3023"] | [] | ["XISX"] | 270.0000 | 280.0000 | 77 | 196 | false | false | |||||||||||
| 01a06de4-48ed-71d0-b350-ce454f5ef57f | AAPL | 2026-09-04 15:27 | call_diagonal_spread_bearish | 2 | 1 | 3 | 40488.00 | long | bid | 321.8814 | 3.4500 | ["255","260"] | ["0.3411","0.3060"] | [] | ["XISX"] | 255.0000 | 260.0000 | 42 | 105 | false | false | |||||||||||
| 01a06de3-4eed-78f1-9616-5bf7fdbd9d8c | AAPL | 2026-09-04 15:26 | call_diagonal_spread_bearish | 2 | 1 | 4 | 43376.00 | short | ask | 321.9100 | 1.9000 | ["250","300"] | ["0.5246","0.2782"] | [] | ["XCBO"] | 250.0000 | 300.0000 | 14 | 133 | false | false | |||||||||||
| 01a06de0-6ca5-7c92-9592-4f8b4211e978 | AAPL | 2026-09-04 15:23 | call_diagonal_spread_bearish | 2 | 1 | 20 | 67200.00 | short | ask | 321.9850 | 1.0000 | ["300","370"] | ["0.2726","0.2608"] | [] | ["XMIO"] | 300.0000 | 370.0000 | 14 | 196 | false | false | |||||||||||
| 01a06dde-bb0d-7e62-9d58-46f808c2063f | AAPL | 2026-09-04 15:21 | call_diagonal_spread_bearish | 2 | 1 | 3 | 50550.00 | short | ask | 321.9200 | 2.1000 | ["220","280"] | ["0.4020","0.3019"] | [] | ["C2OX"] | 220.0000 | 280.0000 | 133 | 286 | false | false | |||||||||||
| 01a06dd7-8f1d-7800-83d6-a90369edf8c1 | AAPL | 2026-09-04 15:13 | call_diagonal_spread_bearish | 2 | 1 | 21 | 35301.00 | short | bid | 321.9800 | 0.2500 | ["330","340"] | ["0.2404","0.2590"] | [] | ["XMIO"] | 330.0000 | 340.0000 | 42 | 77 | false | true | |||||||||||
| 01a06dd5-a6d6-78c3-b63f-2e512400a68d | AAPL | 2026-09-04 15:11 | call_diagonal_spread_bearish | 2 | 1 | 18 | 60444.00 | short | ask | 321.7500 | 0.6500 | ["300","370"] | ["0.2921","0.2615"] | [] | ["BATO"] | 300.0000 | 370.0000 | 14 | 196 | false | false | |||||||||||
| 01a06dd0-a1ad-7083-94ad-76d491933893 | AAPL | 2026-09-04 15:06 | call_diagonal_spread_bearish | 2 | 1 | 2 | 38836.00 | short | bid | 321.6250 | 2.8000 | ["250","270"] | ["0.3224","0.3174"] | [] | ["XCBO"] | 250.0000 | 270.0000 | 504 | 833 | false | false | |||||||||||
| 01a06dcd-270d-7d40-8d5a-543b895954f9 | AAPL | 2026-09-04 15:02 | call_diagonal_spread_bearish | 2 | 1 | 10 | 87560.00 | long | bid | 321.6201 | 2.6500 | ["280","300"] | ["0.2862","0.2796"] | [] | ["XCBO"] | 280.0000 | 300.0000 | 42 | 224 | false | false | |||||||||||
| 01a06dcc-c94d-7111-a0dd-f4323cbe9d59 | AAPL | 2026-09-04 15:02 | call_diagonal_spread_bearish | 2 | 1 | 20 | 28400.00 | short | bid | 321.6460 | 0.3000 | ["315","320"] | ["1.0655","0.2554"] | [] | ["XMIO"] | 315.0000 | 320.0000 | 0 | 14 | false | false | |||||||||||
| 01a06daf-469d-7d71-924b-ac01f72c5f19 | AAPL | 2026-09-04 14:29 | call_diagonal_spread_bearish | 2 | 1 | 5 | 39710.00 | long | ask | 320.8950 | 2.2500 | ["360","390"] | ["0.2875","0.2911"] | [] | ["XMIO"] | 360.0000 | 390.0000 | 560 | 833 | false | true | |||||||||||
| 01a06da1-b20e-72b2-97bb-108d20f91d09 | AAPL | 2026-09-04 14:15 | call_diagonal_spread_bearish | 2 | 1 | 6 | 26232.00 | short | ask | 321.2350 | 0.8000 | ["295","370"] | ["0.2952","0.2690"] | [] | ["XCBO"] | 295.0000 | 370.0000 | 14 | 286 | false | false | |||||||||||
| 01a06d96-57cd-78a1-bc2d-1f7175f6b915 | AAPL | 2026-09-04 14:02 | call_diagonal_spread_bearish | 2 | 1 | 14 | 67900.00 | short | bid | 321.0900 | 0.8000 | ["300","310"] | ["0.2922","0.2644"] | [] | ["MCRY"] | 300.0000 | 310.0000 | 14 | 105 | false | false | |||||||||||
| 01a06d96-53e5-7090-9937-4a9af4d47f85 | AAPL | 2026-09-04 14:02 | call_diagonal_spread_bearish | 2 | 1 | 14 | 67676.00 | short | bid | 321.0851 | 1.0000 | ["300","310"] | ["0.2856","0.2632"] | [] | ["BATO"] | 300.0000 | 310.0000 | 14 | 105 | false | false | |||||||||||
| 01a06d91-009d-78f0-b958-d59fe7a0d4b2 | AAPL | 2026-09-04 13:56 | call_diagonal_spread_bearish | 2 | 1 | 2 | 31364.00 | long | bid | 320.9800 | 1.9500 | ["245","280"] | ["0.3534","0.3102"] | [] | ["XISX"] | 245.0000 | 280.0000 | 133 | 504 | false | false | |||||||||||
| 01a06d7a-7715-7353-b4df-2449848c1e8a | AAPL | 2026-09-04 13:32 | call_diagonal_spread_bearish | 2 | 1 | 10 | 26730.00 | long | ask | 321.4000 | 0.4500 | ["330","340"] | ["0.2629","0.2554"] | [] | ["XCBO"] | 330.0000 | 340.0000 | 77 | 133 | false | true | |||||||||||
| 01a06d7a-57d5-7513-8f35-5e0f033f3402 | AAPL | 2026-09-04 13:32 | call_diagonal_spread_bearish | 2 | 1 | 5 | 27900.00 | long | ask | 321.3400 | 0.9000 | ["295","370"] | ["0.3089","0.2798"] | [] | ["XPHO"] | 295.0000 | 370.0000 | 14 | 469 | false | false | |||||||||||
| 01a06d72-6c7d-7400-8165-5a5eba800b1d | AAPL | 2026-09-04 13:23 | call_diagonal_spread_bearish | 2 | 1 | 14 | 48468.00 | short | ask | 321.8100 | 0.4500 | ["330","350"] | ["0.2591","0.2648"] | [] | ["AMXO"] | 330.0000 | 350.0000 | 133 | 196 | false | true | |||||||||||
| 01a06d56-4d46-7162-8f89-c15304b598d4 | AAPL | 2026-09-04 12:52 | call_diagonal_spread_bearish | 2 | 1 | 4 | 26728.00 | short | bid | 321.0600 | 0.4500 | ["290","310"] | ["0.3244","0.2805"] | [] | ["EMLD"] | 290.0000 | 310.0000 | 14 | 196 | false | false | |||||||||||
| 01a06d56-39bd-70a1-9098-794d89c98943 | AAPL | 2026-09-04 12:52 | call_diagonal_spread_bearish | 2 | 2 | 4 | 26680.00 | short | bid | 321.0950 | 0.8000 | ["290","310"] | ["0.3095","0.2796"] | [] | ["EMLD","SPHR"] | 290.0000 | 310.0000 | 14 | 196 | false | false | |||||||||||
| 01a06d3b-85cd-71a2-be19-a8eb28e85f08 | AAPL | 2026-09-04 12:23 | call_diagonal_spread_bearish | 2 | 1 | 50 | 31150.00 | long | bid | 321.0150 | 0.1500 | ["325","330"] | ["0.2699","0.2533"] | [] | ["XISX"] | 325.0000 | 330.0000 | 7 | 14 | false | true | |||||||||||
| 01a06d38-68ed-7771-9e4b-bf5599a631cf | AAPL | 2026-09-04 12:20 | call_diagonal_spread_bearish | 2 | 1 | 2 | 31826.00 | short | ask | 321.3292 | 2.3500 | ["240","245"] | ["0.7567","0.3599"] | [] | ["XCBO"] | 240.0000 | 245.0000 | 14 | 42 | false | false |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:52:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:52:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:52:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:44:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:40:09Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:36:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:35:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:33:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:30:55Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:28:02Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:27:06Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:23:44Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:21:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:14:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:12:20Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:06:36Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| 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 |
| true |
| false |
| mlet |
| tracked |
| 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 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:29:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:15:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:03:22Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:03:22Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:56:56Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:32:52Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:32:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:23:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:52:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:52:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:23:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:20:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |