core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a08682-58a8-7b33-9f7b-0e988d994a4f | URI | 2026-09-09 10:11 | put_vertical_spread | 2 | 1 | 10 | 107240.00 | long | ask | 1041.0815 | 19.6000 | ["1080","1090"] | ["0.4021","0.4044"] | ["1082.40"] | ["MCRY"] | 1080.0000 | 1090.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:11:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08c0f-9c68-79a2-b740-9f517a3e7685 | URI | 2026-09-10 12:03 | other | 2 | 1 | 10 | 1006600.00 | unknown | — | 992.5650 | 32.0000 | ["500"] | ["0.6531"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 99 | 280 | false | false | true | false | false | ||||||||
| 01a090fd-6bd8-76c2-9650-4f474de9ab24 | URI | 2026-09-11 11:01 | call_diagonal_spread | 2 | 1 | 19 | 604371.00 | long | ask | 993.9850 | 18.6000 | ["940","1000"] | ["0.3794","0.3912"] | [] | ["XMIO"] | 940.0000 | 1000.0000 | 189 | 371 | false | false | |||||||||||
| 01a09171-f3e0-7b11-8a43-5dea1d8fe1a2 | URI | 2026-09-11 13:09 | put_vertical_spread | 2 | 1 | 50 | 142989.00 | long | ask | 992.4754 | 10.8000 | ["900","950"] | ["0.3348","0.3254"] | ["938.29"] | ["XMIO"] | 900.0000 | 950.0000 | 35 | 35 | true | true | |||||||||||
| 01a0a593-606e-7f01-91cc-7d3f181597fc | URI | 2026-09-15 10:58 | call_diagonal_spread | 2 | 5 | 8 | 101318.00 | unknown | — | 985.1399 | 12.4000 | ["970","1040"] | ["0.3817","0.5173"] | [] | ["AMXO","ARCO","XCBO","XISX","XMIO"] | 970.0000 | 1040.0000 | 3 | 185 | false | false | true | true | |||||||||
| 01a0a638-9566-7712-96ed-1944da7436a7 | URI | 2026-09-15 13:58 | call_vertical_spread | 2 | 2 | 10 | 192895.00 | short | bid | 985.2900 | 21.8000 | ["810","1170"] | ["0.4609","0.4377"] | ["985.46"] | ["ARCO","XPHO"] | 810.0000 | 1170.0000 | 38 | 38 | true | false | |||||||||||
| 01a0af8f-9fbb-7a03-bc86-60c66cc56954 | URI | 2026-09-17 09:30 | other | 4 | 1 | 6 | 188286.00 | unknown | — | 0.0000 | 79.1000 | ["1440","1480","1620","1760"] | ["0.4131","0.4099","0.3853","0.3793"] | [] | ["XISX"] | 1440.0000 | 1760.0000 | 491 | 855 | false | false | true | true | |||||||||
| 01a0b01c-7e33-7fb2-a211-57ad64687c90 | URI | 2026-09-17 12:04 | put_diagonal_spread | 2 | 2 | 6 | 105582.00 | unknown | — | 1013.4775 | 19.3000 | ["1020","1050"] | ["0.3982","0.3218"] | [] | ["ARCO","XISX"] | 1020.0000 | 1050.0000 | 22 | 273 | false | false | true | true | |||||||||
| 01a0b0b4-bec3-7e02-a2b4-20e51bd16420 | URI | 2026-09-17 14:50 | other | 4 | 1 | 19 | 524916.00 | unknown | — | 1004.9200 | 63.5000 | ["1120","1140","1160","1180"] | ["1.8795","2.0993","2.2754","2.4897"] | [] | ["XBOX"] | 1120.0000 | 1180.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a0b54f-b6e7-7771-a0fa-659dfb978715 | URI | 2026-09-18 12:18 | other | 3 | 1 | 20 | 111360.00 | unknown | — | 1003.6450 | 20.5500 | ["960","1000"] | ["1.3772","0.6663"] | [] | ["XPHO"] | 960.0000 | 1000.0000 | 0 | 0 | false | false | false | true | true | ||||||||
| 01a0c489-2247-7992-8d75-0224d8e0d603 | URI | 2026-09-21 11:15 | call_butterfly_spread | 3 | 1 | 22 | 105468.00 | short | bid | 1018.6700 | 22.9000 | ["990","1060","1120"] | ["0.3144","0.3204","0.3387"] | ["1010.60","1109.40"] | ["EDGO"] | 990.0000 | 1120.0000 | 25 | 25 | false | false | |||||||||||
| 01a0c571-152e-7272-8d75-b4afb74b07a2 | URI | 2026-09-21 15:28 | call_vertical_spread | 2 | 1 | 3 | 110145.00 | short | bid | 1029.0900 | 25.8000 | ["1280","1300"] | ["0.3679","0.3675"] | ["1285.85"] | ["XPHO"] | 1280.0000 | 1300.0000 | 851 | 851 | false | true | |||||||||||
| 01a0c576-2ddf-7563-a9f2-e5e4ad80f7a3 | URI | 2026-09-21 15:34 | straddle | 2 | 1 | 50 | 837500.00 | long | ask | 1028.5401 | 17.8000 | ["1040"] | ["0.3631"] | ["872.50","1207.50"] | ["SPHR"] | 1040.0000 | 1040.0000 | 116 | 116 | true | false | false | ||||||||||
| 01a0c997-9cff-7961-94f6-0259365418e4 | URI | 2026-09-22 10:49 | put_vertical_spread | 2 | 1 | 11 | 126148.00 | long | ask | 1045.3150 | 14.5000 | ["1030","1040"] | ["0.3949","0.3941"] | ["1035.26"] | ["C2OX"] | 1030.0000 | 1040.0000 | 59 | 59 | true | true | |||||||||||
| 01a0c9b5-6dcf-7502-bfcc-157034fa6273 | URI | 2026-09-22 11:21 | call_vertical_spread | 2 | 1 | 3 | 112290.00 | short | bid | 1046.1400 | 32.4000 | ["880","1240"] | ["0.3992","0.3722"] | ["1048.90"] | ["ARCO"] | 880.0000 | 1240.0000 | 360 | 360 | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:04:08Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:02:15Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:09:33Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:58:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:58:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:04:13Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:50:39Z"} |
| 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-18T16:18:24Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:15:31Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:28:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:34:20Z"} |
| 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-22T14:49:33Z"} |
| 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-22T15:22:12Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |