core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0cf2b-f53e-79c3-92d5-c9cbe2752201 | DIA | 2026-09-23 12:49 | other | 4 | 1 | 46 | 174754.00 | unknown | ask | 514.6100 | 1.0000 | ["510","515"] | ["0.1403","0.1326"] | [] | ["XCBO"] | 510.0000 | 515.0000 | 23 | 30 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-23T16:49:45Z"} | 2026-09-23 | 2026-09-23 17:15 | 2026-09-23 17:15 |
| 01a0c43d-f42e-7691-90cb-717f1f6ca147 | DIA | 2026-09-21 09:53 | call_calendar | 2 | 1 | 50 | 183750.00 | short | bid | 517.5300 | 4.4000 | ["550"] | ["0.1370"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0c439-8f2f-77a0-a491-fd1c39bb8abe | DIA | 2026-09-21 09:48 | call_calendar | 2 | 1 | 50 | 184150.00 | short | bid | 516.9062 | 4.5500 | ["550"] | ["0.1387"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0c438-ac9f-7782-92b9-344c453bc997 | DIA | 2026-09-21 09:47 | call_calendar | 2 | 1 | 50 | 203250.00 | short | bid | 516.9926 | 4.1000 | ["545"] | ["0.1384"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0c436-724f-7220-a054-2f76fb1337c2 | DIA | 2026-09-21 09:44 | call_calendar | 2 | 1 | 50 | 203250.00 | short | bid | 516.9900 | 4.1000 | ["545"] | ["0.1384"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0c434-a177-7803-8542-36cb93482f82 | DIA | 2026-09-21 09:42 | put_vertical_spread | 2 | 1 | 300 | 508314.00 | short | bid | 517.2100 | 0.7500 | ["500","510"] | ["0.1602","0.1509"] | ["507.44"] | ["EDGO"] | 500.0000 | 510.0000 | 88 | 88 | false | true | false | ||||||||||
| 01a0c434-479f-7d73-b006-4a6155bd548d | DIA | 2026-09-21 09:42 | call_calendar | 2 | 1 | 50 | 204750.00 | short | bid | 517.4600 | 3.7000 | ["545"] | ["0.1381"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0c433-a38f-7931-982f-047c1e22532d | DIA | 2026-09-21 09:41 | call_calendar | 2 | 1 | 50 | 205500.00 | short | bid | 517.5301 | 3.4000 | ["545"] | ["0.1383"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0c433-8837-7462-946e-eb2989fb9931 | DIA | 2026-09-21 09:41 | call_calendar | 2 | 1 | 50 | 205550.00 | short | bid | 517.5301 | 3.4000 | ["545"] | ["0.1383"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 269 | 282 | false | true | true | false | |||||||||
| 01a0b5ea-1287-7b73-b61e-e9d1a3cc7dc8 | DIA | 2026-09-18 15:06 | put_vertical_spread | 2 | 1 | 160 | 122400.00 | unknown | bid | 516.3300 | 0.3500 | ["516","517"] | ["0.1099","0.1080"] | ["512.68"] | ["XCBO"] | 516.0000 | 517.0000 | 12 | 12 | true | false | false | ||||||||||
| 01a0b554-e707-7d01-9133-9c44a490989c | DIA | 2026-09-18 12:23 | call_calendar | 2 | 1 | 200 | 749600.00 | short | ask | 514.4400 | 7.7500 | ["545"] | ["0.1352"] | [] | ["XCBO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b544-8f6f-7fd2-89d2-ab8b3a60e6c0 | DIA | 2026-09-18 12:06 | call_calendar | 2 | 1 | 100 | 338200.00 | short | bid | 514.6400 | 4.0000 | ["550"] | ["0.1348"] | [] | ["XCBO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4ff-be3f-7cb1-add1-798f928f4ed6 | DIA | 2026-09-18 10:50 | call_calendar | 2 | 1 | 40 | 153160.00 | short | bid | 514.5500 | 6.1500 | ["545"] | ["0.1372"] | [] | ["XPHO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4fc-6aaf-7503-a4a7-82de3bb77334 | DIA | 2026-09-18 10:47 | put_vertical_spread | 2 | 2 | 49 | 111810.00 | unknown | bid | 514.5414 | 0.9500 | ["500","510"] | ["0.1630","0.1561"] | ["493.59"] | ["XCBO"] | 500.0000 | 510.0000 | 119 | 119 | false | true | false | ||||||||||
| 01a0b4f5-9897-7790-bde1-551eb9a3e0fb | DIA | 2026-09-18 10:39 | call_calendar | 2 | 1 | 50 | 170050.00 | short | bid | 515.0600 | 6.6000 | ["550"] | ["0.1343"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4f3-8557-7823-b354-e1b70e263c32 | DIA | 2026-09-18 10:37 | call_calendar | 2 | 1 | 40 | 153640.00 | short | bid | 514.7500 | 3.8000 | ["545"] | ["0.1370"] | [] | ["XPHO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4f1-c807-7923-b6e8-2975d46ce3ff | DIA | 2026-09-18 10:35 | call_calendar | 2 | 1 | 50 | 171000.00 | short | bid | 514.9307 | 5.1000 | ["550"] | ["0.1352"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4f1-200f-7e51-a09d-1d9914a396a1 | DIA | 2026-09-18 10:34 | call_calendar | 2 | 1 | 40 | 153560.00 | short | bid | 514.9010 | 3.9000 | ["545"] | ["0.1366"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4ef-1887-7500-bff9-08043f06f26b | DIA | 2026-09-18 10:32 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 515.1600 | 4.9000 | ["550"] | ["0.1349"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4ea-6d37-7e20-8107-103b3384639d | DIA | 2026-09-18 10:27 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 515.0400 | 4.9000 | ["550"] | ["0.1352"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e8-ea7f-7e43-8f4e-175cf18fecec | DIA | 2026-09-18 10:25 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 514.9700 | 4.9000 | ["550"] | ["0.1354"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e6-98bf-7b52-9cd2-7c4f7d91cf75 | DIA | 2026-09-18 10:23 | call_calendar | 2 | 1 | 40 | 154480.00 | short | bid | 515.2900 | 3.4500 | ["545"] | ["0.1363"] | [] | ["AMXO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e6-526f-7ca2-82e0-48b0e502ef31 | DIA | 2026-09-18 10:23 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 515.2650 | 4.9000 | ["550"] | ["0.1347"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e6-0067-7a03-9026-fe94a07128fe | DIA | 2026-09-18 10:22 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 515.3000 | 4.9000 | ["550"] | ["0.1346"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e5-dd3f-7081-b4e5-0c47880a7b5b | DIA | 2026-09-18 10:22 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 515.3200 | 4.9000 | ["550"] | ["0.1345"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e4-db6f-7a11-a7e1-c7da3f1249a4 | DIA | 2026-09-18 10:21 | call_calendar | 2 | 1 | 50 | 171450.00 | unknown | bid | 515.2700 | 4.9000 | ["550"] | ["0.1346"] | [] | ["AMXO"] | 550.0000 | 550.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e4-3377-7063-876e-75299cc782d3 | DIA | 2026-09-18 10:20 | call_calendar | 2 | 1 | 40 | 154560.00 | short | bid | 515.0500 | 3.4500 | ["545"] | ["0.1369"] | [] | ["XMIO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e3-3d5f-7d30-89e0-30d8588ffdbb | DIA | 2026-09-18 10:19 | call_calendar | 2 | 1 | 40 | 154560.00 | short | bid | 515.2200 | 3.4500 | ["545"] | ["0.1365"] | [] | ["XMIO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4e2-89af-7a51-8243-f2af99d26cdf | DIA | 2026-09-18 10:18 | call_calendar | 2 | 1 | 40 | 154640.00 | short | bid | 515.1800 | 3.5000 | ["545"] | ["0.1367"] | [] | ["XMIO"] | 545.0000 | 545.0000 | 272 | 285 | false | true | true | false | |||||||||
| 01a0b4db-4a38-7e22-ac9b-81c73cfbb81b | DIA | 2026-09-18 10:11 | call_calendar | 2 | 1 | 60 | 228060.00 | short | ask | 515.1551 | 5.9000 | ["545"] | ["0.1349"] | [] | ["XCBO"] | 545.0000 | 545.0000 | 272 | 285 | true | true | true | false | |||||||||
| 01a0b4bb-f6af-71f3-8741-f69a166ed850 | DIA | 2026-09-18 09:36 | put_calendar | 2 | 1 | 50 | 259700.00 | unknown | bid | 515.5100 | 6.8000 | ["525"] | ["0.1669"] | [] | ["XCBO"] | 525.0000 | 525.0000 | 272 | 285 | false | false | true | false | |||||||||
| 01a0abae-4ea3-7bf3-a216-773cc4be03ef | DIA | 2026-09-16 15:25 | other | 4 | 1 | 50 | 178850.00 | unknown | — | 513.0500 | 1.3500 | ["510","515"] | ["0.1462","0.1393"] | [] | ["XMIO"] | 510.0000 | 515.0000 | 23 | 30 | false | false | true | true | false | mlat | |||||||
| 01a0abac-b863-7ac0-97ff-2dd38d245fba | DIA | 2026-09-16 15:23 | other | 4 | 1 | 36 | 165960.00 | unknown | — | 512.9600 | 2.6000 | ["522","524"] | ["0.2343","0.2499"] | [] | ["XCBO"] | 522.0000 | 524.0000 | 2 | 9 | false | false | true | true | false | mlat | |||||||
| 01a090fa-00d8-7472-8498-7fae3384156d | DIA | 2026-09-11 10:58 | put_calendar | 2 | 1 | 100 | 135400.00 | long | bid | 524.8400 | 0.6000 | ["527"] | ["0.1380"] | [] | ["XCBO"] | 527.0000 | 527.0000 | 14 | 19 | false | false | true | false | |||||||||
| 01a087ad-d888-7912-852e-4ed37323b5d2 | DIA | 2026-09-09 15:38 | call_vertical_spread | 2 | 1 | 50 | 104550.00 | long | ask | 524.7700 | 0.6000 | ["530","535"] | ["0.1314","0.1288"] | ["532.43"] | ["XCBO"] | 530.0000 | 535.0000 | 72 | 72 | false | true | false | ||||||||||
| 01a06e07-97fd-7c53-bc8a-9271696701c2 | DIA | 2026-09-04 16:06 | call_calendar | 2 | 1 | 10 | 139620.00 | short | bid | 533.9123 | 0.8500 | ["465"] | ["0.3297"] | [] | ["XCBO"] | 465.0000 | 465.0000 | 14 | 42 | false | false | true | false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:53:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:48:26Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:47:36Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:45:00Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:43:08Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:42:38Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:41:53Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:41:53Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:07:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:24:07Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:06:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:50:58Z"} |
| 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:47:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:40:08Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:37:39Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:35:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:35:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:32:55Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:27:56Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:26:11Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:44Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:23:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:22:38Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:21:51Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:20:48Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:19:47Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:19:01Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:11:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T13:37:00Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:25:29Z"} |
| 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-16T19:23:42Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T14:58:44Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:38:34Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T20:07:16Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |