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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b50e-4500-7a40-b9ff-25d1e18d4107 | META | 2026-09-18 11:06 | synthetic | 2 | 2 | 2 | 61308.00 | long | ask | 680.5350 | 6.4000 | ["730"] | ["0.4356"] | ["732.02"] | ["XMIO"] | 730.0000 | 730.0000 | 637 | 637 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ff-413f-7990-bc15-f26bf973902f | META | 2026-09-18 10:50 | synthetic | 2 | 2 | 2 | 31580.00 | long | ask | 677.5700 | 2.6500 | ["670"] | ["0.4157"] | ["691.00"] | ["BATO","C2OX"] | 670.0000 | 670.0000 | 182 | 182 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:50:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ff-3d57-7183-b45d-e2d06e309f6b | META | 2026-09-18 10:50 | synthetic | 2 | 2 | 2 | 31576.00 | long | ask | 677.5700 | 2.6500 | ["670"] | ["0.4156"] | ["691.00"] | ["EMLD","SPHR"] | 670.0000 | 670.0000 | 182 | 182 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:50:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d8-92e7-7811-8376-194cd38e4d0e | META | 2026-09-18 10:08 | synthetic | 2 | 1 | 2 | 61358.00 | long | bid | 675.6000 | 4.3000 | ["730"] | ["0.4377"] | ["727.39"] | ["XISX"] | 730.0000 | 730.0000 | 637 | 637 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c7-31b0-7463-b046-c3be73ebc3dc | META | 2026-09-18 09:49 | synthetic | 2 | 4 | 4 | 62688.00 | short | bid | 671.8150 | 2.2500 | ["670"] | ["0.4152"] | ["685.30"] | ["BATO","C2OX","EMLD","SPHR"] | 670.0000 | 670.0000 | 182 | 182 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:49:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0e6-793b-75f3-91d2-3defd2b2d1de | META | 2026-09-17 15:44 | synthetic | 2 | 1 | 10 | 162040.00 | long | ask | 680.0208 | 2.3500 | ["590"] | ["0.4287"] | ["691.00"] | ["XISX"] | 590.0000 | 590.0000 | 155 | 155 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:44:51Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b02c-06c3-7600-9333-d1cb3e10e108 | META | 2026-09-17 12:21 | synthetic | 2 | 2 | 14 | 85064.00 | long | bid | 678.0100 | 0.2321 | ["700"] | ["0.3793"] | ["679.89"] | ["XISX","XPHO"] | 700.0000 | 700.0000 | 29 | 29 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:21:11Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abc5-3dbb-7300-96fb-5bb07ed068ca | META | 2026-09-16 15:50 | synthetic | 2 | 6 | 10 | 303132.00 | long | ask | 675.7200 | 11.6500 | ["710"] | ["0.4372"] | ["726.50"] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 710.0000 | 710.0000 | 639 | 639 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:50:31Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a594-98ee-78a1-b0fd-a7125bf69773 | META | 2026-09-15 10:59 | synthetic | 2 | 2 | 18 | 25164.00 | long | ask | 665.7750 | 0.1500 | ["665"] | ["0.5026"] | ["665.80"] | ["XISX","XPHO"] | 665.0000 | 665.0000 | 1 | 1 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:59:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a129-8ed8-7030-832c-3d051a36935e | META | 2026-09-14 14:24 | synthetic | 2 | 3 | 6 | 76560.00 | long | ask | 667.0600 | 1.0500 | ["630"] | ["0.4090"] | ["676.04"] | ["ARCO","XCBO","XISX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:24:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a124-d000-7a52-9229-916d7eee34f2 | META | 2026-09-14 14:18 | synthetic | 2 | 1 | 120 | 1525080.00 | short | bid | 665.4550 | 1.5000 | ["630"] | ["0.4090"] | ["674.45"] | ["ARCO"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:19:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d5-0a20-7562-973d-b4d9747065fd | META | 2026-09-14 12:51 | synthetic | 2 | 1 | 2 | 25176.00 | short | bid | 662.8500 | 1.8000 | ["630"] | ["0.4076"] | ["671.52"] | ["XCBO"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:51:56Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d1-9b38-7b20-b002-85799e8866b1 | META | 2026-09-14 12:48 | synthetic | 2 | 1 | 35 | 439810.00 | short | bid | 662.4050 | 1.0500 | ["630"] | ["0.4073"] | ["670.44"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:48:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b6-9540-7350-9ed1-2d26e0e295b1 | META | 2026-09-14 12:18 | synthetic | 2 | 1 | 3 | 37629.00 | short | bid | 661.4800 | 1.5500 | ["630"] | ["0.4075"] | ["669.53"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:19:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b5-7430-7572-9d95-06f10d07fefe | META | 2026-09-14 12:17 | synthetic | 2 | 1 | 2 | 25080.00 | short | bid | 661.4800 | 1.3500 | ["630"] | ["0.4074"] | ["669.50"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:17:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b4-4f38-7e20-bb6b-cf838570b5d7 | META | 2026-09-14 12:16 | synthetic | 2 | 2 | 2 | 25070.00 | short | bid | 661.1200 | 1.4000 | ["630"] | ["0.4076"] | ["669.25"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:16:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b3-ed90-7a20-8088-8990be600eb5 | META | 2026-09-14 12:15 | synthetic | 2 | 1 | 2 | 25050.00 | short | bid | 660.6337 | 1.9500 | ["630"] | ["0.4077"] | ["668.75"] | ["XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:15:52Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0b3-7c48-7152-b034-211db66c3628 | META | 2026-09-14 12:15 | synthetic | 2 | 2 | 25 | 312700.00 | short | bid | 660.1600 | 2.2500 | ["630"] | ["0.4076"] | ["667.76"] | ["XBOX","XMIO"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:15:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ae-2130-7491-aa66-eff8e990410b | META | 2026-09-14 12:09 | synthetic | 2 | 2 | 20 | 248740.00 | short | bid | 658.1500 | 1.7000 | ["630"] | ["0.4071"] | ["666.82"] | ["C2OX","XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:09:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0ae-1960-7763-a519-b4713c93909e | META | 2026-09-14 12:09 | synthetic | 2 | 2 | 50 | 621700.00 | unknown | — | 658.0000 | 2.2500 | ["630"] | ["0.4073"] | [] | ["ARCO","XBOX"] | 630.0000 | 630.0000 | 123 | 123 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:09:30Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a073-db38-7240-b96d-3e3b3b633663 | META | 2026-09-14 11:05 | synthetic | 2 | 2 | 3 | 47102.00 | long | ask | 653.0400 | 3.1000 | ["605"] | ["0.4192"] | ["666.50"] | ["C2OX","SPHR"] | 605.0000 | 605.0000 | 186 | 186 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:05:43Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09205-d358-7930-a4a6-d69e377cb316 | META | 2026-09-11 15:50 | synthetic | 2 | 1 | 10 | 63620.00 | long | ask | 647.0400 | 2.0000 | ["615"] | ["0.3676"] | ["649.12"] | ["XMIO"] | 615.0000 | 615.0000 | 35 | 35 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:51:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09126-e120-7490-96fd-bbd0048dfe48 | META | 2026-09-11 11:47 | synthetic | 2 | 1 | 25 | 311625.00 | short | bid | 652.1107 | 1.9000 | ["630"] | ["0.4088"] | ["660.25"] | ["XBOX"] | 630.0000 | 630.0000 | 126 | 126 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:47:44Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ea-9b70-71f0-b85d-35424ff7daaf | META | 2026-09-11 10:41 | synthetic | 2 | 2 | 25 | 314375.00 | short | bid | 653.4242 | 2.0500 | ["630"] | ["0.4115"] | ["661.59"] | ["XBOX","XMIO"] | 630.0000 | 630.0000 | 126 | 126 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:41:37Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b9-1b90-70d0-9f9c-d09c93968b54 | META | 2026-09-11 09:47 | synthetic | 2 | 3 | 18 | 54666.00 | short | ask | 659.9799 | 0.3472 | ["670"] | ["0.4003"] | ["660.39"] | ["MCRY","XISX","XPHO"] | 670.0000 | 670.0000 | 7 | 7 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:47:36Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c22-7888-73f1-ba98-6c3652cbe7be | META | 2026-09-10 12:24 | synthetic | 2 | 1 | 10 | 126700.00 | short | bid | 651.0250 | 1.4500 | ["650"] | ["0.4169"] | ["660.00"] | ["XPHO"] | 650.0000 | 650.0000 | 127 | 127 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:24:50Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba4-95f8-7dc0-9d0b-645594b5921d | META | 2026-09-10 10:06 | synthetic | 2 | 2 | 27 | 46143.00 | long | ask | 644.4550 | 0.3000 | ["635"] | ["0.5702"] | ["644.73"] | ["SPHR","XPHO"] | 635.0000 | 635.0000 | 1 | 1 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:07:05Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8b-2640-7c43-b0a3-fc09c3229eac | META | 2026-09-10 09:39 | synthetic | 2 | 1 | 3 | 35805.00 | long | bid | 658.1598 | 2.2500 | ["675"] | ["0.4333"] | ["664.77"] | ["XISX"] | 675.0000 | 675.0000 | 99 | 99 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:39:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0869f-f6b0-7e51-9e72-6fcac3a0bf03 | META | 2026-09-09 10:43 | synthetic | 2 | 1 | 6 | 54720.00 | long | bid | 645.4100 | 1.7000 | ["700"] | ["0.4187"] | ["699.80"] | ["XISX"] | 700.0000 | 700.0000 | 128 | 128 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:43:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0868a-24c0-74a2-9bd6-39ed03fd93ae | META | 2026-09-09 10:19 | synthetic | 2 | 4 | 21 | 75285.00 | long | ask | 646.1000 | 0.3500 | ["620"] | ["0.4047"] | ["646.72"] | ["EMLD","XISX","XPHO"] | 620.0000 | 620.0000 | 7 | 7 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:19:58Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08665-52f8-7ed2-b145-bef9dbfbfbed | META | 2026-09-09 09:39 | synthetic | 2 | 4 | 2 | 31640.00 | long | ask | 647.1850 | 5.4000 | ["610"] | ["0.4280"] | ["660.00"] | ["C2OX","SPHR"] | 610.0000 | 610.0000 | 191 | 191 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:40:00Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081fd-5558-7b63-b2f6-5dd6f2f39ee5 | META | 2026-09-08 13:07 | synthetic | 2 | 2 | 20 | 40040.00 | unknown | — | 618.3491 | 0.3500 | ["625"] | ["0.4301"] | [] | ["XISX"] | 625.0000 | 625.0000 | 3 | 3 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:08:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dd3-1695-7063-84f2-63408f28be72 | META | 2026-09-04 15:09 | synthetic | 2 | 1 | 10 | 58850.00 | short | bid | 614.8901 | 0.8000 | ["615"] | ["0.3548"] | ["617.43"] | ["XMIO"] | 615.0000 | 615.0000 | 42 | 42 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:09:09Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |