core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0ca67-6467-7cb3-aaf1-947446526e05 | OKTA | 2026-09-22 14:36 | call_vertical_spread | 2 | 1 | 20 | 136400.00 | long | ask | 197.4250 | 4.2000 | ["162.5","165"] | ["1.2499","1.1931"] | ["164.96"] | ["ARCO"] | 162.5000 | 165.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:36:45Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca1f-37d7-7e70-aa27-ffaf3379e703 | OKTA | 2026-09-22 13:17 | call_vertical_spread | 2 | 1 | 20 | 295860.00 | long | ask | 196.6400 | 6.0500 | ["115","140"] | ["0.6368","0.6306"] | ["136.25"] | ["AMXO"] | 115.0000 | 140.0000 | 115 | 115 | false | false | false | true | |||||||||
| 01a0c965-d6ce-7563-a62d-8e3241cd779a | OKTA | 2026-09-22 09:54 | call_vertical_spread | 2 | 2 | 90 | 164565.00 | unknown | ask | 189.5200 | 2.7000 | ["230","270"] | ["0.6759","0.6883"] | ["248.28"] | ["AMXO","ARCO"] | 230.0000 | 270.0000 | 87 | 87 | false | true | false | true | |||||||||
| 01a0c528-c18f-7423-85c4-ece6f92e903d | OKTA | 2026-09-21 14:09 | call_vertical_spread | 2 | 1 | 2000 | 872000.00 | long | ask | 190.7200 | 0.8200 | ["220","230"] | ["0.5593","0.5741"] | ["221.04"] | ["AMXO"] | 220.0000 | 230.0000 | 25 | 25 | true | true | false | true | |||||||||
| 01a0c48e-276f-7803-8e03-4ce2d60a47c9 | OKTA | 2026-09-21 11:20 | call_vertical_spread | 2 | 1 | 20 | 123740.00 | long | ask | 189.2350 | 2.5500 | ["157.5","160"] | ["1.0428","0.9948"] | ["159.95"] | ["XMIO"] | 157.5000 | 160.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a0b619-f83f-7921-a460-010e586a23b9 | OKTA | 2026-09-18 15:59 | call_calendar | 2 | 1 | 10 | 104830.00 | short | ask | 182.2550 | 6.1500 | ["130"] | ["51.4961"] | [] | ["XCBO"] | 130.0000 | 130.0000 | 0 | 14 | false | false | true | false | false | ||||||||
| 01a0b5bc-383f-7ac3-b7a4-04d6ffec455e | OKTA | 2026-09-18 14:16 | call_diagonal_spread | 2 | 1 | 5 | 108590.00 | short | ask | 183.1150 | 5.6500 | ["75","80"] | ["32.7068","0.7295"] | [] | ["XMIO"] | 75.0000 | 80.0000 | 0 | 272 | false | false | true | true | false | ||||||||
| 01a0b08a-0d13-7630-93a2-300643f7e657 | OKTA | 2026-09-17 14:03 | call_vertical_spread | 2 | 1 | 11 | 128194.00 | long | ask | 191.0600 | 3.4000 | ["130","140"] | ["0.5886","0.5789"] | ["139.10"] | ["XISX"] | 130.0000 | 140.0000 | 64 | 64 | false | false | false | true | |||||||||
| 01a0b02d-f2f3-7aa1-babe-fb891878c840 | OKTA | 2026-09-17 12:23 | call_vertical_spread | 2 | 1 | 16 | 110144.00 | long | ask | 189.7000 | 1.8000 | ["170","175"] | ["0.6642","0.6632"] | ["172.80"] | ["XPHO"] | 170.0000 | 175.0000 | 92 | 92 | false | false | false | true | |||||||||
| 01a0a6a1-26ee-7411-ac96-f8aa5604ecf1 | OKTA | 2026-09-15 15:52 | call_diagonal_spread | 2 | 2 | 38 | 642238.00 | short | ask | 189.3500 | 5.8000 | ["90","140"] | ["3.8168","0.6593"] | [] | ["ARCO"] | 90.0000 | 140.0000 | 3 | 275 | false | false | true | true | false | ||||||||
| 01a0a600-feee-7540-bdfb-054724e4d77d | OKTA | 2026-09-15 12:57 | call_vertical_spread | 2 | 1 | 25 | 334950.00 | long | ask | 190.7000 | 4.2000 | ["123","124"] | ["2.8791","2.9052"] | ["123.98"] | ["XISX"] | 123.0000 | 124.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0a566-68b6-75e0-a921-faf392df1b54 | OKTA | 2026-09-15 10:09 | straddle | 2 | 3 | 17 | 100470.00 | long | ask | 186.0450 | 2.2412 | ["190"] | ["0.6102"] | ["130.90","249.10"] | ["EMLD","XISX","XPHO"] | 190.0000 | 190.0000 | 157 | 157 | true | false | false | false | true | ||||||||
| 01a0a566-60e6-76e1-b690-70a37e533fa5 | OKTA | 2026-09-15 10:09 | straddle | 2 | 4 | 18 | 110340.00 | long | ask | 186.0450 | 1.3306 | ["200"] | ["0.6111"] | ["138.70","261.30"] | ["EMLD","MCRY","XISX","XPHO"] | 200.0000 | 200.0000 | 157 | 157 | false | false | false | false | true | ||||||||
| 01a0a134-6c18-7372-919e-629d31786706 | OKTA | 2026-09-14 14:36 | call_vertical_spread | 2 | 1 | 11 | 138149.00 | long | ask | 187.6900 | 5.6500 | ["125","126"] | ["2.2014","2.1716"] | ["125.99"] | ["XCBO"] | 125.0000 | 126.0000 | 4 | 4 | false | false | false | true | |||||||||
| 01a086c6-7240-75f1-a0f0-338af78ab1bb | OKTA | 2026-09-09 11:25 | synthetic | 2 | 4 | 19 | 148295.00 | short | ask | 170.2700 | 0.5368 | ["200"] | ["0.6023"] | ["175.93"] | ["ARCO","EDGO","XISX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a086c6-62a0-7171-80a6-04c7892a9932 | OKTA | 2026-09-09 11:25 | straddle | 2 | 3 | 14 | 109270.00 | long | ask | 170.2800 | 0.6500 | ["200"] | ["0.6023"] | ["121.95","278.05"] | ["ARCO","EDGO","XISX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a086c5-5518-7023-9060-13ce4a6868d3 | OKTA | 2026-09-09 11:24 | synthetic | 2 | 1 | 17 | 133960.00 | short | ask | 170.3800 | 0.3000 | ["200"] | ["0.6086"] | ["176.50"] | ["XBOX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a086c5-5518-7023-9060-13b34be52db6 | OKTA | 2026-09-09 11:24 | synthetic | 2 | 1 | 17 | 133960.00 | short | ask | 170.3800 | 0.3500 | ["200"] | ["0.6086"] | ["176.50"] | ["XBOX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | true | ||||||||
| 01a0821a-0130-7ee2-8df5-cffb0b89aaca | OKTA | 2026-09-08 13:38 | call_vertical_spread | 2 | 1 | 19 | 213541.00 | long | ask | 168.6950 | 4.7000 | ["105","120"] | ["1.6744","1.5200"] | ["119.95"] | ["EDGO"] | 105.0000 | 120.0000 | 10 | 10 | false | false | false | true | |||||||||
| 01a06dc7-6e35-7503-b590-05565897eef6 | OKTA | 2026-09-04 14:56 | call_vertical_spread | 2 | 2 | 21 | 221265.00 | long | ask | 172.1475 | 3.9500 | ["115","140"] | ["0.6126","0.5982"] | ["133.82"] | ["EDGO"] | 115.0000 | 140.0000 | 133 | 133 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:18:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:54:58Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:10:04Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:20:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:59:18Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:16:59Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:04:15Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:23:51Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:52:52Z"} |
| 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-15T16:57:57Z"} |
| 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-15T14:09:12Z"} |
| 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-15T14:09:12Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:36:11Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:25:55Z"} |
| 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-09T15:25:55Z"} |
| 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-09T15:24:37Z"} |
| 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-09T15:24:37Z"} |
| 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-08T17:39:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:56:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |