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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c581-6cc7-7f32-8541-424cbd191fdd | QCOM | 2026-09-21 15:46 | call_vertical_spread | 2 | 1 | 10 | 106870.00 | long | ask | 194.0000 | 3.3500 | ["200","250"] | ["0.4865","0.4971"] | ["214.01"] | ["XMIO"] | 200.0000 | 250.0000 | 816 | 816 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:46:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c560-38c7-77c2-8104-a93b2daf8159 | QCOM | 2026-09-21 15:10 | call_vertical_spread | 2 | 1 | 10 | 107390.00 | long | ask | 194.1500 | 2.5500 | ["200","250"] | ["0.4883","0.4983"] | ["214.07"] | ["XCBO"] | 200.0000 | 250.0000 | 816 | 816 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:10:42Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c559-6a97-7340-a307-e7728286f817 | QCOM | 2026-09-21 15:02 | put_vertical_spread | 2 | 1 | 19 | 116033.00 | long | ask | 193.5050 | 3.6500 | ["160","170"] | ["0.5474","0.5490"] | ["165.17"] | ["XCBO"] | 160.0000 | 170.0000 | 634 | 634 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:02:57Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4f7-7c47-74c3-84af-5401b9984d2e | QCOM | 2026-09-21 13:15 | call_vertical_spread | 2 | 1 | 10 | 104260.00 | long | ask | 192.3800 | 4.7000 | ["200","250"] | ["0.4839","0.4942"] | ["213.88"] | ["XCBO"] | 200.0000 | 250.0000 | 816 | 816 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:16:05Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4f6-e3ef-7d82-837f-1f5c35a9fc8c | QCOM | 2026-09-21 13:15 | call_vertical_spread | 2 | 1 | 10 | 104290.00 | long | ask | 192.3400 | 4.7500 | ["200","250"] | ["0.4844","0.4944"] | ["213.91"] | ["XCBO"] | 200.0000 | 250.0000 | 816 | 816 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:15:28Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4f0-ec97-7750-9fc1-0c943d79da0f | QCOM | 2026-09-21 13:08 | call_diagonal_spread | 2 | 1 | 10 | 114520.00 | long | ask | 193.0500 | 3.9500 | ["145","150"] | ["0.5112","0.4865"] | [] | ["XMIO"] | 145.0000 | 150.0000 | 88 | 361 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:08:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d3-90f7-7110-9719-c1696f30ca17 | QCOM | 2026-09-21 12:36 | call_vertical_spread | 2 | 1 | 10 | 103810.00 | long | ask | 192.3400 | 3.8000 | ["200","250"] | ["0.4813","0.4931"] | ["213.73"] | ["XCBO"] | 200.0000 | 250.0000 | 816 | 816 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:36:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4cf-2bf7-7792-b756-3d71f8ca7649 | QCOM | 2026-09-21 12:31 | call_vertical_spread | 2 | 1 | 10 | 103570.00 | long | ask | 191.6950 | 4.9000 | ["200","250"] | ["0.4847","0.4949"] | ["213.81"] | ["XCBO"] | 200.0000 | 250.0000 | 816 | 816 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:31:51Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a5-02ff-7b93-aea8-13f95bfe0993 | QCOM | 2026-09-21 11:45 | put_vertical_spread | 2 | 1 | 200 | 355200.00 | long | ask | 190.7700 | 1.3700 | ["130","180"] | ["0.5439","0.5216"] | ["166.62"] | ["XCBO"] | 130.0000 | 180.0000 | 116 | 116 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:45:50Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c49c-f097-74e2-9acd-4ff1fb644601 | QCOM | 2026-09-21 11:36 | call_vertical_spread | 2 | 1 | 46 | 141220.00 | long | ask | 190.5000 | 1.5000 | ["190","220"] | ["0.5198","0.5317"] | ["200.18"] | ["XCBO"] | 190.0000 | 220.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:36:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b56a-6ad7-7a03-b95b-f80aa582bf26 | QCOM | 2026-09-18 12:47 | call_vertical_spread | 2 | 1 | 21 | 117684.00 | long | ask | 176.2900 | 2.3500 | ["180","190"] | ["0.4816","0.4834"] | ["183.80"] | ["XCBO"] | 180.0000 | 190.0000 | 272 | 272 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:47:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e6-cb87-70e2-af15-6430c81ea4d8 | QCOM | 2026-09-18 10:23 | call_vertical_spread | 2 | 1 | 115 | 232530.00 | long | ask | 182.4050 | 1.7500 | ["170","175"] | ["1.7616","1.1948"] | ["174.98"] | ["AMXO"] | 170.0000 | 175.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:23:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d5-3b70-7d30-9eed-197027ab276c | QCOM | 2026-09-18 10:04 | put_vertical_spread | 2 | 1 | 100 | 196901.00 | long | ask | 182.8901 | 1.4000 | ["130","180"] | ["0.5084","0.4862"] | ["165.03"] | ["XCBO"] | 130.0000 | 180.0000 | 119 | 119 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:31Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a6a7-1676-7cf2-a922-3a5e7dc1ed01 | QCOM | 2026-09-15 15:59 | call_diagonal_spread | 2 | 1 | 157 | 310389.00 | short | ask | 187.7900 | 0.7000 | ["175","200"] | ["0.6198","0.5008"] | [] | ["EDGO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:59:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-e7dd-76c1-b26b-5a80af92bae0 | QCOM | 2026-09-15 15:56 | call_diagonal_spread | 2 | 1 | 158 | 315210.00 | short | ask | 187.8250 | 0.8000 | ["175","200"] | ["0.6488","0.5030"] | [] | ["EDGO"] | 175.0000 | 200.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:00Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a561-b596-7ab3-9ef0-ac6d49d50d57 | QCOM | 2026-09-15 10:03 | put_diagonal_spread | 2 | 1 | 26 | 158158.00 | long | ask | 189.1400 | 2.9500 | ["180","190"] | ["0.5140","0.5161"] | [] | ["XCBO"] | 180.0000 | 190.0000 | 275 | 367 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:04:15Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a147-28f8-75a0-8876-590d58de5458 | QCOM | 2026-09-14 14:56 | put_vertical_spread | 2 | 1 | 100 | 213601.00 | long | ask | 181.6600 | 0.7400 | ["130","180"] | ["0.5139","0.4937"] | ["164.12"] | ["XCBO"] | 130.0000 | 180.0000 | 123 | 123 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:56:44Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a05d-3e28-7653-a625-185799d3c135 | QCOM | 2026-09-14 10:40 | put_vertical_spread | 2 | 1 | 100 | 193703.00 | long | ask | 178.6000 | 0.8500 | ["140","170"] | ["0.4982","0.4894"] | ["159.97"] | ["XCBO"] | 140.0000 | 170.0000 | 123 | 123 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:40:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0865c-815f-7d03-a924-a47cdb17ab31 | QCOM | 2026-09-09 09:30 | put_vertical_spread | 2 | 1 | 100 | 213300.00 | long | ask | 174.7100 | 3.1500 | ["140","170"] | ["0.4891","0.4818"] | ["159.17"] | ["XISX"] | 140.0000 | 170.0000 | 128 | 128 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:30:03Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08234-f3a0-7e63-901d-69cc501770da | QCOM | 2026-09-08 14:08 | put_vertical_spread | 2 | 1 | 400 | 862000.00 | long | ask | 173.8700 | 1.2000 | ["140","170"] | ["0.4781","0.4758"] | ["158.85"] | ["XCBO"] | 140.0000 | 170.0000 | 129 | 129 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:09:20Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |