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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a06d2d-2235-7c12-8ca2-bb4c63712164 | CIFR | 2026-09-04 12:07 | call_vertical_spread | 2 | 2 | 4044 | 246684.00 | unknown | — | 17.6750 | 0.0700 | ["20","24"] | ["0.9105","1.0325"] | [] | ["AMXO"] | 20.0000 | 24.0000 | 14 | 14 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:08:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d99-c2cd-79f3-9407-8e3e278bd7ad | CIFR | 2026-09-04 14:06 | call_vertical_spread | 2 | 1 | 4312 | 616616.00 | short | bid | 17.6400 | 0.1100 | ["17.5","18.5"] | ["0.8469","0.8925"] | ["17.87"] | ["SPHR"] | 17.5000 | 18.5000 | 7 | 7 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:06:53Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06df6-bf7d-7ad0-8487-4df93bf57294 | CIFR | 2026-09-04 15:48 | other | 3 | 1 | 3750 | 1532500.00 | unknown | — | 17.7850 | 0.4300 | ["15","22","28"] | ["0.9668","1.0243","1.0430"] | [] | ["XBOX"] | 15.0000 | 28.0000 | 77 | 77 | false | true | false | true | true | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:48:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a0814f-98c8-7c62-af99-e47e6d923567 | CIFR | 2026-09-08 09:57 | other | 2 | 1 | 5000 | 587500.00 | unknown | — | 18.1050 | 0.1300 | ["18","19"] | ["1.3697","1.3192"] | [] | ["SPHR"] | 18.0000 | 19.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:58:09Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08260-4960-70b0-8a1e-da8bc6f26817 | CIFR | 2026-09-08 14:55 | other | 2 | 1 | 1994 | 327016.00 | unknown | — | 19.1750 | 0.4900 | ["25","34"] | ["1.0598","1.0719"] | [] | ["ARCO"] | 25.0000 | 34.0000 | 73 | 73 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:55:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08277-2cc1-7232-bf02-7b4f670c1ca7 | CIFR | 2026-09-08 15:20 | call_frontspread | 2 | 1 | 6500 | 1476000.00 | long | bid | 18.9800 | 0.2100 | ["17","20"] | ["1.1385","1.2898"] | ["18.97"] | ["SPHR"] | 17.0000 | 20.0000 | 3 | 3 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:21:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08667-6638-7cc2-b855-2dbbff37b488 | CIFR | 2026-09-09 09:41 | call_frontspread | 2 | 1 | 5000 | 473000.00 | long | bid | 18.1200 | 0.1800 | ["18","20"] | ["1.3252","1.5077"] | ["18.59"] | ["SPHR"] | 18.0000 | 20.0000 | 2 | 2 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:42:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08669-d738-73f1-ba57-84e1af1d6e8a | CIFR | 2026-09-09 09:44 | call_vertical_spread | 2 | 1 | 200 | 157200.00 | short | bid | 17.9600 | 1.0800 | ["16","24"] | ["1.0458","1.0213"] | ["18.70"] | ["SPHR"] | 16.0000 | 24.0000 | 128 | 128 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:44:41Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d5-4b08-75e2-ab57-195916aba02a | CIFR | 2026-09-09 11:41 | call_vertical_spread | 2 | 1 | 300 | 170100.00 | long | ask | 17.1900 | 0.2600 | ["19","24"] | ["1.0093","1.0028"] | ["20.31"] | ["SPHR"] | 19.0000 | 24.0000 | 128 | 128 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:42:17Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08b90-2781-72b3-aac1-af52d64ec34f | CIFR | 2026-09-10 09:44 | call_calendar | 2 | 1 | 700 | 170800.00 | long | ask | 15.4699 | 0.3800 | ["15.5"] | ["1.0105"] | [] | ["SPHR"] | 15.5000 | 15.5000 | 8 | 22 | false | true | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:44:48Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08ba1-bb80-7b71-ba17-d48e9b664911 | CIFR | 2026-09-10 10:03 | call_diagonal_spread | 2 | 1 | 900 | 171900.00 | long | ask | 15.5300 | 0.1800 | ["15.5","16.5"] | ["1.0490","1.0319"] | [] | ["SPHR"] | 15.5000 | 16.5000 | 8 | 15 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:04:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c08-5909-7e53-853a-3e4aca819230 | CIFR | 2026-09-10 11:55 | call_vertical_spread | 2 | 1 | 1050 | 212100.00 | long | ask | 16.0400 | 0.1800 | ["15.5","16.5"] | ["1.0304","1.0075"] | ["16.0"] | ["SPHR"] | 15.5000 | 16.5000 | 8 | 8 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:56:06Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c93-fb20-7cf3-9be7-d2ab45134bb5 | CIFR | 2026-09-10 14:28 | other | 4 | 1 | 100 | 141800.00 | unknown | — | 16.0200 | 1.7300 | ["10","12","26","30"] | ["1.1233","0.7163","1.0008","1.0570"] | [] | ["SPHR"] | 10.0000 | 30.0000 | 99 | 127 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:28:24Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cb2-54a8-75a0-b0fe-ed123450f4db | CIFR | 2026-09-10 15:01 | other | 6 | 1 | 452 | 573608.00 | unknown | — | 15.9200 | 3.1500 | ["20","20.5","21","21.5","22","22.5"] | ["3.0814","4.0753","4.3341","4.5821","4.8000","5.0498"] | [] | ["XBOX"] | 20.0000 | 22.5000 | 1 | 1 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:01:41Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a09194-9711-7d12-9469-4d3f3e0a581e | CIFR | 2026-09-11 13:47 | call_vertical_spread | 2 | 1 | 1000 | 153000.00 | long | ask | 17.3400 | 0.1500 | ["18","20"] | ["0.9752","0.9812"] | ["18.57"] | ["SPHR"] | 18.0000 | 20.0000 | 14 | 14 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:47:21Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091f9-09e9-7c70-a772-71886f88f1a4 | CIFR | 2026-09-11 15:36 | call_vertical_spread | 2 | 1 | 2000 | 234000.00 | long | ask | 17.0600 | 0.0900 | ["21","26"] | ["0.9946","1.0237"] | ["21.59"] | ["AMXO"] | 21.0000 | 26.0000 | 35 | 35 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:37:05Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0a575-223e-75f3-bc05-09b1777a8661 | CIFR | 2026-09-15 10:25 | call_backspread | 2 | 1 | 3750 | 870000.00 | long | bid | 15.2900 | 0.2200 | ["20","30"] | ["1.0164","1.0416"] | ["20.90","48.20"] | ["SPHR"] | 20.0000 | 30.0000 | 122 | 122 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0aac7-c31b-7cf1-a76c-6de13b0a2da0 | CIFR | 2026-09-16 11:13 | call_diagonal_spread | 2 | 1 | 300 | 120600.00 | short | bid | 17.4350 | 0.2000 | ["15","19"] | ["1.0101","1.1316"] | [] | ["SPHR"] | 15.0000 | 19.0000 | 9 | 30 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:13:50Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab9f-d783-73e2-827f-24d461605d8a | CIFR | 2026-09-16 15:09 | call_diagonal_spread | 2 | 1 | 600 | 654000.00 | short | bid | 16.5400 | 1.7000 | ["15","22"] | ["1.0482","1.0031"] | [] | ["SPHR"] | 15.0000 | 22.0000 | 121 | 492 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:09:37Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0afdd-b7e3-7e11-90fa-0fe842bfc32f | CIFR | 2026-09-17 10:55 | call_ratio_spread | 2 | 1 | 1000 | 155000.00 | long | ask | 17.3900 | 0.2900 | ["25","30"] | ["1.0135","0.9913"] | ["35.10"] | ["XBOX"] | 25.0000 | 30.0000 | 92 | 92 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:55:37Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b0b4-5d1a-71d3-b1e4-327e2f04f54c | CIFR | 2026-09-17 14:50 | put_ladder | 6 | 1 | 1578 | 2694252.00 | unknown | — | 17.1250 | 2.7600 | ["20.5","21","22","24","25","28"] | ["3.2036","2.6112","3.0502","3.8344","4.1893","5.1405"] | [] | ["XBOX"] | 20.5000 | 28.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:50:39Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b603-10f7-77c3-84af-ce17f4248926 | CIFR | 2026-09-18 15:34 | call_diagonal_spread | 2 | 1 | 550 | 182970.00 | unknown | ask | 18.0399 | 0.2800 | ["16","19"] | ["14.8677","0.9187"] | [] | ["SPHR"] | 16.0000 | 19.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:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |