core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0b4d6-f4d7-7770-87a2-07cd0dca1f5e | XLE | 2026-09-18 10:06 | call_calendar | 2 | 1 | 500 | 72500.00 | short | ask | 64.3500 | 0.0200 | ["65"] | ["0.2592"] | [] | ["AMXO"] | 65.0000 | 65.0000 | 0 | 28 | false | true | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:06:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a672-cfa5-7703-8277-6095f8b5850f | XLE | 2026-09-15 15:02 | straddle | 2 | 1 | 310 | 131440.00 | long | ask | 65.8170 | 0.0700 | ["66"] | ["0.2772"] | ["61.76","70.24"] | ["XBOX"] | 66.0000 | 66.0000 | 31 | 31 | false | false | false | false | |||||||||
| 01a0a0e8-3460-7513-8df2-a1800b4f6006 | XLE | 2026-09-14 13:12 | put_vertical_spread | 2 | 1 | 3752 | 228872.00 | long | ask | 64.6450 | 0.0300 | ["60","62"] | ["0.3327","0.3221"] | ["61.71"] | ["AMXO"] | 60.0000 | 62.0000 | 11 | 11 | false | true | false | true | |||||||||
| 01a090f2-ec58-7331-b458-f301fecb700e | XLE | 2026-09-11 10:50 | call_diagonal_spread | 2 | 1 | 200 | 300000.00 | short | ask | 64.8197 | 1.0000 | ["55","65"] | ["0.6783","0.2294"] | [] | ["SPHR"] | 55.0000 | 65.0000 | 7 | 201 | false | false | true | true | |||||||||
| 01a086e1-35d0-78e2-a1ee-98097dfbf186 | XLE | 2026-09-09 11:54 | call_diagonal_spread | 2 | 1 | 88 | 85800.00 | short | ask | 65.2397 | 0.3500 | ["60","65"] | ["0.2720","0.2388"] | [] | ["SPHR"] | 60.0000 | 65.0000 | 21 | 128 | false | false | true | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:02:59Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:13:38Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:50:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:55:31Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |