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 | 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 |
|---|
| 01a0f3ca-4577-7493-bf57-ec74a808158e | XLU | 2026-09-30 15:28 | call_diagonal_spread | 2 | 1 | 413 | 33866.00 | long | ask | 39.5900 | 0.0400 | ["40.5","41"] | ["0.2050","0.2061"] | [] | ["C2OX"] | 40.5000 | 41.0000 | 16 | 30 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-30T19:28:43Z"} | 2026-09-30 | 2026-09-30 17:15 | 2026-09-30 17:15 |
| 01a0f37f-51f7-7020-a6c9-c16ebc3deaed | XLU | 2026-09-30 14:06 | call_vertical_spread | 2 | 1 | 164 | 92988.00 | long | ask | 39.6300 | 0.2200 | ["40","45"] | ["0.1478","0.1606"] | ["41.91"] | ["SPHR"] | 40.0000 | 45.0000 | 478 | 478 | false | true | false | ||||||||||
| 01a0f37f-4e0f-7923-98d7-1412845791fa | XLU | 2026-09-30 14:06 | call_vertical_spread | 2 | 3 | 136 | 77136.00 | long | ask | 39.6300 | 0.2200 | ["40","45"] | ["0.1479","0.1606"] | ["41.91"] | ["EMLD","SPHR","XPHO"] | 40.0000 | 45.0000 | 478 | 478 | false | true | false | ||||||||||
| 01a0ee80-e0b7-7e83-b61e-8a78a218f4a2 | XLU | 2026-09-29 14:50 | call_ratio_spread | 2 | 2 | 708 | 29736.00 | long | ask | 39.6124 | 0.0600 | ["40.5","42"] | ["0.1877","0.1912"] | ["40.75","44.50"] | ["AMXO"] | 40.5000 | 42.0000 | 24 | 24 | false | true | false | ||||||||||
| 01a0ee80-e0b7-7e83-b61e-8a585a69374f | XLU | 2026-09-29 14:50 | call_ratio_spread | 2 | 2 | 708 | 29736.00 | long | ask | 39.6124 | 0.0600 | ["40.5","42"] | ["0.1877","0.1912"] | ["40.75","44.50"] | ["AMXO"] | 40.5000 | 42.0000 | 24 | 24 | false | true | false | ||||||||||
| 01a0ee7f-fa3f-78f3-9c7a-f5a5e4dc2988 | XLU | 2026-09-29 14:49 | call_ratio_spread | 2 | 2 | 891 | 36234.00 | long | ask | 39.6299 | 0.0700 | ["40.5","42"] | ["0.1834","0.1871"] | ["40.75","44.50"] | ["AMXO","XISX"] | 40.5000 | 42.0000 | 24 | 24 | false | true | false | ||||||||||
| 01a0ee0d-624e-7520-bd93-246c1ef50176 | XLU | 2026-09-29 12:44 | call_diagonal_spread | 2 | 1 | 37 | 29674.00 | long | ask | 39.3800 | 0.6500 | ["40","40.5"] | ["0.1128","0.1382"] | [] | ["BATO"] | 40.0000 | 40.5000 | 479 | 843 | false | true | true | true | |||||||||
| 01a0e958-0417-7e82-9fef-4391a6ca096b | XLU | 2026-09-28 14:47 | call_vertical_spread | 2 | 2 | 520 | 29120.00 | long | ask | 39.3500 | 0.0250 | ["40","42"] | ["0.2064","0.2156"] | ["40.39"] | ["AMXO","XPHO"] | 40.0000 | 42.0000 | 18 | 18 | false | true | false | ||||||||||
| 01a0e92f-cb36-7b90-bcf0-28c3ee40ba9b | XLU | 2026-09-28 14:03 | put_calendar | 2 | 1 | 150 | 63900.00 | long | bid | 39.3500 | 0.2800 | ["41"] | ["0.2179"] | [] | ["XCBO"] | 41.0000 | 41.0000 | 18 | 109 | false | false | true | false | |||||||||
| 01a0e877-3937-7b93-a43e-798ad1f49473 | XLU | 2026-09-28 10:41 | call_diagonal_spread | 2 | 1 | 60 | 86520.00 | long | ask | 39.3250 | 1.1500 | ["32","34"] | ["0.1988","0.1077"] | [] | ["XCBO"] | 32.0000 | 34.0000 | 200 | 262 | false | false | true | true | |||||||||
| 01a0e83f-9707-75b1-b421-dbcf9cf55c9d | XLU | 2026-09-28 09:41 | call_vertical_spread | 2 | 1 | 300 | 35400.00 | long | ask | 39.2350 | 0.0800 | ["40","43"] | ["0.2004","0.2045"] | ["40.74"] | ["XCBO"] | 40.0000 | 43.0000 | 53 | 53 | false | true | false | ||||||||||
| 01a0e83f-5887-7920-8f58-ac8123ded60a | XLU | 2026-09-28 09:40 | call_vertical_spread | 2 | 1 | 252 | 29736.00 | long | ask | 39.2225 | 0.0800 | ["40","43"] | ["0.2013","0.2051"] | ["40.74"] | ["XCBO"] | 40.0000 | 43.0000 | 53 | 53 | false | true | false | ||||||||||
| 01a0da20-477f-7870-926d-0b472fb4fb6c | XLU | 2026-09-25 15:52 | call_ratio_spread | 2 | 1 | 2000 | 87000.00 | long | ask | 39.5750 | 0.0600 | ["40","42"] | ["0.2012","0.2094"] | ["40.35","43.65"] | ["XPHO"] | 40.0000 | 42.0000 | 21 | 21 | false | true | false | ||||||||||
| 01a0d9b0-b8e7-7073-9d60-9e264eb0d35d | XLU | 2026-09-25 13:50 | call_ratio_spread | 2 | 1 | 466 | 48697.00 | long | ask | 39.3350 | 0.0800 | ["39.5","45"] | ["0.1670","0.1809"] | ["40.67","49.33"] | ["EDGO"] | 39.5000 | 45.0000 | 112 | 112 | false | true | false | ||||||||||
| 01a0d500-f05f-7a62-a128-6f48352f770c | XLU | 2026-09-24 16:00 | call_diagonal_spread | 2 | 1 | 525 | 54075.00 | long | ask | 39.3600 | 0.1000 | ["40","42"] | ["0.1800","0.1965"] | [] | ["BATO"] | 40.0000 | 42.0000 | 22 | 57 | false | true | true | true | |||||||||
| 01a0ce8a-b017-70c2-af15-d1eb55d6d9da | XLU | 2026-09-23 09:53 | put_vertical_spread | 2 | 1 | 200 | 27600.00 | long | ask | 39.9150 | 0.2500 | ["39.5","40.5"] | ["0.1471","0.1525"] | ["39.98"] | ["XMIO"] | 39.5000 | 40.5000 | 30 | 30 | false | false | false | ||||||||||
| 01a0ce89-aa5e-7da3-a760-fa14791ab244 | XLU | 2026-09-23 09:52 | put_vertical_spread | 2 | 2 | 200 | 38400.00 | long | ask | 39.9600 | 0.2300 | ["40","41"] | ["0.1521","0.1577"] | ["40.38"] | ["C2OX"] | 40.0000 | 41.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0c54f-96f6-72c2-a542-e4f1389f6edc | XLU | 2026-09-21 14:51 | put_vertical_spread | 2 | 1 | 50 | 37638.00 | long | ask | 40.6950 | 0.4700 | ["40","45"] | ["0.2083","0.2279"] | ["42.22"] | ["XCBO"] | 40.0000 | 45.0000 | 487 | 487 | false | false | false | true | |||||||||
| 01a0c4c9-7ed6-7510-a004-c3d94aba86fb | XLU | 2026-09-21 12:25 | put_vertical_spread | 2 | 1 | 825 | 61863.00 | long | ask | 40.8450 | 0.1300 | ["37","40"] | ["0.1914","0.1685"] | ["39.49"] | ["EDGO"] | 37.0000 | 40.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0b5e9-a13f-7a23-bf02-bc961b21570f | XLU | 2026-09-18 15:06 | call_diagonal_spread | 2 | 1 | 54 | 50868.00 | long | ask | 41.2250 | 0.3500 | ["37","42"] | ["0.1917","0.1176"] | [] | ["XCBO"] | 37.0000 | 42.0000 | 119 | 819 | false | false | true | true | |||||||||
| 01a0b020-d77b-7b41-bd91-89a3a4f9e35d | XLU | 2026-09-17 12:08 | put_diagonal_spread | 2 | 2 | 294 | 49686.00 | long | bid | 41.6500 | 0.1600 | ["35","40"] | ["0.2155","0.1870"] | [] | ["ARCO"] | 35.0000 | 40.0000 | 120 | 491 | false | true | true | true | |||||||||
| 01a0afbe-9723-7dc0-a505-eff4d366c4c3 | XLU | 2026-09-17 10:21 | call_diagonal_spread | 2 | 2 | 43 | 51756.00 | long | ask | 41.4350 | 0.9209 | ["36","40"] | ["0.2359","0.1063"] | [] | ["BATO","MCRY"] | 36.0000 | 40.0000 | 92 | 855 | false | false | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T18:07:15Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T18:07:15Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:50:22Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:50:22Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T18:49:20Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:44:37Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:47:57Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:03:37Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:42:13Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:41:34Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T13:41:14Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T19:52:23Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:51:03Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T20:00:03Z"} |
| 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-23T13:53:13Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:52:03Z"} |
| 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-21T18:52:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:25:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:06:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:08:55Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:21:57Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |