Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b619-2167-7b90-8c07-243cbdfdb9fd | SMH | 2026-09-18 15:58 | call_backspread | 2 | 2 | 30 | 45480.00 | long | bid | 572.3300 | 1.4000 | ["560","575"] | ["0.2681","0.2556"] | ["562.20","587.80"] | ["XCBO","XPHO"] | 560.0000 | 575.0000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:58:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab3e-142b-7b00-b9d5-b50a43b82070 | SMH | 2026-09-16 13:22 | call_backspread | 2 | 1 | 42 | 26754.00 | long | bid | 549.5900 | 1.0800 | ["560","575"] | ["0.3246","0.3167"] | ["561.30","588.70"] | ["XCBO"] | 560.0000 | 575.0000 | 9 | 9 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:23:13Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a166-c6b8-75b0-b1de-9ee41dec7aef | SMH | 2026-09-14 15:30 | call_backspread | 2 | 2 | 50 | 36956.00 | long | bid | 543.7100 | 1.3500 | ["540","560"] | ["0.3666","0.3464"] | ["545.42","573.46"] | ["AMXO","XMIO"] | 540.0000 | 560.0000 | 4 | 4 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:31:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08788-b4b8-7100-b000-c3168ab3c5bc | SMH | 2026-09-09 14:57 | call_backspread | 2 | 10 | 64 | 76824.00 | long | bid | 573.0000 | 0.8875 | ["565","600"] | ["0.3590","0.3313"] | ["576","624.00"] | ["AMXO","ARCO","BATO","C2OX","EDGO","EMLD","XCBO","XISX","XMIO","XPHO"] | 565.0000 | 600.0000 | 9 | 9 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:58:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08785-16f0-7b32-8b8b-5ed7cb8e22dd | SMH | 2026-09-09 14:53 | call_backspread | 2 | 2 | 38 | 47063.00 | unknown | — | 573.5360 | 1.6868 | ["565","600"] | ["0.3600","0.3348"] | [] | ["XCBO","XISX"] | 565.0000 | 600.0000 | 9 | 9 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:54:38Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08213-a830-7af2-8fd1-f661d9f412d9 | SMH | 2026-09-08 13:31 | call_backspread | 2 | 2 | 40 | 63820.00 | long | bid | 576.0675 | 1.0000 | ["600","640"] | ["0.3593","0.3534"] | ["603.53","676.47"] | ["EDGO","XCBO"] | 600.0000 | 640.0000 | 38 | 38 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:32:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08213-a830-7af2-8fd1-f652471f3ee5 | SMH | 2026-09-08 13:31 | call_backspread | 2 | 2 | 48 | 76800.00 | long | bid | 576.0675 | 1.0500 | ["600","640"] | ["0.3602","0.3537"] | ["603.56","676.44"] | ["XISX","XPHO"] | 600.0000 | 640.0000 | 38 | 38 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:32:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08205-a640-78b0-acbc-b4df301c001a | SMH | 2026-09-08 13:16 | call_backspread | 2 | 1 | 30 | 48465.00 | long | bid | 576.7400 | 1.1500 | ["600","640"] | ["0.3574","0.3534"] | ["603.39","676.61"] | ["XCBO"] | 600.0000 | 640.0000 | 38 | 38 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:17:11Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081bd-0868-7473-964a-bc486eb92ddf | SMH | 2026-09-08 11:57 | call_backspread | 2 | 1 | 40 | 88580.00 | long | bid | 577.5900 | 4.0500 | ["805","860"] | ["0.3590","0.3585"] | ["921.83"] | ["XPHO"] | 805.0000 | 860.0000 | 282 | 282 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:57:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08158-dfc8-73c3-8e17-9f4c0cd01e42 | SMH | 2026-09-08 10:07 | call_backspread | 2 | 1 | 30 | 42855.00 | long | bid | 572.6300 | 1.7500 | ["600","640"] | ["0.3540","0.3506"] | ["603.45","676.55"] | ["XISX"] | 600.0000 | 640.0000 | 38 | 38 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:08:00Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd0-c4d6-7870-936e-71ef04240680 | SMH | 2026-09-04 15:06 | call_backspread | 2 | 6 | 86 | 49798.00 | long | bid | 564.2100 | 0.4400 | ["575","625"] | ["0.3147","0.3317"] | ["582.58","667.42"] | ["AMXO","EMLD","XBOX","XCBO","XMIO","XPHO"] | 575.0000 | 625.0000 | 14 | 14 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:06:36Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d22-b255-7dc2-868b-ecdd2cc08a59 | SMH | 2026-09-04 11:56 | call_backspread | 2 | 1 | 270 | 750690.00 | long | bid | 564.8641 | 1.6000 | ["560","610"] | ["0.3196","0.3113"] | ["574.56","680.89"] | ["XPHO"] | 560.0000 | 610.0000 | 42 | 42 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T15:56:29Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |