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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ee-7b70-7f72-b94a-c8cd4630be04 | DELL | 2026-09-18 15:11 | call_ratio_spread | 2 | 1 | 10 | 35630.00 | long | ask | 574.2700 | 2.9000 | ["545","572.5"] | ["0.5224","0.5349"] | ["600.98"] | ["ARCO"] | 545.0000 | 572.5000 | 7 | 7 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:12:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4fe-c827-7692-af74-4bd1b1a6dbe7 | DELL | 2026-09-18 10:49 | call_ratio_spread | 2 | 1 | 2 | 40594.00 | unknown | bid | 583.4400 | 4.0500 | ["360","570"] | ["0.6979","0.6724"] | ["635.31"] | ["XISX"] | 360.0000 | 570.0000 | 91 | 91 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:50:09Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e2-33bf-7fc1-8737-f4b60b9b99e4 | DELL | 2026-09-18 10:18 | call_ratio_spread | 2 | 1 | 8 | 93084.00 | long | ask | 584.4000 | 4.4000 | ["460","530"] | ["5.2233","2.4857"] | ["475.99","584.01"] | ["XMIO"] | 460.0000 | 530.0000 | 0 | 0 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:18:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f2-c994-70e2-94ee-0a627bf3159d | DELL | 2026-09-17 15:58 | call_ratio_spread | 2 | 1 | 20 | 190202.00 | long | ask | 590.0500 | 3.9500 | ["550","620"] | ["0.6421","0.6417"] | ["709.70"] | ["XCBO"] | 550.0000 | 620.0000 | 64 | 64 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0e1-126b-7141-a836-afb344e0d567 | DELL | 2026-09-17 15:38 | call_ratio_spread | 2 | 1 | 2 | 35275.00 | long | ask | 592.2550 | 5.0500 | ["450","500"] | ["0.6930","0.6430"] | ["608.41"] | ["XISX"] | 450.0000 | 500.0000 | 29 | 29 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:39:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0d0-60fb-75c0-8046-1aedc0be7133 | DELL | 2026-09-17 15:20 | call_ratio_spread | 2 | 1 | 40 | 25320.00 | long | ask | 590.8300 | 0.3500 | ["595","605"] | ["0.6681","0.6704"] | ["595.10","614.90"] | ["XMIO"] | 595.0000 | 605.0000 | 1 | 1 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:21:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b092-e2cb-7b43-adfc-4f9bbe49d1c9 | DELL | 2026-09-17 14:13 | call_ratio_spread | 2 | 1 | 40 | 29946.00 | long | ask | 585.9800 | 0.3500 | ["585","600"] | ["0.6710","0.6700"] | ["587.50","612.50"] | ["XISX"] | 585.0000 | 600.0000 | 1 | 1 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:14:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab9d-89ac-7091-8a08-9957b9e2f4c4 | DELL | 2026-09-16 15:07 | call_ratio_spread | 2 | 4 | 46 | 34060.00 | unknown | — | 557.7800 | 0.8500 | ["570","572.5"] | ["0.7267","0.7268"] | [] | ["XISX"] | 570.0000 | 572.5000 | 2 | 2 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:07:14Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa92-342b-7832-8304-d340425967f9 | DELL | 2026-09-16 10:15 | call_ratio_spread | 2 | 1 | 4 | 71220.00 | unknown | — | 569.8350 | 5.3000 | ["500","550"] | ["0.6893","0.6881"] | [] | ["XCBO"] | 500.0000 | 550.0000 | 93 | 93 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T14:15:20Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a026-b151-7ed0-8f58-6e65a5212fa1 | DELL | 2026-09-14 09:41 | call_ratio_spread | 2 | 1 | 48 | 824472.00 | long | ask | 529.2000 | 5.1500 | ["500","760"] | ["0.6971","0.6940"] | ["1033.27"] | ["EDGO"] | 500.0000 | 760.0000 | 368 | 368 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:41:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a026-a1b1-7962-9ccc-7cc232b07943 | DELL | 2026-09-14 09:41 | call_ratio_spread | 2 | 1 | 50 | 859600.00 | long | ask | 529.2000 | 5.4500 | ["500","760"] | ["0.6948","0.6958"] | ["1034.44"] | ["EDGO"] | 500.0000 | 760.0000 | 368 | 368 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:41:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091b6-7ad8-7523-85dd-54c451040f7e | DELL | 2026-09-11 14:24 | call_ratio_spread | 2 | 1 | 2 | 55989.00 | long | ask | 560.8999 | 7.7000 | ["300","800"] | ["0.7175","0.7020"] | ["366.33","1233.67"] | ["XCBO"] | 300.0000 | 800.0000 | 497 | 497 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:24:15Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c8b-d530-75b3-9313-3333305c3ee0 | DELL | 2026-09-10 14:19 | call_ratio_spread | 2 | 1 | 16 | 27968.00 | long | ask | 513.2500 | 1.7000 | ["700","710"] | ["0.6438","0.6441"] | ["730.24"] | ["XISX"] | 700.0000 | 710.0000 | 71 | 71 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:19:28Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0867a-2ae8-7522-82df-d80bf6b38658 | DELL | 2026-09-09 10:02 | call_ratio_spread | 2 | 1 | 2 | 40348.00 | long | ask | 560.8991 | 7.3500 | ["500","760"] | ["0.7008","0.7045"] | ["1046.08"] | ["XPHO"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:02:28Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08679-bd88-7d80-87f4-c98565f6c726 | DELL | 2026-09-09 10:01 | call_ratio_spread | 2 | 1 | 2 | 40203.00 | long | ask | 559.5300 | 6.6500 | ["500","760"] | ["0.6997","0.7070"] | ["1047.01"] | ["XCBO"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:02:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08679-6798-7ea2-a46b-75f9a4a6d5ea | DELL | 2026-09-09 10:01 | call_ratio_spread | 2 | 2 | 4 | 80481.00 | long | ask | 560.3050 | 7.0500 | ["500","760"] | ["0.6970","0.7060"] | ["1047.30"] | ["ARCO","XCBO"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:01:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866f-e601-73a0-b9ed-6b1493498b28 | DELL | 2026-09-09 09:51 | call_ratio_spread | 2 | 1 | 2 | 40470.00 | long | ask | 560.0001 | 5.0000 | ["500","760"] | ["0.7041","0.7092"] | ["1047.30"] | ["XISX"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:51:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866e-c108-7742-b1ea-2e523f570b17 | DELL | 2026-09-09 09:49 | call_ratio_spread | 2 | 1 | 87 | 78416.00 | long | ask | 559.3150 | 1.4000 | ["700","770"] | ["0.6901","0.7034"] | ["807.20"] | ["BATO"] | 700.0000 | 770.0000 | 37 | 37 | false | true | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866e-c108-7742-b1ea-2e48732929f9 | DELL | 2026-09-09 09:49 | call_ratio_spread | 2 | 1 | 114 | 102752.00 | long | ask | 559.3150 | 1.4000 | ["700","770"] | ["0.6901","0.7034"] | ["807.20"] | ["BATO"] | 700.0000 | 770.0000 | 37 | 37 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866e-9228-7d02-8af9-c0acf9eb5703 | DELL | 2026-09-09 09:49 | call_ratio_spread | 2 | 1 | 2 | 40113.00 | long | ask | 558.9101 | 3.9000 | ["500","760"] | ["0.6997","0.7073"] | ["1046.99"] | ["EDGO"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:50:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866d-9828-78c2-8b2d-c0f98cdb5f6c | DELL | 2026-09-09 09:48 | call_ratio_spread | 2 | 1 | 144 | 127104.00 | long | ask | 557.9600 | 1.5500 | ["700","770"] | ["0.6905","0.7040"] | ["807.15"] | ["BATO"] | 700.0000 | 770.0000 | 37 | 37 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:48:42Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866b-fa19-7892-b580-edc1e9b54508 | DELL | 2026-09-09 09:46 | call_ratio_spread | 2 | 5 | 18 | 354397.00 | long | ask | 554.8900 | 5.6500 | ["500","760"] | ["0.6984","0.7068"] | ["1045.90"] | ["AMXO","EDGO","XISX","XPHO"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:47:09Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0866a-c968-7d21-ab1c-0701d61aea28 | DELL | 2026-09-09 09:45 | call_ratio_spread | 2 | 1 | 2 | 39575.00 | long | ask | 555.9200 | 5.7000 | ["500","760"] | ["0.6996","0.7067"] | ["1045.93"] | ["XISX"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:45:51Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08669-9ca1-74b3-8119-b4667f26c18a | DELL | 2026-09-09 09:44 | call_ratio_spread | 2 | 2 | 4 | 78910.00 | long | ask | 554.8775 | 6.6500 | ["500","760"] | ["0.7008","0.7075"] | ["1045.75"] | ["EDGO","XISX"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:44:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08669-90e8-7580-b13f-5b8d37e0b0b9 | DELL | 2026-09-09 09:44 | call_ratio_spread | 2 | 2 | 6 | 118354.00 | long | ask | 554.8775 | 6.8000 | ["500","760"] | ["0.7016","0.7071"] | ["1045.43"] | ["EDGO","XISX"] | 500.0000 | 760.0000 | 373 | 373 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:44:19Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |