core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg508,354 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric |
|---|
| 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 |
|---|
| 01a0d435-a94f-70d2-8559-70eadcb47f24 | AEM | 2026-09-24 12:17 | put_diagonal_spread | 2 | 1 | 1000 | 1486000.00 | long | ask | 193.0550 | 1.7500 | ["165","190"] | ["0.4095","0.4579"] | [] | ["AMXO"] | 165.0000 | 190.0000 | 22 | 85 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T16:18:04Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d3de-695f-7e11-a107-4b0b1d24689d | AEM | 2026-09-24 10:42 | call_ratio_spread | 2 | 1 | 60 | 170740.00 | long | ask | 192.7000 | 1.1000 | ["185","200"] | ["0.4456","0.4479"] | ["230.25"] | ["XISX"] | 185.0000 | 200.0000 | 85 | 85 | false | false | |||||||||||
| 01a0cf50-51d7-7741-8ec6-843899e863e9 | AEM | 2026-09-23 13:29 | put_vertical_spread | 2 | 1 | 10 | 108470.00 | long | ask | 195.2650 | 4.1000 | ["200","250"] | ["0.4729","0.4996"] | ["216.63"] | ["XPHO"] | 200.0000 | 250.0000 | 485 | 485 | false | false | |||||||||||
| 01a0b5df-2990-7672-b7b1-a5a49fbe9679 | AEM | 2026-09-18 14:54 | straddle | 2 | 2 | 300 | 2901000.00 | long | ask | 199.7000 | 5.7000 | ["240"] | ["0.4857"] | ["143.30","336.70"] | ["AMXO"] | 240.0000 | 240.0000 | 490 | 490 | true | false | |||||||||||
| 01a0878b-c5e0-7773-bf0e-efd3a2cf32bc | AEM | 2026-09-09 15:01 | synthetic | 2 | 2 | 250 | 1268750.00 | long | ask | 202.8800 | 3.2000 | ["170"] | ["0.4780"] | ["206.35"] | ["ARCO"] | 170.0000 | 170.0000 | 128 | 128 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:42:47Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:29:13Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:55:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:01:48Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |