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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c4d4-217e-7d23-b9d3-2719ff3398f7 | ETHA | 2026-09-21 12:37 | synthetic | 2 | 1 | 100 | 157600.00 | long | ask | 20.8176 | 0.5000 | ["23"] | ["0.6507"] | ["23.08"] | ["XCBO"] | 23.0000 | 23.0000 | 851 | 851 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:37:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4d4-1d97-7fe0-a848-723ae8c42cf6 | ETHA | 2026-09-21 12:37 | straddle | 2 | 3 | 200 | 314720.00 | long | ask | 20.8176 | 0.5000 | ["23"] | ["0.6496"] | ["7.26","38.74"] | ["XBOX"] | 23.0000 | 23.0000 | 851 | 851 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T16:37:24Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c49f-2ae6-7331-86b0-fbba8afeaa7a | ETHA | 2026-09-21 11:39 | call_vertical_spread | 2 | 1 | 600 | 100800.00 | long | ask | 20.6651 | 0.0900 | ["23","26"] | ["0.5776","0.6060"] | ["23.56"] | ["XPHO"] | 23.0000 | 26.0000 | 60 | 60 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:39:20Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c46b-93df-76f1-b953-5e69565e5af5 | ETHA | 2026-09-21 10:42 | call_vertical_spread | 2 | 1 | 500 | 701000.00 | long | ask | 20.6300 | 0.4000 | ["13","19"] | ["0.6464","0.5838"] | ["16.86"] | ["EDGO"] | 13.0000 | 19.0000 | 269 | 269 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:43:01Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c42f-d6e7-7580-8c2f-7dd39aedf2bd | ETHA | 2026-09-21 09:37 | call_vertical_spread | 2 | 1 | 300 | 176100.00 | long | ask | 20.5650 | 0.5000 | ["20","24"] | ["0.5741","0.5619"] | ["21.55"] | ["SPHR"] | 20.0000 | 24.0000 | 179 | 179 | false | false | false | true | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:37:45Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5d9-5948-7631-9dec-6f998a3b9a8c | ETHA | 2026-09-18 14:48 | call_diagonal_spread | 2 | 1 | 111 | 315271.00 | long | ask | 19.7204 | 0.2000 | ["1","10"] | ["2.2487","27.7987"] | [] | ["XCBO"] | 1.0000 | 10.0000 | 0 | 119 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:48:34Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b550-2447-7d82-ab19-b23f2ccca245 | ETHA | 2026-09-18 12:18 | synthetic | 2 | 1 | 20000 | 10160000.00 | long | ask | 19.6350 | 0.2100 | ["16"] | ["0.5686"] | ["19.80"] | ["AMXO"] | 16.0000 | 16.0000 | 91 | 91 | true | false | false | false | true | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:19:12Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0afd4-de43-7f72-909d-2516f14e3fc5 | ETHA | 2026-09-17 10:45 | synthetic | 2 | 1 | 279 | 126666.00 | long | bid | 18.6100 | 0.1400 | ["19"] | ["0.5334"] | ["18.92"] | ["SPHR"] | 19.0000 | 19.0000 | 120 | 120 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T14:46:09Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0aac9-036b-7d91-b9f1-d30d1b0e7912 | ETHA | 2026-09-16 11:14 | call_vertical_spread | 2 | 1 | 1290 | 129000.00 | long | ask | 18.0400 | 0.0400 | ["30","35"] | ["0.6032","0.6329"] | ["30.24"] | ["BATO"] | 30.0000 | 35.0000 | 184 | 184 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:15:26Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a0a565-99ae-7890-b405-5d14c21246b0 | ETHA | 2026-09-15 10:08 | call_vertical_spread | 2 | 6 | 2404 | 234784.00 | long | ask | 18.4250 | 0.1400 | ["40","50"] | ["0.6454","0.6737"] | ["40.28"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 40.0000 | 50.0000 | 275 | 275 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T14:08:12Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a09166-2089-78a0-9081-3863cdaf514c | ETHA | 2026-09-11 12:56 | call_diagonal_spread | 2 | 1 | 186 | 139314.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.3027","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:56:34Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09164-4bc9-7220-a5f1-5b367dbee96f | ETHA | 2026-09-11 12:54 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2574","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:55:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09164-3c28-7ef3-b192-55277543def6 | ETHA | 2026-09-11 12:54 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2563","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:55:02Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09164-1131-7771-8a18-8477a34f541d | ETHA | 2026-09-11 12:54 | call_diagonal_spread | 2 | 1 | 400 | 299600.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2518","0.6063"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:54:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09163-af88-7830-a951-43acb7d08d39 | ETHA | 2026-09-11 12:53 | call_diagonal_spread | 2 | 2 | 290 | 217210.00 | long | bid | 19.4736 | 0.3000 | ["15.5","16"] | ["8.0553","0.5808"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:54:13Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09163-51c8-7930-8c7b-a68f85b67f3b | ETHA | 2026-09-11 12:53 | call_diagonal_spread | 2 | 4 | 165 | 123129.00 | long | bid | 19.4650 | 0.3000 | ["15.5","16"] | ["8.2341","0.6414"] | [] | ["MCRY","XBOX"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:53:25Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09161-cf11-7091-a1d0-e637aeb7b732 | ETHA | 2026-09-11 12:51 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4799 | 0.3000 | ["15.5","16"] | ["7.8666","0.5594"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09161-9860-75c1-87c3-1eb47d721e1c | ETHA | 2026-09-11 12:51 | call_diagonal_spread | 2 | 2 | 410 | 307090.00 | long | bid | 19.4706 | 0.3000 | ["15.5","16"] | ["8.0723","0.5901"] | [] | ["MCRY"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a09161-5dc8-7f00-b086-0339f66e4cbe | ETHA | 2026-09-11 12:51 | call_diagonal_spread | 2 | 4 | 196 | 146348.00 | long | bid | 19.4800 | 0.3000 | ["15.5","16"] | ["7.8541","0.5929"] | [] | ["MCRY","XBOX"] | 15.5000 | 16.0000 | 0 | 14 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T16:51:50Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a090fa-7dd8-74d3-8066-c7b8e34cbba9 | ETHA | 2026-09-11 10:58 | call_diagonal_spread | 2 | 1 | 1000 | 352000.00 | long | bid | 19.6900 | 0.1300 | ["18","19"] | ["0.5580","0.5514"] | [] | ["XCBO"] | 18.0000 | 19.0000 | 7 | 35 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:59:16Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08bd5-0850-7c60-a2e3-c04ba4aca2dc | ETHA | 2026-09-10 10:59 | call_vertical_spread | 2 | 1 | 2000 | 136000.00 | long | ask | 18.4300 | 0.0800 | ["28","38"] | ["0.6042","0.6877"] | ["28.34"] | ["XMIO"] | 28.0000 | 38.0000 | 127 | 127 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:00:02Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a06db5-b70d-72e3-be71-421dcad820cc | ETHA | 2026-09-04 14:36 | call_vertical_spread | 2 | 1 | 1825 | 246375.00 | long | ask | 18.4800 | 0.0400 | ["22","30"] | ["0.5551","0.6150"] | ["22.83"] | ["EDGO"] | 22.0000 | 30.0000 | 105 | 105 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:37:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db5-b70d-72e3-be71-4206c804518a | ETHA | 2026-09-04 14:36 | call_vertical_spread | 2 | 1 | 1442 | 194670.00 | long | ask | 18.4800 | 0.0400 | ["22","30"] | ["0.5551","0.6150"] | ["22.83"] | ["AMXO"] | 22.0000 | 30.0000 | 105 | 105 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:37:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06db5-b70d-72e3-be71-41dfa8d17e13 | ETHA | 2026-09-04 14:36 | call_vertical_spread | 2 | 4 | 1620 | 218700.00 | long | ask | 18.4800 | 0.0491 | ["22","30"] | ["0.5551","0.6150"] | ["22.83"] | ["EMLD","SPHR","XBOX","XPHO"] | 22.0000 | 30.0000 | 105 | 105 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T18:37:23Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |