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 |
|---|
| 01a06dd7-e50d-7881-90c3-bae319674855 | QQQ | 2026-09-04 15:14 | call_diagonal_spread_bearish | 2 | 1 | 2 | 35460.00 | short | ask | 717.6700 | 2.6200 | ["620","720"] | ["0.2690","0.2227"] | [] | ["XISX"] | 620.0000 | 720.0000 | 105 | 286 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:14:49Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc3-5b3d-7ac3-a9fb-05bbe7864bc5 | QQQ | 2026-09-04 14:51 | call_diagonal_spread_bearish | 2 | 1 | 10 | 38180.00 | short | bid | 717.8850 | 0.3600 | ["699","700"] | ["0.7516","0.1578"] | [] | ["XCBO"] | 699.0000 | 700.0000 | 0 | 7 | false | false | |||||||||||
| 01a06dc3-0935-7890-badc-da75edcbb02f | QQQ | 2026-09-04 14:51 | call_diagonal_spread_bearish | 2 | 3 | 6 | 43328.00 | short | bid | 717.8800 | 1.1500 | ["725","755"] | ["0.1883","0.2128"] | [] | ["AMXO","XCBO","XISX"] | 725.0000 | 755.0000 | 77 | 286 | false | true | |||||||||||
| 01a06daa-83dd-76d2-bbe8-dbd01b3ee1eb | QQQ | 2026-09-04 14:24 | call_diagonal_spread_bearish | 2 | 4 | 1116 | 138384.00 | short | bid | 717.5100 | 0.0200 | ["718","722"] | ["0.1423","0.0813"] | [] | ["AMXO","XCBO","XMIO","XPHO"] | 718.0000 | 722.0000 | 0 | 4 | false | true | |||||||||||
| 01a06daa-7825-7613-a95f-3cccdd00d34a | QQQ | 2026-09-04 14:24 | call_diagonal_spread_bearish | 2 | 1 | 554 | 69804.00 | short | bid | 717.5300 | 0.0200 | ["718","722"] | ["0.1430","0.0815"] | [] | ["ARCO"] | 718.0000 | 722.0000 | 0 | 4 | false | true | |||||||||||
| 01a06da3-d4ed-7f61-ab04-6827bdef6070 | QQQ | 2026-09-04 14:17 | call_diagonal_spread_bearish | 2 | 1 | 60 | 187260.00 | short | bid | 717.0750 | 1.3400 | ["860","940"] | ["0.1949","0.2019"] | [] | ["XPHO"] | 860.0000 | 940.0000 | 286 | 469 | false | true | |||||||||||
| 01a06da2-179d-7b20-b404-041d07370bd8 | QQQ | 2026-09-04 14:15 | call_diagonal_spread_bearish | 2 | 1 | 60 | 236040.00 | short | bid | 717.0300 | 2.1400 | ["835","920"] | ["0.1972","0.2021"] | [] | ["XPHO"] | 835.0000 | 920.0000 | 286 | 469 | false | true | |||||||||||
| 01a06da1-63ed-7b60-b09f-177637c20e34 | QQQ | 2026-09-04 14:14 | call_diagonal_spread_bearish | 2 | 1 | 29 | 101384.00 | short | bid | 717.0200 | 1.5900 | ["845","935"] | ["0.1965","0.2023"] | [] | ["AMXO"] | 845.0000 | 935.0000 | 286 | 469 | false | true | |||||||||||
| 01a06da1-256d-7920-b051-cbf4fe16ca72 | QQQ | 2026-09-04 14:14 | call_diagonal_spread_bearish | 2 | 1 | 30 | 104370.00 | short | bid | 717.1100 | 1.6200 | ["845","935"] | ["0.1962","0.2017"] | [] | ["XPHO"] | 845.0000 | 935.0000 | 286 | 469 | false | true | |||||||||||
| 01a06da0-c3c5-7c13-8d0c-c8df718320dd | QQQ | 2026-09-04 14:14 | call_diagonal_spread_bearish | 2 | 1 | 2 | 34396.00 | short | ask | 717.1700 | 4.1600 | ["620","670"] | ["0.3377","0.2218"] | [] | ["MCRY"] | 620.0000 | 670.0000 | 26 | 133 | false | false | |||||||||||
| 01a06d9d-02d5-7000-bc46-b96b08cba2bd | QQQ | 2026-09-04 14:09 | call_diagonal_spread_bearish | 2 | 1 | 200 | 331400.00 | short | bid | 717.0900 | 1.5000 | ["930","1005"] | ["0.1968","0.2043"] | [] | ["ARCO"] | 930.0000 | 1005.0000 | 286 | 469 | false | true | |||||||||||
| 01a06d9c-a12d-70e0-9b74-335173baa9e1 | QQQ | 2026-09-04 14:09 | call_diagonal_spread_bearish | 2 | 1 | 250 | 420750.00 | short | bid | 716.8900 | 0.7800 | ["940","990"] | ["0.1967","0.2027"] | [] | ["XPHO"] | 940.0000 | 990.0000 | 286 | 469 | false | true | |||||||||||
| 01a06d9c-7a1d-7f72-8ba3-8c36e4f64e7b | QQQ | 2026-09-04 14:09 | call_diagonal_spread_bearish | 2 | 1 | 150 | 269250.00 | short | bid | 716.8900 | 0.7700 | ["925","990"] | ["0.1956","0.2032"] | [] | ["ARCO"] | 925.0000 | 990.0000 | 286 | 469 | false | true | |||||||||||
| 01a06d9c-530d-7273-a94b-e27dd6963c88 | QQQ | 2026-09-04 14:09 | call_diagonal_spread_bearish | 2 | 1 | 39 | 73710.00 | short | bid | 716.8900 | 1.3000 | ["920","985"] | ["0.1957","0.2034"] | [] | ["AMXO"] | 920.0000 | 985.0000 | 286 | 469 | false | true | |||||||||||
| 01a06d9c-436d-7433-a963-93c4e44affef | QQQ | 2026-09-04 14:09 | call_diagonal_spread_bearish | 2 | 1 | 40 | 73880.00 | short | bid | 716.9400 | 1.8000 | ["920","985"] | ["0.1946","0.2018"] | [] | ["XPHO"] | 920.0000 | 985.0000 | 286 | 469 | false | true | |||||||||||
| 01a06d98-b15d-7622-a4c4-a1ad4219ea18 | QQQ | 2026-09-04 14:05 | call_diagonal_spread_bearish | 2 | 1 | 5 | 85980.00 | short | ask | 716.6900 | 3.9200 | ["620","670"] | ["0.3586","0.2245"] | [] | ["MCRY"] | 620.0000 | 670.0000 | 26 | 133 | false | false | |||||||||||
| 01a06d88-03d5-7330-bda8-7cffdd6de73b | QQQ | 2026-09-04 13:47 | call_diagonal_spread_bearish | 2 | 1 | 3 | 25326.00 | short | ask | 716.8600 | 2.7200 | ["670","725"] | ["0.2666","0.1967"] | [] | ["EMLD"] | 670.0000 | 725.0000 | 14 | 133 | false | false | |||||||||||
| 01a06d75-c7dd-70f3-b0b9-f765b464a904 | QQQ | 2026-09-04 13:27 | call_diagonal_spread_bearish | 2 | 1 | 4 | 32144.00 | short | bid | 717.7700 | 1.7600 | ["720","750"] | ["0.1899","0.2183"] | [] | ["XCBO"] | 720.0000 | 750.0000 | 87 | 299 | false | true | |||||||||||
| 01a06d72-262d-7770-97f6-5c7bea3331aa | QQQ | 2026-09-04 13:23 | call_diagonal_spread_bearish | 2 | 1 | 17 | 936980.00 | short | ask | 717.8900 | 7.0400 | ["440","500"] | ["0.3662","0.2991"] | [] | ["XCBO"] | 440.0000 | 500.0000 | 286 | 469 | false | false | |||||||||||
| 01a06d5a-9ebd-7b70-b98e-0db44d792c5c | QQQ | 2026-09-04 12:57 | call_diagonal_spread_bearish | 2 | 1 | 16 | 247840.00 | short | ask | 719.3100 | 2.0200 | ["640","650"] | ["0.2962","0.2328"] | [] | ["XISX"] | 640.0000 | 650.0000 | 14 | 42 | false | false | |||||||||||
| 01a06d59-1c05-7c02-b116-f16a358a4c1e | QQQ | 2026-09-04 12:55 | call_diagonal_spread_bearish | 2 | 1 | 4 | 63380.00 | short | ask | 719.4100 | 4.2000 | ["630","680"] | ["0.3227","0.2162"] | [] | ["XMIO"] | 630.0000 | 680.0000 | 26 | 133 | false | false | |||||||||||
| 01a06d3d-56a5-7442-918d-19faec9c13d5 | QQQ | 2026-09-04 12:25 | call_diagonal_spread_bearish | 2 | 1 | 21 | 27783.00 | short | bid | 718.5700 | 0.2700 | ["770","785"] | ["0.1506","0.1761"] | [] | ["XMIO"] | 770.0000 | 785.0000 | 42 | 133 | false | true | |||||||||||
| 01a06d36-7105-71f1-b6d1-260096433bf9 | QQQ | 2026-09-04 12:17 | call_diagonal_spread_bearish | 2 | 1 | 7 | 31808.00 | short | bid | 718.2800 | 0.6700 | ["705","716"] | ["0.1693","0.1816"] | [] | ["XMIO"] | 705.0000 | 716.0000 | 26 | 56 | false | false | |||||||||||
| 01a06d24-92cd-7011-b24a-4ecd31ae8b80 | QQQ | 2026-09-04 11:58 | call_diagonal_spread_bearish | 2 | 1 | 2 | 27928.00 | short | ask | 717.5097 | 5.3100 | ["650","655"] | ["0.3624","0.2279"] | [] | ["XCBO"] | 650.0000 | 655.0000 | 14 | 49 | false | false |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:52:02Z"} |
| 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:52:02Z"} |
| 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:25:02Z"} |
| 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-04T18:25:02Z"} |
| 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:17: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-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:15:16Z"} |
| 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:14:38Z"} |
| 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:14:38Z"} |
| 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:10:05Z"} |
| 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:10:05Z"} |
| 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:10:05Z"} |
| 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:09: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-04T18:09:19Z"} |
| 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-04T18:06:02Z"} |
| 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:47: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:27:29Z"} |
| 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:23:49Z"} |
| 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:57:38Z"} |
| 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:56: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-04T16:25:47Z"} |
| 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:18:31Z"} |
| 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-04T15:59:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |