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 | directiontext |
|---|
| 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 |
|---|
| 01a0ca27-abe7-71a1-9b4e-64aca06c5ec1 | LMT | 2026-09-22 13:26 | put_vertical_spread | 2 | 1 | 4 | 222116.00 | short | bid | 518.7900 | 12.2000 | ["795","800"] | ["2.6328","2.6633"] | ["795.01"] | ["XCBO"] | 795.0000 | 800.0000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:27:16Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca20-ba8f-7e40-accc-ca6f272e408a | LMT | 2026-09-22 13:18 | put_vertical_spread | 2 | 1 | 3 | 148689.00 | short | bid | 518.8850 | 15.1000 | ["765","770"] | ["2.6257","2.6593"] | ["765.01"] | ["XCBO"] | 765.0000 | 770.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca1c-e22f-7762-be6f-d0f816d9f3c2 | LMT | 2026-09-22 13:14 | put_vertical_spread | 2 | 1 | 2 | 90938.00 | short | bid | 519.7300 | 14.8000 | ["745","750"] | ["2.5174","2.5682"] | ["745.01"] | ["XCBO"] | 745.0000 | 750.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca1a-bb67-72c2-a692-4a5684584edc | LMT | 2026-09-22 13:12 | put_vertical_spread | 2 | 1 | 3 | 139377.00 | short | bid | 520.1700 | 14.6000 | ["750","755"] | ["1.6430","1.6610"] | ["750.01"] | ["XCBO"] | 750.0000 | 755.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9b1-faff-7691-80d0-aa0d1bf9f9e8 | LMT | 2026-09-22 11:17 | put_vertical_spread | 2 | 1 | 5 | 50655.00 | short | bid | 520.9950 | 10.8000 | ["565","575"] | ["0.3038","0.3245"] | ["565.69"] | ["XPHO"] | 565.0000 | 575.0000 | 24 | 24 | false | false | false | true | |||||||||
| 01a0c99a-0a17-79b1-a9cd-7f5ac9b29271 | LMT | 2026-09-22 10:51 | call_vertical_spread | 2 | 1 | 2 | 35248.00 | short | bid | 517.9800 | 12.9000 | ["450","470"] | ["0.2529","0.2578"] | ["463.30"] | ["XCBO"] | 450.0000 | 470.0000 | 268 | 268 | false | false | false | true | |||||||||
| 01a0c994-e996-76a3-b65e-5239cc1fd1c3 | LMT | 2026-09-22 10:46 | call_vertical_spread | 2 | 1 | 6 | 32166.00 | short | bid | 518.5600 | 3.4000 | ["520","530"] | ["0.2705","0.2709"] | ["524.57"] | ["XMIO"] | 520.0000 | 530.0000 | 87 | 87 | false | true | false | true | |||||||||
| 01a0c992-1ad7-7ef3-8923-0a87608fdfb1 | LMT | 2026-09-22 10:43 | call_calendar | 2 | 1 | 10 | 38240.00 | short | bid | 518.8000 | 2.6000 | ["550"] | ["0.2693"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 87 | 115 | false | true | true | false | |||||||||
| 01a0c987-2627-78b2-abb0-f84f220d6b50 | LMT | 2026-09-22 10:31 | call_calendar | 2 | 1 | 4 | 125992.00 | short | ask | 521.2000 | 13.8000 | ["400"] | ["0.1777"] | [] | ["XCBO"] | 400.0000 | 400.0000 | 486 | 850 | false | false | true | false | |||||||||
| 01a0c46f-9b1f-71a1-ba76-eb97696ece68 | LMT | 2026-09-21 10:47 | call_calendar | 2 | 1 | 6 | 30372.00 | short | ask | 533.5301 | 2.8000 | ["550"] | ["0.2659"] | [] | ["XCBO"] | 550.0000 | 550.0000 | 88 | 116 | false | true | true | false | |||||||||
| 01a0b57b-ef38-7921-b5e3-9a17fed10e0f | LMT | 2026-09-18 13:06 | put_vertical_spread | 2 | 1 | 10 | 52760.00 | short | bid | 530.3676 | 5.1000 | ["520","530"] | ["0.3007","0.3015"] | ["525.22"] | ["XMIO"] | 520.0000 | 530.0000 | 91 | 91 | false | true | false | true | |||||||||
| 01a0b4b6-16c7-7022-afb6-9247156b827d | LMT | 2026-09-18 09:30 | call_vertical_spread | 2 | 1 | 10 | 26810.00 | short | bid | 536.5500 | 11.6000 | ["522.5","525"] | ["0.7593","0.7092"] | ["524.85"] | ["AMXO"] | 522.5000 | 525.0000 | 0 | 0 | false | false | false | true | |||||||||
| 01a0aad0-2f5b-79e3-91b0-56c8f7702474 | LMT | 2026-09-16 11:22 | call_vertical_spread | 2 | 1 | 4 | 135832.00 | short | bid | 538.1900 | 13.2000 | ["365","370"] | ["3.2925","3.0839"] | ["370"] | ["XCBO"] | 365.0000 | 370.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0a612-d556-7252-b1e0-be71932e73bb | LMT | 2026-09-15 13:17 | call_vertical_spread | 2 | 1 | 2 | 69536.00 | short | bid | 534.9600 | 13.6000 | ["360","365"] | ["2.3932","2.3210"] | ["365"] | ["XCBO"] | 360.0000 | 365.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a5c7-9f6e-7222-b523-f6bf01a5be7f | LMT | 2026-09-15 11:55 | call_calendar | 2 | 1 | 2 | 43218.00 | short | bid | 530.0150 | 10.0000 | ["425"] | ["0.3942"] | [] | ["XCBO"] | 425.0000 | 425.0000 | 38 | 45 | false | false | true | false | |||||||||
| 01a0a5c6-bcdd-7713-926c-abeb49b618f3 | LMT | 2026-09-15 11:54 | call_calendar | 2 | 1 | 3 | 59124.00 | short | bid | 529.6750 | 8.6000 | ["435"] | ["0.4019"] | [] | ["XCBO"] | 435.0000 | 435.0000 | 38 | 45 | false | false | true | false | |||||||||
| 01a0a5c6-47ad-7942-9d7f-c9e374cec78f | LMT | 2026-09-15 11:53 | call_calendar | 2 | 1 | 2 | 41334.00 | short | bid | 530.1750 | 11.4000 | ["430"] | ["0.3844"] | [] | ["XCBO"] | 430.0000 | 430.0000 | 38 | 45 | false | false | true | false | |||||||||
| 01a0a5bc-b28e-7ba1-b050-f197ee533e3f | LMT | 2026-09-15 11:43 | call_vertical_spread | 2 | 1 | 3 | 138324.00 | short | bid | 530.8500 | 17.6000 | ["250","350"] | ["5.2389","3.1527"] | ["349.92"] | ["XCBO"] | 250.0000 | 350.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a59f-dfa5-7191-878c-cf65438453d5 | LMT | 2026-09-15 11:11 | call_calendar | 2 | 1 | 9 | 167013.00 | short | ask | 529.8801 | 12.9000 | ["440"] | ["0.3308"] | [] | ["XCBO"] | 440.0000 | 440.0000 | 38 | 45 | false | false | true | false | |||||||||
| 01a0a590-7656-7833-86ba-0b5da046d2e6 | LMT | 2026-09-15 10:55 | call_calendar | 2 | 1 | 4 | 85084.00 | short | ask | 529.4700 | 10.4000 | ["425"] | ["0.3932"] | [] | ["XCBO"] | 425.0000 | 425.0000 | 38 | 45 | false | false | true | false | |||||||||
| 01a0a121-41d9-7383-ac76-eaf8d0f37da2 | LMT | 2026-09-14 14:15 | call_vertical_spread | 2 | 1 | 2 | 54378.00 | short | bid | 527.8999 | 12.8000 | ["390","395"] | ["1.3539","1.3077"] | ["394.99"] | ["XCBO"] | 390.0000 | 395.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a0d2-e358-7c42-97a1-00b3dea1994c | LMT | 2026-09-14 12:49 | call_diagonal_spread | 2 | 1 | 5 | 51825.00 | short | bid | 527.5750 | 8.5000 | ["470","530"] | ["0.2668","0.3096"] | [] | ["XMIO"] | 470.0000 | 530.0000 | 46 | 186 | false | false | true | true | |||||||||
| 01a0a02c-b078-77a0-ba4f-ab03cc7ff755 | LMT | 2026-09-14 09:47 | put_calendar | 2 | 1 | 7 | 65870.00 | short | ask | 527.8550 | 14.8000 | ["530"] | ["0.3045"] | [] | ["XMIO"] | 530.0000 | 530.0000 | 249 | 276 | false | false | true | false | |||||||||
| 01a09159-0511-7592-90b8-547557c08164 | LMT | 2026-09-11 12:42 | call_calendar | 2 | 1 | 3 | 34707.00 | short | ask | 525.3500 | 6.6000 | ["500"] | ["0.2339"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 7 | 497 | false | false | true | false | |||||||||
| 01a09148-1520-75c3-b2bb-a56784942b11 | LMT | 2026-09-11 12:23 | put_vertical_spread | 2 | 1 | 3 | 28545.00 | short | bid | 524.7850 | 8.5000 | ["565","575"] | ["0.2705","0.2818"] | ["566.21"] | ["XMIO"] | 565.0000 | 575.0000 | 35 | 35 | false | false | false | true | |||||||||
| 01a090ce-af01-7e73-9d95-7d9ec8811597 | LMT | 2026-09-11 10:10 | call_vertical_spread | 2 | 1 | 2 | 90666.00 | short | bid | 525.5000 | 12.9000 | ["250","350"] | ["2.6027","1.5334"] | ["349.89"] | ["XCBO"] | 250.0000 | 350.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a08cde-0828-7751-ace2-8bc3ee8c5b1c | LMT | 2026-09-10 15:49 | call_vertical_spread | 2 | 1 | 2 | 71620.00 | short | bid | 529.3042 | 14.6000 | ["300","400"] | ["2.3841","1.3244"] | ["399.92"] | ["XMIO"] | 300.0000 | 400.0000 | 8 | 8 | false | false | false | true | |||||||||
| 01a08cc4-59f0-7f83-8753-a658c9623f9b | LMT | 2026-09-10 15:21 | put_vertical_spread | 2 | 1 | 4 | 28660.00 | short | bid | 527.8900 | 7.0000 | ["470","535"] | ["0.3082","0.3069"] | ["508.09"] | ["XCBO"] | 470.0000 | 535.0000 | 253 | 253 | false | false | false | true | |||||||||
| 01a08211-46d0-79e0-9b7f-c351524e4ee8 | LMT | 2026-09-08 13:29 | call_vertical_spread | 2 | 1 | 2 | 63376.00 | short | bid | 538.6000 | 17.8000 | ["330","430"] | ["3.6449","1.9627"] | ["429.96"] | ["XCBO"] | 330.0000 | 430.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a08211-2b78-7cc0-9004-97ba903d7992 | LMT | 2026-09-08 13:29 | call_vertical_spread | 2 | 1 | 2 | 63374.00 | short | bid | 538.6000 | 17.8000 | ["330","430"] | ["3.6449","1.9627"] | ["429.95"] | ["EDGO"] | 330.0000 | 430.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0817c-d2e8-77d0-a8e3-d04912bc4c25 | LMT | 2026-09-08 10:47 | call_calendar | 2 | 1 | 6 | 101244.00 | short | ask | 540.2817 | 10.3000 | ["500"] | ["0.2570"] | [] | ["XMIO"] | 500.0000 | 500.0000 | 282 | 374 | false | false | true | false | |||||||||
| 01a06d65-ce05-7260-a970-1131977b7f78 | LMT | 2026-09-04 13:09 | call_diagonal_spread_bearish | 2 | 1 | 7 | 69776.00 | short | bid | 526.4300 | 3.4000 | ["500","515"] | ["0.2687","0.2605"] | [] | ["XCBO"] | 500.0000 | 515.0000 | 105 | 196 | false | false | true | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:19:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:15:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:12:39Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:18:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:51:59Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:46:23Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:43:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:31:33Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:47:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:06:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:30:31Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:22:45Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:18:02Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:55:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:55:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:54:09Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:43:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:12:14Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:55:11Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:15:37Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:49:32Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:47:56Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:42:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:24:08Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:49:33Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:21:43Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:29:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:29:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:47:48Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:10:20Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |