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 |
|---|
| 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 |
|---|
| 01a0d4d3-7f8f-7a73-8e89-75120a80c522 | ETN | 2026-09-24 15:10 | call_diagonal_spread | 2 | 1 | 12 | 145800.00 | long | ask | 438.3800 | 4.8000 | ["450","460"] | ["0.3807","0.3740"] | [] | ["XMIO"] | 450.0000 | 460.0000 | 266 | 358 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:10:50Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cf7a-28c7-78d1-bdc4-a7eb5045f9f1 | ETN | 2026-09-23 14:14 | call_diagonal_spread | 2 | 1 | 7 | 322700.00 | long | bid | 439.0850 | 10.0000 | ["220","240"] | ["0.2235","0.3176"] | [] | ["XMIO"] | 220.0000 | 240.0000 | 485 | 849 | false | false | |||||||||||
| 01a0cecb-0ca7-7103-b8d4-6973cc0bf94a | ETN | 2026-09-23 11:03 | call_vertical_spread | 2 | 1 | 50 | 269050.00 | long | ask | 438.9400 | 6.8000 | ["417.5","420"] | ["0.3934","0.3908"] | ["419.35"] | ["XCBO"] | 417.5000 | 420.0000 | 16 | 16 | true | false | |||||||||||
| 01a0c98f-9267-7d40-baa9-fbac7e470795 | ETN | 2026-09-22 10:40 | call_diagonal_spread | 2 | 1 | 16 | 213280.00 | long | ask | 439.7200 | 7.0000 | ["440","450"] | ["0.3816","0.3809"] | [] | ["XMIO"] | 440.0000 | 450.0000 | 268 | 360 | false | true | |||||||||||
| 01a0c536-e2bf-76f2-8528-96a0df6480ef | ETN | 2026-09-21 14:25 | straddle | 2 | 1 | 100 | 775000.00 | long | ask | 435.6000 | 7.2000 | ["450"] | ["0.3911"] | ["372.50","527.50"] | ["SPHR"] | 450.0000 | 450.0000 | 116 | 116 | false | false | |||||||||||
| 01a0c4c1-455f-7992-a356-867ea4f48c9c | ETN | 2026-09-21 12:16 | call_diagonal_spread | 2 | 1 | 15 | 193500.00 | long | ask | 435.9250 | 6.6000 | ["440","450"] | ["0.3816","0.3809"] | [] | ["XISX"] | 440.0000 | 450.0000 | 269 | 361 | false | true | |||||||||||
| 01a08bd0-5d01-73b3-bc76-ea449dcbb939 | ETN | 2026-09-10 10:54 | call_calendar | 2 | 1 | 82 | 208608.00 | long | ask | 412.1550 | 1.7500 | ["450"] | ["0.3867"] | [] | ["XPHO"] | 450.0000 | 450.0000 | 8 | 127 | false | true | |||||||||||
| 01a08bc1-da29-7112-8d3a-6b00d579d786 | ETN | 2026-09-10 10:38 | call_calendar | 2 | 1 | 125 | 330750.00 | long | bid | 413.1900 | 2.2500 | ["450"] | ["0.3989"] | [] | ["AMXO"] | 450.0000 | 450.0000 | 8 | 127 | false | true | |||||||||||
| 01a08bac-2390-7f60-86a5-f5bd1366757a | ETN | 2026-09-10 10:15 | risk_reversal | 2 | 1 | 17 | 138533.00 | long | bid | 407.9900 | 10.0000 | ["370","580"] | ["0.4203","0.3946"] | ["357.15"] | ["ARCO"] | 370.0000 | 580.0000 | 498 | 498 | false | true | |||||||||||
| 01a08bac-2390-7f60-86a5-f5a7f8c15197 | ETN | 2026-09-10 10:15 | risk_reversal | 2 | 1 | 17 | 138533.00 | long | bid | 407.9900 | 10.0000 | ["370","580"] | ["0.4204","0.3945"] | ["357.11"] | ["ARCO"] | 370.0000 | 580.0000 | 498 | 498 | false | true | |||||||||||
| 01a0866f-22b0-7022-9c7c-299d60c4c40e | ETN | 2026-09-09 09:50 | call_vertical_spread | 2 | 1 | 10 | 110360.00 | long | ask | 419.3650 | 6.3000 | ["360","370"] | ["0.5221","0.4783"] | ["369.80"] | ["XCBO"] | 360.0000 | 370.0000 | 9 | 9 | false | false | |||||||||||
| 01a08190-1c68-7581-afb2-1b34b062486c | ETN | 2026-09-08 11:08 | risk_reversal | 3 | 2 | 20 | 125080.00 | long | ask | 427.3125 | 7.3000 | ["400","410","430"] | ["0.3961","0.3979","0.3846"] | ["411.85"] | ["AMXO","XMIO"] | 400.0000 | 430.0000 | 38 | 38 | false | false |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:15:18Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:03:36Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:40:40Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:25:02Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:17:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:55:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:39:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:27Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:27Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:50:32Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:08:41Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |