core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg600,173 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 |
|---|
| 01a0ed7d-c897-7082-a812-07a30dd1d325 | AVGO | 2026-09-29 10:07 | synthetic | 2 | 3 | 5 | 27981.00 | long | ask | 359.0000 | 1.3500 | ["350"] | ["0.4187"] | ["362.51"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 80 | 80 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-29T14:07:29Z"} | 2026-09-29 | 2026-09-29 17:15 | 2026-09-29 17:15 |
| 01a0ed73-0a97-7c11-9062-20c4c18bb0b4 | AVGO | 2026-09-29 09:55 | synthetic | 2 | 3 | 5 | 28044.00 | long | ask | 358.9600 | 2.2500 | ["350"] | ["0.4193"] | ["362.56"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 80 | 80 | false | false | false | false | |||||||||
| 01a0e97f-db4f-7111-b405-92dfda1ab586 | AVGO | 2026-09-28 15:31 | synthetic | 2 | 1 | 2 | 35912.00 | long | ask | 349.8000 | 3.9500 | ["350"] | ["0.4586"] | ["380.84"] | ["XCBO"] | 350.0000 | 350.0000 | 809 | 809 | false | false | false | false | |||||||||
| 01a0e953-935f-7511-bb7a-ca4a522a3941 | AVGO | 2026-09-28 14:42 | synthetic | 2 | 2 | 7 | 27899.00 | long | ask | 350.6400 | 0.5000 | ["340"] | ["0.3684"] | ["352.95"] | ["XCBO","XISX"] | 340.0000 | 340.0000 | 53 | 53 | false | false | false | false | |||||||||
| 01a0e950-14d7-7690-bbe5-cb9af85a1365 | AVGO | 2026-09-28 14:38 | synthetic | 2 | 3 | 10 | 40070.00 | long | ask | 350.8000 | 0.5500 | ["340"] | ["0.3701"] | ["353.11"] | ["AMXO","XCBO","XISX"] | 340.0000 | 340.0000 | 53 | 53 | false | false | false | false | |||||||||
| 01a0e91f-aa4f-7923-9f23-b557d0199fd5 | AVGO | 2026-09-28 13:45 | synthetic | 2 | 3 | 7 | 28130.00 | long | ask | 351.1490 | 0.4500 | ["340"] | ["0.3704"] | ["353.46"] | ["AMXO","XCBO","XISX"] | 340.0000 | 340.0000 | 53 | 53 | false | false | false | false | |||||||||
| 01a0e8ef-95b7-7560-a281-27f0267e3d2e | AVGO | 2026-09-28 12:53 | synthetic | 2 | 3 | 5 | 27182.00 | long | ask | 351.2550 | 0.7900 | ["350"] | ["0.4142"] | ["354.82"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 81 | 81 | false | false | false | false | |||||||||
| 01a0e8ed-c0f7-7ec1-aaef-fb8749d1a69e | AVGO | 2026-09-28 12:51 | synthetic | 2 | 3 | 5 | 27271.00 | long | ask | 350.9950 | 0.9000 | ["350"] | ["0.4157"] | ["354.55"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 81 | 81 | false | false | false | false | |||||||||
| 01a0e8e7-f87f-7071-b995-52b900478e39 | AVGO | 2026-09-28 12:45 | synthetic | 2 | 3 | 5 | 27274.00 | long | ask | 351.3600 | 1.1000 | ["350"] | ["0.4155"] | ["354.96"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 81 | 81 | false | false | false | false | |||||||||
| 01a0d9c2-7bc7-7330-ae1c-7fb1842a424f | AVGO | 2026-09-25 14:09 | synthetic | 2 | 3 | 5 | 27894.00 | long | ask | 353.1150 | 0.5500 | ["350"] | ["0.4155"] | ["356.76"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 84 | 84 | false | false | false | false | |||||||||
| 01a0d98f-233f-72f3-9449-c04941e5fa63 | AVGO | 2026-09-25 13:13 | synthetic | 2 | 3 | 7 | 38774.00 | long | ask | 352.8100 | 1.1000 | ["350"] | ["0.4128"] | ["356.42"] | ["AMXO","XCBO","XISX"] | 350.0000 | 350.0000 | 84 | 84 | false | false | false | false | |||||||||
| 01a0d3ad-9d2f-7610-8543-0bbe98906eb9 | AVGO | 2026-09-24 09:49 | synthetic | 2 | 1 | 4 | 71440.00 | long | ask | 348.5600 | 6.2500 | ["340"] | ["0.4596"] | ["378.56"] | ["XISX"] | 340.0000 | 340.0000 | 813 | 813 | false | false | false | false | |||||||||
| 01a0ce9f-8037-7361-9c28-ac8d24ee4eed | AVGO | 2026-09-23 10:15 | synthetic | 2 | 1 | 17 | 97801.00 | long | ask | 356.7200 | 1.2000 | ["350"] | ["0.4190"] | ["360.57"] | ["XCBO"] | 350.0000 | 350.0000 | 86 | 86 | false | false | false | false | |||||||||
| 01a0c952-5a87-7311-8559-998ba1db6aae | AVGO | 2026-09-22 09:33 | synthetic | 2 | 1 | 2 | 27210.00 | long | ask | 363.2598 | 6.7500 | ["370"] | ["0.4677"] | ["341.75"] | ["XCBO"] | 370.0000 | 370.0000 | 815 | 815 | false | false | false | false | |||||||||
| 01a0c53e-8f97-7f40-8fff-8509584e48b5 | AVGO | 2026-09-21 14:33 | synthetic | 2 | 1 | 5 | 96625.00 | long | ask | 361.6700 | 3.9000 | ["390"] | ["0.4635"] | ["394.81"] | ["XMIO"] | 390.0000 | 390.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0b4db-1388-7321-a814-f671ce34768d | AVGO | 2026-09-18 10:10 | synthetic | 2 | 1 | 2 | 36850.00 | long | ask | 360.9800 | 3.9500 | ["350"] | ["0.4563"] | ["390.55"] | ["XISX"] | 350.0000 | 350.0000 | 819 | 819 | false | false | false | false | |||||||||
| 01a0b4c6-dbc0-7612-ae8b-c4b324d461bc | AVGO | 2026-09-18 09:48 | synthetic | 2 | 3 | 3 | 25600.00 | long | ask | 361.2900 | 4.0500 | ["350"] | ["0.4254"] | ["368.00"] | ["C2OX","EMLD","SPHR"] | 350.0000 | 350.0000 | 182 | 182 | false | false | false | false | |||||||||
| 01a0b044-e9db-7da0-9b70-0ea99a8d4be2 | AVGO | 2026-09-17 12:48 | synthetic | 2 | 1 | 3 | 35337.00 | long | ask | 349.0800 | 1.4500 | ["350"] | ["0.4331"] | ["362.75"] | ["XISX"] | 350.0000 | 350.0000 | 365 | 365 | false | false | false | false | |||||||||
| 01a0ab95-8acb-7533-8c51-c77e2229efdc | AVGO | 2026-09-16 14:58 | synthetic | 2 | 3 | 6 | 25216.00 | long | bid | 337.1000 | 1.0000 | ["340"] | ["0.3704"] | ["339.11"] | ["AMXO","XCBO","XISX"] | 340.0000 | 340.0000 | 65 | 65 | false | false | false | false | |||||||||
| 01a0a160-b7f0-7250-85f1-9bcd659e09e8 | AVGO | 2026-09-14 15:24 | synthetic | 2 | 2 | 11 | 32890.00 | long | bid | 345.2000 | 0.1000 | ["350"] | ["0.3638"] | ["346"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-b7f0-7250-85f1-9bbc0382c1a6 | AVGO | 2026-09-14 15:24 | synthetic | 2 | 2 | 15 | 44850.00 | long | bid | 345.2000 | 0.3500 | ["350"] | ["0.3638"] | ["346"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-5a30-7611-a93c-0090be88bfb3 | AVGO | 2026-09-14 15:23 | synthetic | 2 | 2 | 21 | 62580.00 | long | bid | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | ["346.10"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-5648-7572-9365-d2b68adfa845 | AVGO | 2026-09-14 15:23 | synthetic | 2 | 2 | 15 | 44700.00 | long | bid | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | ["346.10"] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a08c31-e9a8-7470-916c-285a832a75ac | AVGO | 2026-09-10 12:41 | synthetic | 2 | 1 | 4 | 80948.00 | long | bid | 362.9738 | 4.0500 | ["400"] | ["0.4809"] | ["395.75"] | ["EMLD"] | 400.0000 | 400.0000 | 827 | 827 | false | false | false | false | |||||||||
| 01a0865c-d718-7f12-9b6d-2652930c6069 | AVGO | 2026-09-09 09:30 | synthetic | 2 | 4 | 4 | 52018.00 | long | ask | 367.2800 | 5.1875 | ["360"] | ["0.4574"] | ["381.69"] | ["AMXO","XBOX","XISX","XPHO"] | 360.0000 | 360.0000 | 373 | 373 | false | false | false | false | |||||||||
| 01a06dc7-27e5-7ba1-809c-dd91611ca177 | AVGO | 2026-09-04 14:56 | synthetic | 2 | 2 | 2 | 37408.00 | long | ask | 356.9350 | 1.6500 | ["350"] | ["0.4553"] | ["385.50"] | ["SPHR","XBOX"] | 350.0000 | 350.0000 | 833 | 833 | false | false | false | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T13:55:54Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T19:31:18Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:42:43Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T18:39:24Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:46:03Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:53:41Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:52:00Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:45:28Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T18:10:32Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T17:14:10Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:49:24Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:15:53Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:33:48Z"} |
| 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: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-18T14:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:48:59Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:49:12Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:58:36Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T16:41:22Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:30:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:56:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |