core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_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 |
|---|
| 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 | 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 |
| 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 | ||||||||
| 01a0b0c3-419b-7043-8bcd-ccc0eafc4452 | OKTA | 2026-09-17 15:06 | call_calendar | 2 | 1 | 13 | 239018.00 | unknown | — | 192.4950 | 5.4000 | ["100"] | ["3.8365"] | [] | ["XMIO"] | 100.0000 | 100.0000 | 1 | 36 | false | false | true | false | false | mlat | |||||||
| 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 | mlat | |||||||
| 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 | |||||||||
| 01a0a12c-a7d0-76e2-b5a2-4920cb845214 | OKTA | 2026-09-14 14:27 | other | 4 | 1 | 20 | 335480.00 | unknown | — | 188.8900 | 9.5500 | ["142","143","149","150"] | ["1.9008","1.8834","1.0639","1.0309"] | [] | ["XBOX"] | 142.0000 | 150.0000 | 4 | 11 | false | false | true | true | false | mlat | |||||||
| 01a09130-04f9-7f90-8ec5-2791872ecd0e | OKTA | 2026-09-11 11:57 | call_diagonal_spread | 2 | 1 | 15 | 233385.00 | long | bid | 168.2250 | 4.7000 | ["90","100"] | ["2.7447","0.6594"] | [] | ["XMIO"] | 90.0000 | 100.0000 | 7 | 279 | false | false | true | true | false | ||||||||
| 01a0822f-ea90-7032-abdb-bd2f48f4c89a | OKTA | 2026-09-08 14:02 | other | 4 | 1 | 10 | 186768.00 | unknown | — | 167.3600 | 5.7000 | ["105","120","130","140"] | ["1.8002","1.3387","0.5802","0.5566"] | [] | ["XCBO"] | 105.0000 | 140.0000 | 10 | 73 | false | false | true | true | false | mlat | |||||||
| 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 | |||||||||
| 01a08218-8260-7b80-a4af-6214cbb6c062 | OKTA | 2026-09-08 13:37 | other | 4 | 1 | 11 | 207394.00 | unknown | — | 168.6850 | 9.3000 | ["105","120","130","140"] | ["1.9594","1.5225","0.5380","0.5304"] | [] | ["XCBO"] | 105.0000 | 140.0000 | 10 | 73 | false | false | true | true | false | mlat | |||||||
| 01a081da-d938-7f93-9fa0-a460f3da588d | OKTA | 2026-09-08 12:29 | other | 4 | 1 | 10 | 118690.00 | unknown | — | 167.4200 | 9.5000 | ["137","138","139"] | ["1.0767","0.8244","0.6327"] | [] | ["AMXO"] | 137.0000 | 139.0000 | 3 | 10 | false | false | true | true | false | mlat | |||||||
| 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 | |||||||||
| 01a06d47-af15-76f3-98ca-bff538ee19c3 | OKTA | 2026-09-04 12:36 | other | 4 | 1 | 20 | 206520.00 | unknown | — | 172.4700 | 9.1500 | ["146","147","148"] | ["7.0511","3.8357","0.8702"] | [] | ["XBOX"] | 146.0000 | 148.0000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a06d47-5155-7cb1-a5e2-742a36032e15 | OKTA | 2026-09-04 12:36 | other | 4 | 1 | 20 | 219160.00 | unknown | — | 172.4700 | 8.5500 | ["144","145","146"] | ["7.0203","3.7115","0.6126"] | [] | ["AMXO"] | 144.0000 | 146.0000 | 0 | 7 | false | false | true | true | false | mlat | |||||||
| 01a06d44-f7c5-7cf3-b287-2f88d097178f | OKTA | 2026-09-04 12:33 | other | 4 | 1 | 15 | 140985.00 | unknown | — | 172.3750 | 9.1000 | ["148","149","150"] | ["6.6316","3.6595","0.6220"] | [] | ["AMXO"] | 148.0000 | 150.0000 | 0 | 7 | false | false | true | true | 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T19:06:31Z"} |
| 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-17T14:42:01Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| 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-14T18:27:46Z"} |
| 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-11T15:57:42Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:03:16Z"} |
| 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-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:38:04Z"} |
| 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-08T16:30:01Z"} |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:36:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:36:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:34:11Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |