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 |
|---|
| 01a0f8f3-50f7-7750-b04d-a5a395d06e87 | JPM | 2026-10-01 15:31 | other | 4 | 1 | 151 | 431114.00 | unknown | bid | 332.7200 | 7.6500 | ["342.5","345","350","352.5"] | ["0.4601","0.7967","0.8860","1.1386"] | ["333.25"] | ["XBOX"] | 342.5000 | 352.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T19:32:03Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f346-7f17-7e72-ba41-9eedcb9882b6 | JPM | 2026-09-30 13:04 | other | 4 | 1 | 240 | 129480.00 | unknown | ask | 332.7500 | 1.2600 | ["340","342.5","347.5","352.5"] | ["0.2665","0.2647","0.2663","0.2673"] | ["354.33"] | ["XCBO"] | 340.0000 | 352.5000 | 16 | 16 | false | true | |||||||||||
| 01a0edd0-74a7-7d53-9c3c-ffca7e583e5f | JPM | 2026-09-29 11:37 | other | 4 | 1 | 50 | 119450.00 | unknown | — | 335.0100 | 3.6000 | ["327.5","330","332.5","335"] | ["0.3329","0.2908","0.3206","0.2867"] | [] | ["ARCO"] | 327.5000 | 335.0000 | 10 | 17 | false | true | true | true | |||||||||
| 01a0eda2-e0af-7e20-83de-fafbf1c1ca23 | JPM | 2026-09-29 10:47 | other | 4 | 1 | 10 | 153300.00 | unknown | bid | 335.6600 | 6.5000 | ["340","395"] | ["0.2722","0.3515"] | [] | ["XISX"] | 340.0000 | 395.0000 | 52 | 80 | false | false | |||||||||||
| 01a0eda0-2577-7da1-ba90-032f9569c5ae | JPM | 2026-09-29 10:44 | other | 4 | 1 | 10 | 132440.00 | unknown | ask | 335.3999 | 6.2500 | ["335","390"] | ["0.3011","0.4232"] | [] | ["EDGO"] | 335.0000 | 390.0000 | 17 | 52 | false | false | |||||||||||
| 01a0e900-79f0-75a2-a35c-5b2f3955ce83 | JPM | 2026-09-28 13:11 | other | 4 | 1 | 50 | 109850.00 | unknown | — | 338.9450 | 2.6000 | ["330","332.5","335","337.5"] | ["0.3285","0.2726","0.3220","0.2685"] | [] | ["XISX"] | 330.0000 | 337.5000 | 11 | 18 | false | true | true | true | |||||||||
| 01a0d4be-bf0f-7213-96f3-29bb26209f72 | JPM | 2026-09-24 14:47 | other | 4 | 1 | 154 | 509132.00 | unknown | bid | 337.0050 | 9.8500 | ["350","352.5","360","370"] | ["0.3858","0.8901","0.4092","1.4730"] | [] | ["XBOX"] | 350.0000 | 370.0000 | 1 | 8 | false | false | |||||||||||
| 01a0cf83-3917-7a02-9090-405f07acd60c | JPM | 2026-09-23 14:24 | other | 4 | 6 | 24 | 162815.00 | unknown | — | 337.9200 | 1.1500 | ["330","340"] | ["0.2569","0.2548"] | [] | ["ARCO","EMLD"] | 330.0000 | 340.0000 | 177 | 177 | false | false | false | true | |||||||||
| 01a0cf2a-c877-7293-9f81-d5c383d91bea | JPM | 2026-09-23 12:48 | other | 4 | 1 | 50 | 104800.00 | unknown | ask | 337.8500 | 1.6000 | ["332.5","335","337.5","340"] | ["0.2578","0.2398","0.2569","0.2341"] | [] | ["XMIO"] | 332.5000 | 340.0000 | 9 | 16 | false | false | |||||||||||
| 01a0ceeb-c78f-7741-b10e-e447c1684c9f | JPM | 2026-09-23 11:39 | other | 4 | 2 | 10 | 143826.00 | unknown | — | 337.5450 | 4.9000 | ["240","310","342.5","347.5"] | ["0.3474","0.2216","0.2889","0.2937"] | [] | ["XCBO","XISX"] | 240.0000 | 347.5000 | 2 | 849 | false | false | true | true | |||||||||
| 01a0ce75-a94a-7ea1-8ce5-98aa6775f31d | JPM | 2026-09-23 09:30 | other | 4 | 1 | 20 | 104780.00 | unknown | bid | 337.7650 | 15.0500 | ["345","350"] | ["0.2784","0.3053"] | [] | ["XISX"] | 345.0000 | 350.0000 | 2 | 37 | false | false | |||||||||||
| 01a0b52a-3d28-74e1-8a26-716df7c97bae | JPM | 2026-09-18 11:37 | other | 4 | 1 | 120 | 567900.00 | unknown | — | 347.1600 | 6.0500 | ["330","340"] | ["0.7684","0.3427"] | [] | ["XISX"] | 330.0000 | 340.0000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a0b4d4-f907-7311-a707-45012adf190a | JPM | 2026-09-18 10:04 | other | 4 | 1 | 35 | 103495.00 | unknown | bid | 346.4575 | 4.0000 | ["345","355"] | ["0.2306","0.2270"] | [] | ["XCBO"] | 345.0000 | 355.0000 | 7 | 14 | false | false | |||||||||||
| 01a0aba1-526b-7803-aaec-6073afdf4b0a | JPM | 2026-09-16 15:11 | other | 4 | 2 | 400 | 106304.00 | unknown | — | 346.2850 | 6.2300 | ["330","375","385"] | ["0.4334","0.2430","0.2460"] | [] | ["XMIO","XPHO"] | 330.0000 | 385.0000 | 2 | 30 | false | false | true | true | |||||||||
| 01a0ab22-fe93-7533-91a0-aab83c37f31c | JPM | 2026-09-16 12:53 | other | 6 | 1 | 100 | 115400.00 | unknown | — | 350.0800 | 1.6000 | ["315","330","335","345","370","375"] | ["0.3160","0.4037","0.2932","0.3282","0.2400","0.3710"] | [] | ["AMXO"] | 315.0000 | 375.0000 | 2 | 30 | false | true | true | true | |||||||||
| 01a0a621-4c75-7de1-bdcc-8e3dc769dc41 | JPM | 2026-09-15 13:33 | other | 4 | 2 | 14 | 164536.00 | unknown | — | 345.3800 | 5.9600 | ["290","350","370"] | ["0.8124","0.3257","0.2416"] | [] | ["EMLD","XBOX"] | 290.0000 | 370.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a0a563-307d-7550-8593-64c5eac80f3d | JPM | 2026-09-15 10:05 | other | 4 | 3 | 999 | 839048.00 | unknown | — | 350.6100 | 0.9400 | ["360","370","375"] | ["0.2359","0.3030","0.2310"] | [] | ["XISX"] | 360.0000 | 375.0000 | 3 | 31 | false | true | true | true | |||||||||
| 01a0a170-b1c8-7192-824f-284ae8c84f43 | JPM | 2026-09-14 15:41 | other | 2 | 2 | 64 | 141952.00 | unknown | — | 350.0175 | 1.6500 | ["345","350"] | ["0.2794","0.2296"] | [] | ["EMLD","SPHR"] | 345.0000 | 350.0000 | 4 | 67 | false | false | true | true | false | ||||||||
| 01a0a167-b8e9-7081-b477-1989852b58ff | JPM | 2026-09-14 15:32 | other | 2 | 1 | 64 | 138176.00 | unknown | — | 349.2550 | 0.6000 | ["350","355"] | ["0.2840","0.2593"] | [] | ["XCBO"] | 350.0000 | 355.0000 | 4 | 67 | false | false | true | true | false | ||||||||
| 01a0a14a-6130-7700-980d-83aa335337a1 | JPM | 2026-09-14 14:59 | other | 2 | 1 | 17 | 129948.00 | unknown | — | 350.5000 | 6.7000 | ["410","420"] | ["0.2389","0.2371"] | [] | ["XCBO"] | 410.0000 | 420.0000 | 823 | 858 | false | true | true | true | false | ||||||||
| 01a0a129-d140-7543-9f03-ca28c0b9ca7d | JPM | 2026-09-14 14:24 | other | 2 | 1 | 46 | 355396.00 | unknown | — | 349.6200 | 3.5000 | ["310","320"] | ["0.7621","0.2395"] | [] | ["XMIO"] | 310.0000 | 320.0000 | 4 | 95 | false | false | true | true | false | ||||||||
| 01a0a119-eed8-7793-a30f-74e8dfabad6f | JPM | 2026-09-14 14:07 | other | 2 | 1 | 27 | 108810.00 | unknown | — | 348.7900 | 2.9000 | ["330","350"] | ["0.3755","0.2408"] | [] | ["MCRY"] | 330.0000 | 350.0000 | 4 | 123 | false | false | true | true | false | ||||||||
| 01a0911a-13c8-78c1-a2b9-4104df1ac507 | JPM | 2026-09-11 11:33 | other | 2 | 1 | 10 | 100000.00 | unknown | — | 356.7100 | 6.1000 | ["305","310"] | ["0.2142","0.3079"] | [] | ["XMIO"] | 305.0000 | 310.0000 | 21 | 35 | false | false | true | true | false | ||||||||
| 01a090e8-6509-7a01-8c4c-cdd340442b52 | JPM | 2026-09-11 10:39 | other | 2 | 2 | 56 | 497504.00 | unknown | — | 355.5800 | 3.5750 | ["315"] | ["0.3770"] | [] | ["ARCO","EDGO"] | 315.0000 | 315.0000 | 7 | 98 | false | false | true | false | false | ||||||||
| 01a090c0-66c1-7f73-847c-1e6691b06d7e | JPM | 2026-09-11 09:55 | other | 4 | 1 | 35 | 209685.00 | unknown | — | 357.5600 | 7.3600 | ["350","355","375","380"] | ["0.2381","0.2533","0.2025","0.2490"] | [] | ["XISX"] | 350.0000 | 380.0000 | 7 | 70 | false | false | true | true | |||||||||
| 01a08bed-c071-7013-bdfb-f57dc3c13a43 | JPM | 2026-09-10 11:26 | other | 2 | 1 | 8 | 245352.00 | unknown | — | 353.5800 | 4.9000 | ["200"] | ["1.1671"] | [] | ["MCRY"] | 200.0000 | 200.0000 | 8 | 99 | false | false | true | false | false | ||||||||
| 01a08b99-4f40-7d32-a3b2-23af906d1812 | JPM | 2026-09-10 09:54 | other | 2 | 2 | 41 | 369328.00 | unknown | — | 351.5700 | 6.4500 | ["310","350"] | ["0.5183","0.2509"] | [] | ["XMIO"] | 310.0000 | 350.0000 | 8 | 463 | false | false | true | true | false | ||||||||
| 01a081b8-de01-75d0-9fd8-eff875636b98 | JPM | 2026-09-08 11:52 | other | 2 | 1 | 595 | 3106750.00 | unknown | — | 355.8400 | 1.4000 | ["350","360"] | ["0.2406","0.2440"] | [] | ["XBOX"] | 350.0000 | 360.0000 | 129 | 282 | false | false | true | true | false | ||||||||
| 01a0814d-c7f0-7060-8553-705bf88749f9 | JPM | 2026-09-08 09:55 | other | 2 | 1 | 1200 | 3316800.00 | unknown | — | 356.8000 | 3.5000 | ["270","320"] | ["0.3087","0.2939"] | [] | ["AMXO"] | 270.0000 | 320.0000 | 282 | 500 | true | true | true | true | false | ||||||||
| 01a06de9-32be-7802-b3dc-dadea7181be3 | JPM | 2026-09-04 15:33 | other | 2 | 1 | 7 | 202825.00 | unknown | — | 358.0500 | 5.1500 | ["210","220"] | ["0.8004","0.4774"] | [] | ["XBOX"] | 210.0000 | 220.0000 | 42 | 77 | false | false | true | true | false | ||||||||
| 01a06d6c-88ad-7d40-97dd-0a8e78fe277a | JPM | 2026-09-04 13:17 | other | 4 | 1 | 40 | 108240.00 | unknown | — | 358.5500 | 3.7500 | ["350","375"] | ["0.2563","0.2151"] | [] | ["XISX"] | 350.0000 | 375.0000 | 42 | 49 | false | true | true | true | true |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T17:05:14Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T15:38:11Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:47:56Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T14:45:19Z"} |
| 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-28T17:12:07Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:47:54Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:24:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:48:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:39:47Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:30:12Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:37:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:04:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:11:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 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-15T17:33:58Z"} |
| 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:05:46Z"} |
| 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-14T19:41:58Z"} |
| 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-14T19:32:03Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:00:00Z"} |
| 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-14T18:24:30Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:07:14Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:33:36Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:39:11Z"} |
| 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-11T13:55:31Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:26:59Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:54:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:52:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:55:55Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:33:14Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:17:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |