core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0819d-f360-7f93-aca3-b9c61b08dea8 | NOW | 2026-09-08 11:23 | call_calendar | 2 | 1 | 20 | 114240.00 | long | ask | 134.6450 | 2.0500 | ["155"] | ["0.5711"] | [] | ["XMIO"] | 155.0000 | 155.0000 | 374 | 500 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:23:33Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08157-ab30-7161-85e4-27dd0ebd5904 | NOW | 2026-09-08 10:06 | call_diagonal_spread | 2 | 1 | 100 | 306800.00 | long | ask | 134.4900 | 0.8500 | ["132","150"] | ["0.5670","0.5668"] | [] | ["BATO"] | 132.0000 | 150.0000 | 101 | 129 | false | false | true | ||||||||||
| 01a08146-0f60-7f60-bbb5-b4afe0a4e243 | NOW | 2026-09-08 09:47 | put_diagonal_spread | 2 | 1 | 219 | 188340.00 | long | bid | 134.2450 | 0.5000 | ["130","138"] | ["0.5734","0.6722"] | [] | ["XISX"] | 130.0000 | 138.0000 | 3 | 10 | false | false | true | ||||||||||
| 01a0813e-0c98-7aa0-819f-3568ebdb3634 | NOW | 2026-09-08 09:38 | other | 4 | 1 | 70 | 117140.00 | unknown | — | 134.0500 | 0.6900 | ["140","145"] | ["0.6844","0.7090"] | [] | ["XISX"] | 140.0000 | 145.0000 | 3 | 3 | false | false | false | true | true | ||||||||
| 01a0813a-8641-76f0-8bdc-e0020ab06e34 | NOW | 2026-09-08 09:34 | other | 2 | 1 | 60 | 109560.00 | unknown | — | 134.4450 | 0.7000 | ["130","145"] | ["0.6050","0.5905"] | [] | ["XPHO"] | 130.0000 | 145.0000 | 10 | 73 | false | false | true | true | false | ||||||||
| 01a08136-d10a-78c3-965f-194c2fe92c15 | NOW | 2026-09-08 09:30 | other | 6 | 1 | 16 | 116760.00 | unknown | — | 135.6650 | 13.8000 | ["100","105","130","140"] | ["1.0134","0.7589","0.5833","0.5704"] | [] | ["BATO"] | 100.0000 | 140.0000 | 3 | 17 | false | false | true | true | true | ||||||||
| 01a08136-bd2f-7d01-95eb-61148325eafe | NOW | 2026-09-08 09:30 | other | 6 | 1 | 24 | 175632.00 | unknown | — | 135.6650 | 14.4000 | ["100","105","130","140"] | ["1.0816","0.7891","0.5860","0.5639"] | [] | ["SPHR"] | 100.0000 | 140.0000 | 3 | 17 | false | false | true | true | true | ||||||||
| 01a06dfe-9366-7673-a207-01d67f621b84 | NOW | 2026-09-04 15:56 | put_vertical_spread | 2 | 1 | 300 | 122400.00 | short | bid | 141.0000 | 0.3100 | ["138","145"] | ["5.1417","6.3189"] | ["141"] | ["XISX"] | 138.0000 | 145.0000 | 0 | 0 | false | false | false | ||||||||||
| 01a06de0-9f6d-7951-bb7e-6c77c79750b3 | NOW | 2026-09-04 15:23 | other | 6 | 9 | 205 | 183300.00 | unknown | — | 141.1700 | 1.5200 | ["115","130","140","145","160"] | ["0.5587","0.5151","0.5025","0.5521","0.5196"] | [] | ["BATO","C2OX","EMLD","SPHR","XBOX","XISX"] | 115.0000 | 160.0000 | 14 | 133 | false | false | true | true | |||||||||
| 01a06ddb-4c25-7753-b779-9c6adf7a406d | NOW | 2026-09-04 15:18 | risk_reversal | 2 | 1 | 105 | 371595.00 | long | ask | 141.8200 | 1.3000 | ["115","190"] | ["0.5750","0.5622"] | ["194.11"] | ["XMIO"] | 115.0000 | 190.0000 | 378 | 378 | false | true | false | ||||||||||
| 01a06dad-7d95-78c1-94c7-e42a828571c5 | NOW | 2026-09-04 14:27 | put_calendar | 2 | 1 | 80 | 135120.00 | short | ask | 142.2000 | 0.7500 | ["150"] | ["1.5270"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a06d9b-978d-74e2-9063-33446e9795af | NOW | 2026-09-04 14:08 | risk_reversal | 2 | 1 | 80 | 284560.00 | short | bid | 141.8950 | 1.2000 | ["115","190"] | ["0.5788","0.5622"] | ["193.99"] | ["XCBO"] | 115.0000 | 190.0000 | 378 | 378 | false | true | false | ||||||||||
| 01a06d8d-ff15-7253-86d6-66e8282f9149 | NOW | 2026-09-04 13:53 | other | 4 | 2 | 100 | 145199.00 | unknown | — | 141.4350 | 0.6000 | ["135","140"] | ["1.2189","0.5498"] | [] | ["C2OX","XPHO"] | 135.0000 | 140.0000 | 0 | 7 | false | false | true | true | true | ||||||||
| 01a06d88-fdd5-7213-9db8-e9d183d9618b | NOW | 2026-09-04 13:48 | other | 2 | 1 | 61 | 142679.00 | unknown | — | 141.3950 | 0.8000 | ["130"] | ["1.8867"] | [] | ["BATO"] | 130.0000 | 130.0000 | 0 | 7 | false | false | true | false | false | ||||||||
| 01a06d7c-0586-7602-84ee-cb84c9339b1d | NOW | 2026-09-04 13:33 | put_diagonal_spread_bullish | 2 | 3 | 420 | 567296.00 | short | bid | 141.3850 | 0.5000 | ["133","135"] | ["0.5467","0.5163"] | [] | ["ARCO","EDGO","XISX"] | 133.0000 | 135.0000 | 42 | 49 | false | true | |||||||||||
| 01a06d73-2fcd-76d0-a4bd-af0e5352d319 | NOW | 2026-09-04 13:24 | call_diagonal_spread_bullish | 2 | 2 | 123 | 532344.00 | short | bid | 141.5950 | 0.6000 | ["110","130"] | ["0.6122","1.7933"] | [] | ["XCBO"] | 110.0000 | 130.0000 | 0 | 7 | false | false | |||||||||||
| 01a06d60-6f06-7733-812b-1010f3c7d1b8 | NOW | 2026-09-04 13:03 | other | 4 | 2 | 45 | 213552.00 | unknown | — | 140.9600 | 1.9900 | ["85","125","200","240"] | ["0.6200","0.5634","0.5579","0.5700"] | [] | ["BATO","C2OX"] | 85.0000 | 240.0000 | 133 | 133 | false | false | false | true | false | ||||||||
| 01a06d60-6f06-7733-812b-10046d4cc7a1 | NOW | 2026-09-04 13:03 | other | 4 | 4 | 105 | 498138.00 | unknown | — | 140.9600 | 1.9900 | ["85","125","200","240"] | ["0.6008","0.5638","0.5600","0.5698"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 85.0000 | 240.0000 | 133 | 133 | false | false | false | true | false | ||||||||
| 01a06d51-76fe-71c1-ae35-2c54f36b827c | NOW | 2026-09-04 12:47 | call_vertical_spread | 2 | 1 | 18 | 182304.00 | unknown | — | 140.6250 | 2.6500 | ["90","91"] | ["13.5501","13.3639"] | [] | ["XISX"] | 90.0000 | 91.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a06d3a-5905-76f1-a5ea-e0f9bf5b789c | NOW | 2026-09-04 12:22 | call_condor | 4 | 1 | 10 | 106260.00 | long | ask | 141.2950 | 1.9500 | ["110","120","140","150"] | ["0.5718","0.5675","0.5574","0.5571"] | ["112.66","147.34"] | ["XMIO"] | 110.0000 | 150.0000 | 133 | 133 | false | false | false | ||||||||||
| 01a06d31-3145-7171-9e30-007f3170a433 | NOW | 2026-09-04 12:12 | other | 4 | 1 | 30 | 143680.00 | unknown | — | 141.4500 | 2.0400 | ["85","125","200","240"] | ["0.6259","0.5609","0.5550","0.5695"] | [] | ["C2OX"] | 85.0000 | 240.0000 | 133 | 133 | false | false | false | true | false | ||||||||
| 01a06d30-3b2d-7ec3-866a-fd5da0b0fe74 | NOW | 2026-09-04 12:11 | other | 4 | 2 | 30 | 143862.00 | unknown | — | 141.5600 | 2.1000 | ["85","125","200","240"] | ["0.5990","0.5599","0.5580","0.5672"] | [] | ["BATO","C2OX"] | 85.0000 | 240.0000 | 133 | 133 | false | false | false | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:46Z"} |
| 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-08T13:47:33Z"} |
| 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-08T13:38:45Z"} |
| 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-08T13:34:55Z"} |
| 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-08T13:30: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-08T13:30:39Z"} |
| 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-04T19:56:44Z"} |
| 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:24:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:18:22Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:28:25Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:08:31Z"} |
| 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-04T17:53:52Z"} |
| 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-04T17:48:28Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:34:11Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:24:30Z"} |
| 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-04T17:04:06Z"} |
| 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-04T17:04:06Z"} |
| 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:47:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:22:25Z"} |
| 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:12:46Z"} |
| 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:11:37Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |