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 |
|---|
| 01a08bf7-0388-73d0-842e-a735036092ef | ALAB | 2026-09-10 11:36 | other | 4 | 1 | 5 | 109325.00 | unknown | — | 291.2300 | 20.4500 | ["185","220","420","620"] | ["0.8418","1.3334","0.8467","2.7548"] | [] | ["XCBO"] | 185.0000 | 620.0000 | 8 | 127 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:36:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b93-34c0-7ce1-a862-9d74c0f7a768 | ALAB | 2026-09-10 09:47 | call_vertical_spread | 2 | 1 | 66 | 294162.00 | short | bid | 284.6600 | 6.9000 | ["350","450"] | ["0.8593","0.8871"] | ["365.91"] | ["XISX"] | 350.0000 | 450.0000 | 99 | 99 | false | true | false | true | |||||||||
| 01a087a8-cf79-7be1-ab87-282947b34a9b | ALAB | 2026-09-09 15:32 | other | 4 | 1 | 961 | 3055974.00 | unknown | — | 300.2200 | 3.7700 | ["245","275","285","315"] | ["1.1152","0.7894","0.8877","0.7980"] | [] | ["AMXO"] | 245.0000 | 315.0000 | 2 | 9 | false | false | true | true | true | mlat | |||||||
| 01a0874f-2271-7261-a614-df96b3417c31 | ALAB | 2026-09-09 13:55 | call_butterfly_spread | 3 | 1 | 20 | 131260.00 | long | ask | 301.0200 | 7.0000 | ["350","400","440"] | ["0.8368","0.8454","0.8544"] | ["355.14"] | ["XCBO"] | 350.0000 | 440.0000 | 128 | 128 | false | true | false | true | |||||||||
| 01a08681-d3d8-77b1-93cb-c93c13eaadce | ALAB | 2026-09-09 10:10 | call_vertical_spread | 2 | 1 | 4 | 116840.00 | unknown | — | 307.4200 | 11.9000 | ["200","260"] | ["0.8301","0.8285"] | [] | ["XCBO"] | 200.0000 | 260.0000 | 464 | 464 | false | false | false | true | false | mlat | |||||||
| 01a0867a-9c30-7202-bea0-e9ebc46ab48d | ALAB | 2026-09-09 10:02 | call_vertical_spread | 2 | 1 | 70 | 406280.00 | short | bid | 305.9299 | 6.5000 | ["350","450"] | ["0.8434","0.8687"] | ["370"] | ["XISX"] | 350.0000 | 450.0000 | 100 | 100 | false | true | false | true | |||||||||
| 01a08295-4f99-72a2-a3a0-0f0c7a2b1f08 | ALAB | 2026-09-08 15:53 | call_vertical_spread | 2 | 1 | 200 | 932800.00 | short | bid | 288.2900 | 9.4500 | ["350","450"] | ["0.8497","0.8728"] | ["366.78"] | ["XISX"] | 350.0000 | 450.0000 | 101 | 101 | true | true | false | true | |||||||||
| 01a06df3-6fd5-79c3-aaa6-0ce97454537d | ALAB | 2026-09-04 15:44 | call_condor | 4 | 1 | 5 | 102310.00 | unknown | — | 312.3750 | 11.9500 | ["280","320","330","400"] | ["0.8284","0.8329","0.8304","0.8426"] | [] | ["XCBO"] | 280.0000 | 400.0000 | 105 | 105 | false | false | false | true | false | mlat | |||||||
| 01a06dcd-658d-7cd2-87ce-04fcdd823fbb | ALAB | 2026-09-04 15:02 | risk_reversal | 3 | 1 | 53 | 106053.00 | long | bid | 313.0300 | 2.9500 | ["300","330","345"] | ["0.7963","0.8326","0.8319"] | ["295.77"] | ["XMIO"] | 300.0000 | 345.0000 | 7 | 7 | false | true | false | true | true | ||||||||
| 01a06dbc-7986-7cf1-8a8b-557927c626b3 | ALAB | 2026-09-04 14:44 | other | 3 | 1 | 8 | 172020.00 | unknown | — | 313.9800 | 13.6000 | ["200","230","260"] | ["0.8159","0.8114","0.8119"] | [] | ["MCRY"] | 200.0000 | 260.0000 | 133 | 133 | false | false | false | true | false | mlat | |||||||
| 01a06d73-667d-77d2-809c-ca84997c4462 | ALAB | 2026-09-04 13:24 | call_diagonal_spread_bearish | 2 | 1 | 40 | 199120.00 | short | ask | 312.7000 | 3.8500 | ["280","330"] | ["0.8688","0.8300"] | [] | ["XMIO"] | 280.0000 | 330.0000 | 7 | 14 | false | false | true | true | |||||||||
| 01a06d6d-e456-7030-bd09-ce13655e7ddf | ALAB | 2026-09-04 13:18 | call_vertical_spread | 2 | 1 | 9 | 274689.00 | long | ask | 312.9000 | 7.5000 | ["140","200"] | ["0.8907","0.8234"] | ["190.65"] | ["XCBO"] | 140.0000 | 200.0000 | 133 | 133 | false | false | false | true | |||||||||
| 01a06d42-e486-7a92-8446-a0891794678a | ALAB | 2026-09-04 12:31 | call_ladder | 3 | 1 | 10 | 118430.00 | short | bid | 316.8500 | 9.4000 | ["310","400","410"] | ["0.8180","0.8242","0.8272"] | ["310.49","499.51"] | ["XCBO"] | 310.0000 | 410.0000 | 105 | 105 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:47:55Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:33:17Z"} |
| 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-09T17:55:32Z"} |
| 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-09T14:11:15Z"} |
| 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-09T14:03:15Z"} |
| 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-08T19:54: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-04T19:44:39Z"} |
| 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-04T19:03:14Z"} |
| 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:44:57Z"} |
| 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-04T17:25:17Z"} |
| 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-04T17:18:49Z"} |
| 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:31:42Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |