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 |
|---|
| 01a0d94d-8277-7681-a07a-c523e69ee865 | OKTA | 2026-09-25 12:02 | call_calendar | 2 | 1 | 12 | 117804.00 | short | ask | 199.3100 | 5.6000 | ["150"] | ["5.3397"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T16:02:10Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d3e9-c39f-7a41-acb3-616234a71f50 | OKTA | 2026-09-24 10:55 | other | 4 | 1 | 27 | 107730.00 | unknown | ask | 210.2500 | 3.9000 | ["192.5","197.5","217.5","222.5"] | ["1.0288","0.8514","0.6456","0.6569"] | [] | ["XISX"] | 192.5000 | 222.5000 | 1 | 8 | false | false | |||||||||||
| 01a0cfad-5e27-7c20-bbd2-ab4586cd7655 | OKTA | 2026-09-23 15:10 | straddle | 2 | 4 | 30 | 320010.00 | long | ask | 202.6700 | 1.0167 | ["250"] | ["0.6827"] | ["143.33","356.67"] | ["ARCO","MCRY","XBOX"] | 250.0000 | 250.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cf92-40be-76b2-a039-cbd4605376a5 | OKTA | 2026-09-23 14:41 | other | 4 | 1 | 5 | 101625.00 | unknown | ask | 203.1100 | 10.7000 | ["150","152.5","155"] | ["0.6861","1.3252","1.7873"] | [] | ["XISX"] | 150.0000 | 155.0000 | 2 | 9 | false | false | |||||||||||
| 01a0cf75-4aae-78c3-b46f-55b39d30ec15 | OKTA | 2026-09-23 14:09 | synthetic | 2 | 1 | 15 | 159300.00 | short | ask | 202.7350 | 2.0500 | ["250"] | ["0.6793"] | ["210.48"] | ["ARCO"] | 250.0000 | 250.0000 | 267 | 267 | false | false | |||||||||||
| 01a0cf6e-d26f-7683-9a5a-3985f5db9228 | OKTA | 2026-09-23 14:02 | call_calendar | 2 | 1 | 51 | 250155.00 | short | ask | 202.7300 | 4.0000 | ["180"] | ["0.6770"] | [] | ["XISX"] | 180.0000 | 180.0000 | 2 | 23 | false | false | |||||||||||
| 01a0cee7-5ea7-7ee1-98d4-b406c78a2595 | OKTA | 2026-09-23 11:34 | call_diagonal_spread | 2 | 1 | 40 | 140680.00 | long | ask | 205.4936 | 1.0000 | ["200","205"] | ["0.5914","0.5905"] | [] | ["XPHO"] | 200.0000 | 205.0000 | 23 | 58 | false | false | |||||||||||
| 01a0cedd-b9e6-7501-bbd7-ad8eac737867 | OKTA | 2026-09-23 11:23 | call_vertical_spread | 2 | 1 | 10 | 142250.00 | long | ask | 204.3050 | 4.4500 | ["130","140"] | ["0.6607","0.6347"] | ["139.45"] | ["XISX"] | 130.0000 | 140.0000 | 58 | 58 | false | false | |||||||||||
| 01a0ced0-5fef-7de0-ad87-d81fffc00f85 | OKTA | 2026-09-23 11:09 | put_vertical_spread | 2 | 1 | 67 | 102577.00 | long | ask | 203.8600 | 1.1500 | ["185","202.5"] | ["0.5859","0.5905"] | ["195.65"] | ["ARCO"] | 185.0000 | 202.5000 | 23 | 23 | false | true | |||||||||||
| 01a0ceba-b50f-7fc2-a7d3-eb0656b7b8eb | OKTA | 2026-09-23 10:45 | call_vertical_spread | 2 | 3 | 297 | 182923.00 | unknown | ask | 200.3450 | 0.9900 | ["200","210"] | ["0.7627","0.7936"] | ["206.16"] | ["ARCO","XBOX","XMIO"] | 200.0000 | 210.0000 | 2 | 2 | false | false | |||||||||||
| 01a0ce87-e53f-78c0-aa02-f57ff61e7ba5 | OKTA | 2026-09-23 09:50 | call_diagonal_spread | 2 | 2 | 28 | 328048.00 | unknown | ask | 201.0300 | 6.8500 | ["85","190"] | ["0.8380","0.6508"] | [] | ["XISX"] | 85.0000 | 190.0000 | 86 | 359 | false | false | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:55:11Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:10:49Z"} |
| 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-23T18:41:38Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:09:54Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:02:56Z"} |
| 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-23T15:34:54Z"} |
| 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-23T15:24:21Z"} |
| 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-23T15:09:29Z"} |
| 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-23T14:45:50Z"} |
| 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:50:20Z"} |
| 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-22T18:36:45Z"} |
| 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-22T17:18:01Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| false |
| false |
| mlat |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |
| false |
| true |
| mlet |
| 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 |
| false |
| true |
| mlet |
| 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 |
| true |
| false |
| 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 |
| false |
| true |
| mlet |
| 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 |
| false |
| true |
| mlet |
| 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 |
| false |
| true |
| mesl |
| 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 |
| false |
| true |
| mesl |
| 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 |
| true |
| false |
| 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 |
| true |
| false |
| 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 |