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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d2e-cfe5-7f41-9f0b-4842c477972d | SNOW | 2026-09-04 12:09 | put_vertical_spread | 2 | 1 | 10 | 116360.00 | unknown | — | 345.9200 | 7.0000 | ["400","410"] | ["0.7125","0.7960"] | [] | ["MCRY"] | 400.0000 | 410.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:09:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06da6-6cfe-7ea3-b1f2-edb31f39eb00 | SNOW | 2026-09-04 14:20 | put_vertical_spread | 2 | 1 | 50 | 333200.00 | unknown | — | 341.1200 | 1.6000 | ["360","370"] | ["0.4233","0.4252"] | [] | ["XISX"] | 360.0000 | 370.0000 | 42 | 42 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:20:35Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06e00-3d2d-7401-9674-8a0755dd15ee | SNOW | 2026-09-04 15:58 | put_vertical_spread | 2 | 1 | 150 | 1525050.00 | short | bid | 338.5400 | 7.9000 | ["387.5","390"] | ["0.6444","0.6600"] | ["387.55"] | ["BATO"] | 387.5000 | 390.0000 | 7 | 7 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:58:25Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a081cb-7f88-7c43-b362-fb23ec355357 | SNOW | 2026-09-08 12:13 | put_vertical_spread | 2 | 1 | 4 | 133808.00 | long | ask | 334.7550 | 8.3500 | ["470","520"] | ["0.5497","0.5739"] | ["475.60"] | ["AMXO"] | 470.0000 | 520.0000 | 192 | 192 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:13:27Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d1-9a08-7cb2-9da1-f7b59e6bde25 | SNOW | 2026-09-08 12:19 | put_vertical_spread | 2 | 1 | 4 | 109960.00 | long | ask | 334.8400 | 4.4000 | ["430","490"] | ["0.5415","0.5603"] | ["439.74"] | ["AMXO"] | 430.0000 | 490.0000 | 192 | 192 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:19:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0874d-4db1-70e0-8c74-cd0440943f6b | SNOW | 2026-09-09 13:53 | put_vertical_spread | 2 | 1 | 250 | 213750.00 | long | ask | 332.9300 | 0.7400 | ["325","335"] | ["0.5353","0.5416"] | ["330.75"] | ["ARCO"] | 325.0000 | 335.0000 | 2 | 2 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:53:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08792-6d01-7dd0-b1e3-d8e8308087e0 | SNOW | 2026-09-09 15:08 | put_vertical_spread | 2 | 1 | 8 | 122080.00 | short | bid | 333.2900 | 4.9500 | ["380","410"] | ["0.5454","0.5477"] | ["387.40"] | ["XPHO"] | 380.0000 | 410.0000 | 100 | 100 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:08:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08b84-92a8-7b12-abef-5c7ca84caff9 | SNOW | 2026-09-10 09:31 | put_vertical_spread | 2 | 1 | 30 | 160200.00 | unknown | — | 327.9700 | 7.5000 | ["350","355"] | ["0.5101","0.5203"] | [] | ["XMIO"] | 350.0000 | 355.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:31:59Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b85-8ca9-7f30-91d5-c25bcc6a94df | SNOW | 2026-09-10 09:32 | put_vertical_spread | 2 | 1 | 25 | 102350.00 | long | ask | 325.3400 | 2.3500 | ["300","350"] | ["0.4672","0.4529"] | ["325"] | ["XISX"] | 300.0000 | 350.0000 | 36 | 36 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:33:00Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a09129-2728-7053-9ecd-6685e740ce7c | SNOW | 2026-09-11 11:49 | put_vertical_spread | 2 | 2 | 28 | 359632.00 | short | bid | 329.3900 | 4.4500 | ["300","400"] | ["0.5671","0.5661"] | ["340.24"] | ["ARCO","XPHO"] | 300.0000 | 400.0000 | 189 | 189 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:50:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0aac5-7d13-7ba2-b659-0768cc3aaa49 | SNOW | 2026-09-16 11:11 | put_vertical_spread | 2 | 1 | 16 | 365984.00 | long | ask | 337.6150 | 9.7500 | ["390","470"] | ["0.5838","0.6057"] | ["408.18"] | ["XISX"] | 390.0000 | 470.0000 | 184 | 184 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:11:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab85-69e3-7a81-8a72-c72ea134d3ef | SNOW | 2026-09-16 14:40 | put_vertical_spread | 2 | 1 | 10 | 107540.00 | short | bid | 333.8600 | 13.7500 | ["380","390"] | ["0.4706","0.4746"] | ["381.30"] | ["XMIO"] | 380.0000 | 390.0000 | 30 | 30 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:40:58Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afad-264b-7d43-94e4-42caae10f162 | SNOW | 2026-09-17 10:02 | put_vertical_spread | 2 | 1 | 10 | 145170.00 | long | ask | 340.9600 | 10.1500 | ["350","420"] | ["0.5384","0.5428"] | ["373.03"] | ["ARCO"] | 350.0000 | 420.0000 | 155 | 155 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:02:41Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |