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 | 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 |
|---|
| 01a0e90d-acd7-7411-ae7f-0d7611192b5d | USO | 2026-09-28 13:26 | other | 4 | 1 | 10 | 144060.00 | unknown | bid | 149.1700 | 7.7300 | ["78","80"] | ["0.7004","0.4812"] | [] | ["SPHR"] | 78.0000 | 80.0000 | 109 | 262 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-28T17:26:45Z"} | 2026-09-28 | 2026-09-28 17:15 | 2026-09-28 17:15 |
| 01a0e901-162f-7092-b6d0-4335ac8e62b8 | USO | 2026-09-28 13:12 | other | 2 | 2 | 334 | 205410.00 | unknown | bid | 146.8080 | 1.0850 | ["140","165"] | ["0.6393","0.5211"] | [] | ["BATO","C2OX"] | 140.0000 | 165.0000 | 9 | 32 | false | true | true | true | |||||||||
| 01a0e901-162e-7993-9d70-70b9f378e2c6 | USO | 2026-09-28 13:12 | other | 2 | 6 | 666 | 409840.00 | unknown | bid | 146.8060 | 1.1074 | ["140","165"] | ["0.6395","0.5212"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 140.0000 | 165.0000 | 9 | 32 | false | true | true | true | |||||||||
| 01a0e8d2-1307-77f2-9f91-648c3930783d | USO | 2026-09-28 12:21 | other | 3 | 1 | 210 | 206640.00 | unknown | bid | 150.0162 | 2.4200 | ["120","125","135"] | ["0.4892","0.4898","0.6124"] | [] | ["XPHO"] | 120.0000 | 135.0000 | 11 | 109 | false | true | true | true | |||||||||
| 01a0e87b-b5a7-7d30-94db-3bfa2df87a5f | USO | 2026-09-28 10:46 | other | 3 | 1 | 606 | 192405.00 | unknown | bid | 152.9250 | 0.2000 | ["140","153","160"] | ["0.5904","0.6179","0.6057"] | [] | ["XPHO"] | 140.0000 | 160.0000 | 2 | 9 | false | true | true | true | |||||||||
| 01a0d927-511f-7bb2-8153-75a8379de2b4 | USO | 2026-09-25 11:20 | other | 4 | 1 | 1700 | 817700.00 | unknown | bid | 151.4300 | 0.2600 | ["154","156","159","161"] | ["0.5081","0.6473","0.5087","1.0960"] | [] | ["EDGO"] | 154.0000 | 161.0000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0d8ed-8c0f-76b2-a4df-65832a88b114 | USO | 2026-09-25 10:17 | other | 4 | 1 | 1950 | 934050.00 | unknown | bid | 150.2800 | 0.2900 | ["153","156","158","161"] | ["0.5156","0.6435","0.5207","1.0982"] | [] | ["EDGO"] | 153.0000 | 161.0000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0d8e7-2b3f-75d1-beaa-d67c8f1304d0 | USO | 2026-09-25 10:10 | other | 4 | 1 | 530 | 270830.00 | unknown | bid | 150.8000 | 0.2400 | ["153","157","158","162"] | ["0.5141","0.7485","0.5152","1.1246"] | [] | ["EDGO"] | 153.0000 | 162.0000 | 0 | 7 | false | true | true | true | |||||||||
| 01a0caaf-a868-7203-bc44-4f2d27ce5da1 | USO | 2026-09-22 15:55 | other | 3 | 4 | 436 | 209668.00 | unknown | bid | 143.8600 | 0.4600 | ["138","142","157"] | ["0.6568","0.6317","0.5442"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 138.0000 | 157.0000 | 3 | 10 | false | true | true | true | |||||||||
| 01a0ca87-9696-7940-991d-c5ba977cd117 | USO | 2026-09-22 15:11 | other | 3 | 1 | 109 | 108564.00 | unknown | bid | 145.3400 | 0.6700 | ["138","146","165"] | ["0.5457","0.5360","0.5068"] | [] | ["EDGO"] | 138.0000 | 165.0000 | 8 | 38 | false | false | true | true | |||||||||
| 01a0c986-3faf-7173-a0b2-43e2c00b8a38 | USO | 2026-09-22 10:30 | other | 3 | 1 | 50 | 102335.00 | unknown | bid | 145.8900 | 4.1500 | ["120","122","130"] | ["0.4846","0.4298","0.4774"] | ["129.21"] | ["XCBO"] | 120.0000 | 130.0000 | 178 | 178 | false | false | false | true | |||||||||
| 01a0c44d-c6f7-75b0-bf01-46ba4d5df228 | USO | 2026-09-21 10:10 | other | 2 | 2 | 1016 | 243340.00 | unknown | bid | 148.8607 | 0.3200 | ["152","160"] | ["0.6371","0.5044"] | [] | ["BATO","SPHR"] | 152.0000 | 160.0000 | 2 | 9 | false | false | true | true | |||||||||
| 01a0b5d9-de18-7c10-98c3-8b08b3c81ed5 | USO | 2026-09-18 14:49 | other | 3 | 1 | 10 | 137140.00 | unknown | bid | 153.7008 | 8.1900 | ["135","215","220"] | ["0.5585","0.4539","0.4624"] | [] | ["XBOX"] | 135.0000 | 220.0000 | 7 | 546 | false | false | true | true | |||||||||
| 01a0b5ce-6c68-7953-8a53-9e1b9037c780 | USO | 2026-09-18 14:36 | other | 3 | 1 | 11 | 153835.00 | unknown | bid | 154.0500 | 8.8300 | ["140","215","220"] | ["0.5213","0.4755","0.4829"] | [] | ["XPHO"] | 140.0000 | 220.0000 | 5 | 546 | false | false | true | true | |||||||||
| 01a0b505-e08f-74d1-b0a7-e3ad0a1b41c6 | USO | 2026-09-18 10:57 | other | 4 | 1 | 10 | 204270.00 | unknown | bid | 155.8930 | 14.5000 | ["133","137"] | ["0.3688","0.3785"] | [] | ["XCBO"] | 133.0000 | 137.0000 | 819 | 854 | false | false | true | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:13:10Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T17:13:10Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T16:21:25Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-28T14:47:07Z"} |
| 2026-09-28 |
| 2026-09-28 17:15 |
| 2026-09-28 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:20:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:17:20Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T14:10:23Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:55:05Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T19:11:30Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:30:17Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:10:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:49:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:36:54Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:57:43Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |