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 | 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 |
|---|
| 01a0d8cf-2e9f-7430-b9cd-db3017c01602 | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 75 | 133200.00 | long | bid | 190.8079 | 0.3940 | ["165","245"] | ["0.6025","0.6449"] | ["163.80"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T13:44:28Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8cf-2ab7-73c2-a889-036b42777257 | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 79 | 139830.00 | long | bid | 190.8079 | 0.5500 | ["165","245"] | ["0.6015","0.6439"] | ["163.80"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | |||||||||
| 01a0d8cf-2ab7-73c2-a889-034b7452fbba | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 83 | 146744.00 | long | bid | 190.8079 | 0.5500 | ["165","245"] | ["0.6015","0.6432"] | ["163.78"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | |||||||||
| 01a0d8cf-2ab7-73c2-a889-0331d0563e7a | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 79 | 139830.00 | long | bid | 190.7500 | 0.6500 | ["165","245"] | ["0.6010","0.6444"] | ["163.80"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | |||||||||
| 01a0d8cf-26cf-7492-92cf-ea464dfd3ee4 | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 78 | 138840.00 | long | bid | 190.7400 | 0.4500 | ["165","245"] | ["0.6044","0.6445"] | ["163.70"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | |||||||||
| 01a0d8cf-26cf-7492-92cf-ea28d58bb5ce | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 79 | 140225.00 | long | bid | 190.7800 | 0.6750 | ["165","245"] | ["0.6030","0.6441"] | ["163.75"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | |||||||||
| 01a0d8cf-26cf-7492-92cf-e9fb51d69a2c | SKHY | 2026-09-25 09:44 | risk_reversal | 2 | 1 | 81 | 143613.00 | long | bid | 190.7700 | 0.6500 | ["165","245"] | ["0.6029","0.6436"] | ["163.73"] | ["ARCO"] | 165.0000 | 245.0000 | 84 | 84 | false | true | false | true | |||||||||
| 01a0d39c-ad3e-77c0-b618-f13015f08049 | SKHY | 2026-09-24 09:30 | risk_reversal | 2 | 1 | 83 | 124635.00 | short | bid | 185.6567 | 2.2500 | ["140","250"] | ["0.6068","0.6483"] | ["253.76"] | ["XISX"] | 140.0000 | 250.0000 | 113 | 113 | false | true | false | true | |||||||||
| 01a0aabc-8c03-73a0-9f5c-f20439a8e7ee | SKHY | 2026-09-16 11:01 | risk_reversal | 2 | 3 | 750 | 102500.00 | short | ask | 179.4450 | 0.0600 | ["170","197.5"] | ["0.8357","0.7911"] | ["169.11"] | ["AMXO","XCBO","XISX"] | 170.0000 | 197.5000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0aabc-6cc3-7a40-83bd-1ac31be51df3 | SKHY | 2026-09-16 11:01 | risk_reversal | 2 | 4 | 751 | 102658.00 | short | ask | 179.3400 | 0.0600 | ["170","197.5"] | ["0.8283","0.7997"] | ["169.12"] | ["AMXO","C2OX","XCBO","XISX"] | 170.0000 | 197.5000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0aabc-228b-72b3-a020-22e2df520520 | SKHY | 2026-09-16 11:00 | risk_reversal | 2 | 7 | 1000 | 135992.00 | short | ask | 179.2850 | 0.0263 | ["170","197.5"] | ["0.8202","0.8094"] | ["169.15"] | ["AMXO","C2OX","XCBO","XISX"] | 170.0000 | 197.5000 | 2 | 2 | false | true | false | true | |||||||||
| 01a0a626-cab6-7b61-b452-6b674b753371 | SKHY | 2026-09-15 13:39 | risk_reversal | 2 | 5 | 916 | 155884.00 | short | ask | 173.7000 | 0.1525 | ["165","192.5"] | ["0.7208","0.7467"] | ["164.00"] | ["AMXO","C2OX","XCBO","XISX"] | 165.0000 | 192.5000 | 3 | 3 | false | true | false | true | |||||||||
| 01a086a7-a388-7dd3-aed9-3f5adc5da7c9 | SKHY | 2026-09-09 10:52 | risk_reversal | 2 | 3 | 85 | 234554.00 | short | bid | 195.3700 | 1.5959 | ["165","245"] | ["0.6997","0.7265"] | ["246.60"] | ["ARCO","XBOX","XISX"] | 165.0000 | 245.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a086a7-7890-76e1-980b-3d0d3b5065f3 | SKHY | 2026-09-09 10:51 | risk_reversal | 2 | 2 | 146 | 408033.00 | long | ask | 195.3950 | 1.6500 | ["165","245"] | ["0.6989","0.7364"] | ["247.02"] | ["C2OX","XCBO"] | 165.0000 | 245.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a081aa-66e0-7341-9de3-a04429b0d0ed | SKHY | 2026-09-08 11:37 | risk_reversal | 2 | 1 | 31 | 154659.00 | short | bid | 188.7500 | 1.2500 | ["180","210"] | ["0.6982","0.7180"] | ["210.05"] | ["XMIO"] | 180.0000 | 210.0000 | 129 | 129 | false | true | false | true | |||||||||
| 01a08147-1130-7551-82f0-ae71e349523e | SKHY | 2026-09-08 09:48 | risk_reversal | 2 | 3 | 12 | 100812.00 | long | bid | 185.5750 | 0.8000 | ["205","235"] | ["0.6901","0.6938"] | ["182.70"] | ["EDGO","XISX","XMIO"] | 205.0000 | 235.0000 | 282 | 282 | false | false | false | true | |||||||||
| 01a08144-7538-7f70-97e5-337928b937df | SKHY | 2026-09-08 09:45 | risk_reversal | 2 | 1 | 18 | 151218.00 | short | ask | 185.5400 | 0.5000 | ["205","235"] | ["0.6913","0.6927"] | ["182.51"] | ["XCBO"] | 205.0000 | 235.0000 | 282 | 282 | false | false | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:44:28Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:44:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:44:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:44:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:44:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:44:09Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:31:04Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:01:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:01:16Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:00:50Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:40:08Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:52:11Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:52:11Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:37:35Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:48:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:46:00Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |