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 |
|---|
| 01a0d40f-77f7-7363-90f3-ed86665b021d | ORCL | 2026-09-24 11:36 | put_butterfly_spread | 3 | 1 | 10 | 38220.00 | short | bid | 137.5500 | 1.2000 | ["135","145","155"] | ["0.5788","0.5804","0.5848"] | ["136","154"] | ["XCBO"] | 135.0000 | 155.0000 | 85 | 85 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T15:36:47Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 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 | |||||||||||
| 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 | ||||||||||
| 01a0a5ad-06d6-7a41-9bec-8b94a2500d60 | ORCL | 2026-09-15 11:26 | put_butterfly_spread | 3 | 1 | 10 | 51540.00 | short | bid | 143.9400 | 1.4000 | ["150","160","170"] | ["0.5652","0.5734","0.5837"] | ["150.80","169.20"] | ["AMXO"] | 150.0000 | 170.0000 | 94 | 94 | 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 | |||||||||||
| 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 | |||||||||||
| 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 |
| 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 |
| true |
| 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 |
| true |
| false |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:26:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| 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 |
| true |
| 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 |
| true |
| 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 |