Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
312,778 rowsCSV — whole table, not this view
Sources in this table
uw_multileg312,778 rowsexportable
| idtext | tickertext | executed_at ↓timestamp with time zone | strategytext | leg_countinteger | txnsinteger | sizebigint | total_premiumnumeric | directiontext | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b618-0828-7333-86b6-3aa37c1b16da | COIN | 2026-09-18 15:57 | call_vertical_spread | 2 | 1 | 1000 | 1789000.00 | short | bid | 193.8400 | 0.9600 | ["177.5","192.5"] | ["19.5676","2.8885"] | ["192.49"] | ["XISX"] | 177.5000 | 192.5000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:57:16Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b600-3680-73d1-be73-5558c5f6e4e3 | COIN | 2026-09-18 15:31 | call_vertical_spread | 2 | 1 | 4415 | 13933740.00 | short | bid | 194.5500 | 1.3000 | ["175","182.5"] | ["10.5973","5.5332"] | ["182.5"] | ["XISX"] | 175.0000 | 182.5000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:31:14Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b59f-9437-7a12-b2ab-b13617198546 | COIN | 2026-09-18 13:45 | call_vertical_spread | 2 | 1 | 1000 | 635000.00 | short | bid | 195.1500 | 0.3200 | ["202.5","212.5"] | ["0.6652","0.7002"] | ["204.67"] | ["EDGO"] | 202.5000 | 212.5000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:45:43Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b584-5f5f-7113-8da7-c1b6b4207c6d | COIN | 2026-09-18 13:15 | call_vertical_spread | 2 | 1 | 50 | 158500.00 | short | bid | 194.8000 | 2.1000 | ["177.5","180"] | ["3.5309","3.0004"] | [] | ["XPHO"] | 177.5000 | 180.0000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:16:01Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b56c-5ed7-79e0-9800-f182397ba38c | COIN | 2026-09-18 12:49 | call_vertical_spread | 2 | 1 | 2000 | 1368000.00 | short | bid | 193.4700 | 0.4100 | ["200","210"] | ["0.6722","0.7122"] | ["202.26"] | ["EDGO"] | 200.0000 | 210.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:50:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b568-bd27-76a0-a7d2-33086701c1e7 | COIN | 2026-09-18 12:45 | call_vertical_spread | 2 | 1 | 10 | 128560.00 | short | bid | 194.0050 | 5.3000 | ["155","160"] | ["0.7284","0.7264"] | ["157.72"] | ["XMIO"] | 155.0000 | 160.0000 | 245 | 245 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:45:59Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b50e-e90f-73f3-a317-baea76fd2229 | COIN | 2026-09-18 11:07 | call_vertical_spread | 2 | 1 | 20 | 136080.00 | short | bid | 191.6850 | 1.5500 | ["150","250"] | ["0.6968","0.7054"] | ["190"] | ["XCBO"] | 150.0000 | 250.0000 | 119 | 119 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T15:07:27Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d4-e967-7fd0-8da7-9f3f45bc2638 | COIN | 2026-09-18 10:04 | call_vertical_spread | 2 | 1 | 1500 | 1155000.00 | short | bid | 185.5300 | 0.4700 | ["190","197.5"] | ["0.6605","0.6834"] | ["192.1"] | ["EDGO"] | 190.0000 | 197.5000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:04:13Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b0c6-bc3a-7d03-992a-580cf0edc752 | COIN | 2026-09-17 15:10 | call_vertical_spread | 2 | 1 | 850 | 521050.00 | short | bid | 172.1550 | 0.4900 | ["177.5","185"] | ["0.6084","0.6268"] | ["179.41"] | ["EDGO"] | 177.5000 | 185.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:10:21Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abb6-0733-7d30-a63e-682daf50fd5e | COIN | 2026-09-16 15:33 | put_vertical_spread | 2 | 1 | 320 | 373440.00 | short | bid | 162.9800 | 0.7500 | ["157.5","165"] | ["0.6494","0.6448"] | ["161.49"] | ["AMXO"] | 157.5000 | 165.0000 | 9 | 9 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:33:51Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a6a5-b6e5-79c1-9e61-02e389b8bc5e | COIN | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 68 | 150824.00 | short | ask | 172.4200 | 0.9500 | ["160","185"] | ["0.8281","0.6681"] | [] | ["EDGO"] | 160.0000 | 185.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:51Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a6a4-ff4e-75d2-9ad9-288d622c42a8 | COIN | 2026-09-15 15:57 | call_diagonal_spread | 2 | 1 | 68 | 151300.00 | short | ask | 172.5300 | 0.8000 | ["160","185"] | ["0.8216","0.6658"] | [] | ["EDGO"] | 160.0000 | 185.0000 | 3 | 31 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T19:57:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a575-4566-7462-afd6-a0dc6c05ec1e | COIN | 2026-09-15 10:25 | call_calendar | 2 | 1 | 80 | 392640.00 | short | bid | 178.5700 | 3.9000 | ["155"] | ["0.8912"] | [] | ["XCBO"] | 155.0000 | 155.0000 | 3 | 10 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:25:23Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a16f-9888-7a93-bbca-0b0a39ff5ba7 | COIN | 2026-09-14 15:40 | call_vertical_spread | 2 | 1 | 10 | 116220.00 | short | bid | 192.0350 | 2.8500 | ["165","170"] | ["0.7277","0.7259"] | ["167.48"] | ["AMXO"] | 165.0000 | 170.0000 | 249 | 249 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:41:14Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a16e-1da1-7972-a087-fadde8033239 | COIN | 2026-09-14 15:39 | call_vertical_spread | 2 | 1 | 10 | 106380.00 | short | bid | 191.8500 | 2.2500 | ["175","180"] | ["0.7234","0.7226"] | ["177.24"] | ["XMIO"] | 175.0000 | 180.0000 | 249 | 249 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:39:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0d0-89c8-70b0-af3e-6f079aad03de | COIN | 2026-09-14 12:46 | call_condor | 4 | 1 | 20 | 131570.00 | short | bid | 189.6200 | 3.0500 | ["200","230","250","330"] | ["0.7038","0.7084","0.7146","0.7522"] | ["200.58","279.42"] | ["XCBO"] | 200.0000 | 330.0000 | 123 | 123 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T16:47:03Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a09d-5851-7710-b92c-1ed777d44bd0 | COIN | 2026-09-14 11:50 | call_condor | 4 | 1 | 20 | 127120.00 | short | bid | 187.3450 | 4.3000 | ["200","230","250","330"] | ["0.7098","0.7150","0.7211","0.7608"] | ["200.64","279.36"] | ["XCBO"] | 200.0000 | 330.0000 | 123 | 123 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:51:28Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091df-adb8-7dc3-b231-5013533ac0e0 | COIN | 2026-09-11 15:09 | put_calendar | 2 | 1 | 3 | 196074.00 | short | bid | 174.6850 | 6.8000 | ["500"] | ["0.9230"] | [] | ["XCBO"] | 500.0000 | 500.0000 | 497 | 644 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:09:12Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0915d-75ca-7932-a2bf-888a7e15b568 | COIN | 2026-09-11 12:46 | put_vertical_spread | 2 | 1 | 8 | 129256.00 | short | bid | 177.9050 | 3.9000 | ["200","210"] | ["0.7149","0.7163"] | ["203.19"] | ["XCBO"] | 200.0000 | 210.0000 | 826 | 826 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:47:00Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090ba-5410-73c2-b26f-81fe65d37dff | COIN | 2026-09-11 09:48 | call_vertical_spread | 2 | 1 | 200 | 170334.00 | short | bid | 175.0500 | 0.7100 | ["177.5","185"] | ["0.6689","0.6973"] | ["179.82"] | ["XISX"] | 177.5000 | 185.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T13:48:51Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08ce6-7850-7e81-9e2f-b522cc8afc3b | COIN | 2026-09-10 15:58 | put_calendar | 2 | 1 | 9 | 102474.00 | short | ask | 172.4300 | 7.9000 | ["230"] | ["0.9541"] | [] | ["XCBO"] | 230.0000 | 230.0000 | 8 | 22 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:58:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd9-9770-71f3-9da2-90fda6baf4fe | COIN | 2026-09-10 15:44 | call_vertical_spread | 2 | 1 | 250 | 206000.00 | short | bid | 173.2600 | 0.4900 | ["177.5","185"] | ["0.6820","0.7043"] | ["179.66"] | ["EDGO"] | 177.5000 | 185.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:44:29Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd0-48a0-74b3-ab75-e920bd9b488a | COIN | 2026-09-10 15:34 | call_vertical_spread | 2 | 1 | 750 | 622874.00 | short | bid | 173.3100 | 0.1500 | ["177.5","185"] | ["0.6824","0.7073"] | ["179.64"] | ["EDGO"] | 177.5000 | 185.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:34:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bae-4a58-7860-89e4-1b82ccabe4c8 | COIN | 2026-09-10 10:17 | call_vertical_spread | 2 | 1 | 500 | 385500.00 | short | bid | 172.5200 | 0.3600 | ["177.5","185"] | ["0.6811","0.7038"] | ["179.55"] | ["EDGO"] | 177.5000 | 185.0000 | 8 | 8 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T14:17:42Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a087bf-aef0-7f72-89d0-33116060e5de | COIN | 2026-09-09 15:57 | call_vertical_spread | 2 | 1 | 200 | 129400.00 | short | bid | 175.1350 | 0.3500 | ["185","192.5"] | ["0.7060","0.7283"] | ["186.59"] | ["XISX"] | 185.0000 | 192.5000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:58:22Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a087bf-83f8-7ca0-9dbc-4f91881f7610 | COIN | 2026-09-09 15:57 | call_vertical_spread | 2 | 1 | 300 | 194700.00 | short | bid | 175.1450 | 0.3500 | ["185","192.5"] | ["0.7067","0.7293"] | ["186.59"] | ["EDGO"] | 185.0000 | 192.5000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T19:57:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086cf-8e49-7261-b025-fb8407606997 | COIN | 2026-09-09 11:35 | put_vertical_spread | 2 | 1 | 240 | 210480.00 | short | bid | 177.7301 | 0.8000 | ["167.5","172.5"] | ["0.7006","0.7015"] | ["170.69"] | ["EDGO"] | 167.5000 | 172.5000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:36:15Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a06dd4-6a6d-7443-ad79-41b49b5763bc | COIN | 2026-09-04 15:10 | call_calendar | 2 | 1 | 25 | 175550.00 | short | ask | 185.0900 | 4.6500 | ["150"] | ["8.3909"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:11:00Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4f-d505-75f0-88ad-a289e3b88e8e | COIN | 2026-09-04 12:45 | iron_condor | 4 | 2 | 80 | 165460.00 | short | bid | 186.1000 | 1.3500 | ["165","170","210","215"] | ["0.6322","0.6302","0.6659","0.6736"] | ["167.61","212.39"] | ["XMIO"] | 165.0000 | 215.0000 | 28 | 28 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:45:52Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d3d-3765-7a80-9cf0-1c9b75aeef47 | COIN | 2026-09-04 12:25 | call_calendar | 2 | 1 | 16 | 115472.00 | short | ask | 185.5400 | 5.7500 | ["150"] | ["3.6796"] | [] | ["XCBO"] | 150.0000 | 150.0000 | 0 | 7 | false | false | true | false | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:25:47Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |