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 |
|---|
| 01a0caaa-939f-7613-b953-a0cf34058174 | COHR | 2026-09-22 15:49 | call_vertical_spread | 2 | 1 | 30 | 110850.00 | short | bid | 310.0300 | 2.1000 | ["400","420"] | ["0.7714","0.7710"] | ["403.65"] | ["XMIO"] | 400.0000 | 420.0000 | 87 | 87 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:49:51Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c9e8-0ad7-7990-a6f4-802803e04e32 | COHR | 2026-09-22 12:17 | call_vertical_spread | 2 | 2 | 18 | 194022.00 | short | bid | 308.6350 | 9.8000 | ["265","270"] | ["0.7549","0.7524"] | ["268.49"] | ["C2OX"] | 265.0000 | 270.0000 | 38 | 38 | false | false | false | true | |||||||||
| 01a0c996-54df-7431-9734-1d05a9c4a424 | COHR | 2026-09-22 10:47 | call_calendar | 2 | 2 | 67 | 511576.00 | short | ask | 306.7900 | 12.7582 | ["272.5"] | ["1.0577"] | [] | ["XISX","XMIO"] | 272.5000 | 272.5000 | 3 | 10 | false | false | true | false | |||||||||
| 01a0c57e-57b7-7851-8046-6c33847c3b77 | COHR | 2026-09-21 15:43 | call_vertical_spread | 2 | 1 | 3 | 122652.00 | short | bid | 323.2400 | 12.3000 | ["140","150"] | ["0.8053","0.8015"] | ["146.60"] | ["BATO"] | 140.0000 | 150.0000 | 487 | 487 | false | false | false | true | |||||||||
| 01a0c57d-0f97-7223-b1fe-c908c4d811fb | COHR | 2026-09-21 15:41 | call_vertical_spread | 2 | 1 | 3 | 122658.00 | short | bid | 323.6550 | 12.3000 | ["140","150"] | ["0.7983","0.7952"] | ["146.60"] | ["XMIO"] | 140.0000 | 150.0000 | 487 | 487 | false | false | false | true | |||||||||
| 01a0c572-3e0f-7712-88a2-531e3d47a67f | COHR | 2026-09-21 15:29 | call_vertical_spread | 2 | 1 | 20 | 560200.00 | short | bid | 323.0850 | 11.0000 | ["350","400"] | ["0.7692","0.7709"] | ["361.70"] | ["XPHO"] | 350.0000 | 400.0000 | 851 | 851 | false | true | false | true | |||||||||
| 01a0c52e-ff37-7813-87a0-8c101391b83c | COHR | 2026-09-21 14:16 | call_vertical_spread | 2 | 1 | 10 | 109530.00 | short | bid | 321.6400 | 3.1000 | ["320","330"] | ["0.7575","0.7557"] | ["324.25"] | ["BATO"] | 320.0000 | 330.0000 | 116 | 116 | false | false | false | true | |||||||||
| 01a0c480-11f6-76f3-b1e5-d8f55100f4b4 | COHR | 2026-09-21 11:05 | call_diagonal_spread | 2 | 1 | 10 | 461060.00 | short | ask | 327.1350 | 12.1000 | ["110","140"] | ["0.8101","0.7944"] | [] | ["XCBO"] | 110.0000 | 140.0000 | 487 | 851 | false | false | true | true | |||||||||
| 01a0b5e0-4e87-7443-8576-78abf0de9cdb | COHR | 2026-09-18 14:56 | put_vertical_spread | 2 | 4 | 10 | 115626.00 | short | bid | 312.1500 | 4.5000 | ["300","350"] | ["0.7350","0.7368"] | ["319.98"] | ["ARCO","EDGO","XCBO","XISX"] | 300.0000 | 350.0000 | 119 | 119 | false | false | false | ||||||||||
| 01a0b597-fed0-7093-99c9-05230925b695 | COHR | 2026-09-18 13:37 | call_calendar | 2 | 1 | 20 | 161380.00 | short | bid | 307.9700 | 3.4000 | ["270"] | ["2.4180"] | [] | ["XCBO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b597-e377-7882-ac83-dfbb94221586 | COHR | 2026-09-18 13:37 | call_calendar | 2 | 1 | 20 | 161740.00 | short | ask | 307.8750 | 3.5000 | ["270"] | ["2.6576"] | [] | ["XCBO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b597-e377-7882-ac83-dfa765c5401c | COHR | 2026-09-18 13:37 | call_calendar | 2 | 2 | 39 | 315393.00 | short | ask | 307.8300 | 3.5000 | ["270"] | ["2.7094"] | [] | ["C2OX","EDGO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b595-c868-7d63-bf28-5ccf6bb48a42 | COHR | 2026-09-18 13:34 | call_calendar | 2 | 3 | 13 | 104795.00 | short | ask | 307.7150 | 5.0000 | ["270"] | ["2.6457"] | [] | ["SPHR","XCBO","XMIO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b595-c868-7d63-bf28-5ca81d644212 | COHR | 2026-09-18 13:34 | call_calendar | 2 | 3 | 31 | 249649.00 | short | ask | 307.7150 | 5.0000 | ["270"] | ["2.5989"] | [] | ["ARCO","C2OX","EDGO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b595-c47f-74d3-8fb5-cb6c4ba551fa | COHR | 2026-09-18 13:34 | call_calendar | 2 | 2 | 17 | 137054.00 | short | ask | 307.7150 | 5.0000 | ["270"] | ["2.6565"] | [] | ["C2OX","EDGO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b595-c097-7933-8c4b-0d7b645c7558 | COHR | 2026-09-18 13:34 | call_calendar | 2 | 2 | 41 | 329930.00 | short | ask | 307.6200 | 5.0000 | ["270"] | ["2.6800"] | [] | ["ARCO","EDGO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b593-c0df-7cf0-9bea-14cae61c022d | COHR | 2026-09-18 13:32 | call_calendar | 2 | 1 | 20 | 161920.00 | short | ask | 307.6250 | 5.4000 | ["270"] | ["2.9004"] | [] | ["XCBO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b591-ec1f-7252-a443-65e8e921b3d2 | COHR | 2026-09-18 13:30 | call_calendar | 2 | 1 | 18 | 142236.00 | short | bid | 307.6350 | 3.1000 | ["270"] | ["2.2957"] | [] | ["XCBO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b590-f220-7473-bd1a-fb7cd0615789 | COHR | 2026-09-18 13:29 | call_calendar | 2 | 1 | 39 | 312273.00 | short | ask | 307.8400 | 4.1000 | ["270"] | ["3.1137"] | [] | ["XCBO"] | 270.0000 | 270.0000 | 0 | 14 | false | false | true | false | |||||||||
| 01a0b4c1-e250-7763-8791-d5d5b13ab2ec | COHR | 2026-09-18 09:43 | call_vertical_spread | 2 | 3 | 54 | 286460.00 | short | bid | 313.1900 | 3.4000 | ["300","320"] | ["0.7056","0.6981"] | ["310"] | ["XMIO","XPHO"] | 300.0000 | 320.0000 | 28 | 28 | false | false | false | true | |||||||||
| 01a0b4c1-e250-7763-8791-d5c557bc8f09 | COHR | 2026-09-18 09:43 | call_vertical_spread | 2 | 1 | 31 | 163990.00 | short | bid | 313.1900 | 3.4000 | ["300","320"] | ["0.7034","0.6959"] | ["310"] | ["MCRY"] | 300.0000 | 320.0000 | 28 | 28 | false | false | false | true | |||||||||
| 01a0b4bd-4a88-7802-adbb-609f00f4d3af | COHR | 2026-09-18 09:38 | put_calendar | 2 | 1 | 18 | 264420.00 | short | ask | 312.0000 | 11.6000 | ["360"] | ["0.7861"] | [] | ["XMIO"] | 360.0000 | 360.0000 | 63 | 91 | false | false | true | false | |||||||||
| 01a0abc8-d79b-79f3-ac9d-5c4dc9e53725 | COHR | 2026-09-16 15:54 | call_diagonal_spread | 2 | 1 | 48 | 402722.00 | short | bid | 289.7050 | 11.1000 | ["250","255"] | ["0.7513","1.0188"] | [] | ["XCBO"] | 250.0000 | 255.0000 | 2 | 30 | false | false | true | true | |||||||||
| 01a0abc8-b473-7561-9eca-857457b9648e | COHR | 2026-09-16 15:54 | call_diagonal_spread | 2 | 1 | 31 | 260710.00 | short | bid | 289.4400 | 11.1000 | ["250","255"] | ["0.7616","1.1913"] | [] | ["XISX"] | 250.0000 | 255.0000 | 2 | 30 | false | false | true | true | |||||||||
| 01a0abc5-1a92-7fd0-a631-d5ef3ca75bd3 | COHR | 2026-09-16 15:50 | call_calendar | 2 | 1 | 110 | 1604240.00 | short | ask | 290.8550 | 4.3000 | ["220"] | ["1.4006"] | [] | ["AMXO"] | 220.0000 | 220.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0ab78-61f3-7aa0-9fb1-01eeeee8e0fc | COHR | 2026-09-16 14:26 | call_calendar | 2 | 1 | 28 | 122472.00 | short | ask | 286.1600 | 8.1000 | ["270"] | ["0.9787"] | [] | ["XMIO"] | 270.0000 | 270.0000 | 2 | 9 | false | false | true | false | |||||||||
| 01a0a166-6ce0-7333-a768-d139ffe90a5b | COHR | 2026-09-14 15:30 | call_butterfly_spread | 3 | 1 | 50 | 246125.00 | short | bid | 270.1000 | 6.4000 | ["280","360","440"] | ["0.7523","0.7527","0.7663"] | ["292.05","427.95"] | ["XMIO"] | 280.0000 | 440.0000 | 123 | 123 | false | true | false | ||||||||||
| 01a0a0f7-6ed0-7c10-ba11-eb973cb98b8b | COHR | 2026-09-14 13:29 | call_vertical_spread | 2 | 1 | 4 | 127852.00 | short | bid | 272.6900 | 11.1000 | ["140","145"] | ["0.7944","0.7922"] | ["143.05"] | ["BATO"] | 140.0000 | 145.0000 | 494 | 494 | false | false | false | true | |||||||||
| 01a0a084-abe8-7f02-921c-23a4ef172201 | COHR | 2026-09-14 11:24 | call_butterfly_spread | 3 | 1 | 20 | 100020.00 | short | bid | 274.9000 | 6.2000 | ["250","400","550"] | ["0.7564","0.7595","0.8106"] | ["283.50","516.50"] | ["XMIO"] | 250.0000 | 550.0000 | 123 | 123 | false | false | false | ||||||||||
| 01a0825a-4a39-74c1-b1ca-ae4543416bd2 | COHR | 2026-09-08 14:49 | put_vertical_spread | 2 | 1 | 70 | 210000.00 | short | bid | 305.6150 | 1.4000 | ["270","280"] | ["0.7537","0.7508"] | ["276.40"] | ["XISX"] | 270.0000 | 280.0000 | 38 | 38 | false | true | false | true | |||||||||
| 01a08189-5221-7451-856a-b834079bd7b4 | COHR | 2026-09-08 11:00 | call_vertical_spread | 2 | 1 | 28 | 120624.00 | short | bid | 313.0936 | 7.0000 | ["300","310"] | ["0.8361","0.8215"] | ["305.80"] | ["BATO"] | 300.0000 | 310.0000 | 10 | 10 | false | false | false | true | |||||||||
| 01a06dfd-d015-7ca2-a3c1-870532820b7c | COHR | 2026-09-04 15:55 | put_vertical_spread | 2 | 1 | 17 | 223907.00 | short | bid | 281.5400 | 17.8000 | ["200","250"] | ["0.7943","0.7853"] | ["223.45"] | ["EMLD"] | 200.0000 | 250.0000 | 651 | 651 | false | true | false | true | |||||||||
| 01a06deb-9fd5-7673-975d-173d2c6688b7 | COHR | 2026-09-04 15:35 | straddle | 2 | 6 | 13 | 491020.00 | short | bid | 280.8150 | 3.9077 | ["650"] | ["0.8457"] | ["272.29","1027.71"] | ["AMXO","ARCO","EMLD","XBOX","XMIO","XPHO"] | 650.0000 | 650.0000 | 196 | 196 | false | false | false | false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:17:16Z"} |
| 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-22T14:48:10Z"} |
| 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-21T19:43:07Z"} |
| 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-21T19:41:56Z"} |
| 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-21T19:29:56Z"} |
| 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-21T18:16:40Z"} |
| 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-21T15:05:38Z"} |
| 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-18T18:56:32Z"} |
| 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-18T17:37:27Z"} |
| 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-18T17:37:27Z"} |
| 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-18T17:37:27Z"} |
| 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-18T17:34:46Z"} |
| 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-18T17:34:46Z"} |
| 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-18T17:34:46Z"} |
| 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-18T17:34:46Z"} |
| 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-18T17:32:58Z"} |
| 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-18T17:31:00Z"} |
| 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-18T17:29:57Z"} |
| 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:43:19Z"} |
| 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-18T13:43:19Z"} |
| 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-18T13:38:17Z"} |
| 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-16T19:54:37Z"} |
| 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-16T19:54:14Z"} |
| 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-16T19:50:31Z"} |
| 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-16T18:27:00Z"} |
| 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-14T19:30:44Z"} |
| 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-14T17:29:47Z"} |
| 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-14T15:24:31Z"} |
| 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-08T18:49:19Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:01:17Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:56:00Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:36:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |