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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c525-8187-7923-a66e-659471d76fba | META | 2026-09-21 14:06 | call_ladder | 3 | 1 | 60 | 994320.00 | unknown | ask | 742.6750 | 9.2500 | ["680","720","790"] | ["0.4623","0.4563","0.4556"] | ["691.70","734.15","901.70"] | ["XCBO"] | 680.0000 | 790.0000 | 88 | 88 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T18:06:40Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c51a-5626-76d0-9ed4-e78c17220107 | META | 2026-09-21 13:53 | call_ladder | 3 | 1 | 12 | 67452.00 | long | ask | 740.0599 | 1.9500 | ["850","950","990"] | ["0.4578","0.4653","0.4704"] | ["856.21","1083.79"] | ["MCRY"] | 850.0000 | 990.0000 | 88 | 88 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:53:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c4fd-9aae-7331-a934-a0dde0088509 | META | 2026-09-21 13:22 | call_ladder | 3 | 1 | 4 | 75680.00 | unknown | ask | 736.4650 | 3.5000 | ["600","735","800"] | ["0.4839","0.4435","0.4537"] | ["717.68"] | ["XCBO"] | 600.0000 | 800.0000 | 25 | 25 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T17:22:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c460-6c67-7233-b5b9-9949ad19aa50 | META | 2026-09-21 10:30 | call_ladder | 3 | 1 | 20 | 158260.00 | unknown | ask | 711.3500 | 0.6500 | ["660","695","800"] | ["0.4251","0.4165","0.4257"] | ["760.16"] | ["XBOX"] | 660.0000 | 800.0000 | 25 | 25 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:30:48Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b54f-0eef-7c20-9f94-0346ab43a189 | META | 2026-09-18 12:17 | call_ladder | 3 | 1 | 4 | 26856.00 | unknown | — | 671.3600 | 1.6000 | ["665","690","710"] | ["0.3763","0.3774","0.3788"] | [] | ["XCBO"] | 665.0000 | 710.0000 | 28 | 28 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T16:17:49Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b06b-6953-7210-8994-3d8241d6b265 | META | 2026-09-17 13:30 | call_ladder | 3 | 1 | 12 | 60308.00 | unknown | — | 678.0000 | 2.5500 | ["660","680","690"] | ["0.3793","0.3757","0.3773"] | [] | ["XCBO"] | 660.0000 | 690.0000 | 15 | 15 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-17T17:30:45Z"} | 2026-09-17 | 2026-09-17 17:15 | 2026-09-17 17:15 |
| 01a0a597-4486-7343-a7c8-a2f2332d877b | META | 2026-09-15 11:02 | call_ladder | 3 | 1 | 60 | 32160.00 | unknown | — | 668.9691 | 0.2000 | ["670","682.5","702.5"] | ["0.5273","0.5330","0.5682"] | [] | ["XCBO"] | 670.0000 | 702.5000 | 1 | 1 | false | true | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T15:02:33Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08770-b818-7011-b2fa-77ea69bdb355 | META | 2026-09-09 14:31 | call_ladder | 3 | 1 | 10 | 92980.00 | short | ask | 652.9300 | 1.6000 | ["640","655","690"] | ["0.3943","0.3947","0.3980"] | ["716.76"] | ["XMIO"] | 640.0000 | 690.0000 | 37 | 37 | false | false | false | true | false | mlat | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:32:13Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a086b8-5cc8-71d1-b17a-999b14f4dd13 | META | 2026-09-09 11:10 | call_ladder | 3 | 1 | 100 | 1187500.00 | long | ask | 656.7625 | 3.1500 | ["660","755","760"] | ["0.4367","0.4408","0.4416"] | ["664.43","850.57"] | ["XCBO"] | 660.0000 | 760.0000 | 100 | 100 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T15:10:23Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |