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 | directiontext |
|---|
| 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 |
|---|
| 01a0a091-8cc8-7680-b8ba-9689adfff2a1 | CCI | 2026-09-14 11:38 | time_butterfly | 3 | 1 | 280 | 235480.00 | long | ask | 74.7000 | 2.9500 | ["75","85","90"] | ["0.2112","0.2276","1.1863"] | [] | ["SPHR"] | 75.0000 | 90.0000 | 4 | 368 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:38:11Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0f6-fd88-7481-961a-3662bc5c7bc4 | CCI | 2026-09-14 13:28 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.3700 | 3.0000 | ["60","70"] | ["1.3473","0.5151"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-1110-7630-bffc-0162c0945dbe | CCI | 2026-09-14 13:28 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.3700 | 3.0000 | ["60","70"] | ["1.3473","0.5151"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-2499-7472-82fe-19eb9d00a30e | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-3c08-7f03-a4d2-cd5509cb9520 | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-47c0-71f3-b2bf-1213eece2c6f | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-5761-7552-94a4-89b1ca21ae43 | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-72b8-7e21-bc90-248f7467b78c | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-8259-7a63-a901-7f31ac842c4c | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-95e0-7db0-be50-4a7a78c2df7c | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-ad50-7733-8ea9-0772f97f3269 | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0a0f7-b908-7763-bc30-76b9f7a2c98a | CCI | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 60 | 115830.00 | unknown | — | 74.4000 | 3.0000 | ["60","70"] | ["1.3136","0.4980"] | [] | ["XPHO"] | 60.0000 | 70.0000 | 4 | 4 | false | false | false | true | false | ||||||||
| 01a0b0ab-cdb2-70c2-a841-d28dc4c76b1e | CCI | 2026-09-17 14:40 | put_ladder | 8 | 1 | 91 | 399792.00 | unknown | — | 73.8400 | 15.5000 | ["82.5","85","90","92.5","95","97.5","100","105"] | ["2.7723","2.9011","3.9789","4.3079","4.6196","4.9160","5.1988","5.7291"] | [] | ["XBOX"] | 82.5000 | 105.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b0b9-e32b-7f52-903c-f856529f40c4 | CCI | 2026-09-17 14:56 | put_ladder | 6 | 1 | 78 | 310294.00 | unknown | — | 73.8900 | 9.8000 | ["77.5","85","90","92.5","97.5","105"] | ["1.2611","2.9381","3.8284","4.1525","4.7516","5.5532"] | [] | ["XBOX"] | 77.5000 | 105.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0d4bc-0ba6-7f12-8e52-cff095e59b63 | CCI | 2026-09-24 14:44 | put_vertical_spread | 2 | 1 | 84 | 202440.00 | unknown | bid | 68.0600 | 5.4000 | ["80","82.5"] | ["0.7706","0.8756"] | ["69.20"] | ["XBOX"] | 80.0000 | 82.5000 | 22 | 22 | false | false | false | ||||||||||
| 01a0d8df-5b3e-71a2-8627-074e262c9a69 | CCI | 2026-09-25 10:01 | put_diagonal_spread | 2 | 1 | 150 | 270270.00 | unknown | ask | 66.9850 | 3.7000 | ["75","77.5"] | ["0.4191","0.5749"] | [] | ["XBOX"] | 75.0000 | 77.5000 | 21 | 84 | false | false | true | true | |||||||||
| 01a0d96d-6e57-7893-bf7a-9313d9afd80b | CCI | 2026-09-25 12:37 | call_ratio_spread | 2 | 1 | 442 | 135915.00 | unknown | bid | 67.7850 | 0.3500 | ["67.5","75"] | ["0.3305","0.3193"] | ["73.65"] | ["XPHO"] | 67.5000 | 75.0000 | 56 | 56 | true | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:29:01Z"} |
| 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-14T17:29:01Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-14T17:29:47Z"} |
| 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-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:56:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:45:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:01:53Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:37:21Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |