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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b0f2-507b-77f2-8ac6-ace45295cd59 | CRCL | 2026-09-17 15:57 | call_vertical_spread | 2 | 1 | 29 | 152076.00 | long | ask | 84.9600 | 2.4000 | ["140","190"] | ["0.8041","0.8023"] | ["146.60"] | ["BATO"] | 140.0000 | 190.0000 | 820 | 820 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T19:57:49Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0abbc-3153-7801-a4f9-995329c69f56 | CRCL | 2026-09-16 15:40 | put_calendar | 2 | 1 | 26 | 112788.00 | long | ask | 79.7100 | 3.3000 | ["100"] | ["0.9061"] | [] | ["XISX"] | 100.0000 | 100.0000 | 16 | 30 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:40:54Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-ca63-76f2-9d6f-d5e62d540109 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 274800.00 | long | ask | 78.6200 | 4.9000 | ["75","125"] | ["0.8318","0.8207"] | ["86.12"] | ["XMIO"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-ca63-76f2-9d6f-d5d634edb344 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 274800.00 | long | ask | 78.6200 | 4.9000 | ["75","125"] | ["0.8315","0.8210"] | ["86.10"] | ["XMIO"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-c67b-7ca1-a128-3da8a8cb9445 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 274600.00 | long | ask | 78.6200 | 4.9500 | ["75","125"] | ["0.8555","0.8009"] | ["87.85"] | ["XISX"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba9-c67b-7ca1-a128-3d91dbf06992 | CRCL | 2026-09-16 15:20 | call_vertical_spread | 2 | 1 | 40 | 278200.00 | long | ask | 78.6200 | 5.9500 | ["75","125"] | ["0.8786","0.8029"] | ["88.57"] | ["XISX"] | 75.0000 | 125.0000 | 821 | 821 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:20:43Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aba5-84a4-7313-a8b1-a762056f372d | CRCL | 2026-09-16 15:15 | call_diagonal_spread | 2 | 1 | 36 | 155304.00 | long | bid | 78.8399 | 6.7500 | ["80","115"] | ["0.8066","0.8469"] | [] | ["BATO"] | 80.0000 | 115.0000 | 274 | 457 | false | true | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T19:16:02Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0ab5f-0d93-73a1-bf3d-9cfaaa8808e3 | CRCL | 2026-09-16 13:58 | synthetic | 2 | 7 | 121 | 166494.00 | long | ask | 81.8957 | 0.3000 | ["80"] | ["0.7399"] | ["82.14"] | ["AMXO","ARCO","EDGO","XCBO","XISX","XMIO","XPHO"] | 80.0000 | 80.0000 | 30 | 30 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T17:59:18Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0aae6-014b-79c3-a1fb-7e2cf009c72d | CRCL | 2026-09-16 11:46 | call_vertical_spread | 2 | 1 | 47 | 105891.00 | long | ask | 81.0368 | 1.2500 | ["190","230"] | ["0.8318","0.8405"] | ["192.75"] | ["EDGO"] | 190.0000 | 230.0000 | 492 | 492 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:47:10Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a63f-f806-7ce3-aefe-2f3f3cf48b92 | CRCL | 2026-09-15 14:06 | call_diagonal_spread | 2 | 1 | 15 | 123750.00 | long | bid | 88.5000 | 4.7000 | ["40","75"] | ["0.8437","0.8426"] | [] | ["XMIO"] | 40.0000 | 75.0000 | 185 | 275 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T18:07:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a172-e449-7471-a993-30e92e91ec7f | CRCL | 2026-09-14 15:44 | put_vertical_spread | 2 | 1 | 4 | 123228.00 | long | ask | 97.3900 | 13.6500 | ["200","300"] | ["1.1174","1.5244"] | ["200.75"] | ["ARCO"] | 200.0000 | 300.0000 | 95 | 95 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T19:44:25Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a126-0c68-7582-93aa-278626c569fd | CRCL | 2026-09-14 14:20 | put_vertical_spread | 2 | 2 | 62 | 137702.00 | long | ask | 95.8800 | 3.1000 | ["92","100"] | ["0.8195","0.8354"] | ["95.39"] | ["ARCO","XCBO"] | 92.0000 | 100.0000 | 46 | 46 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T18:21:00Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a051-a180-7b91-95ea-4581737db645 | CRCL | 2026-09-14 10:28 | put_vertical_spread | 2 | 6 | 179 | 286589.00 | long | ask | 92.7850 | 3.6182 | ["84","93"] | ["0.7795","0.7923"] | ["88.54"] | ["ARCO","EDGO","XPHO"] | 84.0000 | 93.0000 | 46 | 46 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:28:36Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a03d-b7d8-7521-b887-af92a98ef68d | CRCL | 2026-09-14 10:06 | call_vertical_spread | 2 | 1 | 99 | 141471.00 | long | ask | 93.1994 | 5.9000 | ["98","115"] | ["0.8515","0.8744"] | ["102.57"] | ["XPHO"] | 98.0000 | 115.0000 | 46 | 46 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:06:34Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a091f9-e4a8-77f0-941a-c2b3cef1eae5 | CRCL | 2026-09-11 15:37 | call_diagonal_spread | 2 | 1 | 40 | 210240.00 | long | bid | 90.7750 | 2.8500 | ["60","70"] | ["1.8148","0.7617"] | [] | ["XMIO"] | 60.0000 | 70.0000 | 7 | 35 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T19:38:09Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a091b3-5628-79b1-8f5b-33d9ccc628b1 | CRCL | 2026-09-11 14:20 | put_vertical_spread | 2 | 1 | 100 | 201200.00 | long | ask | 91.0300 | 1.0000 | ["98","99"] | ["0.7675","0.7642"] | ["98.30"] | ["BATO"] | 98.0000 | 99.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T18:21:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09180-7aa0-7dc1-889c-d620ea9d88db | CRCL | 2026-09-11 13:25 | put_calendar | 2 | 1 | 500 | 379500.00 | long | bid | 92.8200 | 0.6600 | ["95"] | ["0.9693"] | [] | ["XISX"] | 95.0000 | 95.0000 | 0 | 7 | false | false | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T17:25:20Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a0912e-2099-7050-bdf4-9bd5e19ce770 | CRCL | 2026-09-11 11:55 | call_vertical_spread | 2 | 1 | 27 | 207468.00 | long | ask | 92.3450 | 8.3500 | ["55","56"] | ["19.5371","19.0637"] | ["55.98"] | ["EDGO"] | 55.0000 | 56.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T15:55:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08199-05a9-7b83-922e-6133ee653f38 | CRCL | 2026-09-08 11:18 | put_vertical_spread | 2 | 2 | 186 | 1534500.00 | long | ask | 97.9900 | 4.6000 | ["130","145"] | ["0.8296","0.8797"] | ["131.20"] | ["ARCO","XISX"] | 130.0000 | 145.0000 | 45 | 45 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:18:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08191-aec0-7e41-864e-12dfdf21cbdc | CRCL | 2026-09-08 11:10 | put_vertical_spread | 2 | 1 | 120 | 247680.00 | long | ask | 98.2000 | 1.8000 | ["92","102"] | ["0.7920","0.8185"] | ["96.36"] | ["ARCO"] | 92.0000 | 102.0000 | 45 | 45 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:10:17Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08177-3d39-7b52-a597-b06a15b4e502 | CRCL | 2026-09-08 10:41 | put_vertical_spread | 2 | 2 | 42 | 361410.00 | long | ask | 98.5150 | 4.9000 | ["130","150"] | ["0.8127","0.8776"] | ["131.48"] | ["ARCO","XMIO"] | 130.0000 | 150.0000 | 45 | 45 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:41:10Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0813a-76a0-7c73-832a-0912516f3355 | CRCL | 2026-09-08 09:34 | put_vertical_spread | 2 | 2 | 78 | 133458.00 | long | ask | 99.3150 | 4.8500 | ["88","100"] | ["0.8022","0.8209"] | ["94.12"] | ["ARCO","XISX"] | 88.0000 | 100.0000 | 45 | 45 | true | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:34:55Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06dcf-22dd-7d01-8c69-160d2c4cb804 | CRCL | 2026-09-04 15:04 | call_vertical_spread | 2 | 1 | 80 | 471200.00 | long | ask | 101.8050 | 2.7000 | ["65","80"] | ["1.3240","0.7186"] | ["79.62"] | ["XISX"] | 65.0000 | 80.0000 | 14 | 14 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T19:04:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06dc7-79ed-7213-9b3e-2ca2d1c75429 | CRCL | 2026-09-04 14:56 | call_diagonal_spread_bearish | 2 | 2 | 43 | 218164.00 | long | ask | 101.0853 | 2.5000 | ["100","200"] | ["0.8091","0.8353"] | [] | ["AMXO","XMIO"] | 100.0000 | 200.0000 | 105 | 833 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:56:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d77-d736-7621-9838-ff2a8f3784df | CRCL | 2026-09-04 13:29 | strangle | 2 | 2 | 38 | 200184.00 | long | ask | 101.5550 | 1.5500 | ["65","200"] | ["0.8303","0.8462"] | ["12.32","252.68"] | ["XISX","XPHO"] | 65.0000 | 200.0000 | 833 | 833 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:29:48Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d76-641d-7c00-b847-ecb1852c4d18 | CRCL | 2026-09-04 13:27 | strangle | 2 | 1 | 20 | 105500.00 | long | ask | 101.8450 | 1.8500 | ["65","200"] | ["0.8361","0.8419"] | ["12.25","252.75"] | ["MCRY"] | 65.0000 | 200.0000 | 833 | 833 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:28:15Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d75-048d-7da3-932d-e407fbfde148 | CRCL | 2026-09-04 13:26 | strangle | 2 | 1 | 20 | 105400.00 | long | ask | 101.7000 | 1.8500 | ["65","200"] | ["0.8321","0.8444"] | ["12.30","252.70"] | ["XISX"] | 65.0000 | 200.0000 | 833 | 833 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:26:45Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d72-e595-7553-9f8e-86d6dae05a14 | CRCL | 2026-09-04 13:23 | strangle | 2 | 2 | 30 | 157700.00 | long | ask | 101.7000 | 2.1000 | ["65","200"] | ["0.8351","0.8405"] | ["12.43","252.57"] | ["ARCO","XMIO"] | 65.0000 | 200.0000 | 833 | 833 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:24:30Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4b-29b6-7090-9cde-64374b0b1bc1 | CRCL | 2026-09-04 12:40 | call_vertical_spread | 2 | 1 | 40 | 146920.00 | long | ask | 102.5100 | 2.9500 | ["95","170"] | ["0.8004","0.8196"] | ["113.55"] | ["ARCO"] | 95.0000 | 170.0000 | 196 | 196 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d4b-25cd-77d1-9be5-eb338fa796c0 | CRCL | 2026-09-04 12:40 | call_vertical_spread | 2 | 1 | 40 | 146920.00 | long | ask | 102.5100 | 2.9500 | ["95","170"] | ["0.7960","0.8241"] | ["113.31"] | ["ARCO"] | 95.0000 | 170.0000 | 196 | 196 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:41:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |