core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d4bd-5b97-72d0-97fe-25a3870b4203 | UPS | 2026-09-24 14:46 | other | 5 | 1 | 1940 | 3762120.00 | unknown | bid | 91.7800 | 5.6500 | ["96","97","99","105","110"] | ["1.1789","0.9263","1.0347","0.4543","0.5755"] | [] | ["XBOX"] | 96.0000 | 110.0000 | 1 | 22 | false | false | true | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T18:46:58Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4bb-e497-72e2-8129-be822aedfbcd | UPS | 2026-09-24 14:44 | other | 4 | 1 | 802 | 1662360.00 | unknown | bid | 91.8350 | 4.0000 | ["98","100","105"] | ["0.9296","1.2027","0.4681"] | [] | ["XBOX"] | 98.0000 | 105.0000 | 1 | 22 | false | false | |||||||||||
| 01a0d4ba-988f-7231-8399-cd59218f9c70 | UPS | 2026-09-24 14:43 | put_calendar | 2 | 1 | 400 | 1549200.00 | long | bid | 91.7893 | 1.5500 | ["110"] | ["0.4002"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 85 | 113 | false | false | true | ||||||||||
| 01a0ce8c-dac7-7703-8243-484a4da56323 | UPS | 2026-09-23 09:55 | put_ratio_spread | 2 | 3 | 94 | 380489.00 | unknown | bid | 95.5900 | 2.3500 | ["120","125"] | ["0.4286","0.4630"] | ["94.35"] | ["XCBO","XISX","XPHO"] | 120.0000 | 125.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ce81-9fc6-70a2-bc67-9a6c86afac13 | UPS | 2026-09-23 09:43 | put_ratio_spread | 2 | 2 | 34 | 137207.00 | unknown | bid | 95.5787 | 2.3500 | ["120","125"] | ["0.4242","0.4540"] | ["94.35"] | ["XCBO"] | 120.0000 | 125.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ce81-9fc6-70a2-bc67-9a581ecd4b52 | UPS | 2026-09-23 09:43 | put_ratio_spread | 2 | 4 | 76 | 307786.00 | unknown | bid | 95.5787 | 2.3500 | ["120","125"] | ["0.4287","0.4638"] | ["94.35"] | ["AMXO","ARCO","XISX","XMIO"] | 120.0000 | 125.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ce81-9fc6-70a2-bc67-9a376072226e | UPS | 2026-09-23 09:43 | put_ratio_spread | 2 | 3 | 78 | 315381.00 | unknown | bid | 95.5787 | 2.3500 | ["120","125"] | ["0.4267","0.4593"] | ["94.35"] | ["EDGO","XCBO","XPHO"] | 120.0000 | 125.0000 | 114 | 114 | false | false | |||||||||||
| 01a0ca2f-f4fe-7f20-b1af-e257dc62b594 | UPS | 2026-09-22 13:35 | ratio_risk_reversal | 2 | 1 | 1200 | 519000.00 | short | bid | 95.7300 | 0.2500 | ["90","100"] | ["0.3614","0.2990"] | ["88.76"] | ["SPHR"] | 90.0000 | 100.0000 | 59 | 59 | false | true | |||||||||||
| 01a0c527-1baf-77d1-bcd6-a101cd597bdc | UPS | 2026-09-21 14:07 | put_vertical_spread | 2 | 1 | 250 | 207500.00 | short | bid | 94.5550 | 0.2800 | ["85","95"] | ["0.3421","0.3461"] | ["91.02"] | ["XMIO"] | 85.0000 | 95.0000 | 88 | 88 | false | false | |||||||||||
| 01a0ab22-9903-7602-9633-7891f22db800 | UPS | 2026-09-16 12:52 | straddle | 2 | 1 | 43 | 115369.00 | short | bid | 99.4699 | 0.3500 | ["105"] | ["0.2940"] | ["78.17","131.83"] | ["XCBO"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0ab22-8d4b-70e2-81b0-af303df52312 | UPS | 2026-09-16 12:52 | straddle | 2 | 2 | 62 | 166525.00 | short | bid | 99.4500 | 0.7161 | ["105"] | ["0.2944"] | ["78.14","131.86"] | ["XISX"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0ab22-8d4b-70e2-81b0-af2fda214710 | UPS | 2026-09-16 12:52 | straddle | 2 | 3 | 180 | 480600.00 | short | bid | 99.4500 | 0.7897 | ["105"] | ["0.2926"] | ["78.30","131.70"] | ["C2OX","EDGO","XCBO"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0ab22-8d4b-70e2-81b0-af1652edf85f | UPS | 2026-09-16 12:52 | straddle | 2 | 3 | 121 | 325980.00 | short | bid | 99.4500 | 0.7996 | ["105"] | ["0.2953"] | ["78.06","131.94"] | ["C2OX","EDGO","XCBO"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0ab22-8d4b-70e2-81b0-af091b24e7eb | UPS | 2026-09-16 12:52 | straddle | 2 | 2 | 42 | 112605.00 | short | bid | 99.4500 | 0.7500 | ["105"] | ["0.2938"] | ["78.19","131.81"] | ["MCRY","XBOX"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0ab22-8d4b-70e2-81b0-aefa5e782974 | UPS | 2026-09-16 12:52 | straddle | 2 | 4 | 38 | 101835.00 | short | bid | 99.4500 | 0.7829 | ["105"] | ["0.2937"] | ["78.20","131.80"] | ["AMXO","MCRY","XBOX","XMIO"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0ab22-8d4b-70e2-81b0-aeeb1b867b2f | UPS | 2026-09-16 12:52 | straddle | 2 | 5 | 148 | 395350.00 | short | bid | 99.4500 | 0.9270 | ["105"] | ["0.2928"] | ["78.29","131.71"] | ["AMXO","ARCO","EMLD","XPHO"] | 105.0000 | 105.0000 | 492 | 492 | false | false | |||||||||||
| 01a0aac1-27b3-7541-ac55-56eda9b83ad6 | UPS | 2026-09-16 11:06 | put_calendar | 2 | 1 | 200 | 340400.00 | short | bid | 99.5600 | 0.8000 | ["105"] | ["0.4008"] | [] | ["XPHO"] | 105.0000 | 105.0000 | 2 | 184 | false | false |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:45:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:43:24Z"} |
| 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-23T13:55:39Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:43:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:43:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T13:43:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:36:27Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:08:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:53:46Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:06:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |