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 | 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 |
|---|
| 01a0b555-8b17-7ab1-9a0b-436616f088b6 | ORCL | 2026-09-18 12:24 | put_butterfly_spread | 3 | 1 | 100 | 25400.00 | unknown | ask | 144.9400 | 0.3200 | ["130","140","150"] | ["2.1065","0.8504","1.1127"] | ["144.92"] | ["XMIO"] | 130.0000 | 150.0000 | 0 | 0 | false | false | false | true | false | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:24:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b015-94ab-77f1-a1c9-3530a413b1b6 | ORCL | 2026-09-17 11:56 | put_butterfly_spread | 3 | 1 | 100 | 170750.00 | unknown | — | 151.5600 | 0.9500 | ["157.5","160","162.5"] | ["0.6105","0.5898","0.6154"] | [] | ["XISX"] | 157.5000 | 162.5000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0ab88-6b6b-7d92-b1b7-f67582ff0122 | ORCL | 2026-09-16 14:43 | put_butterfly_spread | 3 | 1 | 100 | 106200.00 | unknown | — | 144.4500 | 0.6900 | ["130","145","160"] | ["0.7446","0.5949","0.5985"] | [] | ["XISX"] | 130.0000 | 160.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a0aa69-34a9-77e1-abfc-fd849e0ea562 | ORCL | 2026-09-16 09:30 | put_butterfly_spread | 3 | 1 | 100 | 77400.00 | short | bid | 140.2200 | 1.0100 | ["130","140","150"] | ["0.6675","0.6631","0.6823"] | ["135","145"] | ["XPHO"] | 130.0000 | 150.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a08ce5-10f0-7ef1-9bb9-ed349ad31afb | ORCL | 2026-09-10 15:56 | put_butterfly_spread | 3 | 4 | 12 | 26874.00 | long | ask | 153.2899 | 0.4000 | ["140","155","170"] | ["2.6895","2.9706","3.0545"] | ["143.10","166.9"] | ["ARCO","EMLD","SPHR","XBOX"] | 140.0000 | 170.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a08ce3-6b10-70b2-93d6-49e3e5685fb8 | ORCL | 2026-09-10 15:55 | put_butterfly_spread | 3 | 1 | 300 | 282150.00 | unknown | — | 153.6171 | 0.3800 | ["130","140","150"] | ["1.0845","1.1109","1.1521"] | [] | ["XMIO"] | 130.0000 | 150.0000 | 8 | 8 | false | true | false | true | false | ||||||||
| 01a08cbc-8dd8-7fe2-a4ca-6bb193268252 | ORCL | 2026-09-10 15:12 | put_butterfly_spread | 3 | 1 | 10 | 25260.00 | long | ask | 154.6500 | 0.5500 | ["152.5","160","167.5"] | ["2.8254","2.9063","2.9544"] | ["153.26","166.74"] | ["XISX"] | 152.5000 | 167.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a081f1-bc99-7171-9026-dab62d2ae7a9 | ORCL | 2026-09-08 12:54 | put_butterfly_spread | 3 | 1 | 20 | 71560.00 | short | bid | 162.8650 | 1.4500 | ["125","135","150"] | ["0.6013","0.6027","0.6040"] | ["147"] | ["XCBO"] | 125.0000 | 150.0000 | 282 | 282 | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:56:55Z"} |
| 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-16T18:44:13Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:30:12Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:57:05Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:55:18Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:12:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:55:25Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |