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 | net_side |
|---|
| 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 |
|---|
| 01a06d6c-c72d-7c81-9172-545f0de7e3ae | EWZ | 2026-09-04 13:17 | call_calendar | 2 | 1 | 5000 | 3045000.00 | long | bid | 38.0350 | 0.1400 | ["37"] | ["0.3929"] | [] | ["XBOX"] | 37.0000 | 37.0000 | 42 | 77 | false | false | true | false | false | mlft | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-04T17:17:57Z"} | 2026-09-04 | 2026-09-07 00:53 | 2026-09-07 00:53 |
| 01a08143-40a0-7cf1-b67f-cf053338f20b | EWZ | 2026-09-08 09:44 | call_vertical_spread | 2 | 1 | 20000 | 3300000.00 | short | bid | 38.9550 | 0.0900 | ["46","50"] | ["0.3859","0.3936"] | ["46.53"] | ["AMXO"] | 46.0000 | 50.0000 | 101 | 101 | false | true | false | true | |||||||||
| 01a08205-1d88-70d1-8d59-c68045f7deda | EWZ | 2026-09-08 13:16 | call_diagonal_spread | 2 | 1 | 150 | 162450.00 | short | bid | 38.5895 | 0.8500 | ["35","40"] | ["0.2643","0.3219"] | [] | ["SPHR"] | 35.0000 | 40.0000 | 192 | 500 | false | false | true | true | |||||||||
| 01a08c5e-8b71-7753-924f-aa0bdcac39f8 | EWZ | 2026-09-10 13:29 | call_vertical_spread | 2 | 1 | 8300 | 672300.00 | short | bid | 38.7350 | 0.2800 | ["41","42"] | ["0.3358","0.3391"] | ["41.19"] | ["EDGO"] | 41.0000 | 42.0000 | 22 | 22 | false | true | false | true | |||||||||
| 01a090b6-cdb8-70b1-9738-021f57c94a4c | EWZ | 2026-09-11 09:44 | call_vertical_spread | 2 | 1 | 3000 | 189000.00 | short | bid | 38.4300 | 0.8900 | ["44","45"] | ["0.4432","0.4522"] | ["44.09"] | ["XMIO"] | 44.0000 | 45.0000 | 28 | 28 | true | true | false | true | |||||||||
| 01a090bc-6b38-7882-86e8-98802f6bbad9 | EWZ | 2026-09-11 09:51 | call_vertical_spread | 2 | 1 | 7000 | 301000.00 | short | bid | 38.4300 | 0.3500 | ["44","45"] | ["0.4012","0.4005"] | ["44.09"] | ["XMIO"] | 44.0000 | 45.0000 | 28 | 28 | true | true | false | true | |||||||||
| 01a0910d-b3d0-7990-bbb5-730b6d5f85b3 | EWZ | 2026-09-11 11:19 | call_vertical_spread | 2 | 2 | 2100 | 905100.00 | short | bid | 38.3400 | 0.0800 | ["40","41"] | ["0.4346","0.4367"] | ["40.35"] | ["AMXO"] | 40.0000 | 41.0000 | 70 | 70 | false | true | false | true | |||||||||
| 01a091c6-a390-7982-9d3d-f41bd219ef0a | EWZ | 2026-09-11 14:41 | call_vertical_spread | 2 | 1 | 1000 | 120000.00 | short | bid | 37.9250 | 0.0500 | ["46","50"] | ["0.3883","0.3857"] | ["46.46"] | ["XCBO"] | 46.0000 | 50.0000 | 98 | 98 | false | true | false | true | |||||||||
| 01a0a54c-454f-7da0-ab64-444cba20eab1 | EWZ | 2026-09-15 09:40 | jelly_roll | 4 | 1 | 375 | 385875.00 | short | bid | 37.7600 | 0.9100 | ["40"] | ["0.4377"] | [] | ["XPHO"] | 40.0000 | 40.0000 | 31 | 66 | false | false | true | false | true | ||||||||
| 01a0a580-4d9e-7d83-abc1-fb746d8055a1 | EWZ | 2026-09-15 10:37 | risk_reversal | 3 | 2 | 6200 | 2641200.00 | long | bid | 37.8000 | 0.0900 | ["32","40","42"] | ["0.4544","0.4534","0.4497"] | ["31.98"] | ["ARCO"] | 32.0000 | 42.0000 | 66 | 66 | false | true | false | true | |||||||||
| 01a0aa7e-e6c3-7a90-aedf-bf2496ab0083 | EWZ | 2026-09-16 09:53 | ratio_risk_reversal | 2 | 1 | 3000 | 163199.00 | long | bid | 37.4300 | 0.0600 | ["38","43"] | ["0.4270","0.4292"] | ["43.13"] | ["XMIO"] | 38.0000 | 43.0000 | 30 | 30 | false | false | false | true | |||||||||
| 01a0b065-3f33-7181-99ad-63868e5c8d88 | EWZ | 2026-09-17 13:23 | call_diagonal_spread | 2 | 2 | 4000 | 568000.00 | short | bid | 37.7004 | 0.0400 | ["41","45"] | ["0.4275","0.4359"] | [] | ["AMXO"] | 41.0000 | 45.0000 | 29 | 64 | false | true | true | true | |||||||||
| 01a0b07c-16db-70a1-b439-8600abffae95 | EWZ | 2026-09-17 13:48 | call_vertical_spread | 2 | 1 | 1000 | 108000.00 | short | bid | 37.7850 | 0.0400 | ["46","50"] | ["0.3936","0.3882"] | ["46.44"] | ["AMXO"] | 46.0000 | 50.0000 | 92 | 92 | false | true | false | true | |||||||||
| 01a0b0f3-2b3b-7320-8516-f27226ae5ff8 | EWZ | 2026-09-17 15:58 | synthetic | 2 | 2 | 263 | 148595.00 | long | bid | 37.7200 | 0.0900 | ["38"] | ["0.4490"] | ["37.99"] | ["XCBO"] | 38.0000 | 38.0000 | 64 | 64 | false | false | false | false | true | ||||||||
| 01a0b4f5-274f-7c21-994a-262f803bb407 | EWZ | 2026-09-18 10:39 | call_vertical_spread | 2 | 2 | 4400 | 902000.00 | unknown | bid | 37.2600 | 0.0500 | ["41","45"] | ["0.4450","0.4319"] | ["43.05"] | ["ARCO"] | 41.0000 | 45.0000 | 63 | 63 | false | true | false | true | |||||||||
| 01a0b546-9ec8-7961-a462-197f4c33ebc1 | EWZ | 2026-09-18 12:08 | call_vertical_spread | 2 | 4 | 4600 | 991300.00 | short | bid | 37.3800 | 0.0650 | ["41","45"] | ["0.4489","0.4364"] | ["41.90"] | ["ARCO"] | 41.0000 | 45.0000 | 63 | 63 | false | true | false | true | |||||||||
| 01a0b552-1847-7021-8a7b-edaf27a8c570 | EWZ | 2026-09-18 12:20 | put_calendar | 2 | 1 | 26 | 117806.00 | unknown | bid | 37.4200 | 7.7750 | ["60"] | ["0.7136"] | [] | ["XISX"] | 60.0000 | 60.0000 | 63 | 91 | true | false | true | false | false | ||||||||
| 01a0b5f5-3de7-78b2-9854-e50e24781cec | EWZ | 2026-09-18 15:19 | call_vertical_spread | 2 | 1 | 4750 | 522500.00 | unknown | bid | 37.4950 | 0.1400 | ["40.5","41"] | ["0.4477","0.4494"] | ["41.30"] | ["EDGO"] | 40.5000 | 41.0000 | 21 | 21 | false | true | false | true | |||||||||
| 01a0b5f5-5d27-7010-b4a1-42ce6ca485bd | EWZ | 2026-09-18 15:19 | call_vertical_spread | 2 | 1 | 4750 | 527250.00 | unknown | bid | 37.4950 | 0.1400 | ["40.5","41"] | ["0.4511","0.4494"] | ["41.30"] | ["EDGO"] | 40.5000 | 41.0000 | 21 | 21 | false | true | false | true | |||||||||
| 01a0c429-52f3-7b10-a935-c6c6ed06b6e0 | EWZ | 2026-09-21 09:30 | call_vertical_spread | 2 | 3 | 239 | 176382.00 | short | bid | 37.9600 | 0.4500 | ["34","40"] | ["0.4634","0.4623"] | ["37.18"] | ["EDGO"] | 34.0000 | 40.0000 | 60 | 60 | false | false | false | true | |||||||||
| 01a0c430-e857-77f1-bb1e-1a0746bb5021 | EWZ | 2026-09-21 09:38 | call_butterfly_spread | 3 | 1 | 3000 | 675000.00 | short | bid | 37.9400 | 0.1300 | ["40","46","51"] | ["0.3630","0.3600","0.3545"] | ["41.02","50.98"] | ["XPHO"] | 40.0000 | 51.0000 | 116 | 116 | false | true | false | true | |||||||||
| 01a0c445-eb3f-7272-88eb-a67d2624da55 | EWZ | 2026-09-21 10:01 | strangle | 2 | 1 | 1250 | 110000.00 | short | bid | 37.7650 | 0.0700 | ["37","38.5"] | ["0.3221","0.3176"] | ["36.12","39.38"] | ["AMXO"] | 37.0000 | 38.5000 | 9 | 9 | false | true | false | true | |||||||||
| 01a0c4b9-bbaf-79d0-9738-0f8acde349dc | EWZ | 2026-09-21 12:08 | other | 4 | 1 | 1500 | 759000.00 | unknown | bid | 38.0000 | 0.0600 | ["40","42"] | ["0.4536","0.4488"] | [] | ["XPHO"] | 40.0000 | 42.0000 | 25 | 60 | false | true | true | true | false | ||||||||
| 01a0c570-711e-7f00-a73a-045df90ccd91 | EWZ | 2026-09-21 15:27 | call_vertical_spread | 2 | 1 | 2170 | 425320.00 | unknown | bid | 38.0750 | 0.0300 | ["39","42"] | ["0.4533","0.4383"] | ["40.96"] | ["XISX"] | 39.0000 | 42.0000 | 25 | 25 | false | true | false | true | |||||||||
| 01a0c95b-e7d7-7ee1-aea5-4400842c599f | EWZ | 2026-09-22 09:43 | call_vertical_spread | 2 | 1 | 1758 | 167010.00 | unknown | bid | 37.8050 | 0.0700 | ["46","50"] | ["0.3912","0.3798"] | ["46.95"] | ["AMXO"] | 46.0000 | 50.0000 | 87 | 87 | false | true | false | true | |||||||||
| 01a0c95d-feff-7431-b783-1c85c1ba46a3 | EWZ | 2026-09-22 09:46 | call_vertical_spread | 2 | 1 | 5000 | 285000.00 | unknown | bid | 37.8495 | 0.0600 | ["42","45"] | ["0.4431","0.4222"] | ["42.57"] | ["EDGO"] | 42.0000 | 45.0000 | 24 | 24 | false | true | false | true | |||||||||
| 01a0c9b0-551e-7492-8013-ce926d164a79 | EWZ | 2026-09-22 11:16 | call_vertical_spread | 2 | 1 | 500 | 170000.00 | unknown | bid | 37.8350 | 0.0200 | ["40","42"] | ["0.4639","0.4571"] | ["42.70"] | ["EDGO"] | 40.0000 | 42.0000 | 59 | 59 | false | true | false | true | |||||||||
| 01a0ca3b-d027-7a93-80b8-900db664d2b4 | EWZ | 2026-09-22 13:48 | call_vertical_spread | 2 | 1 | 2500 | 547500.00 | unknown | bid | 37.9550 | 0.1000 | ["43","47"] | ["0.3619","0.3572"] | ["45.19"] | ["AMXO"] | 43.0000 | 47.0000 | 115 | 115 | false | true | false | true | |||||||||
| 01a0ca4a-faf6-72f1-82dc-c6db2c1f4984 | EWZ | 2026-09-22 14:05 | call_ratio_spread | 2 | 2 | 750 | 212000.00 | unknown | bid | 38.0600 | 0.0300 | ["40","42"] | ["0.4608","0.4525"] | ["42.90"] | ["AMXO"] | 40.0000 | 42.0000 | 59 | 59 | false | true | false | true |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T13:44:28Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-08T17:16:16Z"} |
| 2026-09-08 |
| 2026-09-08 21:50 |
| 2026-09-08 21:50 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-10T17:30:14Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:44:55Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T13:51:12Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T15:19:52Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-11T18:42:00Z"} |
| 2026-09-11 |
| 2026-09-11 17:15 |
| 2026-09-11 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T13:40:48Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-15T14:37:22Z"} |
| 2026-09-15 |
| 2026-09-15 19:28 |
| 2026-09-15 19:28 |
| mlat |
| market_whale |
| 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 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:24:06Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T17:49:18Z"} |
| 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-17T19:58:50Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T14:39:42Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T16:08:19Z"} |
| 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-18T16:21:23Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:19:22Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:19:22Z"} |
| 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-21T13:30:23Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T13:39:01Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T14:02:06Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:08:24Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T19:28:20Z"} |
| 2026-09-21 |
| 2026-09-21 17:15 |
| 2026-09-21 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:44:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T13:46:25Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T15:16:13Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T17:49:09Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-22T18:05:28Z"} |
| 2026-09-22 |
| 2026-09-22 17:15 |
| 2026-09-22 17:15 |