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 |
|---|
| 01a0ca65-ca3f-73e2-af91-8c0bb4a013d2 | OKTA | 2026-09-22 14:34 | other | 4 | 1 | 10 | 198970.00 | unknown | bid | 197.3850 | 9.1500 | ["147","148","149"] | ["1.7084","1.1434","0.8766"] | [] | ["XMIO"] | 147.0000 | 149.0000 | 3 | 10 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T18:34:36Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca4f-d90f-7c61-88ed-a53cc54f7aa0 | OKTA | 2026-09-22 14:10 | call_calendar | 2 | 1 | 10 | 204380.00 | long | bid | 196.9700 | 7.2500 | ["95"] | ["1.4983"] | [] | ["XMIO"] | 95.0000 | 95.0000 | 24 | 59 | false | false | true | 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 | true | |||||||||
| 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 | true | |||||||||
| 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 | true | |||||||||
| 01a0c952-663f-7fd2-8d86-41e81f596585 | OKTA | 2026-09-22 09:33 | other | 4 | 4 | 12 | 110112.00 | unknown | bid | 190.8300 | 8.4500 | ["150","160","170","200"] | ["0.6788","0.6468","0.6075","0.6665"] | [] | ["ARCO","EMLD","SPHR","XISX"] | 150.0000 | 200.0000 | 10 | 178 | false | false | true | true | |||||||||
| 01a0c47b-dfbf-7601-ad74-e176b88dc58c | OKTA | 2026-09-21 11:00 | call_diagonal_spread | 2 | 1 | 7 | 116851.00 | short | bid | 189.7000 | 7.9000 | ["140","165"] | ["0.6561","0.6296"] | [] | ["XCBO"] | 140.0000 | 165.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0b4cc-b7c0-7ef1-a33a-92a724084eca | OKTA | 2026-09-18 09:55 | call_diagonal_spread | 2 | 1 | 10 | 153520.00 | short | bid | 184.9600 | 6.3000 | ["110","115"] | ["11.5055","0.6822"] | [] | ["XCBO"] | 110.0000 | 115.0000 | 0 | 182 | false | false | true | true | |||||||||
| 01a0b047-a8fb-7071-8477-92ad0128eac0 | OKTA | 2026-09-17 12:51 | call_diagonal_spread | 2 | 2 | 30 | 101490.00 | short | bid | 190.2100 | 3.1500 | ["175","190"] | ["0.6357","0.5656"] | [] | ["XMIO"] | 175.0000 | 190.0000 | 1 | 64 | false | false | true | true | |||||||||
| 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 | true | |||||||||
| 01a0a566-6c9e-7282-8acf-84a0d1e26e88 | OKTA | 2026-09-15 10:09 | straddle | 2 | 5 | 47 | 249241.00 | short | bid | 186.0450 | 2.2734 | ["170"] | ["0.6283"] | ["116.97","223.03"] | ["EMLD","MCRY","SPHR","XISX","XPHO"] | 170.0000 | 170.0000 | 122 | 122 | false | 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 | true | |||||||||
| 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 | true | |||||||||
| 01a0a053-5319-70f0-92f4-1c5b03dee053 | OKTA | 2026-09-14 10:30 | straddle | 2 | 1 | 24 | 118056.00 | short | bid | 182.5850 | 2.3000 | ["160"] | ["0.6539"] | ["110.81","209.19"] | ["SPHR"] | 160.0000 | 160.0000 | 95 | 95 | false | false | false | false | |||||||||
| 01a0a053-5319-70f0-92f4-1c4893e29e14 | OKTA | 2026-09-14 10:30 | straddle | 2 | 2 | 34 | 146404.00 | short | bid | 182.5850 | 3.8162 | ["150"] | ["0.5778"] | ["106.94","193.06"] | ["SPHR","XPHO"] | 150.0000 | 150.0000 | 67 | 67 | false | false | false | false | |||||||||
| 01a086c6-0cb0-7360-93c8-0d17310d79de | OKTA | 2026-09-09 11:25 | synthetic | 2 | 3 | 14 | 109480.00 | long | bid | 170.1300 | 1.2000 | ["200"] | ["0.6036"] | ["176.08"] | ["ARCO","EDGO","XISX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a086c5-f540-7922-a9e3-ea87e7614dac | OKTA | 2026-09-09 11:25 | straddle | 2 | 3 | 13 | 101660.00 | short | bid | 170.1300 | 0.7462 | ["200"] | ["0.6036"] | ["121.8","278.20"] | ["ARCO","EDGO","XISX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a086c5-35d8-7ef3-8049-3bc5d1834b02 | OKTA | 2026-09-09 11:24 | straddle | 2 | 3 | 13 | 102700.00 | short | bid | 170.1900 | 0.9000 | ["200"] | ["0.6103"] | ["121","279.00"] | ["ARCO","EDGO","XISX"] | 200.0000 | 200.0000 | 281 | 281 | false | false | false | false | |||||||||
| 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 | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:10:24Z"} |
| 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-22T17:43:24Z"} |
| 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-22T17:19:36Z"} |
| 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-22T17:11:48Z"} |
| 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:33:48Z"} |
| 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-21T15:00:50Z"} |
| 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-18T13:55:14Z"} |
| 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-17T16:51:42Z"} |
| 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-16T14:45:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| 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 |
| 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 |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:30:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:30:19Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:25:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:25:23Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| 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 |
| 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 |