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 |
|---|
| 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 |
|---|
| 01a06e00-6826-72b2-aace-bf4c3c99a5dd | AAPL | 2026-09-04 15:58 | call_diagonal_spread_bearish | 2 | 1 | 13 | 105716.00 | short | bid | 319.9500 | 2.8500 | ["280","300"] | ["0.3710","0.2893"] | [] | ["XCBO"] | 280.0000 | 300.0000 | 14 | 196 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:58:42Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06e00-6055-7b32-9868-d0c0defce0f0 | AAPL | 2026-09-04 15:58 | call_diagonal_spread_bearish | 2 | 1 | 14 | 113946.00 | short | bid | 319.9300 | 2.9500 | ["280","300"] | ["0.3885","0.2896"] | [] | ["XMIO"] | 280.0000 | 300.0000 | 14 | 196 | false | false | |||||||||||
| 01a06e00-549d-7af2-a6e7-c30fc4b5681e | AAPL | 2026-09-04 15:58 | call_diagonal_spread_bearish | 2 | 1 | 13 | 105794.00 | short | bid | 319.9500 | 2.9500 | ["280","300"] | ["0.3779","0.2897"] | [] | ["XCBO"] | 280.0000 | 300.0000 | 14 | 196 | false | false | |||||||||||
| 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 | |||||||||||
| 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-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 | |||||||||||
| 01a06df9-24c5-7f22-95cf-0ec496b80916 | AAPL | 2026-09-04 15:50 | call_diagonal_spread_bearish | 2 | 3 | 60 | 137256.00 | short | bid | 320.3650 | 2.5000 | ["315","320"] | ["0.2695","0.2544"] | [] | ["BATO","C2OX","EDGO"] | 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a06dd3-512d-75c0-9736-8e231280251b | AAPL | 2026-09-04 15:09 | call_diagonal_spread_bearish | 2 | 1 | 31 | 103881.00 | short | ask | 321.8092 | 0.6000 | ["300","370"] | ["0.2816","0.2612"] | [] | ["XMIO"] | 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 01a06d8b-6ed5-7fc2-96cb-d4a5fa0d69fd | AAPL | 2026-09-04 13:50 | call_diagonal_spread_bearish | 2 | 1 | 60 | 1109520.00 | short | bid | 321.1000 | 3.6500 | ["230","240"] | ["0.7554","0.3324"] | [] | ["XMIO"] | 230.0000 | 240.0000 | 14 | 286 | false | false | |||||||||||
| 01a06d86-c76d-79a1-8f3d-62fe3eed109f | AAPL | 2026-09-04 13:45 | call_diagonal_spread_bearish | 2 | 1 | 10 | 346360.00 | short | ask | 321.0100 | 5.9500 | ["155","160"] | ["0.4664","0.4369"] | [] | ["XCBO"] | 155.0000 | 160.0000 | 378 | 504 | false | false | |||||||||||
| 01a06d85-600d-7990-8770-c03cf6ffe7e9 | AAPL | 2026-09-04 13:44 | call_diagonal_spread_bearish | 2 | 1 | 31 | 260152.00 | short | bid | 320.8999 | 1.3500 | ["280","290"] | ["0.3956","0.2796"] | [] | ["BATO"] | 280.0000 | 290.0000 | 14 | 133 | 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 | |||||||||||
| 01a06d46-bce5-7482-8f9f-4109869aaa7c | AAPL | 2026-09-04 12:35 | call_diagonal_spread_bearish | 2 | 1 | 30 | 261300.00 | short | bid | 321.0000 | 1.6500 | ["290","330"] | ["0.2960","0.2847"] | [] | ["XMIO"] | 290.0000 | 330.0000 | 133 | 469 | false | false | |||||||||||
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:58:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:58: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:54:48Z"} |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:50:54Z"} |
| 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:36:42Z"} |
| 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 |
| 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 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:09: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: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-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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:51:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:45:59Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:44:33Z"} |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:36: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-04T16:20:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |