Multi-leg option trades
core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
403,968 rowsCSV — whole table, not this view
Sources in this table
uw_multileg403,968 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c49d-e6af-7973-93df-d00fb106eab2 | CCJ | 2026-09-21 11:37 | call_butterfly_spread | 3 | 3 | 364 | 128310.00 | unknown | ask | 92.0800 | 0.5400 | ["100","120","140"] | ["0.4920","0.5105","0.5539"] | ["101.99","138.01"] | ["BATO","C2OX","EDGO"] | 100.0000 | 140.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:38:18Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0aac5-f243-7983-b87e-88e70f86096f | CCJ | 2026-09-16 11:11 | call_diagonal_spread | 2 | 1 | 10 | 105400.00 | short | ask | 92.6500 | 4.7500 | ["45","50"] | ["0.5945","0.5083"] | [] | ["ARCO"] | 45.0000 | 50.0000 | 492 | 856 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-16T15:11:41Z"} | 2026-09-16 | 2026-09-16 17:15 | 2026-09-16 17:15 |
| 01a08259-3cb1-70a3-804a-0aa823f7c962 | CCJ | 2026-09-08 14:47 | call_vertical_spread | 2 | 5 | 116 | 109148.00 | long | ask | 103.5400 | 0.5400 | ["115","140"] | ["0.5046","0.5146"] | ["119.75"] | ["MCRY","XBOX","XCBO","XISX"] | 115.0000 | 140.0000 | 101 | 101 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:48:00Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d40-aa35-70d2-a3a8-44b9e1d61690 | CCJ | 2026-09-04 12:29 | call_calendar | 2 | 6 | 574 | 220633.00 | short | ask | 100.6600 | 0.2888 | ["110"] | ["0.4504"] | [] | ["ARCO","C2OX","EDGO","XCBO","XPHO"] | 110.0000 | 110.0000 | 14 | 42 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:29:17Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a06d28-6b2d-76c1-a308-87de943b5844 | CCJ | 2026-09-04 12:02 | call_calendar | 2 | 4 | 330 | 123970.00 | short | ask | 100.6400 | 0.3400 | ["110"] | ["0.4459"] | [] | ["AMXO","EMLD","XBOX","XMIO"] | 110.0000 | 110.0000 | 14 | 42 | false | true | true | false | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T16:03:06Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |