core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg508,354 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 |
|---|
| 01a0d9a5-f317-7742-99be-d20109d892be | SNPS | 2026-09-25 13:38 | synthetic | 2 | 1 | 10 | 175750.00 | long | ask | 430.0850 | 11.1000 | ["380"] | ["0.4651"] | ["453.75"] | ["XMIO"] | 380.0000 | 380.0000 | 483 | 483 | false | false | false | false | true | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-25T17:38:59Z"} | 2026-09-25 | 2026-09-25 17:15 | 2026-09-25 17:15 |
| 01a0d96f-0496-7fa2-bf5b-da7ed2defa53 | SNPS | 2026-09-25 12:38 | call_vertical_spread | 2 | 1 | 573 | 4516386.00 | long | ask | 429.6450 | 11.2000 | ["385","395"] | ["4.9008","4.1211"] | ["395"] | ["EDGO"] | 385.0000 | 395.0000 | 0 | 0 | false | false | |||||||||||
| 01a0d405-c396-7fc2-862a-170b70d7fc06 | SNPS | 2026-09-24 11:25 | put_vertical_spread | 2 | 1 | 40 | 125600.00 | long | ask | 420.5200 | 2.3000 | ["370","410"] | ["0.4476","0.4379"] | ["396.50"] | ["XISX"] | 370.0000 | 410.0000 | 57 | 57 | false | true | |||||||||||
| 01a0cf98-b12f-7fb1-a85c-198dbe265643 | SNPS | 2026-09-23 14:48 | call_vertical_spread | 2 | 1 | 90 | 223920.00 | long | ask | 419.4700 | 2.3000 | ["420","460"] | ["0.4452","0.4478"] | ["433"] | ["XCBO"] | 420.0000 | 460.0000 | 23 | 23 | false | true | |||||||||||
| 01a0ceb5-afe7-7722-bf02-7464e91a9724 | SNPS | 2026-09-23 10:40 | call_vertical_spread | 2 | 1 | 560 | 389200.00 | long | ask | 415.7000 | 8.2000 | ["422.5","427.5"] | ["0.5665","0.5764"] | ["423.87"] | ["XCBO"] | 422.5000 | 427.5000 | 2 | 2 | true | true | |||||||||||
| 01a0c4b1-3fcf-7f21-8870-95d477eb9a9c | SNPS | 2026-09-21 11:59 | call_vertical_spread | 2 | 1 | 4 | 115544.00 | long | ask | 399.5000 | 13.5000 | ["300","310"] | ["0.4831","0.4805"] | ["306.20"] | ["XCBO"] | 300.0000 | 310.0000 | 487 | 487 | false | false | |||||||||||
| 01a0c4ae-26d7-76f0-811d-0402c48aede7 | SNPS | 2026-09-21 11:55 | call_vertical_spread | 2 | 1 | 5 | 144430.00 | long | ask | 399.9400 | 13.5000 | ["300","310"] | ["0.4802","0.4778"] | ["306.20"] | ["XCBO"] | 300.0000 | 310.0000 | 487 | 487 | false | false | |||||||||||
| 01a0c4a8-1427-73d3-80c4-a8fb6894b133 | SNPS | 2026-09-21 11:49 | call_vertical_spread | 2 | 1 | 5 | 144455.00 | long | ask | 399.7750 | 13.6000 | ["300","310"] | ["0.4815","0.4790"] | ["306.21"] | ["XCBO"] | 300.0000 | 310.0000 | 487 | 487 | false | false | |||||||||||
| 01a0c4a5-83e6-7b40-bd72-f807b525062e | SNPS | 2026-09-21 11:46 | call_vertical_spread | 2 | 1 | 5 | 144455.00 | long | ask | 400.3000 | 13.6000 | ["300","310"] | ["0.4780","0.4757"] | ["306.21"] | ["XCBO"] | 300.0000 | 310.0000 | 487 | 487 | false | false | |||||||||||
| 01a0c4a1-a79f-7191-9c51-0d8c9d1f638a | SNPS | 2026-09-21 11:42 | call_vertical_spread | 2 | 1 | 5 | 144455.00 | long | ask | 400.8250 | 13.6000 | ["300","310"] | ["0.4745","0.4724"] | ["306.21"] | ["XCBO"] | 300.0000 | 310.0000 | 487 | 487 | false | false | |||||||||||
| 01a0c48c-912f-7e00-a206-59d43da13724 | SNPS | 2026-09-21 11:18 | call_vertical_spread | 2 | 1 | 4 | 115176.00 | long | ask | 400.0000 | 11.9000 | ["300","310"] | ["0.4760","0.4738"] | ["306.20"] | ["AMXO"] | 300.0000 | 310.0000 | 487 | 487 | false | false | |||||||||||
| 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 | |||||||||||
| 01a0aa8b-a093-77f3-9a68-d477d182484b | SNPS | 2026-09-16 10:07 | call_diagonal_spread | 2 | 1 | 1248 | 6676800.00 | long | ask | 372.6250 | 4.4000 | ["380","400"] | ["0.4914","0.4452"] | [] | ["SPHR"] | 380.0000 | 400.0000 | 65 | 93 | 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 | |||||||||||
| 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 | |||||||||||
| 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 | |||||||||||
| 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 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-25T16:38:45Z"} |
| 2026-09-25 |
| 2026-09-25 17:15 |
| 2026-09-25 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T15:26:15Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:48:16Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:40:19Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:59:16Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:56:13Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:49:19Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:46:40Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:42:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:19:10Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| 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 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:08:05Z"} |
| 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-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-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: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-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 |