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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b61a-753f-7181-910f-2b15a9e782cc | SPX | 2026-09-18 15:59 | other | 6 | 2 | 6 | 26630.00 | unknown | ask | 7647.8600 | 2.4167 | ["7605","7630","7635","7650"] | ["0.2278","0.1898","0.6244","0.4695"] | ["7603.82","7634.70"] | ["XCBO"] | 7605.0000 | 7650.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:59:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b616-662f-7073-8752-4222f169aabc | MU | 2026-09-18 15:55 | other | 3 | 2 | 3 | 36210.00 | unknown | ask | 1014.6300 | 15.2833 | ["950","960"] | ["7.3190","9.4367"] | [] | ["XISX"] | 950.0000 | 960.0000 | 0 | 5 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:55:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b608-25bf-79e2-8d0b-741134b3213f | SPX | 2026-09-18 15:39 | other | 5 | 2 | 4 | 30360.00 | unknown | ask | 7641.7600 | 0.5667 | ["7600","7605","7620"] | ["0.5090","0.4834","0.2768"] | ["7605","7620"] | ["XCBO"] | 7600.0000 | 7620.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:39:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b606-2608-7aa2-a2df-d3576ef0847e | SPY | 2026-09-18 15:37 | other | 4 | 2 | 100 | 60557.00 | unknown | ask | 761.0000 | 0.0400 | ["755","762","765","766"] | ["0.5769","0.0613","0.4108","0.0578"] | [] | ["XISX"] | 755.0000 | 766.0000 | 0 | 3 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:37:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b602-900f-7360-94d0-f0e77057997d | NBIS | 2026-09-18 15:33 | other | 3 | 1 | 44 | 101420.00 | unknown | ask | 221.3200 | 1.3000 | ["180","200","400"] | ["0.8048","0.8624","0.9395"] | [] | ["XISX"] | 180.0000 | 400.0000 | 42 | 91 | false | true | true | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:33:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-f02f-7393-a471-eeb65a54546e | SPX | 2026-09-18 15:30 | other | 5 | 1 | 14 | 26690.00 | unknown | ask | 7637.9300 | 0.5000 | ["7640","7645","7650"] | ["0.1347","0.1387","0.1601"] | ["7641.10"] | ["XCBO"] | 7640.0000 | 7650.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e6-6137-7202-acdb-9f17ba2db34f | SPY | 2026-09-18 15:02 | other | 4 | 2 | 153 | 26607.00 | unknown | ask | 761.2000 | 0.0400 | ["745","751","754","755"] | ["0.1319","0.0976","0.0890","0.1060"] | [] | ["ARCO","XISX"] | 745.0000 | 755.0000 | 3 | 5 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:02:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c9-8680-7b81-959e-f2a949790d2c | XLK | 2026-09-18 14:31 | other | 4 | 1 | 80 | 30080.00 | unknown | ask | 188.2350 | 0.4700 | ["185","188","191"] | ["0.2191","0.1929","0.1724"] | ["182.52","187.48","188.52","193.48"] | ["XISX"] | 185.0000 | 191.0000 | 7 | 7 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:31:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c1-c61f-7810-bc65-99562fdbfefb | SPY | 2026-09-18 14:22 | other | 4 | 2 | 49 | 27463.00 | unknown | ask | 760.4950 | 0.0400 | ["761","764","771","772"] | ["0.0959","0.0643","0.0877","0.0867"] | [] | ["XISX"] | 761.0000 | 772.0000 | 3 | 10 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:22:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c0-7248-7492-980d-f98cdae470a8 | NBIS | 2026-09-18 14:21 | other | 4 | 1 | 24 | 462840.00 | unknown | ask | 220.0100 | 11.2000 | ["170","175","180"] | ["7.0445","12.6756","0.7961"] | [] | ["C2OX"] | 170.0000 | 180.0000 | 0 | 28 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:21:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c0-280f-71b3-a406-a77fac2b7843 | SPX | 2026-09-18 14:21 | other | 6 | 2 | 25 | 56330.00 | unknown | ask | 7631.8700 | 0.5040 | ["7625","7630","7640","7650"] | ["0.1265","0.1219","0.1264","0.1362"] | ["7642.75"] | ["XCBO"] | 7625.0000 | 7650.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:21:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5af-95df-7200-bbcb-aeaba5468290 | META | 2026-09-18 14:02 | other | 3 | 2 | 4 | 35530.00 | unknown | ask | 671.8400 | 4.1500 | ["605","700"] | ["0.3842","0.3742"] | [] | ["C2OX","XCBO"] | 605.0000 | 700.0000 | 7 | 35 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:03:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ae-74d0-7b61-891b-95dfa70d3b40 | SPX | 2026-09-18 14:01 | other | 4 | 2 | 20 | 33560.00 | unknown | ask | 7629.3800 | 0.6000 | ["7520","7645","7650","7720"] | ["0.1239","0.1163","0.1258","0.0871"] | [] | ["XCBO"] | 7520.0000 | 7720.0000 | 0 | 11 | false | true | true | true | true | mesl | tracked | 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 |
| 01a0b595-6aa7-7323-bf27-cbbdcd800728 | SPX | 2026-09-18 13:34 | other | 6 | 1 | 10 | 97395.00 | unknown | ask | 7624.0600 | 1.3189 | ["7600","7650","7695"] | ["0.1384","0.1204","0.2336"] | ["7624.11"] | ["XCBO"] | 7600.0000 | 7695.0000 | 0 | 0 | false | false | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:34:46Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b582-b1af-7710-8051-6d481e901971 | NVDA | 2026-09-18 13:13 | other | 2 | 1 | 2 | 31900.00 | unknown | ask | 219.9401 | 2.8000 | ["100","240"] | ["0.4287","0.3536"] | [] | ["MCRY"] | 100.0000 | 240.0000 | 91 | 819 | false | false | true | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:14:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b579-c487-7d50-b009-ca956ed57816 | SPCX | 2026-09-18 13:04 | other | 3 | 1 | 216 | 31328.00 | unknown | ask | 151.7500 | 0.0400 | ["152.5","157.5","160"] | ["1.2541","1.4739","0.5191"] | [] | ["ARCO"] | 152.5000 | 160.0000 | 0 | 7 | false | true | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:04:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b537-700f-7602-b928-482e6aa11f56 | NVDA | 2026-09-18 11:51 | other | 4 | 1 | 600 | 38700.00 | unknown | ask | 219.5700 | 0.0500 | ["230"] | ["0.4628"] | [] | ["XISX"] | 230.0000 | 230.0000 | 0 | 10 | false | true | true | false | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:51:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51c-103f-7180-a545-463d5a786271 | COIN | 2026-09-18 11:21 | other | 3 | 1 | 58 | 325960.00 | unknown | ask | 192.5700 | 2.5700 | ["135","160","170"] | ["1.0383","0.6862","0.6487"] | ["78.80","193.10"] | ["EDGO"] | 135.0000 | 170.0000 | 7 | 7 | false | false | false | true | true | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:22:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4dd-70ff-7243-9d05-ad787b60109c | AMAT | 2026-09-18 10:13 | other | 4 | 5 | 15 | 135793.00 | unknown | ask | 428.4605 | 6.9636 | ["380","390","432.5","435"] | ["0.5120","0.5044","0.6793","0.6815"] | [] | ["MCRY","XISX","XPHO"] | 380.0000 | 435.0000 | 0 | 28 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:13:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d3-570f-7682-b02b-87b7fd1143e8 | SPY | 2026-09-18 10:02 | other | 4 | 3 | 100 | 35538.00 | unknown | ask | 759.1600 | 0.0400 | ["738","752","757","762"] | ["0.1589","0.1274","0.1757","0.1533"] | [] | ["ARCO","EMLD","XISX"] | 738.0000 | 762.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:02:38Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c8-5e77-7d82-8c80-d9c928bb52dd | META | 2026-09-18 09:50 | other | 3 | 1 | 13 | 49460.00 | unknown | ask | 674.9001 | 1.5000 | ["670","700","750"] | ["0.3801","0.3777","0.3842"] | ["707.46"] | ["XISX"] | 670.0000 | 750.0000 | 28 | 28 | false | true | false | true | true | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:50:29Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c3-0747-74b3-ade3-7f1ea244f956 | SNDK | 2026-09-18 09:44 | other | 3 | 1 | 6 | 36840.00 | unknown | ask | 1663.0950 | 1.8000 | ["1650","1750","1850"] | ["1.0469","0.6683","0.7172"] | [] | ["ARCO"] | 1650.0000 | 1850.0000 | 0 | 7 | false | false | true | true | false | mesl | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:44:33Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |