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_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 |
|---|
| 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 | 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 |
| 01a0820b-5748-7dd2-b266-9c86eb37cf2d | OKTA | 2026-09-08 13:22 | call_vertical_spread | 2 | 1 | 28 | 311752.00 | short | bid | 167.9400 | 5.5500 | ["105","120"] | ["1.1859","0.9781"] | ["119.90"] | ["XMIO"] | 105.0000 | 120.0000 | 10 | 10 | false | 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 | false | ||||||||||
| 01a08222-6988-75f3-9d04-ba59062a5ec9 | OKTA | 2026-09-08 13:48 | call_vertical_spread | 2 | 1 | 98 | 766458.00 | unknown | — | 169.2800 | 3.4000 | ["130","140"] | ["0.5761","0.5615"] | [] | ["XPHO"] | 130.0000 | 140.0000 | 73 | 73 | false | false | false | true | false | ||||||||
| 01a0822e-11e8-7c41-a231-37a8a1940af6 | OKTA | 2026-09-08 14:00 | call_vertical_spread | 2 | 1 | 15 | 113235.00 | unknown | — | 167.6400 | 3.5000 | ["130","140"] | ["0.5780","0.5627"] | [] | ["XPHO"] | 130.0000 | 140.0000 | 73 | 73 | false | false | false | true | false | ||||||||
| 01a0a058-8338-7053-8241-1949443fcf7c | OKTA | 2026-09-14 10:35 | call_vertical_spread | 2 | 1 | 20 | 197200.00 | short | bid | 182.5156 | 4.8000 | ["130","140"] | ["0.7801","0.7034"] | ["139.50"] | ["XISX"] | 130.0000 | 140.0000 | 32 | 32 | false | false | false | ||||||||||
| 01a0a116-ce11-7c31-b49a-388e5c57627f | OKTA | 2026-09-14 14:03 | call_vertical_spread | 2 | 1 | 10 | 108100.00 | short | bid | 188.4500 | 5.5500 | ["130","140"] | ["0.8917","0.5556"] | ["139.50"] | ["BATO"] | 130.0000 | 140.0000 | 32 | 32 | false | 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 | false | ||||||||||
| 01a0a152-4c88-7330-b0dd-9e2488cb87ee | OKTA | 2026-09-14 15:08 | call_vertical_spread | 2 | 1 | 50 | 334250.00 | unknown | — | 187.8150 | 4.9000 | ["155","160"] | ["0.6107","0.5971"] | [] | ["XMIO"] | 155.0000 | 160.0000 | 32 | 32 | false | false | false | 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 | ||||||||||
| 01a0a60d-c476-7cb2-9858-f55a50e73631 | OKTA | 2026-09-15 13:11 | call_vertical_spread | 2 | 1 | 8 | 111032.00 | unknown | — | 191.3000 | 6.5000 | ["115","140"] | ["0.6323","0.6257"] | [] | ["XPHO"] | 115.0000 | 140.0000 | 122 | 122 | false | false | false | true | false | ||||||||
| 01a0aaae-2483-76e2-ab31-2e8a57a2c2b2 | OKTA | 2026-09-16 10:45 | call_vertical_spread | 2 | 1 | 20 | 145020.00 | short | bid | 189.6000 | 4.3000 | ["152.5","155"] | ["0.7367","0.7233"] | ["154.93"] | ["XMIO"] | 152.5000 | 155.0000 | 9 | 9 | false | false | false | ||||||||||
| 01a0afd1-1584-7ab1-af5d-7ce77cfc7bde | OKTA | 2026-09-17 10:41 | call_vertical_spread | 2 | 1 | 5 | 123630.00 | unknown | — | 190.4650 | 6.4500 | ["72.5","80"] | ["0.7336","0.7175"] | [] | ["XMIO"] | 72.5000 | 80.0000 | 456 | 456 | false | false | false | true | false | ||||||||
| 01a0b008-6993-7ae3-9126-9b9cdf9b0124 | OKTA | 2026-09-17 11:42 | call_vertical_spread | 2 | 1 | 5 | 149910.00 | unknown | — | 189.8400 | 4.3000 | ["37.5","42.5"] | ["11.5738","11.0386"] | [] | ["XPHO"] | 37.5000 | 42.5000 | 1 | 1 | false | false | false | true | 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 | 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a0ca1a-03cf-79c3-ba22-e0c5d1864fa0 | OKTA | 2026-09-22 13:11 | call_vertical_spread | 2 | 1 | 8 | 117952.00 | unknown | bid | 196.6700 | 5.9000 | ["115","140"] | ["0.6054","0.6194"] | ["201.22"] | ["XISX"] | 115.0000 | 140.0000 | 115 | 115 | false | 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 | false | ||||||||||
| 01a0ca21-1c37-7220-9da4-2076ce8e8cd4 | OKTA | 2026-09-22 13:19 | call_vertical_spread | 2 | 1 | 20 | 166200.00 | short | bid | 196.8700 | 5.4500 | ["160","185"] | ["0.6237","0.6273"] | ["174.54"] | ["XPHO"] | 160.0000 | 185.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0ca36-c717-7272-9e8f-943fe5a07d93 | OKTA | 2026-09-22 13:43 | call_vertical_spread | 2 | 1 | 19 | 161215.00 | short | bid | 196.5950 | 4.9500 | ["160","185"] | ["0.6577","0.6529"] | ["174.55"] | ["XPHO"] | 160.0000 | 185.0000 | 115 | 115 | false | 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 | false | ||||||||||
| 01a0ca67-c9f7-7f70-be1e-2055c75179d6 | OKTA | 2026-09-22 14:36 | call_vertical_spread | 2 | 1 | 20 | 115500.00 | unknown | — | 197.4250 | 2.1000 | ["167.5","170"] | ["0.9009","0.8792"] | [] | ["XMIO"] | 167.5000 | 170.0000 | 3 | 3 | false | false | false | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:23:01Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:48:39Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:01:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:36:00Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:03:43Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:08:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:12:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:45:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:42:01Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:42:26Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:11:48Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| false |
| mlet |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:43:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| 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 |
| 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 |