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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c51a-a05f-7be3-a76d-edfba3435e97 | QQQ | 2026-09-21 13:54 | put_calendar | 2 | 1 | 300 | 674250.00 | long | ask | 739.7400 | 0.1400 | ["720"] | ["0.2036"] | [] | ["XPHO"] | 720.0000 | 720.0000 | 32 | 60 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:54:34Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c518-17ef-7123-8a82-fc1cc661d0e1 | TSLA | 2026-09-21 13:51 | put_calendar | 2 | 1 | 300 | 2056500.00 | long | ask | 374.0000 | 0.7000 | ["350"] | ["0.4603"] | [] | ["SPHR"] | 350.0000 | 350.0000 | 60 | 452 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:51:39Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c50c-775e-78b3-a5c2-187f02ef3b67 | USO | 2026-09-21 13:38 | put_calendar | 2 | 1 | 50 | 160400.00 | long | ask | 148.0400 | 2.7500 | ["125"] | ["0.4489"] | [] | ["SPHR"] | 125.0000 | 125.0000 | 543 | 634 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:39:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c508-f107-7db2-b271-72a81a17665c | USO | 2026-09-21 13:34 | put_calendar | 2 | 1 | 50 | 136500.00 | long | ask | 148.0300 | 4.3000 | ["120"] | ["0.4413"] | [] | ["SPHR"] | 120.0000 | 120.0000 | 543 | 634 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:35:17Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4aa-0056-73b3-9812-270d1218ef5f | TSM | 2026-09-21 11:51 | put_calendar | 2 | 1 | 600 | 2478000.00 | long | ask | 440.5350 | 0.6500 | ["440"] | ["0.3362"] | [] | ["ARCO"] | 440.0000 | 440.0000 | 25 | 88 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:51:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c482-485f-7c73-ad9c-ab6adbe97737 | GOOGL | 2026-09-21 11:07 | put_calendar | 2 | 1 | 750 | 2692500.00 | long | ask | 354.8150 | 1.5500 | ["350"] | ["0.3196"] | [] | ["AMXO"] | 350.0000 | 350.0000 | 25 | 179 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:07:56Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b60e-c50f-7532-9127-9a82f53a380d | MP | 2026-09-18 15:46 | put_calendar | 2 | 1 | 100 | 111700.00 | long | bid | 47.6201 | 1.0500 | ["53"] | ["8.3117"] | [] | ["SPHR"] | 53.0000 | 53.0000 | 0 | 14 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:47:05Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ce-704f-7fd1-8fb8-1fa6bc5fc40a | MU | 2026-09-18 14:36 | put_calendar | 2 | 1 | 60 | 346320.00 | long | bid | 1003.8000 | 0.9600 | ["930"] | ["1.3725"] | [] | ["SPHR"] | 930.0000 | 930.0000 | 0 | 63 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:36:54Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b577-efc7-78e3-9def-d1c967be5614 | TSM | 2026-09-18 13:02 | put_calendar | 2 | 2 | 450 | 2189250.00 | long | ask | 429.7450 | 1.7500 | ["430"] | ["0.3335"] | [] | ["ARCO"] | 430.0000 | 430.0000 | 63 | 91 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:02:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50c-1a4f-75f3-9b27-bb2c0070d503 | MU | 2026-09-18 11:04 | put_calendar | 2 | 2 | 360 | 1931400.00 | long | bid | 993.0237 | 0.3500 | ["950"] | ["0.5460"] | [] | ["ARCO"] | 950.0000 | 950.0000 | 7 | 28 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:04:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e0-10e0-7572-9194-88411584f07a | UBER | 2026-09-18 10:16 | put_calendar | 2 | 1 | 5445 | 3332340.00 | long | bid | 70.1000 | 0.4100 | ["73"] | ["0.6981"] | [] | ["AMXO"] | 73.0000 | 73.0000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:16:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-afc7-7ad0-9c37-f6f63642f5a5 | NBIS | 2026-09-18 10:11 | put_calendar | 2 | 1 | 445 | 1339450.00 | long | ask | 212.2500 | 1.5500 | ["225"] | ["1.1839"] | [] | ["SPHR"] | 225.0000 | 225.0000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0aff6-9ee3-7983-a174-891b5eade22c | PAL | 2026-09-17 11:22 | put_calendar | 2 | 1 | 1708 | 204960.00 | long | bid | 4.6300 | 0.4000 | ["5"] | ["1.0249"] | [] | ["SPHR"] | 5.0000 | 5.0000 | 1 | 120 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:23:30Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a62e-f876-7681-a159-1e20338c674d | SPCX | 2026-09-15 13:48 | put_calendar | 2 | 1 | 50 | 99450.00 | long | bid | 143.6200 | 0.8500 | ["152.5"] | ["0.5529"] | [] | ["SPHR"] | 152.5000 | 152.5000 | 3 | 10 | false | false | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:49:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a621-44a6-7cd0-9ffb-e45aa8f3170f | OPEN | 2026-09-15 13:33 | put_calendar | 2 | 1 | 200 | 105200.00 | long | bid | 2.6650 | 0.1800 | ["5"] | ["1.0091"] | [] | ["SPHR"] | 5.0000 | 5.0000 | 157 | 493 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:33:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a612-c99e-7920-a10a-2d4c8aaf6e77 | ZION | 2026-09-15 13:17 | put_calendar | 2 | 1 | 450 | 249300.00 | long | ask | 67.9400 | 2.0000 | ["70"] | ["0.3229"] | [] | ["XPHO"] | 70.0000 | 70.0000 | 3 | 31 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:18:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a176-91b0-7243-8545-0e4eb5f08132 | MDT | 2026-09-14 15:48 | put_calendar | 2 | 1 | 1293 | 250842.00 | long | ask | 93.9050 | 1.2700 | ["90"] | ["0.2868"] | [] | ["AMXO"] | 90.0000 | 90.0000 | 11 | 32 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:48:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03c-0258-7ea3-bf12-50a612230165 | QQQ | 2026-09-14 10:04 | put_calendar | 2 | 1 | 250 | 650750.00 | long | ask | 706.2400 | 0.1700 | ["705"] | ["0.1997"] | [] | ["AMXO"] | 705.0000 | 705.0000 | 18 | 32 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:05:02Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a032-e650-79e1-9d64-5936671de217 | USO | 2026-09-14 09:54 | put_calendar | 2 | 1 | 200 | 117400.00 | long | ask | 159.7250 | 0.8500 | ["155"] | ["0.6461"] | [] | ["SPHR"] | 155.0000 | 155.0000 | 2 | 11 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:54:48Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09147-d2b8-77f0-a8f1-db9a02ba7ca1 | LMND | 2026-09-11 12:23 | put_calendar | 2 | 1 | 1000 | 275000.00 | long | bid | 49.1800 | 0.8000 | ["50"] | ["0.8439"] | [] | ["XBOX"] | 50.0000 | 50.0000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:23:22Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cc8-2699-7482-b50b-be94337a01cb | GOOG | 2026-09-10 15:25 | put_calendar | 2 | 1 | 50 | 109650.00 | long | bid | 330.1350 | 0.9500 | ["340"] | ["0.3484"] | [] | ["SPHR"] | 340.0000 | 340.0000 | 1 | 8 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:25:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c1a-db50-7460-9ae2-4c86085e1a97 | KVYO | 2026-09-10 12:16 | put_calendar | 2 | 1 | 125 | 115750.00 | long | bid | 16.2100 | 0.7000 | ["20"] | ["0.7311"] | [] | ["SPHR"] | 20.0000 | 20.0000 | 36 | 127 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:16:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c16-6a99-7480-be48-d880f540c4ad | LULU | 2026-09-10 12:11 | put_calendar | 2 | 2 | 250 | 696250.00 | long | ask | 98.2900 | 1.4000 | ["100"] | ["0.4545"] | [] | ["ARCO"] | 100.0000 | 100.0000 | 71 | 498 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:11:14Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bc6-5a80-77a0-9325-c3896bfc4227 | VEL | 2026-09-10 10:43 | put_calendar | 2 | 1 | 2500 | 1437500.00 | long | ask | 17.8300 | 3.6500 | ["20"] | ["0.8339"] | [] | ["XBOX"] | 20.0000 | 20.0000 | 8 | 71 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:43:54Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0867b-28d0-7cb2-bc5f-f0e1c7655243 | DAL | 2026-09-09 10:03 | put_calendar | 2 | 1 | 300 | 336000.00 | long | bid | 78.2020 | 1.0000 | ["80"] | ["0.4110"] | [] | ["AMXO"] | 80.0000 | 80.0000 | 37 | 72 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:03:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08230-38b0-76d1-a6ca-63bcbd9f5ce2 | BE | 2026-09-08 14:03 | put_calendar | 2 | 1 | 60 | 309960.00 | long | bid | 282.5000 | 1.2000 | ["230"] | ["0.9286"] | [] | ["SPHR"] | 230.0000 | 230.0000 | 73 | 129 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:03:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06df1-ed1d-7722-bda6-6b5cfe637905 | OCGN | 2026-09-04 15:42 | put_calendar | 2 | 1 | 5000 | 100000.00 | long | ask | 1.3650 | 0.5500 | ["1"] | ["1.9258"] | [] | ["XPHO"] | 1.0000 | 1.0000 | 14 | 42 | true | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:43:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d90-dd75-7f91-b307-2bce7a27841d | AVGO | 2026-09-04 13:56 | put_calendar | 2 | 1 | 50 | 290050.00 | long | bid | 354.5901 | 0.9000 | ["360"] | ["0.3950"] | [] | ["SPHR"] | 360.0000 | 360.0000 | 77 | 105 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:56:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |