core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a06de9-a405-7b10-b661-bbda44e17fe4 | SPX | 2026-09-04 15:33 | call_diagonal_spread_bearish | 2 | 1 | 13 | 110916.00 | short | bid | 7714.6300 | 1.1000 | ["8010","8060"] | ["0.1015","0.1142"] | [] | ["XCBO"] | 8010.0000 | 8060.0000 | 42 | 77 | false | true | true | true | false | mlet | market_whale | 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 |
| 01a06de9-6d54-7263-96c1-ed75ecf899b8 | SPX | 2026-09-04 15:33 | call_diagonal_spread_bearish | 2 | 1 | 3 | 130167.00 | short | bid | 7714.7000 | 1.8000 | ["7780","8000"] | ["0.1267","0.1356"] | [] | ["XCBO"] | 7780.0000 | 8000.0000 | 77 | 196 | false | true | |||||||||||
| 01a06dd9-9e75-70a0-bc18-8359a8f3120e | SPX | 2026-09-04 15:16 | call_diagonal_spread_bearish | 2 | 1 | 5 | 215395.00 | short | bid | 7711.8100 | 1.6000 | ["7780","8000"] | ["0.1266","0.1355"] | [] | ["XCBO"] | 7780.0000 | 8000.0000 | 77 | 196 | false | true | |||||||||||
| 01a06dcb-3add-7922-a3e1-d3e714b94926 | SPX | 2026-09-04 15:00 | call_diagonal_spread_bearish | 2 | 1 | 10 | 82660.00 | short | ask | 7718.1800 | 1.7000 | ["7675","7685"] | ["0.2213","0.0495"] | [] | ["XCBO"] | 7675.0000 | 7685.0000 | 0 | 4 | false | false | |||||||||||
| 01a06dca-b60d-7461-81e0-34d89c0ddd8e | SPX | 2026-09-04 14:59 | call_diagonal_spread_bearish | 2 | 1 | 2 | 86358.00 | short | bid | 7718.2600 | 1.8000 | ["7785","8000"] | ["0.1253","0.1350"] | [] | ["XCBO"] | 7785.0000 | 8000.0000 | 77 | 196 | false | true | |||||||||||
| 01a06dca-b225-7a63-9b1f-8b17b932146a | SPX | 2026-09-04 14:59 | call_diagonal_spread_bearish | 2 | 1 | 16 | 47744.00 | short | bid | 7718.3500 | 0.6000 | ["9300","10000"] | ["0.1194","0.1255"] | [] | ["XCBO"] | 9300.0000 | 10000.0000 | 196 | 378 | false | true | |||||||||||
| 01a06dbe-07f5-78a2-a8f4-fa01f826e115 | SPX | 2026-09-04 14:46 | call_diagonal_spread_bearish | 2 | 1 | 15 | 40680.00 | short | bid | 7716.5500 | 0.9000 | ["8140","8300"] | ["0.0988","0.1092"] | [] | ["XCBO"] | 8140.0000 | 8300.0000 | 42 | 77 | false | true | |||||||||||
| 01a06dbd-cd5d-7330-b7a2-1c495cb2ac2a | SPX | 2026-09-04 14:45 | call_diagonal_spread_bearish | 2 | 1 | 6 | 337356.00 | short | bid | 7716.6300 | 2.2000 | ["7790","8225"] | ["0.1249","0.1456"] | [] | ["XCBO"] | 7790.0000 | 8225.0000 | 77 | 378 | false | true | |||||||||||
| 01a06dbd-4c75-7502-9720-e0c6ce910c0b | SPX | 2026-09-04 14:45 | call_diagonal_spread_bearish | 2 | 1 | 16 | 38032.00 | short | bid | 7716.9100 | 0.8000 | ["8290","10000"] | ["0.1021","0.1253"] | [] | ["XCBO"] | 8290.0000 | 10000.0000 | 42 | 378 | false | true | |||||||||||
| 01a06daf-ee95-7c11-b340-d2cdf65a10c6 | SPX | 2026-09-04 14:30 | call_diagonal_spread_bearish | 2 | 1 | 2 | 113232.00 | short | bid | 7714.8800 | 2.2000 | ["7780","8225"] | ["0.1255","0.1456"] | [] | ["XCBO"] | 7780.0000 | 8225.0000 | 77 | 378 | false | true | |||||||||||
| 01a06daf-bfb5-72f1-9676-b02b639ab04a | SPX | 2026-09-04 14:30 | call_diagonal_spread_bearish | 2 | 1 | 19 | 55651.00 | short | bid | 7714.8600 | 0.7000 | ["8140","10000"] | ["0.0988","0.1253"] | [] | ["XCBO"] | 8140.0000 | 10000.0000 | 42 | 378 | false | true | |||||||||||
| 01a06da2-13b5-7903-a7f5-5ea3da43c364 | SPX | 2026-09-04 14:15 | call_diagonal_spread_bearish | 2 | 1 | 19 | 50388.00 | short | bid | 7712.0200 | 0.7000 | ["8140","8300"] | ["0.0992","0.1093"] | [] | ["XCBO"] | 8140.0000 | 8300.0000 | 42 | 77 | false | true | |||||||||||
| 01a06da1-eca5-70d2-9c9d-3257cfdd194c | SPX | 2026-09-04 14:15 | call_diagonal_spread_bearish | 2 | 1 | 12 | 509148.00 | short | bid | 7712.7700 | 1.6000 | ["7790","8000"] | ["0.1252","0.1352"] | [] | ["XCBO"] | 7790.0000 | 8000.0000 | 77 | 196 | false | true | |||||||||||
| 01a06da1-bdc5-76f0-a04f-dcd837bdfd7b | SPX | 2026-09-04 14:15 | call_diagonal_spread_bearish | 2 | 1 | 19 | 48488.00 | short | bid | 7712.2600 | 0.8000 | ["8210","10000"] | ["0.0995","0.1254"] | [] | ["XCBO"] | 8210.0000 | 10000.0000 | 42 | 378 | false | true | |||||||||||
| 01a06d50-55ed-79e1-945a-45b5f840c4a6 | SPX | 2026-09-04 12:46 | call_diagonal_spread_bearish | 2 | 1 | 9 | 25749.00 | short | bid | 7724.9500 | 0.7000 | ["8140","8300"] | ["0.0990","0.1090"] | [] | ["XCBO"] | 8140.0000 | 8300.0000 | 42 | 77 | false | true | |||||||||||
| 01a06d4f-9a6d-7bb3-a64d-d09ea556fc8a | SPX | 2026-09-04 12:45 | call_diagonal_spread_bearish | 2 | 1 | 19 | 54359.00 | short | bid | 7724.7400 | 0.7000 | ["8140","8300"] | ["0.0990","0.1091"] | [] | ["XCBO"] | 8140.0000 | 8300.0000 | 42 | 77 | false | true | |||||||||||
| 01a06d4e-bfad-7ba1-b6df-5b1f63a5f0ee | SPX | 2026-09-04 12:44 | call_diagonal_spread_bearish | 2 | 1 | 6 | 342252.00 | short | bid | 7725.1700 | 2.4000 | ["7790","8225"] | ["0.1251","0.1454"] | [] | ["XCBO"] | 7790.0000 | 8225.0000 | 77 | 378 | false | true | |||||||||||
| 01a06d45-5585-7b91-8f52-4b5ef2017bda | SPX | 2026-09-04 12:34 | call_diagonal_spread_bearish | 2 | 1 | 19 | 53713.00 | short | bid | 7724.4200 | 0.8000 | ["8140","8300"] | ["0.0988","0.1088"] | [] | ["XCBO"] | 8140.0000 | 8300.0000 | 42 | 77 | false | true | |||||||||||
| 01a06d45-3645-77a0-b0d7-1352b29827a3 | SPX | 2026-09-04 12:34 | call_diagonal_spread_bearish | 2 | 1 | 19 | 53694.00 | short | bid | 7724.1100 | 0.8000 | ["8140","8300"] | ["0.0989","0.1088"] | [] | ["XCBO"] | 8140.0000 | 8300.0000 | 42 | 77 | false | true | |||||||||||
| 01a06d45-3645-77a0-b0d7-1348c30079b5 | SPX | 2026-09-04 12:34 | call_diagonal_spread_bearish | 2 | 1 | 3 | 170601.00 | short | bid | 7724.1100 | 2.1000 | ["7790","8225"] | ["0.1249","0.1453"] | [] | ["XCBO"] | 7790.0000 | 8225.0000 | 77 | 378 | false | true | |||||||||||
| 01a06d44-d49d-7ed2-9fe0-e21fd04ff86b | SPX | 2026-09-04 12:33 | call_diagonal_spread_bearish | 2 | 1 | 6 | 339252.00 | short | bid | 7724.0500 | 2.4000 | ["7795","8225"] | ["0.1244","0.1453"] | [] | ["XCBO"] | 7795.0000 | 8225.0000 | 77 | 378 | false | true | |||||||||||
| 01a06d39-5b1d-7050-a0db-7da632e523be | SPX | 2026-09-04 12:21 | call_diagonal_spread_bearish | 2 | 1 | 4 | 46916.00 | short | bid | 7725.1100 | 0.6000 | ["7685","7695"] | ["0.0764","0.0917"] | [] | ["XCBO"] | 7685.0000 | 7695.0000 | 6 | 7 | false | false |
| true |
| false |
| mlet |
| market_whale |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:16:27Z"} |
| 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:00: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:00:17Z"} |
| 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:00:17Z"} |
| 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:46:13Z"} |
| 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-04T18:46: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-04T18:45:37Z"} |
| 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-04T18:31:18Z"} |
| 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:30:29Z"} |
| 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:16:10Z"} |
| 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-04T18:16:10Z"} |
| 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-04T16:46:37Z"} |
| 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:45:52Z"} |
| 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:45:11Z"} |
| 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:34: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-04T16:34:11Z"} |
| 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:34:11Z"} |
| 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:34:11Z"} |
| 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:21:24Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |