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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e1-7767-7de1-a095-e5fb7525a24f | SMH | 2026-09-18 14:57 | put_diagonal_spread | 2 | 1 | 2 | 28038.00 | long | ask | 565.1900 | 5.3500 | ["630","635"] | ["0.3457","0.3495"] | [] | ["XCBO"] | 630.0000 | 635.0000 | 28 | 42 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:57:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53e-a7b7-7741-abae-a6209457abe2 | SMH | 2026-09-18 11:59 | put_diagonal_spread | 2 | 1 | 22 | 784388.00 | long | ask | 564.2632 | 4.7000 | ["580","900"] | ["0.2469","0.4802"] | [] | ["XCBO"] | 580.0000 | 900.0000 | 7 | 819 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:59:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b012-0a6b-7b71-adcf-2d352b9e918a | SMH | 2026-09-17 11:52 | put_diagonal_spread | 2 | 1 | 4 | 25180.00 | unknown | — | 559.7100 | 2.6000 | ["580","582.5"] | ["0.3209","0.3084"] | [] | ["XCBO"] | 580.0000 | 582.5000 | 22 | 36 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:53:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab6d-424b-7a71-a232-0cdbc911e351 | SMH | 2026-09-16 14:14 | put_diagonal_spread | 2 | 1 | 146 | 161330.00 | long | ask | 550.7600 | 0.9000 | ["542.5","545"] | ["0.3278","0.3820"] | [] | ["XISX"] | 542.5000 | 545.0000 | 2 | 9 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:14:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a68e-a88e-7053-8a80-83dca318fba0 | SMH | 2026-09-15 15:32 | put_diagonal_spread | 2 | 1 | 5 | 36060.00 | unknown | — | 541.7900 | 3.1000 | ["575","577.5"] | ["0.3154","0.5891"] | [] | ["XCBO"] | 575.0000 | 577.5000 | 1 | 17 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:33:08Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60a-8c3e-7b20-a345-1cb2cdeab165 | SMH | 2026-09-15 13:08 | put_diagonal_spread | 2 | 1 | 40 | 637000.00 | unknown | — | 540.6600 | 6.4500 | ["615","620"] | ["0.3454","0.3486"] | [] | ["XCBO"] | 615.0000 | 620.0000 | 31 | 66 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:08:37Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5db-7975-7403-9d33-b304beccd0db | SMH | 2026-09-15 12:16 | put_diagonal_spread | 2 | 1 | 20 | 55137.00 | long | ask | 541.1900 | 1.4000 | ["530","550"] | ["0.3377","0.3722"] | [] | ["XCBO"] | 530.0000 | 550.0000 | 3 | 31 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:17:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c7-3af9-7253-bb5b-4468cdc0bd22 | SMH | 2026-09-14 12:36 | put_diagonal_spread | 2 | 1 | 5 | 29895.00 | short | bid | 543.3300 | 5.0000 | ["572.5","575"] | ["1.8836","0.7634"] | [] | ["XCBO"] | 572.5000 | 575.0000 | 0 | 1 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:36:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b9-d160-7283-bbc7-930a03635c64 | SMH | 2026-09-14 12:22 | put_diagonal_spread | 2 | 1 | 4 | 27333.00 | long | ask | 543.9750 | 2.9000 | ["540","550"] | ["0.3592","0.3514"] | [] | ["XCBO"] | 540.0000 | 550.0000 | 67 | 95 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:22:37Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091c7-18c0-7001-9415-712da354d6b1 | SMH | 2026-09-11 14:42 | put_diagonal_spread | 2 | 1 | 5 | 236065.00 | short | ask | 571.6400 | 7.3500 | ["795","800"] | ["0.3934","0.3953"] | [] | ["XMIO"] | 795.0000 | 800.0000 | 462 | 497 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:42:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cde-3af0-7b90-ad93-d33e296e6512 | SMH | 2026-09-10 15:49 | put_diagonal_spread | 2 | 1 | 12 | 44052.00 | short | bid | 562.0000 | 1.3000 | ["575","580"] | ["0.3328","0.3690"] | [] | ["XMIO"] | 575.0000 | 580.0000 | 1 | 8 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:49:33Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0868a-b548-7180-b6c3-fdb7666f2615 | SMH | 2026-09-09 10:20 | put_diagonal_spread | 2 | 1 | 60 | 81480.00 | short | bid | 575.2900 | 0.8600 | ["540","560"] | ["0.4053","0.3720"] | [] | ["XMIO"] | 540.0000 | 560.0000 | 9 | 16 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:20:45Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08222-2ef0-7e81-b1a2-ea5a832b8b77 | SMH | 2026-09-08 13:47 | put_diagonal_spread | 2 | 1 | 9 | 54324.00 | long | ask | 575.6000 | 3.8500 | ["580","592.5"] | ["0.3658","0.3594"] | [] | ["XCBO"] | 580.0000 | 592.5000 | 24 | 45 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:48:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e6-9909-74a2-b9da-360a3c66829a | SMH | 2026-09-08 12:42 | put_diagonal_spread | 2 | 1 | 10 | 27070.00 | long | ask | 574.9150 | 0.6500 | ["530","560"] | ["0.3973","0.3811"] | [] | ["XMIO"] | 530.0000 | 560.0000 | 10 | 73 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:43:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081e0-5778-76f0-83e9-2cec68666075 | SMH | 2026-09-08 12:35 | put_diagonal_spread | 2 | 1 | 20 | 40940.00 | unknown | — | 575.2550 | 0.7500 | ["540","560"] | ["0.3828","0.3837"] | [] | ["XMIO"] | 540.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:36:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081de-4ff1-7ac1-8919-96a99daed948 | SMH | 2026-09-08 12:33 | put_diagonal_spread | 2 | 1 | 20 | 40780.00 | long | ask | 575.1000 | 0.4000 | ["540","560"] | ["0.3807","0.3825"] | [] | ["XMIO"] | 540.0000 | 560.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:33:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d4-12d8-7da0-85f5-a4b163b2f861 | SMH | 2026-09-08 12:22 | put_diagonal_spread | 2 | 1 | 20 | 43260.00 | long | ask | 576.5700 | 1.1500 | ["550","555"] | ["0.3786","0.3962"] | [] | ["XMIO"] | 550.0000 | 555.0000 | 10 | 38 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:22:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |