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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c596-0e07-7631-8f3d-ff25bfa3c6af | QQQ | 2026-09-21 16:08 | other | 2 | 1 | 5000 | 7375000.00 | unknown | bid | 741.2900 | 0.1900 | ["725","775"] | ["0.1959","0.1847"] | [] | ["AMXO"] | 725.0000 | 775.0000 | 11 | 60 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T20:09:30Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c569-8f67-7322-894f-daa48354b289 | QQQ | 2026-09-21 15:20 | other | 6 | 1 | 3000 | 7011400.00 | unknown | bid | 741.7500 | 0.2200 | ["665","670","680","690","703","710"] | ["0.2528","0.2542","0.2416","0.2358","0.2170","0.2078"] | [] | ["AMXO"] | 665.0000 | 710.0000 | 25 | 88 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:20:46Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c54b-60d7-7b60-9a1a-8fc0d437ddcb | QQQ | 2026-09-21 14:47 | strangle | 2 | 1 | 2000 | 256000.00 | short | bid | 740.8850 | 0.0200 | ["710","755"] | ["0.2477","0.1624"] | ["708.72","756.28"] | ["ARCO"] | 710.0000 | 755.0000 | 4 | 4 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:47:31Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4e3-82fe-78e3-842f-fd3bebe0b61f | QQQ | 2026-09-21 12:53 | put_diagonal_spread | 2 | 1 | 2000 | 2574000.00 | long | bid | 738.5700 | 0.2600 | ["550","725"] | ["0.3196","0.1871"] | [] | ["AMXO"] | 550.0000 | 725.0000 | 25 | 179 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:54:04Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c468-8e6f-7231-9ac0-ec0f6f97b80c | QQQ | 2026-09-21 10:39 | call_vertical_spread | 2 | 1 | 1500 | 535500.00 | short | bid | 735.3000 | 0.0400 | ["850","860"] | ["0.1822","0.1835"] | ["850.47"] | ["AMXO"] | 850.0000 | 860.0000 | 88 | 88 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:40:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b620-1a90-7692-b6d9-18ad05371e44 | QQQ | 2026-09-18 16:05 | call_vertical_spread | 2 | 1 | 2500 | 1085000.00 | unknown | bid | 721.9700 | 0.1100 | ["750","760"] | ["0.1409","0.1396"] | ["754.34"] | ["AMXO"] | 750.0000 | 760.0000 | 28 | 28 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T20:06:22Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f1-9850-72f2-9665-8d000f84a7d9 | QQQ | 2026-09-18 15:15 | straddle | 2 | 1 | 1175 | 677975.00 | short | bid | 719.2600 | 0.1100 | ["725"] | ["0.4010"] | ["719.23","730.77"] | ["AMXO"] | 725.0000 | 725.0000 | 0 | 0 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:15:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5f1-4647-7d12-96fd-6f928cec39ee | QQQ | 2026-09-18 15:14 | risk_reversal | 2 | 1 | 1350 | 1250100.00 | short | bid | 719.1300 | 0.0600 | ["674","735"] | ["0.2258","0.1468"] | ["738.12"] | ["AMXO"] | 674.0000 | 735.0000 | 28 | 28 | false | true | false | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:14:50Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e9-c080-7513-92ac-4ae272161628 | QQQ | 2026-09-18 15:06 | straddle | 2 | 1 | 3000 | 1362000.00 | short | bid | 719.5000 | 0.0900 | ["715"] | ["0.3095"] | ["710.46","719.54"] | ["AMXO"] | 715.0000 | 715.0000 | 0 | 0 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:06:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e9-c080-7513-92ac-4ad727a6f0e4 | QQQ | 2026-09-18 15:06 | straddle | 2 | 1 | 1089 | 494406.00 | short | bid | 719.5000 | 0.0900 | ["715"] | ["0.3094"] | ["710.46","719.54"] | ["AMXO"] | 715.0000 | 715.0000 | 0 | 0 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:06:39Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b53a-0fef-75a0-8075-1b7b98fece96 | QQQ | 2026-09-18 11:54 | synthetic | 2 | 1 | 1850 | 5670250.00 | short | bid | 716.3150 | 0.2200 | ["705"] | ["0.1828"] | ["717.55"] | ["AMXO"] | 705.0000 | 705.0000 | 28 | 28 | false | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:54:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52c-7f47-7b71-81cb-1356f75e2ad3 | QQQ | 2026-09-18 11:39 | other | 2 | 1 | 1000 | 160000.00 | unknown | bid | 716.6000 | 0.0200 | ["710","725"] | ["0.1339","0.0996"] | [] | ["AMXO"] | 710.0000 | 725.0000 | 3 | 4 | false | true | true | true | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:40:00Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b504-a427-76b0-89df-532519d53059 | QQQ | 2026-09-18 10:56 | strangle | 2 | 1 | 2000 | 74000.00 | short | bid | 717.3900 | 0.0200 | ["710","720"] | ["0.2477","0.1691"] | ["709.63","720.37"] | ["AMXO"] | 710.0000 | 720.0000 | 0 | 0 | false | true | false | true | true | mlct | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:56:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4f2-50c0-72d2-b7f2-bc875c92688e | QQQ | 2026-09-18 10:36 | call_diagonal_spread | 2 | 1 | 3000 | 3558000.00 | short | bid | 716.5100 | 0.1300 | ["725","760"] | ["0.1440","0.1691"] | [] | ["ARCO"] | 725.0000 | 760.0000 | 14 | 63 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:36:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |