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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b614-6677-76d2-9a1d-743a11dfe460 | SPCX | 2026-09-18 15:53 | put_diagonal_spread | 2 | 1 | 100 | 317800.00 | long | ask | 152.3701 | 0.7000 | ["160","175"] | ["6.2517","0.5119"] | [] | ["BATO"] | 160.0000 | 175.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:53:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b60c-2917-7a91-895a-a1730db31d86 | SPCX | 2026-09-18 15:44 | put_diagonal_spread | 2 | 1 | 100 | 261000.00 | long | ask | 152.5850 | 2.4500 | ["160","170"] | ["6.0790","0.5330"] | [] | ["XPHO"] | 160.0000 | 170.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:44:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b609-42e7-7ce3-bddf-9c0e9817308f | SPCX | 2026-09-18 15:40 | put_diagonal_spread | 2 | 1 | 20 | 41500.00 | long | ask | 152.5600 | 0.3500 | ["160","165"] | ["4.6446","0.5395"] | [] | ["XISX"] | 160.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b609-3eff-7352-b674-d70ad59cf077 | SPCX | 2026-09-18 15:40 | put_diagonal_spread | 2 | 1 | 20 | 41500.00 | long | ask | 152.5600 | 0.3500 | ["160","165"] | ["4.6446","0.5395"] | [] | ["XISX"] | 160.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b609-3eff-7352-b674-d6fdcd06b8e6 | SPCX | 2026-09-18 15:40 | put_diagonal_spread | 2 | 1 | 20 | 41500.00 | long | ask | 152.5600 | 0.3500 | ["160","165"] | ["4.6446","0.5395"] | [] | ["XISX"] | 160.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b609-3eff-7352-b674-d6e19e0d66bc | SPCX | 2026-09-18 15:40 | put_diagonal_spread | 2 | 1 | 20 | 41500.00 | long | ask | 152.5600 | 0.3500 | ["160","165"] | ["4.6446","0.5395"] | [] | ["XISX"] | 160.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b609-3eff-7352-b674-d6d441b32396 | SPCX | 2026-09-18 15:40 | put_diagonal_spread | 2 | 1 | 20 | 41500.00 | long | ask | 152.5600 | 0.3500 | ["160","165"] | ["4.6425","0.5395"] | [] | ["XISX"] | 160.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:41:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b607-720f-77b0-82d9-d0a7452592a2 | SPCX | 2026-09-18 15:38 | put_diagonal_spread | 2 | 1 | 50 | 107400.00 | long | ask | 152.7300 | 0.3500 | ["160","165"] | ["4.2293","0.5180"] | [] | ["XCBO"] | 160.0000 | 165.0000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:57Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b585-d65f-7213-83b9-e40c43882438 | SPCX | 2026-09-18 13:17 | put_diagonal_spread | 2 | 1 | 27 | 50544.00 | long | ask | 151.9550 | 0.3500 | ["80","100"] | ["0.5953","0.5816"] | [] | ["XISX"] | 80.0000 | 100.0000 | 455 | 637 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:17:29Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4bd-ac30-7cc2-a612-c2d51ecda623 | SPCX | 2026-09-18 09:38 | put_diagonal_spread | 2 | 1 | 15 | 26085.00 | long | ask | 154.3450 | 0.8000 | ["160","165"] | ["0.8290","0.5220"] | [] | ["XCBO"] | 160.0000 | 165.0000 | 0 | 7 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:38:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab18-447b-7f31-99bd-84222b2b6709 | SPCX | 2026-09-16 12:41 | put_diagonal_spread | 2 | 1 | 50 | 36100.00 | long | ask | 151.6000 | 0.1500 | ["148","152.5"] | ["0.5678","0.6921"] | [] | ["XMIO"] | 148.0000 | 152.5000 | 2 | 9 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:41:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aacf-a6a3-74c0-b3b4-39cbb85166d4 | SPCX | 2026-09-16 11:22 | put_diagonal_spread | 2 | 1 | 9 | 61128.00 | long | bid | 152.8100 | 4.5500 | ["135","155"] | ["0.5890","0.5783"] | [] | ["XMIO"] | 135.0000 | 155.0000 | 457 | 856 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:22:45Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a180-8490-7bd1-a350-163cd97348a3 | SPCX | 2026-09-14 15:59 | put_diagonal_spread | 2 | 1 | 50 | 138600.00 | long | ask | 148.1450 | 0.6500 | ["160","162.5"] | ["0.6039","0.5364"] | [] | ["AMXO"] | 160.0000 | 162.5000 | 4 | 11 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:59:21Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091fc-8871-71d2-8fd2-51c869bfbc4c | SPCX | 2026-09-11 15:40 | put_diagonal_spread | 2 | 1 | 50 | 35350.00 | long | ask | 151.7200 | 0.1100 | ["152.5","155"] | ["1.2785","0.5133"] | [] | ["SPHR"] | 152.5000 | 155.0000 | 0 | 7 | false | false | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:40:55Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091fa-fa00-7351-b948-1f2e5f0577c9 | SPCX | 2026-09-11 15:38 | put_diagonal_spread | 2 | 1 | 10 | 25660.00 | long | bid | 151.0460 | 0.8500 | ["110","125"] | ["0.5773","0.5646"] | [] | ["XCBO"] | 110.0000 | 125.0000 | 279 | 371 | false | true | true | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:39:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091ec-fbf8-7e13-a6e7-701191985985 | SPCX | 2026-09-11 15:23 | put_diagonal_spread | 2 | 3 | 27 | 25974.00 | long | ask | 149.8850 | 0.0600 | ["130","150"] | ["0.5492","0.4991"] | [] | ["BATO","C2OX","EDGO"] | 130.0000 | 150.0000 | 14 | 35 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:23:45Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c80-f408-7af0-8ce4-bf463b7412f0 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 3 | 39 | 37006.00 | long | ask | 149.6500 | 0.1300 | ["145","150"] | ["0.5271","0.6402"] | [] | ["ARCO","C2OX","EDGO"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-e850-7032-aaa7-fd035edb91a3 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 3 | 53 | 50380.00 | long | ask | 149.6300 | 0.1300 | ["145","150"] | ["0.5271","0.6396"] | [] | ["EDGO","XCBO","XISX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-e468-7ab2-adb5-55d8f5fa9a92 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 2 | 46 | 43892.00 | long | ask | 149.6000 | 0.1200 | ["145","150"] | ["0.5275","0.6403"] | [] | ["ARCO","XBOX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-c910-7ea0-bf50-ec146599080a | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 3 | 41 | 38578.00 | long | ask | 149.7396 | 0.1300 | ["145","150"] | ["0.5267","0.6423"] | [] | ["ARCO","C2OX","EDGO"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-b970-7fc2-a607-68748b9e6ca6 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 2 | 36 | 34060.00 | long | ask | 149.6900 | 0.1300 | ["145","150"] | ["0.5269","0.6440"] | [] | ["ARCO","XBOX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-b588-7c62-99c4-2f47d9abaa41 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 3 | 65 | 61403.00 | long | ask | 149.7000 | 0.1200 | ["145","150"] | ["0.5262","0.6437"] | [] | ["ARCO","C2OX","XCBO"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-adb8-7450-a2a1-984dde1584b7 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 3 | 39 | 36719.00 | long | ask | 149.7000 | 0.1300 | ["145","150"] | ["0.5252","0.6415"] | [] | ["ARCO","C2OX","XISX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-a9d0-7530-8a6a-c82e2cb2f014 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 2 | 28 | 26348.00 | long | ask | 149.6850 | 0.1200 | ["145","150"] | ["0.5249","0.6382"] | [] | ["ARCO","XISX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:08:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c80-9648-7c00-bc89-acedc510cbb4 | SPCX | 2026-09-10 14:07 | put_diagonal_spread | 2 | 5 | 38 | 36160.00 | long | ask | 149.6000 | 0.0853 | ["145","150"] | ["0.5253","0.6442"] | [] | ["ARCO","C2OX","EDGO","XCBO"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:07:13Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7f-03f0-7460-9b91-bbbf78a705ff | SPCX | 2026-09-10 14:05 | put_diagonal_spread | 2 | 2 | 27 | 25140.00 | long | ask | 149.8440 | 0.0700 | ["145","150"] | ["0.5246","0.6532"] | [] | ["ARCO","XBOX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:05:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c7f-0008-76e0-a50c-4f09346738e4 | SPCX | 2026-09-10 14:05 | put_diagonal_spread | 2 | 2 | 33 | 30696.00 | long | ask | 149.8402 | 0.0700 | ["145","150"] | ["0.5242","0.6511"] | [] | ["ARCO","XBOX"] | 145.0000 | 150.0000 | 1 | 36 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:05:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b9d-0860-7f40-a2e5-66b708f7e24a | SPCX | 2026-09-10 09:58 | put_diagonal_spread | 2 | 2 | 20 | 27828.00 | long | ask | 154.3400 | 0.5000 | ["150","160"] | ["0.6100","0.5801"] | [] | ["XPHO"] | 150.0000 | 160.0000 | 8 | 15 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:58:39Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b9a-58e0-7960-a486-93e1892744c7 | SPCX | 2026-09-10 09:55 | put_diagonal_spread | 2 | 2 | 540 | 250020.00 | long | ask | 153.6450 | 0.0698 | ["149","150"] | ["0.8321","0.6000"] | [] | ["ARCO"] | 149.0000 | 150.0000 | 1 | 8 | false | true | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:55:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08791-9629-7912-8e4b-9a0781e97e53 | SPCX | 2026-09-09 15:07 | put_diagonal_spread | 2 | 1 | 47 | 103118.00 | long | ask | 147.7500 | 0.2500 | ["155","157.5"] | ["0.5379","0.5295"] | [] | ["XPHO"] | 155.0000 | 157.5000 | 9 | 16 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:07:53Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ab-a2f8-70c2-81e6-bc616a39b2f8 | SPCX | 2026-09-09 10:56 | put_diagonal_spread | 2 | 1 | 16 | 112960.00 | long | ask | 149.0250 | 2.4500 | ["155","210"] | ["0.6337","0.5861"] | [] | ["XISX"] | 155.0000 | 210.0000 | 2 | 128 | false | false | true | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:56:47Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081a0-d990-7d12-8411-b99ccde2a976 | SPCX | 2026-09-08 11:26 | put_diagonal_spread | 2 | 1 | 7 | 58072.00 | long | bid | 151.3000 | 1.9000 | ["170","200"] | ["0.5630","0.6064"] | [] | ["XISX"] | 170.0000 | 200.0000 | 101 | 129 | false | false | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:26:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |