core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d4d9-923f-7c50-af4a-0aab6c76edea | HD | 2026-09-24 15:17 | other | 4 | 2 | 15 | 299970.00 | unknown | bid | 292.0350 | 6.7500 | ["260","280","375","380"] | ["0.3089","0.3107","0.3561","0.3670"] | [] | ["XMIO"] | 260.0000 | 380.0000 | 176 | 239 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:17:21Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4d5-9e86-7921-a7d7-312a80278902 | HD | 2026-09-24 15:12 | other | 4 | 1 | 20 | 420060.00 | unknown | bid | 292.0500 | 7.9000 | ["275","300","370","380"] | ["0.3066","0.3077","0.3501","0.3669"] | [] | ["XMIO"] | 275.0000 | 380.0000 | 176 | 239 | false | false | |||||||||||
| 01a0d4ce-e7c7-77b3-b85f-719e6b0890a5 | HD | 2026-09-24 15:05 | other | 4 | 1 | 14 | 307762.00 | unknown | bid | 292.5100 | 9.7000 | ["285","310","370","380"] | ["0.3078","0.3103","0.3535","0.3733"] | [] | ["XMIO"] | 285.0000 | 380.0000 | 176 | 239 | false | false | |||||||||||
| 01a0d3f2-dfa6-7de0-92da-406044a5b819 | HD | 2026-09-24 11:05 | strangle | 2 | 1 | 500 | 1377500.00 | short | bid | 291.7550 | 0.5500 | ["290","310"] | ["0.2944","0.2644"] | ["262.45","337.55"] | ["SPHR"] | 290.0000 | 310.0000 | 113 | 113 | false | true | |||||||||||
| 01a0d3e1-769e-7ad3-8f61-7deb78af6e0a | HD | 2026-09-24 10:46 | call_vertical_spread | 2 | 2 | 14 | 128695.00 | short | bid | 292.2700 | 3.6500 | ["300","330"] | ["0.2251","0.2350"] | ["311.02"] | ["ARCO","XMIO"] | 300.0000 | 330.0000 | 848 | 848 | false | true | |||||||||||
| 01a0cf09-32cf-7b61-88c6-68b5f5badd9d | HD | 2026-09-23 12:11 | strangle | 2 | 3 | 19 | 102315.00 | short | bid | 299.5350 | 0.5263 | ["300","350"] | ["0.3130","0.2489"] | ["246.15","403.85"] | ["XISX"] | 300.0000 | 350.0000 | 450 | 450 | false | false | |||||||||||
| 01a0c9e8-fd06-7473-93d3-871ddc0552fe | HD | 2026-09-22 12:18 | put_vertical_spread | 2 | 1 | 5 | 126215.00 | short | bid | 301.4050 | 4.5500 | ["425","430"] | ["1.7222","1.7452"] | ["425.03"] | ["XMIO"] | 425.0000 | 430.0000 | 3 | 3 | false | false | |||||||||||
| 01a0b606-492f-71f2-ac6c-8a0b9108ba3b | HD | 2026-09-18 15:37 | put_diagonal_spread | 2 | 2 | 274 | 293728.00 | short | bid | 299.8400 | 1.0000 | ["300","305"] | ["0.2399","1.7016"] | [] | ["XISX"] | 300.0000 | 305.0000 | 0 | 14 | false | false | |||||||||||
| 01a0b5e8-0717-7c62-99e5-a388eb72caf7 | HD | 2026-09-18 15:04 | put_calendar | 2 | 1 | 10 | 149390.00 | unknown | bid | 300.3000 | 3.8500 | ["370"] | ["0.3372"] | [] | ["XPHO"] | 370.0000 | 370.0000 | 272 | 364 | false | false | |||||||||||
| 01a0a5e2-3bee-7ee1-a9b3-e93def0053ae | HD | 2026-09-15 12:24 | put_calendar | 2 | 1 | 12 | 135480.00 | short | bid | 305.4550 | 5.0000 | ["350"] | ["0.3105"] | [] | ["BATO"] | 350.0000 | 350.0000 | 275 | 367 | false | false | true | ||||||||||
| 01a0a5da-c5c5-7fd1-b8b0-8882eb54f7a4 | HD | 2026-09-15 12:16 | put_vertical_spread | 2 | 1 | 4 | 105884.00 | short | bid | 304.8050 | 4.5500 | ["435","440"] | ["2.1474","2.2026"] | ["435.03"] | ["BATO"] | 435.0000 | 440.0000 | 3 | 3 | false | false | |||||||||||
| 01a091d4-a199-75e2-a5af-ed99e17692b8 | HD | 2026-09-11 14:57 | call_diagonal_spread | 2 | 1 | 6 | 166284.00 | short | bid | 309.2087 | 6.0000 | ["170","175"] | ["0.3627","1.6054"] | [] | ["XCBO"] | 170.0000 | 175.0000 | 7 | 462 | true | false | |||||||||||
| 01a091c7-1ca8-7813-bf9b-2e2fedfcb691 | HD | 2026-09-11 14:42 | synthetic | 2 | 1 | 30 | 234000.00 | short | bid | 309.0100 | 4.3000 | ["310"] | ["0.2757"] | ["315.90"] | ["XBOX"] | 310.0000 | 310.0000 | 497 | 497 | false | false | false | ||||||||||
| 01a090fb-1248-77f1-88cc-68be59fd7913 | HD | 2026-09-11 10:59 | call_diagonal_spread | 2 | 3 | 36 | 423882.00 | short | bid | 308.7875 | 4.9000 | ["200","300"] | ["1.1931","1.4057"] | [] | ["ARCO","EDGO","XISX"] | 200.0000 | 300.0000 | 0 | 7 | false | false | |||||||||||
| 01a090fb-0e60-7eb2-b614-8c158fcdbe7a | HD | 2026-09-11 10:59 | call_diagonal_spread | 2 | 2 | 54 | 636174.00 | short | bid | 308.8300 | 5.0250 | ["200","300"] | ["1.1106","0.9561"] | [] | ["ARCO","XISX"] | 200.0000 | 300.0000 | 0 | 7 | false | false | |||||||||||
| 01a0874b-bb59-7d52-bbe2-aa4b2ab82207 | HD | 2026-09-09 13:51 | put_diagonal_spread | 2 | 1 | 22 | 216678.00 | long | bid | 311.2500 | 4.8000 | ["350","360"] | ["0.3072","0.3174"] | [] | ["XISX"] | 350.0000 | 360.0000 | 100 | 191 | false | false | |||||||||||
| 01a0874b-bb59-7d52-bbe2-aa3263844561 | HD | 2026-09-09 13:51 | put_diagonal_spread | 2 | 1 | 22 | 216678.00 | long | bid | 311.2500 | 4.8000 | ["350","360"] | ["0.3072","0.3174"] | [] | ["XISX"] | 350.0000 | 360.0000 | 100 | 191 | false | false | |||||||||||
| 01a0874b-bb59-7d52-bbe2-aa2e301b61da | HD | 2026-09-09 13:51 | put_diagonal_spread | 2 | 1 | 22 | 216678.00 | long | bid | 311.2500 | 4.8000 | ["350","360"] | ["0.3072","0.3174"] | [] | ["XISX"] | 350.0000 | 360.0000 | 100 | 191 | false | false | |||||||||||
| 01a0874b-bb59-7d52-bbe2-aa1c7ceca8ae | HD | 2026-09-09 13:51 | put_diagonal_spread | 2 | 1 | 22 | 216678.00 | long | bid | 311.2500 | 4.8000 | ["350","360"] | ["0.3072","0.3174"] | [] | ["XISX"] | 350.0000 | 360.0000 | 100 | 191 | false | false | |||||||||||
| 01a0874b-bb59-7d52-bbe2-aa05c7d3d26d | HD | 2026-09-09 13:51 | put_diagonal_spread | 2 | 1 | 22 | 216700.00 | long | bid | 311.2500 | 4.8000 | ["350","360"] | ["0.3072","0.3176"] | [] | ["XISX"] | 350.0000 | 360.0000 | 100 | 191 | false | false | |||||||||||
| 01a08204-98b8-73b0-8d5b-4aab48498089 | HD | 2026-09-08 13:15 | put_calendar | 2 | 1 | 8 | 119776.00 | short | bid | 315.7050 | 2.9000 | ["390"] | ["0.3202"] | [] | ["XCBO"] | 390.0000 | 390.0000 | 129 | 164 | false | false | true | ||||||||||
| 01a06df0-e765-7c42-8e02-5d49aee9b8c7 | HD | 2026-09-04 15:41 | put_vertical_spread | 2 | 1 | 13 | 160056.00 | short | bid | 321.5700 | 5.4500 | ["380","385"] | ["0.5689","0.6056"] | [] | ["AMXO"] | 380.0000 | 385.0000 | 14 | 14 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:12:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:05:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:05:20Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:46:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:11:35Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:18:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:37:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:04:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:24:53Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:16:31Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:57:45Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:42:50Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:59:49Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:59:49Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:52:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:52:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:52:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:52:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:52:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:16:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:37Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |