core.multileg_trades
Class E accrual with a 24-hour vendor cap - the shortest window in the project.
uw_multileg473,794 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 |
|---|
| 01a0d4fa-a317-73c3-be8d-f51c85c139fa | MCD | 2026-09-24 15:53 | put_vertical_spread | 2 | 1 | 15 | 133710.00 | long | ask | 237.4217 | 4.3000 | ["280","285"] | ["0.3253","0.3596"] | [] | ["AMXO"] | 280.0000 | 285.0000 | 29 | 29 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T19:53:31Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d3d1-3a5f-70f1-bb64-c1066a4d5ee0 | MCD | 2026-09-24 10:28 | put_vertical_spread | 2 | 1 | 10 | 113040.00 | long | ask | 240.9375 | 3.5000 | ["295","300"] | ["2.5011","2.5945"] | ["295.02"] | ["XMIO"] | 295.0000 | 300.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0d3d1-0f67-7993-a881-c3a44187b216 | MCD | 2026-09-24 10:28 | put_vertical_spread | 2 | 1 | 10 | 113050.00 | long | ask | 240.8900 | 3.5000 | ["295","300"] | ["2.4744","2.5648"] | ["295.01"] | ["XCBO"] | 295.0000 | 300.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0cfad-fe4f-7b40-aae1-4f97c4105c1a | MCD | 2026-09-23 15:11 | call_vertical_spread | 2 | 1 | 90 | 189000.00 | long | ask | 237.2100 | 0.4500 | ["235","245"] | ["0.2286","0.2301"] | ["239.60"] | ["XCBO"] | 235.0000 | 245.0000 | 86 | 86 | false | false | false | true | |||||||||
| 01a0cf39-3baf-7503-9221-bedfe9b75884 | MCD | 2026-09-23 13:03 | put_vertical_spread | 2 | 1 | 60 | 268800.00 | long | ask | 234.2500 | 2.0500 | ["250","260"] | ["0.2496","0.2649"] | ["251.70"] | ["XISX"] | 250.0000 | 260.0000 | 58 | 58 | false | false | false | true | |||||||||
| 01a0cf22-c997-75d2-ade3-b6196137e319 | MCD | 2026-09-23 12:39 | call_ratio_spread | 2 | 1 | 447 | 125458.00 | long | ask | 235.0000 | 0.4600 | ["270","330"] | ["0.2415","0.2625"] | ["273.48","358.26"] | ["AMXO"] | 270.0000 | 330.0000 | 177 | 177 | false | true | false | true | |||||||||
| 01a0ca5e-4c47-7673-92b0-ac95edf23053 | MCD | 2026-09-22 14:26 | put_vertical_spread | 2 | 1 | 10 | 193470.00 | long | ask | 251.0500 | 4.3000 | ["345","350"] | ["1.7628","1.8076"] | ["345.03"] | ["BATO"] | 345.0000 | 350.0000 | 3 | 3 | false | false | false | true | |||||||||
| 01a0c57b-1b97-7b71-a323-a7b131f2458e | MCD | 2026-09-21 15:39 | call_calendar | 2 | 1 | 129 | 131322.00 | long | ask | 248.8250 | 0.3500 | ["265"] | ["0.2333"] | [] | ["BATO"] | 265.0000 | 265.0000 | 60 | 88 | false | true | true | false | false | ||||||||
| 01a0b5a3-7c37-7250-9653-e8b063c1d550 | MCD | 2026-09-18 13:49 | call_vertical_spread | 2 | 1 | 60 | 303360.00 | long | ask | 249.0900 | 2.1000 | ["240","250"] | ["0.2218","0.2225"] | ["245.40"] | ["BATO"] | 240.0000 | 250.0000 | 272 | 272 | false | false | false | true | |||||||||
| 01a0b4fa-5f40-7a50-9a15-455d60abed54 | MCD | 2026-09-18 10:44 | put_vertical_spread | 2 | 1 | 45 | 215685.00 | long | ask | 250.0650 | 1.7000 | ["265","275"] | ["0.2602","0.2698"] | ["267.51"] | ["BATO"] | 265.0000 | 275.0000 | 91 | 91 | false | false | false | true | |||||||||
| 01a0b007-6f93-7292-8ce0-e4316b58b7ae | MCD | 2026-09-17 11:41 | put_vertical_spread | 2 | 1 | 6 | 150714.00 | long | ask | 249.2926 | 9.4000 | ["350","400"] | ["0.3930","0.5005"] | ["350.05"] | ["XMIO"] | 350.0000 | 400.0000 | 491 | 491 | false | false | false | true | |||||||||
| 01a0afd4-a793-7480-801b-8f6ad3cb95f5 | MCD | 2026-09-17 10:45 | put_vertical_spread | 2 | 1 | 6 | 111684.00 | long | ask | 249.8100 | 3.5000 | ["340","345"] | ["2.9981","3.0904"] | ["340.02"] | ["XMIO"] | 340.0000 | 345.0000 | 1 | 1 | false | false | false | true | |||||||||
| 01a0aad0-bfe3-7bf2-af73-2c3a26672c8e | MCD | 2026-09-16 11:23 | put_calendar | 2 | 1 | 20 | 214420.00 | long | ask | 250.2250 | 2.6500 | ["300"] | ["0.3129"] | [] | ["XMIO"] | 300.0000 | 300.0000 | 184 | 457 | false | false | true | false | false | ||||||||
| 01a0aa84-8443-7d80-ae06-33ba7a7afad3 | MCD | 2026-09-16 10:00 | call_ratio_spread | 2 | 3 | 70 | 148532.00 | long | ask | 249.2850 | 1.7000 | ["250","270"] | ["0.2282","0.2275"] | ["251.50","297.75"] | ["ARCO","EMLD","SPHR"] | 250.0000 | 270.0000 | 184 | 184 | false | true | false | true | |||||||||
| 01a0a647-3396-7aa0-be95-6c0ed9fb1997 | MCD | 2026-09-15 14:14 | risk_reversal | 2 | 1 | 22 | 111100.00 | long | bid | 253.7300 | 2.9500 | ["305","370"] | ["1.0829","2.1775"] | ["255.80"] | ["EMLD"] | 305.0000 | 370.0000 | 3 | 3 | false | false | false | true | true | ||||||||
| 01a0a5d7-f706-73b2-9871-8a5b7cf2aad5 | MCD | 2026-09-15 12:13 | put_vertical_spread | 2 | 6 | 49 | 127706.00 | long | ask | 254.4850 | 0.6000 | ["250","260"] | ["0.2452","0.2473"] | ["255.0"] | ["ARCO","BATO","C2OX","EMLD","SPHR","XBOX"] | 250.0000 | 260.0000 | 122 | 122 | false | false | false | true | |||||||||
| 01a0a0fe-3149-79c0-ba31-cfc811d1fdd9 | MCD | 2026-09-14 13:36 | put_calendar | 2 | 1 | 22 | 107668.00 | long | ask | 257.1300 | 2.5000 | ["280"] | ["0.2394"] | [] | ["XMIO"] | 280.0000 | 280.0000 | 32 | 95 | false | false | true | false | false | ||||||||
| 01a08661-1508-7631-b7e4-b3580c5d0cf1 | MCD | 2026-09-09 09:35 | put_vertical_spread | 2 | 6 | 111 | 438006.00 | long | ask | 253.8100 | 0.9500 | ["250","260"] | ["0.2608","0.2628"] | ["255"] | ["BATO","EDGO","XCBO","XISX","XPHO"] | 250.0000 | 260.0000 | 281 | 281 | false | false | false | true |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:28:18Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:28:18Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T19:11:35Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T17:03:56Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T16:39:48Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:26:42Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:39:54Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:50:13Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:45:06Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:41:32Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T14:46:09Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T15:23:31Z"} |
| 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-16T14:00:19Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T18:15:11Z"} |
| 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-15T16:13:16Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:37:27Z"} |
| 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-09T13:35:13Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |