core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d8d1-16e7-72c1-9b6a-7760345dc8ff | XLV | 2026-09-25 09:46 | call_vertical_spread | 2 | 1 | 3 | 25626.00 | long | ask | 169.2900 | 4.2000 | ["125","130"] | ["1.4455","1.2990"] | ["129.98"] | ["XCBO"] | 125.0000 | 130.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T13:46:24Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d41b-fb16-7381-902a-c0f61ffc9626 | XLV | 2026-09-24 11:49 | call_vertical_spread | 2 | 1 | 17 | 162010.00 | long | ask | 169.8800 | 1.8000 | ["120","125"] | ["0.7283","0.6660"] | ["124.98"] | ["XMIO"] | 120.0000 | 125.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0d418-edd7-73e2-b8fc-08c45564e31d | XLV | 2026-09-24 11:46 | call_vertical_spread | 2 | 1 | 2 | 26998.00 | long | ask | 170.0200 | 1.4000 | ["100","105"] | ["1.1502","1.1444"] | ["104.97"] | ["XMIO"] | 100.0000 | 105.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0d3f0-9d86-7243-83ad-3fae7f9204e1 | XLV | 2026-09-24 11:02 | call_vertical_spread | 2 | 1 | 12 | 79992.00 | long | ask | 170.4000 | 2.7000 | ["135","140"] | ["0.6050","0.5297"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0d3ec-7aef-7892-a603-8a84934e46a9 | XLV | 2026-09-24 10:58 | call_vertical_spread | 2 | 1 | 10 | 66640.00 | long | ask | 170.5300 | 2.7000 | ["135","140"] | ["0.5070","0.4482"] | ["139.98"] | ["XMIO"] | 135.0000 | 140.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0d3ec-57c7-7432-ba73-9887e59a8097 | XLV | 2026-09-24 10:57 | call_vertical_spread | 2 | 1 | 10 | 66640.00 | long | ask | 170.5375 | 2.7000 | ["135","140"] | ["0.4983","0.4414"] | ["139.98"] | ["XMIO"] | 135.0000 | 140.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0d3eb-908f-7082-82d7-c1d9142b85a2 | XLV | 2026-09-24 10:57 | call_vertical_spread | 2 | 1 | 20 | 133320.00 | long | ask | 170.4700 | 2.7000 | ["135","140"] | ["0.5654","0.4959"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0d3e3-9d67-7920-9392-24028f8a28ad | XLV | 2026-09-24 10:48 | call_vertical_spread | 2 | 1 | 20 | 133320.00 | long | ask | 170.7800 | 2.7000 | ["135","140"] | ["0.7079","0.6429"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a0cf22-19cf-75c1-9b29-86c283e12c3c | XLV | 2026-09-23 12:38 | call_vertical_spread | 2 | 1 | 4 | 45536.00 | long | ask | 168.6500 | 3.3000 | ["110","115"] | ["3.5126","3.2207"] | ["114.98"] | ["XMIO"] | 110.0000 | 115.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0cf1f-c80e-75c3-bdc7-a3df6569ed4a | XLV | 2026-09-23 12:35 | call_vertical_spread | 2 | 1 | 3 | 45807.00 | long | ask | 168.6100 | 0.6000 | ["90","95"] | ["1.2067","1.1499"] | ["94.97"] | ["XISX"] | 90.0000 | 95.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0cf1d-14a7-7902-9c21-346abd0280e4 | XLV | 2026-09-23 12:33 | call_vertical_spread | 2 | 1 | 2 | 28760.00 | long | ask | 168.6600 | 2.8000 | ["95","100"] | ["2.0754","1.9223"] | ["99.98"] | ["XMIO"] | 95.0000 | 100.0000 | 9 | 9 | false | false | false | ||||||||||
| 01a0cf1a-fd7e-7800-9158-5bf07388d5c5 | XLV | 2026-09-23 12:30 | call_vertical_spread | 2 | 1 | 48 | 590112.00 | long | ask | 168.7205 | 0.8500 | ["105","110"] | ["0.9220","0.8582"] | ["109.98"] | ["XCBO"] | 105.0000 | 110.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0cf17-3c8f-7691-8549-bb76760c3ec8 | XLV | 2026-09-23 12:26 | call_vertical_spread | 2 | 1 | 21 | 258090.00 | long | ask | 168.6750 | 0.8000 | ["105","110"] | ["0.9637","0.8927"] | ["109.98"] | ["XMIO"] | 105.0000 | 110.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0cf17-05df-7541-b3d9-b82b7ed3f147 | XLV | 2026-09-23 12:26 | call_vertical_spread | 2 | 1 | 16 | 196640.00 | long | ask | 168.6700 | 0.8000 | ["105","110"] | ["0.9708","0.8987"] | ["109.98"] | ["XMIO"] | 105.0000 | 110.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0cf16-3ea6-7991-bc8f-c9c34e547065 | XLV | 2026-09-23 12:25 | call_vertical_spread | 2 | 1 | 20 | 245840.00 | long | ask | 168.6400 | 0.8000 | ["105","110"] | ["1.0194","0.9407"] | ["109.98"] | ["XCBO"] | 105.0000 | 110.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0cf10-f32f-79e0-9913-8a27cc617aca | XLV | 2026-09-23 12:19 | call_vertical_spread | 2 | 1 | 20 | 245800.00 | long | ask | 168.6700 | 0.8000 | ["105","110"] | ["0.9708","0.8987"] | ["109.98"] | ["XMIO"] | 105.0000 | 110.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0cf0f-1e6f-7a62-84ed-ec327623f53b | XLV | 2026-09-23 12:17 | call_vertical_spread | 2 | 1 | 2 | 26560.00 | long | ask | 168.6600 | 0.8000 | ["100","105"] | ["1.0058","0.9401"] | ["104.98"] | ["XMIO"] | 100.0000 | 105.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a0c9fe-59c7-73c2-841d-c93e073bda6b | XLV | 2026-09-22 12:41 | call_vertical_spread | 2 | 1 | 50 | 323000.00 | long | ask | 170.0950 | 2.8000 | ["135","140"] | ["0.7409","0.6868"] | ["139.98"] | ["XPHO"] | 135.0000 | 140.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a0c9f9-25bf-7f61-95fe-dcfb5b9cf7a1 | XLV | 2026-09-22 12:35 | call_vertical_spread | 2 | 1 | 50 | 323100.00 | long | ask | 170.1000 | 2.8000 | ["135","140"] | ["0.7379","0.6847"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a0c4d4-9e7f-7e41-bf83-da23a98f241f | XLV | 2026-09-21 12:37 | call_vertical_spread | 2 | 1 | 2 | 26426.00 | long | ask | 168.6200 | 3.5500 | ["100","105"] | ["1.3333","1.2597"] | ["104.97"] | ["XMIO"] | 100.0000 | 105.0000 | 18 | 18 | false | false | false | ||||||||||
| 01a0c46b-12f7-7981-829b-7ed87f9ab579 | XLV | 2026-09-21 10:42 | call_vertical_spread | 2 | 1 | 19 | 116356.00 | long | ask | 168.8800 | 4.2500 | ["135","140"] | ["0.6210","0.5628"] | ["139.98"] | ["XCBO"] | 135.0000 | 140.0000 | 11 | 11 | false | false | false | ||||||||||
| 01a0b612-4780-7b61-a54a-0bc357ae1129 | XLV | 2026-09-18 15:50 | call_vertical_spread | 2 | 1 | 35 | 243950.00 | long | ask | 168.5800 | 2.1500 | ["110","157.5"] | ["1.7000","0.4197"] | ["157.5"] | ["XPHO"] | 110.0000 | 157.5000 | 7 | 7 | false | false | false | ||||||||||
| 01a0aa78-a533-7aa3-b025-4451c9920d1d | XLV | 2026-09-16 09:47 | call_vertical_spread | 2 | 1 | 500 | 248500.00 | long | ask | 168.3200 | 1.0000 | ["165","168"] | ["0.2635","0.2363"] | ["167.25"] | ["XCBO"] | 165.0000 | 168.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0a043-7c69-7653-a328-90ba0cc88243 | XLV | 2026-09-14 10:12 | call_vertical_spread | 2 | 1 | 2 | 32012.00 | long | ask | 167.1000 | 2.2500 | ["85","90"] | ["3.2958","3.0688"] | ["89.98"] | ["XMIO"] | 85.0000 | 90.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a08bdc-8648-76e2-a0e0-628df6a7ced9 | XLV | 2026-09-10 11:07 | call_vertical_spread | 2 | 1 | 5 | 88880.00 | long | ask | 165.6800 | 3.2000 | ["75","80"] | ["2.9281","2.7262"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 8 | 8 | false | false | false | ||||||||||
| 01a08706-26d9-7500-954c-d4f628bc75d6 | XLV | 2026-09-09 12:35 | call_vertical_spread | 2 | 1 | 57 | 617424.00 | long | ask | 166.6000 | 1.0000 | ["110","115"] | ["0.8359","0.8480"] | ["114.98"] | ["XCBO"] | 110.0000 | 115.0000 | 16 | 16 | false | false | false | ||||||||||
| 01a086ef-33d8-7ce1-926d-bf07c6d8d380 | XLV | 2026-09-09 12:10 | call_vertical_spread | 2 | 1 | 41 | 652146.00 | long | ask | 166.5590 | 2.1000 | ["85","90"] | ["2.1883","2.0349"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 9 | 9 | false | false | false | ||||||||||
| 01a086e7-ae10-7031-851f-70b79082b797 | XLV | 2026-09-09 12:02 | call_vertical_spread | 2 | 1 | 55 | 875160.00 | long | ask | 166.8000 | 2.0000 | ["85","90"] | ["1.9439","1.8154"] | ["89.98"] | ["XCBO"] | 85.0000 | 90.0000 | 9 | 9 | false | false | false | ||||||||||
| 01a081e2-a169-7f81-8a41-5cca6432067a | XLV | 2026-09-08 12:38 | call_vertical_spread | 2 | 1 | 12 | 132840.00 | long | ask | 167.7200 | 3.2000 | ["110","115"] | ["2.0091","1.8657"] | ["114.98"] | ["XISX"] | 110.0000 | 115.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a081df-6160-7f73-91f9-18d06de56f32 | XLV | 2026-09-08 12:34 | call_vertical_spread | 2 | 1 | 11 | 198924.00 | long | ask | 167.8000 | 2.9000 | ["75","80"] | ["1.7880","1.7198"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a081dc-aa10-7d60-bdb9-731fc9f16fe7 | XLV | 2026-09-08 12:31 | call_vertical_spread | 2 | 1 | 37 | 669182.00 | long | ask | 167.8300 | 2.9000 | ["75","80"] | ["1.6329","1.6247"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a081d3-ff51-7cf0-b0c0-3f61ba1bea93 | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 2 | 36168.00 | long | ask | 167.5550 | 2.9000 | ["75","80"] | ["2.3198","2.1663"] | ["79.98"] | ["XPHO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false | ||||||||||
| 01a081d3-e010-73f1-b456-2a40bcba270d | XLV | 2026-09-08 12:22 | call_vertical_spread | 2 | 1 | 48 | 868128.00 | long | ask | 167.5200 | 2.9000 | ["75","80"] | ["2.3724","2.2139"] | ["79.98"] | ["XCBO"] | 75.0000 | 80.0000 | 10 | 10 | false | false | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:50:22Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:46:37Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:02:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:58:16Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:57:56Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:57:31Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:48:49Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:39:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:36:19Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:33:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:31:25Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:26:45Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:26:45Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:25:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:19:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:17:59Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:41:54Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:36:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:37:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:42:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:50:46Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:47:28Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:13:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:08:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:35:31Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:11:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:02:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:38:28Z"} |
| 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-08T16:34:56Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:32:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:22:41Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:22:41Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |