Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
367,592 rowsCSV — whole table, not this view
Sources in this table
uw_multileg367,592 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c49e-9677-7831-bb63-d296e713a9fc | CIFR | 2026-09-21 11:38 | call_vertical_spread | 2 | 1 | 400 | 169240.00 | long | ask | 18.7350 | 0.1900 | ["23","30"] | ["0.9752","0.9816"] | ["24.31"] | ["XMIO"] | 23.0000 | 30.0000 | 116 | 116 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:39:03Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5a5-d9af-7831-b799-4dcd61411b9e | CIFR | 2026-09-18 13:52 | call_vertical_spread | 2 | 1 | 2500 | 197500.00 | unknown | bid | 17.9775 | 0.1000 | ["19","20"] | ["0.8991","0.9407"] | ["19.79"] | ["XISX"] | 19.0000 | 20.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:52:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b593-7e78-7f60-88dd-0e9d76cccc97 | CIFR | 2026-09-18 13:32 | call_vertical_spread | 2 | 1 | 1250 | 675000.00 | long | ask | 17.7556 | 0.2400 | ["20","23"] | ["0.9514","0.9554"] | ["20.80"] | ["XPHO"] | 20.0000 | 23.0000 | 119 | 119 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:32:20Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0ab74-db9b-7051-aac2-d56144541eec | CIFR | 2026-09-16 14:22 | call_vertical_spread | 2 | 1 | 600 | 106800.00 | unknown | — | 16.9575 | 0.0900 | ["17","18"] | ["1.0198","1.0529"] | [] | ["XISX"] | 17.0000 | 18.0000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T18:22:42Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a025-49f0-7ef3-9ff4-227268279144 | CIFR | 2026-09-14 09:39 | call_vertical_spread | 2 | 1 | 1000 | 170000.00 | long | ask | 15.6401 | 0.2500 | ["15.5","18"] | ["1.0957","1.1070"] | ["16.32"] | ["XMIO"] | 15.5000 | 18.0000 | 11 | 11 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T13:40:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a09191-7a30-7fd3-96ba-6b10057aa27e | CIFR | 2026-09-11 13:43 | call_vertical_spread | 2 | 1 | 1200 | 133200.00 | long | ask | 17.4050 | 0.0700 | ["18","19"] | ["0.9964","0.9936"] | ["18.31"] | ["XCBO"] | 18.0000 | 19.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:44:05Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090d6-f430-7ae3-8a28-9c1fe640e8ad | CIFR | 2026-09-11 10:19 | call_vertical_spread | 2 | 1 | 1000 | 105000.00 | unknown | — | 17.3401 | 0.0700 | ["18","20"] | ["1.0577","1.1617"] | [] | ["XISX"] | 18.0000 | 20.0000 | 7 | 7 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:20:11Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08b92-2b20-74b3-85b2-092c26a30110 | CIFR | 2026-09-10 09:46 | call_vertical_spread | 2 | 1 | 337 | 111547.00 | unknown | — | 15.5050 | 0.3500 | ["20","23"] | ["1.0253","1.0293"] | [] | ["XCBO"] | 20.0000 | 23.0000 | 99 | 99 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:46:51Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08b8d-e560-74a2-8cd8-8a546f610359 | CIFR | 2026-09-10 09:42 | call_vertical_spread | 2 | 1 | 1907 | 139211.00 | long | ask | 15.6600 | 0.1800 | ["15.5","16.5"] | ["1.4289","1.4572"] | ["15.87"] | ["XPHO"] | 15.5000 | 16.5000 | 1 | 1 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T13:42:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a086d6-e919-7e63-a91e-07b590fe0fe0 | CIFR | 2026-09-09 11:43 | call_vertical_spread | 2 | 1 | 302 | 112042.00 | unknown | — | 17.2350 | 0.0800 | ["21","22"] | ["1.0470","1.0446"] | [] | ["EDGO"] | 21.0000 | 22.0000 | 72 | 72 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:43:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d6-9328-7d82-8fa3-3c49b5b6c28e | CIFR | 2026-09-09 11:43 | call_vertical_spread | 2 | 1 | 357 | 131733.00 | unknown | — | 17.2299 | 0.0700 | ["21","22"] | ["1.0444","1.0418"] | [] | ["EDGO"] | 21.0000 | 22.0000 | 72 | 72 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:43:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086d4-c639-78a0-964a-daf5a87fc5df | CIFR | 2026-09-09 11:41 | call_vertical_spread | 2 | 1 | 357 | 130305.00 | long | ask | 17.1900 | 0.0800 | ["21","22"] | ["1.0434","1.0403"] | ["21.25"] | ["EDGO"] | 21.0000 | 22.0000 | 72 | 72 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:41:34Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08691-5880-7172-a256-06d5c25a61b9 | CIFR | 2026-09-09 10:27 | call_vertical_spread | 2 | 1 | 1907 | 162095.00 | unknown | — | 17.9750 | 0.1000 | ["20","21"] | ["1.0694","1.1010"] | [] | ["XCBO"] | 20.0000 | 21.0000 | 9 | 9 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:27:55Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a08288-43c0-7e20-b2eb-93f5af68aae0 | CIFR | 2026-09-08 15:39 | call_vertical_spread | 2 | 1 | 1080 | 133920.00 | unknown | — | 18.6301 | 0.0900 | ["20","21.5"] | ["1.0767","1.0882"] | [] | ["XISX"] | 20.0000 | 21.5000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T19:39:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081ee-e608-7c52-857a-37bfa0bc9dbc | CIFR | 2026-09-08 12:51 | call_vertical_spread | 2 | 1 | 1000 | 180000.00 | unknown | — | 19.4409 | 0.1100 | ["20","21.5"] | ["1.0637","1.0899"] | [] | ["XISX"] | 20.0000 | 21.5000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T16:51:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081a2-ba08-7211-866e-46793b9d7061 | CIFR | 2026-09-08 11:28 | call_vertical_spread | 2 | 1 | 1312 | 192864.00 | unknown | — | 18.9500 | 0.1000 | ["19","19.5"] | ["1.2421","1.2745"] | [] | ["XISX"] | 19.0000 | 19.5000 | 3 | 3 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:28:49Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081a2-2980-79a3-a2dd-b5c4fea6b213 | CIFR | 2026-09-08 11:28 | call_vertical_spread | 2 | 1 | 1500 | 328500.00 | unknown | — | 18.9400 | 0.1200 | ["19","20"] | ["1.0397","1.0657"] | [] | ["XISX"] | 19.0000 | 20.0000 | 10 | 10 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:28:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08182-35d0-7973-93f8-680eceb14d26 | CIFR | 2026-09-08 10:53 | call_vertical_spread | 2 | 1 | 800 | 167200.00 | unknown | — | 18.6900 | 0.1600 | ["18.5","20.5"] | ["1.0547","1.0904"] | [] | ["XISX"] | 18.5000 | 20.5000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:53:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08155-3649-78b0-aa68-578dafe06ab9 | CIFR | 2026-09-08 10:03 | call_vertical_spread | 2 | 1 | 820 | 209920.00 | unknown | — | 18.3765 | 0.2100 | ["18","19"] | ["1.0700","1.0965"] | [] | ["XISX"] | 18.0000 | 19.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:04:12Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08142-c788-7013-9f96-05a2af1a1e70 | CIFR | 2026-09-08 09:43 | call_vertical_spread | 2 | 1 | 640 | 322560.00 | short | bid | 17.8400 | 0.4600 | ["15","16.5"] | ["1.0186","1.0327"] | ["16.1"] | ["XCBO"] | 15.0000 | 16.5000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:43:53Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d9f-cdad-79d0-a32c-48bf02319811 | CIFR | 2026-09-04 14:13 | call_vertical_spread | 2 | 1 | 556 | 123432.00 | short | bid | 17.6700 | 0.1300 | ["17.5","18.5"] | ["0.8822","0.9017"] | ["17.9"] | ["XISX"] | 17.5000 | 18.5000 | 14 | 14 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:13:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d9d-d5c5-7022-ae31-7776afad6022 | CIFR | 2026-09-04 14:10 | call_vertical_spread | 2 | 1 | 1163 | 307032.00 | unknown | — | 17.6701 | 0.1200 | ["17","18"] | ["0.8654","0.8887"] | [] | ["XISX"] | 17.0000 | 18.0000 | 14 | 14 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:11:24Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |