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 |
|---|
| 01a0d97e-23af-7822-a15b-fb31023203fd | DE | 2026-09-25 12:55 | other | 4 | 1 | 10 | 108460.00 | unknown | bid | 686.5400 | 24.8000 | ["705","707.5","710"] | ["0.3157","1.1459","1.1250"] | [] | ["XCBO"] | 705.0000 | 710.0000 | 0 | 21 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T16:55:18Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d91b-1c1f-7e71-a42d-96a53b58e8ce | DE | 2026-09-25 11:07 | call_diagonal_spread | 2 | 1 | 3 | 105894.00 | long | bid | 685.8250 | 18.0000 | ["580","680"] | ["0.3350","0.3316"] | [] | ["EDGO"] | 580.0000 | 680.0000 | 483 | 847 | false | false | true | ||||||||||
| 01a0d8cd-61af-7f22-98ff-dba6aaa84db6 | DE | 2026-09-25 09:42 | call_vertical_spread | 2 | 1 | 20 | 115220.00 | short | bid | 695.0000 | 16.2000 | ["665","667.5"] | ["0.6781","0.6491"] | ["667.49"] | ["XMIO"] | 665.0000 | 667.5000 | 0 | 0 | false | false | false | ||||||||||
| 01a0d446-52ef-7eb0-8c6b-c2d684c4396e | DE | 2026-09-24 12:36 | call_vertical_spread | 2 | 1 | 7 | 136857.00 | short | bid | 695.6100 | 10.2000 | ["597.5","600"] | ["1.6323","1.5985"] | ["599.99"] | ["XMIO"] | 597.5000 | 600.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d446-4b1f-7ae1-b0c1-a0c70e540465 | DE | 2026-09-24 12:36 | call_vertical_spread | 2 | 1 | 10 | 195470.00 | short | bid | 695.6100 | 10.2000 | ["597.5","600"] | ["1.6250","1.5914"] | ["599.99"] | ["XCBO"] | 597.5000 | 600.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d401-4b0f-7d91-9b90-492a91763ad4 | DE | 2026-09-24 11:20 | call_vertical_spread | 2 | 1 | 10 | 188610.00 | long | ask | 697.0500 | 14.2000 | ["600","605"] | ["2.1682","2.0939"] | ["604.97"] | ["XCBO"] | 600.0000 | 605.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d401-00d6-7663-9778-058e5b0cf2b2 | DE | 2026-09-24 11:20 | call_vertical_spread | 2 | 1 | 10 | 188610.00 | long | ask | 697.0500 | 14.2000 | ["600","605"] | ["2.1682","2.0939"] | ["604.97"] | ["XCBO"] | 600.0000 | 605.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d3ed-0b77-7f30-bf80-c5bff87d9a06 | DE | 2026-09-24 10:58 | call_vertical_spread | 2 | 1 | 10 | 190710.00 | long | ask | 698.6500 | 9.6000 | ["600","605"] | ["1.8329","1.7770"] | ["604.99"] | ["XCBO"] | 600.0000 | 605.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d3ec-5baf-7c93-a731-e2c5f7f086cd | DE | 2026-09-24 10:57 | call_vertical_spread | 2 | 1 | 10 | 190710.00 | long | ask | 697.5500 | 9.6000 | ["600","605"] | ["1.3237","1.2671"] | ["604.99"] | ["XCBO"] | 600.0000 | 605.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d3e4-8baf-7ce3-a9e0-3d0cc79993ee | DE | 2026-09-24 10:49 | call_vertical_spread | 2 | 1 | 10 | 178070.00 | long | ask | 698.1550 | 13.5000 | ["607.5","612.5"] | ["1.5063","1.4425"] | ["612.47"] | ["XCBO"] | 607.5000 | 612.5000 | 1 | 1 | false | false | false | ||||||||||
| 01a0d3b0-15ff-7251-ba0a-4001d6064407 | DE | 2026-09-24 09:52 | call_calendar | 2 | 1 | 10 | 189010.00 | short | ask | 704.9450 | 9.8000 | ["610"] | ["1.0532"] | [] | ["XCBO"] | 610.0000 | 610.0000 | 1 | 22 | false | false | true | false | |||||||||
| 01a0ce9a-09c7-7301-b056-4eee0623b51c | DE | 2026-09-23 10:09 | call_vertical_spread | 2 | 1 | 37 | 288970.00 | short | bid | 719.7550 | 5.0000 | ["670","720"] | ["0.3081","0.2925"] | ["704.42"] | ["XMIO"] | 670.0000 | 720.0000 | 23 | 23 | false | false | false | ||||||||||
| 01a0c9be-f34e-70f3-8914-243fcbfa7328 | DE | 2026-09-22 11:32 | call_vertical_spread | 2 | 1 | 20 | 118540.00 | long | ask | 693.1850 | 9.5000 | ["665","667.5"] | ["0.4637","0.4467"] | ["667.33"] | ["XCBO"] | 665.0000 | 667.5000 | 3 | 3 | true | false | false | ||||||||||
| 01a0c557-e3f7-74a0-a0b8-f66d5824aa21 | DE | 2026-09-21 15:01 | call_calendar | 2 | 3 | 12 | 133116.00 | short | ask | 691.6400 | 9.0000 | ["700"] | ["0.3316"] | [] | ["XCBO"] | 700.0000 | 700.0000 | 88 | 179 | false | true | true | false | |||||||||
| 01a0b51b-8788-79f2-8a47-1ef159ba74ee | DE | 2026-09-18 11:21 | other | 4 | 1 | 21 | 109788.00 | unknown | — | 682.7350 | 13.7000 | ["650","680","710","740"] | ["2.2456","0.4114","0.2787","0.2944"] | [] | ["XPHO"] | 650.0000 | 740.0000 | 0 | 28 | false | false | true | true | false | ||||||||
| 01a0b4d5-4340-7b03-8d53-25a17a8f34e1 | DE | 2026-09-18 10:04 | call_diagonal_spread | 2 | 1 | 11 | 188210.00 | long | ask | 682.6450 | 8.2000 | ["600","620"] | ["2.9197","0.3472"] | [] | ["XMIO"] | 600.0000 | 620.0000 | 0 | 91 | false | false | true | ||||||||||
| 01a0b4ce-e26f-7b41-9661-0d69b58ab4e8 | DE | 2026-09-18 09:57 | call_diagonal_spread | 2 | 1 | 6 | 539400.00 | long | bid | 683.4650 | 13.2000 | ["230","240"] | ["16.5276","0.9356"] | [] | ["XMIO"] | 230.0000 | 240.0000 | 0 | 119 | false | false | true | ||||||||||
| 01a0b04e-5bd3-7680-b0a6-2070fa2f079a | DE | 2026-09-17 12:58 | call_diagonal_spread | 2 | 1 | 9 | 323163.00 | short | ask | 680.6850 | 9.9000 | ["500","510"] | ["2.4668","0.3555"] | [] | ["XCBO"] | 500.0000 | 510.0000 | 1 | 92 | false | false | true | ||||||||||
| 01a0a6a2-4be6-76f3-8b14-01dbc90ecb8d | DE | 2026-09-15 15:54 | other | 4 | 1 | 5 | 286160.00 | unknown | — | 681.6500 | 24.4000 | ["540","550"] | ["0.8369","0.8257"] | [] | ["XCBO"] | 540.0000 | 550.0000 | 3 | 94 | false | false | true | true | false | mlat | |||||||
| 01a0a58d-9fc6-7003-b94a-c3a6d8163e06 | DE | 2026-09-15 10:51 | call_diagonal_spread | 2 | 1 | 9 | 423180.00 | unknown | — | 683.5475 | 14.4000 | ["510","550"] | ["0.3861","0.3706"] | [] | ["XPHO"] | 510.0000 | 550.0000 | 493 | 857 | false | false | true | true | false | ||||||||
| 01a08c8e-bf48-78a0-a1c2-9b46aa7f830a | DE | 2026-09-10 14:22 | call_diagonal_spread | 2 | 1 | 10 | 263710.00 | short | bid | 675.5750 | 12.2000 | ["580","600"] | ["0.3494","0.3521"] | [] | ["XMIO"] | 580.0000 | 600.0000 | 190 | 280 | false | false | true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T15:07:27Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T13:42:25Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:36:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T16:36:23Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:21:13Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:20:39Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:59:03Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:57:56Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:49:32Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T13:52:28Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:10:01Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:32:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:01:21Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T15:21:36Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:04:31Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:57:33Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T16:59: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-15T19:54:29Z"} |
| 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-15T14:51:57Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:23:24Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |