core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg677,480 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 |
|---|
| 01a0f898-b98f-7ae1-8559-3b536f430078 | HL | 2026-10-01 13:52 | call_condor | 4 | 1 | 2925 | 231075.00 | unknown | ask | 17.0599 | 0.2200 | ["18","19","20","21"] | ["0.5369","0.5785","0.6100","0.6858"] | ["21.00"] | ["XPHO"] | 18.0000 | 21.0000 | 15 | 15 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T17:53:04Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0ed83-f2b6-7ef1-b654-cedb73125bd1 | HL | 2026-09-29 10:14 | call_vertical_spread | 2 | 1 | 200 | 152000.00 | short | bid | 17.1050 | 0.2800 | ["13","16"] | ["0.5906","0.6002"] | ["14.90"] | ["XISX"] | 13.0000 | 16.0000 | 108 | 108 | false | false | false | true | |||||||||
| 01a0e835-987a-7321-9395-bd626f274ab1 | HL | 2026-09-28 09:30 | put_vertical_spread | 2 | 1 | 100 | 164000.00 | long | ask | 17.1300 | 0.5500 | ["18","30"] | ["0.6223","0.7724"] | ["20"] | ["XPHO"] | 18.0000 | 30.0000 | 172 | 172 | false | false | false | true | |||||||||
| 01a0d4c4-645f-7de1-a036-0814e1093c11 | HL | 2026-09-24 14:53 | put_ladder | 5 | 1 | 628 | 276880.00 | unknown | ask | 17.8350 | 1.8400 | ["19.5","20","20.5","21","21.5"] | ["1.8209","1.7481","2.5995","2.5465","4.2540"] | ["17.97"] | ["XBOX"] | 19.5000 | 21.5000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0ca35-f03f-7f81-9f2d-5bd26a8d2e1c | HL | 2026-09-22 13:42 | strangle | 2 | 1 | 2000 | 644000.00 | long | ask | 18.8350 | 0.1400 | ["20","23"] | ["0.6301","0.6456"] | ["16.78","26.22"] | ["AMXO"] | 20.0000 | 23.0000 | 59 | 59 | true | false | false | true | |||||||||
| 01a0b0ad-6bc3-7020-ab55-59c71bee335f | HL | 2026-09-17 14:42 | put_ladder | 3 | 1 | 1008 | 773340.00 | unknown | — | 18.9650 | 1.9000 | ["22","23","24"] | ["2.8931","2.7038","5.9823"] | [] | ["XBOX"] | 22.0000 | 24.0000 | 1 | 1 | false | false | false | true | false | mlft | |||||||
| 01a0abbe-9e6b-7742-8fa5-5fe60683ee16 | HL | 2026-09-16 15:43 | call_calendar | 2 | 1 | 250 | 506500.00 | unknown | — | 17.7550 | 2.7000 | ["10"] | ["0.6862"] | [] | ["XISX"] | 10.0000 | 10.0000 | 492 | 856 | false | false | true | false | false | mlet | |||||||
| 01a0ab94-eaa3-7df1-b0fc-f3b96f0785b0 | HL | 2026-09-16 14:57 | call_diagonal_spread | 2 | 1 | 50 | 114700.00 | long | bid | 17.8037 | 3.5500 | ["8","10"] | ["0.8995","0.8009"] | [] | ["XISX"] | 8.0000 | 10.0000 | 492 | 856 | false | false | true | true | |||||||||
| 01a0a0ad-6d80-7563-8bc4-26e9eef3ba76 | HL | 2026-09-14 12:08 | other | 4 | 1 | 2703 | 467619.00 | unknown | — | 18.8950 | 0.1800 | ["20","21","22","23"] | ["0.6283","0.6401","0.8359","0.9585"] | [] | ["XPHO"] | 20.0000 | 23.0000 | 4 | 32 | false | true | true | true | false | mlat |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:14:26Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:30:11Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:54:24Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:42:28Z"} |
| 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:42:34Z"} |
| 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-16T19:43:10Z"} |
| 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:57:53Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:08:50Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |