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 | directiontext |
|---|
| 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 |
|---|
| 01a06d37-095d-7bd1-b08e-6ed0c93d57b0 | MRVL | 2026-09-04 12:18 | straddle | 2 | 2 | 250 | 62500.00 | short | bid | 221.1500 | 0.2100 | ["220"] | ["0.6422"] | ["217.50","222.50"] | ["AMXO"] | 220.0000 | 220.0000 | 0 | 0 | false | false | false | false | true | mlft | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:19:12Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dfc-0325-76c3-9101-233b95977913 | MRVL | 2026-09-04 15:53 | straddle | 2 | 1 | 8 | 93256.00 | long | ask | 223.2700 | 1.3000 | ["270"] | ["0.6680"] | ["153.43","386.57"] | ["XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06dfc-0325-76c3-9101-23493a5e028f | MRVL | 2026-09-04 15:53 | straddle | 2 | 2 | 4 | 46620.00 | long | ask | 223.2700 | 0.8000 | ["270"] | ["0.6679"] | ["153.45","386.55"] | ["AMXO","XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06dfc-5915-7850-a7eb-23c17efeec63 | MRVL | 2026-09-04 15:54 | straddle | 2 | 2 | 14 | 163324.00 | long | ask | 223.1650 | 1.4714 | ["270"] | ["0.6686"] | ["153.34","386.66"] | ["XISX","XPHO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06dfc-ce45-7f71-9459-dec8b476edad | MRVL | 2026-09-04 15:54 | straddle | 2 | 6 | 13 | 151840.00 | long | ask | 223.1449 | 1.0615 | ["270"] | ["0.6695"] | ["153.20","386.80"] | ["AMXO","XCBO","XISX","XPHO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06dfe-54e5-7d00-a799-1e67dce0865a | MRVL | 2026-09-04 15:56 | straddle | 2 | 1 | 8 | 93576.00 | short | bid | 223.4600 | 0.9500 | ["270"] | ["0.6705"] | ["153.03","386.97"] | ["XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06dfe-aad5-7892-95cc-efbcf2715c64 | MRVL | 2026-09-04 15:56 | straddle | 2 | 1 | 7 | 81942.00 | long | ask | 223.5200 | 0.9000 | ["270"] | ["0.6711"] | ["152.94","387.06"] | ["XISX"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06dff-2bbd-7dc1-9163-2eccc7e634ca | MRVL | 2026-09-04 15:57 | straddle | 2 | 1 | 3 | 35127.00 | short | bid | 223.5400 | 0.7000 | ["270"] | ["0.6713"] | ["152.91","387.09"] | ["XPHO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a06e00-73dd-7162-86c0-805f9f78d407 | MRVL | 2026-09-04 15:58 | straddle | 2 | 3 | 3 | 35139.00 | short | bid | 223.6600 | 0.5000 | ["270"] | ["0.6715"] | ["152.87","387.13"] | ["BATO","C2OX","EDGO"] | 270.0000 | 270.0000 | 286 | 286 | false | false | false | false | |||||||||
| 01a08171-78a8-7b93-860a-ff1d90f4c373 | MRVL | 2026-09-08 10:34 | straddle | 2 | 2 | 12 | 69516.00 | short | bid | 228.2300 | 1.0500 | ["270"] | ["0.6831"] | ["212.07","327.93"] | ["EMLD","XISX"] | 270.0000 | 270.0000 | 45 | 45 | false | false | false | false | |||||||||
| 01a0824c-30d8-7f10-b632-87333c8e9c38 | MRVL | 2026-09-08 14:33 | straddle | 2 | 6 | 15 | 53475.00 | long | ask | 228.6800 | 0.3333 | ["230"] | ["0.6713"] | ["194.35","265.65"] | ["MCRY","XISX","XPHO"] | 230.0000 | 230.0000 | 31 | 31 | false | false | false | false | |||||||||
| 01a0824c-30d8-7f10-b632-872ad58d910f | MRVL | 2026-09-08 14:33 | straddle | 2 | 2 | 16 | 48000.00 | unknown | — | 228.6800 | 0.3500 | ["230"] | ["0.6407"] | [] | ["EMLD","XISX"] | 230.0000 | 230.0000 | 24 | 24 | false | false | false | false | true | mlet | |||||||
| 01a08bd5-b430-72d1-bc7a-61cde4121815 | MRVL | 2026-09-10 11:00 | straddle | 2 | 1 | 500 | 3982500.00 | long | ask | 232.7150 | 1.1500 | ["260"] | ["0.6771"] | ["180.35","339.65"] | ["SPHR"] | 260.0000 | 260.0000 | 127 | 127 | false | false | false | false | |||||||||
| 01a0a0ce-9d98-7a51-8efb-119836e195b3 | MRVL | 2026-09-14 12:44 | straddle | 2 | 2 | 75 | 854250.00 | short | bid | 222.0500 | 5.0000 | ["220"] | ["0.6714"] | ["106.10","333.90"] | ["ARCO"] | 220.0000 | 220.0000 | 368 | 368 | false | false | false | false | |||||||||
| 01a0a102-b970-7b91-8c6b-becfd89292c6 | MRVL | 2026-09-14 13:41 | straddle | 2 | 1 | 2 | 33820.00 | short | bid | 222.9500 | 2.4500 | ["220"] | ["0.6872"] | ["50.90","389.10"] | ["XBOX"] | 220.0000 | 220.0000 | 858 | 858 | false | false | false | false | |||||||||
| 01a0aa83-9213-7332-bfb9-cebe01ea7f73 | MRVL | 2026-09-16 09:59 | straddle | 2 | 2 | 26 | 91299.00 | short | bid | 232.8500 | 0.7500 | ["230"] | ["0.6632"] | ["194.88","265.12"] | ["EDGO","XCBO"] | 230.0000 | 230.0000 | 30 | 30 | false | false | false | false | |||||||||
| 01a0b540-2a6f-73a0-94ce-f17808d55e14 | MRVL | 2026-09-18 12:01 | straddle | 2 | 1 | 100 | 162001.00 | short | bid | 238.1750 | 0.7500 | ["245"] | ["0.5734"] | ["228.80","261.20"] | ["XMIO"] | 245.0000 | 245.0000 | 7 | 7 | false | false | false | false | |||||||||
| 01a0b60f-f1d8-7960-97d8-8b9da5e12d07 | MRVL | 2026-09-18 15:48 | straddle | 2 | 1 | 229 | 43510.00 | long | ask | 238.9001 | 0.5300 | ["240"] | ["1.8469"] | ["238.10","241.90"] | ["AMXO"] | 240.0000 | 240.0000 | 0 | 0 | false | false | false | false | |||||||||
| 01a0ca30-1057-75d0-b3ec-3192942a8c90 | MRVL | 2026-09-22 13:35 | straddle | 2 | 3 | 3 | 30642.00 | short | bid | 262.4700 | 2.1000 | ["280"] | ["0.6869"] | ["177.86","382.14"] | ["ARCO","MCRY","XBOX"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca37-3c46-78e3-9ffa-f7a7caf3a9a4 | MRVL | 2026-09-22 13:43 | straddle | 2 | 2 | 4 | 40968.00 | short | bid | 261.8400 | 3.8000 | ["280"] | ["0.6893"] | ["177.58","382.42"] | ["ARCO","XPHO"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca37-3c46-78e3-9ffa-f79be13c54e0 | MRVL | 2026-09-22 13:43 | straddle | 2 | 1 | 5 | 51210.00 | short | bid | 261.8400 | 4.0500 | ["280"] | ["0.6893"] | ["177.58","382.42"] | ["ARCO"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca39-f397-7ba2-863c-15bd6e6d6d69 | MRVL | 2026-09-22 13:46 | straddle | 2 | 1 | 23 | 243156.00 | long | ask | 262.5950 | 3.1000 | ["290"] | ["0.6921"] | ["184.28","395.72"] | ["ARCO"] | 290.0000 | 290.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca3f-eed7-7880-ac1b-923232540df0 | MRVL | 2026-09-22 13:53 | straddle | 2 | 3 | 3 | 30621.00 | short | bid | 262.9334 | 3.4500 | ["280"] | ["0.6860"] | ["177.93","382.07"] | ["AMXO","ARCO","XBOX"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca3f-eed7-7880-ac1b-922017f584bc | MRVL | 2026-09-22 13:53 | straddle | 2 | 3 | 13 | 132691.00 | short | bid | 262.9334 | 3.9038 | ["280"] | ["0.6860"] | ["177.93","382.07"] | ["ARCO","EMLD","XBOX"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca4c-8d4f-7463-9a55-11c33e1d9b4a | MRVL | 2026-09-22 14:06 | straddle | 2 | 1 | 8 | 82096.00 | short | bid | 263.1599 | 2.8000 | ["280"] | ["0.6896"] | ["177.38","382.62"] | ["ARCO"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca4c-8d4f-7463-9a55-11ec3c363361 | MRVL | 2026-09-22 14:06 | straddle | 2 | 3 | 10 | 102660.00 | long | ask | 263.1599 | 2.2000 | ["280"] | ["0.6899"] | ["177.34","382.66"] | ["ARCO","EDGO","XMIO"] | 280.0000 | 280.0000 | 178 | 178 | false | false | false | false | |||||||||
| 01a0ca51-30cf-77e3-be55-1657e1fa6632 | MRVL | 2026-09-22 14:11 | straddle | 2 | 1 | 21 | 222054.00 | long | ask | 263.3100 | 2.4500 | ["290"] | ["0.6919"] | ["184.26","395.74"] | ["ARCO"] | 290.0000 | 290.0000 | 178 | 178 | false | false | false | false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:07Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:29Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:54:48Z"} |
| 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-04T19:56:18Z"} |
| 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-04T19:56:44Z"} |
| 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-04T19:57:24Z"} |
| 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-04T19:58:42Z"} |
| 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-08T14:35:07Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:34:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T18:34:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:00:39Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:44:49Z"} |
| 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-14T17:41:59Z"} |
| 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-16T13:59:05Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:01:32Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:48:16Z"} |
| 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-22T17:36:27Z"} |
| 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-22T17:44:07Z"} |
| 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-22T17:44:07Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:46:29Z"} |
| 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-22T17:53:07Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:53:07Z"} |
| 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-22T18:07:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:07:04Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |