core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg438,407 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 |
|---|
| 01a0ca1c-fd87-75a3-9288-6ee40655634b | ISRG | 2026-09-22 13:14 | call_vertical_spread | 2 | 1 | 10 | 127400.00 | long | ask | 399.6600 | 8.8000 | ["360","370"] | ["0.4154","0.4096"] | ["366.50"] | ["XISX"] | 360.0000 | 370.0000 | 150 | 150 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:15:22Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0c95a-e607-7481-9ee2-b5133f7c52e9 | ISRG | 2026-09-22 09:42 | call_vertical_spread | 2 | 1 | 50 | 353000.00 | unknown | ask | 401.0400 | 8.8000 | ["370","375"] | ["0.4225","0.4132"] | ["407.80"] | ["XBOX"] | 370.0000 | 375.0000 | 24 | 24 | false | false | |||||||||||
| 01a0c437-ba6e-7b12-878e-89f6369a315c | ISRG | 2026-09-21 09:46 | call_vertical_spread | 2 | 2 | 20 | 117480.00 | long | ask | 393.2100 | 8.7000 | ["520","640"] | ["0.3876","0.3848"] | ["540"] | ["XMIO"] | 520.0000 | 640.0000 | 487 | 487 | false | true | |||||||||||
| 01a0b560-f110-76e0-b1ab-ceda1bc5e267 | ISRG | 2026-09-18 12:37 | put_diagonal_spread | 2 | 2 | 70 | 1599990.00 | short | ask | 392.4400 | 6.2000 | ["480","500"] | ["0.4191","0.4351"] | [] | ["XBOX","XPHO"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b560-f110-76e0-b1ab-cec76cac0bec | ISRG | 2026-09-18 12:37 | put_diagonal_spread | 2 | 2 | 70 | 1590540.00 | short | ask | 392.4400 | 6.2000 | ["480","500"] | ["0.4154","0.4280"] | [] | ["AMXO","XPHO"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b55d-d430-78b1-bf42-62a179d99ea7 | ISRG | 2026-09-18 12:33 | put_diagonal_spread | 2 | 2 | 178 | 4038820.00 | short | ask | 392.6900 | 7.0000 | ["480","500"] | ["0.4161","0.4265"] | [] | ["AMXO"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b55b-1ce0-7252-8b68-b7fa29b868ba | ISRG | 2026-09-18 12:30 | put_diagonal_spread | 2 | 2 | 5 | 113450.00 | short | ask | 392.4500 | 7.0000 | ["480","500"] | ["0.4154","0.4246"] | [] | ["XPHO"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b55b-18f7-7693-bffe-f67c18eee104 | ISRG | 2026-09-18 12:30 | put_diagonal_spread | 2 | 1 | 179 | 4061513.00 | short | ask | 392.4500 | 7.0000 | ["480","500"] | ["0.4154","0.4246"] | [] | ["XISX"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b55b-18f7-7693-bffe-f66829f4e0f3 | ISRG | 2026-09-18 12:30 | put_diagonal_spread | 2 | 1 | 179 | 4061510.00 | short | ask | 392.4500 | 7.0000 | ["480","500"] | ["0.4154","0.4246"] | [] | ["XISX"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b55b-18f7-7693-bffe-f65b0ebd56ad | ISRG | 2026-09-18 12:30 | put_diagonal_spread | 2 | 1 | 179 | 4061510.00 | short | ask | 392.4500 | 7.0000 | ["480","500"] | ["0.4156","0.4244"] | [] | ["XISX"] | 480.0000 | 500.0000 | 182 | 490 | false | false | |||||||||||
| 01a0b558-2710-75b3-a05d-1db2b67e057b | ISRG | 2026-09-18 12:27 | call_diagonal_spread | 2 | 2 | 46 | 216361.00 | long | ask | 392.3599 | 2.9000 | ["460","500"] | ["0.3867","0.3860"] | [] | ["ARCO","XCBO"] | 460.0000 | 500.0000 | 182 | 272 | false | true | |||||||||||
| 01a0afa7-65a3-7810-8e5b-5e3f406c9928 | ISRG | 2026-09-17 09:56 | call_vertical_spread | 2 | 1 | 110 | 143990.00 | long | ask | 380.9800 | 4.2000 | ["375","380"] | ["0.5736","0.5539"] | ["378.23"] | ["XMIO"] | 375.0000 | 380.0000 | 1 | 1 | false | false | |||||||||||
| 01a0ab05-0e83-7ce3-970a-a7fb52428881 | ISRG | 2026-09-16 12:20 | put_calendar | 2 | 3 | 50 | 133530.00 | long | ask | 385.3800 | 1.4600 | ["385"] | ["0.3411"] | [] | ["ARCO","C2OX"] | 385.0000 | 385.0000 | 23 | 30 | false | true | |||||||||||
| 01a0a085-ec38-7d30-a9f0-5859870b7801 | ISRG | 2026-09-14 11:25 | put_vertical_spread | 2 | 1 | 2 | 101602.00 | long | ask | 372.9075 | 12.6000 | ["625","630"] | ["2.9433","2.9572"] | ["625.03"] | ["BATO"] | 625.0000 | 630.0000 | 4 | 4 | false | false | |||||||||||
| 01a09134-1020-7590-9ba4-1d1fde6f8c2f | ISRG | 2026-09-11 12:01 | synthetic | 2 | 4 | 17 | 115090.00 | short | ask | 367.6600 | 0.6000 | ["380"] | ["0.3886"] | ["373.21"] | ["AMXO","C2OX","EDGO","XPHO"] | 380.0000 | 380.0000 | 126 | 126 | false | false | |||||||||||
| 01a090c1-a710-7d53-95da-38b8582700ae | ISRG | 2026-09-11 09:56 | call_vertical_spread | 2 | 1 | 45 | 191340.00 | long | ask | 366.6100 | 9.1000 | ["370","375"] | ["0.4411","0.4186"] | ["373.40"] | ["BATO"] | 370.0000 | 375.0000 | 49 | 49 | true | true | |||||||||||
| 01a08cbc-d428-7062-8e5b-0a32c61069e3 | ISRG | 2026-09-10 15:12 | synthetic | 2 | 1 | 10 | 172546.00 | long | ask | 362.3250 | 11.4000 | ["310"] | ["0.4220"] | ["393.68"] | ["XCBO"] | 310.0000 | 310.0000 | 827 | 827 | false | false | |||||||||||
| 01a08b86-a5e8-77c1-9a54-fb2ff43b53fc | ISRG | 2026-09-10 09:34 | call_vertical_spread | 2 | 1 | 500 | 267000.00 | long | ask | 349.1900 | 3.5500 | ["350","360"] | ["0.6228","0.6385"] | ["353"] | ["XISX"] | 350.0000 | 360.0000 | 1 | 1 | false | true | |||||||||||
| 01a0878b-4cc8-74d0-bf22-0736ed371282 | ISRG | 2026-09-09 15:00 | put_calendar | 2 | 1 | 5 | 102045.00 | short | ask | 351.5900 | 5.0000 | ["450"] | ["0.4161"] | [] | ["XISX"] | 450.0000 | 450.0000 | 128 | 163 | false | false | |||||||||||
| 01a086d2-3210-7b61-b635-a3abf286aa67 | ISRG | 2026-09-09 11:38 | put_vertical_spread | 2 | 1 | 10 | 133140.00 | long | ask | 351.2950 | 10.9000 | ["405","415"] | ["0.3764","0.3792"] | ["407.20"] | ["XMIO"] | 405.0000 | 415.0000 | 128 | 128 | false | false | |||||||||||
| 01a086c5-9780-7113-853b-90eff998cf1e | ISRG | 2026-09-09 11:24 | put_calendar | 2 | 1 | 20 | 124380.00 | short | ask | 350.6700 | 8.1000 | ["380"] | ["0.2940"] | [] | ["XISX"] | 380.0000 | 380.0000 | 9 | 37 | false | false | |||||||||||
| 01a081bf-65e1-7382-a69a-1bc41f1c47de | ISRG | 2026-09-08 11:59 | call_vertical_spread | 2 | 1 | 500 | 385000.00 | long | ask | 348.3850 | 1.5000 | ["350","360"] | ["0.5009","0.4869"] | ["353.50"] | ["XMIO"] | 350.0000 | 360.0000 | 3 | 3 | false | true | |||||||||||
| 01a081a4-b9c0-7bd0-aef7-8808eddf0e38 | ISRG | 2026-09-08 11:30 | put_calendar | 2 | 1 | 15 | 145110.00 | short | ask | 350.8599 | 5.3000 | ["380"] | ["0.3788"] | [] | ["XMIO"] | 380.0000 | 380.0000 | 129 | 192 | false | false | |||||||||||
| 01a0818e-bcd8-70a2-ab32-86ae1ea7e6eb | ISRG | 2026-09-08 11:06 | call_vertical_spread | 2 | 3 | 300 | 1458000.00 | long | ask | 351.5600 | 2.6000 | ["350","360"] | ["0.3935","0.3898"] | ["354.80"] | ["EMLD","XCBO"] | 350.0000 | 360.0000 | 73 | 73 | true | false | |||||||||||
| 01a0818e-bcd8-70a2-ab32-8698c160e11e | ISRG | 2026-09-08 11:06 | call_vertical_spread | 2 | 2 | 200 | 978000.00 | long | ask | 351.5600 | 2.7000 | ["350","360"] | ["0.3959","0.3922"] | ["354.80"] | ["AMXO","XISX"] | 350.0000 | 360.0000 | 73 | 73 | true | false | |||||||||||
| 01a06d27-abc5-7f92-a77d-216ae1d17055 | ISRG | 2026-09-04 12:01 | put_calendar | 2 | 1 | 20 | 114680.00 | short | ask | 364.8700 | 9.7000 | ["385"] | ["0.3556"] | [] | ["XMIO"] | 385.0000 | 385.0000 | 14 | 77 | false | false |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:42:52Z"} |
| 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-21T13:46:20Z"} |
| 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-18T16:37:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:37:09Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:33:40Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:31:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:31:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:31:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:31:04Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:27:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:56:38Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T16:20:55Z"} |
| 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-14T15:25:35Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| true |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T16:01:46Z"} |
| 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-11T13:56:59Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T19:13:20Z"} |
| 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-10T13:34:13Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T19:01:09Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| true |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:38:49Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T15:25:00Z"} |
| 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-08T16:00:03Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:31:11Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:07:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| true |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T15:07:08Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T16:02:21Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |