core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0cf6c-710e-7a73-a840-67e5fbb390ef | XOM | 2026-09-23 13:59 | synthetic | 2 | 1 | 5 | 26860.00 | long | ask | 161.2050 | 2.7500 | ["160"] | ["0.2817"] | ["168.40"] | ["XMIO"] | 160.0000 | 160.0000 | 849 | 849 | false | false | false | false | true | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T17:59:48Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0c996-b29f-7543-aa9b-4a232447609e | XOM | 2026-09-22 10:48 | synthetic | 2 | 1 | 10 | 52420.00 | long | ask | 159.3700 | 2.2500 | ["165"] | ["0.2840"] | ["166.50"] | ["XMIO"] | 165.0000 | 165.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c994-7467-70b1-acde-5f9d68a4ab81 | XOM | 2026-09-22 10:45 | synthetic | 2 | 1 | 10 | 52660.00 | long | ask | 159.5750 | 2.0000 | ["165"] | ["0.2850"] | ["166.70"] | ["XCBO"] | 165.0000 | 165.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c98d-4877-76a2-bf0c-d42df190f773 | XOM | 2026-09-22 10:37 | synthetic | 2 | 1 | 10 | 52850.00 | long | ask | 158.5300 | 2.4000 | ["165"] | ["0.2820"] | ["166.25"] | ["XCBO"] | 165.0000 | 165.0000 | 850 | 850 | false | false | false | false | |||||||||
| 01a0c98b-f0b7-7af2-8a65-14a79dd30f84 | XOM | 2026-09-22 10:36 | synthetic | 2 | 1 | 10 | 52680.00 | short | bid | 158.8950 | 2.5500 | ["165"] | ["0.2805"] | ["166.30"] | ["XMIO"] | 165.0000 | 165.0000 | 850 | 850 | false | false | false | false | |||||||||
| 01a0c986-ad0f-7401-a98a-2b60349cdbb8 | XOM | 2026-09-22 10:30 | synthetic | 2 | 1 | 10 | 51470.00 | long | ask | 158.8050 | 2.0500 | ["160"] | ["0.2796"] | ["165.75"] | ["XCBO"] | 160.0000 | 160.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c986-300f-7ff1-b2e7-cf55ea314e90 | XOM | 2026-09-22 10:30 | synthetic | 2 | 1 | 10 | 51040.00 | long | ask | 158.7250 | 2.4000 | ["160"] | ["0.2773"] | ["165.70"] | ["XMIO"] | 160.0000 | 160.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c980-6b7f-7713-a044-31e6ae4a1f4d | XOM | 2026-09-22 10:23 | synthetic | 2 | 1 | 10 | 40960.00 | long | ask | 158.4850 | 1.2500 | ["160"] | ["0.2858"] | ["162.80"] | ["XMIO"] | 160.0000 | 160.0000 | 486 | 486 | false | false | false | false | |||||||||
| 01a0c97f-13bf-7163-bd44-abc61cfca5e3 | XOM | 2026-09-22 10:22 | synthetic | 2 | 1 | 10 | 40990.00 | long | ask | 158.4200 | 1.2500 | ["160"] | ["0.2861"] | ["162.85"] | ["XCBO"] | 160.0000 | 160.0000 | 486 | 486 | false | false | false | false | |||||||||
| 01a0c97e-583f-7282-8312-4c425325bb34 | XOM | 2026-09-22 10:21 | synthetic | 2 | 1 | 10 | 41330.00 | long | ask | 158.5500 | 1.3500 | ["160"] | ["0.2884"] | ["162.95"] | ["XCBO"] | 160.0000 | 160.0000 | 486 | 486 | false | false | false | false | |||||||||
| 01a0c544-3cb7-7ac0-a19f-b629b9d01cfc | XOM | 2026-09-21 14:39 | synthetic | 2 | 1 | 10 | 41050.00 | long | ask | 158.9399 | 0.8000 | ["160"] | ["0.2853"] | ["163.45"] | ["XMIO"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c543-e6c7-7472-b742-18e7588ec5f7 | XOM | 2026-09-21 14:39 | synthetic | 2 | 1 | 10 | 41080.00 | long | ask | 158.9400 | 0.8000 | ["160"] | ["0.2855"] | ["163.42"] | ["XCBO"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c543-8cee-7b62-9453-e2d5753d01b7 | XOM | 2026-09-21 14:38 | synthetic | 2 | 1 | 10 | 41200.00 | long | ask | 158.9500 | 1.3500 | ["160"] | ["0.2864"] | ["163.38"] | ["XCBO"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c543-2b46-7c21-aef3-64711594a73b | XOM | 2026-09-21 14:38 | synthetic | 2 | 1 | 10 | 41150.00 | long | ask | 158.9500 | 1.4000 | ["160"] | ["0.2860"] | ["163.35"] | ["XMIO"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c53f-4347-7262-b04a-a0c487bec88c | XOM | 2026-09-21 14:34 | synthetic | 2 | 1 | 10 | 51500.00 | long | ask | 158.9150 | 2.0500 | ["160"] | ["0.2794"] | ["165.88"] | ["XCBO"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53e-fcf6-75f0-94c8-33872ea93c76 | XOM | 2026-09-21 14:33 | synthetic | 2 | 1 | 10 | 51500.00 | long | ask | 158.9250 | 2.0500 | ["160"] | ["0.2794"] | ["165.88"] | ["XCBO"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53d-2c1f-74c0-a136-ff21fb5b8054 | XOM | 2026-09-21 14:31 | synthetic | 2 | 1 | 10 | 51480.00 | long | ask | 158.9050 | 2.0500 | ["160"] | ["0.2793"] | ["165.88"] | ["XMIO"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53c-8fdf-7400-b4e8-8ddccf0651bc | XOM | 2026-09-21 14:31 | synthetic | 2 | 1 | 10 | 51670.00 | short | bid | 158.9300 | 1.6500 | ["160"] | ["0.2803"] | ["165.85"] | ["XMIO"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c539-b567-7852-836e-2ee20ca0ca3e | XOM | 2026-09-21 14:28 | synthetic | 2 | 1 | 10 | 52230.00 | short | bid | 158.8550 | 2.6500 | ["160"] | ["0.2778"] | ["166.15"] | ["XCBO"] | 160.0000 | 160.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c539-347e-78b0-9c1b-f8b998aad769 | XOM | 2026-09-21 14:27 | synthetic | 2 | 1 | 10 | 52230.00 | short | bid | 158.9400 | 2.6500 | ["160"] | ["0.2776"] | ["166.15"] | ["XCBO"] | 160.0000 | 160.0000 | 851 | 851 | false | false | false | false |
| mlat |
| tracked |
| 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 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:45:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:38:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:36:49Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:30:46Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:30:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:24:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:22:35Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:22:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:40:04Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:39:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:39:33Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:38:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:34:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:34:29Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:32:11Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:31:22Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:28:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:27:43Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |