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 | 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 |
|---|
| 01a0c9aa-4e26-7123-87bc-a2e4195a457e | XOM | 2026-09-22 11:09 | synthetic | 2 | 1 | 10 | 36310.00 | short | bid | 159.3150 | 2.4500 | ["160"] | ["0.2916"] | ["162.15"] | ["XISX"] | 160.0000 | 160.0000 | 360 | 360 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T15:09:50Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c995-feef-7512-a416-c631ca72e2d8 | XOM | 2026-09-22 10:47 | synthetic | 2 | 1 | 10 | 52640.00 | short | bid | 159.4900 | 1.9000 | ["165"] | ["0.2850"] | ["166.42"] | ["XISX"] | 165.0000 | 165.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c994-419f-76d2-b1cb-eeb0783c6e66 | XOM | 2026-09-22 10:45 | synthetic | 2 | 1 | 10 | 52550.00 | long | ask | 159.5150 | 2.2000 | ["165"] | ["0.2845"] | ["166.41"] | ["XPHO"] | 165.0000 | 165.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c98c-defe-7732-a769-9e3bc9d3381e | XOM | 2026-09-22 10:37 | synthetic | 2 | 1 | 10 | 52850.00 | short | bid | 158.5310 | 2.5000 | ["165"] | ["0.2820"] | ["166.07"] | ["XISX"] | 165.0000 | 165.0000 | 850 | 850 | false | false | false | false | |||||||||
| 01a0c98b-c1d7-7542-aab5-ea2bea4b9f0e | XOM | 2026-09-22 10:36 | synthetic | 2 | 1 | 10 | 52660.00 | short | bid | 158.8600 | 3.1500 | ["165"] | ["0.2804"] | ["166.10"] | ["XISX"] | 165.0000 | 165.0000 | 850 | 850 | false | false | false | false | |||||||||
| 01a0c986-85ff-7e81-9748-d79ded600583 | XOM | 2026-09-22 10:30 | synthetic | 2 | 1 | 10 | 51540.00 | long | ask | 158.7500 | 1.3000 | ["160"] | ["0.2801"] | ["165.42"] | ["XPHO"] | 160.0000 | 160.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c985-f95f-7d30-9622-561b61c91359 | XOM | 2026-09-22 10:29 | synthetic | 2 | 1 | 10 | 51070.00 | long | ask | 158.7800 | 2.4000 | ["160"] | ["0.2773"] | ["165.43"] | ["XCBO"] | 160.0000 | 160.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c980-4c3f-71f0-8ec7-789ae508f4a0 | XOM | 2026-09-22 10:23 | synthetic | 2 | 1 | 10 | 41120.00 | long | ask | 158.4650 | 1.2500 | ["160"] | ["0.2870"] | ["162.68"] | ["XISX"] | 160.0000 | 160.0000 | 486 | 486 | false | false | false | false | |||||||||
| 01a0c97e-777f-7dd1-a8db-0ef6ceb10a93 | XOM | 2026-09-22 10:21 | synthetic | 2 | 1 | 10 | 41150.00 | long | ask | 158.4800 | 1.2500 | ["160"] | ["0.2872"] | ["162.73"] | ["XISX"] | 160.0000 | 160.0000 | 486 | 486 | false | false | false | false | |||||||||
| 01a0c544-215e-7c32-a838-140977fc3ccc | XOM | 2026-09-21 14:39 | synthetic | 2 | 1 | 10 | 41060.00 | short | bid | 158.9300 | 0.8000 | ["160"] | ["0.2854"] | ["163.10"] | ["XPHO"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c543-7196-70a2-b288-712427169fb2 | XOM | 2026-09-21 14:38 | synthetic | 2 | 1 | 10 | 41060.00 | short | bid | 158.9900 | 1.3500 | ["160"] | ["0.2853"] | ["163.10"] | ["XISX"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c542-ecc6-7430-a752-a81bfc5f7ca7 | XOM | 2026-09-21 14:38 | synthetic | 2 | 1 | 10 | 41030.00 | short | bid | 158.9600 | 1.4000 | ["160"] | ["0.2851"] | ["163.07"] | ["XPHO"] | 160.0000 | 160.0000 | 487 | 487 | false | false | false | false | |||||||||
| 01a0c53f-27ef-7ad0-8a22-ddd44dc8cfda | XOM | 2026-09-21 14:34 | synthetic | 2 | 1 | 10 | 51350.00 | short | bid | 158.9100 | 2.0500 | ["160"] | ["0.2785"] | ["165.51"] | ["XPHO"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53e-e19e-7602-8995-1da54507ad96 | XOM | 2026-09-21 14:33 | synthetic | 2 | 1 | 10 | 51350.00 | short | bid | 158.9700 | 2.0500 | ["160"] | ["0.2784"] | ["165.53"] | ["XISX"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53d-0cdf-7f20-b71e-24682a7cf8d0 | XOM | 2026-09-21 14:31 | synthetic | 2 | 1 | 10 | 51740.00 | short | bid | 158.9300 | 1.6500 | ["160"] | ["0.2807"] | ["165.52"] | ["XISX"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53c-ab36-7e43-a311-8655c20443e4 | XOM | 2026-09-21 14:31 | synthetic | 2 | 1 | 10 | 51750.00 | short | bid | 158.9500 | 1.6500 | ["160"] | ["0.2808"] | ["165.49"] | ["XISX"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c53c-515e-7ad2-8640-78bbf87c409b | XOM | 2026-09-21 14:30 | synthetic | 2 | 1 | 10 | 51750.00 | short | bid | 158.9200 | 1.6500 | ["160"] | ["0.2808"] | ["165.49"] | ["XISX"] | 160.0000 | 160.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0c539-9626-72c2-96bc-b2eeab20fda6 | XOM | 2026-09-21 14:27 | synthetic | 2 | 1 | 10 | 52600.00 | short | bid | 158.9300 | 2.6500 | ["160"] | ["0.2797"] | ["165.84"] | ["XPHO"] | 160.0000 | 160.0000 | 851 | 851 | false | false | false | false | |||||||||
| 01a0c538-ee2f-7450-8210-bfe01e7b6809 | XOM | 2026-09-21 14:27 | synthetic | 2 | 1 | 10 | 51850.00 | short | bid | 158.9250 | 3.4000 | ["160"] | ["0.2754"] | ["165.83"] | ["XPHO"] | 160.0000 | 160.0000 | 851 | 851 | false | false | false | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:47:38Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:37:50Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:36:21Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:29:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:38:17Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:33:51Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |
| mlet |
| 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 |