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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b610-b910-7441-934b-282f1df0c018 | COIN | 2026-09-18 15:49 | call_vertical_spread | 2 | 1 | 100 | 135400.00 | short | bid | 194.4050 | 2.6500 | ["230","240"] | ["0.7138","0.7273"] | ["231.60"] | ["AMXO"] | 230.0000 | 240.0000 | 42 | 42 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:49:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b603-6eb8-7041-a266-0bc0926cfa11 | COIN | 2026-09-18 15:34 | call_diagonal_spread | 2 | 1 | 193 | 372500.00 | unknown | ask | 194.6300 | 1.3000 | ["185","200"] | ["5.6330","0.6561"] | [] | ["XBOX"] | 185.0000 | 200.0000 | 0 | 28 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:34:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ff-156f-7260-8fed-e0d366984220 | COIN | 2026-09-18 15:29 | call_diagonal_spread | 2 | 1 | 100 | 149000.00 | unknown | ask | 195.0700 | 0.9500 | ["187.5","195"] | ["3.3785","0.6585"] | [] | ["XBOX"] | 187.5000 | 195.0000 | 0 | 7 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:30:04Z"} | 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 |
| 01a0b542-9787-7350-84b3-ff9780809644 | COIN | 2026-09-18 12:03 | strangle | 2 | 1 | 400 | 908000.00 | short | bid | 192.2300 | 0.6500 | ["190","200"] | ["0.6339","0.6479"] | ["167.30","222.70"] | ["ARCO"] | 190.0000 | 200.0000 | 28 | 28 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:04:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0b1-480b-7af2-996c-5ca9e89e9385 | COIN | 2026-09-17 14:46 | put_vertical_spread | 2 | 1 | 83 | 1619330.00 | unknown | — | 172.1300 | 7.4000 | ["220","320"] | ["3.9951","7.6746"] | [] | ["XBOX"] | 220.0000 | 320.0000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T18:47:23Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0af8f-ce96-7da3-bd4d-52055bd203b2 | COIN | 2026-09-17 09:30 | put_diagonal_spread | 2 | 1 | 100 | 328600.00 | short | bid | 168.5350 | 7.0000 | ["180","182.5"] | ["0.6006","1.4131"] | [] | ["SPHR"] | 180.0000 | 182.5000 | 1 | 29 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T13:30:27Z"} | 2026-09-17 | 2026-09-17 17:27 | 2026-09-17 17:27 |
| 01a0abb2-55e3-7101-afc8-56790d119d5d | COIN | 2026-09-16 15:29 | other | 4 | 1 | 153 | 4932178.00 | unknown | — | 161.8100 | 20.5500 | ["207.5","280","300","340"] | ["2.5452","4.2697","4.6360","4.7257"] | [] | ["XBOX"] | 207.5000 | 340.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:29:57Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba8-f773-73a0-a77c-39677d058091 | COIN | 2026-09-16 15:19 | put_butterfly_spread | 3 | 1 | 110 | 3316760.00 | unknown | — | 161.9500 | 14.3000 | ["280","300","340"] | ["4.0613","4.1550","5.1069"] | [] | ["XBOX"] | 280.0000 | 340.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:19:35Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a697-f75e-7530-beb8-711d8654077c | COIN | 2026-09-15 15:42 | other | 4 | 1 | 153 | 6106472.00 | unknown | — | 172.3650 | 22.1500 | ["280","300","310","340"] | ["3.1289","3.8195","4.1787","4.6068"] | [] | ["XPHO"] | 280.0000 | 340.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:42:57Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a626-7c96-78c0-b48e-ff8622811b63 | COIN | 2026-09-15 13:38 | call_calendar | 2 | 2 | 600 | 620700.00 | unknown | — | 179.8500 | 0.8000 | ["180"] | ["0.8589"] | [] | ["AMXO"] | 180.0000 | 180.0000 | 3 | 10 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:39:08Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a55e-df06-79f1-afe4-ea948077c8b6 | COIN | 2026-09-15 10:00 | other | 4 | 1 | 134 | 558847.00 | unknown | — | 179.1750 | 2.3500 | ["170","175","185","190"] | ["0.6665","0.6640","0.6656","0.6777"] | [] | ["SPHR"] | 170.0000 | 190.0000 | 31 | 31 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:01:01Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a0ed-2dd0-7ad2-bf01-6a9af3743b38 | COIN | 2026-09-14 13:18 | risk_reversal | 2 | 2 | 500 | 2487500.00 | unknown | — | 191.3200 | 2.0500 | ["190","200"] | ["0.6993","0.7031"] | [] | ["AMXO"] | 190.0000 | 200.0000 | 95 | 95 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:18:40Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091e8-fc88-7e82-90f3-3d883b1ae475 | COIN | 2026-09-11 15:19 | other | 4 | 1 | 153 | 6107090.00 | unknown | — | 174.0600 | 20.5000 | ["280","300","310","340"] | ["1.9805","2.1639","2.1891","2.7356"] | [] | ["XBOX"] | 280.0000 | 340.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:19:28Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091e4-f160-7aa3-b819-1fd0c24894c1 | COIN | 2026-09-11 15:14 | other | 4 | 1 | 80 | 3118350.00 | unknown | — | 174.4400 | 20.5000 | ["280","300","310","340"] | ["2.1006","2.2984","2.3470","2.8551"] | [] | ["XBOX"] | 280.0000 | 340.0000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:14:56Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08cbe-d7c8-71d1-ad3f-685a2deed802 | COIN | 2026-09-10 15:15 | call_vertical_spread | 2 | 1 | 2580 | 709500.00 | short | bid | 173.5700 | 0.6100 | ["230","310"] | ["0.7205","0.8615"] | ["232.01"] | ["SPHR"] | 230.0000 | 310.0000 | 36 | 36 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:15:20Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb4-8b11-7073-b45c-f2204ef128d0 | COIN | 2026-09-10 15:03 | other | 7 | 1 | 484 | 10505412.00 | unknown | — | 173.7500 | 26.0500 | ["200","205","260","300","310","320","340"] | ["2.9048","3.1275","1.5951","2.5655","2.6855","2.8332","3.0096"] | [] | ["XBOX"] | 200.0000 | 340.0000 | 1 | 8 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:04:11Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c4d-64d1-70d0-86fa-98b80b8e1e7e | COIN | 2026-09-10 13:11 | other | 3 | 1 | 265 | 1176500.00 | unknown | — | 172.7900 | 1.8000 | ["140","150","170"] | ["0.6951","0.7239","0.6387"] | [] | ["XBOX"] | 140.0000 | 170.0000 | 8 | 498 | false | true | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:11:45Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086f0-e189-7230-93b4-0cc664bcdbca | COIN | 2026-09-09 12:12 | risk_reversal | 2 | 1 | 400 | 490000.00 | short | ask | 178.0600 | 0.8500 | ["175","182.5"] | ["0.6947","0.7122"] | ["174.91"] | ["AMXO"] | 175.0000 | 182.5000 | 9 | 9 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:12:37Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086be-7f18-7253-b748-273a99e94b31 | COIN | 2026-09-09 11:17 | strangle | 2 | 1 | 500 | 585000.00 | long | ask | 177.8450 | 0.5000 | ["175","185"] | ["0.7076","0.7337"] | ["163.30","196.70"] | ["AMXO"] | 175.0000 | 185.0000 | 9 | 9 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:17:11Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08274-b008-74e0-a72e-9039c6905c81 | COIN | 2026-09-08 15:17 | put_vertical_spread | 2 | 1 | 153 | 3776040.00 | unknown | — | 179.4850 | 9.1000 | ["300","310"] | ["2.0844","2.1502"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:18:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0826e-d021-7182-a676-47c100c344c8 | COIN | 2026-09-08 15:11 | put_vertical_spread | 2 | 1 | 110 | 2714800.00 | unknown | — | 179.4500 | 9.1000 | ["300","310"] | ["2.0780","2.1434"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:11:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06de5-bc05-7580-bae7-ba65d6d9d1cd | COIN | 2026-09-04 15:29 | put_vertical_spread | 2 | 1 | 153 | 3669552.00 | unknown | — | 185.1350 | 8.6500 | ["300","310"] | ["1.2354","1.3087"] | [] | ["XPHO"] | 300.0000 | 310.0000 | 14 | 14 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:29:44Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dd7-77ad-7f32-83a1-68f46250e28e | COIN | 2026-09-04 15:13 | put_vertical_spread | 2 | 1 | 153 | 3612330.00 | unknown | — | 184.7000 | 8.6500 | ["300","310"] | ["1.5726","1.7091"] | [] | ["XBOX"] | 300.0000 | 310.0000 | 14 | 14 | true | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:14:13Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |