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 | 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 |
|---|
| 01a0d991-55be-7fc3-b608-f992627bdf21 | DIA | 2026-09-25 13:16 | other | 3 | 1 | 27 | 25550.00 | unknown | bid | 516.7300 | 0.6000 | ["514","517"] | ["0.1288","0.1230"] | [] | ["EDGO"] | 514.0000 | 517.0000 | 14 | 21 | false | true | true | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T17:16:31Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d4c2-02fe-7a62-aadc-133aba8a48fc | DIA | 2026-09-24 14:51 | other | 7 | 1 | 1514 | 5459180.00 | unknown | bid | 513.0300 | 2.8000 | ["520","522","525","527","530","533","540"] | ["0.2060","0.2584","0.3194","0.1314","0.4152","0.1432","0.1648"] | [] | ["XBOX"] | 520.0000 | 540.0000 | 1 | 22 | false | false | true | ||||||||||
| 01a0cf6a-abef-7ed1-908f-9116afea7998 | DIA | 2026-09-23 13:57 | other | 4 | 2 | 50 | 33950.00 | unknown | bid | 515.3700 | 0.4800 | ["510","512","514","515"] | ["0.1306","0.1455","0.1199","0.1329"] | [] | ["XPHO"] | 510.0000 | 515.0000 | 2 | 7 | false | true | true | true | |||||||||
| 01a0cf44-20be-7af2-8d88-d4d12b27c572 | DIA | 2026-09-23 13:15 | other | 4 | 1 | 9 | 27154.00 | unknown | bid | 514.3600 | 1.3000 | ["515","518","520","524"] | ["0.1460","0.1171","0.1425","0.1214"] | [] | ["EDGO"] | 515.0000 | 524.0000 | 7 | 58 | false | false | true | true | |||||||||
| 01a0ca6e-4a07-7df3-81ce-1ecb24409810 | DIA | 2026-09-22 14:43 | other | 4 | 1 | 250 | 196250.00 | unknown | bid | 518.0300 | 0.6300 | ["505","535"] | ["0.1421","0.1229"] | [] | ["XBOX"] | 505.0000 | 535.0000 | 17 | 31 | true | true | true | true | |||||||||
| 01a0b5d7-7cb8-7a42-b34b-aee9a419385f | DIA | 2026-09-18 14:46 | other | 4 | 1 | 10 | 29910.00 | unknown | bid | 516.2500 | 0.9300 | ["522","528","542","548"] | ["0.1048","0.1434","0.1238","0.1659"] | [] | ["XISX"] | 522.0000 | 548.0000 | 7 | 91 | false | false | true | true | |||||||||
| 01a0b56e-cbef-7992-91d7-4a0745d611f7 | DIA | 2026-09-18 12:52 | other | 4 | 1 | 50 | 28250.00 | unknown | bid | 515.1100 | 0.3700 | ["510","512","513","515"] | ["0.1242","0.1195","0.1587","0.1459"] | [] | ["XMIO"] | 510.0000 | 515.0000 | 0 | 12 | false | true | true | true | |||||||||
| 01a0b4f1-1457-7ac2-8c18-e6c03ffa7183 | DIA | 2026-09-18 10:34 | other | 4 | 1 | 23 | 885242.00 | unknown | bid | 514.8250 | 1.9500 | ["300","325","350"] | ["0.6013","0.5861","0.5219"] | [] | ["XMIO"] | 300.0000 | 350.0000 | 91 | 119 | false | false | true | true | |||||||||
| 01a0b4df-af37-7bd0-9349-74a452097370 | DIA | 2026-09-18 10:15 | other | 3 | 2 | 4 | 52644.00 | unknown | bid | 514.9100 | 10.3000 | ["549","605","620"] | ["1.0889","0.2352","0.2557"] | [] | ["SPHR"] | 549.0000 | 620.0000 | 0 | 819 | false | false | true | true | |||||||||
| 01a0b4df-af37-7bd0-9349-7492e77630ff | DIA | 2026-09-18 10:15 | other | 3 | 3 | 6 | 78966.00 | unknown | bid | 514.9100 | 10.3000 | ["549","605","620"] | ["1.0889","0.2352","0.2557"] | [] | ["ARCO","EMLD","SPHR"] | 549.0000 | 620.0000 | 0 | 819 | false | false | true | true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:51:19Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:57:55Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:15:43Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:44:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T18:46:34Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:52:15Z"} |
| 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-18T14:35:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:15:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:15:53Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |