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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b593-e407-7323-b373-06d2f8c04f5c | AMD | 2026-09-18 13:32 | call_ratio_spread | 2 | 2 | 500 | 353250.00 | unknown | — | 545.3700 | 0.3600 | ["545","580"] | ["0.4210","0.4294"] | [] | ["AMXO"] | 545.0000 | 580.0000 | 5 | 5 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:32:58Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b547-3720-7401-ad47-224d6f28abee | AMD | 2026-09-18 12:08 | call_ratio_spread | 2 | 2 | 600 | 382200.00 | unknown | ask | 543.0000 | 0.2500 | ["545","580"] | ["0.4305","0.4328"] | ["557.74"] | ["AMXO"] | 545.0000 | 580.0000 | 5 | 5 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:08:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b52c-8ee7-7bd2-9f56-a5cb64afbc8c | RKT | 2026-09-18 11:39 | call_ratio_spread | 2 | 1 | 20000 | 1220000.00 | unknown | ask | 12.6000 | 0.0800 | ["13","14"] | ["0.5580","0.5481"] | ["14.07"] | ["ARCO"] | 13.0000 | 14.0000 | 28 | 28 | false | true | false | true | false | mlft | 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 |
| 01a0b52c-6bbf-7400-a735-6e545134e8d3 | WYNN | 2026-09-18 11:39 | call_ratio_spread | 2 | 1 | 2000 | 460000.00 | unknown | ask | 82.6900 | 0.4900 | ["90","97.5"] | ["0.3708","0.3596"] | ["94.6"] | ["SPHR"] | 90.0000 | 97.5000 | 63 | 63 | true | true | false | true | false | mlft | 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 |
| 01a0b4d8-f877-7142-8090-b633bd8db0f2 | SMH | 2026-09-18 10:08 | call_ratio_spread | 2 | 2 | 1000 | 1653500.00 | unknown | bid | 564.4400 | 1.9500 | ["565","600"] | ["0.3048","0.2968"] | ["598.07"] | ["AMXO"] | 565.0000 | 600.0000 | 28 | 28 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:08:42Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ca-759f-71f0-939c-6570d70613fd | AMD | 2026-09-18 09:52 | call_ratio_spread | 2 | 2 | 150 | 1012100.00 | unknown | ask | 549.9134 | 2.0500 | ["510","550"] | ["0.5037","0.4985"] | ["574.48"] | ["AMXO"] | 510.0000 | 550.0000 | 28 | 28 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:52:52Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c4-e7bf-7703-ad75-54ec95a318fe | FPS | 2026-09-18 09:46 | call_ratio_spread | 2 | 1 | 2800 | 1587000.00 | unknown | bid | 39.0800 | 0.8000 | ["37.5","40"] | ["0.6569","0.6913"] | ["41.98"] | ["XBOX"] | 37.5000 | 40.0000 | 28 | 28 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:46:44Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0f2-6fbb-7681-a115-ff209b0adb78 | AMD | 2026-09-17 15:57 | call_ratio_spread | 2 | 1 | 75 | 497500.00 | unknown | — | 546.0474 | 1.2500 | ["510","550"] | ["0.5256","0.5167"] | [] | ["XBOX"] | 510.0000 | 550.0000 | 29 | 29 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:58:06Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b086-118a-7ee2-bf90-3c261b7e55ec | KOPN | 2026-09-17 13:59 | call_ratio_spread | 2 | 2 | 4500 | 384000.00 | unknown | — | 4.7900 | 0.3500 | ["5","7"] | ["0.9064","0.9251"] | [] | ["ARCO"] | 5.0000 | 7.0000 | 92 | 92 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:59:44Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b002-faf3-70c0-978b-fcd426d61449 | MARA | 2026-09-17 11:36 | call_ratio_spread | 2 | 1 | 2000 | 180000.00 | unknown | — | 11.4450 | 0.0700 | ["13","18"] | ["0.8790","0.9171"] | [] | ["XPHO"] | 13.0000 | 18.0000 | 64 | 64 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T15:36:32Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afc4-964b-75a2-ab89-773d77f4ae2f | NRGV | 2026-09-17 10:28 | call_ratio_spread | 2 | 1 | 2000 | 195000.00 | unknown | — | 4.2250 | 0.6000 | ["4","7"] | ["1.0921","1.0848"] | [] | ["SPHR"] | 4.0000 | 7.0000 | 120 | 120 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:28:28Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0afa3-fe8b-7700-9ca4-1641519548d0 | GNRC | 2026-09-17 09:52 | call_ratio_spread | 2 | 1 | 132 | 108570.00 | unknown | — | 215.3350 | 2.8000 | ["210","220"] | ["1.3502","1.2596"] | [] | ["AMXO"] | 210.0000 | 220.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:52:47Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abbf-84e4-78b0-b33c-8656a1259bb3 | NRGV | 2026-09-16 15:44 | call_ratio_spread | 2 | 1 | 2000 | 161000.00 | unknown | — | 3.8550 | 0.5000 | ["4","7"] | ["1.1061","1.1446"] | [] | ["SPHR"] | 4.0000 | 7.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:44:30Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba6-ec03-7f12-81ac-9bd7529c99ad | BAC | 2026-09-16 15:17 | call_ratio_spread | 2 | 2 | 2000 | 466000.00 | unknown | — | 57.3750 | 0.2400 | ["60","65"] | ["0.2531","0.2449"] | [] | ["ARCO"] | 60.0000 | 65.0000 | 121 | 121 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab3e-f6bb-76c0-9e35-d4ebc16f4f2d | NDX | 2026-09-16 13:23 | call_ratio_spread | 2 | 1 | 24 | 1449432.00 | unknown | — | 0.0000 | 33.8000 | ["28500","31000"] | ["0.2019","0.1498"] | [] | ["XPHO"] | 28500.0000 | 31000.0000 | 30 | 30 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:24:04Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab11-a52b-7312-afce-c4967d8be100 | TLT | 2026-09-16 12:34 | call_ratio_spread | 2 | 3 | 16500 | 441375.00 | unknown | — | 81.1000 | 0.0200 | ["81.5","82"] | ["0.1833","0.1813"] | [] | ["AMXO"] | 81.5000 | 82.0000 | 2 | 2 | false | true | false | true | false | 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 |
| 01a0aa7f-9a73-78b0-bc00-fc14cc5408d8 | NUE | 2026-09-16 09:54 | call_ratio_spread | 2 | 1 | 1000 | 644000.00 | unknown | — | 264.1900 | 3.2500 | ["260","270"] | ["0.6094","0.6661"] | [] | ["XPHO"] | 260.0000 | 270.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:54:47Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a69c-9ade-75e0-94fd-2d3035bb4704 | SKHY | 2026-09-15 15:47 | call_ratio_spread | 2 | 1 | 300 | 856500.00 | unknown | — | 174.5500 | 3.1500 | ["150","210"] | ["0.5820","0.6300"] | [] | ["XBOX"] | 150.0000 | 210.0000 | 94 | 94 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:48:34Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a69c-4106-7be1-b99e-61931a2684db | CRM | 2026-09-15 15:47 | call_ratio_spread | 2 | 1 | 700 | 156100.00 | unknown | — | 255.1500 | 0.3300 | ["260","275"] | ["0.5812","0.5967"] | [] | ["XBOX"] | 260.0000 | 275.0000 | 3 | 3 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:47:53Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a67c-2e16-7163-955e-0a8699295769 | AMZN | 2026-09-15 15:12 | call_ratio_spread | 2 | 1 | 1100 | 626000.00 | unknown | — | 248.0850 | 0.1900 | ["285","320"] | ["0.3751","0.3849"] | [] | ["XBOX"] | 285.0000 | 320.0000 | 66 | 66 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:13:03Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a616-6766-7991-bc12-1ec098f1c9a7 | MU | 2026-09-15 13:21 | call_ratio_spread | 2 | 2 | 500 | 2355000.00 | unknown | — | 925.8800 | 5.5000 | ["1100","1600"] | ["0.5782","0.6235"] | [] | ["ARCO"] | 1100.0000 | 1600.0000 | 122 | 122 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:21:45Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a611-46e5-7441-9589-5b864ce5c913 | WULF | 2026-09-15 13:15 | call_ratio_spread | 2 | 1 | 46000 | 5382000.00 | unknown | — | 14.6550 | 0.1800 | ["17","23"] | ["0.9159","0.9049"] | [] | ["XPHO"] | 17.0000 | 23.0000 | 66 | 66 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:16:18Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5f7-42be-7630-aec2-8f8909640d67 | SNDK | 2026-09-15 12:47 | call_ratio_spread | 2 | 2 | 150 | 3745000.00 | unknown | — | 1527.5950 | 13.7000 | ["2000","3500"] | ["0.7288","0.7600"] | [] | ["ARCO"] | 2000.0000 | 3500.0000 | 275 | 275 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T16:47:29Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a7-8896-79e3-bb3f-948b114c82ba | NDX | 2026-09-15 11:20 | call_ratio_spread | 2 | 1 | 30 | 2254250.00 | unknown | — | 0.0000 | 71.2000 | ["28500","28975"] | ["0.2606","0.2263"] | [] | ["XPHO"] | 28500.0000 | 28975.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:20:25Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a5a1-56a6-76e3-b57d-43ada8567dc0 | GDX | 2026-09-15 11:13 | call_ratio_spread | 2 | 1 | 250 | 177500.00 | unknown | — | 93.0800 | 0.5000 | ["93","105"] | ["0.4528","0.4594"] | [] | ["SPHR"] | 93.0000 | 105.0000 | 66 | 66 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:13:39Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a57e-cece-7992-810e-9666a7d58fd2 | WULF | 2026-09-15 10:35 | call_ratio_spread | 2 | 1 | 1250 | 544000.00 | unknown | — | 14.9000 | 0.4100 | ["15","25"] | ["0.8803","0.8614"] | [] | ["SPHR"] | 15.0000 | 25.0000 | 185 | 185 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:36:02Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a56b-cb9e-7963-8843-6111808be150 | META | 2026-09-15 10:14 | call_ratio_spread | 2 | 1 | 463 | 6053260.00 | unknown | — | 669.9200 | 6.6000 | ["620","670"] | ["0.3971","0.4170"] | [] | ["XBOX"] | 620.0000 | 670.0000 | 94 | 94 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:14:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |