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 |
|---|
| 01a0b5b2-d200-7a71-856b-a59a680c3d48 | LEN | 2026-09-18 14:06 | put_diagonal_spread | 2 | 1 | 21 | 106470.00 | long | bid | 76.1500 | 4.6000 | ["85","115"] | ["0.4038","0.6736"] | [] | ["XMIO"] | 85.0000 | 115.0000 | 63 | 119 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:06:56Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4ed-e7d7-7df3-8b57-68afb7f9dce6 | LEN | 2026-09-18 10:31 | other | 3 | 1 | 138 | 183816.00 | unknown | — | 76.0200 | 1.2500 | ["82","83","86"] | ["0.4295","0.4504","0.4818"] | [] | ["XCBO"] | 82.0000 | 86.0000 | 7 | 7 | false | false | false | true | true | ||||||||
| 01a0b0ab-1dea-7313-87e0-eaffa025dd8e | LEN | 2026-09-17 14:39 | put_ladder | 5 | 1 | 240 | 607740.00 | unknown | — | 78.5950 | 11.7000 | ["88","89","90","95","100"] | ["2.3604","3.0810","2.5463","3.1724","4.8067"] | [] | ["XBOX"] | 88.0000 | 100.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0afc9-64c3-7f21-ba54-c7c86fc751f4 | LEN | 2026-09-17 10:33 | other | 4 | 1 | 3051 | 482058.00 | unknown | — | 78.6100 | 0.5000 | ["82","84","85","87"] | ["0.4524","0.4582","1.0037","1.1128"] | [] | ["AMXO"] | 82.0000 | 87.0000 | 1 | 8 | false | true | true | true | false | ||||||||
| 01a0abcd-d10b-73b3-82bc-2f1ef49e4e9d | LEN | 2026-09-16 15:59 | other | 3 | 1 | 120 | 141964.00 | unknown | — | 78.3800 | 1.3500 | ["82","83","86"] | ["0.6316","0.6061","0.6169"] | [] | ["XMIO"] | 82.0000 | 86.0000 | 9 | 9 | false | false | false | true | true | ||||||||
| 01a0aab2-04b3-73c0-93fe-464ea5cf5cf3 | LEN | 2026-09-16 10:49 | put_vertical_spread | 2 | 1 | 3080 | 1336720.00 | unknown | — | 80.7800 | 0.7000 | ["74","83"] | ["1.0683","1.1114"] | [] | ["XMIO"] | 74.0000 | 83.0000 | 2 | 2 | true | false | false | true | false | ||||||||
| 01a0a630-929e-7032-981b-47892b027fdc | LEN | 2026-09-15 13:49 | put_ratio_spread | 2 | 1 | 1875 | 850000.00 | unknown | — | 80.3356 | 0.8500 | ["78","82"] | ["0.6055","0.5209"] | [] | ["ARCO"] | 78.0000 | 82.0000 | 10 | 10 | false | false | false | true | false | ||||||||
| 01a0a17b-6be1-71c0-83c2-5cd0efe5c322 | LEN | 2026-09-14 15:53 | call_vertical_spread | 2 | 1 | 80 | 135200.00 | short | bid | 79.8100 | 2.3500 | ["75","115"] | ["0.3881","0.3905"] | ["86.44"] | ["XISX"] | 75.0000 | 115.0000 | 276 | 276 | true | false | false | ||||||||||
| 01a08cb2-25c9-7b00-b91c-84796cbf1b78 | LEN | 2026-09-10 15:01 | other | 7 | 1 | 579 | 978604.00 | unknown | — | 77.3800 | 12.7000 | ["84","85","86","87","88","89","90"] | ["1.6968","1.4092","2.2658","1.7902","2.2619","2.7870","3.2789"] | [] | ["XBOX"] | 84.0000 | 90.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a08c9b-4e20-7a53-91ef-953c871d6186 | LEN | 2026-09-10 14:36 | other | 5 | 1 | 298 | 569160.00 | unknown | — | 77.2700 | 10.0000 | ["86","87","88","89","90"] | ["2.1870","1.6548","2.1599","2.7030","3.2042"] | [] | ["XBOX"] | 86.0000 | 90.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a08c2e-6739-7553-9426-8a5f221fce66 | LEN | 2026-09-10 12:37 | other | 2 | 1 | 19 | 132240.00 | unknown | — | 77.4700 | 4.2000 | ["110"] | ["0.5008"] | [] | ["EMLD"] | 110.0000 | 110.0000 | 280 | 372 | false | false | true | false | false | ||||||||
| 01a08bf5-fdd0-7a13-8239-56b60fd192e7 | LEN | 2026-09-10 11:35 | put_vertical_spread | 2 | 1 | 1250 | 1057500.00 | short | bid | 77.1600 | 0.9500 | ["75","82"] | ["0.5614","0.4863"] | ["78.40"] | ["XPHO"] | 75.0000 | 82.0000 | 15 | 15 | false | false | false | ||||||||||
| 01a08bcc-de79-75b3-8646-2ae7bfa4118b | LEN | 2026-09-10 10:50 | put_diagonal_spread | 2 | 1 | 21 | 127869.00 | long | bid | 77.0200 | 4.6000 | ["105","110"] | ["0.4404","0.4774"] | [] | ["AMXO"] | 105.0000 | 110.0000 | 71 | 162 | false | false | true | ||||||||||
| 01a08bc7-0a48-7a12-8468-b48e465f5149 | LEN | 2026-09-10 10:44 | put_diagonal_spread | 2 | 1 | 1232 | 862400.00 | short | bid | 76.8450 | 0.8000 | ["72","82"] | ["0.6363","0.4361"] | [] | ["XBOX"] | 72.0000 | 82.0000 | 8 | 15 | false | false | true | ||||||||||
| 01a08bb8-f4d1-7521-84c9-e49fc3db3193 | LEN | 2026-09-10 10:29 | put_diagonal_spread | 2 | 2 | 1250 | 950000.00 | short | bid | 77.3000 | 0.9000 | ["75","82"] | ["0.6287","0.4619"] | [] | ["ARCO"] | 75.0000 | 82.0000 | 8 | 15 | false | false | true | ||||||||||
| 01a08b95-01b0-7183-a742-746f3f4150de | LEN | 2026-09-10 09:49 | other | 2 | 1 | 60 | 117200.00 | unknown | — | 77.3800 | 2.4000 | ["80","85"] | ["0.4141","0.4326"] | [] | ["ARCO"] | 80.0000 | 85.0000 | 127 | 190 | false | false | true | true | false | ||||||||
| 01a086dd-0398-73e0-9545-8eeebbb98c4b | LEN | 2026-09-09 11:50 | other | 4 | 1 | 3056 | 672320.00 | unknown | — | 80.1000 | 0.8500 | ["85","86","87"] | ["0.5832","0.6446","0.5837"] | [] | ["XCBO"] | 85.0000 | 87.0000 | 2 | 9 | false | true | true | true | false | ||||||||
| 01a0828d-73e0-7a13-94f0-700aef2ff5fd | LEN | 2026-09-08 15:45 | other | 4 | 1 | 16 | 117792.00 | unknown | — | 80.3700 | 9.3000 | ["90","95","100","105"] | ["0.4451","0.2725","0.4836","0.5576"] | [] | ["XBOX"] | 90.0000 | 105.0000 | 73 | 129 | false | false | true | true | false | ||||||||
| 01a081a8-c4e8-7cd1-8f48-29a4198ad7b3 | LEN | 2026-09-08 11:35 | call_vertical_spread | 2 | 1 | 60 | 133800.00 | unknown | — | 81.6300 | 1.0000 | ["75","80"] | ["0.3840","0.3809"] | [] | ["XMIO"] | 75.0000 | 80.0000 | 164 | 164 | false | false | false | true | false |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:31:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T18:40:13Z"} |
| 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-17T14:33:27Z"} |
| 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-16T19:59:52Z"} |
| 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-16T14:49:59Z"} |
| 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-15T17:50:10Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:53:39Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:01:41Z"} |
| 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-10T18:36:49Z"} |
| 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-10T16:37:26Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T15:36:00Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:51:09Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:45:04Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:29:19Z"} |
| 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-10T13:49:59Z"} |
| 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-09T15:50:32Z"} |
| 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-08T19:45:13Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:35:44Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |