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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e0-0450-7553-a0f7-1f8adb0925bb | HUT | 2026-09-18 14:55 | call_vertical_spread | 2 | 1 | 200 | 114600.00 | long | ask | 94.8700 | 1.6300 | ["140","180"] | ["0.9725","1.0036"] | ["142.73"] | ["XISX"] | 140.0000 | 180.0000 | 63 | 63 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:56:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ba-6840-7453-acc6-9df402aa9116 | HUT | 2026-09-18 09:35 | call_vertical_spread | 2 | 1 | 435 | 331035.00 | short | bid | 91.9900 | 4.9800 | ["88","89"] | ["1.4877","1.4235"] | ["88.87"] | ["AMXO"] | 88.0000 | 89.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:35:11Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0eb-18d3-7341-9847-9bc3e28519fd | HUT | 2026-09-17 15:49 | call_vertical_spread | 2 | 1 | 435 | 100485.00 | short | bid | 90.6350 | 0.6800 | ["102","110"] | ["0.9679","1.0163"] | ["102.89"] | ["AMXO"] | 102.0000 | 110.0000 | 8 | 8 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:49:56Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0b037-8bfb-7cb2-8ad5-5ff8f8692a24 | HUT | 2026-09-17 12:33 | call_vertical_spread | 2 | 1 | 200 | 115600.00 | unknown | — | 91.6600 | 2.5300 | ["140","180"] | ["1.0214","1.0585"] | [] | ["XISX"] | 140.0000 | 180.0000 | 64 | 64 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T16:34:05Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb6-70ab-7042-a18c-95b5d67d192c | HUT | 2026-09-16 15:34 | call_vertical_spread | 2 | 1 | 12 | 109956.00 | long | ask | 89.8200 | 4.2500 | ["90","100"] | ["0.8742","0.8725"] | ["92.45"] | ["XMIO"] | 90.0000 | 100.0000 | 856 | 856 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:34:16Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab30-e52b-7721-985c-80b88aa23455 | HUT | 2026-09-16 13:08 | call_vertical_spread | 2 | 1 | 144 | 634752.00 | short | bid | 91.3250 | 6.1500 | ["195","210"] | ["0.8641","0.8596"] | ["196.82"] | ["XCBO"] | 195.0000 | 210.0000 | 639 | 639 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:09:01Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a0f6-3650-7a31-8c8c-295b1a1d3873 | HUT | 2026-09-14 13:28 | call_vertical_spread | 2 | 1 | 22 | 153406.00 | unknown | — | 91.5700 | 3.1500 | ["100","110"] | ["0.9095","0.9057"] | [] | ["XCBO"] | 100.0000 | 110.0000 | 494 | 494 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:28:18Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091d1-9071-7250-8826-7b9888cf5619 | HUT | 2026-09-11 14:53 | call_vertical_spread | 2 | 1 | 425 | 519350.00 | long | ask | 98.9000 | 4.8500 | ["91","95"] | ["5.3127","3.1109"] | ["95"] | ["EDGO"] | 91.0000 | 95.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:54:18Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0910a-c9b8-7640-819b-24305c2be99d | HUT | 2026-09-11 11:16 | call_vertical_spread | 2 | 1 | 425 | 232900.00 | unknown | — | 100.2000 | 1.6300 | ["104","109"] | ["0.9084","0.9117"] | [] | ["AMXO"] | 104.0000 | 109.0000 | 7 | 7 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:16:49Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b7-6228-7b81-893f-28fd676d88a3 | HUT | 2026-09-11 09:45 | call_vertical_spread | 2 | 2 | 11 | 108647.00 | short | bid | 94.1000 | 6.6500 | ["90","95"] | ["0.8860","0.8842"] | ["91.35"] | ["XMIO"] | 90.0000 | 95.0000 | 826 | 826 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:45:42Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090b3-62b9-79a2-8755-e1758813ac07 | HUT | 2026-09-11 09:41 | call_vertical_spread | 2 | 1 | 11 | 109582.00 | long | ask | 93.5000 | 5.2000 | ["85","90"] | ["0.8758","0.8745"] | ["86.40"] | ["XCBO"] | 85.0000 | 90.0000 | 826 | 826 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:41:23Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b8c-5ad9-71d0-b3dd-2ac329250d06 | HUT | 2026-09-10 09:40 | call_vertical_spread | 2 | 1 | 10 | 105040.00 | long | ask | 90.7200 | 6.2500 | ["70","80"] | ["0.9151","0.9115"] | ["73"] | ["XCBO"] | 70.0000 | 80.0000 | 827 | 827 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:40:36Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06dd6-9cee-7873-9f34-4d80e8f361c1 | HUT | 2026-09-04 15:12 | call_vertical_spread | 2 | 1 | 434 | 628432.00 | long | ask | 89.9300 | 2.8000 | ["81","85"] | ["8.4774","5.4263"] | ["85"] | ["EDGO"] | 81.0000 | 85.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:12:56Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |