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 |
|---|
| 01a0cf91-65ff-7f43-a190-22fbcc91b230 | SPXL | 2026-09-23 14:40 | call_vertical_spread | 2 | 1 | 20 | 283200.00 | short | bid | 287.5299 | 6.9000 | ["320","325"] | ["0.4160","0.4134"] | ["322.10"] | ["XISX"] | 320.0000 | 325.0000 | 849 | 849 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T18:40:47Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cf0b-f1ee-7c11-a5db-dc0bcddeb319 | SPXL | 2026-09-23 12:14 | call_vertical_spread | 2 | 1 | 63 | 855540.00 | short | bid | 288.5650 | 6.2000 | ["330","335"] | ["0.4143","0.4120"] | ["332"] | ["XISX"] | 330.0000 | 335.0000 | 849 | 849 | false | true | false | ||||||||||
| 01a0ce88-0867-7e43-8630-4ebe77926a5c | SPXL | 2026-09-23 09:50 | other | 6 | 1 | 48 | 234760.00 | unknown | bid | 291.5500 | 10.6500 | ["267.5","270","292.5","310"] | ["0.9579","0.4371","0.2952","0.4646"] | [] | ["BATO"] | 267.5000 | 310.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0ca83-7fb7-74d1-aebd-16bfbc59ce3d | SPXL | 2026-09-22 15:06 | call_vertical_spread | 2 | 1 | 63 | 923013.00 | short | bid | 294.6300 | 7.0000 | ["325","330"] | ["0.4127","0.4111"] | ["326.97"] | ["XPHO"] | 325.0000 | 330.0000 | 850 | 850 | false | true | false | ||||||||||
| 01a0c9e1-2537-7f43-aed0-ccb948011ec6 | SPXL | 2026-09-22 12:09 | call_vertical_spread | 2 | 1 | 10 | 100940.00 | short | bid | 294.0400 | 5.1000 | ["250","260"] | ["0.4591","0.4519"] | ["257.40"] | ["ARCO"] | 250.0000 | 260.0000 | 87 | 87 | false | false | false | ||||||||||
| 01a0c97a-ba77-7250-8d73-63b84f1ca0ae | SPXL | 2026-09-22 10:17 | call_diagonal_spread | 2 | 1 | 10 | 123460.00 | short | bid | 294.6300 | 5.7000 | ["220","250"] | ["0.5535","0.5103"] | [] | ["BATO"] | 220.0000 | 250.0000 | 24 | 38 | false | false | true | ||||||||||
| 01a0c514-e787-7bc0-aa78-eb2b92787e1d | SPXL | 2026-09-21 13:47 | call_vertical_spread | 2 | 1 | 10 | 147300.00 | unknown | bid | 293.7600 | 7.0000 | ["320","325"] | ["0.4074","0.4066"] | ["396.15"] | ["XCBO"] | 320.0000 | 325.0000 | 851 | 851 | false | true | false | ||||||||||
| 01a0b5e8-226f-7e22-8e39-c20d985a93a5 | SPXL | 2026-09-18 15:04 | call_diagonal_spread | 2 | 1 | 19 | 117378.00 | unknown | bid | 281.1386 | 6.2000 | ["250","255"] | ["0.4174","0.4066"] | [] | ["XMIO"] | 250.0000 | 255.0000 | 28 | 35 | false | false | true | ||||||||||
| 01a0b5c6-a04f-7bf1-aeb3-71805cadffbc | SPXL | 2026-09-18 14:28 | call_vertical_spread | 2 | 1 | 10 | 111960.00 | short | bid | 280.0100 | 3.1000 | ["290","295"] | ["0.4207","0.4188"] | ["292.20"] | ["XMIO"] | 290.0000 | 295.0000 | 490 | 490 | false | true | false | ||||||||||
| 01a0b54c-72f8-7e72-a4d6-0d657a43b402 | SPXL | 2026-09-18 12:14 | call_vertical_spread | 2 | 1 | 10 | 142600.00 | short | bid | 278.6700 | 3.9000 | ["295","310"] | ["0.4095","0.4076"] | ["300.60"] | ["XPHO"] | 295.0000 | 310.0000 | 854 | 854 | false | true | false | ||||||||||
| 01a0b54a-86c8-7672-8bc4-e6c2b41b2a04 | SPXL | 2026-09-18 12:12 | call_vertical_spread | 2 | 1 | 20 | 284900.00 | unknown | bid | 278.6900 | 4.9000 | ["295","310"] | ["0.4085","0.4076"] | ["373.72"] | ["XMIO"] | 295.0000 | 310.0000 | 854 | 854 | false | true | false | ||||||||||
| 01a0abb8-456b-7502-9715-587858efb144 | SPXL | 2026-09-16 15:36 | put_calendar | 2 | 1 | 45 | 104130.00 | long | bid | 269.5350 | 2.9000 | ["130"] | ["0.6971"] | [] | ["XCBO"] | 130.0000 | 130.0000 | 457 | 492 | false | true | true | false | |||||||||
| 01a0ab61-2c8c-7343-86cd-32f119fccc35 | SPXL | 2026-09-16 14:01 | put_calendar | 2 | 1 | 50 | 115000.00 | long | bid | 277.6100 | 9.8000 | ["130"] | ["0.7095"] | [] | ["XMIO"] | 130.0000 | 130.0000 | 457 | 492 | false | true | true | false | |||||||||
| 01a09203-c400-7ec2-a45a-8e25da5664dc | SPXL | 2026-09-11 15:48 | call_vertical_spread | 2 | 1 | 20 | 186600.00 | short | bid | 283.5927 | 5.8000 | ["320","325"] | ["0.4136","0.4125"] | ["321.80"] | ["XMIO"] | 320.0000 | 325.0000 | 497 | 497 | false | true | false | ||||||||||
| 01a090c2-5ea9-7b70-a61c-b521b847b5cd | SPXL | 2026-09-11 09:57 | call_vertical_spread | 2 | 1 | 63 | 584010.00 | short | bid | 284.4000 | 7.2000 | ["320","325"] | ["0.4072","0.4077"] | ["321.60"] | ["XMIO"] | 320.0000 | 325.0000 | 497 | 497 | false | true | false | ||||||||||
| 01a08c94-7050-7181-a25d-03eac653989a | SPXL | 2026-09-10 14:28 | call_vertical_spread | 2 | 1 | 20 | 166560.00 | short | bid | 276.2500 | 5.0000 | ["325","330"] | ["0.4180","0.4164"] | ["326.70"] | ["BATO"] | 325.0000 | 330.0000 | 498 | 498 | false | true | false | ||||||||||
| 01a08c22-3df0-7451-a032-8278b21a9b56 | SPXL | 2026-09-10 12:24 | call_vertical_spread | 2 | 2 | 35 | 294490.00 | short | bid | 276.5500 | 5.1000 | ["325","330"] | ["0.4193","0.4194"] | ["326.50"] | ["BATO","XCBO"] | 325.0000 | 330.0000 | 498 | 498 | false | true | false | ||||||||||
| 01a08c22-3df0-7451-a032-8264ab1244d3 | SPXL | 2026-09-10 12:24 | call_vertical_spread | 2 | 1 | 25 | 210350.00 | short | bid | 276.5500 | 5.1000 | ["325","330"] | ["0.4193","0.4194"] | ["326.50"] | ["BATO"] | 325.0000 | 330.0000 | 498 | 498 | false | true | false | ||||||||||
| 01a0876f-3560-7443-ac5c-69cb8d042d6f | SPXL | 2026-09-09 14:30 | call_vertical_spread | 2 | 1 | 63 | 533610.00 | short | bid | 281.8599 | 4.2000 | ["330","335"] | ["0.4130","0.4116"] | ["331.70"] | ["XMIO"] | 330.0000 | 335.0000 | 499 | 499 | false | true | false | ||||||||||
| 01a0868e-2fe8-7242-8b02-fc7cb4b79af5 | SPXL | 2026-09-09 10:24 | put_diagonal_spread | 2 | 1 | 100 | 122000.00 | short | bid | 281.9100 | 2.2000 | ["282.5","285"] | ["0.3643","0.4658"] | [] | ["SPHR"] | 282.5000 | 285.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a08136-5ce3-7c63-8a35-5e595fdb63c6 | SPXL | 2026-09-08 09:30 | call_diagonal_spread | 2 | 1 | 20 | 209680.00 | short | bid | 289.3700 | 7.2000 | ["240","250"] | ["0.7169","0.4423"] | [] | ["XCBO"] | 240.0000 | 250.0000 | 10 | 129 | false | false | true | ||||||||||
| 01a08136-5ce3-7c63-8a35-5e4ad65f2f0b | SPXL | 2026-09-08 09:30 | call_diagonal_spread | 2 | 1 | 10 | 121900.00 | short | bid | 289.3700 | 8.2000 | ["230","240"] | ["0.6680","0.4558"] | [] | ["XCBO"] | 230.0000 | 240.0000 | 10 | 129 | false | false | true | ||||||||||
| 01a08136-1d59-7860-bffb-03f3c0151ae3 | SPXL | 2026-09-08 09:30 | call_diagonal_spread | 2 | 1 | 15 | 115050.00 | short | bid | 289.0500 | 6.0000 | ["255","270"] | ["0.6401","0.4245"] | [] | ["XISX"] | 255.0000 | 270.0000 | 10 | 129 | false | false | true | ||||||||||
| 01a06dd8-b02d-79f1-adf7-e25aa271ab57 | SPXL | 2026-09-04 15:15 | call_vertical_spread | 2 | 1 | 20 | 200800.00 | short | bid | 289.5900 | 7.6000 | ["320","325"] | ["0.4157","0.4121"] | ["322.20"] | ["XMIO"] | 320.0000 | 325.0000 | 504 | 504 | false | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:14:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:50:20Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:07:41Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:10:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:17:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:48:18Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:28:37Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:15:05Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:12:58Z"} |
| 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-16T19:36:20Z"} |
| 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-16T18:01:24Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:48:33Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:57:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:29:15Z"} |
| 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-10T16:24:50Z"} |
| 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-10T16:24:50Z"} |
| 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:30:11Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:24:29Z"} |
| 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-08T13:30:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:30:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:15:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |