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 |
|---|
| 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 | true | 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 |
| 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 | 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 | true | |||||||||
| 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 | true | |||||||||
| 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 | true | |||||||||
| 01a0a0dd-f749-7b11-8cd7-78fa14e43d2b | AXP | 2026-09-14 13:01 | put_diagonal_spread | 2 | 1 | 15 | 105600.00 | long | ask | 327.5300 | 2.2000 | ["300","330"] | ["0.3133","0.3263"] | [] | ["XPHO"] | 300.0000 | 330.0000 | 459 | 823 | false | false | true | true | |||||||||
| 01a0a623-b98e-7731-a371-84c1b310672a | AXP | 2026-09-15 13:35 | call_diagonal_spread | 2 | 1 | 164 | 102828.00 | long | ask | 324.0700 | 0.7100 | ["360","380"] | ["0.2605","0.6021"] | [] | ["XMIO"] | 360.0000 | 380.0000 | 3 | 94 | false | true | true | true | |||||||||
| 01a0a692-cb25-7570-90b2-c74c457fc18f | AXP | 2026-09-15 15:37 | call_calendar | 2 | 1 | 30 | 403470.00 | long | bid | 324.2400 | 5.2000 | ["260"] | ["0.8242"] | [] | ["EDGO"] | 260.0000 | 260.0000 | 3 | 122 | false | false | true | false | |||||||||
| 01a0aa85-5b1a-7d32-9c3b-d6de81f3c5bc | AXP | 2026-09-16 10:00 | put_diagonal_spread | 2 | 1 | 30 | 157500.00 | long | ask | 316.7300 | 4.5000 | ["320","340"] | ["0.2993","0.3280"] | [] | ["XCBO"] | 320.0000 | 340.0000 | 9 | 274 | false | false | true | true | |||||||||
| 01a0aab0-a90a-7182-8a59-79d1ac3ac299 | AXP | 2026-09-16 10:48 | call_vertical_spread | 2 | 1 | 8 | 238720.00 | long | ask | 316.6650 | 2.8000 | ["165","170"] | ["4.4303","2.6288"] | ["169.98"] | ["XISX"] | 165.0000 | 170.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aac3-7d5b-7721-8e5a-11cca1a4f8a7 | AXP | 2026-09-16 11:08 | call_vertical_spread | 2 | 1 | 3 | 102282.00 | long | ask | 318.1000 | 3.9000 | ["145","150"] | ["5.3811","5.2741"] | ["149.98"] | ["XMIO"] | 145.0000 | 150.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aac8-9ddb-7153-8314-898b4105a41c | AXP | 2026-09-16 11:14 | call_vertical_spread | 2 | 1 | 9 | 288486.00 | long | ask | 317.6400 | 3.1000 | ["155","160"] | ["3.7185","3.6432"] | ["159.98"] | ["XISX"] | 155.0000 | 160.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0aad2-dedb-7fa2-bb6e-9c9eab2c886f | AXP | 2026-09-16 11:25 | call_vertical_spread | 2 | 1 | 6 | 155784.00 | long | ask | 317.2900 | 2.9000 | ["185","190"] | ["3.7619","3.6821"] | ["189.98"] | ["XMIO"] | 185.0000 | 190.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0b4dc-9a27-7a00-9cbf-31ad844efb1b | AXP | 2026-09-18 10:12 | call_diagonal_spread | 2 | 4 | 48 | 269464.00 | long | ask | 309.5199 | 1.0100 | ["260","340"] | ["0.2673","0.2370"] | [] | ["C2OX","EDGO","XISX","XPHO"] | 260.0000 | 340.0000 | 28 | 119 | false | false | true | true | |||||||||
| 01a0b4dc-a5e0-7c01-ad80-dc23330dc32d | AXP | 2026-09-18 10:12 | call_diagonal_spread | 2 | 1 | 20 | 112200.00 | long | ask | 309.4200 | 0.9600 | ["260","340"] | ["0.2689","0.2379"] | [] | ["XPHO"] | 260.0000 | 340.0000 | 28 | 119 | false | false | true | true | |||||||||
| 01a0b53a-ac30-7042-85e6-febaa08bb04a | AXP | 2026-09-18 11:55 | put_calendar | 2 | 1 | 90 | 107010.00 | long | bid | 309.9250 | 1.2000 | ["315"] | ["0.3570"] | [] | ["EDGO"] | 315.0000 | 315.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a0c56c-2f47-7873-88ca-bf72f66dbd8c | AXP | 2026-09-21 15:23 | put_vertical_spread | 2 | 1 | 10 | 178500.00 | long | ask | 313.5750 | 3.4000 | ["400","405"] | ["1.2254","1.2685"] | ["400.02"] | ["XMIO"] | 400.0000 | 405.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0c9f0-a5f6-7361-a1e7-c9019e8b5d61 | AXP | 2026-09-22 12:26 | call_vertical_spread | 2 | 1 | 5 | 109880.00 | long | ask | 307.5900 | 6.8000 | ["195","200"] | ["2.8857","3.0682"] | ["199.98"] | ["EDGO"] | 195.0000 | 200.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c9fe-9077-72c1-bc7a-3cf6c7d20875 | AXP | 2026-09-22 12:41 | straddle | 2 | 1 | 20 | 123140.00 | long | ask | 307.8000 | 2.2000 | ["330"] | ["0.2846"] | ["268.43","391.57"] | ["SPHR"] | 330.0000 | 330.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0c9fe-9077-72c1-bc7a-3cd4c5f2e91e | AXP | 2026-09-22 12:41 | straddle | 2 | 3 | 78 | 480246.00 | long | ask | 307.8000 | 2.9000 | ["330"] | ["0.2846"] | ["268.43","391.57"] | ["ARCO","SPHR"] | 330.0000 | 330.0000 | 268 | 268 | false | false | false | false | |||||||||
| 01a0ca00-420f-7692-8509-03aff0a579b5 | AXP | 2026-09-22 12:43 | straddle | 2 | 4 | 25 | 154193.00 | long | ask | 307.6850 | 1.4500 | ["330"] | ["0.2851"] | ["268.32","391.68"] | ["AMXO","ARCO","EDGO","XCBO"] | 330.0000 | 330.0000 | 268 | 268 | false | false | false | false |
| 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 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:01:51Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:36:52Z"} |
| 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-15T19:37:43Z"} |
| 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-16T14:01:08Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:48:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:09:08Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:14:39Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:25:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:12:34Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:12:34Z"} |
| 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-18T15:55:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:23:23Z"} |
| 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-22T16:26:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:41:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:41:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:44:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |