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 |
|---|
| 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 |
|---|
| 01a0c9dd-aa96-7050-a30a-88c0e6845148 | SNPS | 2026-09-22 12:05 | straddle | 2 | 1 | 7 | 115535.00 | unknown | — | 409.9700 | 12.1000 | ["380"] | ["0.4577"] | [] | ["EMLD"] | 380.0000 | 380.0000 | 486 | 486 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T16:06:21Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0af91-8413-7ed2-a501-224932c1b6bc | SNPS | 2026-09-17 09:32 | straddle | 2 | 1 | 10 | 159850.00 | unknown | — | 385.3000 | 17.8000 | ["380"] | ["0.4667"] | [] | ["XISX"] | 380.0000 | 380.0000 | 491 | 491 | false | false | false | false | true | ||||||||
| 01a0abb7-0903-7d11-9c86-54b8850922f3 | SNPS | 2026-09-16 15:34 | put_diagonal_spread | 2 | 1 | 60 | 146700.00 | long | ask | 376.3900 | 5.3000 | ["370","380"] | ["0.4541","0.6054"] | [] | ["XMIO"] | 370.0000 | 380.0000 | 2 | 30 | false | false | |||||||||||
| 01a0aac1-0873-74d2-b566-b2c7edbf1f85 | SNPS | 2026-09-16 11:06 | other | 4 | 1 | 8 | 104904.00 | unknown | — | 377.1700 | 13.2000 | ["370","375","425","430"] | ["0.4535","0.4549","1.0324","1.1899"] | [] | ["XISX"] | 370.0000 | 430.0000 | 2 | 23 | false | false | true | true | |||||||||
| 01a0a606-b7c6-7063-aa3f-b74a1480cb81 | SNPS | 2026-09-15 13:04 | call_vertical_spread | 2 | 1 | 10 | 269810.00 | short | bid | 367.9050 | 12.6000 | ["250","260"] | ["0.5224","0.5147"] | ["257.75"] | ["XMIO"] | 250.0000 | 260.0000 | 275 | 275 | true | false | |||||||||||
| 01a0a569-144e-7113-ad8f-7afa28329040 | SNPS | 2026-09-15 10:11 | put_vertical_spread | 2 | 1 | 200 | 1142000.00 | unknown | — | 371.4699 | 6.6000 | ["300","400"] | ["0.4783","0.4646"] | [] | ["XISX"] | 300.0000 | 400.0000 | 94 | 94 | false | false | false | true | |||||||||
| 01a0a563-672e-79e1-a692-b84bd2f85d3d | SNPS | 2026-09-15 10:05 | iron_butterfly | 4 | 1 | 6 | 176256.00 | unknown | — | 372.5400 | 18.3000 | ["360","380","400"] | ["0.4587","0.4676","0.4667"] | [] | ["XCBO"] | 360.0000 | 400.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a546-9446-7a01-8fba-df6284ec3bdc | SNPS | 2026-09-15 09:34 | iron_butterfly | 4 | 1 | 5 | 148360.00 | unknown | — | 376.1350 | 28.8000 | ["360","380","400"] | ["0.4611","0.4671","0.4711"] | [] | ["XMIO"] | 360.0000 | 400.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a546-78ee-7073-b07c-a70c8cf4ee1f | SNPS | 2026-09-15 09:34 | iron_butterfly | 4 | 1 | 5 | 148400.00 | unknown | — | 376.1350 | 28.8000 | ["360","380","400"] | ["0.4613","0.4674","0.4707"] | [] | ["XISX"] | 360.0000 | 400.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a544-d6f6-76a3-ac23-bdb263993a1b | SNPS | 2026-09-15 09:32 | iron_butterfly | 4 | 1 | 5 | 148825.00 | unknown | — | 377.4500 | 30.7000 | ["360","380","400"] | ["0.4640","0.4674","0.4688"] | [] | ["ARCO"] | 360.0000 | 400.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a542-c7a2-7181-94b5-40fb81934226 | SNPS | 2026-09-15 09:30 | iron_butterfly | 4 | 1 | 10 | 297620.00 | unknown | — | 378.5000 | 31.5000 | ["360","380","400"] | ["0.4676","0.4668","0.4626"] | [] | ["XCBO"] | 360.0000 | 400.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a542-ac45-7700-a009-780d406a9ec3 | SNPS | 2026-09-15 09:30 | iron_butterfly | 4 | 1 | 20 | 595340.00 | unknown | — | 378.0100 | 32.1000 | ["360","380","400"] | ["0.4658","0.4689","0.4624"] | [] | ["XPHO"] | 360.0000 | 400.0000 | 493 | 493 | false | false | false | true | |||||||||
| 01a0a17e-2ee8-75a0-b437-2429a3a6d48c | SNPS | 2026-09-14 15:56 | put_vertical_spread | 2 | 1 | 95 | 487825.00 | unknown | — | 380.9000 | 3.0000 | ["300","400"] | ["0.4910","0.4622"] | [] | ["AMXO"] | 300.0000 | 400.0000 | 95 | 95 | false | false | false | true | |||||||||
| 01a0a17d-ec80-77f2-8fa4-52da9eb424d8 | SNPS | 2026-09-14 15:56 | put_vertical_spread | 2 | 2 | 30 | 154850.00 | long | ask | 381.1900 | 3.2000 | ["300","400"] | ["0.4964","0.4652"] | ["362.82"] | ["ARCO","C2OX"] | 300.0000 | 400.0000 | 95 | 95 | false | false | |||||||||||
| 01a0a17d-ec80-77f2-8fa4-52c8b04b14b4 | SNPS | 2026-09-14 15:56 | put_vertical_spread | 2 | 3 | 30 | 154850.00 | long | ask | 381.1900 | 3.2000 | ["300","400"] | ["0.4966","0.4651"] | ["362.84"] | ["ARCO","C2OX"] | 300.0000 | 400.0000 | 95 | 95 | false | false | |||||||||||
| 01a0a152-5070-7913-9be6-76b92278b21d | SNPS | 2026-09-14 15:08 | put_vertical_spread | 2 | 1 | 300 | 1454700.00 | short | bid | 385.5700 | 2.7000 | ["300","400"] | ["0.4929","0.4625"] | ["364.55"] | ["MCRY"] | 300.0000 | 400.0000 | 95 | 95 | false | false | |||||||||||
| 01a0a128-5658-7b31-8fb0-23a2ff4534c6 | SNPS | 2026-09-14 14:22 | put_vertical_spread | 2 | 1 | 233 | 1125390.00 | unknown | — | 385.5033 | 2.6000 | ["300","400"] | ["0.4871","0.4624"] | [] | ["XISX"] | 300.0000 | 400.0000 | 95 | 95 | false | false | false | true | |||||||||
| 01a0a128-5658-7b31-8fb0-2392684a9694 | SNPS | 2026-09-14 14:22 | put_vertical_spread | 2 | 1 | 27 | 130869.00 | long | ask | 385.5033 | 2.6000 | ["300","400"] | ["0.4894","0.4634"] | ["364.31"] | ["EDGO"] | 300.0000 | 400.0000 | 95 | 95 | false | false | |||||||||||
| 01a0a051-3039-7132-811f-fe570799b60b | SNPS | 2026-09-14 10:27 | put_vertical_spread | 2 | 3 | 35 | 162190.00 | short | bid | 389.3300 | 4.5000 | ["300","400"] | ["0.4953","0.4629"] | ["366"] | ["C2OX"] | 300.0000 | 400.0000 | 95 | 95 | false | false | |||||||||||
| 01a0a03a-73e8-79d1-82b0-23d94c6696c2 | SNPS | 2026-09-14 10:02 | put_diagonal_spread | 2 | 2 | 20 | 130750.00 | short | bid | 391.1100 | 8.4000 | ["400","410"] | ["0.4442","0.4422"] | [] | ["ARCO","EMLD"] | 400.0000 | 410.0000 | 39 | 67 | false | false | |||||||||||
| 01a0a03a-73e8-79d1-82b0-23444b1f6973 | SNPS | 2026-09-14 10:02 | put_diagonal_spread | 2 | 2 | 50 | 331250.00 | long | ask | 391.1100 | 11.7000 | ["400","410"] | ["0.4526","0.4490"] | [] | ["SPHR","XMIO"] | 400.0000 | 410.0000 | 39 | 67 | false | false | |||||||||||
| 01a09206-0620-7582-8843-889196f35eb6 | SNPS | 2026-09-11 15:51 | other | 3 | 4 | 4 | 111570.00 | unknown | — | 398.8000 | 14.6000 | ["490","500","580"] | ["1.2210","0.8254","1.3622"] | [] | ["ARCO","EMLD","XPHO"] | 490.0000 | 580.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a09206-0620-7582-8843-888ba567a370 | SNPS | 2026-09-11 15:51 | other | 3 | 6 | 12 | 327574.00 | unknown | — | 398.8000 | 16.8000 | ["490","500","580"] | ["1.1087","0.9296","1.4696"] | [] | ["ARCO","EMLD","SPHR","XBOX"] | 490.0000 | 580.0000 | 7 | 7 | false | false | false | true | |||||||||
| 01a091da-3748-7242-bcd2-9c670242671a | SNPS | 2026-09-11 15:03 | other | 2 | 2 | 48 | 165684.00 | unknown | — | 399.8200 | 3.3000 | ["400","430"] | ["0.3831","0.4486"] | [] | ["ARCO","C2OX"] | 400.0000 | 430.0000 | 7 | 98 | false | false | true | true | |||||||||
| 01a091da-3748-7242-bcd2-9c5c0e922773 | SNPS | 2026-09-11 15:03 | other | 2 | 2 | 100 | 345125.00 | unknown | — | 399.8200 | 3.3000 | ["400","430"] | ["0.3826","0.4487"] | [] | ["ARCO","C2OX"] | 400.0000 | 430.0000 | 7 | 98 | false | false | true | true | |||||||||
| 01a08ce1-6b58-7042-8b97-aa67f1ca296a | SNPS | 2026-09-10 15:52 | put_vertical_spread | 2 | 1 | 5 | 104580.00 | long | ask | 396.2800 | 11.0000 | ["490","510"] | ["0.8826","1.0090"] | ["490.02"] | ["C2OX"] | 490.0000 | 510.0000 | 8 | 8 | false | false | |||||||||||
| 01a08730-4be9-7b90-bdb3-202be6293d9f | SNPS | 2026-09-09 13:21 | risk_reversal | 2 | 1 | 10 | 100850.00 | long | ask | 396.2653 | 7.8000 | ["390","400"] | ["0.4691","0.4684"] | ["410.05"] | ["BATO"] | 390.0000 | 400.0000 | 191 | 191 | false | true | |||||||||||
| 01a06dc6-be6d-7b91-8283-dca5d925364d | SNPS | 2026-09-04 14:55 | call_ratio_spread | 2 | 5 | 84 | 268040.00 | long | ask | 393.2300 | 8.5000 | ["610","780"] | ["0.4385","0.4466"] | ["610.80","949.20"] | ["ARCO","C2OX","EDGO","EMLD","XBOX"] | 610.0000 | 780.0000 | 504 | 504 | false | true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:32:23Z"} |
| 2026-09-17 |
| 2026-09-17 17:27 |
| 2026-09-17 17:27 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T19:34:58Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:06:40Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:04:41Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:12:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:06:13Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:34:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:34:23Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:32:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:30:07Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:30:03Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:56:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:56:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:56:34Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:08:57Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:23:41Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T18:23:41Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:28:09Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:03:18Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:03:18Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:51:20Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:51:20Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:03:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:03:19Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:53:14Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T17:22:18Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:55:39Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |