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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0aba6-ad83-78f1-be3a-11a5f106870f | OKLO | 2026-09-16 15:16 | put_butterfly_spread | 3 | 1 | 420 | 1465200.00 | unknown | — | 35.1300 | 4.1500 | ["50","55","60"] | ["3.9790","4.6729","4.6218"] | [] | ["XBOX"] | 50.0000 | 60.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:17:15Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae9-9f13-7861-b145-89b353287362 | SPY | 2026-09-16 11:50 | put_butterfly_spread | 3 | 3 | 500 | 630000.00 | unknown | — | 760.9201 | 0.1600 | ["690","725","755"] | ["0.2306","0.1850","0.1524"] | [] | ["AMXO"] | 690.0000 | 755.0000 | 44 | 44 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:51:19Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aadc-c603-7602-8574-bd4a52234b2a | QQQ | 2026-09-16 11:36 | put_butterfly_spread | 3 | 1 | 500 | 780750.00 | unknown | — | 710.5200 | 0.2200 | ["640","670","695"] | ["0.2753","0.2399","0.2123"] | [] | ["XBOX"] | 640.0000 | 695.0000 | 44 | 44 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:37:28Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aa69-479b-7410-88f5-c3bb56c062ef | USO | 2026-09-16 09:30 | put_butterfly_spread | 3 | 1 | 400 | 1059800.00 | short | bid | 159.2800 | 6.3500 | ["152","161","170"] | ["0.5496","0.5675","0.5824"] | ["152.95","169.05"] | ["SPHR"] | 152.0000 | 170.0000 | 44 | 44 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T13:30:23Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a68e-6626-7991-bfd6-cef3054f83f2 | CMG | 2026-09-15 15:32 | put_butterfly_spread | 3 | 1 | 500 | 538000.00 | unknown | — | 34.7600 | 2.2500 | ["39","40","42.5"] | ["0.7667","1.1715","2.3110"] | [] | ["XPHO"] | 39.0000 | 42.5000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:32:31Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a689-7c55-7f51-9d43-51a391c8ba6a | MU | 2026-09-15 15:27 | put_butterfly_spread | 3 | 1 | 51 | 1092480.00 | unknown | — | 923.0300 | 24.4000 | ["1025","1030","1035"] | ["1.6341","1.0240","1.8129"] | [] | ["XBOX"] | 1025.0000 | 1035.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:27:04Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a66a-5f7d-7513-b345-756976c15c70 | OKLO | 2026-09-15 14:53 | put_butterfly_spread | 3 | 1 | 800 | 2964000.00 | unknown | — | 36.0400 | 4.0000 | ["50","55","60"] | ["2.2672","2.7582","3.1890"] | [] | ["XPHO"] | 50.0000 | 60.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:53:17Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a628-3dcd-7541-a78c-4ccfa4607047 | IWM | 2026-09-15 13:40 | put_butterfly_spread | 3 | 2 | 1000 | 259000.00 | long | ask | 285.2100 | 0.0800 | ["260","270","280"] | ["0.3068","0.2574","0.2175"] | ["261.06","278.94"] | ["AMXO"] | 260.0000 | 280.0000 | 15 | 15 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:40:58Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08ca4-3f30-7401-9593-b13619ddc3fd | ORCL | 2026-09-10 14:46 | put_butterfly_spread | 3 | 1 | 300 | 243600.00 | long | ask | 155.1050 | 0.3400 | ["130","140","150"] | ["1.0356","1.0704","1.1217"] | ["131.80","148.20"] | ["SPHR"] | 130.0000 | 150.0000 | 8 | 8 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:46:12Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c97-9500-7de3-8cf6-17b6516b76b2 | CHTR | 2026-09-10 14:32 | put_butterfly_spread | 3 | 1 | 112 | 1576640.00 | unknown | — | 139.5000 | 22.2000 | ["200","210","220"] | ["2.1603","2.3466","2.4777"] | [] | ["XBOX"] | 200.0000 | 220.0000 | 8 | 8 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:32:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08137-5da8-7ec2-97f8-a9bf62163171 | SNDK | 2026-09-08 09:31 | put_butterfly_spread | 3 | 1 | 100 | 145500.00 | long | ask | 1782.1700 | 2.1500 | ["1350","1430","1510"] | ["0.9357","0.8641","0.8568"] | ["1355.10","1504.90"] | ["SPHR"] | 1350.0000 | 1510.0000 | 10 | 10 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:31:35Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |