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 |
|---|
| 01a0c476-711f-76b0-b62e-a85d63a5ee13 | GDX | 2026-09-21 10:54 | call_vertical_spread | 2 | 1 | 200 | 196800.00 | short | bid | 94.2150 | 2.5500 | ["170","200"] | ["0.4749","0.4892"] | ["171.96"] | ["XMIO"] | 170.0000 | 200.0000 | 487 | 487 | false | true | false | true | false | mlat | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-21T14:54:54Z"} | 2026-09-21 | 2026-09-21 17:15 | 2026-09-21 17:15 |
| 01a0b5f5-af30-7f21-800c-e5a5dbaf5ec9 | GDX | 2026-09-18 15:19 | call_vertical_spread | 2 | 1 | 67 | 780282.00 | long | ask | 95.2900 | 7.6000 | ["35","40"] | ["1.4982","1.3276"] | ["39.96"] | ["XCBO"] | 35.0000 | 40.0000 | 42 | 42 | false | false | false | ||||||||||
| 01a0b5dd-2207-72e0-91bb-58d18afc35a7 | GDX | 2026-09-18 14:52 | call_vertical_spread | 2 | 1 | 46 | 625278.00 | short | bid | 95.3450 | 5.3000 | ["25","30"] | ["1.4289","1.3461"] | ["29.97"] | ["XCBO"] | 25.0000 | 30.0000 | 35 | 35 | false | false | false | ||||||||||
| 01a0b583-2eb0-7691-906e-263e6817375f | GDX | 2026-09-18 13:14 | call_vertical_spread | 2 | 1 | 7000 | 1624004.00 | unknown | bid | 95.5000 | 0.2000 | ["97","100"] | ["0.4178","0.4277"] | ["99.32"] | ["EDGO"] | 97.0000 | 100.0000 | 7 | 7 | false | true | false | ||||||||||
| 01a0b57a-ba9f-7b43-a6e3-698f929805ba | GDX | 2026-09-18 13:05 | call_vertical_spread | 2 | 1 | 6385 | 1474936.00 | short | bid | 95.5000 | 0.2300 | ["97","100"] | ["0.4159","0.4277"] | ["97.83"] | ["EDGO"] | 97.0000 | 100.0000 | 7 | 7 | false | true | false | ||||||||||
| 01a0b0a9-780a-7ab3-83dd-348f69ad875b | GDX | 2026-09-17 14:38 | call_vertical_spread | 2 | 1 | 9777 | 117324.00 | long | ask | 95.7850 | 0.0300 | ["99","103"] | ["0.4810","0.5919"] | ["99.10"] | ["MCRY"] | 99.0000 | 103.0000 | 1 | 1 | false | true | false | ||||||||||
| 01a0b081-a0d3-7e81-9f6e-1d8186279670 | GDX | 2026-09-17 13:54 | call_vertical_spread | 2 | 1 | 21 | 190869.00 | unknown | — | 95.8250 | 2.4000 | ["50","51"] | ["5.7292","5.6400"] | [] | ["XCBO"] | 50.0000 | 51.0000 | 1 | 1 | false | false | false | true | false | ||||||||
| 01a0b027-6efb-7632-8b43-880fb3f252d9 | GDX | 2026-09-17 12:16 | call_vertical_spread | 2 | 1 | 53 | 304167.00 | unknown | — | 95.9550 | 4.5000 | ["65","70"] | ["0.7233","0.6428"] | [] | ["XCBO"] | 65.0000 | 70.0000 | 22 | 22 | false | false | false | true | false | ||||||||
| 01a0b01b-a373-7a12-a53a-cacbd7a7b2f9 | GDX | 2026-09-17 12:03 | call_vertical_spread | 2 | 1 | 10000 | 2120000.00 | unknown | — | 96.4650 | 0.3300 | ["99","103"] | ["0.4422","0.4572"] | [] | ["EDGO"] | 99.0000 | 103.0000 | 8 | 8 | true | true | false | true | false | ||||||||
| 01a0aff4-aecb-7882-9679-0105744fc647 | GDX | 2026-09-17 11:20 | call_vertical_spread | 2 | 1 | 10 | 137400.00 | long | ask | 96.0500 | 4.9000 | ["25","30"] | ["2.3276","2.0501"] | ["29.98"] | ["XCBO"] | 25.0000 | 30.0000 | 22 | 22 | false | false | false | ||||||||||
| 01a0afee-3e5b-7871-a035-8a2bf6aabf30 | GDX | 2026-09-17 11:13 | call_vertical_spread | 2 | 1 | 10000 | 2403002.00 | unknown | — | 95.9600 | 0.2600 | ["98","102"] | ["0.4480","0.4610"] | [] | ["EDGO"] | 98.0000 | 102.0000 | 8 | 8 | true | true | false | true | false | ||||||||
| 01a0afa8-6b5b-75f0-904e-ab301a4984f2 | GDX | 2026-09-17 09:57 | call_vertical_spread | 2 | 1 | 18 | 103428.00 | long | ask | 95.7800 | 3.4000 | ["66","67"] | ["4.0393","4.0325"] | ["66.98"] | ["XCBO"] | 66.0000 | 67.0000 | 1 | 1 | false | false | false | ||||||||||
| 01a0ab5e-80f4-7041-8ab0-777dd8c06a5c | GDX | 2026-09-16 13:58 | call_vertical_spread | 2 | 1 | 12 | 149280.00 | long | ask | 94.4400 | 6.6000 | ["30","35"] | ["2.1678","1.9057"] | ["34.98"] | ["XCBO"] | 30.0000 | 35.0000 | 23 | 23 | false | false | false | ||||||||||
| 01a0aae2-b1a3-7da2-beca-2e1977b3b905 | GDX | 2026-09-16 11:42 | call_vertical_spread | 2 | 1 | 18 | 169596.00 | unknown | — | 94.6450 | 1.7500 | ["47","48"] | ["5.3314","5.1889"] | [] | ["XCBO"] | 47.0000 | 48.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a0aae0-ae03-7f72-8f00-2d3493743823 | GDX | 2026-09-16 11:40 | call_vertical_spread | 2 | 1 | 15 | 168030.00 | unknown | — | 94.6559 | 2.3500 | ["38","39"] | ["6.8871","6.7084"] | [] | ["XCBO"] | 38.0000 | 39.0000 | 2 | 2 | false | false | false | true | false | ||||||||
| 01a0a661-669e-7741-b0e2-b3eda64b74cc | GDX | 2026-09-15 14:43 | call_vertical_spread | 2 | 1 | 250 | 167000.00 | unknown | — | 93.9800 | 0.3000 | ["105","107"] | ["0.4551","0.4561"] | [] | ["XCBO"] | 105.0000 | 107.0000 | 66 | 66 | false | true | false | true | false | ||||||||
| 01a0a557-de0d-7882-a598-ad2fae2f2d4e | GDX | 2026-09-15 09:53 | call_vertical_spread | 2 | 1 | 85 | 115940.00 | unknown | — | 94.0900 | 0.5000 | ["95","105"] | ["0.4509","0.4548"] | [] | ["EDGO"] | 95.0000 | 105.0000 | 94 | 94 | false | true | false | true | false | ||||||||
| 01a0a08a-4969-79a3-830b-8c0b92374f21 | GDX | 2026-09-14 11:30 | call_vertical_spread | 2 | 1 | 1000 | 375000.00 | long | ask | 93.9250 | 0.2600 | ["100","110"] | ["0.4531","0.4686"] | ["101.87"] | ["XPHO"] | 100.0000 | 110.0000 | 32 | 32 | false | true | false | ||||||||||
| 01a090c5-6031-78f0-8ee5-640cf6667c64 | GDX | 2026-09-11 10:00 | call_vertical_spread | 2 | 1 | 8430 | 2082210.00 | short | bid | 98.6350 | 0.4500 | ["101","105"] | ["0.4942","0.5061"] | ["101.99"] | ["AMXO"] | 101.0000 | 105.0000 | 7 | 7 | false | true | false | ||||||||||
| 01a090bf-1ea1-7821-bab5-1f9476ab5b22 | GDX | 2026-09-11 09:53 | call_vertical_spread | 2 | 1 | 9700 | 2298900.00 | unknown | — | 98.6100 | 0.3300 | ["101","105"] | ["0.4845","0.4968"] | [] | ["EDGO"] | 101.0000 | 105.0000 | 7 | 7 | false | true | false | true | false | ||||||||
| 01a08ce7-2fe9-7212-9209-f20ff1a76a49 | GDX | 2026-09-10 15:59 | call_vertical_spread | 2 | 1 | 13000 | 182000.00 | unknown | — | 96.0050 | 0.0400 | ["101","104"] | ["0.6768","0.7055"] | [] | ["EDGO"] | 101.0000 | 104.0000 | 1 | 1 | false | true | false | true | false | ||||||||
| 01a08ca1-6c89-7462-bb7f-c4858f824788 | GDX | 2026-09-10 14:43 | call_vertical_spread | 2 | 1 | 9900 | 2593798.00 | short | bid | 96.3800 | 0.2800 | ["99","103"] | ["0.5056","0.5103"] | ["100.02"] | ["EDGO"] | 99.0000 | 103.0000 | 8 | 8 | true | true | false | ||||||||||
| 01a06d9d-7bed-73e1-812f-4218e0353698 | GDX | 2026-09-04 14:10 | call_vertical_spread | 2 | 1 | 5000 | 1043040.00 | unknown | — | 99.2909 | 0.1900 | ["101","104"] | ["0.3917","0.3977"] | [] | ["EDGO"] | 101.0000 | 104.0000 | 7 | 7 | false | true | false | true | false |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T19:19:45Z"} |
| 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-18T18:52:57Z"} |
| 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-18T17:14:48Z"} |
| 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-18T17:05:23Z"} |
| 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-17T18:38:57Z"} |
| 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-17T17:55:04Z"} |
| 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-17T16:16:34Z"} |
| 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-17T16:03:29Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:21:15Z"} |
| 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-17T15:13:42Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T13:57:40Z"} |
| 2026-09-17 |
| 2026-09-17 17:15 |
| 2026-09-17 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:58:39Z"} |
| 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-16T15:43:16Z"} |
| 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-16T15:41:10Z"} |
| 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:44:19Z"} |
| 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-15T13:53:31Z"} |
| 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-14T15:30:30Z"} |
| 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-11T14:01: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-11T13:54:07Z"} |
| 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-10T19:59:25Z"} |
| 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-10T18:43:02Z"} |
| 2026-09-10 |
| 2026-09-10 17:15 |
| 2026-09-10 17:15 |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-04T18:10:48Z"} |
| 2026-09-04 |
| 2026-09-07 00:53 |
| 2026-09-07 00:53 |