core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0d4f9-6e7f-7720-901e-5d867cfc0c75 | COST | 2026-09-24 15:51 | call_diagonal_spread | 2 | 1 | 20 | 556900.00 | short | ask | 897.9400 | 15.8500 | ["760","770"] | ["0.2946","0.2339"] | [] | ["XISX"] | 760.0000 | 770.0000 | 22 | 85 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:52:11Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4e6-28e7-7520-a570-8bc1d3c9a75c | COST | 2026-09-24 15:30 | call_diagonal_spread | 2 | 4 | 37 | 356501.00 | long | ask | 897.6600 | 2.4000 | ["970","1000"] | ["0.2306","0.2363"] | [] | ["ARCO","EDGO","XBOX","XISX"] | 970.0000 | 1000.0000 | 176 | 358 | false | true | |||||||||||
| 01a0d4e6-1947-7430-a835-828af0446f78 | COST | 2026-09-24 15:30 | call_diagonal_spread | 2 | 4 | 37 | 293810.00 | unknown | ask | 897.9650 | 1.9000 | ["1010","1020"] | ["0.2320","0.2368"] | [] | ["ARCO","EDGO","XBOX","XISX"] | 1010.0000 | 1020.0000 | 176 | 358 | false | true | |||||||||||
| 01a0d4d5-350f-7b50-8c6a-4b11358f4c19 | COST | 2026-09-24 15:12 | call_diagonal_spread | 2 | 3 | 23 | 224386.00 | unknown | bid | 898.8000 | 1.8000 | ["970","1000"] | ["0.2310","0.2368"] | [] | ["AMXO","XCBO","XPHO"] | 970.0000 | 1000.0000 | 176 | 358 | false | true | |||||||||||
| 01a0d3bd-44ff-7c81-9206-85a306cb552c | COST | 2026-09-24 10:06 | call_diagonal_spread | 2 | 2 | 62 | 124062.00 | long | ask | 903.2500 | 1.4000 | ["915","930"] | ["0.7620","0.2817"] | [] | ["XBOX","XCBO"] | 915.0000 | 930.0000 | 1 | 15 | false | true | true | ||||||||||
| 01a0d3bd-4117-70d3-8c79-b15c677d8c0e | COST | 2026-09-24 10:06 | call_diagonal_spread | 2 | 3 | 55 | 108077.00 | long | ask | 903.2500 | 1.4000 | ["915","930"] | ["0.7548","0.2782"] | [] | ["AMXO","XCBO","XISX"] | 915.0000 | 930.0000 | 1 | 15 | false | true | true | ||||||||||
| 01a0cf1d-5326-7d63-9ac1-8b28b017930f | COST | 2026-09-23 12:33 | call_diagonal_spread | 2 | 1 | 23 | 149500.00 | long | ask | 898.4050 | 2.3000 | ["885","900"] | ["0.2527","0.2220"] | [] | ["C2OX"] | 885.0000 | 900.0000 | 23 | 58 | false | false | true | ||||||||||
| 01a0cebb-032f-7002-884b-9788eeaf0817 | COST | 2026-09-23 10:45 | call_diagonal_spread | 2 | 2 | 29 | 120524.00 | short | bid | 897.2300 | 3.4483 | ["875","910"] | ["0.3231","0.5715"] | [] | ["XISX"] | 875.0000 | 910.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0ce91-7677-7643-b81a-78b70e294f5b | COST | 2026-09-23 10:00 | call_diagonal_spread | 2 | 1 | 50 | 217961.00 | short | bid | 894.6700 | 5.6500 | ["870","905"] | ["0.3200","0.5578"] | [] | ["XISX"] | 870.0000 | 905.0000 | 2 | 9 | false | false | true | ||||||||||
| 01a0c9a3-aaef-7bb1-90bd-5e77ee5bf1e0 | COST | 2026-09-22 11:02 | call_diagonal_spread | 2 | 1 | 2 | 142402.00 | long | ask | 902.0700 | 16.0000 | ["610","620"] | ["0.2625","0.2609"] | [] | ["XCBO"] | 610.0000 | 620.0000 | 633 | 850 | false | false | true | ||||||||||
| 01a0c4cd-2857-7c40-8c52-7f7ec0f03a4e | COST | 2026-09-21 12:29 | call_diagonal_spread | 2 | 1 | 10 | 144440.00 | long | ask | 896.3700 | 7.0000 | ["850","860"] | ["0.2278","0.2268"] | [] | ["XMIO"] | 850.0000 | 860.0000 | 88 | 116 | false | false | true | ||||||||||
| 01a0c470-857f-7b72-81bc-68ba68151a39 | COST | 2026-09-21 10:48 | call_diagonal_spread | 2 | 1 | 6 | 192762.00 | long | ask | 893.9700 | 11.3500 | ["740","830"] | ["0.2011","0.2440"] | [] | ["XISX"] | 740.0000 | 830.0000 | 60 | 487 | false | false | true | ||||||||||
| 01a0b60e-76f0-7150-a376-2c2286b63a3f | COST | 2026-09-18 15:46 | call_diagonal_spread | 2 | 1 | 4 | 156684.00 | short | ask | 896.7700 | 9.7000 | ["700","740"] | ["21.6879","0.2544"] | [] | ["XPHO"] | 700.0000 | 740.0000 | 0 | 272 | false | false | true | ||||||||||
| 01a0b574-84c7-7a91-8b19-704d88548456 | COST | 2026-09-18 12:58 | call_diagonal_spread | 2 | 1 | 2 | 101746.00 | short | bid | 897.7500 | 15.2000 | ["520","860"] | ["0.2310","0.2283"] | [] | ["XCBO"] | 520.0000 | 860.0000 | 119 | 854 | false | false | true | ||||||||||
| 01a0aad1-ae2b-71b1-929e-ed22122adb36 | COST | 2026-09-16 11:24 | call_diagonal_spread | 2 | 1 | 100 | 195148.00 | long | bid | 900.6293 | 1.9500 | ["920","930"] | ["0.3079","0.2706"] | [] | ["XCBO"] | 920.0000 | 930.0000 | 9 | 16 | false | true | true | ||||||||||
| 01a0a59b-ccae-7512-a436-97c19e5062fb | COST | 2026-09-15 11:07 | call_diagonal_spread | 2 | 1 | 3 | 250656.00 | unknown | — | 908.3530 | 17.0000 | ["520","560"] | ["0.2901","0.2685"] | [] | ["XCBO"] | 520.0000 | 560.0000 | 493 | 822 | false | false | true | true | false | ||||||||
| 01a0a59b-43f6-7c61-80e9-7458e7c7ce78 | COST | 2026-09-15 11:06 | call_diagonal_spread | 2 | 1 | 6 | 501306.00 | unknown | — | 908.5000 | 17.0000 | ["520","560"] | ["0.2873","0.2675"] | [] | ["XCBO"] | 520.0000 | 560.0000 | 493 | 822 | false | false | true | true | false | ||||||||
| 01a0a080-1bf0-7213-80bb-5d5011f80a92 | COST | 2026-09-14 11:19 | call_diagonal_spread | 2 | 1 | 34 | 109480.00 | short | bid | 917.9000 | 4.5000 | ["910","925"] | ["0.2247","0.2624"] | [] | ["XPHO"] | 910.0000 | 925.0000 | 4 | 18 | false | false | true | ||||||||||
| 01a0869f-8d38-7781-a905-b64309bc685b | COST | 2026-09-09 10:43 | call_diagonal_spread | 2 | 1 | 23 | 1386348.00 | short | ask | 904.2450 | 14.1000 | ["600","620"] | ["0.9229","0.2283"] | [] | ["ARCO"] | 600.0000 | 620.0000 | 9 | 191 | false | false | true | ||||||||||
| 01a0868f-4158-7bc2-8dbb-2e0307d0826a | COST | 2026-09-09 10:25 | call_diagonal_spread | 2 | 2 | 6 | 189954.00 | long | ask | 903.5000 | 13.6000 | ["760","820"] | ["0.2847","0.2530"] | [] | ["AMXO"] | 760.0000 | 820.0000 | 100 | 373 | false | false | true |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:31:27Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:30:44Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:12:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:06:33Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:06:33Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:33:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:46:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:00:37Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:02:38Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:29:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:48:21Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:46:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:58:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:25:02Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:07:32Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:06:52Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:19:03Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:43:47Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:25:36Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |