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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5cb-4f88-7822-9b2f-7b841a01f036 | QQQ | 2026-09-18 14:33 | ratio_risk_reversal | 2 | 2 | 420 | 221200.00 | long | ask | 717.8850 | 0.0200 | ["710","722"] | ["0.1603","0.1221"] | ["723.29"] | ["AMXO"] | 710.0000 | 722.0000 | 7 | 7 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:33:48Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5c5-294f-7cb2-8888-b84f8f3d5e4e | QQQ | 2026-09-18 14:26 | ratio_risk_reversal | 2 | 2 | 420 | 222880.00 | long | ask | 717.8060 | 0.0300 | ["710","722"] | ["0.1605","0.1235"] | ["723.29"] | ["AMXO"] | 710.0000 | 722.0000 | 7 | 7 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:26:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b51b-b668-7fa3-8b7d-95fbb1108cfe | MXEA | 2026-09-18 11:21 | ratio_risk_reversal | 2 | 2 | 249 | 573460.00 | long | bid | 3144.5800 | 30.8000 | ["3070","3190"] | ["0.1735","0.1074"] | ["3065.43"] | ["AMXO"] | 3070.0000 | 3190.0000 | 14 | 14 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:21:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab12-06d3-7d01-9fa4-f639dbbec335 | NDX | 2026-09-16 12:34 | ratio_risk_reversal | 2 | 1 | 40 | 1430800.00 | long | bid | 0.0000 | 30.1000 | ["28000","37000"] | ["0.2273","0.1904"] | ["27327"] | ["XPHO"] | 28000.0000 | 37000.0000 | 93 | 93 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:34:59Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a663-2005-7363-9134-ace131f2988e | MU | 2026-09-15 14:45 | ratio_risk_reversal | 2 | 2 | 150 | 3306000.00 | long | bid | 921.7900 | 7.0000 | ["950","1400"] | ["0.5801","0.6087"] | ["807"] | ["AMXO"] | 950.0000 | 1400.0000 | 275 | 275 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:45:11Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60d-5715-78f0-ac00-68c10e66c630 | IWM | 2026-09-15 13:11 | ratio_risk_reversal | 2 | 2 | 1200 | 156000.00 | long | bid | 285.2400 | 0.0400 | ["280","290"] | ["0.2963","0.2467"] | ["279.14"] | ["AMXO"] | 280.0000 | 290.0000 | 3 | 3 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:12:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a5-793d-7900-b9e0-7e6f3e71f398 | SMH | 2026-09-15 11:17 | ratio_risk_reversal | 2 | 1 | 400 | 1954200.00 | long | ask | 542.7150 | 6.6500 | ["400","620"] | ["0.4078","0.3554"] | ["638.39"] | ["XPHO"] | 400.0000 | 620.0000 | 367 | 367 | true | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:18:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a58b-9456-7050-a933-8c59b722782a | MRVL | 2026-09-15 10:49 | ratio_risk_reversal | 2 | 1 | 600 | 1662000.00 | long | ask | 223.7800 | 1.9500 | ["150","240"] | ["0.6561","0.6893"] | ["262.20"] | ["XPHO"] | 150.0000 | 240.0000 | 185 | 185 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:49:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a578-374e-7f33-a6d7-644910fb19f8 | ALAB | 2026-09-15 10:28 | ratio_risk_reversal | 2 | 1 | 600 | 1196100.00 | long | ask | 259.5300 | 3.7000 | ["180","330"] | ["0.8093","0.8414"] | ["335.95"] | ["XPHO"] | 180.0000 | 330.0000 | 94 | 94 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:29:06Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0c3-2be8-7bf0-8750-61bdfed742d6 | NDX | 2026-09-14 12:32 | ratio_risk_reversal | 2 | 1 | 38 | 1175004.00 | long | ask | 0.0000 | 35.0000 | ["26600","29800"] | ["0.2663","0.1687"] | ["29947.50"] | ["XPHO"] | 26600.0000 | 29800.0000 | 32 | 32 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:32:58Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090c6-eab8-7e92-b793-a40c74863ca4 | NXT | 2026-09-11 10:02 | ratio_risk_reversal | 2 | 1 | 350 | 301000.00 | long | bid | 82.5900 | 2.1000 | ["85","105"] | ["0.6533","0.7402"] | ["84.27"] | ["XBOX"] | 85.0000 | 105.0000 | 70 | 70 | true | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:02:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08c84-a558-7c02-9867-457ebb39f903 | TSM | 2026-09-10 14:11 | ratio_risk_reversal | 2 | 2 | 1350 | 623250.00 | long | ask | 429.8700 | 0.4800 | ["380","450"] | ["0.3481","0.3233"] | ["452.75"] | ["ARCO"] | 380.0000 | 450.0000 | 29 | 29 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:11:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c76-8810-72f0-a272-0596fa97593b | INTC | 2026-09-10 13:56 | ratio_risk_reversal | 2 | 2 | 2700 | 606600.00 | long | bid | 101.0750 | 0.1100 | ["105","120"] | ["0.6245","0.7022"] | ["99.70"] | ["ARCO"] | 105.0000 | 120.0000 | 8 | 8 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:56:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08684-ae50-72e2-867f-4a460b53bacc | AAPL | 2026-09-09 10:13 | ratio_risk_reversal | 2 | 1 | 360 | 164700.00 | long | bid | 316.0650 | 0.4100 | ["240","420"] | ["0.3254","0.2723"] | ["421.42"] | ["XPHO"] | 240.0000 | 420.0000 | 191 | 191 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:14:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0865d-adf1-79d3-8d52-dc546cfe4633 | BE | 2026-09-09 09:31 | ratio_risk_reversal | 2 | 1 | 60 | 128700.00 | long | ask | 276.7150 | 0.5800 | ["235","270"] | ["0.9091","0.9713"] | ["289.20"] | ["XBOX"] | 235.0000 | 270.0000 | 9 | 9 | false | false | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:31:29Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |