core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 01a0cf56-a6ef-7b03-930a-23f93cabf4ba | SPCX | 2026-09-23 13:35 | put_butterfly_spread | 3 | 1 | 22 | 31229.00 | long | ask | 150.3100 | 0.3000 | ["142","147","150"] | ["0.4839","0.4816","0.4822"] | ["143.43"] | ["XCBO"] | 142.0000 | 150.0000 | 37 | 37 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T17:36:39Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0cab0-f086-77c0-8d89-8397f50d2cae | SPCX | 2026-09-22 15:56 | put_butterfly_spread | 3 | 1 | 8 | 25840.00 | long | ask | 154.6800 | 1.0000 | ["125","150","175"] | ["0.5399","0.5285","0.5322"] | ["130.80","169.20"] | ["XISX"] | 125.0000 | 175.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0b5ba-b96f-7082-852b-319110b906eb | SPCX | 2026-09-18 14:15 | put_butterfly_spread | 3 | 2 | 120 | 87960.00 | long | ask | 151.5500 | 0.1400 | ["70","110","150"] | ["0.8247","0.5816","0.5348"] | ["79.66","140.34"] | ["XISX"] | 70.0000 | 150.0000 | 63 | 63 | false | true | false | ||||||||||
| 01a0b5ba-a9cf-7440-adf9-6cdb6090bce1 | SPCX | 2026-09-18 14:15 | put_butterfly_spread | 3 | 1 | 120 | 87720.00 | long | ask | 151.5326 | 0.1900 | ["70","110","150"] | ["0.8271","0.5803","0.5335"] | ["79.66","140.34"] | ["ARCO"] | 70.0000 | 150.0000 | 63 | 63 | false | true | false | ||||||||||
| 01a0b5ba-a9cf-7440-adf9-6cca0352d100 | SPCX | 2026-09-18 14:15 | put_butterfly_spread | 3 | 1 | 120 | 87720.00 | long | ask | 151.5326 | 0.2100 | ["70","110","150"] | ["0.8271","0.5803","0.5335"] | ["79.66","140.34"] | ["XISX"] | 70.0000 | 150.0000 | 63 | 63 | false | true | false | ||||||||||
| 01a0b05a-94bb-75b1-95f5-c917a5951e75 | SPCX | 2026-09-17 13:11 | put_butterfly_spread | 3 | 1 | 20 | 25240.00 | long | ask | 154.9000 | 0.6000 | ["135","145","155"] | ["0.5170","0.5064","0.5051"] | ["136.60","153.40"] | ["BATO"] | 135.0000 | 155.0000 | 43 | 43 | false | false | false | ||||||||||
| 01a0b05a-7193-7d72-8a56-bda80ee090ea | SPCX | 2026-09-17 13:11 | put_butterfly_spread | 3 | 1 | 20 | 25240.00 | long | ask | 154.9250 | 0.6000 | ["135","145","155"] | ["0.5173","0.5068","0.5056"] | ["136.60","153.40"] | ["BATO"] | 135.0000 | 155.0000 | 43 | 43 | false | false | false | ||||||||||
| 01a0b058-a4a3-7ec3-8784-217669914ffe | SPCX | 2026-09-17 13:09 | put_butterfly_spread | 3 | 1 | 20 | 25320.00 | long | ask | 154.8150 | 0.6000 | ["135","145","155"] | ["0.5159","0.5061","0.5051"] | ["136.60","153.40"] | ["XCBO"] | 135.0000 | 155.0000 | 43 | 43 | false | false | false | ||||||||||
| 01a08bab-44e8-7361-b953-dd46d25ce141 | SPCX | 2026-09-10 10:14 | put_butterfly_spread | 3 | 4 | 18 | 58588.00 | long | ask | 149.6399 | 0.7000 | ["145","150","155"] | ["0.5613","0.5604","0.5615"] | ["146.36"] | ["ARCO","EMLD","SPHR","XBOX"] | 145.0000 | 155.0000 | 99 | 99 | false | false | false | ||||||||||
| 01a081a1-75d0-7063-bab1-1fbb1fbcd209 | SPCX | 2026-09-08 11:27 | put_butterfly_spread | 3 | 1 | 27 | 72882.00 | long | ask | 150.9800 | 0.7000 | ["140","145","150"] | ["0.5653","0.5644","0.5632"] | ["141.47"] | ["XCBO"] | 140.0000 | 150.0000 | 101 | 101 | false | true | false |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:56:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:15:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:15:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:15:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:12:19Z"} |
| 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-17T17:12:19Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:09: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-10T14:14:12Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:27:33Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |