core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a06dfe-54e5-7d00-a799-1e53da573576 | QQQ | 2026-09-04 15:56 | call_diagonal_spread_bearish | 2 | 1 | 10 | 182970.00 | long | bid | 719.1200 | 6.5400 | ["620","660"] | ["0.3058","0.2397"] | [] | ["EMLD"] | 620.0000 | 660.0000 | 14 | 133 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:18Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 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 | ||||||||||
| 01a06dc3-1cbd-7183-8bf5-f73b47738233 | QQQ | 2026-09-04 14:51 | call_diagonal_spread_bearish | 2 | 1 | 250 | 364250.00 | long | bid | 717.8750 | 2.0900 | ["980","1085"] | ["0.2019","0.2076"] | [] | ["XPHO"] | 980.0000 | 1085.0000 | 378 | 504 | false | true | true | ||||||||||
| 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 | |||||||||||
| 01a06dc2-bb15-7993-8547-bcd97ea68c4f | QQQ | 2026-09-04 14:51 | call_diagonal_spread_bearish | 2 | 1 | 150 | 252600.00 | long | bid | 717.8900 | 2.1700 | ["960","1070"] | ["0.2010","0.2066"] | [] | ["XPHO"] | 960.0000 | 1070.0000 | 378 | 504 | false | true | true | ||||||||||
| 01a06dc2-9405-7b22-85c0-a10b7b821e60 | QQQ | 2026-09-04 14:51 | call_diagonal_spread_bearish | 2 | 1 | 40 | 68000.00 | long | bid | 717.9250 | 2.1100 | ["965","1060"] | ["0.2013","0.2061"] | [] | ["XPHO"] | 965.0000 | 1060.0000 | 378 | 504 | false | true | true | ||||||||||
| 01a06dc2-7c95-7173-acd3-0314209cb9c3 | QQQ | 2026-09-04 14:50 | call_diagonal_spread_bearish | 2 | 1 | 40 | 69400.00 | long | bid | 717.9300 | 2.3000 | ["955","1070"] | ["0.2009","0.2068"] | [] | ["XPHO"] | 955.0000 | 1070.0000 | 378 | 504 | false | true | 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 | |||||||||||
| 01a06da6-364d-7223-90a9-62da26dc4416 | QQQ | 2026-09-04 14:20 | call_diagonal_spread_bearish | 2 | 1 | 6 | 27258.00 | long | bid | 717.4350 | 1.2200 | ["695","700"] | ["0.1588","0.1704"] | [] | ["XMIO"] | 695.0000 | 700.0000 | 11 | 13 | false | 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 | 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 | 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 | 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 | 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 | true | ||||||||||
| 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 | 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 | 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 | 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 | 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 | true | ||||||||||
| 01a06d94-e4b5-7f51-83e8-9b4d39b78c0f | QQQ | 2026-09-04 14:01 | call_diagonal_spread_bearish | 2 | 1 | 5 | 64270.00 | long | bid | 717.1700 | 2.5500 | ["655","750"] | ["0.2130","0.2193"] | [] | ["ARCO"] | 655.0000 | 750.0000 | 26 | 378 | false | false | true | ||||||||||
| 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 | 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 | true | ||||||||||
| 01a06d5f-3a6d-78d3-9557-5cf2bb926111 | QQQ | 2026-09-04 13:02 | call_diagonal_spread_bearish | 2 | 1 | 3 | 46911.00 | long | bid | 718.7300 | 4.2800 | ["630","680"] | ["0.1986","0.2194"] | [] | ["XISX"] | 630.0000 | 680.0000 | 26 | 133 | false | false | true | ||||||||||
| 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 | true | ||||||||||
| 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 | true | ||||||||||
| 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 | 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 | true | ||||||||||
| 01a06d32-0fed-7172-ac28-12354967df12 | QQQ | 2026-09-04 12:13 | call_diagonal_spread_bearish | 2 | 1 | 2 | 45700.00 | long | bid | 718.5200 | 1.9600 | ["565","725"] | ["0.2866","0.2191"] | [] | ["XISX"] | 565.0000 | 725.0000 | 133 | 286 | false | false | true | ||||||||||
| 01a06d2e-6e3d-71d3-9240-4cf8fb8c1abb | QQQ | 2026-09-04 12:09 | call_diagonal_spread_bearish | 2 | 1 | 56 | 25592.00 | long | bid | 718.0800 | 0.1000 | ["715","724"] | ["0.1826","0.1001"] | [] | ["XISX"] | 715.0000 | 724.0000 | 0 | 5 | false | false | 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 |
| true |
| false |
| mlet |
| market_whale |
| 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:51:15Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:51:15Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:51:15Z"} |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:20:35Z"} |
| 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 |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:01:15Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:02:55Z"} |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:13:11Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:09:18Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |