core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
Simplify Analyticsuw_multileg403,968 rowsexportable| idtext | tickertext | executed_at ↑timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext |
|---|
| 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 |
|---|
| 01a081da-19d1-7110-98f1-b9025a86b41c | QQQ | 2026-09-08 12:29 | time_butterfly | 3 | 4 | 102 | 58536.00 | short | bid | 719.1000 | 0.1500 | ["722","747","748"] | ["0.1772","0.1576","0.1563"] | [] | ["ARCO","EMLD","SPHR","XPHO"] | 722.0000 | 748.0000 | 10 | 24 | false | true | true | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:29:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a09191-dbd8-7991-b849-bd78a409b9e2 | QQQ | 2026-09-11 13:44 | time_butterfly | 3 | 4 | 108 | 31968.00 | long | ask | 716.8500 | 0.0600 | ["722","747","748"] | ["0.1554","0.1416","0.1427"] | [] | ["BATO","EDGO","EMLD","SPHR"] | 722.0000 | 748.0000 | 7 | 21 | false | true | true | true | |||||||||
| 01a0a040-57b8-75a3-8b2d-6925b1b7095b | QQQ | 2026-09-14 10:09 | time_butterfly | 3 | 1 | 40 | 70424.00 | long | bid | 707.2700 | 0.1500 | ["710","720"] | ["0.1896","0.1924"] | [] | ["XMIO"] | 710.0000 | 720.0000 | 4 | 32 | false | true | true | true | |||||||||
| 01a0a040-7ec8-7783-ad75-063ad44d47f9 | QQQ | 2026-09-14 10:09 | time_butterfly | 3 | 1 | 70 | 123382.00 | long | bid | 707.2900 | 0.0800 | ["710","720"] | ["0.1896","0.1927"] | [] | ["EDGO"] | 710.0000 | 720.0000 | 4 | 32 | false | true | true | true | |||||||||
| 01a0a040-7ae1-7512-ae63-98045bf26493 | QQQ | 2026-09-14 10:09 | time_butterfly | 3 | 5 | 70 | 123325.00 | long | bid | 707.2900 | 0.0850 | ["710","720"] | ["0.1896","0.1925"] | [] | ["C2OX","EDGO","XCBO"] | 710.0000 | 720.0000 | 4 | 32 | false | true | true | true | |||||||||
| 01a0a040-82b0-7c21-a374-37d2cd6ef905 | QQQ | 2026-09-14 10:09 | time_butterfly | 3 | 3 | 15 | 26409.00 | unknown | — | 707.2850 | 0.1200 | ["710","720"] | ["0.1895","0.1923"] | [] | ["C2OX","EDGO","XCBO"] | 710.0000 | 720.0000 | 4 | 32 | false | true | true | true | false | mlet | |||||||
| 01a0b54d-ab78-78d1-bbb6-5b8af6298f4e | QQQ | 2026-09-18 12:15 | time_butterfly | 3 | 1 | 30 | 40275.00 | long | ask | 716.2500 | 0.3100 | ["700","715","725"] | ["0.4931","0.1594","0.1519"] | [] | ["XISX"] | 700.0000 | 725.0000 | 0 | 12 | false | false | true | true | |||||||||
| 01a0c4ed-2f8f-7d11-b4a0-45de252a8b93 | QQQ | 2026-09-21 13:04 | time_butterfly | 3 | 3 | 60 | 43840.00 | short | bid | 738.8750 | 0.1000 | ["741","765"] | ["0.1690","0.1633"] | [] | ["BATO","C2OX","EDGO"] | 741.0000 | 765.0000 | 11 | 25 | false | true | true | true | |||||||||
| 01a0c963-3ebf-7553-b448-2cb4202d39e1 | QQQ | 2026-09-22 09:51 | time_butterfly | 3 | 1 | 30 | 190600.00 | short | bid | 745.1600 | 0.7300 | ["740","750","755"] | ["0.2031","0.2019","0.1972"] | [] | ["XISX"] | 740.0000 | 755.0000 | 87 | 100 | false | false | true | true | |||||||||
| 01a0ca1a-7517-78d0-bbfb-b24fed7d7ce7 | QQQ | 2026-09-22 13:12 | time_butterfly | 3 | 1 | 6 | 28410.00 | long | ask | 745.2793 | 2.7800 | ["717","722","726"] | ["0.8056","0.2206","0.5678"] | [] | ["XISX"] | 717.0000 | 726.0000 | 0 | 2 | false | false | true | true | |||||||||
| 01a0ca9b-a368-77e2-8daf-6c513372b141 | QQQ | 2026-09-22 15:33 | time_butterfly | 3 | 1 | 30 | 198860.00 | short | bid | 747.6200 | 0.9400 | ["740","750","755"] | ["0.2033","0.2025","0.1971"] | [] | ["XMIO"] | 740.0000 | 755.0000 | 87 | 100 | false | false | true | true |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T17:45:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:09:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:09:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:09:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:09:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:16:26Z"} |
| 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-21T17:05:05Z"} |
| 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-22T13:52:17Z"} |
| 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-22T17:12:39Z"} |
| 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:33:31Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |