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 |
|---|
| 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 |
|---|
| 01a0d464-df3e-78b3-89f7-c4c731579184 | AVGO | 2026-09-24 13:09 | straddle | 2 | 1 | 4 | 35576.00 | short | bid | 351.2900 | 2.5000 | ["360"] | ["0.4264"] | ["271.06","448.94"] | ["ARCO"] | 360.0000 | 360.0000 | 204 | 204 | false | false | false | false | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T17:09:35Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d39f-742f-7e73-b780-3b67434a50bb | AVGO | 2026-09-24 09:33 | straddle | 2 | 1 | 2 | 36568.00 | short | bid | 347.7650 | 5.7000 | ["350"] | ["0.4595"] | ["167.16","532.84"] | ["ARCO"] | 350.0000 | 350.0000 | 848 | 848 | false | false | |||||||||||
| 01a0c955-737f-74f3-af71-1f70641d7c46 | AVGO | 2026-09-22 09:36 | straddle | 2 | 2 | 4 | 76536.00 | short | bid | 363.3850 | 4.4500 | ["360"] | ["0.4614"] | ["168.66","551.34"] | ["ARCO","XISX"] | 360.0000 | 360.0000 | 850 | 850 | false | false | |||||||||||
| 01a0c574-8be7-71a2-9588-91409ffb22c5 | AVGO | 2026-09-21 15:32 | straddle | 2 | 1 | 2 | 33584.00 | long | ask | 363.4916 | 3.6000 | ["360"] | ["0.4615"] | ["192.08","527.92"] | ["XBOX"] | 360.0000 | 360.0000 | 634 | 634 | false | false | |||||||||||
| 01a0c539-ff9f-7860-865a-c1de66a49e8d | AVGO | 2026-09-21 14:28 | straddle | 2 | 1 | 10 | 182800.00 | unknown | — | 361.5600 | 3.7000 | ["330"] | ["0.4564"] | [] | ["XMIO"] | 330.0000 | 330.0000 | 816 | 816 | false | false | false | false | |||||||||
| 01a0b522-9c07-7f22-8365-6d85846d01e6 | AVGO | 2026-09-18 11:28 | straddle | 2 | 7 | 8 | 53472.00 | long | ask | 357.4800 | 0.6000 | ["370"] | ["0.4055"] | ["303.16","436.84"] | ["BATO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 370.0000 | 370.0000 | 119 | 119 | false | false | |||||||||||
| 01a0b510-96bf-7763-8e79-26fd4ce92b27 | AVGO | 2026-09-18 11:09 | straddle | 2 | 1 | 50 | 138250.00 | short | bid | 357.7950 | 0.5000 | ["360"] | ["0.3491"] | ["332.35","387.65"] | ["XBOX"] | 360.0000 | 360.0000 | 28 | 28 | false | false | |||||||||||
| 01a0abc1-a7c3-7a33-9e2f-9ab80d1916e0 | AVGO | 2026-09-16 15:46 | straddle | 2 | 1 | 2 | 35040.00 | unknown | — | 339.1100 | 2.6000 | ["340"] | ["0.4579"] | [] | ["XISX"] | 340.0000 | 340.0000 | 821 | 821 | false | false | false | false | |||||||||
| 01a0a160-bbd9-7a01-96a4-0e68239a2fb3 | AVGO | 2026-09-14 15:24 | straddle | 2 | 2 | 10 | 29900.00 | long | ask | 345.2300 | 0.4500 | ["350"] | ["0.3638"] | ["320.10","379.90"] | ["AMXO","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | |||||||||||
| 01a0a160-a081-7a01-8b80-036d6ca2d099 | AVGO | 2026-09-14 15:24 | straddle | 2 | 1 | 10 | 29850.00 | short | bid | 345.1875 | 0.4500 | ["350"] | ["0.3632"] | ["320.15","379.85"] | ["XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | |||||||||||
| 01a0a160-5a30-7611-a93c-00c75af14b03 | AVGO | 2026-09-14 15:23 | straddle | 2 | 2 | 21 | 62580.00 | unknown | — | 345.2400 | 0.2000 | ["350"] | ["0.3626"] | [] | ["XISX","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | false | false | |||||||||
| 01a0a160-5260-73c1-b16b-5c16f22b869d | AVGO | 2026-09-14 15:23 | straddle | 2 | 6 | 46 | 137080.00 | long | ask | 345.2695 | 0.5380 | ["350"] | ["0.3626"] | ["320.2","379.80"] | ["EMLD","XBOX","XCBO","XISX","XMIO","XPHO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | |||||||||||
| 01a0a160-46a9-79c1-b256-22f2d9ac0498 | AVGO | 2026-09-14 15:23 | straddle | 2 | 3 | 16 | 47600.00 | short | bid | 345.2000 | 0.6500 | ["350"] | ["0.3620"] | ["320.25","379.75"] | ["EMLD","XBOX","XMIO"] | 350.0000 | 350.0000 | 32 | 32 | false | false | |||||||||||
| 01a0a042-0569-7ee2-b1f4-913b83169944 | AVGO | 2026-09-14 10:11 | straddle | 2 | 1 | 2 | 29252.00 | long | ask | 348.2300 | 4.5500 | ["370"] | ["0.4583"] | ["223.74","516.26"] | ["XBOX"] | 370.0000 | 370.0000 | 494 | 494 | false | false | |||||||||||
| 01a08c97-c7c9-7f00-9458-dfe65edd8d35 | AVGO | 2026-09-10 14:32 | straddle | 2 | 2 | 2 | 38120.00 | unknown | — | 362.5000 | 2.4000 | ["350"] | ["0.4758"] | [] | ["ARCO","XBOX"] | 350.0000 | 350.0000 | 827 | 827 | false | false | false | false | |||||||||
| 01a087a0-8278-7d43-80e8-91b37b275631 | AVGO | 2026-09-09 15:23 | straddle | 2 | 1 | 80 | 139280.00 | long | ask | 363.6000 | 0.4500 | ["365"] | ["0.3812"] | ["347.59","382.41"] | ["EDGO"] | 365.0000 | 365.0000 | 9 | 9 | false | false | |||||||||||
| 01a086b8-7ff0-7c02-b966-ebff1f8f7cb0 | AVGO | 2026-09-09 11:10 | straddle | 2 | 1 | 12 | 137580.00 | long | ask | 361.2600 | 2.7500 | ["380"] | ["0.4544"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a086b7-4770-7561-ac45-b7052f55acee | AVGO | 2026-09-09 11:09 | straddle | 2 | 1 | 13 | 149045.00 | short | bid | 361.4600 | 4.0000 | ["380"] | ["0.4543"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a086b6-2a49-7111-9c02-05a977a1900a | AVGO | 2026-09-09 11:07 | straddle | 2 | 1 | 8 | 91720.00 | short | bid | 361.7300 | 3.7000 | ["380"] | ["0.4541"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a086b1-bd78-7373-b276-1c7c00437d17 | AVGO | 2026-09-09 11:03 | straddle | 2 | 1 | 8 | 91720.00 | short | bid | 362.1350 | 3.8500 | ["380"] | ["0.4540"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a086ad-3938-7fd2-9d1f-67c54a86ae89 | AVGO | 2026-09-09 10:58 | straddle | 2 | 2 | 21 | 240751.00 | short | bid | 362.0500 | 3.8500 | ["380"] | ["0.4540"] | ["265.36","494.64"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a086a6-e038-77b1-ba9b-89bf59ebb7fd | AVGO | 2026-09-09 10:51 | straddle | 2 | 1 | 9 | 103104.00 | short | bid | 362.2500 | 2.8500 | ["380"] | ["0.4535"] | ["265.44","494.56"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a086a3-d2f8-7e11-ae3d-35a479f7a6b4 | AVGO | 2026-09-09 10:47 | straddle | 2 | 1 | 9 | 103185.00 | short | bid | 363.1300 | 2.8000 | ["380"] | ["0.4535"] | ["265.35","494.65"] | ["C2OX"] | 380.0000 | 380.0000 | 281 | 281 | false | false | |||||||||||
| 01a06de5-17f5-7653-8b6f-f8caea465bed | AVGO | 2026-09-04 15:28 | straddle | 2 | 1 | 4 | 35220.00 | long | ask | 356.2300 | 1.5000 | ["350"] | ["0.4268"] | ["261.95","438.05"] | ["XISX"] | 350.0000 | 350.0000 | 196 | 196 | false | false | |||||||||||
| 01a06dc9-8945-7060-9f79-ed13d79829d1 | AVGO | 2026-09-04 14:58 | straddle | 2 | 3 | 3 | 56068.00 | short | bid | 356.7500 | 2.9500 | ["350"] | ["0.4551"] | ["163.11","536.89"] | ["ARCO","SPHR","XBOX"] | 350.0000 | 350.0000 | 833 | 833 | false | false |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:33:59Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:37:00Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:32:27Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:28:39Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:29:12Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:09:17Z"} |
| 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-16T19:46:33Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| true |
| 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 |
| false |
| true |
| mlet |
| 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-14T19:24:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| true |
| mlet |
| market_whale |
| 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 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:23:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:11:28Z"} |
| 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-10T18:33:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:24:21Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:10:40Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:09:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:08:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:03:26Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:58:45Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:51:35Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:48:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:29:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| false |
| true |
| 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 |