core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 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 |
|---|
| 01a0f7e8-1e9e-7803-93f3-9b8cb6733337 | LRCX | 2026-10-01 10:39 | straddle | 2 | 3 | 6 | 109140.00 | long | ask | 338.5700 | 3.5917 | ["350"] | ["0.6096"] | ["168.1","531.90"] | ["ARCO","XISX","XPHO"] | 350.0000 | 350.0000 | 477 | 477 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T14:39:57Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f7e8-072f-7a41-b982-7384625873a4 | LRCX | 2026-10-01 10:39 | straddle | 2 | 1 | 6 | 109110.00 | long | ask | 338.4250 | 3.2500 | ["350"] | ["0.6096"] | ["168.15","531.85"] | ["XISX"] | 350.0000 | 350.0000 | 477 | 477 | false | false | false | false | |||||||||
| 01a0f7e7-ff5e-7290-9d4c-6838cd15acdb | LRCX | 2026-10-01 10:39 | straddle | 2 | 5 | 150 | 2728200.00 | long | ask | 338.5800 | 5.7000 | ["350"] | ["0.6095"] | ["168.12","531.88"] | ["C2OX","EDGO","EMLD","XBOX","XISX"] | 350.0000 | 350.0000 | 477 | 477 | false | false | false | ||||||||||
| 01a0f7c7-d116-7432-99d7-7b0d223c0bf0 | LRCX | 2026-10-01 10:04 | straddle | 2 | 1 | 105 | 1595685.00 | long | ask | 335.1350 | 2.2000 | ["400"] | ["0.6093"] | ["248.03","551.97"] | ["XISX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c6-b007-7671-860b-4484e484e5ec | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 8 | 121656.00 | short | bid | 334.5550 | 2.5000 | ["400"] | ["0.6097"] | ["247.93","552.07"] | ["XMIO"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c6-b007-7671-860b-447c811eaddf | LRCX | 2026-10-01 10:03 | straddle | 2 | 3 | 31 | 471297.00 | short | bid | 334.5450 | 2.5500 | ["400"] | ["0.6096"] | ["247.97","552.03"] | ["AMXO","EDGO","XISX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c6-ac1f-7981-a7e0-c165d58f4f3b | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 8 | 121600.00 | long | ask | 334.5450 | 2.1000 | ["400"] | ["0.6094"] | ["248","552.00"] | ["XISX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | false | |||||||||
| 01a0f7c6-a44e-75f1-ba32-5efa9fcaaaad | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 7 | 106400.00 | short | bid | 334.4250 | 3.0000 | ["400"] | ["0.6094"] | ["248","552.00"] | ["XISX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | false | |||||||||
| 01a0f7c6-a066-74d0-8e3b-d6c610d62129 | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 8 | 121600.00 | long | ask | 334.4250 | 1.6500 | ["400"] | ["0.6094"] | ["248","552.00"] | ["XISX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | false | |||||||||
| 01a0f7c6-a066-74d0-8e3b-d6b32806325a | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 7 | 106400.00 | long | ask | 334.4250 | 2.5500 | ["400"] | ["0.6094"] | ["248","552.00"] | ["EDGO"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | false | |||||||||
| 01a0f7c6-a066-74d0-8e3b-d69c5e569044 | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 8 | 121600.00 | long | ask | 334.4250 | 1.6000 | ["400"] | ["0.6094"] | ["248","552.00"] | ["ARCO"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | false | |||||||||
| 01a0f7c6-a066-74d0-8e3b-d67d3377fb47 | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 7 | 106400.00 | long | ask | 334.4250 | 1.4500 | ["400"] | ["0.6094"] | ["248","552.00"] | ["XISX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | false | |||||||||
| 01a0f7c6-9c7e-7042-9e37-d7f57a3d287a | LRCX | 2026-10-01 10:03 | straddle | 2 | 2 | 12 | 182400.00 | short | bid | 334.4250 | 2.7083 | ["400"] | ["0.6094"] | ["248","552.00"] | ["C2OX","EMLD"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c6-9c7e-7042-9e37-d7e951913b38 | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 7 | 106400.00 | short | bid | 334.4250 | 3.6000 | ["400"] | ["0.6094"] | ["248","552.00"] | ["C2OX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c6-9c7e-7042-9e37-d7dda9755f08 | LRCX | 2026-10-01 10:03 | straddle | 2 | 1 | 7 | 106400.00 | short | bid | 334.4250 | 3.6500 | ["400"] | ["0.6094"] | ["248","552.00"] | ["C2OX"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c6-9c7e-7042-9e37-d7a0373036ff | LRCX | 2026-10-01 10:03 | straddle | 2 | 2 | 16 | 243200.00 | short | bid | 334.4250 | 3.8500 | ["400"] | ["0.6094"] | ["248","552.00"] | ["EMLD"] | 400.0000 | 400.0000 | 259 | 259 | false | false | false | ||||||||||
| 01a0f7c5-351f-73b1-bb0b-a45faffb236d | LRCX | 2026-10-01 10:01 | straddle | 2 | 1 | 38 | 687534.00 | short | bid | 334.8100 | 6.9500 | ["350"] | ["0.6101"] | ["169.07","530.93"] | ["EMLD"] | 350.0000 | 350.0000 | 477 | 477 | false | false | false | ||||||||||
| 01a0f7c5-3137-7ed0-b067-85497999f427 | LRCX | 2026-10-01 10:01 | straddle | 2 | 1 | 16 | 289488.00 | short | bid | 334.7700 | 6.2000 | ["350"] | ["0.6102"] | ["169.07","530.93"] | ["XMIO"] | 350.0000 | 350.0000 | 477 | 477 | false | false | false | ||||||||||
| 01a0f2fc-27d7-7ab3-bbe6-1e525d9e6f1a | LRCX | 2026-09-30 11:43 | straddle | 2 | 1 | 26 | 316550.00 | long | ask | 326.0600 | 4.0500 | ["380"] | ["0.6149"] | ["258.25","501.75"] | ["SPHR"] | 380.0000 | 380.0000 | 170 | 170 | false | false | false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:39:33Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:39:33Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:04:29Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:03:14Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:01:33Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T14:01:33Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-30T15:43:43Z"} |
| 2026-09-30 |
| 2026-09-30 17:15 |
| 2026-09-30 17:15 |