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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0c43d-09cf-7751-b8b6-174d1d88e02e | DRAM | 2026-09-21 09:52 | call_vertical_spread | 2 | 1 | 200 | 188600.00 | short | bid | 61.4400 | 1.2200 | ["58","80"] | ["0.6123","0.6271"] | ["64.55"] | ["XMIO"] | 58.0000 | 80.0000 | 60 | 60 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:52:07Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0c436-4f26-7af2-aeaf-a51dec73228b | DRAM | 2026-09-21 09:44 | put_diagonal_spread | 2 | 1 | 732 | 205692.00 | short | bid | 61.8600 | 0.1100 | ["58","58.5"] | ["0.5979","0.6255"] | [] | ["XMIO"] | 58.0000 | 58.5000 | 11 | 18 | false | true | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T13:45:00Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5c6-0be0-7250-9d90-348df9ab3b95 | DRAM | 2026-09-18 14:27 | call_vertical_spread | 2 | 1 | 2111 | 895064.00 | short | bid | 58.8850 | 0.2600 | ["56","57.5"] | ["2.5062","1.0512"] | ["57.48"] | ["XPHO"] | 56.0000 | 57.5000 | 0 | 0 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:28:02Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5b9-c73f-7082-9be4-e008c40921b3 | DRAM | 2026-09-18 14:14 | call_vertical_spread | 2 | 1 | 100 | 146300.00 | short | bid | 58.7843 | 0.5100 | ["50","75"] | ["0.6025","0.6025"] | ["59.67"] | ["XMIO"] | 50.0000 | 75.0000 | 91 | 91 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:14:36Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4d0-b347-7a13-96f4-04f1ecb51644 | DRAM | 2026-09-18 09:59 | call_diagonal_spread | 2 | 1 | 1000 | 187000.00 | long | bid | 58.3600 | 0.1900 | ["57.5","63.5"] | ["0.6367","0.5724"] | [] | ["XPHO"] | 57.5000 | 63.5000 | 0 | 14 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:59:35Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a08cb8-6758-7c52-bfcb-c7904c8afca0 | DRAM | 2026-09-10 15:08 | call_vertical_spread | 2 | 1 | 1000 | 538000.00 | short | bid | 58.5700 | 0.3300 | ["75","81"] | ["0.6449","0.6562"] | ["75.86"] | ["XPHO"] | 75.0000 | 81.0000 | 99 | 99 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:08:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0871a-e758-7fe2-bc63-a1912b989a17 | DRAM | 2026-09-09 12:57 | straddle | 2 | 1 | 400 | 1785200.00 | short | bid | 61.5550 | 3.0500 | ["85"] | ["0.6563"] | ["40.37","129.63"] | ["XMIO"] | 85.0000 | 85.0000 | 499 | 499 | false | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T16:58:49Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0820b-2480-7c23-830b-4a872704c630 | DRAM | 2026-09-08 13:22 | call_vertical_spread | 2 | 1 | 250 | 497000.00 | short | bid | 61.6700 | 0.7000 | ["47","58"] | ["0.9082","0.7092"] | ["56.78"] | ["XPHO"] | 47.0000 | 58.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:23:01Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0819b-9201-7503-82e9-889937c1a242 | DRAM | 2026-09-08 11:20 | call_backspread | 2 | 1 | 700 | 332050.00 | long | bid | 61.8414 | 0.0700 | ["60","63"] | ["0.6831","0.6832"] | ["60.22","68.00"] | ["XPHO"] | 60.0000 | 63.0000 | 10 | 10 | false | false | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:21:16Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0814c-f500-7cf0-9c87-f471c2cf85c4 | DRAM | 2026-09-08 09:54 | call_diagonal_spread | 2 | 1 | 158 | 198290.00 | short | bid | 61.2099 | 0.9500 | ["60","66"] | ["0.6629","0.6451"] | [] | ["XCBO"] | 60.0000 | 66.0000 | 38 | 101 | false | false | true | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:55:15Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |