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 |
|---|
| 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 |
|---|
| 01a0caac-31af-7973-862e-e0f6bd2d6650 | SMH | 2026-09-22 15:51 | call_vertical_spread | 2 | 1 | 15 | 114975.00 | short | bid | 607.6850 | 2.8500 | ["562.5","577.5"] | ["0.4042","0.4017"] | ["576.85"] | ["XCBO"] | 562.5000 | 577.5000 | 3 | 3 | false | false | false | true | false | mesl | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T19:51:30Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca51-389e-7f93-8d60-25b741c3a3e3 | SMH | 2026-09-22 14:11 | strangle | 2 | 1 | 38 | 86830.00 | short | bid | 605.0450 | 0.1079 | ["587.5","630"] | ["0.3321","0.3221"] | ["564.65","652.85"] | ["XISX"] | 587.5000 | 630.0000 | 24 | 24 | false | true | false | true | |||||||||
| 01a0ca50-e2af-7860-9ae8-9c1d8375407b | SMH | 2026-09-22 14:11 | strangle | 2 | 2 | 234 | 535860.00 | short | bid | 604.8509 | 0.1286 | ["587.5","630"] | ["0.3318","0.3233"] | ["564.6","652.90"] | ["AMXO"] | 587.5000 | 630.0000 | 24 | 24 | false | true | false | true | |||||||||
| 01a0ca50-e2af-7860-9ae8-9c0ab4f2d5c2 | SMH | 2026-09-22 14:11 | strangle | 2 | 1 | 15 | 34355.00 | short | bid | 604.8509 | 0.1500 | ["587.5","630"] | ["0.3318","0.3234"] | ["564.60","652.90"] | ["AMXO"] | 587.5000 | 630.0000 | 24 | 24 | false | true | false | true | |||||||||
| 01a0c98e-9097-7273-8903-991f7dfd5ed5 | SMH | 2026-09-22 10:39 | straddle | 2 | 2 | 59 | 648885.00 | short | bid | 602.1000 | 0.6093 | ["545"] | ["0.3798"] | ["435.02","654.98"] | ["ARCO"] | 545.0000 | 545.0000 | 115 | 115 | false | false | false | false | |||||||||
| 01a0c563-4606-7220-a94f-3c031b270cfb | SMH | 2026-09-21 15:13 | call_vertical_spread | 2 | 3 | 181 | 934160.00 | short | bid | 596.2100 | 0.1550 | ["600","650"] | ["0.3643","0.3571"] | ["618.81"] | ["C2OX"] | 600.0000 | 650.0000 | 60 | 60 | false | true | false | true | |||||||||
| 01a0c552-2737-77d1-b65f-aee4cc2a3d20 | SMH | 2026-09-21 14:54 | call_vertical_spread | 2 | 1 | 130 | 393250.00 | short | bid | 595.9500 | 0.1500 | ["600","625"] | ["0.3383","0.3346"] | ["609.55"] | ["C2OX"] | 600.0000 | 625.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c4a9-2597-7331-8126-f7389f028a02 | SMH | 2026-09-21 11:50 | put_diagonal_spread | 2 | 7 | 115 | 299920.00 | short | bid | 590.9000 | 0.3500 | ["435","560"] | ["0.5532","0.3692"] | [] | ["BATO","EMLD","XCBO","XISX","XPHO"] | 435.0000 | 560.0000 | 25 | 88 | false | true | true | true | |||||||||
| 01a0c490-debe-7523-80ca-489ecfd4ae40 | SMH | 2026-09-21 11:23 | call_vertical_spread | 2 | 1 | 4 | 75140.00 | short | bid | 590.2300 | 5.8500 | ["480","520"] | ["0.5671","0.4573"] | ["515.15"] | ["XISX"] | 480.0000 | 520.0000 | 25 | 25 | false | false | false | true | |||||||||
| 01a0c48a-2fcf-7750-ae97-28493b3332e6 | SMH | 2026-09-21 11:16 | call_vertical_spread | 2 | 2 | 109 | 246330.00 | short | bid | 590.3900 | 0.3000 | ["605","630"] | ["0.3354","0.3360"] | ["612.5"] | ["EDGO","XISX"] | 605.0000 | 630.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c479-efa6-78f1-91fd-47875bd07328 | SMH | 2026-09-21 10:58 | straddle | 2 | 3 | 12 | 122085.00 | short | bid | 587.9400 | 1.3125 | ["545"] | ["0.3693"] | ["443.26","646.74"] | ["ARCO"] | 545.0000 | 545.0000 | 116 | 116 | false | false | false | false | |||||||||
| 01a0c464-3527-7b00-bcaf-9517120ac11d | SMH | 2026-09-21 10:34 | call_calendar | 2 | 1 | 11 | 27720.00 | short | bid | 586.6000 | 0.6000 | ["600"] | ["0.3423"] | [] | ["XMIO"] | 600.0000 | 600.0000 | 4 | 39 | false | true | true | false | |||||||||
| 01a0afe9-e8fb-7d53-a0a4-e74627341dd5 | SMH | 2026-09-17 11:08 | put_calendar | 2 | 1 | 38 | 26600.00 | short | bid | 560.1450 | 0.2400 | ["550"] | ["0.3507"] | [] | ["C2OX"] | 550.0000 | 550.0000 | 1 | 8 | false | true | true | false | |||||||||
| 01a0afe8-3763-7252-b72b-6df9f7536af1 | SMH | 2026-09-17 11:07 | put_calendar | 2 | 2 | 57 | 41610.00 | short | bid | 559.4800 | 0.1700 | ["550"] | ["0.3488"] | [] | ["C2OX"] | 550.0000 | 550.0000 | 1 | 8 | false | true | true | false | |||||||||
| 01a0aa7e-bfb2-7330-bb6c-948193a12129 | SMH | 2026-09-16 09:53 | call_calendar | 2 | 2 | 2 | 44790.00 | short | bid | 550.6100 | 2.5500 | ["440"] | ["0.8420"] | [] | ["XCBO"] | 440.0000 | 440.0000 | 2 | 30 | false | false | true | false | |||||||||
| 01a0a607-3c95-7743-8b2e-378af1e880d8 | SMH | 2026-09-15 13:04 | put_diagonal_spread | 2 | 1 | 5 | 75150.00 | short | bid | 540.5200 | 1.4000 | ["610","615"] | ["0.3462","0.3480"] | [] | ["C2OX"] | 610.0000 | 615.0000 | 24 | 66 | false | false | true | true | |||||||||
| 01a0a607-3c95-7743-8b2e-377928eb8a63 | SMH | 2026-09-15 13:04 | put_diagonal_spread | 2 | 1 | 7 | 105210.00 | short | bid | 540.5200 | 1.4000 | ["610","615"] | ["0.3462","0.3480"] | [] | ["C2OX"] | 610.0000 | 615.0000 | 24 | 66 | false | false | true | true | |||||||||
| 01a0a5ca-0c85-7de1-8aaf-807d6dd4f542 | SMH | 2026-09-15 11:57 | risk_reversal | 2 | 1 | 10 | 27650.00 | short | ask | 542.2600 | 0.1000 | ["500","600"] | ["0.3748","0.3390"] | ["497.75"] | ["XBOX"] | 500.0000 | 600.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a0a55f-0de6-7bd2-8e3c-b31da556deac | SMH | 2026-09-15 10:01 | call_diagonal_spread | 2 | 1 | 6 | 69780.00 | short | bid | 547.2650 | 2.8000 | ["490","495"] | ["0.6044","0.3614"] | [] | ["XCBO"] | 490.0000 | 495.0000 | 3 | 31 | false | false | true | true | |||||||||
| 01a08bb2-ce98-7473-babe-7482a9630b04 | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 22 | 135190.00 | short | ask | 560.3062 | 1.2000 | ["520","675"] | ["0.3867","0.3549"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | true | |||||||||
| 01a08bb2-ce98-7473-babe-7475cbf0b96c | SMH | 2026-09-10 10:22 | risk_reversal | 2 | 1 | 6 | 36870.00 | short | ask | 560.2500 | 0.7000 | ["520","675"] | ["0.3867","0.3551"] | ["507.35"] | ["XBOX"] | 520.0000 | 675.0000 | 190 | 190 | false | true | false | true | |||||||||
| 01a08bac-0c20-7f30-b68c-1947fc8861af | SMH | 2026-09-10 10:15 | put_vertical_spread | 2 | 1 | 25 | 48975.00 | short | bid | 559.4100 | 2.1400 | ["510","565"] | ["0.3843","0.3428"] | ["549.49"] | ["C2OX"] | 510.0000 | 565.0000 | 14 | 14 | true | false | false | true | |||||||||
| 01a08714-1159-7fb0-b89a-8ec40d08db1e | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 23 | 366965.00 | short | ask | 575.1400 | 0.3000 | ["630"] | ["0.3804"] | ["592.25"] | ["MCRY"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a08714-0988-7842-9d01-de2f48466a43 | SMH | 2026-09-09 12:50 | synthetic | 2 | 1 | 2 | 31910.00 | short | ask | 575.1650 | 0.8000 | ["630"] | ["0.3804"] | ["592.25"] | ["XBOX"] | 630.0000 | 630.0000 | 281 | 281 | false | false | false | false | |||||||||
| 01a086a0-0a38-71c3-a4ac-b7b77bd9175e | SMH | 2026-09-09 10:43 | call_vertical_spread | 2 | 1 | 30 | 49200.00 | short | bid | 575.2450 | 2.6500 | ["580","615"] | ["0.3487","0.3435"] | ["590.10"] | ["C2OX"] | 580.0000 | 615.0000 | 13 | 13 | true | true | false | true | |||||||||
| 01a0869c-d5e8-70e1-9d1b-3c6dfaed9f68 | SMH | 2026-09-09 10:40 | call_vertical_spread | 2 | 1 | 35 | 39515.00 | short | bid | 575.7300 | 1.5700 | ["590","640"] | ["0.3486","0.3555"] | ["598.81"] | ["C2OX"] | 590.0000 | 640.0000 | 14 | 14 | false | true | false | true | |||||||||
| 01a08698-fd88-72d0-8bb4-fb8fb5c3593c | SMH | 2026-09-09 10:36 | call_vertical_spread | 2 | 2 | 35 | 33110.00 | short | bid | 575.8500 | 2.1100 | ["595","645"] | ["0.3479","0.3624"] | ["602.34"] | ["C2OX"] | 595.0000 | 645.0000 | 14 | 14 | false | true | false | true | |||||||||
| 01a08145-6768-7660-992c-5d4ece045a3e | SMH | 2026-09-08 09:46 | put_vertical_spread | 2 | 1 | 75 | 35700.00 | short | bid | 574.3850 | 0.3600 | ["525","535"] | ["0.4323","0.4139"] | ["534.04"] | ["C2OX"] | 525.0000 | 535.0000 | 10 | 10 | false | true | false | true |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:11:57Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:39:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:13:50Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:55:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:50:37Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:23:47Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T15:16:42Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:58:52Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:34:56Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:09:12Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:07:31Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:54:04Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:05:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:05:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:58:09Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:01:26Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:22:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:22:28Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:15:03Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T16:50:46Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:44:22Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:40:31Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T14:36:25Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |
| mesl |
| tracked |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:46:53Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |