core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0ce7a-681f-7283-b702-441f6a4056d6 | LMT | 2026-09-23 09:35 | other | 4 | 1 | 19 | 144248.00 | unknown | ask | 525.9822 | 22.8000 | ["500","555"] | ["0.3079","0.3162"] | [] | ["XCBO"] | 500.0000 | 555.0000 | 9 | 30 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T13:35:24Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0ca93-5e37-76c2-a8a0-9f41c26031ea | LMT | 2026-09-22 15:24 | put_vertical_spread | 2 | 1 | 4 | 216460.00 | long | ask | 522.6600 | 7.7000 | ["790","795"] | ["2.2388","2.2568"] | ["790.03"] | ["XMIO"] | 790.0000 | 795.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0ca7c-b56e-7880-ba5d-b898d5bc6ba4 | LMT | 2026-09-22 14:59 | call_vertical_spread | 2 | 1 | 5 | 198805.00 | unknown | bid | 521.7050 | 15.9000 | ["320","325"] | ["3.4700","3.5268"] | ["521.30"] | ["XISX"] | 320.0000 | 325.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0ca74-aad6-7b71-b408-8b9339b73cae | LMT | 2026-09-22 14:50 | call_vertical_spread | 2 | 1 | 4 | 158964.00 | unknown | bid | 521.7850 | 16.3000 | ["320","325"] | ["3.4523","3.5112"] | ["521.20"] | ["XISX"] | 320.0000 | 325.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0ca06-0e6f-7672-b485-64bde356cb41 | LMT | 2026-09-22 12:49 | put_vertical_spread | 2 | 1 | 3 | 151137.00 | long | ask | 521.4050 | 14.4000 | ["770","775"] | ["2.1554","2.1752"] | ["770.03"] | ["XMIO"] | 770.0000 | 775.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c9f3-0f27-7943-a692-77a65d0c3926 | LMT | 2026-09-22 12:29 | put_vertical_spread | 2 | 1 | 4 | 221516.00 | long | ask | 521.2941 | 14.2000 | ["795","800"] | ["2.2636","2.2808"] | ["795.03"] | ["XMIO"] | 795.0000 | 800.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c9f2-c8d6-7720-b3ee-4745fa287ec2 | LMT | 2026-09-22 12:28 | put_vertical_spread | 2 | 1 | 3 | 151317.00 | long | ask | 521.3950 | 14.4000 | ["770","775"] | ["2.2414","2.2632"] | ["770.03"] | ["XPHO"] | 770.0000 | 775.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c9e4-941f-7751-b5f8-91b9e72285c0 | LMT | 2026-09-22 12:13 | put_vertical_spread | 2 | 1 | 4 | 221420.00 | long | ask | 521.7300 | 13.7000 | ["795","800"] | ["2.3622","2.3819"] | ["795.03"] | ["XMIO"] | 795.0000 | 800.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0afbd-81cb-7100-8b94-d590f552a669 | LMT | 2026-09-17 10:20 | put_calendar | 2 | 1 | 10 | 103660.00 | short | ask | 536.7400 | 7.8000 | ["540"] | ["0.2959"] | [] | ["XISX"] | 540.0000 | 540.0000 | 273 | 365 | false | false | true | false | |||||||||
| 01a0a667-2b2e-7091-a4c4-1d5c92cd0adc | LMT | 2026-09-15 14:49 | call_vertical_spread | 2 | 1 | 10 | 231130.00 | unknown | — | 534.6150 | 11.4000 | ["430","510"] | ["0.2615","0.2717"] | [] | ["MCRY"] | 430.0000 | 510.0000 | 493 | 493 | false | false | false | true | false | ||||||||
| 01a0a5c5-caae-7f81-8c5b-ccbfe0243bf0 | LMT | 2026-09-15 11:53 | call_calendar | 2 | 3 | 5 | 102642.00 | short | ask | 530.3600 | 13.9200 | ["430"] | ["0.4027"] | [] | ["ARCO","EMLD","XBOX"] | 430.0000 | 430.0000 | 38 | 45 | false | false | true | false | |||||||||
| 01a0a590-7655-7391-9fca-4fb2ef938779 | LMT | 2026-09-15 10:55 | other | 6 | 4 | 5 | 144535.00 | unknown | — | 529.4700 | 35.0600 | ["425","435","440"] | ["0.4112","0.3713","0.2644"] | [] | ["C2OX","EMLD","XBOX","XISX"] | 425.0000 | 440.0000 | 38 | 45 | false | false | true | true | false | ||||||||
| 01a0a590-7655-7391-9fca-4f9572715730 | LMT | 2026-09-15 10:55 | other | 4 | 3 | 4 | 118430.00 | unknown | — | 529.4700 | 24.4000 | ["430","440"] | ["0.4184","0.2696"] | [] | ["EMLD","XBOX","XCBO"] | 430.0000 | 440.0000 | 38 | 45 | false | false | true | true | false | mlet | |||||||
| 01a0a57d-b976-7eb0-8968-4e90917b89f6 | LMT | 2026-09-15 10:34 | put_calendar | 2 | 2 | 36 | 166860.00 | short | ask | 529.2600 | 5.9000 | ["535"] | ["0.3007"] | [] | ["ARCO","EDGO"] | 535.0000 | 535.0000 | 38 | 45 | true | false | true | false | |||||||||
| 01a0828e-5a59-7801-a66c-348400c57cc6 | LMT | 2026-09-08 15:45 | put_vertical_spread | 2 | 1 | 9 | 146862.00 | long | ask | 536.2100 | 9.5000 | ["615","620"] | ["0.4951","0.5166"] | ["615.02"] | ["C2OX"] | 615.0000 | 620.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a08165-3020-7c32-9625-5453f158d918 | LMT | 2026-09-08 10:21 | put_vertical_spread | 2 | 4 | 34 | 104904.00 | short | bid | 539.1650 | 3.1000 | ["530","540"] | ["0.2653","0.2644"] | ["535.45"] | ["BATO","EDGO","XCBO","XISX"] | 530.0000 | 540.0000 | 38 | 38 | true | false | false | ||||||||||
| 01a06d4b-068d-7333-83fd-389016e1b9da | LMT | 2026-09-04 12:40 | risk_reversal | 2 | 1 | 25 | 103425.00 | short | bid | 526.7000 | 4.8000 | ["510","540"] | ["0.2886","0.2826"] | ["545.17"] | ["MCRY"] | 510.0000 | 540.0000 | 77 | 77 | false | true | false | ||||||||||
| 01a06d2f-8395-7ac3-a7e7-96dbf6299a23 | LMT | 2026-09-04 12:10 | put_calendar | 2 | 1 | 20 | 165680.00 | long | bid | 527.2900 | 9.5000 | ["560"] | ["0.2968"] | [] | ["ARCO"] | 560.0000 | 560.0000 | 14 | 105 | false | false | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:24:29Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:59:44Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:51:07Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:50:08Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:29:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:29:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:13:16Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:20: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-15T18:50:05Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:53:25Z"} |
| 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-15T14:55:11Z"} |
| 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-15T14:55:11Z"} |
| 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-15T14:34:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T19:46:02Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:21:32Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:40:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:10:26Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |