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 | directiontext |
|---|
| 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 |
|---|
| 01a0d4c8-d12f-7d90-92c3-dff9d905f13d | CDE | 2026-09-24 14:58 | call_vertical_spread | 2 | 1 | 88 | 108328.00 | long | ask | 18.8901 | 0.5000 | ["12.5","13"] | ["3.3592","3.4143"] | ["12.99"] | ["XISX"] | 12.5000 | 13.0000 | 1 | 1 | true | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T18:59:04Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d4c6-b61f-7c91-84f1-f807e759e135 | CDE | 2026-09-24 14:56 | call_vertical_spread | 2 | 1 | 249 | 356319.00 | long | ask | 18.8943 | 0.5000 | ["11.5","12"] | ["3.6806","3.9163"] | ["11.99"] | ["XISX"] | 11.5000 | 12.0000 | 1 | 1 | true | false | false | true | |||||||||
| 01a0cfc9-bbdf-7d52-8f4f-11bced8f3c00 | CDE | 2026-09-23 15:41 | call_vertical_spread | 2 | 1 | 240 | 317040.00 | long | ask | 19.3150 | 0.7000 | ["12.5","13"] | ["2.9984","2.8892"] | ["12.99"] | ["XISX"] | 12.5000 | 13.0000 | 2 | 2 | true | false | false | true | |||||||||
| 01a0cfc8-92ff-7ce1-8c75-f542eb85f9b7 | CDE | 2026-09-23 15:40 | call_vertical_spread | 2 | 1 | 240 | 365040.00 | long | ask | 19.2950 | 0.7000 | ["11.5","12"] | ["3.7866","3.6261"] | ["11.99"] | ["XISX"] | 11.5000 | 12.0000 | 2 | 2 | true | false | false | true | |||||||||
| 01a0cfc8-0a46-74a2-9ac0-69dc5380378a | CDE | 2026-09-23 15:39 | call_vertical_spread | 2 | 1 | 88 | 151448.00 | long | ask | 19.2950 | 0.7000 | ["10.5","11"] | ["4.3684","4.1983"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0cfc6-8f5f-7e72-b2eb-8d7d77c5deda | CDE | 2026-09-23 15:38 | call_vertical_spread | 2 | 1 | 88 | 151448.00 | long | ask | 19.3080 | 0.7000 | ["10.5","11"] | ["4.1718","4.0342"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0cfc6-701f-7b20-a2a6-77325515ca95 | CDE | 2026-09-23 15:38 | call_vertical_spread | 2 | 1 | 80 | 138160.00 | long | ask | 19.3014 | 0.7000 | ["10.5","11"] | ["4.6687","4.4594"] | ["10.99"] | ["XCBO"] | 10.5000 | 11.0000 | 2 | 2 | false | false | false | true | |||||||||
| 01a0cfc5-ef37-7993-8202-1c45247ca467 | CDE | 2026-09-23 15:37 | call_vertical_spread | 2 | 1 | 80 | 138000.00 | long | ask | 19.3150 | 0.7000 | ["10.5","11"] | ["4.3742","4.2043"] | ["10.99"] | ["XMIO"] | 10.5000 | 11.0000 | 2 | 2 | true | false | false | true | |||||||||
| 01a0ca22-0697-7bc3-8cc0-c9bac0eb5026 | CDE | 2026-09-22 13:20 | call_vertical_spread | 2 | 1 | 88 | 164472.00 | long | ask | 20.0799 | 0.5000 | ["10.5","11"] | ["2.8250","2.9473"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca21-6a56-7001-9adb-75ad5f9e945a | CDE | 2026-09-22 13:19 | call_vertical_spread | 2 | 1 | 180 | 336420.00 | long | ask | 20.0816 | 0.5000 | ["10.5","11"] | ["2.7359","2.9057"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 3 | 3 | true | false | false | true | |||||||||
| 01a0ca21-3f5e-7933-a645-82e13ce519f6 | CDE | 2026-09-22 13:19 | call_vertical_spread | 2 | 1 | 55 | 102795.00 | long | ask | 20.0950 | 0.5000 | ["10.5","11"] | ["4.2260","2.2604"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0ca20-f90f-7e50-861d-e04fec36e89d | CDE | 2026-09-22 13:19 | call_vertical_spread | 2 | 1 | 59 | 110271.00 | long | ask | 20.0861 | 0.5000 | ["10.5","11"] | ["2.2169","2.7767"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 3 | 3 | true | false | false | true | |||||||||
| 01a0b618-17c7-7132-8198-17bd449ff717 | CDE | 2026-09-18 15:57 | call_vertical_spread | 2 | 1 | 244 | 443836.00 | long | ask | 19.7250 | 0.8000 | ["10.5","11"] | ["2.7372","2.6075"] | ["10.99"] | ["XISX"] | 10.5000 | 11.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a0b616-6a17-75f1-a54a-ff8d9be0c95e | CDE | 2026-09-18 15:55 | call_vertical_spread | 2 | 1 | 248 | 480872.00 | long | ask | 19.7200 | 2.7000 | ["10","10.5"] | ["3.3879","3.2147"] | ["10.49"] | ["XISX"] | 10.0000 | 10.5000 | 7 | 7 | true | false | false | true | |||||||||
| 01a0a177-7c11-73e3-94c0-7cb3eae80d48 | CDE | 2026-09-14 15:49 | put_vertical_spread | 2 | 1 | 88 | 112288.00 | long | ask | 19.9350 | 0.5000 | ["26","26.5"] | ["0.8044","0.8168"] | ["26.02"] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | |||||||||
| 01a0a177-39a8-7db1-bbf3-309f9fce65f1 | CDE | 2026-09-14 15:48 | put_vertical_spread | 2 | 1 | 80 | 102160.00 | long | ask | 19.9350 | 0.5000 | ["26","26.5"] | ["0.8044","0.8330"] | ["26.01"] | ["XCBO"] | 26.0000 | 26.5000 | 18 | 18 | false | false | false | true | |||||||||
| 01a0a176-dbe8-7b72-ac27-c760c6e34a70 | CDE | 2026-09-14 15:48 | put_vertical_spread | 2 | 1 | 88 | 113432.00 | long | ask | 19.9350 | 1.0000 | ["26","26.5"] | ["0.8848","0.9184"] | ["26.01"] | ["XMIO"] | 26.0000 | 26.5000 | 18 | 18 | true | false | false | true | |||||||||
| 01a0a13b-3e30-7e23-adec-28c19d6b037b | CDE | 2026-09-14 14:43 | call_vertical_spread | 2 | 1 | 88 | 168872.00 | long | ask | 20.0600 | 0.6000 | ["10","11"] | ["3.0974","2.8434"] | ["10.99"] | ["XISX"] | 10.0000 | 11.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a13a-d8a0-7161-9c52-eb910dff838f | CDE | 2026-09-14 14:43 | call_vertical_spread | 2 | 1 | 180 | 345420.00 | long | ask | 20.0600 | 0.6000 | ["10","11"] | ["3.0974","2.8434"] | ["10.99"] | ["XISX"] | 10.0000 | 11.0000 | 4 | 4 | true | false | false | true | |||||||||
| 01a0a139-55e8-7413-8567-75f6a7692755 | CDE | 2026-09-14 14:41 | call_vertical_spread | 2 | 1 | 180 | 262980.00 | long | ask | 20.0650 | 0.4000 | ["12.5","13"] | ["2.2389","2.7358"] | ["12.99"] | ["XISX"] | 12.5000 | 13.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0a139-03e1-7ba0-a644-0f428e87b37e | CDE | 2026-09-14 14:41 | call_vertical_spread | 2 | 1 | 88 | 128568.00 | long | ask | 20.0550 | 0.4000 | ["12.5","13"] | ["2.3437","2.7799"] | ["12.99"] | ["XISX"] | 12.5000 | 13.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a08cda-4350-7dc3-8486-b45bd00b0628 | CDE | 2026-09-10 15:45 | call_vertical_spread | 2 | 1 | 188 | 251356.00 | long | ask | 20.3800 | 0.6000 | ["13.5","14"] | ["4.2919","4.1026"] | ["13.99"] | ["XISX"] | 13.5000 | 14.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08cda-2028-7811-a1bc-629915a66204 | CDE | 2026-09-10 15:44 | call_vertical_spread | 2 | 1 | 88 | 117656.00 | long | ask | 20.3750 | 0.6000 | ["13.5","14"] | ["4.3657","4.1648"] | ["13.99"] | ["XISX"] | 13.5000 | 14.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0870b-1490-7901-b35d-5d4a852af33a | CDE | 2026-09-09 12:40 | call_calendar | 2 | 1 | 200 | 190800.00 | long | bid | 21.1650 | 0.7000 | ["16.5"] | ["0.8989"] | [] | ["C2OX"] | 16.5000 | 16.5000 | 9 | 16 | false | false | true | false | false | ||||||||
| 01a08708-3630-7752-a916-e87c83402faa | CDE | 2026-09-09 12:37 | call_calendar | 2 | 1 | 190 | 180310.00 | long | bid | 21.1439 | 1.0000 | ["16.5"] | ["0.8897"] | [] | ["C2OX"] | 16.5000 | 16.5000 | 9 | 16 | false | false | true | false | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:56:40Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:41:40Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:40:28Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:39:57Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:38:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:38:29Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:37:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:20:27Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:20:27Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:19:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:19:36Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:57:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:55:20Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:49:49Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:49:12Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:48:40Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:44:16Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:43:22Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:41:32Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:41:32Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:45:13Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:45:00Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:41:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:38:14Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |