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 | direction |
|---|
| 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 |
|---|
| 01a0d3c7-66bf-7ea3-b328-4684279947a0 | SLV | 2026-09-24 10:17 | call_vertical_spread | 2 | 3 | 109 | 222905.00 | long | ask | 57.2701 | 0.8872 | ["60","120"] | ["0.3980","0.4827"] | ["69.05"] | ["EMLD","SPHR","XPHO"] | 60.0000 | 120.0000 | 813 | 813 | false | true | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T14:17:48Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0d3c3-962e-75b1-8263-c413ef5541fc | SLV | 2026-09-24 10:13 | call_vertical_spread | 2 | 2 | 30 | 126450.00 | long | ask | 57.3100 | 0.9000 | ["45","46"] | ["0.3687","0.3701"] | ["45.53"] | ["XISX","XPHO"] | 45.0000 | 46.0000 | 848 | 848 | false | false | false | ||||||||||
| 01a0d3c3-962e-75b1-8263-c408237eeec2 | SLV | 2026-09-24 10:13 | call_vertical_spread | 2 | 4 | 273 | 1151541.00 | long | ask | 57.3100 | 0.9000 | ["45","46"] | ["0.3694","0.3707"] | ["45.53"] | ["ARCO","EMLD","SPHR","XPHO"] | 45.0000 | 46.0000 | 848 | 848 | false | false | false | ||||||||||
| 01a0ca53-5797-7233-a363-e4ff4c95548d | SLV | 2026-09-22 14:14 | call_vertical_spread | 2 | 1 | 165 | 328350.00 | long | ask | 60.5250 | 0.5000 | ["62","63"] | ["0.4038","0.4061"] | ["62.36"] | ["XCBO"] | 62.0000 | 63.0000 | 360 | 360 | false | true | false | ||||||||||
| 01a0c993-767f-78a3-9272-a67c9b60bb7b | SLV | 2026-09-22 10:44 | call_vertical_spread | 2 | 1 | 100 | 170000.00 | long | ask | 59.1850 | 0.5750 | ["75","150"] | ["0.4287","0.5197"] | ["82.20"] | ["XISX"] | 75.0000 | 150.0000 | 815 | 815 | false | true | false | ||||||||||
| 01a0c460-8f8f-7c22-a93f-17280df35e52 | SLV | 2026-09-21 10:30 | call_vertical_spread | 2 | 1 | 114 | 526452.00 | long | ask | 59.6588 | 1.1500 | ["45","46"] | ["0.3734","0.3751"] | ["45.54"] | ["C2OX"] | 45.0000 | 46.0000 | 851 | 851 | false | false | false | ||||||||||
| 01a0c460-83d7-7a13-82b2-fd97480388e5 | SLV | 2026-09-21 10:30 | call_vertical_spread | 2 | 1 | 26 | 120068.00 | long | ask | 59.6550 | 1.1500 | ["45","46"] | ["0.3735","0.3753"] | ["45.54"] | ["C2OX"] | 45.0000 | 46.0000 | 851 | 851 | false | false | false | ||||||||||
| 01a0c460-7fee-7cf0-bcf6-1e9193bee95e | SLV | 2026-09-21 10:30 | call_vertical_spread | 2 | 1 | 249 | 1149882.00 | long | ask | 59.6500 | 1.1500 | ["45","46"] | ["0.3737","0.3755"] | ["45.54"] | ["MCRY"] | 45.0000 | 46.0000 | 851 | 851 | false | false | false | ||||||||||
| 01a0c460-7fee-7cf0-bcf6-1e84da5d8a66 | SLV | 2026-09-21 10:30 | call_vertical_spread | 2 | 3 | 131 | 606988.00 | long | ask | 59.6500 | 1.1500 | ["45","46"] | ["0.3771","0.3787"] | ["45.54"] | ["ARCO","EMLD","XPHO"] | 45.0000 | 46.0000 | 851 | 851 | false | false | false | ||||||||||
| 01a0b55d-2c37-7043-9278-c4cd87df1eca | SLV | 2026-09-18 12:32 | call_vertical_spread | 2 | 1 | 23 | 108629.00 | long | ask | 60.2301 | 1.1500 | ["45","46"] | ["0.3770","0.3785"] | ["45.55"] | ["XCBO"] | 45.0000 | 46.0000 | 854 | 854 | false | false | false | ||||||||||
| 01a0b55d-2467-7e50-bee9-a2758c0fb75e | SLV | 2026-09-18 12:32 | call_vertical_spread | 2 | 1 | 32 | 151072.00 | long | ask | 60.2199 | 1.2000 | ["45","46"] | ["0.3770","0.3784"] | ["45.55"] | ["XCBO"] | 45.0000 | 46.0000 | 854 | 854 | false | false | false | ||||||||||
| 01a0b55d-2467-7e50-bee9-a24e4fd10a33 | SLV | 2026-09-18 12:32 | call_vertical_spread | 2 | 3 | 38 | 179954.00 | long | ask | 60.2199 | 1.2500 | ["45","46"] | ["0.3801","0.3815"] | ["45.55"] | ["ARCO","EMLD","SPHR"] | 45.0000 | 46.0000 | 854 | 854 | true | false | false | ||||||||||
| 01a0b4fb-322f-73f0-93c8-2531bb760ecf | SLV | 2026-09-18 10:45 | call_vertical_spread | 2 | 1 | 150 | 169500.00 | long | ask | 59.8450 | 0.3000 | ["60","72"] | ["0.4112","0.4434"] | ["63.56"] | ["XCBO"] | 60.0000 | 72.0000 | 182 | 182 | false | true | false | ||||||||||
| 01a0aa71-b7c3-7a70-930e-ac6c62d51685 | SLV | 2026-09-16 09:39 | call_vertical_spread | 2 | 1 | 100 | 209676.00 | long | ask | 58.2450 | 0.5500 | ["60","70"] | ["0.4178","0.4369"] | ["62.95"] | ["XMIO"] | 60.0000 | 70.0000 | 492 | 492 | false | true | false | ||||||||||
| 01a0a5bc-5c9d-7df2-b987-98f7c6758f09 | SLV | 2026-09-15 11:42 | call_vertical_spread | 2 | 1 | 500 | 130500.00 | long | ask | 57.1400 | 0.0600 | ["80","85"] | ["0.5223","0.5405"] | ["80.33"] | ["XMIO"] | 80.0000 | 85.0000 | 122 | 122 | false | true | false | ||||||||||
| 01a0a0f6-ede8-7f11-a80d-1698f3e14395 | SLV | 2026-09-14 13:28 | call_vertical_spread | 2 | 1 | 420 | 140700.00 | long | ask | 57.5550 | 0.3300 | ["160","210"] | ["0.5750","0.6206"] | ["160.71"] | ["XPHO"] | 160.0000 | 210.0000 | 494 | 494 | false | true | false | ||||||||||
| 01a0a0bd-ec28-7072-ab0d-7256e0bf3ee8 | SLV | 2026-09-14 12:26 | call_vertical_spread | 2 | 6 | 193 | 157115.00 | long | ask | 57.3000 | 0.8350 | ["120","150"] | ["0.5181","0.5532"] | ["121.25"] | ["ARCO","BATO","MCRY","XCBO","XISX","XPHO"] | 120.0000 | 150.0000 | 641 | 641 | false | true | false | ||||||||||
| 01a090c9-2121-78b2-a86c-2b33462df579 | SLV | 2026-09-11 10:04 | call_vertical_spread | 2 | 1 | 200 | 279000.00 | long | ask | 58.6750 | 0.3000 | ["55","60"] | ["0.4293","0.4391"] | ["57.35"] | ["XMIO"] | 55.0000 | 60.0000 | 126 | 126 | false | false | false | ||||||||||
| 01a090be-47c8-7d12-8ac0-d6fc076911ba | SLV | 2026-09-11 09:53 | call_vertical_spread | 2 | 1 | 200 | 279000.00 | long | ask | 58.6400 | 0.3000 | ["55","60"] | ["0.4311","0.4405"] | ["57.35"] | ["XMIO"] | 55.0000 | 60.0000 | 126 | 126 | false | false | false | ||||||||||
| 01a08b99-eb81-7d02-abd3-1faed9ef4fe8 | SLV | 2026-09-10 09:55 | call_vertical_spread | 2 | 1 | 230 | 125810.00 | long | ask | 58.3900 | 0.4700 | ["130","160"] | ["0.5481","0.5811"] | ["130.95"] | ["XMIO"] | 130.0000 | 160.0000 | 498 | 498 | false | true | false | ||||||||||
| 01a08784-fb99-7172-97e4-fb0a3f877df5 | SLV | 2026-09-09 14:53 | call_vertical_spread | 2 | 1 | 350 | 485100.00 | long | ask | 61.0000 | 0.4000 | ["60","72"] | ["0.4431","0.4770"] | ["63.78"] | ["BATO"] | 60.0000 | 72.0000 | 191 | 191 | false | false | false |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:13:39Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-24T14:13:39Z"} |
| 2026-09-24 |
| 2026-09-24 17:15 |
| 2026-09-24 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:14:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:44:55Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:31:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:31:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:31:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:31:05Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:33:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:33:19Z"} |
| 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-18T16:33:19Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:45:58Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T13:39:35Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:43:20Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T17:29:01Z"} |
| 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-14T16:26:41Z"} |
| 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-11T14:05:02Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:53:03Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T13:55:20Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T18:53:52Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |