Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c573-5b36-71e2-a7c0-4dbd9d99fe39 | SMH | 2026-09-21 15:31 | call_ratio_spread | 2 | 1 | 1500 | 2206250.00 | unknown | ask | 596.6830 | 1.2000 | ["660","730"] | ["0.3561","0.3536"] | ["704.12"] | ["XBOX"] | 660.0000 | 730.0000 | 88 | 88 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T19:31:13Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c54c-d3ef-7bc1-a998-253bd4978865 | PCG | 2026-09-21 14:48 | call_ratio_spread | 2 | 1 | 15000 | 770000.00 | long | ask | 13.0500 | 0.1200 | ["15","20"] | ["0.5017","0.5104"] | ["15.53","28.94"] | ["XPHO"] | 15.0000 | 20.0000 | 88 | 88 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:49:04Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4ee-680e-70c1-a8be-80efa2541f8c | NFLX | 2026-09-21 13:05 | call_ratio_spread | 2 | 1 | 200 | 124400.00 | unknown | ask | 73.8050 | 0.1200 | ["70","74"] | ["0.3305","0.3242"] | ["73.72"] | ["SPHR"] | 70.0000 | 74.0000 | 25 | 25 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:06:19Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c465-b00f-7111-91e5-51fb1002e636 | BTDR | 2026-09-21 10:36 | call_ratio_spread | 2 | 1 | 2000 | 347000.00 | long | ask | 13.3500 | 0.2500 | ["15","21"] | ["0.9706","0.9745"] | ["15.47","26.53"] | ["ARCO"] | 15.0000 | 21.0000 | 88 | 88 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:36:33Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5db-87df-70c2-af5e-3eb72ec4bcc3 | FPS | 2026-09-18 14:50 | call_ratio_spread | 2 | 1 | 750 | 222000.00 | long | ask | 39.3150 | 0.6000 | ["45","55"] | ["0.7493","0.7327"] | ["46.44","72.12"] | ["SPHR"] | 45.0000 | 55.0000 | 63 | 63 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:51:00Z"} | 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 |
| 01a0b507-b54f-7460-862f-8b430fba0b70 | DKNG | 2026-09-18 10:59 | call_ratio_spread | 2 | 1 | 1275 | 198825.00 | long | ask | 22.7550 | 0.2800 | ["22","24"] | ["0.5297","0.5046"] | ["22.51","26.13"] | ["XBOX"] | 22.0000 | 24.0000 | 21 | 21 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:59:43Z"} | 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 |
| 01a0b0e9-1d03-7180-85d0-d4e5407d2948 | NBIS | 2026-09-17 15:47 | call_ratio_spread | 2 | 1 | 500 | 318000.00 | long | ask | 214.9550 | 0.4300 | ["250","300"] | ["0.8075","0.8459"] | ["253.60","346.40"] | ["SPHR"] | 250.0000 | 300.0000 | 29 | 29 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:47:55Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 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 |
| 01a0afdd-2373-7ae0-bca8-be55ac519c78 | SPY | 2026-09-17 10:54 | call_ratio_spread | 2 | 3 | 3508 | 213952.00 | long | ask | 760.6700 | 0.0200 | ["764","767"] | ["0.1193","0.1260"] | ["764.18","769.81"] | ["AMXO"] | 764.0000 | 767.0000 | 1 | 1 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:55:04Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0ab01-41db-7510-aeec-3e4bb1899eb5 | TLT | 2026-09-16 12:16 | call_ratio_spread | 2 | 1 | 16700 | 2404800.00 | long | ask | 81.1299 | 0.0800 | ["90","103"] | ["0.0771","0.1225"] | ["90.26","115.74"] | ["XBOX"] | 90.0000 | 103.0000 | 492 | 492 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T16:16:40Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a162-cb30-7801-9429-d3d31ccc62a7 | DRAM | 2026-09-14 15:26 | call_ratio_spread | 2 | 1 | 980 | 114170.00 | long | ask | 55.3950 | 0.1300 | ["57","64"] | ["0.6176","0.6412"] | ["58.09","69.91"] | ["AMXO"] | 57.0000 | 64.0000 | 11 | 11 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:26:54Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d1-6870-7af3-ab37-97a5923de5aa | SHAZ | 2026-09-14 12:47 | call_ratio_spread | 2 | 1 | 5000 | 2650000.00 | long | ask | 52.4600 | 2.3500 | ["65","90"] | ["1.1485","1.1168"] | ["67","113.00"] | ["XPHO"] | 65.0000 | 90.0000 | 67 | 67 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:48:06Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d0-a908-7f60-ab5f-e7be845ce7a5 | IREN | 2026-09-14 12:47 | call_ratio_spread | 2 | 1 | 1000 | 197500.00 | long | ask | 43.5200 | 0.2200 | ["60","85"] | ["0.9477","1.0057"] | ["61.19","108.81"] | ["SPHR"] | 60.0000 | 85.0000 | 67 | 67 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:47:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a8-5ca0-70b1-8620-5d6bc15b55fc | XLV | 2026-09-14 12:03 | call_ratio_spread | 2 | 1 | 2000 | 437000.00 | long | ask | 167.8000 | 0.5000 | ["165","170"] | ["0.2036","0.1906"] | ["167.21","172.79"] | ["SPHR"] | 165.0000 | 170.0000 | 4 | 4 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:03:35Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0a4-f588-7371-8b6f-fcf18262f9f5 | WULF | 2026-09-14 11:59 | call_ratio_spread | 2 | 1 | 1000 | 134500.00 | long | ask | 15.7150 | 0.1200 | ["18","23"] | ["0.8622","0.8701"] | ["18.37","27.63"] | ["XPHO"] | 18.0000 | 23.0000 | 67 | 67 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:59:20Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a050-3e08-76b3-b5d3-bad554b27c56 | GILD | 2026-09-14 10:26 | call_ratio_spread | 2 | 1 | 7896 | 3521616.00 | long | ask | 144.8700 | 0.7500 | ["150","165"] | ["0.3029","0.2867"] | ["152.60","177.40"] | ["SPHR"] | 150.0000 | 165.0000 | 67 | 67 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:26:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a02b-77f8-7452-9cd5-de9cf22487a9 | SLV | 2026-09-14 09:46 | call_ratio_spread | 2 | 1 | 5100 | 863200.00 | long | ask | 56.8300 | 0.1200 | ["73","85"] | ["0.5086","0.5595"] | ["73.29","101.72"] | ["XPHO"] | 73.0000 | 85.0000 | 95 | 95 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:46:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091cb-1c18-73e0-ba98-66f252d21469 | BHF | 2026-09-11 14:46 | call_ratio_spread | 2 | 2 | 1000 | 680000.00 | long | ask | 50.2300 | 4.5000 | ["55","60"] | ["0.7458","0.6612"] | ["66.40"] | ["AMXO"] | 55.0000 | 60.0000 | 98 | 98 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:46:47Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09162-1d30-7eb3-9f02-b6d39233f634 | META | 2026-09-11 12:51 | call_ratio_spread | 2 | 1 | 23 | 112828.00 | long | ask | 648.3299 | 1.8500 | ["650","970"] | ["0.4205","0.4300"] | ["704.50","1174.23"] | ["XPHO"] | 650.0000 | 970.0000 | 189 | 189 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:52:39Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09161-9c48-7b23-9bd9-10807cfbff11 | WYNN | 2026-09-11 12:51 | call_ratio_spread | 2 | 1 | 2484 | 664470.00 | long | ask | 88.3500 | 0.2600 | ["95","105"] | ["0.3598","0.3495"] | ["96.15","113.85"] | ["XPHO"] | 95.0000 | 105.0000 | 70 | 70 | true | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bac-5270-7302-946e-ae11d5873a5b | PCG | 2026-09-10 10:15 | call_ratio_spread | 2 | 1 | 40000 | 5220000.00 | long | ask | 14.2650 | 0.2400 | ["15","20"] | ["0.6340","0.6461"] | ["15.65","24.35"] | ["SPHR"] | 15.0000 | 20.0000 | 99 | 99 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:15:27Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0829e-6f88-7850-a665-0aca90ea3858 | IWM | 2026-09-08 16:03 | call_ratio_spread | 2 | 2 | 2000 | 607000.00 | long | ask | 294.6700 | 0.1200 | ["294","300"] | ["0.1647","0.1557"] | ["295.35","304.65"] | ["AMXO"] | 294.0000 | 300.0000 | 10 | 10 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T20:05:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813d-f911-7882-9183-74847bedf7c9 | NVDA | 2026-09-08 09:38 | call_ratio_spread | 2 | 1 | 250 | 203000.00 | long | ask | 230.6017 | 0.2000 | ["240","250"] | ["0.3521","0.3479"] | ["240.37","264.45"] | ["SPHR"] | 240.0000 | 250.0000 | 38 | 38 | false | true | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:38:45Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |