core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0f81e-41fe-7db0-9f0c-dd5b9f9d6e0b | XYZ | 2026-10-01 11:38 | other | 4 | 1 | 710 | 139870.00 | unknown | bid | 72.7000 | 0.5600 | ["74","77","78","81"] | ["0.4111","0.4407","0.8229","1.3523"] | [] | ["AMXO"] | 74.0000 | 81.0000 | 1 | 8 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T15:39:15Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0d9fd-a837-7fa1-8fbe-b3e5ab71a7d3 | XYZ | 2026-09-25 15:14 | other | 4 | 1 | 710 | 117886.00 | unknown | bid | 76.8650 | 0.5000 | ["77","78","79","81"] | ["0.7025","0.3670","2.0475","0.3880"] | [] | ["AMXO"] | 77.0000 | 81.0000 | 0 | 7 | false | true | |||||||||||
| 01a0ca1f-6e87-74f0-8c95-9c7d60c0eef3 | XYZ | 2026-09-22 13:17 | call_diagonal_spread | 2 | 3 | 41 | 134352.00 | long | bid | 77.5600 | 2.7500 | ["75","120"] | ["0.4754","0.4710"] | [] | ["AMXO","XCBO","XPHO"] | 75.0000 | 120.0000 | 486 | 815 | false | false | |||||||||||
| 01a0ca1f-6e87-74f0-8c95-9c659d69ba5f | XYZ | 2026-09-22 13:17 | call_diagonal_spread | 2 | 2 | 46 | 151616.00 | long | bid | 77.5600 | 2.8000 | ["75","120"] | ["0.4784","0.4731"] | [] | ["AMXO","XCBO"] | 75.0000 | 120.0000 | 486 | 815 | false | false | |||||||||||
| 01a0ca1e-7487-7630-b404-93ae6281e16a | XYZ | 2026-09-22 13:16 | call_diagonal_spread | 2 | 1 | 115 | 368196.00 | unknown | bid | 77.5500 | 2.8000 | ["75","120"] | ["0.4643","0.4627"] | [] | ["XBOX"] | 75.0000 | 120.0000 | 486 | 815 | false | false | |||||||||||
| 01a0c498-58cf-7400-80aa-9f8dda2b679a | XYZ | 2026-09-21 11:31 | put_calendar | 2 | 1 | 85 | 123250.00 | short | bid | 77.8550 | 0.7000 | ["85"] | ["0.4406"] | [] | ["XPHO"] | 85.0000 | 85.0000 | 4 | 11 | false | false | true | ||||||||||
| 01a0c480-8ef7-7780-a376-ab83604dc8a5 | XYZ | 2026-09-21 11:05 | call_ladder | 3 | 1 | 571 | 1507440.00 | long | bid | 77.3000 | 2.0000 | ["67.5","77.5","80"] | ["0.4768","0.4558","0.4551"] | ["0","67.5","90.00"] | ["XISX"] | 67.5000 | 80.0000 | 88 | 88 | false | false | |||||||||||
| 01a0b5bb-78d7-7313-a309-a7ea00dd1935 | XYZ | 2026-09-18 14:15 | call_vertical_spread | 2 | 1 | 311 | 200595.00 | short | bid | 76.3400 | 0.9600 | ["70","80"] | ["3.6374","1.9632"] | ["76.37"] | ["XISX"] | 70.0000 | 80.0000 | 0 | 0 | false | false | |||||||||||
| 01a0b580-6f8f-79f2-8c90-c69e241862b0 | XYZ | 2026-09-18 13:11 | straddle | 2 | 3 | 111 | 227550.00 | short | bid | 76.8000 | 0.5991 | ["82.5"] | ["0.4587"] | ["62.0","103.00"] | ["ARCO","MCRY","XBOX"] | 82.5000 | 82.5000 | 182 | 182 | false | false | |||||||||||
| 01a0b564-4c6f-77e2-92a6-1263333e95c5 | XYZ | 2026-09-18 12:40 | straddle | 2 | 3 | 117 | 241605.00 | short | bid | 76.5450 | 1.4000 | ["82.5"] | ["0.4622"] | ["61.85","103.15"] | ["ARCO","XBOX","XMIO"] | 82.5000 | 82.5000 | 182 | 182 | false | false | |||||||||||
| 01a0b02b-bc8b-7ec1-8c4f-47b309adb7da | XYZ | 2026-09-17 12:20 | synthetic | 2 | 3 | 78 | 163020.00 | long | bid | 77.0550 | 1.2000 | ["82.5"] | ["0.4667"] | ["78.88"] | ["ARCO","XBOX","XMIO"] | 82.5000 | 82.5000 | 183 | 183 | false | false | |||||||||||
| 01a0afc0-602b-7242-a3cf-46a599aaf54e | XYZ | 2026-09-17 10:23 | call_calendar | 2 | 1 | 50 | 125150.00 | short | bid | 77.3100 | 1.0000 | ["65"] | ["1.2526"] | [] | ["XISX"] | 65.0000 | 65.0000 | 1 | 29 | false | false | true | ||||||||||
| 01a0aa7e-6dab-7803-88f2-c7baf9df6a27 | XYZ | 2026-09-16 09:53 | call_vertical_spread | 2 | 1 | 41 | 125706.00 | short | bid | 77.9200 | 2.1000 | ["95","100"] | ["0.4774","0.4763"] | ["96.40"] | ["XMIO"] | 95.0000 | 100.0000 | 639 | 639 | false | true | |||||||||||
| 01a06d29-4dbd-7de0-bafc-055ea43e5afd | XYZ | 2026-09-04 12:03 | call_vertical_spread | 2 | 1 | 647 | 113225.00 | short | bid | 82.9200 | 0.2600 | ["84","86"] | ["0.3535","0.3589"] | ["84.59"] | ["XPHO"] | 84.0000 | 86.0000 | 7 | 7 | false | true |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:14:53Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:18:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:18:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:17:10Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:31:53Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:06:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:16:28Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:11:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:40:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:21:11Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:23:33Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:53:45Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:03:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |