core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg637,282 rowsexportable| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a0f87b-5237-7921-9c9f-70d970e6c90c | GDX | 2026-10-01 13:20 | risk_reversal | 2 | 8 | 55 | 115301.00 | long | ask | 87.4000 | 1.2500 | ["80","111"] | ["0.4292","0.4121"] | ["111.35"] | ["AMXO","ARCO","C2OX","EDGO","XISX","XMIO","XPHO"] | 80.0000 | 111.0000 | 477 | 477 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-10-01T17:20:29Z"} | 2026-10-01 | 2026-10-01 17:15 | 2026-10-01 17:15 |
| 01a0f87b-5237-7921-9c9f-70a676f1bd25 | GDX | 2026-10-01 13:20 | risk_reversal | 2 | 8 | 74 | 155078.00 | long | ask | 87.4000 | 1.2500 | ["80","111"] | ["0.4291","0.4120"] | ["111.35"] | ["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"] | 80.0000 | 111.0000 | 477 | 477 | false | true | false | true | |||||||||
| 01a0f87b-3eaf-7882-bd19-dedcbc15ae54 | GDX | 2026-10-01 13:20 | risk_reversal | 2 | 8 | 180 | 377244.00 | long | ask | 87.4000 | 1.2500 | ["80","111"] | ["0.4292","0.4120"] | ["111.35"] | ["AMXO","ARCO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 80.0000 | 111.0000 | 477 | 477 | false | true | false | true | |||||||||
| 01a0f87b-0be7-7e11-b6a1-46ec6d470a56 | GDX | 2026-10-01 13:20 | risk_reversal | 2 | 9 | 364 | 762732.00 | long | ask | 87.3750 | 1.2500 | ["80","111"] | ["0.4289","0.4123"] | ["111.35"] | ["AMXO","ARCO","C2OX","EDGO","XCBO","XISX","XMIO","XPHO"] | 80.0000 | 111.0000 | 477 | 477 | false | true | false | true | |||||||||
| 01a0ee03-e49f-7762-9e91-ed7b88eed914 | GDX | 2026-09-29 12:33 | risk_reversal | 2 | 1 | 200 | 426000.00 | short | ask | 88.3850 | 1.5000 | ["85","125"] | ["0.4368","0.4300"] | ["81.10"] | ["XPHO"] | 85.0000 | 125.0000 | 479 | 479 | false | true | false | true | |||||||||
| 01a0c4f2-c53f-7f10-8af0-30ecc7cf627c | GDX | 2026-09-21 13:10 | risk_reversal | 2 | 1 | 2000 | 2906000.00 | long | bid | 94.0100 | 0.5000 | ["90","110"] | ["0.4290","0.4271"] | ["88.15"] | ["ARCO"] | 90.0000 | 110.0000 | 179 | 179 | false | true | false | true | |||||||||
| 01a0a62d-cbae-77e1-969d-7454c8fc061c | GDX | 2026-09-15 13:46 | risk_reversal | 2 | 1 | 800 | 2644000.00 | short | bid | 93.6800 | 1.9500 | ["80","120"] | ["0.4604","0.4483"] | ["126.85"] | ["XPHO"] | 80.0000 | 120.0000 | 822 | 822 | false | true | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:20:29Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:20:29Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-10-01T17:20:08Z"} |
| 2026-10-01 |
| 2026-10-01 17:15 |
| 2026-10-01 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-29T16:34:25Z"} |
| 2026-09-29 |
| 2026-09-29 17:15 |
| 2026-09-29 17:15 |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:11:09Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:47:55Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |