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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08180-45b8-7fd2-ad80-0243993f1ed3 | SMTC | 2026-09-08 10:50 | call_vertical_spread | 2 | 1 | 50 | 119000.00 | unknown | — | 159.9800 | 2.5000 | ["150","160"] | ["0.8470","0.8603"] | [] | ["XISX"] | 150.0000 | 160.0000 | 10 | 10 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T14:51:05Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08189-c750-73b0-a862-35309ade9707 | SMTC | 2026-09-08 11:01 | call_butterfly_spread | 3 | 1 | 40 | 144600.00 | short | bid | 161.4300 | 6.6000 | ["130","150","165"] | ["0.7849","0.8820","0.9272"] | ["138.30","161.70"] | ["XCBO"] | 130.0000 | 165.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:01:51Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081a0-5c90-7cc1-bb8f-3dd8395879ab | SMTC | 2026-09-08 11:26 | call_ladder | 3 | 5 | 58 | 340944.00 | short | bid | 160.5000 | 7.4000 | ["160","200","220"] | ["0.8532","0.8668","0.8583"] | ["160.1","259.90"] | ["ARCO","EMLD","SPHR","XBOX","XPHO"] | 160.0000 | 220.0000 | 101 | 101 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:26:18Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a081a2-6be8-70b2-a130-24bfd3bfdac1 | SMTC | 2026-09-08 11:28 | call_ladder | 3 | 4 | 18 | 106072.00 | short | bid | 160.5850 | 6.5000 | ["160","200","220"] | ["0.8539","0.8700","0.8552"] | ["160.10","259.90"] | ["EDGO","EMLD","SPHR","XBOX"] | 160.0000 | 220.0000 | 101 | 101 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T15:28:49Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a0821d-4908-7ed0-b15a-c013b4f6d228 | SMTC | 2026-09-08 13:42 | put_vertical_spread | 2 | 1 | 200 | 527472.00 | short | bid | 162.3000 | 3.8000 | ["110","140"] | ["0.8429","0.8278"] | ["129.20"] | ["XCBO"] | 110.0000 | 140.0000 | 129 | 129 | true | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T17:43:08Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08258-a841-7cb3-b132-76e33250d086 | SMTC | 2026-09-08 14:47 | other | 2 | 1 | 1220 | 7617400.00 | unknown | — | 165.0000 | 4.7000 | ["115","145"] | ["1.3509","0.7988"] | [] | ["XCBO"] | 115.0000 | 145.0000 | 10 | 10 | false | false | false | true | false | mlct | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T18:47:38Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08be7-d0e8-70b0-b023-d0abc5311ad4 | SMTC | 2026-09-10 11:20 | other | 3 | 1 | 100 | 173150.00 | unknown | — | 159.3400 | 4.0000 | ["140","160","170"] | ["0.8044","0.7579","0.7896"] | [] | ["EDGO"] | 140.0000 | 170.0000 | 8 | 8 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:20:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c04-49f8-77a1-9315-975e8c78c7db | SMTC | 2026-09-10 11:51 | straddle | 2 | 2 | 7 | 110747.00 | long | ask | 160.1450 | 4.8714 | ["250"] | ["0.8341"] | ["91.79","408.21"] | ["ARCO","EDGO"] | 250.0000 | 250.0000 | 498 | 498 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:51:34Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c05-0578-7142-adb3-15ea017868a1 | SMTC | 2026-09-10 11:52 | straddle | 2 | 1 | 477 | 7560450.00 | long | ask | 160.1450 | 3.9000 | ["250"] | ["0.8361"] | ["91.50","408.50"] | ["EDGO"] | 250.0000 | 250.0000 | 498 | 498 | true | false | false | false | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T15:52:19Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a0a040-b961-7683-8a28-56d04b9f1762 | SMTC | 2026-09-14 10:09 | call_ladder | 3 | 1 | 100 | 214699.00 | short | bid | 154.6100 | 5.9000 | ["165","185","195"] | ["0.8427","0.8354","0.8451"] | ["166.35","213.65"] | ["EDGO"] | 165.0000 | 195.0000 | 32 | 32 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T14:10:01Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a06e-e998-7dd3-8edb-43f1051fffe2 | SMTC | 2026-09-14 11:00 | put_vertical_spread | 2 | 1 | 100 | 295600.00 | short | bid | 150.1700 | 3.7000 | ["110","140"] | ["0.8058","0.8079"] | ["127.38"] | ["EDGO"] | 110.0000 | 140.0000 | 123 | 123 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T15:00:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0a0f0-f690-7e92-a898-ee60429cf7d9 | SMTC | 2026-09-14 13:22 | put_vertical_spread | 2 | 1 | 200 | 610802.00 | short | bid | 150.4900 | 2.0000 | ["110","140"] | ["0.8303","0.8264"] | ["127.40"] | ["XCBO"] | 110.0000 | 140.0000 | 123 | 123 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-14T17:22:19Z"} | 2026-09-14 | 2026-09-14 17:15 | 2026-09-14 17:15 |
| 01a0b4c0-ec38-7f02-8a67-681fb8f83794 | SMTC | 2026-09-18 09:42 | call_vertical_spread | 2 | 1 | 100 | 164400.00 | long | ask | 182.6800 | 4.1000 | ["170","180"] | ["2.4639","1.2332"] | ["178.50"] | ["XMIO"] | 170.0000 | 180.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T13:42:30Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b4db-e677-7302-b028-f238252ded0b | SMTC | 2026-09-18 10:11 | call_vertical_spread | 2 | 1 | 100 | 145900.00 | short | bid | 181.0400 | 1.5500 | ["170","180"] | ["1.9787","1.3612"] | ["178.43"] | ["EDGO"] | 170.0000 | 180.0000 | 0 | 0 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T14:11:45Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5ab-e877-7423-987f-51067aaad409 | SMTC | 2026-09-18 13:58 | straddle | 2 | 2 | 67 | 645880.00 | long | ask | 182.8100 | 4.0761 | ["220"] | ["0.8419"] | ["123.6","316.40"] | ["ARCO","XISX"] | 220.0000 | 220.0000 | 182 | 182 | true | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T17:59:10Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b5fd-d520-7451-9c3a-5affb3bed3a5 | SMTC | 2026-09-18 15:28 | call_diagonal_spread | 2 | 1 | 12 | 156072.00 | short | ask | 181.8600 | 5.5000 | ["105","130"] | ["44.6773","0.8355"] | [] | ["XMIO"] | 105.0000 | 130.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:28:25Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b604-93af-7823-a77a-7ebc44de8afe | SMTC | 2026-09-18 15:35 | call_diagonal_spread | 2 | 1 | 12 | 157392.00 | short | ask | 182.7250 | 6.3000 | ["105","130"] | ["49.6947","0.7947"] | [] | ["XMIO"] | 105.0000 | 130.0000 | 0 | 28 | false | false | true | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:36:07Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0c4a6-cc07-7a62-b563-e37cf1bd9d8c | SMTC | 2026-09-21 11:47 | call_vertical_spread | 2 | 1 | 7 | 105560.00 | short | bid | 178.0800 | 3.0000 | ["100","110"] | ["0.9057","0.8970"] | ["109"] | ["XISX"] | 100.0000 | 110.0000 | 60 | 60 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T15:47:45Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |