core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 01a0d8c3-6317-74b3-a252-31aec70faa0f | ORCL | 2026-09-25 09:31 | risk_reversal | 2 | 4 | 82 | 162724.00 | long | bid | 139.1650 | 2.7000 | ["125","175"] | ["0.5518","0.5416"] | ["122.5"] | ["C2OX","EDGO","EMLD","SPHR"] | 125.0000 | 175.0000 | 147 | 147 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T13:31:19Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d8c3-6317-74b3-a252-31977a5a7c19 | ORCL | 2026-09-25 09:31 | risk_reversal | 2 | 1 | 14 | 27860.00 | long | bid | 139.0500 | 2.7000 | ["125","175"] | ["0.5515","0.5437"] | ["122.50"] | ["ARCO"] | 125.0000 | 175.0000 | 147 | 147 | false | true | false | ||||||||||
| 01a0d465-3917-72b2-a388-9add3abc3168 | ORCL | 2026-09-24 13:09 | risk_reversal | 2 | 1 | 250 | 618000.00 | long | ask | 138.9500 | 0.4500 | ["130","150"] | ["0.5567","0.5431"] | ["151.42"] | ["XMIO"] | 130.0000 | 150.0000 | 113 | 113 | false | true | false | ||||||||||
| 01a0cf3d-23ae-7080-9e09-93a0500d4fe3 | ORCL | 2026-09-23 13:08 | risk_reversal | 2 | 1 | 300 | 42900.00 | long | ask | 146.3200 | 0.1100 | ["120","175"] | ["0.5168","0.5399"] | ["175.53"] | ["XPHO"] | 120.0000 | 175.0000 | 23 | 23 | false | true | false | ||||||||||
| 01a0cea3-ba3f-7022-9661-2ece5e73bdbe | ORCL | 2026-09-23 10:20 | risk_reversal | 2 | 2 | 8 | 32848.00 | long | bid | 145.7266 | 0.9500 | ["135","200"] | ["0.5662","0.5600"] | ["130.40"] | ["EDGO"] | 135.0000 | 200.0000 | 359 | 359 | false | true | false | ||||||||||
| 01a0ca54-845e-7c83-9fba-84d24e800376 | ORCL | 2026-09-22 14:15 | risk_reversal | 2 | 1 | 18 | 26262.00 | long | ask | 149.7900 | 0.4000 | ["130","180"] | ["0.5715","0.5754"] | ["180.35"] | ["C2OX"] | 130.0000 | 180.0000 | 87 | 87 | false | true | false | ||||||||||
| 01a0c9b4-6bfe-7390-9d5b-cc2566d3b62e | ORCL | 2026-09-22 11:20 | risk_reversal | 2 | 2 | 11 | 46506.00 | long | bid | 149.2850 | 0.4000 | ["150","160"] | ["0.5686","0.5588"] | ["148"] | ["ARCO","XBOX"] | 150.0000 | 160.0000 | 178 | 178 | false | false | false | ||||||||||
| 01a0b524-ca9f-7642-b68c-f8f0e92147f9 | ORCL | 2026-09-18 11:31 | risk_reversal | 2 | 2 | 10 | 26050.00 | long | bid | 145.5600 | 0.4000 | ["145","160"] | ["0.5576","0.5532"] | ["141.09"] | ["ARCO","XBOX"] | 145.0000 | 160.0000 | 91 | 91 | false | true | false | ||||||||||
| 01a0b4ce-944f-7700-aaec-aeacc16df43f | ORCL | 2026-09-18 09:57 | risk_reversal | 2 | 1 | 5 | 25790.00 | long | bid | 146.0650 | 1.7000 | ["140","210"] | ["0.5755","0.5557"] | ["132.80"] | ["XCBO"] | 140.0000 | 210.0000 | 490 | 490 | false | true | false | ||||||||||
| 01a0af95-be1b-7131-bba7-ebded9ade8f9 | ORCL | 2026-09-17 09:36 | risk_reversal | 2 | 1 | 25 | 33425.00 | long | bid | 148.6201 | 0.6500 | ["130","190"] | ["0.5690","0.5769"] | ["127.97"] | ["EMLD"] | 130.0000 | 190.0000 | 92 | 92 | false | true | false | ||||||||||
| 01a0a06c-caa0-7ba2-8749-5f948d11f296 | ORCL | 2026-09-14 10:57 | risk_reversal | 2 | 2 | 24 | 45360.00 | long | bid | 143.9450 | 0.1000 | ["145","165"] | ["0.5260","0.5224"] | ["138.10"] | ["XISX","XPHO"] | 145.0000 | 165.0000 | 67 | 67 | false | false | false | ||||||||||
| 01a0a06c-c6b9-7422-9115-23771f298043 | ORCL | 2026-09-14 10:57 | risk_reversal | 2 | 2 | 24 | 45360.00 | long | bid | 143.9450 | 0.1000 | ["145","165"] | ["0.5260","0.5224"] | ["138.10"] | ["XISX","XPHO"] | 145.0000 | 165.0000 | 67 | 67 | false | false | false | ||||||||||
| 01a0a06c-c6b9-7422-9115-236e615d00db | ORCL | 2026-09-14 10:57 | risk_reversal | 2 | 2 | 29 | 54810.00 | long | bid | 143.9450 | 0.2207 | ["145","165"] | ["0.5260","0.5224"] | ["138.10"] | ["XISX","XPHO"] | 145.0000 | 165.0000 | 67 | 67 | false | false | false | ||||||||||
| 01a0a06c-c6b9-7422-9115-235f8754e7f9 | ORCL | 2026-09-14 10:57 | risk_reversal | 2 | 2 | 29 | 54810.00 | long | bid | 143.9450 | 0.2000 | ["145","165"] | ["0.5260","0.5224"] | ["138.10"] | ["XISX","XPHO"] | 145.0000 | 165.0000 | 67 | 67 | false | false | false | ||||||||||
| 01a0a022-2928-72f1-a93c-4b8c217d922c | ORCL | 2026-09-14 09:36 | risk_reversal | 2 | 4 | 5 | 36892.00 | long | bid | 142.5700 | 4.2500 | ["150","240"] | ["0.5761","0.5794"] | ["134"] | ["BATO","C2OX","EDGO","XBOX"] | 150.0000 | 240.0000 | 823 | 823 | false | false | false | ||||||||||
| 01a091e4-9b70-7bd3-82c1-d3379baf8690 | ORCL | 2026-09-11 15:14 | risk_reversal | 2 | 9 | 37 | 29970.00 | long | bid | 151.3000 | 0.4000 | ["120","210"] | ["0.5523","0.5762"] | ["119.63"] | ["AMXO","ARCO","EDGO","EMLD","SPHR","XBOX","XISX","XMIO"] | 120.0000 | 210.0000 | 98 | 98 | false | true | false | ||||||||||
| 01a090e3-11c0-7033-8c2c-50cd7ad974d9 | ORCL | 2026-09-11 10:33 | risk_reversal | 3 | 2 | 25 | 62760.00 | long | bid | 153.3800 | 0.8500 | ["160","170"] | ["0.5241","0.5230"] | ["149.30"] | ["MCRY","XBOX"] | 160.0000 | 170.0000 | 35 | 35 | false | false | false | ||||||||||
| 01a090e2-b7e8-7263-9561-5e4baaabeebd | ORCL | 2026-09-11 10:32 | risk_reversal | 2 | 2 | 9 | 29853.00 | long | bid | 153.6250 | 1.7278 | ["155","175"] | ["0.5618","0.5690"] | ["148.73"] | ["ARCO","XBOX"] | 155.0000 | 175.0000 | 126 | 126 | false | false | false | ||||||||||
| 01a090df-3191-7143-a426-09369ce01c2a | ORCL | 2026-09-11 10:28 | risk_reversal | 2 | 1 | 10 | 27710.00 | long | bid | 153.8650 | 0.4500 | ["150","170"] | ["0.5648","0.5738"] | ["147.61"] | ["XBOX"] | 150.0000 | 170.0000 | 98 | 98 | false | true | false | ||||||||||
| 01a0818d-6518-7410-9fe3-cb379d8ba10b | ORCL | 2026-09-08 11:05 | risk_reversal | 3 | 1 | 10 | 73780.00 | long | ask | 163.8900 | 1.7500 | ["120","160","260"] | ["0.5995","0.5835","0.5973"] | ["171.20"] | ["XMIO"] | 120.0000 | 260.0000 | 374 | 374 | false | false | false | ||||||||||
| 01a06d37-72d5-7461-a115-d931ceb8cd39 | ORCL | 2026-09-04 12:19 | risk_reversal | 2 | 2 | 57 | 27083.00 | long | ask | 157.9450 | 0.1100 | ["115","230"] | ["0.5951","0.6316"] | ["230.57"] | ["MCRY","XMIO"] | 115.0000 | 230.0000 | 77 | 77 | false | true | false |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:31:19Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T17:10:07Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| mlft |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:08:32Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:20:43Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:15:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:20:51Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:31:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlat |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:57:16Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:37:03Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:58:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:58:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:58:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:58:06Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:36:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:14:56Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:33:22Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:33:01Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:29:23Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:05:22Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| mlet |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:19:12Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |