core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0cef7-9ae7-7f10-a414-66310898b3fe | XSP | 2026-09-23 11:52 | call_vertical_spread | 2 | 1 | 284 | 522844.00 | short | bid | 771.3500 | 2.3200 | ["740","770"] | ["0.1806","0.1709"] | ["760.50"] | ["XCBO"] | 740.0000 | 770.0000 | 450 | 450 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T15:52:21Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0ceee-adbf-73a0-b4c1-61e67595a468 | XSP | 2026-09-23 11:42 | put_vertical_spread | 2 | 1 | 648 | 102513.60 | unknown | bid | 771.8700 | 0.2100 | ["490","720"] | ["0.3639","0.1878"] | ["704.18"] | ["XCBO"] | 490.0000 | 720.0000 | 177 | 177 | false | true | false | ||||||||||
| 01a0ceee-9e1f-7d83-ad37-7f61b12d4935 | XSP | 2026-09-23 11:42 | call_diagonal_spread | 2 | 1 | 202 | 282093.00 | short | bid | 771.8000 | 1.2700 | ["720","750"] | ["0.1778","0.1699"] | [] | ["XCBO"] | 720.0000 | 750.0000 | 114 | 267 | false | false | true | ||||||||||
| 01a0ceea-5c46-7f93-b3b0-23170bd0d3b7 | XSP | 2026-09-23 11:37 | call_ratio_spread | 2 | 1 | 886 | 450043.70 | long | ask | 772.0200 | 0.5400 | ["785","835"] | ["0.1582","0.1403"] | ["785.75","884.25"] | ["XCBO"] | 785.0000 | 835.0000 | 296 | 296 | true | true | false | ||||||||||
| 01a0cee8-29c7-7141-96db-c17c747067bc | XSP | 2026-09-23 11:35 | call_ratio_spread | 2 | 1 | 852 | 290063.40 | long | ask | 771.8900 | 0.5200 | ["750","790"] | ["0.1513","0.1257"] | ["761.45","818.55"] | ["XCBO"] | 750.0000 | 790.0000 | 86 | 86 | false | false | false | ||||||||||
| 01a0cedc-4e9f-73b3-b022-5e9bd6799119 | XSP | 2026-09-23 11:22 | other | 4 | 2 | 495 | 322368.00 | unknown | — | 772.9200 | 1.0000 | ["720","750","773","774"] | ["0.2047","0.1935","0.1173","0.1163"] | [] | ["XCBO"] | 720.0000 | 774.0000 | 0 | 450 | false | true | true | true | true | ||||||||
| 01a0c580-a1a6-74e1-9191-1bccd796f115 | XSP | 2026-09-21 15:45 | call_vertical_spread | 2 | 1 | 300 | 136350.00 | short | bid | 777.4900 | 0.7000 | ["780","790"] | ["0.1364","0.1312"] | ["785.77"] | ["XCBO"] | 780.0000 | 790.0000 | 101 | 101 | false | true | false | ||||||||||
| 01a0c42e-7f27-7fc2-9833-5fc4c8295fb6 | XSP | 2026-09-21 09:36 | call_vertical_spread | 2 | 1 | 300 | 114060.00 | unknown | bid | 769.6500 | 0.6000 | ["781","785"] | ["0.1310","0.1288"] | ["802.01"] | ["XCBO"] | 781.0000 | 785.0000 | 101 | 101 | false | true | false | ||||||||||
| 01a0b024-233b-7810-96d9-6fa9e0978e60 | XSP | 2026-09-17 12:12 | put_diagonal_spread | 2 | 1 | 16689 | 1286368.80 | unknown | — | 763.3800 | 0.2600 | ["709","725"] | ["0.5426","0.1767"] | [] | ["XCBO"] | 709.0000 | 725.0000 | 1 | 74 | false | true | true | true | false | ||||||||
| 01a0aba0-a68b-71a2-84b2-09add9a881bf | XSP | 2026-09-16 15:10 | put_condor | 4 | 1 | 400 | 118880.00 | unknown | — | 754.1800 | 0.4100 | ["720","735","740","755"] | ["0.1947","0.1735","0.1662","0.1449"] | [] | ["XCBO"] | 720.0000 | 755.0000 | 30 | 30 | false | false | false | true | false | ||||||||
| 01a0ab93-92e4-74d3-89e6-2d412a55fa2c | XSP | 2026-09-16 14:56 | other | 6 | 2 | 161 | 167948.20 | unknown | — | 756.1300 | 9.8000 | ["759","760","780","790"] | ["0.5348","0.5457","0.1411","0.1358"] | [] | ["XCBO"] | 759.0000 | 790.0000 | 0 | 212 | false | false | true | true | true | ||||||||
| 01a0aad0-a48b-7092-b3aa-04fa2302e6d2 | XSP | 2026-09-16 11:23 | call_condor | 4 | 1 | 1200 | 152760.00 | unknown | — | 761.6000 | 0.4800 | ["757","758","764","765"] | ["0.3880","0.3775","0.3322","0.3269"] | [] | ["XCBO"] | 757.0000 | 765.0000 | 0 | 0 | false | false | false | true | false | ||||||||
| 01a0a0bc-1768-7850-bf0c-2a1e948e5e85 | XSP | 2026-09-14 12:24 | other | 4 | 2 | 730 | 113214.00 | unknown | — | 763.7900 | 1.1435 | ["756","757","773","774"] | ["0.1531","0.1502","0.1102","0.1091"] | [] | ["XCBO"] | 756.0000 | 774.0000 | 1 | 7 | false | false | true | true | false | ||||||||
| 01a0a09c-6238-7df0-b4f6-b807897f7c41 | XSP | 2026-09-14 11:49 | risk_reversal | 2 | 1 | 393 | 168243.30 | short | bid | 762.9300 | 0.8400 | ["685","855"] | ["0.2073","0.1444"] | ["855.15"] | ["XCBO"] | 685.0000 | 855.0000 | 368 | 368 | true | true | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:42:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:42:33Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:38:18Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:35:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:22:51Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:45:55Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:36:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:12:46Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:10:30Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T18:56:09Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:23:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T16:24:48Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T15:50:18Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |