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_side |
|---|
| 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 |
|---|
| 01a0912f-87f8-7f22-bbb0-38a25fb9e69e | AMAT | 2026-09-11 11:56 | other | 4 | 1 | 841 | 1564260.00 | unknown | — | 462.5000 | 0.8500 | ["460","470","482.5"] | ["0.4911","0.4862","0.5005"] | [] | ["EDGO"] | 460.0000 | 482.5000 | 0 | 7 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:57:10Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09105-d818-7690-8b11-c6622aee46fe | AMAT | 2026-09-11 11:11 | put_diagonal_spread | 2 | 1 | 20 | 152060.00 | long | ask | 461.9950 | 5.8000 | ["480","495"] | ["0.5308","0.5598"] | [] | ["XCBO"] | 480.0000 | 495.0000 | 7 | 35 | false | false | true | true | false | ||||||||
| 01a08c3c-bb30-7c42-aae5-60e758703cce | AMAT | 2026-09-10 12:53 | other | 4 | 1 | 15 | 270705.00 | unknown | — | 457.5050 | 4.6000 | ["470","480"] | ["0.5334","0.5335"] | [] | ["XCBO"] | 470.0000 | 480.0000 | 8 | 127 | false | false | true | true | false | mlat | |||||||
| 01a08c11-b779-7683-8fd0-ea1622ef185a | AMAT | 2026-09-10 12:06 | put_vertical_spread | 2 | 1 | 25 | 164165.00 | unknown | — | 458.5300 | 2.9500 | ["460","470"] | ["0.5260","0.5273"] | [] | ["XCBO"] | 460.0000 | 470.0000 | 36 | 36 | false | false | false | true | false | mlat | |||||||
| 01a08bb9-6a00-79c0-bafd-27c15a7f9d2c | AMAT | 2026-09-10 10:29 | other | 4 | 1 | 10 | 118660.00 | unknown | — | 458.3489 | 13.8000 | ["465","470","480"] | ["0.5478","0.6823","0.6016"] | [] | ["XCBO"] | 465.0000 | 480.0000 | 1 | 43 | false | false | true | true | false | mlat | |||||||
| 01a087bb-0b70-7743-bd46-0818a5c32bbb | AMAT | 2026-09-09 15:52 | put_calendar | 2 | 1 | 40 | 452513.00 | long | ask | 468.1900 | 9.4000 | ["500"] | ["0.5600"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 16 | 100 | false | false | true | false | false | ||||||||
| 01a0876a-5b30-7570-958d-6db64b640f08 | AMAT | 2026-09-09 14:24 | call_vertical_spread | 2 | 1 | 19 | 255512.00 | unknown | — | 467.4600 | 7.4500 | ["460","470"] | ["0.5754","0.5755"] | [] | ["XCBO"] | 460.0000 | 470.0000 | 128 | 128 | false | false | false | true | false | mlat | |||||||
| 01a086e7-3cc8-7782-b1f6-964695515c11 | AMAT | 2026-09-09 12:01 | other | 2 | 1 | 4 | 135596.00 | unknown | — | 467.6850 | 4.3000 | ["300"] | ["1.9279"] | [] | ["XCBO"] | 300.0000 | 300.0000 | 2 | 37 | false | false | true | false | false | mlat | |||||||
| 01a0866f-8070-7523-9889-d0bfb97a3ab5 | AMAT | 2026-09-09 09:50 | call_vertical_spread | 2 | 1 | 10 | 119260.00 | unknown | — | 465.0250 | 9.4500 | ["460","470"] | ["0.5920","0.5932"] | [] | ["XCBO"] | 460.0000 | 470.0000 | 100 | 100 | false | false | false | true | false | mlat | |||||||
| 01a0827b-3401-73d2-be3c-2bed0a857baf | AMAT | 2026-09-08 15:25 | put_calendar | 2 | 1 | 100 | 120600.00 | short | ask | 471.6750 | 1.1700 | ["445"] | ["0.5729"] | [] | ["XCBO"] | 445.0000 | 445.0000 | 3 | 17 | false | true | true | false | false | ||||||||
| 01a0826d-a740-7f12-8e9f-240b1ceaa924 | AMAT | 2026-09-08 15:10 | other | 2 | 1 | 40 | 117360.00 | unknown | — | 471.7450 | 2.3500 | ["490"] | ["0.5514"] | [] | ["AMXO"] | 490.0000 | 490.0000 | 10 | 24 | false | true | true | false | false | mlat | |||||||
| 01a08203-4cb0-71f1-a98b-e12aa600235c | AMAT | 2026-09-08 13:14 | call_vertical_spread | 2 | 1 | 18 | 137856.00 | long | ask | 471.0050 | 4.9500 | ["460","470"] | ["0.5686","0.5689"] | ["464.97"] | ["XCBO"] | 460.0000 | 470.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a081e4-9568-7a63-8932-92c0fe53bfb2 | AMAT | 2026-09-08 12:40 | put_calendar | 2 | 1 | 50 | 367738.00 | short | ask | 468.7100 | 11.0000 | ["500"] | ["0.5717"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 3 | 17 | false | false | true | false | false | ||||||||
| 01a081c3-51c8-74c3-adc1-2acc91053ff6 | AMAT | 2026-09-08 12:04 | call_diagonal_spread | 2 | 1 | 3 | 104628.00 | short | ask | 470.8000 | 17.4500 | ["360","500"] | ["0.5874","0.5875"] | [] | ["XCBO"] | 360.0000 | 500.0000 | 500 | 829 | false | false | true | true | |||||||||
| 01a081b8-5548-77d2-9dae-2bae5029f1b9 | AMAT | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 54 | 112320.00 | short | bid | 469.2250 | 1.3000 | ["470","520"] | ["0.5594","0.5849"] | ["483.58"] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 10 | false | true | false | true | |||||||||
| 01a081b8-5160-7a62-aa44-f63cd74413be | AMAT | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 54 | 112320.00 | short | bid | 469.2250 | 1.3000 | ["470","520"] | ["0.5594","0.5849"] | ["483.58"] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 10 | false | true | false | true | |||||||||
| 01a081b8-5160-7a62-aa44-f62384b80bbe | AMAT | 2026-09-08 11:52 | call_vertical_spread | 2 | 1 | 54 | 112320.00 | short | bid | 469.2250 | 1.3000 | ["470","520"] | ["0.5594","0.5849"] | ["483.58"] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 10 | false | true | false | true | |||||||||
| 01a081b7-e7e8-7ff2-981e-cb3a5636d2b5 | AMAT | 2026-09-08 11:51 | other | 3 | 1 | 173 | 482162.00 | unknown | — | 469.1400 | 3.1000 | ["470","520"] | ["0.5667","0.5774"] | [] | ["XMIO"] | 470.0000 | 520.0000 | 10 | 17 | false | true | true | true | false | mlat | |||||||
| 01a081ab-c288-7a93-9d48-c490a92e9d04 | AMAT | 2026-09-08 11:38 | call_diagonal_spread | 2 | 1 | 40 | 247120.00 | long | ask | 469.1400 | 2.5500 | ["450","520"] | ["0.5750","0.6050"] | [] | ["XCBO"] | 450.0000 | 520.0000 | 10 | 73 | false | false | true | true | false | ||||||||
| 01a08197-c940-7303-abc6-1c186447a7f7 | AMAT | 2026-09-08 11:16 | other | 2 | 1 | 100 | 110658.00 | unknown | — | 468.0955 | 1.7500 | ["600","700"] | ["0.5970","0.6371"] | [] | ["XPHO"] | 600.0000 | 700.0000 | 38 | 73 | false | true | true | true | false | mlat | |||||||
| 01a08191-7811-73d1-87e4-8842516de66d | AMAT | 2026-09-08 11:09 | call_vertical_spread | 2 | 1 | 10 | 312000.00 | unknown | — | 466.4925 | 16.0000 | ["500","540"] | ["0.5897","0.5886"] | [] | ["XMIO"] | 500.0000 | 540.0000 | 829 | 829 | false | true | false | true | false | mlat | |||||||
| 01a0813b-8bf8-7201-b7e6-3d12dfc57f4f | AMAT | 2026-09-08 09:35 | put_vertical_spread | 2 | 1 | 5 | 232645.00 | short | bid | 463.4150 | 16.5000 | ["610","620"] | ["0.5892","0.5902"] | ["612.81"] | ["XCBO"] | 610.0000 | 620.0000 | 829 | 829 | false | false | false | true | |||||||||
| 01a08139-45f0-7073-94d6-56ed8d4d0437 | AMAT | 2026-09-08 09:33 | call_backspread | 2 | 1 | 26 | 110630.00 | long | bid | 468.3800 | 8.9500 | ["440","720"] | ["0.5547","0.5889"] | ["496.22","943.78"] | ["XMIO"] | 440.0000 | 720.0000 | 101 | 101 | false | false | false | true | |||||||||
| 01a06d4e-a455-7bd2-a201-a873f6dea50d | AMAT | 2026-09-04 12:44 | put_vertical_spread | 2 | 1 | 25 | 183825.00 | long | ask | 454.2650 | 3.2500 | ["460","470"] | ["0.5185","0.5205"] | ["464.13"] | ["AMXO"] | 460.0000 | 470.0000 | 42 | 42 | false | false | false | true | |||||||||
| 01a06d4c-567d-7730-b6dd-1ab0299fbaca | AMAT | 2026-09-04 12:41 | put_vertical_spread | 2 | 1 | 25 | 181625.00 | long | ask | 454.3750 | 2.5000 | ["460","470"] | ["0.5125","0.5139"] | ["464.17"] | ["XMIO"] | 460.0000 | 470.0000 | 42 | 42 | false | false | false | true | |||||||||
| 01a06d26-8ab5-7321-900e-b3eb5e771560 | AMAT | 2026-09-04 12:00 | other | 2 | 1 | 450 | 2833425.00 | unknown | — | 454.7300 | 6.8500 | ["420","550"] | ["0.5597","0.5399"] | [] | ["XMIO"] | 420.0000 | 550.0000 | 77 | 133 | true | false | true | true | false | mlat | |||||||
| 01a06d22-393d-7763-87f5-7ba302b2c8df | AMAT | 2026-09-04 11:55 | other | 3 | 1 | 5 | 138240.00 | unknown | — | 454.4100 | 18.8500 | ["420","535"] | ["0.5548","0.5838"] | [] | ["XCBO"] | 420.0000 | 535.0000 | 14 | 378 | false | false | true | true | true | mlat |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:11:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:53:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:06:52Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:29:51Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:53:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:25:12Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:01:44Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:50:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:25:40Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:10:18Z"} |
| 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-08T17:14:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:40:58Z"} |
| 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-08T16:04:53Z"} |
| 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-08T15:52:17Z"} |
| 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-08T15:52:17Z"} |
| 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-08T15:52:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:52:17Z"} |
| 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-08T15:38:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:16:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:10:17Z"} |
| 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-08T13:36:03Z"} |
| 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-08T13:33:29Z"} |
| 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-04T16:44:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:42:34Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:00:58Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T15:56:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |