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 |
|---|
| 01a0cab0-0df7-72b1-8c49-5c378a02ae1b | ARM | 2026-09-22 15:55 | call_vertical_spread | 2 | 1 | 7 | 110544.00 | long | ask | 332.8200 | 6.1000 | ["310","320"] | ["0.7472","0.7494"] | ["314.26"] | ["XCBO"] | 310.0000 | 320.0000 | 178 | 178 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:55:42Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca9d-261e-7340-8422-4f39719644d3 | ARM | 2026-09-22 15:34 | call_diagonal_spread | 2 | 1 | 7 | 167923.00 | long | ask | 330.9920 | 6.1000 | ["260","320"] | ["0.7433","0.7457"] | [] | ["XCBO"] | 260.0000 | 320.0000 | 268 | 486 | false | false | true | true | |||||||||
| 01a0ca85-b61f-7a80-a38f-0f08b0409e4d | ARM | 2026-09-22 15:09 | call_butterfly_spread | 3 | 1 | 4 | 196330.00 | long | ask | 331.2250 | 12.3500 | ["75","90","95"] | ["1.2163","1.0841","1.0253"] | ["84.77"] | ["XMIO"] | 75.0000 | 95.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0ca76-be17-73e2-9164-363cd61f59cb | ARM | 2026-09-22 14:52 | call_vertical_spread | 2 | 1 | 100 | 210600.00 | long | ask | 330.9100 | 1.1500 | ["340","360"] | ["0.7881","0.8155"] | ["345.78"] | ["XCBO"] | 340.0000 | 360.0000 | 10 | 10 | false | true | false | true | |||||||||
| 01a0c9b3-337e-74a1-bfad-560eb4b5ad87 | ARM | 2026-09-22 11:19 | call_calendar | 2 | 1 | 15 | 343065.00 | short | ask | 332.5400 | 6.6500 | ["360"] | ["0.7410"] | [] | ["XMIO"] | 360.0000 | 360.0000 | 451 | 633 | false | true | true | false | |||||||||
| 01a0c9ac-03a7-7ba3-a80f-a6f43f130d2b | ARM | 2026-09-22 11:11 | call_calendar | 2 | 1 | 15 | 230565.00 | long | ask | 330.4950 | 6.3000 | ["340"] | ["0.7350"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 206 | 268 | false | true | true | false | |||||||||
| 01a0c9ab-30b7-79f3-9e2d-30806f1fa698 | ARM | 2026-09-22 11:10 | call_calendar | 2 | 1 | 15 | 205875.00 | short | ask | 329.9069 | 4.9500 | ["340"] | ["0.7380"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 178 | 206 | false | true | true | false | |||||||||
| 01a0c99e-6b2f-71a0-b2a9-4a3bf5070946 | ARM | 2026-09-22 10:56 | risk_reversal | 2 | 1 | 10 | 133450.00 | long | ask | 327.3400 | 7.4000 | ["260","450"] | ["0.7352","0.7502"] | ["473.51"] | ["XCBO"] | 260.0000 | 450.0000 | 451 | 451 | false | true | false | true | |||||||||
| 01a0c991-0197-7480-ad1f-decd02a9e223 | ARM | 2026-09-22 10:41 | call_vertical_spread | 2 | 1 | 40 | 113520.00 | long | ask | 326.5800 | 2.2500 | ["332.5","335"] | ["0.7969","0.7992"] | ["333.48"] | ["XPHO"] | 332.5000 | 335.0000 | 10 | 10 | false | true | false | true | |||||||||
| 01a0c964-bd8e-7e32-a761-f54d646a2715 | ARM | 2026-09-22 09:53 | call_calendar | 2 | 1 | 15 | 140610.00 | long | ask | 325.6600 | 5.9000 | ["340"] | ["0.7551"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 87 | 115 | false | true | true | false | |||||||||
| 01a0c549-70bf-7b90-96c6-883c15f5b161 | ARM | 2026-09-21 14:45 | call_vertical_spread | 2 | 1 | 48 | 1151040.00 | long | ask | 320.0500 | 7.3000 | ["410","420"] | ["0.7379","0.7379"] | ["412.20"] | ["XCBO"] | 410.0000 | 420.0000 | 816 | 816 | false | true | false | true | |||||||||
| 01a0c547-3e3f-7c72-994e-61d13b98385d | ARM | 2026-09-21 14:42 | call_vertical_spread | 2 | 1 | 30 | 118380.00 | unknown | ask | 320.9800 | 2.0000 | ["320","360"] | ["0.7627","0.7938"] | ["359.46"] | ["XMIO"] | 320.0000 | 360.0000 | 25 | 25 | false | false | false | true | |||||||||
| 01a0c52c-76c7-73f2-911e-e3b517100a8f | ARM | 2026-09-21 14:13 | other | 3 | 2 | 15 | 166733.00 | unknown | ask | 318.6800 | 5.7000 | ["350","390"] | ["0.7495","0.7537"] | [] | ["XCBO"] | 350.0000 | 390.0000 | 179 | 269 | false | true | true | true | |||||||||
| 01a0c51f-1cce-7962-8f69-14e00b5fa70c | ARM | 2026-09-21 13:59 | put_vertical_spread | 2 | 1 | 20 | 126700.00 | long | ask | 318.1600 | 3.5000 | ["310","330"] | ["0.7485","0.7583"] | ["318.63"] | ["XMIO"] | 310.0000 | 330.0000 | 39 | 39 | true | false | false | true | |||||||||
| 01a0c512-95c7-7981-a6d6-6ac89be4e45d | ARM | 2026-09-21 13:45 | put_diagonal_spread | 2 | 1 | 11 | 110847.00 | long | ask | 318.9500 | 2.8000 | ["220","230"] | ["0.7267","0.7248"] | [] | ["XCBO"] | 220.0000 | 230.0000 | 487 | 851 | false | true | true | true | |||||||||
| 01a0c4f4-99fe-70a0-b216-430031c783c9 | ARM | 2026-09-21 13:12 | call_diagonal_spread | 2 | 1 | 60 | 554700.00 | short | ask | 319.0900 | 3.0500 | ["320","350"] | ["0.7681","0.7540"] | [] | ["XCBO"] | 320.0000 | 350.0000 | 88 | 116 | false | true | true | true | |||||||||
| 01a0c4d4-5447-7461-9458-dd98f98f9c91 | ARM | 2026-09-21 12:37 | call_calendar | 2 | 1 | 15 | 114405.00 | short | ask | 319.6198 | 2.2000 | ["340"] | ["0.7961"] | [] | ["XCBO"] | 340.0000 | 340.0000 | 60 | 88 | false | true | true | false | |||||||||
| 01a0c4a4-2457-7231-b25c-acdb4f9c427a | ARM | 2026-09-21 11:44 | call_calendar | 2 | 1 | 13 | 480701.00 | short | ask | 316.8250 | 8.4000 | ["200"] | ["0.7345"] | [] | ["XCBO"] | 200.0000 | 200.0000 | 816 | 851 | false | false | true | false | |||||||||
| 01a0c46f-3d5f-7083-93fd-153f48192d1a | ARM | 2026-09-21 10:46 | call_vertical_spread | 2 | 1 | 1651 | 2580515.00 | long | ask | 311.3750 | 1.1500 | ["317.5","325"] | ["0.8970","0.9175"] | ["319.91"] | ["XCBO"] | 317.5000 | 325.0000 | 4 | 4 | true | true | false | true | |||||||||
| 01a0c43a-bbf7-71a2-82cd-7e16a0ede5e9 | ARM | 2026-09-21 09:49 | call_diagonal_spread | 2 | 1 | 10 | 171570.00 | short | ask | 301.4404 | 6.7500 | ["220","300"] | ["0.7559","0.7259"] | [] | ["XMIO"] | 220.0000 | 300.0000 | 88 | 269 | false | false | true | true | |||||||||
| 01a0b613-8f9f-7421-b7da-0744b61322bf | ARM | 2026-09-18 15:52 | iron_condor | 4 | 1 | 33 | 101211.00 | long | ask | 271.8550 | 5.8600 | ["270","275","330","335"] | ["0.6469","0.6433","0.7208","0.7149"] | ["272.05","332.95"] | ["XMIO"] | 270.0000 | 335.0000 | 14 | 14 | false | false | false | true | |||||||||
| 01a0a158-1500-7581-9015-09b1e680676a | ARM | 2026-09-14 15:14 | call_vertical_spread | 2 | 1 | 30 | 538800.00 | long | ask | 241.6500 | 5.4000 | ["150","155"] | ["1.4186","1.3398"] | ["154.98"] | ["XCBO"] | 150.0000 | 155.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a0a10d-c1a9-70b2-9dc9-bd672e2f7158 | ARM | 2026-09-14 13:53 | call_vertical_spread | 2 | 1 | 100 | 1698500.00 | long | ask | 242.1200 | 4.7000 | ["155","160"] | ["1.0846","1.0415"] | ["159.97"] | ["XMIO"] | 155.0000 | 160.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a0a104-b540-79d0-9d42-804fc464d3e9 | ARM | 2026-09-14 13:43 | call_vertical_spread | 2 | 1 | 116 | 1970260.00 | long | ask | 242.2400 | 4.7000 | ["155","160"] | ["1.5773","0.8000"] | ["159.97"] | ["XCBO"] | 155.0000 | 160.0000 | 11 | 11 | false | false | false | true | |||||||||
| 01a0a03c-7788-77b0-858b-1a495d114c6c | ARM | 2026-09-14 10:05 | call_vertical_spread | 2 | 1 | 7 | 131236.00 | long | ask | 245.8050 | 7.0500 | ["200","220"] | ["0.6951","0.6961"] | ["208.50"] | ["XCBO"] | 200.0000 | 220.0000 | 459 | 459 | false | false | false | true | |||||||||
| 01a08297-dbf1-7b22-8bdd-710c69e7737a | ARM | 2026-09-08 15:56 | put_calendar | 2 | 1 | 10 | 126040.00 | short | ask | 260.9500 | 4.9000 | ["320"] | ["0.8115"] | [] | ["XPHO"] | 320.0000 | 320.0000 | 10 | 38 | false | false | true | false | |||||||||
| 01a081f0-e5c0-7ba1-a399-8526450a8115 | ARM | 2026-09-08 12:54 | call_butterfly_spread | 3 | 1 | 4 | 142020.00 | long | ask | 264.2300 | 13.3000 | ["75","90","95"] | ["1.0456","0.9597","0.9390"] | ["84.90"] | ["XMIO"] | 75.0000 | 95.0000 | 73 | 73 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:34:57Z"} |
| 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-22T19:09:14Z"} |
| 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-22T18:52:53Z"} |
| 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-22T15:19:35Z"} |
| 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-22T15:11:59Z"} |
| 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-22T15:11:14Z"} |
| 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:57:08Z"} |
| 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:42:10Z"} |
| 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-22T13:53:54Z"} |
| 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-21T18:45:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:43:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:14:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:59:34Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:45:25Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:12:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:37:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:44:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:47:04Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:49:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:52:12Z"} |
| 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-14T19:15:23Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:54:05Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:44:36Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:05:26Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:56: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-08T16:54:31Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |