core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_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 |
|---|
| 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 | true | 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 |
| 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 | true | ||||||||||
| 01a0c4b5-00be-7aa3-81ef-7ed0fea9b990 | ETN | 2026-09-21 12:03 | call_vertical_spread | 2 | 1 | 11 | 135091.00 | short | bid | 435.5000 | 6.4000 | ["400","430"] | ["0.3851","0.3831"] | ["416.35"] | ["XPHO"] | 400.0000 | 430.0000 | 179 | 179 | false | false | false | ||||||||||
| 01a0af9d-9dbb-7e53-83c4-7f5b913e95e3 | ETN | 2026-09-17 09:45 | call_calendar | 2 | 6 | 16 | 176876.00 | short | bid | 417.5900 | 6.0000 | ["400"] | ["0.5101"] | [] | ["ARCO","BATO","C2OX","EDGO","EMLD","SPHR"] | 400.0000 | 400.0000 | 1 | 491 | false | false | true | ||||||||||
| 01a0af98-17ab-7363-be4d-739e78241890 | ETN | 2026-09-17 09:39 | iron_condor | 4 | 1 | 19 | 336509.00 | unknown | — | 415.8500 | 16.2000 | ["350","380","500","540"] | ["0.4107","0.4111","0.3799","0.3779"] | [] | ["BATO"] | 350.0000 | 540.0000 | 491 | 491 | false | true | false | true | true | ||||||||
| 01a0af98-17ab-7363-be4d-7385ad21f453 | ETN | 2026-09-17 09:39 | iron_condor | 4 | 1 | 6 | 106260.00 | unknown | — | 415.6700 | 16.2000 | ["350","380","500","540"] | ["0.4111","0.4103","0.3807","0.3778"] | [] | ["SPHR"] | 350.0000 | 540.0000 | 491 | 491 | false | true | false | true | true | ||||||||
| 01a0af97-7f53-76d3-aad4-84980c0b0cb6 | ETN | 2026-09-17 09:38 | other | 4 | 1 | 50 | 273850.00 | unknown | — | 417.1700 | 11.4000 | ["400","410","450","500"] | ["0.4063","0.5935","0.9048","0.4022"] | [] | ["MCRY"] | 400.0000 | 500.0000 | 1 | 64 | false | false | true | true | false | ||||||||
| 01a0ab13-339b-7a40-ac2b-9910763fed0b | ETN | 2026-09-16 12:35 | strangle | 2 | 1 | 20 | 118800.00 | unknown | — | 400.8000 | 6.3000 | ["350","470"] | ["0.4084","0.3791"] | [] | ["XISX"] | 350.0000 | 470.0000 | 274 | 274 | false | true | false | true | true | mlet | |||||||
| 01a0aa77-12db-7870-bc9b-2571aa81c954 | ETN | 2026-09-16 09:45 | call_diagonal_spread | 2 | 1 | 12 | 367200.00 | unknown | — | 397.4850 | 9.2000 | ["270","300"] | ["0.3641","0.3524"] | [] | ["XMIO"] | 270.0000 | 300.0000 | 492 | 856 | false | false | true | true | false | ||||||||
| 01a0a67c-513d-7d83-b2f0-5b08941ad9f9 | ETN | 2026-09-15 15:12 | call_vertical_spread | 2 | 1 | 24 | 234720.00 | unknown | — | 392.3950 | 6.2000 | ["360","370"] | ["0.4037","0.4026"] | [] | ["XMIO"] | 360.0000 | 370.0000 | 94 | 94 | false | false | false | true | false | ||||||||
| 01a0a67a-0b35-7e50-ba8e-34f99e85c260 | ETN | 2026-09-15 15:10 | other | 4 | 1 | 10 | 101840.00 | unknown | — | 392.1850 | 7.8000 | ["350","370","410","430"] | ["0.4141","0.3890","0.3983","0.3699"] | [] | ["XISX"] | 350.0000 | 430.0000 | 31 | 94 | false | false | true | true | false | ||||||||
| 01a0a03c-0258-7ea3-bf12-50e7f043d3dc | ETN | 2026-09-14 10:04 | other | 4 | 1 | 15 | 163290.00 | unknown | — | 397.6200 | 11.5000 | ["400","410","420"] | ["0.4006","0.4069","0.3874"] | [] | ["MCRY"] | 400.0000 | 420.0000 | 32 | 123 | false | true | true | true | false | mlet | |||||||
| 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 | true | false | |||||||||
| 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 | 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 | false | true | |||||||||
| 01a08bab-ae60-7b02-9783-c21a7277519c | ETN | 2026-09-10 10:14 | risk_reversal | 2 | 1 | 12 | 103404.00 | unknown | — | 407.9700 | 6.8000 | ["380","580"] | ["0.4215","0.3944"] | [] | ["MCRY"] | 380.0000 | 580.0000 | 498 | 498 | false | true | false | true | true | ||||||||
| 01a0866b-afe1-7181-b6ba-f3385d12b3f4 | ETN | 2026-09-09 09:46 | put_vertical_spread | 2 | 1 | 100 | 118000.00 | unknown | — | 419.1800 | 5.3000 | ["330","340"] | ["0.4200","0.4164"] | [] | ["XISX"] | 330.0000 | 340.0000 | 100 | 100 | false | true | false | true | false | ||||||||
| 01a08205-f460-7231-a6a5-be1989ce30cb | ETN | 2026-09-08 13:17 | other | 2 | 1 | 10 | 117400.00 | unknown | — | 428.8910 | 6.4000 | ["430","450"] | ["0.3951","0.3920"] | [] | ["XISX"] | 430.0000 | 450.0000 | 192 | 374 | false | true | true | true | false | mlet | |||||||
| 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 | false |
| 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 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:03:12Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:45:49Z"} |
| 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-17T13:39:35Z"} |
| 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-17T13:39:35Z"} |
| 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-17T13:39:04Z"} |
| 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-16T16:36:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:45:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:13:03Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:10:34Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:05:02Z"} |
| 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-10T14:55:10Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| 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 |
| 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 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:14:38Z"} |
| 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-09T13:46:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:17:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| 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 |