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 | 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 |
|---|
| 01a0ca54-e9ef-7b21-8650-6f67107d916a | SMH | 2026-09-22 14:15 | call_backspread | 2 | 4 | 600 | 419742.00 | long | bid | 605.1200 | 1.5797 | ["710","800"] | ["0.3497","0.3555"] | ["712.25","843.88"] | ["ARCO","SPHR","XBOX","XPHO"] | 710.0000 | 800.0000 | 87 | 87 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:16:25Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c564-d08f-7a22-b18b-f8b0a0680ff5 | SMH | 2026-09-21 15:15 | call_backspread | 2 | 1 | 68 | 69190.00 | long | bid | 596.4800 | 0.3500 | ["625","650"] | ["0.3334","0.3339"] | ["625.55","674.45"] | ["XCBO"] | 625.0000 | 650.0000 | 25 | 25 | false | true | false | ||||||||||
| 01a0c48f-8ece-7350-9986-7e0423f08b82 | SMH | 2026-09-21 11:22 | call_backspread | 2 | 1 | 10 | 89128.00 | long | bid | 590.2000 | 7.0500 | ["625","800"] | ["0.3656","0.3501"] | ["637.82","962.18"] | ["XISX"] | 625.0000 | 800.0000 | 452 | 452 | false | true | false | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | |||||||||||
| 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 | ||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:15:28Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:22:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |