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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4c0-ef6f-7d53-82dd-f9ba9bbaf94e | STX | 2026-09-21 12:16 | straddle | 2 | 2 | 3 | 124218.00 | short | bid | 872.9000 | 13.5000 | ["1200"] | ["0.7086"] | ["785.94","1614.06"] | ["ARCO","XISX"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:16:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4c0-ef6f-7d53-82dd-f9a322d16ade | STX | 2026-09-21 12:16 | straddle | 2 | 4 | 4 | 165624.00 | short | bid | 872.5833 | 14.1000 | ["1200"] | ["0.7082"] | ["785.94","1614.06"] | ["AMXO","XBOX","XCBO","XPHO"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:16:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4bc-441f-7772-a5dc-e7c4d009a8d0 | STX | 2026-09-21 12:11 | straddle | 2 | 1 | 3 | 124422.00 | short | bid | 871.0800 | 10.3000 | ["1200"] | ["0.7084"] | ["785.26","1614.74"] | ["XISX"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:11:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4bc-4037-7082-a2f3-72cacdaf452b | STX | 2026-09-21 12:11 | straddle | 2 | 2 | 4 | 165896.00 | short | bid | 871.0800 | 10.9000 | ["1200"] | ["0.7084"] | ["785.26","1614.74"] | ["XCBO","XPHO"] | 1200.0000 | 1200.0000 | 116 | 116 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:11:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a08c11-e270-7652-aeb5-c764a4776ecb | STX | 2026-09-10 12:06 | straddle | 2 | 5 | 12 | 35352.00 | long | ask | 855.1285 | 2.1000 | ["860"] | ["0.8157"] | ["830.54","889.46"] | ["AMXO","SPHR","XCBO","XPHO"] | 860.0000 | 860.0000 | 1 | 1 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:06:52Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0826d-ab28-7212-bf0b-99fd7dc38c88 | STX | 2026-09-08 15:10 | straddle | 2 | 3 | 3 | 87000.00 | short | bid | 918.9100 | 16.9333 | ["900"] | ["0.7667"] | ["610","1190.00"] | ["XCBO","XPHO"] | 900.0000 | 900.0000 | 101 | 101 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826d-ab28-7212-bf0b-99ea929565be | STX | 2026-09-08 15:10 | straddle | 2 | 4 | 5 | 145052.00 | long | ask | 918.9100 | 16.3600 | ["900"] | ["0.7670"] | ["609.90","1190.10"] | ["ARCO","XCBO","XPHO"] | 900.0000 | 900.0000 | 101 | 101 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826d-ab28-7212-bf0b-99bed39c5648 | STX | 2026-09-08 15:10 | straddle | 2 | 2 | 2 | 58000.00 | short | bid | 918.9100 | 17.1000 | ["900"] | ["0.7667"] | ["610","1190.00"] | ["XCBO","XPHO"] | 900.0000 | 900.0000 | 101 | 101 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:10:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |