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 | 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 |
|---|
| 01a0c9e3-4bff-73f1-9252-26ab63c3633e | AEM | 2026-09-22 12:11 | call_vertical_spread | 2 | 1 | 10 | 221590.00 | short | bid | 200.0700 | 6.6000 | ["90","95"] | ["0.4134","0.4389"] | ["94.63"] | ["XCBO"] | 90.0000 | 95.0000 | 268 | 268 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:12:30Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0afa3-a0cc-71b2-95da-c5dd0fde0249 | AEM | 2026-09-17 09:52 | call_vertical_spread | 2 | 1 | 108 | 117040.00 | unknown | — | 201.4200 | 1.5000 | ["250","260"] | ["0.4871","0.4920"] | [] | ["XCBO"] | 250.0000 | 260.0000 | 92 | 92 | false | true | false | true | false | ||||||||
| 01a0aa91-41fb-71f0-8773-e4568721fff2 | AEM | 2026-09-16 10:13 | call_calendar | 2 | 1 | 5 | 103980.00 | short | bid | 199.5200 | 6.1000 | ["110"] | ["0.4481"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | |||||||||
| 01a0aa80-5dc3-7b01-a40f-9ce2d18d6c60 | AEM | 2026-09-16 09:55 | call_calendar | 2 | 1 | 5 | 105160.00 | short | ask | 200.5900 | 6.4000 | ["110"] | ["0.4532"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | |||||||||
| 01a0aa6d-c7f3-7ec3-95d2-2ca55339cad3 | AEM | 2026-09-16 09:35 | call_calendar | 2 | 1 | 5 | 105780.00 | short | ask | 201.7500 | 8.9000 | ["110"] | ["0.4400"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | |||||||||
| 01a0aa6d-182b-72c2-ab1c-08f905495983 | AEM | 2026-09-16 09:34 | call_calendar | 2 | 1 | 5 | 105780.00 | short | ask | 201.7050 | 8.9000 | ["110"] | ["0.4413"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | |||||||||
| 01a0aa6b-a8fb-7a72-81a2-36ee690d20bb | AEM | 2026-09-16 09:32 | call_calendar | 2 | 1 | 5 | 104995.00 | short | ask | 201.0300 | 7.7000 | ["110"] | ["0.4365"] | [] | ["XCBO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | |||||||||
| 01a0aa6b-3f83-7672-bcd9-938c2aa6b40b | AEM | 2026-09-16 09:32 | call_calendar | 2 | 1 | 5 | 104975.00 | short | ask | 200.8000 | 7.7000 | ["110"] | ["0.4422"] | [] | ["XMIO"] | 110.0000 | 110.0000 | 492 | 856 | false | false | true | false | |||||||||
| 01a0a55b-02be-7b93-abc2-8a9cba13d94c | AEM | 2026-09-15 09:56 | call_diagonal_spread | 2 | 1 | 10 | 119510.00 | short | ask | 196.4300 | 5.5000 | ["125","150"] | ["2.5691","0.5956"] | [] | ["XCBO"] | 125.0000 | 150.0000 | 3 | 31 | false | false | true | ||||||||||
| 01a086a9-68a8-7e83-b77f-100261d6a32e | AEM | 2026-09-09 10:54 | call_vertical_spread | 2 | 1 | 12 | 140508.00 | short | bid | 204.2600 | 3.6000 | ["150","175"] | ["0.4612","0.4613"] | ["166.23"] | ["XCBO"] | 150.0000 | 175.0000 | 281 | 281 | false | false | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:52:24Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:14:15Z"} |
| 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-16T13:55:50Z"} |
| 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-16T13:35:21Z"} |
| 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-16T13:34:37Z"} |
| 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-16T13:33: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-16T13:32:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:56:50Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:54:29Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |