core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg570,195 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 |
|---|
| 01a0d96e-aea7-79f1-8c15-96002be0c69a | GE | 2026-09-25 12:38 | put_vertical_spread | 2 | 1 | 15 | 160950.00 | short | bid | 327.8500 | 4.1000 | ["350","390"] | ["0.3398","0.3505"] | ["361.56"] | ["XISX"] | 350.0000 | 390.0000 | 175 | 175 | false | false | false | true | false | mlet | 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 |
| 01a0d4b9-871e-7f21-8434-1ef0c1e34f95 | GE | 2026-09-24 14:42 | put_butterfly_spread | 3 | 1 | 55 | 206160.00 | unknown | bid | 321.3400 | 8.6500 | ["337.5","340","345"] | ["0.7401","0.8839","1.2066"] | ["323.3"] | ["XBOX"] | 337.5000 | 345.0000 | 1 | 1 | false | false | |||||||||||
| 01a0d4ac-2d26-7692-bde5-3b9f664dc780 | GE | 2026-09-24 14:27 | call_vertical_spread | 2 | 1 | 4000 | 3148000.00 | unknown | bid | 322.4850 | 1.2700 | ["330","350"] | ["0.2878","0.2941"] | ["337.87"] | ["XPHO"] | 330.0000 | 350.0000 | 22 | 22 | false | true | |||||||||||
| 01a0d4ac-2556-7f03-8045-3490edf97634 | GE | 2026-09-24 14:27 | call_vertical_spread | 2 | 1 | 2000 | 812000.00 | unknown | bid | 322.4800 | 1.0100 | ["340","360"] | ["0.2888","0.2982"] | ["344.06"] | ["XPHO"] | 340.0000 | 360.0000 | 22 | 22 | false | true | |||||||||||
| 01a0cf3a-d9bf-7a22-996a-09b1d997049f | GE | 2026-09-23 13:05 | call_calendar | 2 | 1 | 5 | 116315.00 | short | bid | 320.8600 | 6.3000 | ["240"] | ["0.3614"] | [] | ["XCBO"] | 240.0000 | 240.0000 | 485 | 849 | false | false | true | ||||||||||
| 01a0cedd-0a1f-7062-90da-4247216be88c | GE | 2026-09-23 11:23 | put_vertical_spread | 2 | 1 | 6 | 144762.00 | short | bid | 321.5600 | 6.2500 | ["440","445"] | ["2.5248","2.5953"] | ["440.03"] | ["XMIO"] | 440.0000 | 445.0000 | 2 | 2 | false | false | |||||||||||
| 01a0ceb2-9307-7651-a471-efbd7198949b | GE | 2026-09-23 10:36 | put_vertical_spread | 2 | 1 | 500 | 414000.00 | short | bid | 324.8800 | 1.0400 | ["305","315"] | ["0.3154","0.3085"] | ["312.40"] | ["XMIO"] | 305.0000 | 315.0000 | 23 | 23 | true | true | |||||||||||
| 01a0ca73-fb0e-7011-bb41-fa16e853b483 | GE | 2026-09-22 14:49 | ratio_risk_reversal | 2 | 1 | 120 | 365100.00 | unknown | bid | 319.9000 | 4.6500 | ["280","360"] | ["0.3708","0.3331"] | ["249.58","420.85"] | ["SPHR"] | 280.0000 | 360.0000 | 268 | 268 | false | true | |||||||||||
| 01a0ca0f-362f-78d0-b73c-7424f95207a5 | GE | 2026-09-22 12:59 | put_diagonal_spread | 2 | 1 | 150 | 298500.00 | unknown | bid | 318.1700 | 3.4000 | ["260","280"] | ["0.3716","0.3637"] | [] | ["SPHR"] | 260.0000 | 280.0000 | 115 | 268 | false | true | |||||||||||
| 01a0c9d7-9fb7-7d40-9b5c-f425cb6ac2ea | GE | 2026-09-22 11:59 | call_vertical_spread | 2 | 1 | 35 | 806680.00 | short | bid | 318.1550 | 8.0000 | ["220","230"] | ["0.3481","0.3479"] | ["227.46"] | ["XCBO"] | 220.0000 | 230.0000 | 486 | 486 | false | false | |||||||||||
| 01a0c504-e5df-7d83-a763-55c776109151 | GE | 2026-09-21 13:30 | call_vertical_spread | 2 | 1 | 10 | 127380.00 | short | bid | 320.8400 | 4.8500 | ["270","370"] | ["0.3555","0.3382"] | ["318.22"] | ["XPHO"] | 270.0000 | 370.0000 | 487 | 487 | false | false | |||||||||||
| 01a0c4d8-cccf-76f3-ad21-cad298cb49c4 | GE | 2026-09-21 12:42 | call_diagonal_spread | 2 | 2 | 68 | 143820.00 | short | bid | 321.2400 | 2.0500 | ["310","317.5"] | ["0.3188","0.3528"] | [] | ["ARCO","XPHO"] | 310.0000 | 317.5000 | 4 | 11 | false | false | |||||||||||
| 01a0c45b-c117-77e3-8f72-dcb83a531381 | GE | 2026-09-21 10:25 | call_vertical_spread | 2 | 2 | 96 | 143424.00 | short | bid | 315.4250 | 0.8500 | ["310","320"] | ["0.3129","0.3079"] | ["315.18"] | ["ARCO","C2OX"] | 310.0000 | 320.0000 | 11 | 11 | false | false | |||||||||||
| 01a0b5b5-894f-7012-b22d-928bc53c2b7e | GE | 2026-09-18 14:09 | other | 4 | 2 | 44 | 160336.00 | unknown | bid | 312.6950 | 3.6900 | ["290","310","315","322.5"] | ["0.3535","0.3466","0.7190","1.7910"] | [] | ["AMXO","XBOX"] | 290.0000 | 322.5000 | 0 | 63 | false | false | |||||||||||
| 01a0afe7-9353-7701-8c54-fc107bb8ecd5 | GE | 2026-09-17 11:06 | put_calendar | 2 | 1 | 20 | 146000.00 | long | bid | 316.3900 | 5.7000 | ["350"] | ["0.3798"] | [] | ["XMIO"] | 350.0000 | 350.0000 | 15 | 64 | false | false | true | ||||||||||
| 01a0ab5d-7b3a-76d0-a64c-1bea9571b8fb | GE | 2026-09-16 13:57 | call_diagonal_spread | 2 | 1 | 9 | 122445.00 | short | bid | 316.3225 | 6.3500 | ["250","260"] | ["1.4805","0.3528"] | [] | ["XPHO"] | 250.0000 | 260.0000 | 2 | 184 | false | false | |||||||||||
| 01a0ab08-3333-7623-a636-88716fa0063d | GE | 2026-09-16 12:23 | call_vertical_spread | 2 | 1 | 3 | 104973.00 | short | bid | 317.5700 | 5.3500 | ["140","145"] | ["5.9805","5.8343"] | ["144.99"] | ["XCBO"] | 140.0000 | 145.0000 | 2 | 2 | false | false | |||||||||||
| 01a0aaa7-5a3b-7142-97a6-8965fe285eab | GE | 2026-09-16 10:38 | call_calendar | 2 | 1 | 40 | 230320.00 | short | bid | 314.6100 | 5.0500 | ["290"] | ["0.5513"] | [] | ["XMIO"] | 290.0000 | 290.0000 | 2 | 65 | false | false | true | ||||||||||
| 01a0a57d-b1a6-74e0-8829-9f1f9734f903 | GE | 2026-09-15 10:34 | call_vertical_spread | 2 | 1 | 3 | 113103.00 | short | bid | 311.1950 | 6.0500 | ["120","125"] | ["6.1803","4.9396"] | ["124.99"] | ["XCBO"] | 120.0000 | 125.0000 | 3 | 3 | false | false | |||||||||||
| 01a0a556-43e6-7f72-9000-7ad97b6954be | GE | 2026-09-15 09:51 | put_vertical_spread | 2 | 1 | 21 | 194880.00 | short | bid | 312.6600 | 5.0000 | ["300","380"] | ["0.3453","0.3575"] | ["329.22"] | ["XMIO"] | 300.0000 | 380.0000 | 185 | 185 | false | false | |||||||||||
| 01a0a155-59c8-7061-b489-0b6add7cef2a | GE | 2026-09-14 15:11 | call_diagonal_spread | 2 | 1 | 20 | 145630.00 | short | bid | 317.2400 | 2.3600 | ["300","380"] | ["0.3555","0.3157"] | [] | ["XCBO"] | 300.0000 | 380.0000 | 123 | 494 | false | false | |||||||||||
| 01a091db-6fc8-7cc0-b49f-41e02cc90871 | GE | 2026-09-11 15:04 | call_calendar | 2 | 1 | 21 | 108381.00 | long | bid | 325.0200 | 4.6500 | ["300"] | ["2.8874"] | [] | ["C2OX"] | 300.0000 | 300.0000 | 0 | 7 | false | false | true | ||||||||||
| 01a08c0e-7771-7d81-9045-453770a2bb1e | GE | 2026-09-10 12:02 | call_diagonal_spread | 2 | 1 | 10 | 201610.00 | long | bid | 324.2250 | 4.9000 | ["220","260"] | ["1.1882","0.3766"] | [] | ["MCRY"] | 220.0000 | 260.0000 | 8 | 498 | false | false | |||||||||||
| 01a08c03-dc98-71d0-9f06-34d187616dcc | GE | 2026-09-10 11:50 | call_diagonal_spread | 2 | 1 | 5 | 103225.00 | long | bid | 324.7900 | 5.0000 | ["210","270"] | ["1.3909","0.3749"] | [] | ["XPHO"] | 210.0000 | 270.0000 | 8 | 498 | false | false | |||||||||||
| 01a0815d-6020-7450-a931-ad3d46e0f2d3 | GE | 2026-09-08 10:12 | call_butterfly_spread | 3 | 1 | 76 | 133532.00 | short | bid | 337.7450 | 2.0000 | ["340","350","360"] | ["0.3048","0.2991","0.2975"] | ["341.28","358.72"] | ["AMXO"] | 340.0000 | 360.0000 | 38 | 38 | false | true | |||||||||||
| 01a06d46-536d-7232-b8b1-84d291bd210f | GE | 2026-09-04 12:35 | put_diagonal_spread_bullish | 2 | 1 | 12100 | 42047500.00 | long | bid | 334.2000 | 1.4500 | ["300","340"] | ["0.3405","0.3187"] | [] | ["XBOX"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-21d25a573579 | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 1 | 50 | 174750.00 | long | bid | 334.7350 | 1.0000 | ["300","340"] | ["0.3415","0.3262"] | [] | ["EDGO"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-21acc561e8fa | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 1 | 50 | 174950.00 | long | bid | 334.7000 | 1.0500 | ["300","340"] | ["0.3414","0.3262"] | [] | ["EDGO"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-2129503b36c0 | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 2 | 75 | 263878.00 | long | bid | 334.6000 | 1.6500 | ["300","340"] | ["0.3426","0.3269"] | [] | ["EDGO","XISX"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-210ca434c8ec | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 1 | 125 | 443750.00 | long | bid | 334.2600 | 1.7000 | ["300","340"] | ["0.3439","0.3268"] | [] | ["XBOX"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-20f108f8b48c | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 2 | 250 | 887500.00 | long | bid | 334.2600 | 1.7250 | ["300","340"] | ["0.3439","0.3268"] | [] | ["XBOX"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-20e737c1e83a | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 2 | 250 | 890000.00 | long | bid | 334.2600 | 1.8000 | ["300","340"] | ["0.3447","0.3275"] | [] | ["XBOX"] | 300.0000 | 340.0000 | 105 | 133 | false | false | |||||||||||
| 01a06d44-76dd-7431-9bbb-20d38ce6270c | GE | 2026-09-04 12:33 | put_diagonal_spread_bullish | 2 | 2 | 250 | 892500.00 | long | bid | 334.2600 | 1.8000 | ["300","340"] | ["0.3454","0.3282"] | [] | ["XBOX"] | 300.0000 | 340.0000 | 105 | 133 | false | false |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:42:28Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:27:42Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T18:27:42Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:05:46Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T15:23:36Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:36:50Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| true |
| true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:50:22Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:00:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:59:33Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T17:30:28Z"} |
| 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-21T16:42:44Z"} |
| 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-21T14:26:01Z"} |
| 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-18T18:10:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:06:27Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:57:20Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:24:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:38:31Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:34:46Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:51:40Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| true |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T19:12:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T19:04:36Z"} |
| 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-10T16:02:36Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| true |
| false |
| 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 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T14:12:59Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:35:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:33:27Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |