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 | 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 |
|---|
| 01a0ca41-524f-7493-9541-a2ddd52c0f48 | NET | 2026-09-22 13:54 | call_vertical_spread | 2 | 1 | 4 | 146316.00 | short | bid | 355.1500 | 7.4000 | ["170","175"] | ["3.3264","3.2638"] | ["174.97"] | ["BATO"] | 170.0000 | 175.0000 | 3 | 3 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-22T17:54:41Z"} | 2026-09-22 | 2026-09-22 17:15 | 2026-09-22 17:15 |
| 01a0ca0c-bd5e-7812-bfdf-5acb439a8485 | NET | 2026-09-22 12:57 | call_vertical_spread | 2 | 1 | 3 | 120645.00 | short | bid | 353.3200 | 6.8500 | ["150","155"] | ["3.8952","3.7745"] | ["154.99"] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0ca08-7f6e-7601-b7b5-fac0cad51c5b | NET | 2026-09-22 12:52 | call_vertical_spread | 2 | 1 | 4 | 162164.00 | short | bid | 354.5950 | 6.9500 | ["150","155"] | ["4.4695","4.3219"] | ["154.99"] | ["XCBO"] | 150.0000 | 155.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c9e1-020f-7402-aa87-972eb03d5746 | NET | 2026-09-22 12:09 | call_vertical_spread | 2 | 1 | 5 | 109170.00 | unknown | bid | 349.6400 | 6.1000 | ["250","260"] | ["0.6621","0.6552"] | ["364.17"] | ["AMXO"] | 250.0000 | 260.0000 | 115 | 115 | false | false | false | ||||||||||
| 01a0c9d4-5faf-73d2-823a-4aa18e755ee5 | NET | 2026-09-22 11:55 | call_vertical_spread | 2 | 1 | 3 | 112953.00 | short | bid | 350.2300 | 6.3500 | ["160","165"] | ["4.0073","3.8728"] | ["164.99"] | ["XCBO"] | 160.0000 | 165.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c995-56f7-7bb1-afb8-f6d3760f6d3d | NET | 2026-09-22 10:46 | call_vertical_spread | 2 | 1 | 4 | 135144.00 | short | bid | 350.8800 | 5.7000 | ["180","185"] | ["3.4869","3.3557"] | ["185"] | ["XMIO"] | 180.0000 | 185.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0c532-52c7-7c53-b9e2-4de25a3e4ef5 | NET | 2026-09-21 14:20 | call_vertical_spread | 2 | 1 | 4 | 148124.00 | short | bid | 347.8800 | 5.9500 | ["160","165"] | ["3.9690","3.8827"] | ["164.99"] | ["XCBO"] | 160.0000 | 165.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0c521-6aa7-7931-b683-b76e4066e9a1 | NET | 2026-09-21 14:01 | call_vertical_spread | 2 | 1 | 4 | 155928.00 | short | bid | 347.6000 | 6.0000 | ["150","155"] | ["4.6141","3.8191"] | ["154.98"] | ["XCBO"] | 150.0000 | 155.0000 | 4 | 4 | false | false | false | ||||||||||
| 01a0c468-d4bf-7d82-be6c-d00fea91294c | NET | 2026-09-21 10:39 | call_vertical_spread | 2 | 1 | 20 | 113540.00 | unknown | bid | 341.9950 | 6.1000 | ["315","317.5"] | ["0.7967","0.7869"] | ["344.64"] | ["XCBO"] | 315.0000 | 317.5000 | 4 | 4 | false | false | false | ||||||||||
| 01a0c428-f533-7d21-a027-b86629042329 | NET | 2026-09-21 09:30 | call_vertical_spread | 2 | 1 | 7 | 103810.00 | short | bid | 327.5000 | 6.0000 | ["250","280"] | ["0.6730","0.6637"] | ["272.60"] | ["XISX"] | 250.0000 | 280.0000 | 60 | 60 | false | false | false | ||||||||||
| 01a0b5f2-154f-76a1-9ccd-6924f3eab661 | NET | 2026-09-18 15:15 | call_vertical_spread | 2 | 1 | 63 | 974988.00 | unknown | bid | 322.2948 | 6.4500 | ["250","260"] | ["0.6692","0.6586"] | ["332.38"] | ["BATO"] | 250.0000 | 260.0000 | 63 | 63 | false | false | false | ||||||||||
| 01a0b586-b8ef-7ad1-a3e4-02c2226837d3 | NET | 2026-09-18 13:18 | call_vertical_spread | 2 | 1 | 7 | 104230.00 | short | bid | 319.0550 | 7.0000 | ["250","260"] | ["0.6611","0.6536"] | ["257.80"] | ["XMIO"] | 250.0000 | 260.0000 | 63 | 63 | false | false | false | ||||||||||
| 01a0aa9b-d503-7be2-970f-ee6973058e70 | NET | 2026-09-16 10:25 | call_vertical_spread | 2 | 1 | 4 | 199048.00 | short | bid | 330.9600 | 5.8000 | ["80","85"] | ["8.2431","7.9598"] | ["84.98"] | ["XCBO"] | 80.0000 | 85.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0aa98-71d3-71c2-afe5-e235139debb7 | NET | 2026-09-16 10:21 | call_vertical_spread | 2 | 1 | 2 | 100172.00 | short | bid | 332.5650 | 6.7500 | ["80","85"] | ["8.3137","8.0269"] | ["84.98"] | ["XCBO"] | 80.0000 | 85.0000 | 2 | 2 | false | false | false | ||||||||||
| 01a0a694-078d-7840-a64f-9c78fbce3b3e | NET | 2026-09-15 15:38 | call_vertical_spread | 2 | 1 | 10 | 165308.00 | short | bid | 326.7200 | 6.6000 | ["250","260"] | ["0.6981","0.6888"] | ["257.89"] | ["XMIO"] | 250.0000 | 260.0000 | 66 | 66 | false | false | false | ||||||||||
| 01a0a677-adbe-7082-8eee-77d1d7745e2a | NET | 2026-09-15 15:07 | call_vertical_spread | 2 | 1 | 9 | 151180.00 | short | bid | 328.0950 | 3.7000 | ["250","260"] | ["0.7035","0.6938"] | ["257.92"] | ["XCBO"] | 250.0000 | 260.0000 | 66 | 66 | false | false | false | ||||||||||
| 01a0a676-abee-7cc1-9e49-6a318e9809b7 | NET | 2026-09-15 15:06 | call_vertical_spread | 2 | 2 | 6 | 100806.00 | short | bid | 328.3100 | 4.8500 | ["250","260"] | ["0.6974","0.6897"] | ["257.88"] | ["ARCO","XISX"] | 250.0000 | 260.0000 | 66 | 66 | false | false | false | ||||||||||
| 01a0a610-b65e-7140-b0d1-6a384c2439aa | NET | 2026-09-15 13:15 | call_vertical_spread | 2 | 1 | 3 | 138741.00 | short | bid | 333.5550 | 5.4000 | ["100","105"] | ["5.2044","5.0342"] | ["104.99"] | ["XCBO"] | 100.0000 | 105.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5ec-1376-7ce2-a799-87449c7ef1d8 | NET | 2026-09-15 12:35 | call_vertical_spread | 2 | 1 | 3 | 147075.00 | short | bid | 332.8200 | 6.4500 | ["85","90"] | ["8.4357","7.3108"] | ["89.99"] | ["XCBO"] | 85.0000 | 90.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5db-eea6-72c2-9be5-b68044c6d8e4 | NET | 2026-09-15 12:17 | call_vertical_spread | 2 | 1 | 3 | 113145.00 | short | bid | 331.0000 | 6.4500 | ["140","145"] | ["3.1796","3.1368"] | ["144.99"] | ["XCBO"] | 140.0000 | 145.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a5b5-4436-7011-8987-993198aa0190 | NET | 2026-09-15 11:35 | call_vertical_spread | 2 | 1 | 7 | 343315.00 | short | bid | 327.6300 | 5.5500 | ["80","85"] | ["5.5874","5.4184"] | ["84.99"] | ["XCBO"] | 80.0000 | 85.0000 | 3 | 3 | false | false | false | ||||||||||
| 01a0a052-64d0-7f82-aee0-9aed9daa9f22 | NET | 2026-09-14 10:29 | call_vertical_spread | 2 | 2 | 150 | 810750.00 | short | bid | 323.4175 | 2.4500 | ["310","320"] | ["0.5812","0.5832"] | ["315.25"] | ["AMXO"] | 310.0000 | 320.0000 | 32 | 32 | false | false | false | ||||||||||
| 01a0a04f-ec00-7ff1-8fb8-b9cbcd644e20 | NET | 2026-09-14 10:26 | call_vertical_spread | 2 | 1 | 150 | 801000.00 | short | bid | 322.8250 | 4.8000 | ["310","320"] | ["0.5736","0.5921"] | ["314.60"] | ["SPHR"] | 310.0000 | 320.0000 | 32 | 32 | false | false | false | ||||||||||
| 01a08bb3-ad40-70a0-90cf-1fc1a5c98676 | NET | 2026-09-10 10:23 | call_vertical_spread | 2 | 1 | 45 | 199485.00 | short | bid | 314.5650 | 4.1500 | ["310","315"] | ["0.5859","0.5858"] | ["312.45"] | ["XMIO"] | 310.0000 | 315.0000 | 29 | 29 | false | false | false | ||||||||||
| 01a08bb3-ad40-70a0-90cf-1fbb359e1305 | NET | 2026-09-10 10:23 | call_vertical_spread | 2 | 2 | 90 | 398520.00 | short | bid | 314.5650 | 3.7500 | ["310","315"] | ["0.5845","0.5858"] | ["312.40"] | ["AMXO"] | 310.0000 | 315.0000 | 29 | 29 | false | false | false | ||||||||||
| 01a08bb3-ad40-70a0-90cf-1fad31158bc8 | NET | 2026-09-10 10:23 | call_vertical_spread | 2 | 2 | 44 | 194920.00 | short | bid | 314.5650 | 2.4000 | ["310","315"] | ["0.5848","0.5861"] | ["312.40"] | ["C2OX"] | 310.0000 | 315.0000 | 29 | 29 | false | false | false | ||||||||||
| 01a08bb3-4f80-7262-9912-4304b623e7b5 | NET | 2026-09-10 10:22 | call_vertical_spread | 2 | 1 | 225 | 993375.00 | short | bid | 314.7400 | 5.5000 | ["310","315"] | ["0.5776","0.5834"] | ["312.25"] | ["SPHR"] | 310.0000 | 315.0000 | 29 | 29 | true | false | false | ||||||||||
| 01a08669-fa60-7100-ac50-3e57d9af9f02 | NET | 2026-09-09 09:44 | call_vertical_spread | 2 | 1 | 170 | 829260.00 | short | bid | 303.7300 | 4.9500 | ["320","400"] | ["0.6356","0.6355"] | ["341.02"] | ["AMXO"] | 320.0000 | 400.0000 | 100 | 100 | false | true | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:57:47Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:53:03Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T16:09:24Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:55:56Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T14:46:56Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T18:20:29Z"} |
| 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-21T18:02:03Z"} |
| 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-21T14:40:07Z"} |
| 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-21T13:30:04Z"} |
| 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-18T19:15:53Z"} |
| 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-18T17:18: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-16T14:25:37Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T14:22:03Z"} |
| 2026-09-16 |
| 2026-09-16 17:15 |
| 2026-09-16 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:38:54Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T19:08:15Z"} |
| 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-15T19:06:34Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T17:15:24Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:35:51Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T16:18:11Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T15:35:25Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:29:27Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-14T14:26:31Z"} |
| 2026-09-14 |
| 2026-09-14 17:15 |
| 2026-09-14 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:23:42Z"} |
| 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-10T14:23:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mesl |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:23:42Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T14:23:11Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-09T13:45:06Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |