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 |
|---|
| 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 | true | 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 |
| 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 | |||||||||
| 01a0aba1-526a-71b2-9adf-2f5c3e517e31 | AVGO | 2026-09-16 15:11 | synthetic | 2 | 3 | 3 | 34678.00 | short | bid | 336.2800 | 4.8000 | ["350"] | ["0.4351"] | ["350"] | ["C2OX","EMLD","SPHR"] | 350.0000 | 350.0000 | 366 | 366 | 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 | |||||||||
| 01a0ab94-795a-7991-9c34-a291893a92ac | AVGO | 2026-09-16 14:57 | synthetic | 2 | 1 | 5 | 58010.00 | short | bid | 337.4250 | 4.8000 | ["350"] | ["0.4359"] | ["352.00"] | ["BATO"] | 350.0000 | 350.0000 | 366 | 366 | false | false | false | false | |||||||||
| 01a0ab80-7073-7de0-8170-e3727cdcbfb5 | AVGO | 2026-09-16 14:35 | synthetic | 2 | 2 | 2 | 32644.00 | short | ask | 338.6100 | 6.0000 | ["380"] | ["0.4551"] | ["363.12"] | ["C2OX","SPHR"] | 380.0000 | 380.0000 | 639 | 639 | false | false | false | false | |||||||||
| 01a0a59c-d64e-7a01-bbfa-032980531786 | AVGO | 2026-09-15 11:08 | synthetic | 2 | 1 | 10 | 175990.00 | short | bid | 342.4150 | 4.3000 | ["330"] | ["0.4482"] | ["370.25"] | ["XISX"] | 330.0000 | 330.0000 | 822 | 822 | false | false | false | false | |||||||||
| 01a0a0a9-0880-7b92-a710-1c4711aa29a3 | AVGO | 2026-09-14 12:03 | synthetic | 2 | 2 | 2 | 27054.00 | unknown | — | 346.5300 | 3.4500 | ["440"] | ["0.4479"] | [] | ["SPHR","XBOX"] | 440.0000 | 440.0000 | 276 | 276 | false | false | false | false | true | mlet | |||||||
| 01a0a051-c0c0-7d21-912d-14ba93eed709 | AVGO | 2026-09-14 10:28 | synthetic | 2 | 1 | 3 | 54960.00 | unknown | — | 346.0950 | 3.9500 | ["350"] | ["0.4680"] | [] | ["XISX"] | 350.0000 | 350.0000 | 823 | 823 | false | false | false | false | true | mlet | |||||||
| 01a091cd-5e39-7d90-ab97-c1b476fe8cf6 | AVGO | 2026-09-11 14:49 | synthetic | 2 | 2 | 5 | 43892.00 | short | bid | 363.8550 | 2.0000 | ["350"] | ["0.4294"] | ["371.00"] | ["EDGO","EMLD"] | 350.0000 | 350.0000 | 189 | 189 | false | false | false | false | |||||||||
| 01a08c96-3d40-7293-8bb6-2b98225583b3 | AVGO | 2026-09-10 14:30 | synthetic | 2 | 3 | 5 | 95130.00 | short | bid | 362.4101 | 2.0000 | ["350"] | ["0.4750"] | ["391.30"] | ["EMLD","SPHR","XBOX"] | 350.0000 | 350.0000 | 827 | 827 | 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 | |||||||||
| 01a086a2-34e8-7eb3-9a18-ad1eaf7ce55f | AVGO | 2026-09-09 10:46 | synthetic | 2 | 1 | 2 | 28602.00 | short | bid | 363.2300 | 3.1000 | ["330"] | ["0.4625"] | ["379.25"] | ["MCRY"] | 330.0000 | 330.0000 | 464 | 464 | 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 | |||||||||
| 01a081b4-de90-7ff3-9688-f31ed573e8e2 | AVGO | 2026-09-08 11:48 | synthetic | 2 | 2 | 2 | 30400.00 | unknown | — | 369.8000 | 4.3500 | ["370"] | ["0.4558"] | [] | ["C2OX","XBOX"] | 370.0000 | 370.0000 | 500 | 500 | false | false | false | false | true | mlet | |||||||
| 01a0815c-eed8-7bb2-be45-04ac85d0ec65 | AVGO | 2026-09-08 10:12 | synthetic | 2 | 1 | 2 | 38580.00 | short | bid | 367.3900 | 4.3500 | ["350"] | ["0.4689"] | ["395.80"] | ["XCBO"] | 350.0000 | 350.0000 | 829 | 829 | false | false | false | false | |||||||||
| 01a06dc9-8945-7060-9f79-ed20d567597d | AVGO | 2026-09-04 14:58 | synthetic | 2 | 2 | 2 | 37559.00 | short | bid | 356.7500 | 2.9000 | ["350"] | ["0.4575"] | ["385.18"] | ["BATO","C2OX"] | 350.0000 | 350.0000 | 833 | 833 | 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 | |||||||||
| 01a06dc6-fced-7252-bc1f-6725fc45b294 | AVGO | 2026-09-04 14:55 | synthetic | 2 | 3 | 4 | 74798.00 | short | bid | 356.9500 | 2.1500 | ["350"] | ["0.4552"] | ["385.40"] | ["ARCO","SPHR","XBOX"] | 350.0000 | 350.0000 | 833 | 833 | false | false | false | false | |||||||||
| 01a06d75-336d-7572-ab68-515af11b7111 | AVGO | 2026-09-04 13:26 | synthetic | 2 | 2 | 2 | 36792.00 | short | bid | 354.8400 | 1.5500 | ["340"] | ["0.4527"] | ["382.10"] | ["BATO","C2OX"] | 340.0000 | 340.0000 | 833 | 833 | false | false | false | false | |||||||||
| 01a06d75-336d-7572-ab68-514ca7cce990 | AVGO | 2026-09-04 13:26 | synthetic | 2 | 3 | 4 | 73738.00 | short | bid | 354.8400 | 1.8000 | ["340"] | ["0.4538"] | ["382.10"] | ["EMLD","SPHR","XBOX"] | 340.0000 | 340.0000 | 833 | 833 | false | false | false | false |
| 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-16T19:11:15Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:57:20Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:35:30Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:08:36Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:04:17Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:28:36Z"} |
| 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-11T18:49:21Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:31:18Z"} |
| 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-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-09T14:46:22Z"} |
| 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-09T13:30:30Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:48:38Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:12:29Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:59:01Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| 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 |
| 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 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:26:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:26:45Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |