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 |
|---|
| 01a090cf-08d9-7481-bd09-0c14829e49fd | XLE | 2026-09-11 10:11 | call_diagonal_spread | 2 | 1 | 90 | 47970.00 | unknown | — | 65.4400 | 1.1600 | ["65.5","66"] | ["0.2464","0.2500"] | [] | ["XCBO"] | 65.5000 | 66.0000 | 49 | 70 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:11:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a087ac-2ec0-77a3-9adb-0bbcebf5834c | XLE | 2026-09-09 15:36 | call_diagonal_spread | 2 | 1 | 14 | 34440.00 | long | bid | 65.4200 | 0.5500 | ["50","57.5"] | ["0.3286","0.2386"] | [] | ["XISX"] | 50.0000 | 57.5000 | 72 | 100 | false | false | true | true | |||||||||
| 01a08749-9c60-7790-b5b4-b3ee29f3260e | XLE | 2026-09-09 13:49 | call_diagonal_spread | 2 | 1 | 16 | 40848.00 | short | ask | 65.3750 | 1.0500 | ["50","57.5"] | ["0.3113","0.2100"] | [] | ["XCBO"] | 50.0000 | 57.5000 | 128 | 203 | false | false | true | true | |||||||||
| 01a08742-2251-7a92-96b6-c325722bf042 | XLE | 2026-09-09 13:40 | call_diagonal_spread | 2 | 1 | 14 | 35728.00 | unknown | — | 65.4100 | 1.0500 | ["50","57.5"] | ["0.3077","0.2074"] | [] | ["XMIO"] | 50.0000 | 57.5000 | 128 | 203 | false | false | true | true | false | mlet | |||||||
| 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 | |||||||||
| 01a086c3-6500-79a1-bad4-e83a1a45f5a2 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 28 | 36682.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4092","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | ||||||||||
| 01a086c3-6500-79a1-bad4-e817c65e8591 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 53 | 69437.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4064","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | ||||||||||
| 01a086c3-6500-79a1-bad4-e80f774108a1 | XLE | 2026-09-09 11:22 | call_diagonal_spread | 2 | 7 | 53 | 69433.00 | long | bid | 65.2750 | 0.2500 | ["57.5","62.5"] | ["0.4058","0.2449"] | [] | ["AMXO","ARCO","EMLD","XBOX","XISX","XMIO","XPHO"] | 57.5000 | 62.5000 | 9 | 100 | false | false | true | ||||||||||
| 01a08682-1e10-76e0-89b8-6c9529c4eecc | XLE | 2026-09-09 10:11 | call_diagonal_spread | 2 | 1 | 12 | 31224.00 | long | bid | 65.4050 | 0.8500 | ["51","55"] | ["0.9607","0.2249"] | [] | ["XMIO"] | 51.0000 | 55.0000 | 9 | 128 | false | false | true | true | |||||||||
| 01a08239-0e68-7130-ad7a-4c942aabcd51 | XLE | 2026-09-08 14:12 | call_diagonal_spread | 2 | 1 | 30 | 30090.00 | short | ask | 64.7200 | 0.3500 | ["62.5","67.5"] | ["0.2287","0.2267"] | [] | ["XCBO"] | 62.5000 | 67.5000 | 129 | 282 | false | false | true | true | |||||||||
| 01a0815f-92a1-7722-ba0c-17151c4cdc62 | XLE | 2026-09-08 10:15 | call_diagonal_spread | 2 | 1 | 40 | 86040.00 | unknown | — | 65.1600 | 1.4500 | ["55","57"] | ["0.1656","0.1857"] | [] | ["XMIO"] | 55.0000 | 57.0000 | 192 | 204 | false | false | true | true | false | mlet |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:36:42Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:50:02Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:41:16Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:22:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:11:15Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:13:09Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:15:28Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |