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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a09126-e508-77c3-ab47-1a35fa78a4cf | LITE | 2026-09-11 11:47 | put_diagonal_spread | 2 | 2 | 48 | 554136.00 | long | ask | 941.9695 | 4.3000 | ["960","970"] | ["0.7240","0.7168"] | [] | ["EDGO","XISX"] | 960.0000 | 970.0000 | 7 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:47:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a020-e4f0-7a92-a1f3-b5c5b1d664ee | LITE | 2026-09-14 09:35 | put_diagonal_spread | 2 | 1 | 22 | 235290.00 | unknown | — | 855.4300 | 8.9000 | ["840","910"] | ["0.7965","0.9319"] | [] | ["MCRY"] | 840.0000 | 910.0000 | 4 | 11 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:35:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a059-5a10-7dd1-a3b8-23a719509bd8 | LITE | 2026-09-14 10:36 | put_diagonal_spread | 2 | 4 | 172 | 2207016.00 | short | bid | 851.2700 | 5.2000 | ["760","830"] | ["0.7895","0.7426"] | [] | ["AMXO","ARCO","XMIO","XPHO"] | 760.0000 | 830.0000 | 32 | 67 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:36:51Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a086-78d8-7470-b3eb-97ec3fea0ffd | LITE | 2026-09-14 11:26 | put_diagonal_spread | 2 | 1 | 10 | 157450.00 | short | bid | 848.2300 | 8.5000 | ["905","920"] | ["0.7565","0.8210"] | [] | ["XISX"] | 905.0000 | 920.0000 | 4 | 11 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:26:15Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a5bc-7bde-7bc2-840f-5219bdaf0d10 | LITE | 2026-09-15 11:43 | put_diagonal_spread | 2 | 1 | 5 | 122374.00 | short | ask | 843.5700 | 16.1000 | ["800","970"] | ["0.7502","1.1064"] | [] | ["ARCO"] | 800.0000 | 970.0000 | 3 | 122 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:43:20Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5bc-ed26-7fd0-b79b-2672fce8776c | LITE | 2026-09-15 11:43 | put_diagonal_spread | 2 | 1 | 8 | 156744.00 | short | bid | 843.9011 | 11.8000 | ["800","920"] | ["0.7429","0.9503"] | [] | ["BATO"] | 800.0000 | 920.0000 | 3 | 122 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:43:54Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a678-b376-7602-ab97-8f357da54459 | LITE | 2026-09-15 15:08 | put_diagonal_spread | 2 | 1 | 50 | 528450.00 | short | bid | 837.7150 | 5.9000 | ["860","870"] | ["0.7021","0.7828"] | [] | ["EDGO"] | 860.0000 | 870.0000 | 3 | 17 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:08:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aaf8-73f3-7843-b557-8292ef3da2d4 | LITE | 2026-09-16 12:06 | put_diagonal_spread | 2 | 1 | 10 | 197100.00 | long | ask | 909.1000 | 12.6000 | ["945","950"] | ["0.7156","0.7155"] | [] | ["XPHO"] | 945.0000 | 950.0000 | 30 | 37 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:07:08Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aaf8-f4db-7471-b45d-f37b9a952634 | LITE | 2026-09-16 12:07 | put_diagonal_spread | 2 | 1 | 10 | 192160.00 | unknown | — | 908.0001 | 7.9000 | ["940","950"] | ["0.7022","0.7005"] | [] | ["AMXO"] | 940.0000 | 950.0000 | 30 | 37 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:08:06Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0b0d9-1f43-7430-ac25-69699424f9f8 | LITE | 2026-09-17 15:30 | put_diagonal_spread | 2 | 1 | 60 | 380580.00 | short | bid | 889.6750 | 5.2000 | ["890","910"] | ["0.6979","0.7835"] | [] | ["AMXO"] | 890.0000 | 910.0000 | 1 | 8 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:30:27Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b4e5-f0c7-7640-a54f-980cec56bce5 | LITE | 2026-09-18 10:22 | put_diagonal_spread | 2 | 1 | 15 | 165450.00 | long | ask | 910.2000 | 16.7000 | ["952.5","955"] | ["0.7670","1.5309"] | [] | ["XPHO"] | 952.5000 | 955.0000 | 0 | 7 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:23:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |