Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c56e-9876-7f30-a740-b5f28aa0566f | MRVL | 2026-09-21 15:25 | put_diagonal_spread | 2 | 1 | 4 | 84504.00 | long | ask | 259.3900 | 3.3500 | ["260","440"] | ["0.6930","0.8351"] | [] | ["XCBO"] | 260.0000 | 440.0000 | 60 | 88 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:26:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55a-7fee-7992-817d-aefb64e7e57c | MRVL | 2026-09-21 15:03 | put_diagonal_spread | 2 | 1 | 218 | 1510304.00 | short | bid | 259.1000 | 0.7500 | ["275","300"] | ["0.6947","0.7383"] | [] | ["XMIO"] | 275.0000 | 300.0000 | 11 | 25 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:04:10Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c556-2a8f-7ca0-abed-37f51971bd5c | MRVL | 2026-09-21 14:59 | put_diagonal_spread | 2 | 1 | 376 | 2603800.00 | short | bid | 258.9650 | 0.8500 | ["275","300"] | ["0.6898","0.7319"] | [] | ["XISX"] | 275.0000 | 300.0000 | 11 | 25 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:59:21Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c525-568f-75e3-8221-ca8b6f6312d3 | MRVL | 2026-09-21 14:05 | put_diagonal_spread | 2 | 1 | 69 | 718842.00 | long | ask | 258.0400 | 0.9500 | ["260","300"] | ["0.7063","0.6896"] | [] | ["XMIO"] | 260.0000 | 300.0000 | 88 | 151 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:06:02Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c485-2e8f-7931-b6b4-be73204d8949 | MRVL | 2026-09-21 11:10 | put_diagonal_spread | 2 | 1 | 11 | 60337.00 | unknown | — | 253.5050 | 1.4500 | ["265","300"] | ["0.6919","0.7378"] | [] | ["AMXO"] | 265.0000 | 300.0000 | 25 | 32 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:11:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c442-033f-7112-a1d9-445949ee1f8c | MRVL | 2026-09-21 09:57 | put_diagonal_spread | 2 | 1 | 11 | 57321.00 | unknown | ask | 249.2500 | 1.4500 | ["260","275"] | ["0.6744","0.7064"] | [] | ["AMXO"] | 260.0000 | 275.0000 | 11 | 25 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:57:37Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b084-9e73-72a0-a44a-9a5504ee793e | MRVL | 2026-09-17 13:57 | put_diagonal_spread | 2 | 1 | 8 | 35896.00 | short | ask | 241.7900 | 0.8000 | ["250","262.5"] | ["0.6554","0.6187"] | [] | ["XCBO"] | 250.0000 | 262.5000 | 8 | 29 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:58:43Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b01f-701b-7430-879f-7c717c98277f | MRVL | 2026-09-17 12:07 | put_diagonal_spread | 2 | 1 | 15 | 68175.00 | unknown | — | 241.8800 | 1.6500 | ["230","240"] | ["0.6571","0.6771"] | [] | ["XCBO"] | 230.0000 | 240.0000 | 43 | 92 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:07:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b009-4453-7001-8712-c398bd55494a | MRVL | 2026-09-17 11:43 | put_diagonal_spread | 2 | 1 | 13 | 29900.00 | unknown | — | 240.8100 | 0.4000 | ["240","245"] | ["0.6379","0.6354"] | [] | ["XCBO"] | 240.0000 | 245.0000 | 8 | 15 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:43:20Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af91-16b4-7d52-9da2-1cb0d90c5c16 | MRVL | 2026-09-17 09:31 | put_diagonal_spread | 2 | 2 | 5 | 31501.00 | long | ask | 243.6700 | 3.5000 | ["250","260"] | ["0.6737","0.6886"] | [] | ["MCRY","XMIO"] | 250.0000 | 260.0000 | 29 | 92 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:32:01Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0a047-8790-7700-aef1-184cbadc232e | MRVL | 2026-09-14 10:17 | put_diagonal_spread | 2 | 1 | 6 | 51450.00 | short | bid | 222.3400 | 1.8000 | ["260","265"] | ["0.6831","0.7863"] | [] | ["XMIO"] | 260.0000 | 265.0000 | 4 | 32 | false | false | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:17:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cb8-2108-7d62-aca9-6f30390f7e96 | MRVL | 2026-09-10 15:07 | put_diagonal_spread | 2 | 1 | 10 | 33284.00 | short | bid | 230.6750 | 1.0500 | ["220","230"] | ["0.6701","0.6457"] | [] | ["XCBO"] | 220.0000 | 230.0000 | 8 | 99 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:07:57Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0824c-6b70-75a2-bf31-a85f02f91668 | MRVL | 2026-09-08 14:33 | put_diagonal_spread | 2 | 1 | 5 | 28940.00 | short | bid | 228.7000 | 1.4500 | ["175","180"] | ["0.6785","0.6718"] | [] | ["XCBO"] | 175.0000 | 180.0000 | 282 | 500 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:34:03Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |