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 |
|---|
| 01a0d968-9bf7-7841-a15b-6ae3c24b1899 | XOM | 2026-09-25 12:31 | call_butterfly_spread | 3 | 1 | 1200 | 158400.00 | short | bid | 160.4250 | 0.3200 | ["162.5","167.5","172.5"] | ["0.2739","0.2816","0.3145"] | ["163.34","171.66"] | ["EDGO"] | 162.5000 | 172.5000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T16:32:12Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d43a-f0df-7441-aeac-6d10f7fbdef1 | XOM | 2026-09-24 12:23 | call_calendar | 2 | 1 | 13 | 168480.00 | short | ask | 162.7200 | 6.8000 | ["105"] | ["0.3343"] | [] | ["XMIO"] | 105.0000 | 105.0000 | 813 | 848 | false | false | true | false | |||||||||
| 01a0cec2-7187-7fd1-ad38-1f5fc6742d35 | XOM | 2026-09-23 10:54 | call_calendar | 2 | 1 | 17 | 196350.00 | short | ask | 161.0150 | 6.0000 | ["110"] | ["0.3347"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 485 | 849 | false | false | true | false | |||||||||
| 01a0c4a2-6aef-7ad3-bc51-b4310500970c | XOM | 2026-09-21 11:42 | put_vertical_spread | 2 | 1 | 59 | 188387.00 | long | ask | 159.0400 | 2.3500 | ["165","182.5"] | ["0.2792","0.3346"] | ["167.45"] | ["XCBO"] | 165.0000 | 182.5000 | 32 | 32 | true | false | false | ||||||||||
| 01a0c430-9e1f-7930-b322-412b175eafc5 | XOM | 2026-09-21 09:38 | iron_butterfly | 4 | 1 | 170 | 107780.00 | unknown | bid | 160.5200 | 1.0600 | ["157.5","162.5","170"] | ["0.3606","0.3536","0.3564"] | ["161.52"] | ["XMIO"] | 157.5000 | 170.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0b58e-6d97-7f02-9061-4632b4078bea | XOM | 2026-09-18 13:26 | call_diagonal_spread | 2 | 1 | 149 | 262389.00 | unknown | ask | 162.6700 | 0.9000 | ["155","160"] | ["1.9630","0.2895"] | [] | ["XBOX"] | 155.0000 | 160.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b583-03b7-76e0-9847-6b31c642269e | XOM | 2026-09-18 13:14 | call_diagonal_spread | 2 | 1 | 293 | 505425.00 | long | ask | 162.6000 | 0.9000 | ["155","160"] | ["1.3842","0.2854"] | [] | ["XCBO"] | 155.0000 | 160.0000 | 0 | 63 | false | false | true | ||||||||||
| 01a0b0d5-6a0b-74f3-9e33-dfb803e801c0 | XOM | 2026-09-17 15:26 | call_vertical_spread | 2 | 1 | 500 | 120000.00 | unknown | — | 162.7801 | 0.1100 | ["165","170"] | ["0.2837","0.2840"] | [] | ["EDGO"] | 165.0000 | 170.0000 | 8 | 8 | false | true | false | true | false | ||||||||
| 01a0b0b3-4bab-7282-977d-c5841e2d7a96 | XOM | 2026-09-17 14:48 | call_diagonal_spread | 2 | 1 | 120 | 129280.00 | unknown | — | 162.8400 | 1.1000 | ["155","160"] | ["0.4471","0.2890"] | [] | ["XMIO"] | 155.0000 | 160.0000 | 1 | 15 | false | false | true | true | false | ||||||||
| 01a0a650-ff66-7ab3-9d19-5832b5a60d84 | XOM | 2026-09-15 14:25 | call_calendar | 2 | 1 | 30 | 155370.00 | long | ask | 169.0200 | 1.7500 | ["145"] | ["0.3051"] | [] | ["XCBO"] | 145.0000 | 145.0000 | 31 | 94 | false | false | true | false | |||||||||
| 01a0a0c9-fa18-7bf3-b7fe-6eef4a14a853 | XOM | 2026-09-14 12:39 | call_diagonal_spread | 2 | 1 | 238 | 538356.00 | short | ask | 165.8600 | 0.6500 | ["150","175"] | ["0.3279","0.2920"] | [] | ["XPHO"] | 150.0000 | 175.0000 | 32 | 67 | false | false | true | ||||||||||
| 01a0a0c9-cf20-7712-b23a-12a9dd47e32a | XOM | 2026-09-14 12:39 | other | 2 | 1 | 259 | 490495.00 | unknown | — | 165.8750 | 0.8000 | ["160","170"] | ["0.3512","0.2806"] | [] | ["XMIO"] | 160.0000 | 170.0000 | 4 | 186 | false | false | true | true | false | mlat | |||||||
| 01a0a06b-1908-7740-8d37-3a0cfa784cff | XOM | 2026-09-14 10:56 | put_vertical_spread | 2 | 1 | 120 | 137760.00 | unknown | — | 167.5100 | 0.5000 | ["155","160"] | ["0.3211","0.3199"] | [] | ["XCBO"] | 155.0000 | 160.0000 | 95 | 95 | false | true | false | true | false | ||||||||
| 01a09136-c770-73b0-893e-c2cf33daf3de | XOM | 2026-09-11 12:04 | call_calendar | 2 | 1 | 161 | 507472.00 | long | ask | 165.6200 | 1.0500 | ["150"] | ["1.3396"] | [] | ["XMIO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | |||||||||
| 01a09107-ef40-7920-bd06-43d0361ed9df | XOM | 2026-09-11 11:13 | other | 4 | 1 | 1300 | 495300.00 | unknown | — | 164.2900 | 1.2500 | ["162.5","167.5","172.5"] | ["0.4559","0.3688","0.2959"] | [] | ["EDGO"] | 162.5000 | 172.5000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a090ec-1e28-7d10-b123-be9e1b5fe866 | XOM | 2026-09-11 10:43 | other | 4 | 1 | 1380 | 672056.00 | unknown | — | 165.0200 | 0.9600 | ["162.5","167.5","172.5"] | ["0.5017","0.3279","0.3053"] | [] | ["EDGO"] | 162.5000 | 172.5000 | 0 | 7 | false | false | true | true | false | ||||||||
| 01a090e1-48b8-7d63-a50d-c48c9c28f595 | XOM | 2026-09-11 10:31 | call_diagonal_spread | 2 | 1 | 50 | 322200.00 | long | ask | 166.0050 | 3.1000 | ["135","145"] | ["0.4309","0.2416"] | [] | ["XCBO"] | 135.0000 | 145.0000 | 35 | 371 | false | false | true | ||||||||||
| 01a06d53-4fa5-7802-8caa-152512c155b0 | XOM | 2026-09-04 12:49 | call_butterfly_spread | 3 | 1 | 1560 | 158858.00 | short | bid | 160.5000 | 0.2500 | ["162.5","167.5","172.5"] | ["0.2376","0.2522","0.2821"] | ["163.26","171.74"] | ["EDGO"] | 162.5000 | 172.5000 | 7 | 7 | false | true | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:23:52Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:54:02Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:43:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:38:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:26:47Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:14:48Z"} |
| 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:26:38Z"} |
| 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-17T18:49:10Z"} |
| 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-15T18:25:43Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:40:05Z"} |
| 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-14T16:40:05Z"} |
| 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-14T14:56:27Z"} |
| 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-11T16:04:51Z"} |
| 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-11T15:13:53Z"} |
| 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-11T14:43:24Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:31:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:49:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |