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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0abc3-e5fb-72d1-9eb6-b72ad76c2974 | SHOP | 2026-09-16 15:48 | put_vertical_spread | 2 | 1 | 40 | 127200.00 | long | ask | 129.6400 | 3.9000 | ["143","148"] | ["0.7008","0.8625"] | ["143.02"] | ["AMXO"] | 143.0000 | 148.0000 | 2 | 2 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:49:09Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa6b-c453-7223-adc4-abe1a76f9540 | SHOP | 2026-09-16 09:33 | put_diagonal_spread | 2 | 1 | 225 | 537975.00 | long | ask | 129.4700 | 2.5500 | ["130","140"] | ["0.5868","0.5148"] | [] | ["XCBO"] | 130.0000 | 140.0000 | 9 | 65 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:33:05Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08cbb-7498-7a13-bc81-68768043697e | SHOP | 2026-09-10 15:11 | put_vertical_spread | 2 | 1 | 40 | 213240.00 | long | ask | 126.4650 | 5.9000 | ["150","155"] | ["0.8657","0.9754"] | ["150.03"] | ["XCBO"] | 150.0000 | 155.0000 | 8 | 8 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:11:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8b-d9f0-7861-910f-28275bcf0917 | SHOP | 2026-09-10 09:39 | call_vertical_spread | 2 | 1 | 50 | 212634.00 | long | ask | 126.6301 | 2.0000 | ["100","150"] | ["0.5951","0.5520"] | ["124.39"] | ["XCBO"] | 100.0000 | 150.0000 | 127 | 127 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:40:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08755-7788-7de2-aa98-ae92c8610323 | SHOP | 2026-09-09 14:01 | put_vertical_spread | 2 | 1 | 40 | 196680.00 | long | ask | 127.8700 | 4.4500 | ["150","155"] | ["0.5408","0.5487"] | ["150.09"] | ["XCBO"] | 150.0000 | 155.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:02:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08231-8c89-7e22-be89-727d78eb538a | SHOP | 2026-09-08 14:04 | call_diagonal_spread | 2 | 1 | 33 | 116419.00 | long | ask | 135.1400 | 3.6500 | ["120","130"] | ["0.6302","0.5691"] | [] | ["XCBO"] | 120.0000 | 130.0000 | 10 | 101 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:05:26Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ef-2488-7441-aee3-23d7413134a2 | SHOP | 2026-09-08 12:52 | put_vertical_spread | 2 | 1 | 34 | 172278.00 | long | ask | 135.2000 | 5.8500 | ["157.5","162.5"] | ["1.2041","1.3781"] | ["157.51"] | ["XMIO"] | 157.5000 | 162.5000 | 3 | 3 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:52:41Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |