core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0a086-d2b0-79c3-941c-aee80eab0315 | AXP | 2026-09-14 11:26 | other | 2 | 1 | 22 | 130570.00 | unknown | — | 325.1350 | 3.4000 | ["380","410"] | ["0.2711","0.2782"] | [] | ["XPHO"] | 380.0000 | 410.0000 | 368 | 823 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:26:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a086-d2b0-79c3-941c-aed5bdefe94b | AXP | 2026-09-14 11:26 | other | 4 | 3 | 14 | 169204.00 | unknown | — | 325.1350 | 7.5500 | ["300","320","330","350"] | ["0.3073","0.3040","0.3259","0.3280"] | [] | ["AMXO","XPHO"] | 300.0000 | 350.0000 | 368 | 823 | false | false | true | true | false | ||||||||
| 01a0a086-9c00-77f3-be50-fe3ecf18fb61 | AXP | 2026-09-14 11:26 | call_vertical_spread | 2 | 1 | 11 | 368940.00 | long | ask | 325.0400 | 2.4000 | ["155","160"] | ["2.6908","2.6378"] | ["159.98"] | ["XISX"] | 155.0000 | 160.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0a046-6298-7a40-9838-a837ade4cd74 | AXP | 2026-09-14 10:15 | other | 2 | 2 | 12 | 105972.00 | unknown | — | 325.9000 | 6.3500 | ["320","350"] | ["0.3135","0.3337"] | [] | ["ARCO","XBOX"] | 320.0000 | 350.0000 | 368 | 823 | false | false | true | true | false | ||||||||
| 01a0a046-6298-7a40-9838-a810c0f1fd76 | AXP | 2026-09-14 10:15 | put_diagonal_spread | 2 | 1 | 22 | 150414.00 | short | bid | 325.9000 | 5.8500 | ["300","330"] | ["0.3088","0.3275"] | [] | ["XPHO"] | 300.0000 | 330.0000 | 368 | 823 | false | false | true | ||||||||||
| 01a0912d-3a20-7d12-92d6-fb70ea038f04 | AXP | 2026-09-11 11:54 | strangle | 2 | 1 | 485 | 5597002.00 | short | bid | 324.4000 | 2.3000 | ["370","380"] | ["0.3245","0.2792"] | ["254.60","495.40"] | ["XCBO"] | 370.0000 | 380.0000 | 826 | 826 | true | false | false | ||||||||||
| 01a08cd4-b570-73b1-acd8-44eddff4f960 | AXP | 2026-09-10 15:39 | other | 4 | 1 | 25 | 100325.00 | unknown | — | 320.5700 | 3.7000 | ["322.5","325","335"] | ["0.2494","0.3136","0.3710"] | [] | ["AMXO"] | 322.5000 | 335.0000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a08cb7-07c8-7ba0-85b6-da4be160c859 | AXP | 2026-09-10 15:06 | other | 5 | 1 | 464 | 2293140.00 | unknown | — | 319.7400 | 8.8000 | ["332.5","335","347.5","350","370"] | ["0.6861","0.7736","0.4419","0.4694","0.6720"] | [] | ["XBOX"] | 332.5000 | 370.0000 | 1 | 8 | false | false | true | true | false | ||||||||
| 01a08c72-8c88-7781-9dba-5eda92819302 | AXP | 2026-09-10 13:51 | put_vertical_spread | 2 | 1 | 200 | 539200.00 | long | ask | 320.5900 | 1.8000 | ["325","340"] | ["0.2368","0.3324"] | ["326.80"] | ["BATO"] | 325.0000 | 340.0000 | 8 | 8 | false | false | false | ||||||||||
| 01a08c64-9651-7631-9055-15a423f47747 | AXP | 2026-09-10 13:36 | call_vertical_spread | 2 | 1 | 5 | 118250.00 | long | ask | 320.7950 | 3.8000 | ["200","205"] | ["4.9072","4.7804"] | ["204.98"] | ["XPHO"] | 200.0000 | 205.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a08c1e-2ee0-7df3-8ba2-4c0b09265159 | AXP | 2026-09-10 12:19 | other | 4 | 1 | 2314 | 1147744.00 | unknown | — | 320.9500 | 0.4800 | ["325","330","335"] | ["0.2515","0.2889","0.3501"] | [] | ["XCBO"] | 325.0000 | 335.0000 | 1 | 8 | false | true | true | true | false | ||||||||
| 01a08bf9-0728-7650-bb6a-1262c9ca5fd8 | AXP | 2026-09-10 11:39 | put_calendar | 2 | 1 | 31 | 166780.00 | short | ask | 321.0500 | 2.0500 | ["320"] | ["0.2971"] | [] | ["XCBO"] | 320.0000 | 320.0000 | 190 | 372 | false | true | true | ||||||||||
| 01a08bf9-0728-7650-bb6a-125f28cf8f0d | AXP | 2026-09-10 11:39 | other | 2 | 1 | 20 | 107520.00 | unknown | — | 321.0500 | 2.0500 | ["320"] | ["0.2969"] | [] | ["BATO"] | 320.0000 | 320.0000 | 190 | 372 | false | true | true | false | false | ||||||||
| 01a08bf9-0728-7650-bb6a-1242b72e8249 | AXP | 2026-09-10 11:39 | other | 2 | 1 | 21 | 112896.00 | unknown | — | 321.0500 | 2.0500 | ["320"] | ["0.2969"] | [] | ["BATO"] | 320.0000 | 320.0000 | 190 | 372 | false | true | true | false | false | ||||||||
| 01a08bf5-f600-7601-b002-1150cc728e9a | AXP | 2026-09-10 11:35 | other | 2 | 1 | 18 | 144432.00 | unknown | — | 321.4000 | 4.1500 | ["270","300"] | ["0.2677","0.2512"] | [] | ["XCBO"] | 270.0000 | 300.0000 | 15 | 127 | false | false | true | true | false | ||||||||
| 01a08ba5-93e0-7283-9b6f-181b881f5fcb | AXP | 2026-09-10 10:07 | straddle | 2 | 1 | 750 | 6630000.00 | long | ask | 321.1900 | 5.2000 | ["310"] | ["0.3000"] | ["221.60","398.40"] | ["XBOX"] | 310.0000 | 310.0000 | 498 | 498 | true | false | false | ||||||||||
| 01a0875a-5988-71b3-87e4-fc30bdf87bbb | AXP | 2026-09-09 14:07 | call_vertical_spread | 2 | 1 | 15 | 163950.00 | short | bid | 322.3950 | 2.2000 | ["350","360"] | ["0.2816","0.2821"] | ["353.70"] | ["XMIO"] | 350.0000 | 360.0000 | 828 | 828 | false | true | false | ||||||||||
| 01a086d8-0e10-7d93-afc2-ae471dcf463b | AXP | 2026-09-09 11:44 | put_diagonal_spread | 2 | 2 | 78 | 155454.00 | long | bid | 322.5100 | 1.7000 | ["325","330"] | ["0.2531","0.2508"] | [] | ["XISX","XPHO"] | 325.0000 | 330.0000 | 16 | 23 | false | false | true | ||||||||||
| 01a086a9-ddd9-7db0-94e1-7c707407a90c | AXP | 2026-09-09 10:54 | other | 2 | 1 | 5 | 122815.00 | unknown | — | 323.4300 | 6.0500 | ["200","210"] | ["1.7252","0.2799"] | [] | ["ARCO"] | 200.0000 | 210.0000 | 9 | 373 | false | false | true | true | false | ||||||||
| 01a08260-1a80-7902-a71a-02c8d4cf6891 | AXP | 2026-09-08 14:55 | call_calendar | 2 | 1 | 44 | 715836.00 | short | bid | 326.9750 | 3.3000 | ["250"] | ["0.5966"] | [] | ["XCBO"] | 250.0000 | 250.0000 | 10 | 192 | false | false | true | ||||||||||
| 01a08260-1699-7013-8ddf-b7d418f906c4 | AXP | 2026-09-08 14:55 | other | 2 | 1 | 50 | 813050.00 | unknown | — | 326.9750 | 3.4500 | ["250"] | ["0.5836"] | [] | ["XCBO"] | 250.0000 | 250.0000 | 10 | 192 | false | false | true | false | false | ||||||||
| 01a06d7c-019d-7300-8d6a-97ecd32e18a0 | AXP | 2026-09-04 13:33 | other | 4 | 1 | 90 | 151290.00 | unknown | — | 327.4200 | 4.3200 | ["310","350"] | ["0.2608","0.2366"] | [] | ["XPHO"] | 310.0000 | 350.0000 | 42 | 49 | false | true | true | true | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:26:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:26:15Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:16:01Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:16:01Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:54:37Z"} |
| 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-10T19:39:25Z"} |
| 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-10T19:06:38Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:52:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:37:13Z"} |
| 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:20:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:39:08Z"} |
| 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-10T15:39:08Z"} |
| 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-10T15:39:08Z"} |
| 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-10T15:36:00Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:08:13Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:07:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:45:34Z"} |
| 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-09T14:55:04Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:55: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-08T18:55: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-04T17:34:11Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |