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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4ba-a227-7c02-ab1a-1b642837ee80 | SPX | 2026-09-21 12:09 | ratio_risk_reversal | 2 | 1 | 6 | 76575.00 | unknown | ask | 7744.3100 | 1.3000 | ["7250","7805"] | ["0.1836","0.1298"] | ["7122.38","8060.25"] | ["XCBO"] | 7250.0000 | 7805.0000 | 60 | 60 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:09:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a4-7a48-77a2-8916-64cd1d15a1ae | META | 2026-09-21 11:45 | ratio_risk_reversal | 2 | 1 | 270 | 3784540.00 | unknown | bid | 718.7500 | 2.8500 | ["680","760"] | ["0.4332","0.4337"] | ["539.83","970.25"] | ["AMXO"] | 680.0000 | 760.0000 | 269 | 269 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:45:08Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c496-9797-74a2-a094-4e6add7ad2ef | SPX | 2026-09-21 11:29 | ratio_risk_reversal | 2 | 1 | 2 | 91556.00 | unknown | ask | 7728.8100 | 1.5000 | ["7470","7750"] | ["0.1532","0.1348"] | ["7774.60"] | ["XCBO"] | 7470.0000 | 7750.0000 | 60 | 60 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:30:11Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c494-518e-7340-a8eb-fe7ccbe22c3c | MU | 2026-09-21 11:27 | ratio_risk_reversal | 2 | 1 | 3 | 39983.00 | unknown | ask | 1043.2900 | 2.0500 | ["1000","1100"] | ["0.6056","0.6102"] | ["800.08","1233.28"] | ["XCBO"] | 1000.0000 | 1100.0000 | 60 | 60 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:27:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43d-8ab7-7342-a7b6-f305fb8e56b4 | SOXX | 2026-09-21 09:52 | ratio_risk_reversal | 2 | 1 | 3 | 26886.00 | long | bid | 548.2200 | 10.9000 | ["570","680"] | ["0.4072","0.3786"] | ["503.56"] | ["XCBO"] | 570.0000 | 680.0000 | 269 | 269 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:52:44Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43c-ea8f-7e03-88b1-1ff0be012d77 | MU | 2026-09-21 09:51 | ratio_risk_reversal | 2 | 1 | 4 | 30661.00 | unknown | bid | 1053.1950 | 4.1000 | ["980","985"] | ["0.6031","0.6165"] | ["877.80","1061.65"] | ["XBOX"] | 980.0000 | 985.0000 | 4 | 4 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:52:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c43c-bbaf-76f2-acf9-afc5e48e01d1 | INTC | 2026-09-21 09:51 | ratio_risk_reversal | 2 | 1 | 14 | 37107.00 | unknown | bid | 117.1833 | 1.2500 | ["85","150"] | ["0.6599","0.6690"] | ["58.50","203.01"] | ["MCRY"] | 85.0000 | 150.0000 | 452 | 452 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:51:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c429-52f0-7a42-9a75-993a74c17a01 | AMD | 2026-09-21 09:30 | ratio_risk_reversal | 2 | 1 | 9 | 39675.00 | unknown | ask | 587.3300 | 5.9000 | ["510","570"] | ["0.5333","0.5269"] | ["377.75","614.08"] | ["XCBO"] | 510.0000 | 570.0000 | 25 | 25 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:30:23Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5eb-4b07-7e81-b8e6-2622855e2e42 | QQQ | 2026-09-18 15:08 | ratio_risk_reversal | 2 | 1 | 100 | 58050.00 | short | ask | 719.2900 | 0.0300 | ["715","722"] | ["0.1531","0.1215"] | ["723.86"] | ["XMIO"] | 715.0000 | 722.0000 | 7 | 7 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:08:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b02d-626b-7893-a8e4-fce4ef04e60a | AMD | 2026-09-17 12:22 | ratio_risk_reversal | 2 | 1 | 4 | 85024.00 | unknown | — | 551.2600 | 11.6500 | ["420","430"] | ["0.5696","0.5722"] | [] | ["XCBO"] | 420.0000 | 430.0000 | 820 | 820 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:23:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b018-e83b-7403-9529-47cc86ef41db | SPY | 2026-09-17 12:00 | ratio_risk_reversal | 2 | 1 | 21 | 114345.00 | short | ask | 762.5700 | 8.3600 | ["685","970"] | ["0.2137","0.1387"] | ["972.65"] | ["XCBO"] | 685.0000 | 970.0000 | 855 | 855 | true | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:00:18Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afd1-c933-7b63-a5d4-4d6aa76f05c5 | CRWD | 2026-09-17 10:42 | ratio_risk_reversal | 2 | 1 | 5 | 28990.00 | long | ask | 248.3300 | 8.8500 | ["200","300"] | ["0.6161","0.6097"] | ["188.20"] | ["XMIO"] | 200.0000 | 300.0000 | 491 | 491 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:42:50Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afb5-e0ab-7093-b73b-ff7bc3ea6e72 | SPCX | 2026-09-17 10:12 | ratio_risk_reversal | 2 | 1 | 196 | 88102.00 | unknown | — | 155.9120 | 0.1300 | ["155","165"] | ["0.5692","0.5801"] | [] | ["XMIO"] | 155.0000 | 165.0000 | 8 | 8 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:12:24Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb8-64ac-7a50-9f26-ff45b7f75e39 | SPX | 2026-09-16 15:36 | ratio_risk_reversal | 2 | 1 | 12 | 31560.00 | unknown | — | 7530.8600 | 1.1000 | ["7555","7600"] | ["0.1610","0.1512"] | [] | ["XCBO"] | 7555.0000 | 7600.0000 | 2 | 2 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:36:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abae-eecb-7e73-98dc-ccf5c85bba59 | IBIT | 2026-09-16 15:26 | ratio_risk_reversal | 2 | 1 | 2820 | 206800.00 | unknown | — | 42.5700 | 0.0200 | ["42","44"] | ["0.3839","0.3823"] | [] | ["EDGO"] | 42.0000 | 44.0000 | 9 | 9 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:26:17Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0abaa-2053-7d70-adaf-9c3476932192 | SPX | 2026-09-16 15:20 | ratio_risk_reversal | 2 | 1 | 10 | 117275.00 | unknown | — | 7519.7200 | 1.3000 | ["7265","7550"] | ["0.1874","0.1447"] | [] | ["XCBO"] | 7265.0000 | 7550.0000 | 30 | 30 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:21:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba6-a5b3-72f0-9109-20d592e06580 | SPX | 2026-09-16 15:16 | ratio_risk_reversal | 2 | 1 | 8 | 93400.00 | unknown | — | 7524.8300 | 1.2000 | ["7265","7550"] | ["0.1864","0.1448"] | [] | ["XCBO"] | 7265.0000 | 7550.0000 | 30 | 30 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab6e-a9ab-7651-9cd9-4777b43d8177 | PLTR | 2026-09-16 14:15 | ratio_risk_reversal | 2 | 1 | 40 | 51200.00 | short | bid | 172.9725 | 0.6000 | ["170","175"] | ["0.4843","0.4838"] | ["179.98"] | ["XCBO"] | 170.0000 | 175.0000 | 30 | 30 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:16:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa7e-e6c3-7a90-aedf-bf2496ab0083 | EWZ | 2026-09-16 09:53 | ratio_risk_reversal | 2 | 1 | 3000 | 163199.00 | long | bid | 37.4300 | 0.0600 | ["38","43"] | ["0.4270","0.4292"] | ["43.13"] | ["XMIO"] | 38.0000 | 43.0000 | 30 | 30 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:54:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a661-2435-7603-bbcf-57dad1d8a8a2 | SPCX | 2026-09-15 14:42 | ratio_risk_reversal | 2 | 1 | 10 | 41125.00 | unknown | — | 144.3044 | 3.9500 | ["130","135"] | ["0.5716","0.5865"] | [] | ["EDGO"] | 130.0000 | 135.0000 | 857 | 857 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:43:13Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58d-846e-7d72-a67a-17c8571fa223 | SPX | 2026-09-15 10:51 | ratio_risk_reversal | 2 | 1 | 10 | 114825.00 | unknown | — | 7576.6000 | 1.1000 | ["7315","7600"] | ["0.1803","0.1396"] | [] | ["XCBO"] | 7315.0000 | 7600.0000 | 31 | 31 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:51:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a549-e005-7f63-828d-c581939c477e | IWM | 2026-09-15 09:37 | ratio_risk_reversal | 2 | 1 | 697 | 323171.00 | long | bid | 285.6900 | 0.2400 | ["290","295"] | ["0.1762","0.1672"] | ["295.22"] | ["XMIO"] | 290.0000 | 295.0000 | 31 | 31 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T13:37:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a164-3290-7ef1-b150-af3eccfab4a0 | GS | 2026-09-14 15:28 | ratio_risk_reversal | 2 | 1 | 12 | 128958.00 | short | ask | 987.0650 | 8.0000 | ["1000","1200"] | ["0.3602","0.3202"] | ["990.63"] | ["XPHO"] | 1000.0000 | 1200.0000 | 276 | 276 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:28:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a12b-c540-7ab0-ba5a-9f1e2aa73b17 | GEV | 2026-09-14 14:26 | ratio_risk_reversal | 2 | 1 | 6 | 238638.00 | long | ask | 875.0500 | 16.4000 | ["850","900"] | ["0.5117","0.5352"] | ["837.95"] | ["XPHO"] | 850.0000 | 900.0000 | 823 | 823 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:27:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c9e-b920-77e0-95e8-cf68352dae85 | WDC | 2026-09-10 14:40 | ratio_risk_reversal | 2 | 1 | 150 | 67200.00 | short | ask | 466.7400 | 1.5200 | ["455","482.5"] | ["0.7862","0.7408"] | ["454.42"] | ["XCBO"] | 455.0000 | 482.5000 | 1 | 1 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:40:22Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c61-0ff8-7c10-a98e-f2c8c8f2a8b4 | MU | 2026-09-10 13:32 | ratio_risk_reversal | 2 | 2 | 100 | 862694.00 | long | ask | 980.8700 | 2.4500 | ["800","1100"] | ["0.6149","0.6306"] | ["1103.40"] | ["XMIO"] | 800.0000 | 1100.0000 | 99 | 99 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:33:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bbf-ea10-70c3-9ccb-042e3a60da12 | MSFT | 2026-09-10 10:36 | ratio_risk_reversal | 2 | 1 | 200 | 207450.00 | long | bid | 492.2800 | 1.9500 | ["465","610"] | ["0.3025","0.2894"] | ["610.59"] | ["XCBO"] | 465.0000 | 610.0000 | 127 | 127 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:37:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b89-baf8-70b3-87a2-377cc9c5d5a0 | PLTR | 2026-09-10 09:37 | ratio_risk_reversal | 2 | 1 | 8 | 35992.00 | short | bid | 164.9854 | 2.8500 | ["110","125"] | ["0.5861","0.6146"] | ["165.42"] | ["XCBO"] | 110.0000 | 125.0000 | 463 | 463 | false | false | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:37:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0867c-5597-71a3-9eac-cba7a42cef9d | META | 2026-09-09 10:04 | ratio_risk_reversal | 2 | 1 | 2 | 25278.00 | long | ask | 646.2300 | 7.7500 | ["450","740"] | ["0.4419","0.4343"] | ["801.50"] | ["XMIO"] | 450.0000 | 740.0000 | 828 | 828 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:04:50Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08234-0559-7933-87ae-ddf3c9bfebb6 | MSFT | 2026-09-08 14:07 | ratio_risk_reversal | 2 | 1 | 15 | 146596.00 | long | ask | 492.6100 | 3.2500 | ["455","560"] | ["0.3430","0.3149"] | ["438.19"] | ["XCBO"] | 455.0000 | 560.0000 | 829 | 829 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:08:14Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08211-bc00-7f82-876b-f89ee2f1b6b0 | CRWV | 2026-09-08 13:29 | ratio_risk_reversal | 2 | 1 | 212 | 291288.00 | short | bid | 103.1901 | 0.6000 | ["50","270"] | ["0.8607","0.8240"] | ["48.60"] | ["XMIO"] | 50.0000 | 270.0000 | 465 | 465 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:30:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081d1-0598-77c3-be08-82207b219c1c | SPY | 2026-09-08 12:19 | ratio_risk_reversal | 2 | 1 | 105 | 579495.00 | long | bid | 766.9200 | 0.3700 | ["690","970"] | ["0.2272","0.1438"] | ["972.17"] | ["XCBO"] | 690.0000 | 970.0000 | 829 | 829 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:19:52Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ba-e588-7200-9fc9-78e85ca48750 | DELL | 2026-09-08 11:55 | ratio_risk_reversal | 2 | 1 | 10 | 119560.00 | long | ask | 530.1350 | 4.8500 | ["420","450"] | ["0.6914","0.7032"] | ["507.00"] | ["XCBO"] | 420.0000 | 450.0000 | 192 | 192 | false | false | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:55:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dfe-9f1d-7781-95ef-52eb05d694cd | SNDK | 2026-09-04 15:56 | ratio_risk_reversal | 2 | 1 | 3 | 55574.00 | long | ask | 1736.1696 | 9.8000 | ["1250","1900"] | ["0.7819","0.7934"] | ["1249.67"] | ["XCBO"] | 1250.0000 | 1900.0000 | 133 | 133 | false | true | false | true | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:56:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |