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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c572-0b47-7e32-a90b-1e89ad6c88f5 | SHOP | 2026-09-21 15:29 | call_diagonal_spread | 2 | 2 | 110 | 215580.00 | long | ask | 136.3200 | 0.5500 | ["137","145"] | ["0.5080","0.5812"] | [] | ["ARCO","C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:29:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c572-075e-7500-b1cc-aa6e8ce60d4a | SHOP | 2026-09-21 15:29 | call_diagonal_spread | 2 | 1 | 100 | 195400.00 | long | ask | 136.3200 | 0.4500 | ["137","145"] | ["0.5059","0.5802"] | [] | ["C2OX"] | 137.0000 | 145.0000 | 25 | 88 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:29:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c55c-d597-7951-b4e5-881627650c35 | SHOP | 2026-09-21 15:06 | call_diagonal_spread | 2 | 3 | 108 | 188800.00 | long | ask | 136.6900 | 0.4500 | ["139","150"] | ["0.5166","0.5829"] | [] | ["ARCO","C2OX"] | 139.0000 | 150.0000 | 25 | 88 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:07:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51b-f437-7ed3-9d1b-e27d6fd0d59b | SHOP | 2026-09-21 13:55 | call_vertical_spread | 2 | 3 | 68 | 213486.00 | long | ask | 134.1850 | 6.4500 | ["119","130"] | ["0.5762","0.5541"] | ["126.24"] | ["ARCO","XISX"] | 119.0000 | 130.0000 | 39 | 39 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:55:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51b-f436-71a2-96d7-77aee23cc9df | SHOP | 2026-09-21 13:55 | call_vertical_spread | 2 | 3 | 166 | 520626.00 | long | ask | 134.1850 | 6.4500 | ["119","130"] | ["0.5763","0.5521"] | ["126.28"] | ["ARCO","XCBO","XPHO"] | 119.0000 | 130.0000 | 39 | 39 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:55:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51b-f436-71a2-96d7-779e4a55b440 | SHOP | 2026-09-21 13:55 | call_vertical_spread | 2 | 2 | 34 | 106743.00 | long | ask | 134.1850 | 6.4500 | ["119","130"] | ["0.5777","0.5529"] | ["126.28"] | ["ARCO","XISX"] | 119.0000 | 130.0000 | 39 | 39 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:55:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c510-4bd7-79f0-a685-c8b84ebcc723 | SHOP | 2026-09-21 13:42 | call_ratio_spread | 2 | 1 | 350 | 111850.00 | long | ask | 133.3900 | 0.7500 | ["135","140"] | ["0.6621","0.6881"] | ["135.38","146.16"] | ["EDGO"] | 135.0000 | 140.0000 | 4 | 4 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:43:09Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c464-8347-7653-916f-b11efaef472e | SHOP | 2026-09-21 10:35 | put_diagonal_spread | 2 | 2 | 92 | 211232.00 | long | ask | 129.4405 | 0.8500 | ["130","135"] | ["0.5573","0.4605"] | [] | ["XISX","XPHO"] | 130.0000 | 135.0000 | 25 | 88 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:35:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c449-65df-74b3-ab5a-78224e468b8f | SHOP | 2026-09-21 10:05 | call_diagonal_spread | 2 | 1 | 45000 | 54705000.00 | unknown | ask | 129.2300 | 2.2500 | ["135","145"] | ["0.4373","0.5612"] | [] | ["SPHR"] | 135.0000 | 145.0000 | 25 | 88 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:05:38Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5ae-652f-7a33-b5e6-3f66f78fb932 | SHOP | 2026-09-18 14:01 | other | 4 | 5 | 82 | 223501.00 | unknown | ask | 127.2200 | 1.0268 | ["100","120","125","155"] | ["6.2947","1.9404","0.9096","5.1203"] | ["10.75","127.26"] | ["ARCO","XCBO","XISX","XPHO"] | 100.0000 | 155.0000 | 0 | 0 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:01:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56e-52d8-7900-8e9e-ee8c4f0f9b3f | SHOP | 2026-09-18 12:51 | put_vertical_spread | 2 | 1 | 20 | 163500.00 | long | ask | 127.0950 | 4.0500 | ["165","170"] | ["0.5845","0.6155"] | ["165.15"] | ["XPHO"] | 165.0000 | 170.0000 | 42 | 42 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:51:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0d1-6e83-7822-b7c3-978fb01dbb9c | SHOP | 2026-09-17 15:21 | call_vertical_spread | 2 | 1 | 10 | 113980.00 | long | ask | 128.3300 | 4.4500 | ["80","85"] | ["0.6322","0.6231"] | ["83.50"] | ["BATO"] | 80.0000 | 85.0000 | 365 | 365 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:21:48Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af97-3133-7c42-8b68-1d8985dc8b3a | SHOP | 2026-09-17 09:38 | call_vertical_spread | 2 | 1 | 300 | 159300.00 | long | ask | 128.9200 | 0.6200 | ["135","160"] | ["0.4834","0.5100"] | ["139.05"] | ["EDGO"] | 135.0000 | 160.0000 | 29 | 29 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:38:44Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 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 |
| 01a0a663-a4d6-7de3-a0b3-44acecee72a4 | SHOP | 2026-09-15 14:45 | put_vertical_spread | 2 | 1 | 40 | 125600.00 | long | ask | 130.1100 | 3.1000 | ["143","148"] | ["0.7779","0.9195"] | ["143.10"] | ["XMIO"] | 143.0000 | 148.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:46:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 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 |
| 01a08733-8421-7273-891b-c5533a694388 | SHOP | 2026-09-09 13:24 | call_vertical_spread | 2 | 1 | 300 | 208500.00 | long | ask | 129.3150 | 0.3300 | ["135","160"] | ["0.4919","0.5038"] | ["139.87"] | ["EDGO"] | 135.0000 | 160.0000 | 37 | 37 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T17:25:03Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086c6-2421-74c3-89c1-48ad6e99166f | SHOP | 2026-09-09 11:25 | call_vertical_spread | 2 | 4 | 331 | 161928.00 | long | ask | 128.8500 | 0.5100 | ["130","140"] | ["0.5420","0.5378"] | ["132.9"] | ["AMXO","ARCO"] | 130.0000 | 140.0000 | 9 | 9 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:25:55Z"} | 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 |