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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 01a08144-f238-7ba2-9d78-d08e0930a0f6 | ORCL | 2026-09-08 09:46 | jade_lizard | 3 | 6 | 62 | 96062.00 | long | bid | 166.3100 | 0.6200 | ["152.5","165","190"] | ["1.5457","1.6069","1.6924"] | ["156.77","198.23"] | ["AMXO","EMLD","XBOX","XMIO","XPHO"] | 152.5000 | 190.0000 | 3 | 3 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:46:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08144-fa08-7002-957d-d762b7917eb5 | ORCL | 2026-09-08 09:46 | jade_lizard | 3 | 12 | 90 | 139230.00 | long | bid | 166.3100 | 0.6000 | ["152.5","165","190"] | ["1.5442","1.6032","1.6935"] | ["156.78","198.22"] | ["AMXO","ARCO","BATO","C2OX","EDGO","XBOX","XCBO","XISX","XMIO"] | 152.5000 | 190.0000 | 3 | 3 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-08T13:46:19Z"} | 2026-09-08 | 2026-09-08 21:50 | 2026-09-08 21:50 |
| 01a08c67-d270-75a3-aeb0-eef92f16e1f3 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 8 | 150 | 330854.00 | short | bid | 156.0000 | 0.5583 | ["140","160","190"] | ["0.6735","0.6862","0.7247"] | ["126.51","173.49"] | ["AMXO","ARCO","MCRY","XBOX","XMIO","XPHO"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:07Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c67-edc8-7211-bb6a-a6ef45d7ebdc | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 1 | 22 | 48642.00 | short | bid | 155.9200 | 0.5500 | ["140","160","190"] | ["0.6703","0.6891","0.7304"] | ["126.59","173.41"] | ["XBOX"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2db0613cb803 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 17 | 37443.00 | short | bid | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6749","0.6869","0.7245"] | ["126.47","173.53"] | ["ARCO","XPHO"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2da814be780f | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 32 | 70368.00 | unknown | — | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6746","0.6860","0.7236"] | [] | ["ARCO","XPHO"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2d933038b453 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 32 | 70368.00 | unknown | — | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6746","0.6860","0.7236"] | [] | ["ARCO","XPHO"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2d87dd41bb92 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 1 | 16 | 35280.00 | short | bid | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6724","0.6876","0.7280"] | ["126.55","173.45"] | ["XBOX"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2d75dcebe727 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 32 | 70368.00 | unknown | — | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6746","0.6860","0.7236"] | [] | ["ARCO","XPHO"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2d5ba40383d3 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 32 | 70528.00 | short | bid | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6737","0.6873","0.7263"] | ["126.51","173.49"] | ["ARCO","XBOX"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2d011d1824e0 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 27 | 59139.00 | short | bid | 155.9000 | 0.5500 | ["140","160","190"] | ["0.6724","0.6832","0.7232"] | ["126.56","173.44"] | ["AMXO","MCRY"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2caa2d3ed34f | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 1 | 16 | 34864.00 | short | bid | 155.9000 | 0.5500 | ["140","160","190"] | ["0.6687","0.6799","0.7234"] | ["126.69","173.31"] | ["AMXO"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-2090-78e3-93cb-2dc74cf2d4be | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 2 | 33 | 72635.00 | short | bid | 155.8600 | 0.5000 | ["140","160","190"] | ["0.6751","0.6873","0.7238"] | ["126.45","173.55"] | ["ARCO","XISX"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c68-4f70-7162-9f04-3fbecd394333 | ORCL | 2026-09-10 13:40 | jade_lizard | 3 | 1 | 54 | 118638.00 | short | bid | 155.8800 | 0.5000 | ["140","160","190"] | ["0.6746","0.6850","0.7230"] | ["126.49","173.51"] | ["XISX"] | 140.0000 | 190.0000 | 36 | 36 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T17:40:44Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c91-5b40-7341-9396-d798909d6130 | ORCL | 2026-09-10 14:25 | jade_lizard | 3 | 3 | 85 | 104527.00 | long | bid | 155.4600 | 0.1600 | ["140","150","175"] | ["2.5937","2.7735","3.0135"] | ["142.75","182.25"] | ["AMXO","ARCO","XBOX"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:26:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08c91-7e68-75e2-b36e-ecfab50de018 | ORCL | 2026-09-10 14:25 | jade_lizard | 3 | 1 | 368 | 451536.00 | long | bid | 155.4500 | 0.1600 | ["140","150","175"] | ["2.5868","2.7668","3.0158"] | ["142.75","182.25"] | ["XISX"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T18:26:01Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd4-6b38-7753-875d-ef3c80f479ed | ORCL | 2026-09-10 15:38 | jade_lizard | 3 | 3 | 36 | 47924.00 | long | bid | 153.7250 | 0.2200 | ["140","150","175"] | ["2.6512","2.8514","3.0157"] | ["142.75","182.25"] | ["SPHR","XBOX","XMIO"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:38:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd4-6b38-7753-875d-ef276d34315b | ORCL | 2026-09-10 15:38 | jade_lizard | 3 | 4 | 46 | 61245.00 | long | bid | 153.7250 | 0.2200 | ["140","150","175"] | ["2.6507","2.8510","3.0175"] | ["142.75","182.25"] | ["AMXO","ARCO","XCBO","XPHO"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:38:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd4-6b38-7753-875d-ef1a0d532702 | ORCL | 2026-09-10 15:38 | jade_lizard | 3 | 2 | 33 | 43989.00 | long | bid | 153.7250 | 0.2200 | ["140","150","175"] | ["2.6548","2.8528","3.0175"] | ["142.75","182.25"] | ["EMLD","XMIO"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:38:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd4-7ec0-77f3-88c1-9ce0f36500f6 | ORCL | 2026-09-10 15:38 | jade_lizard | 3 | 2 | 34 | 45322.00 | long | bid | 153.7468 | 0.2200 | ["140","150","175"] | ["2.6569","2.8557","3.0155"] | ["142.75","182.25"] | ["EMLD","SPHR"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:38:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd4-7ec0-77f3-88c1-9cf1cb7de140 | ORCL | 2026-09-10 15:38 | jade_lizard | 3 | 2 | 28 | 37246.00 | long | bid | 153.7468 | 0.2200 | ["140","150","175"] | ["2.6511","2.8512","3.0155"] | ["142.75","182.25"] | ["MCRY","XCBO"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:38:58Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a08cd4-d4b0-75b2-a52a-de68dd078d5c | ORCL | 2026-09-10 15:39 | jade_lizard | 3 | 2 | 33 | 43889.00 | long | bid | 153.8100 | 0.2152 | ["140","150","175"] | ["2.6566","2.8590","3.0095"] | ["142.75","182.25"] | ["ARCO","EDGO"] | 140.0000 | 175.0000 | 1 | 1 | false | true | false | true | true | mlet | tracked | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-10T19:39:25Z"} | 2026-09-10 | 2026-09-10 17:15 | 2026-09-10 17:15 |
| 01a090e3-1990-74e2-a220-f7207320d9cc | ORCL | 2026-09-11 10:33 | jade_lizard | 3 | 2 | 47 | 117940.00 | short | bid | 153.0950 | 1.1000 | ["160","170"] | ["0.5230","0.5279"] | ["143.50"] | ["ARCO","MCRY"] | 160.0000 | 170.0000 | 35 | 35 | false | false | false | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-11T14:33:22Z"} | 2026-09-11 | 2026-09-11 17:15 | 2026-09-11 17:15 |