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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b606-aad7-7790-ab0c-9f52b9a65f19 | GOOG | 2026-09-18 15:38 | put_vertical_spread | 2 | 1 | 200 | 412200.00 | short | bid | 347.7150 | 0.7000 | ["290","330"] | ["0.3412","0.3279"] | ["319.55"] | ["SPHR"] | 290.0000 | 330.0000 | 119 | 119 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:38:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5a4-4b3f-7851-be4e-e1bbc3b62a81 | GOOG | 2026-09-18 13:50 | put_calendar | 2 | 1 | 50 | 26850.00 | short | bid | 345.5850 | 0.1800 | ["345"] | ["0.3268"] | [] | ["SPHR"] | 345.0000 | 345.0000 | 0 | 7 | false | true | true | false | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:50:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a667-f266-7853-a848-b2b86ce389d4 | GOOG | 2026-09-15 14:50 | call_diagonal_spread | 2 | 1 | 40 | 26400.00 | short | bid | 340.6200 | 0.3300 | ["360","400"] | ["0.3850","0.3334"] | [] | ["AMXO"] | 360.0000 | 400.0000 | 3 | 94 | false | true | true | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:50:47Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09202-1e21-7d93-9080-03bbc4fe6787 | GOOG | 2026-09-11 15:46 | call_vertical_spread | 2 | 1 | 68 | 38760.00 | short | bid | 335.8400 | 0.2200 | ["340","342.5"] | ["0.2630","0.2708"] | ["340.7"] | ["SPHR"] | 340.0000 | 342.5000 | 7 | 7 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:47:07Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a087ae-3261-7ef2-b136-61dabdefe550 | GOOG | 2026-09-09 15:38 | put_vertical_spread | 2 | 1 | 199 | 39800.00 | short | bid | 327.9600 | 0.1200 | ["315","325"] | ["0.3635","0.3139"] | ["323.50"] | ["SPHR"] | 315.0000 | 325.0000 | 2 | 2 | false | true | false | true | false | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:39:14Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087a3-0700-7b12-93a5-92aae0e2f5fe | GOOG | 2026-09-09 15:26 | straddle | 2 | 2 | 50 | 538500.00 | short | bid | 328.9600 | 1.5000 | ["330"] | ["0.3604"] | ["222.30","437.70"] | ["ARCO"] | 330.0000 | 330.0000 | 499 | 499 | false | false | false | false | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:27:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086ff-4cf1-7230-bedf-3c6282cb07ba | GOOG | 2026-09-09 12:27 | risk_reversal | 2 | 1 | 250 | 2899000.00 | short | ask | 327.3500 | 1.1000 | ["350","440"] | ["0.3828","0.3656"] | ["330.10"] | ["AMXO"] | 350.0000 | 440.0000 | 828 | 828 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:28:25Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086f7-1b48-7c00-b4ba-2feacdeb7682 | GOOG | 2026-09-09 12:18 | risk_reversal | 2 | 1 | 250 | 2899000.00 | short | ask | 326.9650 | 1.3000 | ["350","440"] | ["0.3821","0.3665"] | ["330.10"] | ["AMXO"] | 350.0000 | 440.0000 | 828 | 828 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:19:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08661-0d38-7e90-931f-941279001994 | GOOG | 2026-09-09 09:34 | put_vertical_spread | 2 | 1 | 1000 | 121000.00 | short | bid | 326.9800 | 0.1000 | ["315","317.5"] | ["0.4039","0.3888"] | ["317.25"] | ["XBOX"] | 315.0000 | 317.5000 | 2 | 2 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:35:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06ddc-cedd-71b2-8805-aa43114489cd | GOOG | 2026-09-04 15:19 | put_calendar | 2 | 1 | 96 | 229632.00 | short | ask | 335.9400 | 1.8500 | ["347.5"] | ["1.2311"] | [] | ["SPHR"] | 347.5000 | 347.5000 | 0 | 7 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:20:14Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |