core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 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 |
|---|
| 01a0c9a4-4eff-7803-976f-317ef064ae92 | SPX | 2026-09-22 11:03 | put_calendar | 2 | 1 | 9 | 33210.00 | short | ask | 7766.4600 | 0.4000 | ["7700"] | ["0.1152"] | [] | ["XCBO"] | 7700.0000 | 7700.0000 | 3 | 10 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:03:20Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0afab-d273-7dc3-96f6-664371be990d | SPX | 2026-09-17 10:01 | put_calendar | 2 | 1 | 4 | 25480.00 | long | bid | 7618.4400 | 0.2000 | ["7640"] | ["0.1645"] | [] | ["XCBO"] | 7640.0000 | 7640.0000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0af8f-78a4-7712-ad9a-f48d8303e6b1 | SPX | 2026-09-17 09:30 | put_calendar | 2 | 1 | 11 | 71090.00 | short | bid | 7644.0800 | 4.8636 | ["7650"] | ["0.1393"] | [] | ["XCBO"] | 7650.0000 | 7650.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0ab95-8eb3-7403-97ea-873476dcafb0 | SPX | 2026-09-16 14:58 | put_calendar | 2 | 1 | 5 | 25400.00 | short | ask | 7554.4700 | 0.3600 | ["7555"] | ["0.3592"] | [] | ["XCBO"] | 7555.0000 | 7555.0000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0a695-95fe-7d53-8114-e36b6059927a | SPX | 2026-09-15 15:40 | put_calendar | 2 | 2 | 6 | 29700.00 | short | ask | 7577.4900 | 0.3000 | ["7490"] | ["0.1844"] | [] | ["XCBO"] | 7490.0000 | 7490.0000 | 3 | 6 | false | true | true | false | |||||||||
| 01a0a628-553d-7152-8fc3-da705df6c823 | SPX | 2026-09-15 13:40 | put_calendar | 2 | 1 | 5 | 56150.00 | short | bid | 7583.8200 | 1.0000 | ["7635"] | ["0.1936"] | [] | ["XCBO"] | 7635.0000 | 7635.0000 | 0 | 1 | false | false | true | false | |||||||||
| 01a0a5b2-88fd-70a3-91c2-d3999782801e | SPX | 2026-09-15 11:32 | put_calendar | 2 | 1 | 2 | 57380.00 | short | bid | 7583.3000 | 3.2000 | ["7725"] | ["0.2301"] | [] | ["XCBO"] | 7725.0000 | 7725.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a0a09a-9160-77b1-a422-d7994105c8ee | SPX | 2026-09-14 11:47 | put_calendar | 2 | 1 | 2 | 48500.00 | short | ask | 7630.4700 | 4.9000 | ["7750"] | ["0.1738"] | [] | ["XCBO"] | 7750.0000 | 7750.0000 | 1 | 2 | false | false | true | false | |||||||||
| 01a08c00-0c08-7881-a279-49376594c954 | SPX | 2026-09-10 11:46 | put_calendar | 2 | 1 | 2 | 58600.00 | short | ask | 7602.8800 | 6.6000 | ["7750"] | ["0.2719"] | [] | ["XCBO"] | 7750.0000 | 7750.0000 | 0 | 4 | false | false | true | false | |||||||||
| 01a0866f-74b8-72b3-af5f-a43db6563cf2 | SPX | 2026-09-09 09:50 | put_calendar | 2 | 1 | 5 | 82000.00 | short | bid | 7650.5700 | 5.1000 | ["7725"] | ["0.1234"] | [] | ["XCBO"] | 7725.0000 | 7725.0000 | 2 | 5 | false | false | true | false | |||||||||
| 01a0817b-9e50-7753-97e3-d70d167be2f5 | SPX | 2026-09-08 10:45 | put_calendar | 2 | 1 | 5 | 81900.00 | short | ask | 7684.8800 | 0.8000 | ["7720"] | ["0.1215"] | [] | ["XCBO"] | 7720.0000 | 7720.0000 | 10 | 15 | false | false | true | false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:01:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:30:04Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:58:36Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:40:27Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:40:58Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:32:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:48:09Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:46:46Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:50:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:45:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |