core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 01a0ca87-fc26-7202-86d7-6128c4991da8 | CAVA | 2026-09-22 15:11 | straddle | 2 | 1 | 250 | 861250.00 | long | ask | 52.9400 | 2.6000 | ["70"] | ["0.6173"] | ["35.55","104.45"] | ["SPHR"] | 70.0000 | 70.0000 | 486 | 486 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:12:15Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca7e-14fe-7280-9d99-5adbb8e9f542 | CAVA | 2026-09-22 15:00 | straddle | 2 | 1 | 1750 | 6028750.00 | long | ask | 52.9496 | 2.6000 | ["70"] | ["0.6173"] | ["35.55","104.45"] | ["SPHR"] | 70.0000 | 70.0000 | 486 | 486 | true | false | false | false | true | mlft | |||||||
| 01a0b0b7-5abb-7260-a51b-eb0764a4044a | CAVA | 2026-09-17 14:53 | put_ladder | 5 | 1 | 461 | 841154.00 | unknown | — | 51.4150 | 9.3000 | ["58","60","61","62","65"] | ["3.2660","2.6606","4.0667","3.9677","4.8713"] | [] | ["XBOX"] | 58.0000 | 65.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0b0ab-8f33-7f70-95de-06134b09792a | CAVA | 2026-09-17 14:40 | other | 4 | 1 | 550 | 1035580.00 | unknown | — | 51.4600 | 7.2500 | ["60","61","62","65"] | ["2.7204","4.1068","4.0126","4.9160"] | [] | ["XBOX"] | 60.0000 | 65.0000 | 1 | 1 | true | false | false | true | false | mlft | |||||||
| 01a0b095-3873-7622-b8c7-685e68c5f262 | CAVA | 2026-09-17 14:16 | put_vertical_spread | 2 | 3 | 100 | 209150.00 | short | bid | 51.8100 | 1.4000 | ["50","60"] | ["0.6302","0.6200"] | ["54.10"] | ["XCBO","XISX","XPHO"] | 50.0000 | 60.0000 | 183 | 183 | false | false | false | true | false | ||||||||
| 01a0b093-5fcb-70b0-a968-75dccf8ea557 | CAVA | 2026-09-17 14:14 | put_vertical_spread | 2 | 2 | 75 | 132997.00 | long | ask | 51.7650 | 0.5500 | ["50","60"] | ["0.6114","0.6023"] | ["54.01"] | ["XCBO","XISX"] | 50.0000 | 60.0000 | 120 | 120 | false | false | false | true | false | ||||||||
| 01a0b013-df2b-7720-8645-8b97ad9b83fe | CAVA | 2026-09-17 11:54 | other | 4 | 1 | 79 | 134300.00 | unknown | — | 50.8950 | 3.6500 | ["100","105"] | ["0.5941","0.5951"] | [] | ["MCRY"] | 100.0000 | 105.0000 | 456 | 491 | false | true | true | true | false | mlet | |||||||
| 01a0a598-697e-7671-a143-111722ac3016 | CAVA | 2026-09-15 11:03 | put_diagonal_spread | 2 | 1 | 9530 | 4050250.00 | short | ask | 51.5200 | 0.3400 | ["40","50"] | ["0.6398","0.5638"] | [] | ["XCBO"] | 40.0000 | 50.0000 | 31 | 94 | false | true | true | true | false | ||||||||
| 01a091f0-f780-7df0-80f6-b4144fa61a9f | CAVA | 2026-09-11 15:28 | call_vertical_spread | 2 | 1 | 100 | 117400.00 | unknown | — | 55.9500 | 0.7000 | ["50","55"] | ["0.5822","0.5147"] | [] | ["MCRY"] | 50.0000 | 55.0000 | 35 | 35 | false | false | false | true | false | mlet | |||||||
| 01a08c9d-da78-7b61-b0c3-79b1cdbc34f3 | CAVA | 2026-09-10 14:39 | other | 5 | 1 | 635 | 1594564.00 | unknown | — | 54.9950 | 6.7500 | ["61","62","63","70","75"] | ["2.1130","2.5081","3.5204","1.3582","1.5538"] | [] | ["XBOX"] | 61.0000 | 75.0000 | 1 | 8 | false | false | true | true | false | mlft | |||||||
| 01a08c13-ede0-7ef1-a3ed-9222357b621c | CAVA | 2026-09-10 12:08 | put_diagonal_spread | 2 | 1 | 21 | 271152.00 | short | bid | 54.9400 | 4.1000 | ["100","140"] | ["0.7878","0.7968"] | [] | ["BATO"] | 100.0000 | 140.0000 | 127 | 190 | false | false | true | true | false | ||||||||
| 01a086ab-7419-77a3-ade2-52aeab9e8cee | CAVA | 2026-09-09 10:56 | other | 2 | 1 | 393 | 1499295.00 | unknown | — | 57.6700 | 2.6000 | ["75"] | ["0.8309"] | [] | ["XISX"] | 75.0000 | 75.0000 | 9 | 281 | false | false | true | false | false | mlet | |||||||
| 01a086aa-5ec0-7e62-9e1b-a3c53c448b8e | CAVA | 2026-09-09 10:55 | put_calendar | 2 | 1 | 146 | 557136.00 | long | bid | 57.7000 | 2.7000 | ["75"] | ["0.8417"] | [] | ["XISX"] | 75.0000 | 75.0000 | 9 | 281 | false | false | true | false | false | mlet | |||||||
| 01a086aa-1c58-78f0-a5fd-a297e774e05b | CAVA | 2026-09-09 10:54 | put_calendar | 2 | 1 | 50 | 190750.00 | long | bid | 57.7050 | 2.7000 | ["75"] | ["0.8434"] | [] | ["XISX"] | 75.0000 | 75.0000 | 9 | 281 | false | false | true | false | false | mlet | |||||||
| 01a08699-ad50-7410-b9f0-fdc6ffbb81ce | CAVA | 2026-09-09 10:36 | put_calendar | 2 | 1 | 27 | 102708.00 | unknown | — | 57.8700 | 2.6000 | ["75"] | ["0.8624"] | [] | ["XCBO"] | 75.0000 | 75.0000 | 9 | 281 | false | false | true | false | false | mlat | |||||||
| 01a08699-ad50-7410-b9f0-fda5ad67d1d2 | CAVA | 2026-09-09 10:36 | put_calendar | 2 | 1 | 30 | 114120.00 | unknown | — | 57.8700 | 2.6000 | ["75"] | ["0.8624"] | [] | ["BATO"] | 75.0000 | 75.0000 | 9 | 281 | false | false | true | false | false | mlet | |||||||
| 01a08697-3c50-7092-b027-16e32a23b754 | CAVA | 2026-09-09 10:34 | put_calendar | 2 | 2 | 492 | 1414992.00 | unknown | — | 57.8300 | 1.3500 | ["70"] | ["0.6751"] | [] | ["XISX"] | 70.0000 | 70.0000 | 9 | 191 | false | false | true | false | false | mlet | |||||||
| 01a08695-9671-7840-9908-12b94b112395 | CAVA | 2026-09-09 10:32 | put_calendar | 2 | 2 | 46 | 130932.00 | short | bid | 57.9300 | 1.2000 | ["70"] | ["0.6245"] | [] | ["AMXO","XBOX"] | 70.0000 | 70.0000 | 9 | 191 | false | false | true | false | false | mlet | |||||||
| 01a08695-9671-7840-9908-129179386e9c | CAVA | 2026-09-09 10:32 | put_calendar | 2 | 2 | 48 | 135384.00 | short | bid | 57.9300 | 1.2000 | ["70"] | ["0.5484"] | [] | ["AMXO","XPHO"] | 70.0000 | 70.0000 | 9 | 191 | false | false | true | false | false | mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:01:06Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:53:45Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:41:00Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:16:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:14:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:54:58Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:03:50Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:28:07Z"} |
| 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-10T18:39:30Z"} |
| 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:08:47Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:56:47Z"} |
| 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:40Z"} |
| 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 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:37:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:37:00Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:34:15Z"} |
| 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:32:41Z"} |
| 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:32:41Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |