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 |
|---|
| 01a0a670-1086-7f40-a335-5bae1a2be84b | XLI | 2026-09-15 14:59 | straddle | 2 | 1 | 270 | 205740.00 | long | ask | 169.1500 | 0.4500 | ["169"] | ["0.1936"] | ["161.38","176.62"] | ["EDGO"] | 169.0000 | 169.0000 | 31 | 31 | true | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:59:15Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a64a-e0fe-78c3-9338-efa724cefad9 | XLI | 2026-09-15 14:18 | other | 3 | 1 | 180 | 91000.00 | unknown | — | 169.3600 | 0.6400 | ["180","185"] | ["0.3715","0.4107"] | [] | ["SPHR"] | 180.0000 | 185.0000 | 3 | 3 | false | false | false | true | true | ||||||||
| 01a0a16b-bc40-7a41-b80d-4c39008b4fdc | XLI | 2026-09-14 15:36 | other | 2 | 1 | 300 | 27750.00 | unknown | — | 169.9750 | 0.1800 | ["167","169"] | ["0.2135","0.2011"] | [] | ["EDGO"] | 167.0000 | 169.0000 | 4 | 4 | false | true | false | true | false | ||||||||
| 01a0a0a0-03e9-70e3-82b4-181ff7b2e424 | XLI | 2026-09-14 11:53 | put_diagonal_spread | 2 | 1 | 28 | 44884.00 | short | bid | 169.7200 | 1.0000 | ["175","177.5"] | ["0.2039","0.2810"] | [] | ["XCBO"] | 175.0000 | 177.5000 | 4 | 67 | false | false | true | ||||||||||
| 01a0a05c-57b0-71a1-a79d-197e625d64a4 | XLI | 2026-09-14 10:39 | other | 4 | 2 | 2000 | 810000.00 | unknown | — | 169.4000 | 1.1800 | ["160","165","170"] | ["0.2358","0.2385","0.2120"] | [] | ["AMXO"] | 160.0000 | 170.0000 | 4 | 18 | false | false | true | true | false | ||||||||
| 01a091ca-2218-7631-8e03-b5f6846d962b | XLI | 2026-09-11 14:45 | put_vertical_spread | 2 | 1 | 179 | 179179.00 | unknown | — | 172.5200 | 0.3100 | ["172.5","182.5"] | ["0.1957","2.5755"] | [] | ["XISX"] | 172.5000 | 182.5000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a091ca-2218-7631-8e03-b5e0ad7be175 | XLI | 2026-09-11 14:45 | put_vertical_spread | 2 | 1 | 71 | 71923.00 | unknown | — | 172.5200 | 0.3100 | ["172.5","182.5"] | ["0.2202","2.5755"] | [] | ["EDGO"] | 172.5000 | 182.5000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a08ca1-4d48-72c2-bc76-916369cf23c8 | XLI | 2026-09-10 14:42 | put_vertical_spread | 2 | 1 | 76 | 88920.00 | unknown | — | 170.1900 | 1.6000 | ["176","177"] | ["0.5798","0.6456"] | [] | ["XBOX"] | 176.0000 | 177.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a08ca1-31f0-72a3-93ff-927242ec78c4 | XLI | 2026-09-10 14:42 | other | 6 | 1 | 2124 | 5295000.00 | unknown | — | 170.1850 | 5.2000 | ["177","180","181","182","182.5","183"] | ["0.6433","0.8293","0.3396","0.3907","0.9389","0.3907"] | [] | ["XBOX"] | 177.0000 | 183.0000 | 1 | 8 | false | false | true | true | |||||||||
| 01a08c9d-6161-70a0-958b-e97e6b540eef | XLI | 2026-09-10 14:38 | put_vertical_spread | 2 | 1 | 20 | 55400.00 | unknown | — | 170.2200 | 1.9500 | ["182.5","185"] | ["0.9621","1.0999"] | [] | ["XBOX"] | 182.5000 | 185.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a08ba1-32c9-7133-aa0a-66ff712581f7 | XLI | 2026-09-10 10:03 | other | 3 | 1 | 45 | 70155.00 | unknown | — | 170.4800 | 1.9400 | ["162","164","165"] | ["0.2072","0.2064","0.2152"] | [] | ["XBOX"] | 162.0000 | 165.0000 | 71 | 71 | false | false | false | true | true | ||||||||
| 01a08792-1711-7ba2-80e7-ca866164951c | XLI | 2026-09-09 15:08 | strangle | 2 | 1 | 1400 | 2044000.00 | unknown | — | 172.0100 | 1.3000 | ["170","180"] | ["0.1968","0.1888"] | [] | ["ARCO"] | 170.0000 | 180.0000 | 191 | 191 | true | true | false | true | true | ||||||||
| 01a081f1-37c8-7341-abec-8c220c8c26fc | XLI | 2026-09-08 12:54 | put_frontspread | 2 | 2 | 372 | 312101.00 | long | ask | 175.1300 | 1.2000 | ["140","157"] | ["0.2553","0.2428"] | ["119.42","156.76"] | ["XCBO"] | 140.0000 | 157.0000 | 500 | 500 | true | true | false | ||||||||||
| 01a0813d-1a68-7512-82f9-57bfb3209b3b | XLI | 2026-09-08 09:37 | call_vertical_spread | 2 | 1 | 1400 | 257600.00 | unknown | — | 175.2800 | 0.9000 | ["185","190"] | ["0.1887","0.1904"] | [] | ["XBOX"] | 185.0000 | 190.0000 | 38 | 38 | true | true | false | true | false | ||||||||
| 01a06ddf-d065-71f1-9d2c-5a229ee84100 | XLI | 2026-09-04 15:22 | call_backspread | 2 | 1 | 3000 | 396000.00 | long | bid | 175.0100 | 0.3100 | ["177.5","180"] | ["0.1628","0.1661"] | ["182.54"] | ["XPHO"] | 177.5000 | 180.0000 | 14 | 14 | false | true | false | ||||||||||
| 01a06d36-cadd-75e0-971a-c41cc38d8b66 | XLI | 2026-09-04 12:18 | strangle | 2 | 1 | 1500 | 975000.00 | short | bid | 175.2700 | 0.6600 | ["174","178"] | ["0.1905","0.1614"] | ["167.50","184.50"] | ["SPHR"] | 174.0000 | 178.0000 | 42 | 42 | true | true | false |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:19:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:36:33Z"} |
| 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-14T15:53:57Z"} |
| 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-14T14:40:07Z"} |
| 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-11T18:46:06Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:46:06Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:43:02Z"} |
| 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-10T18:43:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:39:30Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:03:22Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:08:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mfsl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:54:31Z"} |
| 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-08T13:37:49Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:23:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:18:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |