core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0da07-a2e6-7543-bdd1-000b8e5d7cce | IEF | 2026-09-25 15:25 | call_diagonal_spread | 2 | 1 | 35000 | 10500000.00 | long | bid | 89.9650 | 0.2100 | ["90","97"] | ["0.0738","0.0361"] | [] | ["AMXO"] | 90.0000 | 97.0000 | 203 | 483 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T19:25:59Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8f5-2d2f-7440-a467-158804293a9e | IEF | 2026-09-25 10:25 | put_diagonal_spread | 2 | 1 | 16500 | 2684000.00 | unknown | bid | 89.6353 | 0.2000 | ["85","89"] | ["0.1047","0.1007"] | [] | ["AMXO"] | 85.0000 | 89.0000 | 112 | 357 | true | true | |||||||||||
| 01a0d4d9-e05e-7950-b1f8-a05ad45c2414 | IEF | 2026-09-24 15:17 | put_vertical_spread | 2 | 1 | 850 | 256700.00 | unknown | bid | 89.7950 | 0.0700 | ["90","91"] | ["0.0968","0.1054"] | ["88.99"] | ["MCRY"] | 90.0000 | 91.0000 | 57 | 57 | false | false | |||||||||||
| 01a0d48e-bdff-7620-8149-daf3397b1cd6 | IEF | 2026-09-24 13:55 | put_ratio_spread | 2 | 1 | 18141 | 2198631.00 | unknown | bid | 89.8950 | 0.0800 | ["89.5","90"] | ["0.0934","0.0926"] | ["86.99","89.87"] | ["AMXO"] | 89.5000 | 90.0000 | 22 | 22 | false | false | |||||||||||
| 01a0d435-95c7-7510-af39-047e8afcaeba | IEF | 2026-09-24 12:17 | put_diagonal_spread | 2 | 1 | 20836 | 3125400.00 | short | bid | 90.1100 | 0.1000 | ["88","89"] | ["0.0936","0.0948"] | [] | ["ARCO"] | 88.0000 | 89.0000 | 57 | 176 | false | true | |||||||||||
| 01a0d410-c7e6-7c22-9eb6-e441fbae03c1 | IEF | 2026-09-24 11:37 | put_vertical_spread | 2 | 1 | 35942 | 4995938.00 | short | bid | 89.8500 | 0.1000 | ["89.5","90"] | ["0.0949","0.0958"] | ["89.77"] | ["XPHO"] | 89.5000 | 90.0000 | 22 | 22 | false | false | |||||||||||
| 01a0cfb1-2acf-7351-8cd9-9f9c2459b56d | IEF | 2026-09-23 15:14 | put_vertical_spread | 2 | 1 | 15801 | 2828379.00 | unknown | bid | 90.1688 | 0.0600 | ["90","91"] | ["0.0867","0.0943"] | ["89.60"] | ["ARCO"] | 90.0000 | 91.0000 | 23 | 23 | false | false | |||||||||||
| 01a0cf86-1f47-7262-933a-d31c1d034c85 | IEF | 2026-09-23 14:27 | put_vertical_spread | 2 | 1 | 7845 | 1498395.00 | short | bid | 90.0950 | 0.0900 | ["90","91"] | ["0.0888","0.0972"] | ["90.39"] | ["XPHO"] | 90.0000 | 91.0000 | 23 | 23 | false | false | |||||||||||
| 01a0c576-a30f-7760-af59-d71ae3350c3c | IEF | 2026-09-21 15:34 | put_vertical_spread | 2 | 2 | 2000 | 171998.00 | unknown | bid | 91.1400 | 0.0600 | ["88","89"] | ["0.0845","0.0839"] | ["88.14"] | ["XCBO"] | 88.0000 | 89.0000 | 116 | 116 | false | true | |||||||||||
| 01a0c486-7e7f-7431-b463-cc4d9d88bcd9 | IEF | 2026-09-21 11:12 | call_vertical_spread | 2 | 1 | 38000 | 5130000.00 | unknown | bid | 91.0900 | 0.1800 | ["97","108"] | ["0.0272","0.0602"] | ["98.35"] | ["AMXO"] | 97.0000 | 108.0000 | 487 | 487 | true | true | |||||||||||
| 01a0b606-0e97-7b23-8b98-27ab3aa2cb28 | IEF | 2026-09-18 15:37 | put_ratio_spread | 2 | 1 | 18198 | 1113552.00 | unknown | bid | 90.8250 | 0.0600 | ["90","91"] | ["0.0746","0.0767"] | ["89.27"] | ["ARCO"] | 90.0000 | 91.0000 | 28 | 28 | false | false | |||||||||||
| 01a0b04b-98ca-7c61-9a66-ab799b9cb914 | IEF | 2026-09-17 12:55 | strangle | 2 | 1 | 181 | 132492.00 | short | bid | 91.1300 | 0.2100 | ["87","94"] | ["0.1298","0.1337"] | ["86.68","94.32"] | ["C2OX"] | 87.0000 | 94.0000 | 29 | 29 | false | false | |||||||||||
| 01a0a10b-4cc0-7d00-8a47-33aaa6775016 | IEF | 2026-09-14 13:51 | strangle | 2 | 1 | 5000 | 810000.00 | short | bid | 91.1150 | 0.1200 | ["89","92"] | ["0.0856","0.0396"] | ["87.38","93.62"] | ["XPHO"] | 89.0000 | 92.0000 | 123 | 123 | true | true | |||||||||||
| 01a08ba0-0dd0-75c1-98d1-5502cbfb09a2 | IEF | 2026-09-10 10:01 | put_vertical_spread | 2 | 1 | 1490 | 233930.00 | short | bid | 91.3499 | 0.0700 | ["91.5","92.5"] | ["0.0708","0.0750"] | ["91.77"] | ["XCBO"] | 91.5000 | 92.5000 | 8 | 8 | false | false | |||||||||||
| 01a081c0-fc20-7b62-b395-a7c65c1c8c41 | IEF | 2026-09-08 12:01 | strangle | 2 | 1 | 5000 | 850000.00 | short | bid | 92.1390 | 0.3200 | ["88","100"] | ["0.0907","0.0437"] | ["86.30","101.70"] | ["XBOX"] | 88.0000 | 100.0000 | 500 | 500 | false | true |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:25:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T19:17:53Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:55:26Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| 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 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:38:08Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:15:23Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:28:34Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:34:41Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:12:26Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:37:35Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:55:59Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:51:25Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:01:56Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:01:47Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |