core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg403,968 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 |
|---|
| 01a0b5ef-bfa7-7d43-bd3f-42ad39bf51e0 | AAOI | 2026-09-18 15:13 | other | 4 | 3 | 44 | 232424.00 | unknown | — | 105.1200 | 4.9000 | ["120","130","160"] | ["1.0033","1.0362","16.3482"] | [] | ["XISX"] | 120.0000 | 160.0000 | 0 | 63 | false | false | true | true | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-18T19:13:26Z"} | 2026-09-18 | 2026-09-18 17:15 | 2026-09-18 17:15 |
| 01a0b55e-5130-76b2-ae75-63cf68fc182c | AAOI | 2026-09-18 12:34 | other | 4 | 2 | 20 | 121680.00 | unknown | bid | 100.4600 | 7.1000 | ["108","110","120"] | ["0.8471","1.9845","3.9939"] | [] | ["SPHR","XCBO"] | 108.0000 | 120.0000 | 0 | 14 | false | false | true | true | |||||||||
| 01a0b542-2257-7cc1-bd8b-bba22c730c1c | AAOI | 2026-09-18 12:03 | other | 4 | 7 | 27 | 129922.00 | unknown | ask | 101.1800 | 3.0500 | ["90","150","200"] | ["0.9353","0.9629","0.9868"] | [] | ["ARCO","EMLD","MCRY","SPHR","XISX","XMIO","XPHO"] | 90.0000 | 200.0000 | 91 | 182 | false | true | true | true | |||||||||
| 01a0b542-2257-7cc1-bd8b-bb9af9c81be7 | AAOI | 2026-09-18 12:03 | other | 4 | 9 | 38 | 182946.00 | unknown | ask | 101.1800 | 3.0500 | ["90","150","200"] | ["0.9338","0.9646","0.9903"] | [] | ["AMXO","ARCO","EMLD","MCRY","SPHR","XBOX","XISX","XMIO","XPHO"] | 90.0000 | 200.0000 | 91 | 182 | false | true | true | ||||||||||
| 01a0a02a-62a1-7d51-90be-0da4688ef3e3 | AAOI | 2026-09-14 09:45 | other | 2 | 1 | 40 | 265880.00 | unknown | — | 98.4100 | 6.1000 | ["125","130"] | ["1.0081","1.3081"] | [] | ["XISX"] | 125.0000 | 130.0000 | 11 | 95 | false | false | true | true | false | mlet | |||||||
| 01a091ed-8898-7f43-8d44-60f820e8f754 | AAOI | 2026-09-11 15:24 | other | 3 | 1 | 20 | 133300.00 | unknown | — | 105.2900 | 3.2000 | ["55","125","135"] | ["0.9289","0.9274","0.9565"] | [] | ["XISX"] | 55.0000 | 135.0000 | 7 | 126 | false | false | true | true | false | mlet | |||||||
| 01a09116-df79-7e91-a475-f92acd398814 | AAOI | 2026-09-11 11:29 | other | 2 | 1 | 15 | 192825.00 | unknown | — | 105.8750 | 5.9000 | ["42","70"] | ["3.5062","0.9882"] | [] | ["BATO"] | 42.0000 | 70.0000 | 7 | 644 | false | false | true | true | false | mlet | |||||||
| 01a08c83-e9d9-78b0-8378-3e87f1d49edc | AAOI | 2026-09-10 14:10 | other | 2 | 1 | 10 | 117800.00 | unknown | — | 103.4100 | 5.4000 | ["45","50"] | ["3.4185","1.0410"] | [] | ["MCRY"] | 45.0000 | 50.0000 | 8 | 190 | false | false | true | true | false | mlet | |||||||
| 01a087b1-2061-7fc3-8259-f640003aeb76 | AAOI | 2026-09-09 15:42 | other | 2 | 2 | 10 | 108400.00 | unknown | — | 108.4350 | 4.2000 | ["55","70"] | ["2.6776","1.0071"] | [] | ["XPHO"] | 55.0000 | 70.0000 | 9 | 281 | false | false | true | true | false | mlet | |||||||
| 01a086f7-3e71-7db3-98ff-a21fc6bb5fdf | AAOI | 2026-09-09 12:19 | other | 2 | 1 | 18 | 144450.00 | unknown | — | 110.9200 | 6.7000 | ["120","135"] | ["1.0053","0.9907"] | [] | ["ARCO"] | 120.0000 | 135.0000 | 191 | 646 | false | true | true | true | false | mlet | |||||||
| 01a081dd-ee48-7c00-8849-a2cfc3ccbcd7 | AAOI | 2026-09-08 12:33 | other | 4 | 1 | 64 | 120812.00 | unknown | — | 113.9083 | 2.4000 | ["109","110","115","116"] | ["1.1045","1.0778","1.1067","1.1156"] | [] | ["XMIO"] | 109.0000 | 116.0000 | 3 | 3 | false | false | false | true | false | mlet | |||||||
| 01a08163-ad68-7000-99b8-6eaf9417e9b9 | AAOI | 2026-09-08 10:19 | other | 4 | 4 | 300 | 357164.00 | unknown | — | 113.7900 | 3.0500 | ["85","105","120"] | ["1.0960","1.0039","1.0373"] | [] | ["C2OX","XMIO"] | 85.0000 | 120.0000 | 10 | 101 | false | false | true | true | false | mlet |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:34:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:03:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:03:25Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T13:45:28Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:24:17Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:30:16Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T18:11:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:42:18Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:19:37Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T16:33:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:19:52Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |