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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5ab-9287-7080-9200-2e3d74c4920e | GOOG | 2026-09-18 13:58 | put_diagonal_spread | 2 | 1 | 4000 | 2368000.00 | unknown | bid | 345.9240 | 0.3200 | ["315","320"] | ["0.3503","0.3020"] | [] | ["SPHR"] | 315.0000 | 320.0000 | 28 | 63 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:58:37Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b4-de03-7a83-baf1-d0905ac42e58 | GOOG | 2026-09-17 14:50 | other | 3 | 1 | 675 | 4530000.00 | unknown | — | 342.5200 | 7.1000 | ["365","380","410"] | ["1.0668","1.6198","0.3463"] | [] | ["XBOX"] | 365.0000 | 410.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:50:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b4-70a3-7963-9b98-b43ec50bae48 | GOOG | 2026-09-17 14:50 | other | 5 | 1 | 1875 | 35998140.00 | unknown | — | 342.6100 | 12.0500 | ["370","375","380","410","480"] | ["1.3928","1.4741","1.7766","2.5618","0.5195"] | [] | ["XBOX"] | 370.0000 | 480.0000 | 1 | 120 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:50:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b3-2c6b-76b2-a73a-c7ba1e05f87b | GOOG | 2026-09-17 14:48 | other | 6 | 1 | 2116 | 13294800.00 | unknown | — | 342.4340 | 13.9000 | ["360","380","385","390","400","410"] | ["0.9788","1.6350","1.7620","1.8990","2.1610","0.3356"] | [] | ["XBOX"] | 360.0000 | 410.0000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:48:46Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0ae-dedb-7a80-825f-0ab9daae0716 | GOOG | 2026-09-17 14:44 | put_vertical_spread | 2 | 1 | 140 | 1243200.00 | unknown | — | 342.1900 | 4.5500 | ["385","390"] | ["1.6950","1.8286"] | [] | ["XBOX"] | 385.0000 | 390.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:44:13Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b006-4a9b-77f2-b73e-1d30456695ab | GOOG | 2026-09-17 11:39 | put_calendar | 2 | 1 | 47 | 469107.00 | unknown | — | 343.5000 | 3.2500 | ["330"] | ["0.3739"] | [] | ["AMXO"] | 330.0000 | 330.0000 | 820 | 855 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:40:01Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a100-5fe1-7480-9a7c-cbbd67fbb836 | GOOG | 2026-09-14 13:39 | put_vertical_spread | 2 | 1 | 300 | 286500.00 | unknown | — | 345.8900 | 1.0500 | ["290","295"] | ["0.3544","0.3489"] | [] | ["AMXO"] | 290.0000 | 295.0000 | 95 | 95 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:39:45Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a08cbd-9391-7100-bf77-7f9ee0fe48cf | GOOG | 2026-09-10 15:13 | other | 3 | 1 | 80 | 1080480.00 | unknown | — | 330.5200 | 8.5500 | ["390","400","410"] | ["0.6981","0.7815","0.8613"] | [] | ["XPHO"] | 390.0000 | 410.0000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:14:04Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ca5-8750-7053-9354-daacbd09efe8 | GOOG | 2026-09-10 14:47 | other | 4 | 1 | 167 | 3366980.00 | unknown | — | 329.5762 | 9.3500 | ["352.5","390","400","480"] | ["1.0670","0.7038","0.9402","0.5311"] | [] | ["XBOX"] | 352.5000 | 480.0000 | 1 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:47:55Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c9f-5560-7e10-8d86-755959245633 | GOOG | 2026-09-10 14:40 | other | 6 | 1 | 993 | 17450132.00 | unknown | — | 329.7500 | 15.2500 | ["347.5","350","355","395","410","480"] | ["1.0567","1.0400","1.3457","0.9186","1.0600","0.5443"] | [] | ["XBOX"] | 347.5000 | 480.0000 | 1 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:41:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08769-3638-70a1-ab55-6526d838ce69 | GOOG | 2026-09-09 14:23 | put_vertical_spread | 2 | 1 | 30 | 404700.00 | unknown | — | 328.2450 | 3.9000 | ["390","400"] | ["0.7087","0.7890"] | [] | ["XBOX"] | 390.0000 | 400.0000 | 9 | 9 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:24:20Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081fe-5b10-7a82-9feb-55655e8e7abc | GOOG | 2026-09-08 13:08 | other | 2 | 1 | 181 | 82129.00 | unknown | — | 336.1002 | 0.3800 | ["400","440"] | ["0.3578","0.5828"] | [] | ["XBOX"] | 400.0000 | 440.0000 | 10 | 73 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:08:59Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |