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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a0a617-9bfe-7491-b134-7995d6895132 | CRCL | 2026-09-15 13:22 | put_ratio_spread | 2 | 1 | 2175 | 9194450.00 | unknown | — | 88.5750 | 2.6500 | ["60","90"] | ["0.8292","0.8356"] | [] | ["AMXO"] | 60.0000 | 90.0000 | 822 | 822 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:23:28Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a0a60b-e3fe-7191-b6af-2c1dab22fced | CRCL | 2026-09-15 13:09 | put_ratio_spread | 2 | 1 | 1575 | 6633900.00 | unknown | — | 88.2700 | 3.4500 | ["60","90"] | ["0.8253","0.8310"] | [] | ["AMXO"] | 60.0000 | 90.0000 | 822 | 822 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-15T17:10:24Z"} | 2026-09-15 | 2026-09-15 19:28 | 2026-09-15 19:28 |
| 01a08c21-d479-7b32-8315-d8690a26cc92 | CRCL | 2026-09-10 12:23 | other | 4 | 1 | 500 | 322000.00 | unknown | — | 91.0200 | 0.3700 | ["92","96","103","108"] | ["0.8013","0.8202","1.1378","1.3676"] | [] | ["EDGO"] | 92.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T16:24:06Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bfb-2df1-7ca1-b450-34aec4dc9922 | CRCL | 2026-09-10 11:41 | other | 4 | 1 | 500 | 363500.00 | unknown | — | 91.6800 | 0.6500 | ["92","96","103","108"] | ["0.8213","0.8373","1.2356","1.3863"] | [] | ["EDGO"] | 92.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:41:31Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08bde-b0f8-7b72-bdfd-7d87323a3c32 | CRCL | 2026-09-10 11:10 | other | 4 | 1 | 400 | 306400.00 | unknown | — | 91.7750 | 0.6650 | ["92","96","103","108"] | ["0.8511","0.8610","1.2730","1.3786"] | [] | ["EDGO"] | 92.0000 | 108.0000 | 1 | 8 | false | true | true | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:10:35Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08765-a810-7602-9e24-0575b796cd20 | CRCL | 2026-09-09 14:19 | other | 2 | 1 | 3375 | 17280000.00 | unknown | — | 94.2600 | 3.1500 | ["65","100"] | ["0.8298","0.8380"] | [] | ["ARCO"] | 65.0000 | 100.0000 | 828 | 828 | true | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-09T18:20:05Z"} | 2026-09-09 | 2026-09-09 17:15 | 2026-09-09 17:15 |
| 01a0822a-fcd8-7102-88a8-fff4f64bd5f7 | CRCL | 2026-09-08 13:57 | other | 2 | 1 | 1500 | 6732000.00 | unknown | — | 96.4800 | 2.7000 | ["60","100"] | ["0.8301","0.8393"] | [] | ["AMXO"] | 60.0000 | 100.0000 | 829 | 829 | true | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:57:36Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a06d40-5c15-7d70-ac05-d91dedb6a571 | CRCL | 2026-09-04 12:28 | other | 4 | 1 | 400 | 960800.00 | unknown | — | 102.4500 | 1.7100 | ["91","96","103","108"] | ["2.8540","2.5609","0.7412","0.7528"] | [] | ["EDGO"] | 91.0000 | 108.0000 | 0 | 7 | false | false | true | true | false | mlct | 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 |