core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | net_side |
|---|
| 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 |
|---|
| 01a0866b-4668-78a3-bf5a-476b46dd5eca | GLD | 2026-09-09 09:46 | call_vertical_spread | 2 | 1 | 63 | 295785.00 | unknown | — | 405.0600 | 0.5000 | ["410","450"] | ["0.2462","0.2534"] | [] | ["MCRY"] | 410.0000 | 450.0000 | 191 | 191 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T13:46:10Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0865d-05f8-7dc3-9ef9-17e3e9805c2d | GLD | 2026-09-09 09:30 | call_vertical_spread | 2 | 1 | 66 | 147972.00 | unknown | — | 406.4300 | 0.5000 | ["420","440"] | ["0.2581","0.2662"] | [] | ["XCBO"] | 420.0000 | 440.0000 | 72 | 72 | false | true | false | true | false | mlat | |||||||
| 01a0865c-fe28-71a3-ae4b-e3f47bbd9970 | GLD | 2026-09-09 09:30 | call_vertical_spread | 2 | 1 | 35 | 100870.00 | short | bid | 406.4000 | 0.8000 | ["420","440"] | ["0.2536","0.2603"] | ["426.26"] | ["XCBO"] | 420.0000 | 440.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a08158-ad00-7c51-86a0-eadb1aad6266 | GLD | 2026-09-08 10:07 | other | 4 | 1 | 200 | 384400.00 | unknown | — | 403.7150 | 0.7500 | ["420","430","440","470"] | ["0.2587","0.2568","0.2830","0.2810"] | [] | ["XMIO"] | 420.0000 | 470.0000 | 22 | 73 | false | true | true | true | false | mlat | |||||||
| 01a08156-ff50-7992-a77b-5a423abe56ed | GLD | 2026-09-08 10:05 | call_vertical_spread | 2 | 1 | 65 | 269815.00 | unknown | — | 403.5700 | 0.5500 | ["410","413"] | ["0.2470","0.2477"] | [] | ["XCBO"] | 410.0000 | 413.0000 | 114 | 114 | false | true | false | true | false | mlat | |||||||
| 01a06df0-33b5-7530-8ceb-dc20b7846380 | GLD | 2026-09-04 15:40 | call_vertical_spread | 2 | 2 | 65 | 169390.00 | long | ask | 406.9300 | 0.4000 | ["385","411"] | ["0.2573","0.2288"] | ["404.06"] | ["XMIO"] | 385.0000 | 411.0000 | 7 | 7 | false | false | false | true | false | ||||||||
| 01a06dcb-88fd-76b2-bf98-e70672c628e2 | GLD | 2026-09-04 15:00 | other | 4 | 1 | 40 | 125560.00 | unknown | — | 405.5800 | 0.9500 | ["390","400","420"] | ["0.2419","0.2403","0.2559"] | [] | ["XMIO"] | 390.0000 | 420.0000 | 14 | 21 | false | false | true | true | false | mlat | |||||||
| 01a06dbf-8e95-7752-85a3-9aac22fbf1ad | GLD | 2026-09-04 14:47 | call_vertical_spread | 2 | 1 | 100 | 193400.00 | unknown | — | 405.7100 | 0.4000 | ["410","425"] | ["0.2441","0.2517"] | [] | ["XBOX"] | 410.0000 | 425.0000 | 42 | 42 | false | true | false | true | false | mlat | |||||||
| 01a06d9b-ce3d-7463-a8c1-bf1c4720be23 | GLD | 2026-09-04 14:08 | call_vertical_spread | 2 | 1 | 40 | 135080.00 | long | ask | 404.8900 | 0.5000 | ["397","402"] | ["0.2378","0.2389"] | ["399.79"] | ["XCBO"] | 397.0000 | 402.0000 | 42 | 42 | false | false | false | true | false | ||||||||
| 01a06d9a-8ded-7380-9dfe-4b3979b477df | GLD | 2026-09-04 14:07 | other | 4 | 1 | 250 | 524150.00 | unknown | — | 404.7700 | 0.7200 | ["340","365","390","400"] | ["0.2945","0.2466","0.2378","0.2433"] | [] | ["XPHO"] | 340.0000 | 400.0000 | 42 | 77 | false | true | true | true | false | mlat | |||||||
| 01a06d95-55fd-7fb0-a18f-5211e2a619b5 | GLD | 2026-09-04 14:01 | call_vertical_spread | 2 | 1 | 80 | 187840.00 | long | ask | 404.7200 | 0.3500 | ["425","450"] | ["0.2474","0.2567"] | ["431.44"] | ["XCBO"] | 425.0000 | 450.0000 | 105 | 105 | false | true | false | true | |||||||||
| 01a06d6a-4e5d-7ed3-8e0e-373993d55738 | GLD | 2026-09-04 13:14 | put_vertical_spread | 2 | 1 | 80 | 274000.00 | unknown | — | 406.6700 | 0.8000 | ["419","420"] | ["0.2543","0.2559"] | [] | ["XMIO"] | 419.0000 | 420.0000 | 21 | 21 | false | false | false | true | false | mlat | |||||||
| 01a06d3c-31ad-7c03-8351-6b4e3df9eb79 | GLD | 2026-09-04 12:24 | call_diagonal_spread_bullish | 2 | 1 | 84 | 213612.00 | long | ask | 406.7600 | 1.3500 | ["394","395"] | ["0.2153","0.9600"] | [] | ["XCBO"] | 394.0000 | 395.0000 | 0 | 5 | false | false | true | true | |||||||||
| 01a06d36-78d5-7082-8d0f-afed7f8d1309 | GLD | 2026-09-04 12:17 | call_vertical_spread | 2 | 1 | 74 | 280904.00 | short | bid | 407.2700 | 0.5000 | ["420","430"] | ["0.2432","0.2456"] | ["423.66"] | ["XPHO"] | 420.0000 | 430.0000 | 133 | 133 | false | true | false | true |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:30:42Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:30:42Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:08:00Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:06:05Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:41:10Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T19:00:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:48:13Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:09:19Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:07:43Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:01:50Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T17:15:04Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:24:23Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:18:31Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |