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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0b5e2-abff-72c2-946d-0436de2e6140 | LITE | 2026-09-18 14:58 | synthetic | 2 | 1 | 90 | 628650.00 | short | ask | 918.3100 | 2.3000 | ["920"] | ["0.6882"] | ["918.87"] | ["ARCO"] | 920.0000 | 920.0000 | 7 | 7 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T18:59:06Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0a067-d900-78a0-a769-9d4bb9b6dde7 | LITE | 2026-09-14 10:52 | synthetic | 2 | 5 | 19 | 130967.00 | long | bid | 844.4700 | 2.2474 | ["880"] | ["0.8721"] | ["845.15"] | ["EMLD","MCRY","SPHR","XISX","XPHO"] | 880.0000 | 880.0000 | 4 | 4 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:52:50Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a090ce-ab18-7f52-9644-3dd3b094fed4 | LITE | 2026-09-11 10:10 | synthetic | 2 | 5 | 18 | 129870.00 | long | bid | 925.9999 | 0.9326 | ["935"] | ["0.7361"] | ["922.50"] | ["EMLD","SPHR","XISX","XPHO"] | 935.0000 | 935.0000 | 7 | 7 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:11:19Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |
| 01a08678-5df8-7940-a285-111c0cee9c40 | LITE | 2026-09-09 10:00 | synthetic | 2 | 4 | 19 | 123158.00 | unknown | — | 1010.6600 | 1.2421 | ["1045"] | ["0.9658"] | [] | ["MCRY","SPHR","XISX","XPHO"] | 1045.0000 | 1045.0000 | 2 | 2 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T14:00:39Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a081f8-09e0-7091-b963-4188f1baa46c | LITE | 2026-09-08 13:01 | synthetic | 2 | 7 | 24 | 417146.00 | unknown | — | 996.6550 | 3.3125 | ["1105"] | ["0.8342"] | [] | ["ARCO","EMLD","MCRY","SPHR","XISX","XPHO"] | 1105.0000 | 1105.0000 | 17 | 17 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:02:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b6-3268-7fa0-b0ff-2c87478af525 | LITE | 2026-09-08 11:49 | synthetic | 2 | 3 | 31 | 1636800.00 | short | ask | 990.0750 | 16.0000 | ["1200"] | ["0.8234"] | ["1010.79"] | ["ARCO","EMLD","XBOX"] | 1200.0000 | 1200.0000 | 192 | 192 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:50:04Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b5-2cb0-7d80-afc7-b797cbc55701 | LITE | 2026-09-08 11:48 | synthetic | 2 | 1 | 8 | 421544.00 | short | ask | 989.5800 | 2.5000 | ["1200"] | ["0.8216"] | ["1013.29"] | ["ARCO"] | 1200.0000 | 1200.0000 | 192 | 192 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:49:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081b5-24e0-7530-ae9a-2e68c86256e3 | LITE | 2026-09-08 11:48 | synthetic | 2 | 1 | 4 | 210516.00 | short | ask | 989.5800 | 3.9000 | ["1200"] | ["0.8204"] | ["1013.29"] | ["XBOX"] | 1200.0000 | 1200.0000 | 192 | 192 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:49:21Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0816c-a649-7873-a9fe-35b7d8120322 | LITE | 2026-09-08 10:29 | synthetic | 2 | 4 | 11 | 138259.00 | long | bid | 964.6313 | 2.2545 | ["1040"] | ["0.8333"] | ["966.32"] | ["MCRY","XISX","XPHO"] | 1040.0000 | 1040.0000 | 10 | 10 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:29:39Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |