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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b604-c678-77c1-8ed8-72700cec0742 | CIFR | 2026-09-18 15:35 | call_vertical_spread | 2 | 1 | 2000 | 234000.00 | long | ask | 18.0800 | 0.0950 | ["21","26"] | ["0.9554","0.9691"] | ["21.69"] | ["XISX"] | 21.0000 | 26.0000 | 28 | 28 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:36:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fb-9acf-78e1-90e5-860995a9b73d | COIN | 2026-09-18 15:25 | call_vertical_spread | 2 | 1 | 1415 | 887205.00 | long | ask | 194.9000 | 0.3000 | ["202.5","212.5"] | ["0.6692","0.7029"] | ["204.65"] | ["EDGO"] | 202.5000 | 212.5000 | 7 | 7 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:26:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ea-29f8-7513-b676-3162bf05e016 | ALLY | 2026-09-18 15:06 | call_vertical_spread | 2 | 1 | 700 | 125300.00 | long | ask | 39.9400 | 0.1500 | ["40","42"] | ["0.2878","0.2701"] | ["40.81"] | ["XISX"] | 40.0000 | 42.0000 | 28 | 28 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:07:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5d1-a49f-7510-b425-46ed62b17d27 | XOM | 2026-09-18 14:40 | call_vertical_spread | 2 | 1 | 600 | 61200.00 | long | ask | 162.7400 | 0.1100 | ["167.5","172.5"] | ["0.2702","0.2838"] | ["168.1"] | ["EDGO"] | 167.5000 | 172.5000 | 7 | 7 | false | true | false | true | false | mlct | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:40:21Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59f-9c07-7d21-b78c-16a0db7ac9bb | GDX | 2026-09-18 13:45 | call_vertical_spread | 2 | 1 | 5000 | 2815000.00 | long | ask | 95.7950 | 0.3600 | ["110","125"] | ["0.4431","0.4621"] | ["112.25"] | ["AMXO"] | 110.0000 | 125.0000 | 91 | 91 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:45:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59f-3a60-7182-aa30-b8d6bbd3ee46 | GDX | 2026-09-18 13:45 | call_vertical_spread | 2 | 1 | 5000 | 2815000.00 | long | ask | 95.7850 | 0.3600 | ["110","125"] | ["0.4433","0.4622"] | ["112.25"] | ["AMXO"] | 110.0000 | 125.0000 | 91 | 91 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:45:17Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56e-9928-7ed3-bf1b-556551777f72 | CRCL | 2026-09-18 12:51 | call_vertical_spread | 2 | 1 | 625 | 249375.00 | long | ask | 91.0200 | 0.3700 | ["94","99"] | ["0.7644","0.7991"] | ["95.25"] | ["EDGO"] | 94.0000 | 99.0000 | 7 | 7 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:52:15Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55e-b6bf-7d02-86ca-f666bf3c33af | COIN | 2026-09-18 12:34 | call_vertical_spread | 2 | 1 | 1250 | 893750.00 | long | ask | 195.5600 | 0.5200 | ["202.5","212.5"] | ["0.6962","0.7309"] | ["204.81"] | ["EDGO"] | 202.5000 | 212.5000 | 7 | 7 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:34:41Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ea-423f-7750-a9b3-0b6bfd4d8bda | SOXX | 2026-09-18 10:27 | call_vertical_spread | 2 | 1 | 1500 | 5116500.00 | long | ask | 525.3518 | 4.6000 | ["560","580"] | ["0.3702","0.3671"] | ["565.95"] | ["AMXO"] | 560.0000 | 580.0000 | 63 | 63 | true | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:27:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e3-e557-79e1-8c5a-7b3f338cc837 | EWZ | 2026-09-18 10:20 | call_vertical_spread | 2 | 1 | 6000 | 1608000.00 | long | ask | 37.2900 | 0.0900 | ["40","46"] | ["0.4030","0.3903"] | ["41.42"] | ["SPHR"] | 40.0000 | 46.0000 | 91 | 91 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:20:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4e1-1697-7f91-98cf-e14064ad4391 | LQD | 2026-09-18 10:17 | call_vertical_spread | 2 | 1 | 20000 | 1180000.00 | long | ask | 104.6550 | 0.0900 | ["105","107"] | ["0.0487","0.0462"] | ["105.51"] | ["AMXO"] | 105.0000 | 107.0000 | 28 | 28 | false | true | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:17:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4c7-7fd0-72f1-8074-376271439237 | TRMD | 2026-09-18 09:49 | call_vertical_spread | 2 | 1 | 280 | 134120.00 | long | ask | 38.0600 | 0.5500 | ["35","40"] | ["0.4183","0.4271"] | ["37.65"] | ["XCBO"] | 35.0000 | 40.0000 | 28 | 28 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:49:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |