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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b615-d1bf-7e31-ab79-9b3bc8ae5c49 | BMY | 2026-09-18 15:54 | put_ratio_spread | 2 | 1 | 576 | 209088.00 | unknown | bid | 62.7700 | 0.7500 | ["45","55"] | ["0.3687","0.3660"] | ["36.22","53.78"] | ["XPHO"] | 45.0000 | 55.0000 | 364 | 364 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:54:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b610-8647-7691-a70f-b3f501d6ffed | SOXX | 2026-09-18 15:48 | put_ratio_spread | 2 | 1 | 510 | 186405.00 | unknown | bid | 527.2000 | 1.2000 | ["490","520"] | ["0.3742","0.3033"] | ["463.67","516.33"] | ["EDGO"] | 490.0000 | 520.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:48:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60e-a9b7-7601-b465-e1f8e0b0eb7f | SPCX | 2026-09-18 15:46 | put_ratio_spread | 2 | 1 | 46 | 26588.00 | unknown | bid | 152.7350 | 0.1900 | ["110","145"] | ["0.5792","0.5373"] | ["133.44"] | ["AMXO"] | 110.0000 | 145.0000 | 63 | 63 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:46:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b606-f50f-7f13-80c0-757f690c4b5a | SPX | 2026-09-18 15:38 | put_ratio_spread | 2 | 1 | 4 | 40930.00 | long | bid | 7640.3300 | 0.9000 | ["5800","6800"] | ["0.2918","0.2121"] | ["6730.44"] | ["XCBO"] | 5800.0000 | 6800.0000 | 154 | 154 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fb-5c4f-7683-8249-c0369398adec | SPX | 2026-09-18 15:25 | put_ratio_spread | 2 | 1 | 20 | 99060.00 | unknown | bid | 7639.9600 | 0.4500 | ["7610","7640"] | ["0.1075","0.1010"] | ["7560.50"] | ["XCBO"] | 7610.0000 | 7640.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b2-6887-75e0-8743-4c447cdda6fc | USO | 2026-09-18 14:06 | put_ratio_spread | 2 | 1 | 500 | 243751.00 | unknown | bid | 154.1981 | 0.2800 | ["105","140"] | ["0.5170","0.4982"] | ["130.25"] | ["XMIO"] | 105.0000 | 140.0000 | 91 | 91 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:06:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b0-0ef8-79e1-9cf7-18acba5e44de | SNDK | 2026-09-18 14:03 | put_ratio_spread | 2 | 1 | 50 | 268800.00 | unknown | bid | 1742.3250 | 1.2000 | ["1660","1720"] | ["0.6519","0.6494"] | ["1594.40"] | ["XISX"] | 1660.0000 | 1720.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:03:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59d-7d0f-7101-8460-b31b8b5c7dc2 | SPCX | 2026-09-18 13:43 | put_ratio_spread | 2 | 1 | 100 | 70900.00 | unknown | bid | 152.1500 | 0.2000 | ["110","150"] | ["0.5842","0.5327"] | ["135.82"] | ["EDGO"] | 110.0000 | 150.0000 | 63 | 63 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:43:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b564-f07f-7e83-80de-fbbfd0c60848 | ORCL | 2026-09-18 12:41 | put_ratio_spread | 2 | 2 | 10 | 28995.00 | unknown | bid | 145.0900 | 0.6500 | ["145","165"] | ["0.5540","0.5637"] | ["122.67"] | ["XCBO"] | 145.0000 | 165.0000 | 91 | 91 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:41:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b559-3880-7051-94a6-6ef84ccb2250 | IWM | 2026-09-18 12:28 | put_ratio_spread | 2 | 1 | 116 | 34974.00 | unknown | bid | 282.6950 | 0.2200 | ["282","287"] | ["0.1178","0.1186"] | ["279.63","284.37"] | ["XMIO"] | 282.0000 | 287.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:28:40Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b54c-2ca7-78d3-b731-66d1f3495da7 | SPY | 2026-09-18 12:14 | put_ratio_spread | 2 | 1 | 420 | 559230.00 | unknown | bid | 759.0500 | 0.0500 | ["720","730"] | ["0.1799","0.1698"] | ["717.28"] | ["XPHO"] | 720.0000 | 730.0000 | 63 | 63 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:14:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b544-7be7-7f70-af14-0742f7bd6259 | SPX | 2026-09-18 12:05 | put_ratio_spread | 2 | 1 | 6 | 31167.00 | long | bid | 7619.6700 | 1.3000 | ["7625","7650"] | ["0.0839","0.0838"] | ["7620.25"] | ["XCBO"] | 7625.0000 | 7650.0000 | 3 | 3 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:06:04Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b539-6bdf-77d0-9d9b-12ef63d4b5f7 | DIS | 2026-09-18 11:53 | put_ratio_spread | 2 | 1 | 750 | 574500.00 | unknown | bid | 103.2000 | 0.8000 | ["90","100"] | ["0.3063","0.3017"] | ["88.23"] | ["XPHO"] | 90.0000 | 100.0000 | 272 | 272 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:54:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b511-90bf-7270-ad3a-c28fc10f0075 | SNDK | 2026-09-18 11:10 | put_ratio_spread | 2 | 1 | 4 | 64348.00 | long | bid | 1715.4400 | 1.7000 | ["1730","1815"] | ["0.6594","0.6739"] | ["1717.38"] | ["XCBO"] | 1730.0000 | 1815.0000 | 7 | 7 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:10:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-5b37-7b81-8ced-65b0d1118b85 | URA | 2026-09-18 10:30 | put_ratio_spread | 2 | 1 | 375 | 221750.00 | long | bid | 41.9300 | 0.6000 | ["42","47.5"] | ["0.4665","0.4060"] | ["42.32"] | ["XBOX"] | 42.0000 | 47.5000 | 7 | 7 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:30:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d1-a577-7453-900a-5cff7ea21a59 | SNDK | 2026-09-18 10:00 | put_ratio_spread | 2 | 1 | 4 | 71163.00 | unknown | bid | 1694.6900 | 13.3000 | ["1050","1100"] | ["0.7315","0.7310"] | ["851.55"] | ["XCBO"] | 1050.0000 | 1100.0000 | 272 | 272 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:00:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c5-31f7-7153-83c8-8d05c3ab3e82 | VIX | 2026-09-18 09:46 | put_ratio_spread | 2 | 1 | 15000 | 1177500.00 | unknown | bid | 15.2000 | 0.0800 | ["16","17"] | ["0.5480","0.6396"] | ["15.81"] | ["XCBO"] | 16.0000 | 17.0000 | 33 | 33 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:47:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4be-6f80-7b20-bdca-375ed94fac68 | IWM | 2026-09-18 09:39 | put_ratio_spread | 2 | 1 | 2825 | 1489234.00 | unknown | bid | 283.9150 | 0.1000 | ["281","285"] | ["0.1698","0.1533"] | ["253.47","283.76"] | ["XISX"] | 281.0000 | 285.0000 | 12 | 12 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:39:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4b9-04c7-77f2-a6dc-01fe0b30d331 | MSFT | 2026-09-18 09:33 | put_ratio_spread | 2 | 1 | 60 | 28360.00 | unknown | bid | 495.8750 | 4.0400 | ["185","210"] | ["0.4036","0.3891"] | ["134.96"] | ["XCBO"] | 185.0000 | 210.0000 | 819 | 819 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:33:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a69c-ba1e-79f3-b58e-74c39890bc0e | SPY | 2026-09-15 15:48 | put_ratio_spread | 2 | 1 | 16 | 59600.00 | long | bid | 756.8700 | 0.5100 | ["772","779"] | ["0.1431","0.1428"] | ["755.06"] | ["MCRY"] | 772.0000 | 779.0000 | 45 | 45 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a682-9e86-7fd3-be84-67888c85ffe3 | SPY | 2026-09-15 15:19 | put_ratio_spread | 2 | 1 | 500 | 263397.00 | long | bid | 757.2000 | 0.0600 | ["680","745"] | ["0.2928","0.1694"] | ["740.39"] | ["XMIO"] | 680.0000 | 745.0000 | 15 | 15 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:20:10Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a050-da48-7f02-b122-a0f4c2c9ed5a | SNDK | 2026-09-14 10:27 | put_ratio_spread | 2 | 1 | 2 | 26459.00 | long | bid | 1554.0250 | 1.7000 | ["1570","1635"] | ["0.7892","0.7971"] | ["1554.35"] | ["XCBO"] | 1570.0000 | 1635.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:27:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a024-6379-70f1-8ac3-e75f7a5af1fd | SNDK | 2026-09-14 09:38 | put_ratio_spread | 2 | 1 | 2 | 28311.00 | long | bid | 1512.0500 | 4.7000 | ["1530","1600"] | ["0.8513","0.8601"] | ["1513.15"] | ["XCBO"] | 1530.0000 | 1600.0000 | 4 | 4 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:38:53Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08c67-af48-70d0-8b8f-7e2350482cfd | SPY | 2026-09-10 13:39 | put_ratio_spread | 2 | 1 | 4398 | 661899.00 | long | bid | 758.0800 | 0.0300 | ["690","730"] | ["0.3204","0.2180"] | ["728.78"] | ["XMIO"] | 690.0000 | 730.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08143-6f81-7230-b59f-773c030e6110 | QQQ | 2026-09-08 09:44 | put_ratio_spread | 2 | 1 | 44 | 99726.00 | long | bid | 717.0900 | 0.1900 | ["710","715"] | ["0.2011","0.1970"] | ["702.41"] | ["XISX"] | 710.0000 | 715.0000 | 38 | 38 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:44:44Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |