core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a0f2dd-4597-7060-8e06-daa259fe932e | XLU | 2026-09-30 11:09 | call_calendar | 2 | 1 | 40 | 81800.00 | short | ask | 39.5600 | 1.6000 | ["30"] | ["0.3068"] | [] | ["XCBO"] | 30.0000 | 30.0000 | 79 | 198 | false | false | true | false | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T15:10:19Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0f2d0-9f4f-7153-a5e5-b65d67ac6009 | XLU | 2026-09-30 10:55 | straddle | 2 | 1 | 1000 | 640000.00 | short | bid | 39.5850 | 0.3600 | ["40"] | ["0.1757"] | ["33.60","46.40"] | ["XBOX"] | 40.0000 | 40.0000 | 478 | 478 | false | false | |||||||||||
| 01a0f284-f81f-7423-b849-de5540a459ff | XLU | 2026-09-30 09:33 | put_vertical_spread | 2 | 1 | 14 | 26600.00 | short | bid | 39.6600 | 0.9000 | ["48.5","50"] | ["0.2812","0.2978"] | ["48.68"] | ["AMXO"] | 48.5000 | 50.0000 | 478 | 478 | false | false | |||||||||||
| 01a0ee93-5f17-70b1-a3d2-4f765a36effd | XLU | 2026-09-29 15:10 | straddle | 2 | 1 | 1000 | 645000.00 | short | bid | 39.6750 | 0.4400 | ["40"] | ["0.1760"] | ["33.55","46.45"] | ["XBOX"] | 40.0000 | 40.0000 | 479 | 479 | false | false | |||||||||||
| 01a0ee90-74ff-7e63-9118-d703a659d47f | XLU | 2026-09-29 15:07 | straddle | 2 | 1 | 1000 | 650000.00 | short | bid | 39.6750 | 0.4400 | ["40"] | ["0.1775"] | ["33.50","46.50"] | ["XBOX"] | 40.0000 | 40.0000 | 479 | 479 | false | false | |||||||||||
| 01a0ed66-9716-7972-8f67-c794f3ed254b | XLU | 2026-09-29 09:41 | strangle | 2 | 1 | 729 | 69255.00 | short | bid | 39.4200 | 0.0300 | ["39","40"] | ["0.2042","0.2061"] | ["38.05","40.95"] | ["ARCO"] | 39.0000 | 40.0000 | 17 | 17 | false | true | |||||||||||
| 01a0e89f-6276-7891-a4df-6377ae0f7290 | XLU | 2026-09-28 11:25 | call_diagonal_spread | 2 | 3 | 119 | 28362.00 | short | bid | 39.1100 | 0.3900 | ["44","45"] | ["0.1624","0.1577"] | [] | ["AMXO","XCBO","XPHO"] | 44.0000 | 45.0000 | 262 | 445 | false | true | |||||||||||
| 01a0e897-5bc7-7311-842d-b28e29db8e4c | XLU | 2026-09-28 11:17 | straddle | 2 | 1 | 7500 | 3082500.00 | short | bid | 39.1150 | 0.4500 | ["40"] | ["0.1782"] | ["35.89","44.11"] | ["AMXO"] | 40.0000 | 40.0000 | 200 | 200 | true | false | |||||||||||
| 01a0da2e-35e7-7783-ae54-a5eeb09a0dbc | XLU | 2026-09-25 16:07 | put_vertical_spread | 2 | 1 | 200 | 26800.00 | short | bid | 39.5400 | 0.6000 | ["37","39"] | ["0.1858","0.1847"] | ["38.40"] | ["XMIO"] | 37.0000 | 39.0000 | 84 | 84 | false | true | |||||||||||
| 01a0d9c0-fcf7-7c71-916d-6e39cdf23cc8 | XLU | 2026-09-25 14:08 | call_calendar | 2 | 2 | 10000 | 610000.00 | short | ask | 39.3561 | 0.0500 | ["40"] | ["0.2090"] | [] | ["AMXO"] | 40.0000 | 40.0000 | 7 | 14 | false | true | |||||||||||
| 01a0d989-7dee-7f93-a9c0-5456f71902c0 | XLU | 2026-09-25 13:07 | call_butterfly_spread | 3 | 1 | 10000 | 320000.00 | short | bid | 39.2950 | 0.1000 | ["40.5","41.5","42"] | ["0.1867","0.1974","0.2053"] | ["40.62"] | ["AMXO"] | 40.5000 | 42.0000 | 21 | 21 | false | true | |||||||||||
| 01a0d952-3597-74f0-bcd4-ac0131c18a06 | XLU | 2026-09-25 12:07 | put_vertical_spread | 2 | 4 | 28 | 25680.00 | short | bid | 39.2950 | 0.9321 | ["40","45"] | ["0.2185","0.2452"] | ["41.85"] | ["ARCO","EMLD","SPHR","XPHO"] | 40.0000 | 45.0000 | 483 | 483 | false | false | |||||||||||
| 01a0d93c-86ce-7c52-bc00-c89c31de9eb8 | XLU | 2026-09-25 11:43 | call_diagonal_spread | 2 | 2 | 112 | 46032.00 | short | bid | 39.1850 | 0.1500 | ["38.5","42.5"] | ["0.1761","0.1494"] | [] | ["BATO","EDGO"] | 38.5000 | 42.5000 | 84 | 448 | false | false | |||||||||||
| 01a0d509-8b7f-7092-9b06-2b9d7cecb0f1 | XLU | 2026-09-24 16:09 | risk_reversal | 2 | 1 | 3000 | 1659000.00 | short | bid | 39.4180 | 5.2600 | ["35","42"] | ["0.2105","0.1262"] | ["44.45"] | ["ARCO"] | 35.0000 | 42.0000 | 848 | 848 | false | true | |||||||||||
| 01a0d464-4ace-7ff1-938b-0a13f922a082 | XLU | 2026-09-24 13:08 | call_diagonal_spread | 2 | 1 | 100 | 133700.00 | short | bid | 39.6500 | 1.1000 | ["33","34"] | ["0.2411","0.2272"] | [] | ["XCBO"] | 33.0000 | 34.0000 | 113 | 176 | false | false | |||||||||||
| 01a0d3ee-d47f-7b40-b620-d7d2fdbafac2 | XLU | 2026-09-24 11:00 | put_diagonal_spread | 2 | 1 | 45 | 32445.00 | short | bid | 39.5050 | 0.9200 | ["42","42.5"] | ["0.1979","0.2146"] | [] | ["XCBO"] | 42.0000 | 42.5000 | 204 | 449 | false | false | |||||||||||
| 01a0d3e7-ac77-76f0-b2de-56b637371682 | XLU | 2026-09-24 10:52 | call_diagonal_spread | 2 | 1 | 132 | 35772.00 | short | bid | 39.5050 | 0.2800 | ["44","45"] | ["0.1622","0.1590"] | [] | ["XMIO"] | 44.0000 | 45.0000 | 266 | 449 | false | true | |||||||||||
| 01a0d3b0-a686-7282-a14c-78d36b18822e | XLU | 2026-09-24 09:52 | call_diagonal_spread | 2 | 1 | 220 | 26180.00 | short | bid | 39.7550 | 0.0700 | ["40","42"] | ["0.1716","0.1832"] | [] | ["AMXO"] | 40.0000 | 42.0000 | 22 | 57 | false | true | |||||||||||
| 01a0cab1-c75f-7bd2-bba8-4cbedf002e98 | XLU | 2026-09-22 15:57 | put_calendar | 2 | 1 | 200 | 42200.00 | short | ask | 40.5450 | 0.6100 | ["41.5"] | ["0.1951"] | [] | ["XCBO"] | 41.5000 | 41.5000 | 3 | 17 | false | false | |||||||||||
| 01a0c4bd-846e-7e63-8ece-fed6269a3eda | XLU | 2026-09-21 12:12 | strangle | 2 | 1 | 250 | 46250.00 | short | bid | 40.8600 | 0.2900 | ["38","46"] | ["0.1902","0.1526"] | ["36.15","47.85"] | ["AMXO"] | 38.0000 | 46.0000 | 269 | 269 | false | true | |||||||||||
| 01a0c438-858f-7a92-b40e-fb084a3cfab9 | XLU | 2026-09-21 09:47 | put_calendar | 2 | 2 | 201 | 73365.00 | short | bid | 40.6350 | 0.7600 | ["42.5"] | ["0.2816"] | [] | ["C2OX","XCBO"] | 42.5000 | 42.5000 | 4 | 18 | false | false | |||||||||||
| 01a0b5f0-adef-7c91-b667-3ddf0c12bb12 | XLU | 2026-09-18 15:14 | strangle | 2 | 1 | 2100 | 128100.00 | short | bid | 41.2250 | 0.1100 | ["39.5","43"] | ["0.1880","0.1460"] | ["38.89","43.61"] | ["ARCO"] | 39.5000 | 43.0000 | 42 | 42 | false | true | |||||||||||
| 01a0b094-bb73-7a83-986c-d6137969620a | XLU | 2026-09-17 14:15 | call_vertical_spread | 2 | 1 | 120 | 55800.00 | short | bid | 41.6150 | 0.2200 | ["39","42"] | ["0.0857","0.1421"] | ["40.75"] | ["SPHR"] | 39.0000 | 42.0000 | 120 | 120 | false | false | |||||||||||
| 01a0afbf-df42-7971-a419-aab90526df6d | XLU | 2026-09-17 10:22 | call_diagonal_spread | 2 | 1 | 80 | 86240.00 | short | bid | 41.4100 | 2.9000 | ["36","37"] | ["0.2915","0.5676"] | [] | ["XCBO"] | 36.0000 | 37.0000 | 15 | 64 | false | false | |||||||||||
| 01a0abb4-8093-71f1-a138-61a556e632ae | XLU | 2026-09-16 15:32 | call_vertical_spread | 2 | 1 | 80 | 42480.00 | short | bid | 41.1996 | 1.1900 | ["38","41"] | ["0.1679","0.1456"] | ["39.75"] | ["SPHR"] | 38.0000 | 41.0000 | 121 | 121 | false | false | |||||||||||
| 01a0a673-873e-7892-91fd-a0b1eae39b46 | XLU | 2026-09-15 15:03 | synthetic | 2 | 1 | 270 | 45090.00 | short | ask | 41.4551 | 0.2100 | ["42"] | ["0.1691"] | ["41.27"] | ["XBOX"] | 42.0000 | 42.0000 | 31 | 31 | false | false | |||||||||||
| 01a0a64e-4fe6-7202-8c30-ccd18a589d6e | XLU | 2026-09-15 14:22 | call_vertical_spread | 2 | 1 | 55 | 28600.00 | short | bid | 41.4700 | 0.7500 | ["38","42"] | ["0.2041","0.1437"] | ["40.40"] | ["MCRY"] | 38.0000 | 42.0000 | 122 | 122 | false | false | |||||||||||
| 01a0a17a-f6b1-7182-a5d6-a48ff02de947 | XLU | 2026-09-14 15:53 | call_vertical_spread | 2 | 1 | 72 | 52416.00 | short | bid | 41.7750 | 0.9500 | ["38","40"] | ["0.1435","0.1592"] | ["39.50"] | ["ARCO"] | 38.0000 | 40.0000 | 123 | 123 | false | false | |||||||||||
| 01a09131-d5d0-7673-8a36-32f51da85569 | XLU | 2026-09-11 11:59 | call_vertical_spread | 2 | 1 | 115 | 62750.00 | short | bid | 42.5701 | 0.4700 | ["40","42"] | ["0.0910","0.1635"] | ["40.95"] | ["MCRY"] | 40.0000 | 42.0000 | 126 | 126 | false | false | |||||||||||
| 01a08780-1998-7dc1-bd4e-acbe7f8600b2 | XLU | 2026-09-09 14:48 | call_diagonal_spread | 2 | 1 | 62 | 88474.00 | short | ask | 43.0350 | 1.3500 | ["35","37"] | ["0.8483","0.4202"] | [] | ["XMIO"] | 35.0000 | 37.0000 | 9 | 23 | false | false |
| false |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T14:56:17Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T13:33:24Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| false |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T19:10:47Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T19:07:27Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:42:04Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:26:06Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T15:17:22Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T20:09:07Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:08:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:07:53Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:07:17Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:43:47Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T20:11:48Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:09:35Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:01:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:52:58Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:52:50Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:57:26Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| true |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:12:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:47:21Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| true |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:14:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:16:02Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:23:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:32:20Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:04:00Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:22:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:53:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:59:56Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:48:48Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |