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 |
|---|
| 01a06e02-489d-78d2-8652-f4869709ed9e | QQQ | 2026-09-04 16:00 | put_diagonal_spread_bearish | 2 | 1 | 160 | 31840.00 | short | bid | 718.7300 | 0.0200 | ["715","717"] | ["2.3051","0.0962"] | [] | ["XMIO"] | 715.0000 | 717.0000 | 0 | 4 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T20:02:41Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df7-ec45-7c30-87e9-bb2fba1790cc | QQQ | 2026-09-04 15:49 | put_diagonal_spread_bearish | 2 | 1 | 17 | 66912.00 | short | bid | 718.4800 | 0.6600 | ["735","740"] | ["0.1389","0.1534"] | [] | ["XCBO"] | 735.0000 | 740.0000 | 7 | 14 | false | false | true | ||||||||||
| 01a06df6-1b6d-70e3-a470-a6ff4707abb1 | QQQ | 2026-09-04 15:47 | put_diagonal_spread_bearish | 2 | 1 | 24 | 31776.00 | short | bid | 718.4650 | 0.1900 | ["720","725"] | ["0.3010","0.1537"] | [] | ["AMXO"] | 720.0000 | 725.0000 | 0 | 14 | false | false | true | ||||||||||
| 01a06db7-9b6d-7cf0-8c9f-a309bc64af8d | QQQ | 2026-09-04 14:39 | put_diagonal_spread_bearish | 2 | 1 | 72 | 68760.00 | short | bid | 717.5750 | 0.1000 | ["711","713"] | ["0.1473","0.1638"] | [] | ["XISX"] | 711.0000 | 713.0000 | 7 | 14 | false | true | true | ||||||||||
| 01a06daf-db0d-7e23-801a-f26377329f88 | QQQ | 2026-09-04 14:30 | put_diagonal_spread_bearish | 2 | 2 | 50 | 743157.00 | short | bid | 717.7250 | 3.4900 | ["755","785"] | ["0.2112","0.2419"] | [] | ["XPHO"] | 755.0000 | 785.0000 | 196 | 469 | false | false | true | ||||||||||
| 01a06daf-8135-7c91-bc05-64df834bf28f | QQQ | 2026-09-04 14:30 | put_diagonal_spread_bearish | 2 | 1 | 50 | 744000.00 | short | bid | 717.6301 | 3.3800 | ["755","785"] | ["0.2112","0.2421"] | [] | ["XPHO"] | 755.0000 | 785.0000 | 196 | 469 | false | false | true | ||||||||||
| 01a06daf-5255-7673-a3cc-9e1304c0ec75 | QQQ | 2026-09-04 14:29 | put_diagonal_spread_bearish | 2 | 1 | 25 | 379675.00 | short | bid | 717.5700 | 3.5200 | ["755","790"] | ["0.2110","0.2427"] | [] | ["XPHO"] | 755.0000 | 790.0000 | 196 | 469 | false | false | true | ||||||||||
| 01a06daf-081d-7470-8b82-efa34312a1f8 | QQQ | 2026-09-04 14:29 | put_diagonal_spread_bearish | 2 | 1 | 25 | 375900.00 | short | bid | 717.6000 | 3.3300 | ["740","800"] | ["0.2136","0.2445"] | [] | ["XPHO"] | 740.0000 | 800.0000 | 196 | 469 | false | false | true | ||||||||||
| 01a06dae-e4f5-7280-92c9-57b76de3ede6 | QQQ | 2026-09-04 14:29 | put_diagonal_spread_bearish | 2 | 1 | 25 | 375625.00 | short | bid | 717.5150 | 3.5000 | ["740","800"] | ["0.2134","0.2440"] | [] | ["XPHO"] | 740.0000 | 800.0000 | 196 | 469 | false | false | true | ||||||||||
| 01a06d50-e28d-74a1-a1e1-938e296d8de7 | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 4 | 23 | 35820.00 | short | bid | 718.9500 | 0.1022 | ["710","718"] | ["0.1689","0.1680"] | [] | ["AMXO","XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-e28d-74a1-a1e1-937e4b4e8581 | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 3 | 26 | 40536.00 | short | bid | 718.9500 | 0.1100 | ["710","718"] | ["0.1691","0.1681"] | [] | ["AMXO","XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-cb1d-7090-9aa2-dcf614198b2f | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 2 | 46 | 71438.00 | short | bid | 718.9600 | 0.1050 | ["710","718"] | ["0.1686","0.1678"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-abdd-71f3-8761-2a789bd23190 | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 2 | 250 | 389200.00 | short | bid | 718.9300 | 0.1240 | ["710","718"] | ["0.1687","0.1678"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-abdd-71f3-8761-2a6eb9e2e104 | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 2 | 300 | 467100.00 | short | bid | 718.9300 | 0.1200 | ["710","718"] | ["0.1688","0.1679"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d50-abdd-71f3-8761-2a5c32c04f7b | QQQ | 2026-09-04 12:46 | put_diagonal_spread_bearish | 2 | 2 | 300 | 467100.00 | short | bid | 718.9300 | 0.1200 | ["710","718"] | ["0.1688","0.1679"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4e-cb65-7de0-b3bc-c02ee55e60a0 | QQQ | 2026-09-04 12:44 | put_diagonal_spread_bearish | 2 | 1 | 40 | 62240.00 | short | bid | 718.9150 | 0.0900 | ["710","718"] | ["0.1686","0.1677"] | [] | ["XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4e-cb65-7de0-b3bc-c01d15e4c8cd | QQQ | 2026-09-04 12:44 | put_diagonal_spread_bearish | 2 | 2 | 120 | 186720.00 | short | bid | 718.9150 | 0.1200 | ["710","718"] | ["0.1686","0.1677"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4e-cb65-7de0-b3bc-c00cd1e7d077 | QQQ | 2026-09-04 12:44 | put_diagonal_spread_bearish | 2 | 3 | 180 | 280080.00 | short | bid | 718.9150 | 0.1100 | ["710","718"] | ["0.1686","0.1677"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4e-a06d-7340-9939-22c170b7ebf2 | QQQ | 2026-09-04 12:44 | put_diagonal_spread_bearish | 2 | 1 | 150 | 233700.00 | short | bid | 718.9300 | 0.1200 | ["710","718"] | ["0.1688","0.1679"] | [] | ["AMXO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4d-d165-7921-ae84-69650c79586a | QQQ | 2026-09-04 12:43 | put_diagonal_spread_bearish | 2 | 1 | 150 | 235200.00 | short | bid | 718.7900 | 0.1500 | ["710","718"] | ["0.1687","0.1679"] | [] | ["XISX"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4d-d165-7921-ae84-69538b17708c | QQQ | 2026-09-04 12:43 | put_diagonal_spread_bearish | 2 | 2 | 250 | 391800.00 | short | bid | 718.7900 | 0.1500 | ["710","718"] | ["0.1686","0.1678"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4d-d165-7921-ae84-6943276776c3 | QQQ | 2026-09-04 12:43 | put_diagonal_spread_bearish | 2 | 2 | 300 | 470100.00 | short | bid | 718.7900 | 0.1500 | ["710","718"] | ["0.1686","0.1678"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4d-d164-7b00-9d97-4d4166df3416 | QQQ | 2026-09-04 12:43 | put_diagonal_spread_bearish | 2 | 2 | 300 | 470100.00 | short | bid | 718.7900 | 0.1250 | ["710","718"] | ["0.1686","0.1678"] | [] | ["XCBO","XPHO"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4d-390d-7b82-80ec-827e1d31a3ae | QQQ | 2026-09-04 12:42 | put_diagonal_spread_bearish | 2 | 1 | 1000 | 1569000.00 | short | bid | 718.7550 | 0.1200 | ["710","718"] | ["0.1685","0.1678"] | [] | ["XISX"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true | ||||||||||
| 01a06d4c-2f6d-7852-b00c-ca998a81a481 | QQQ | 2026-09-04 12:41 | put_diagonal_spread_bearish | 2 | 1 | 1000 | 1568000.00 | short | bid | 718.7800 | 0.1300 | ["710","718"] | ["0.1687","0.1678"] | [] | ["XISX"] | 710.0000 | 718.0000 | 14 | 21 | false | true | true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:49: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-04T19:47: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-04T18:39:57Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:47:14Z"} |
| 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:47:14Z"} |
| 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:47:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| market_whale |
| 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 |
| false |
| mlet |
| tracked |
| 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 |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:44:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:43:54Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:43:54Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:43:54Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:43:54Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:43:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:41:49Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |