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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c54e-db77-7bc3-8313-4e19b5d2faeb | MRVL | 2026-09-21 14:51 | put_ratio_spread | 2 | 1 | 675 | 2989350.00 | unknown | bid | 258.9201 | 1.0000 | ["170","240"] | ["0.6789","0.6854"] | ["173.57"] | ["XPHO"] | 170.0000 | 240.0000 | 269 | 269 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:51:25Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4a5-39af-7391-8b0a-404fef871db8 | MSFT | 2026-09-21 11:45 | put_ratio_spread | 2 | 1 | 300 | 1165600.00 | unknown | bid | 493.4900 | 1.6500 | ["380","490"] | ["0.3367","0.3182"] | ["431.72"] | ["XPHO"] | 380.0000 | 490.0000 | 269 | 269 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:46:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c460-510f-77d1-b513-ed031a4dcede | DOW | 2026-09-21 10:30 | put_ratio_spread | 2 | 1 | 3350 | 250100.00 | unknown | bid | 28.1600 | 0.1600 | ["27","27.5"] | ["0.4059","0.3928"] | ["27.33"] | ["SPHR"] | 27.0000 | 27.5000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:30:48Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b606-0e97-7b23-8b98-27ab3aa2cb28 | IEF | 2026-09-18 15:37 | put_ratio_spread | 2 | 1 | 18198 | 1113552.00 | unknown | bid | 90.8250 | 0.0600 | ["90","91"] | ["0.0746","0.0767"] | ["89.27"] | ["ARCO"] | 90.0000 | 91.0000 | 28 | 28 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:37:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5e1-fc37-73b3-a3fc-708fb7cfa7c6 | NET | 2026-09-18 14:57 | put_ratio_spread | 2 | 1 | 400 | 1272000.00 | unknown | bid | 322.7150 | 2.0500 | ["250","320"] | ["0.6050","0.5937"] | ["256.40"] | ["XBOX"] | 250.0000 | 320.0000 | 119 | 119 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:58:08Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b597-1c3f-7943-be26-a2787ba3c987 | TSM | 2026-09-18 13:36 | put_ratio_spread | 2 | 1 | 540 | 422550.00 | unknown | bid | 430.3300 | 0.7000 | ["380","430"] | ["0.3513","0.3243"] | ["351.70","419.62"] | ["XBOX"] | 380.0000 | 430.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:36:23Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b596-02ff-7ae3-8d6d-f88d0a024d68 | TSM | 2026-09-18 13:34 | put_ratio_spread | 2 | 1 | 540 | 766800.00 | unknown | bid | 430.1250 | 0.7000 | ["400","430"] | ["0.3337","0.3232"] | ["355.90","422.05"] | ["XBOX"] | 400.0000 | 430.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:35:19Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b570-140f-7ce3-949c-e2e5681e38e7 | QQQ | 2026-09-18 12:53 | put_ratio_spread | 2 | 2 | 75 | 342900.00 | unknown | bid | 716.6650 | 0.3400 | ["650","730"] | ["0.2481","0.2175"] | ["523","713.50"] | ["AMXO"] | 650.0000 | 730.0000 | 182 | 182 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:53:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55c-70b7-78f0-a84b-e2a7d08dde59 | AMD | 2026-09-18 12:32 | put_ratio_spread | 2 | 1 | 576 | 869760.00 | unknown | bid | 543.7450 | 0.6500 | ["470","540"] | ["0.5252","0.4851"] | ["415.20","524.80"] | ["ARCO"] | 470.0000 | 540.0000 | 21 | 21 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:32:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55c-6cd0-7c83-bf40-eb20962279c5 | COIN | 2026-09-18 12:32 | put_ratio_spread | 2 | 1 | 140 | 454790.00 | unknown | bid | 194.9600 | 1.6000 | ["185","190"] | ["0.7043","0.6961"] | ["161.33"] | ["SPHR"] | 185.0000 | 190.0000 | 91 | 91 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:32:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b535-9b50-7bf2-b642-65a309838c90 | KIE | 2026-09-18 11:49 | put_ratio_spread | 2 | 1 | 675 | 171900.00 | unknown | bid | 61.9200 | 0.8500 | ["61","63"] | ["0.2410","0.2362"] | ["57.80","62.60"] | ["AMXO"] | 61.0000 | 63.0000 | 28 | 28 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:50:18Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d4-f907-7311-a707-43b2b2e68ceb | TSLA | 2026-09-18 10:04 | put_ratio_spread | 2 | 2 | 576 | 976032.00 | unknown | bid | 364.7100 | 0.2700 | ["280","370"] | ["0.4938","0.4439"] | ["212.61","347.39"] | ["AMXO"] | 280.0000 | 370.0000 | 63 | 63 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |