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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
| 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 |
| 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 |