core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | direction |
|---|
| 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 |
|---|
| 01a0cf8f-7db6-7222-87dd-2486d4165b5c | OKTA | 2026-09-23 14:38 | call_vertical_spread | 2 | 1 | 10 | 109450.00 | short | bid | 203.0000 | 5.3000 | ["148","149"] | ["0.8460","0.8697"] | ["148.97"] | ["XMIO"] | 148.0000 | 149.0000 | 9 | 9 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T18:38:28Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 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 | false | false | |||||||||
| 01a0cf74-604f-7950-a210-9a3b8d45d242 | OKTA | 2026-09-23 14:08 | straddle | 2 | 2 | 53 | 562704.00 | short | bid | 202.7700 | 2.3000 | ["250"] | ["0.6791"] | ["143.83","356.17"] | ["AMXO","ARCO"] | 250.0000 | 250.0000 | 267 | 267 | false | 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 | true | false | |||||||||
| 01a0cf4a-c7de-7901-acd0-fe270f6b9e69 | OKTA | 2026-09-23 13:22 | put_condor | 4 | 1 | 45 | 123345.00 | short | bid | 204.1400 | 3.9000 | ["120","125","140","145"] | ["0.6709","0.6752","0.6695","0.6689"] | ["120.35","144.65"] | ["XCBO"] | 120.0000 | 145.0000 | 177 | 177 | false | true | false | ||||||||||
| 01a0cef0-b15f-7c40-8219-af7dcf5357ae | OKTA | 2026-09-23 11:44 | call_diagonal_spread | 2 | 2 | 64 | 211232.00 | short | bid | 203.2300 | 1.8500 | ["200","205"] | ["0.5922","0.6077"] | [] | ["AMXO","XCBO"] | 200.0000 | 205.0000 | 23 | 58 | false | false | true | ||||||||||
| 01a0ced0-7b47-7fc1-bd84-60b95103e5b3 | OKTA | 2026-09-23 11:09 | put_vertical_spread | 2 | 2 | 90 | 136800.00 | short | bid | 203.8600 | 0.9250 | ["185","202.5"] | ["0.5817","0.5883"] | ["195.63"] | ["AMXO","ARCO"] | 185.0000 | 202.5000 | 23 | 23 | 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | |||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 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 | ||||||||||
| 01a086c9-21c0-7213-8f24-ec5f3a678f21 | OKTA | 2026-09-09 11:28 | straddle | 2 | 1 | 509 | 3970200.00 | short | bid | 170.5300 | 2.1500 | ["200"] | ["0.6019"] | ["122","278.00"] | ["XPHO"] | 200.0000 | 200.0000 | 281 | 281 | true | false | 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 | 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 | ||||||||||
| 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 | |||||||||
| 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 | |||||||||
| 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 | ||||||||||
| 01a086c5-31f0-7b83-b4f7-310e73b362d9 | OKTA | 2026-09-09 11:24 | straddle | 2 | 2 | 14 | 110605.00 | short | bid | 170.1300 | 1.1250 | ["200"] | ["0.6104"] | ["121.00","279.00"] | ["ARCO","XBOX"] | 200.0000 | 200.0000 | 281 | 281 | 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 |
| 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 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:09:08Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:23:09Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:45:04Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| 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 |
| 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-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-21T15:00:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| 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 |
| false |
| 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 |
| false |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| true |
| 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 |
| true |
| 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 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:29:19Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| 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 |
| true |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |