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 |
|---|
| 01a0d3f4-337e-78e0-b044-e6ea181680f9 | GDX | 2026-09-24 11:06 | call_vertical_spread | 2 | 1 | 100 | 256400.00 | long | ask | 91.2900 | 1.7000 | ["91","100"] | ["0.4249","0.4281"] | ["94.52"] | ["XMIO"] | 91.0000 | 100.0000 | 266 | 266 | false | false | false | true | false | mlet | market_whale | uw_multileg | /api/option-trades/multi-leg | {"limit":500,"older_than":"2026-09-24T15:06:32Z"} | 2026-09-24 | 2026-09-24 17:15 | 2026-09-24 17:15 |
| 01a0cf7f-261e-7d32-8b5c-4a3a04be0b6d | GDX | 2026-09-23 14:20 | call_vertical_spread | 2 | 1 | 300 | 277500.00 | long | ask | 94.1599 | 0.5900 | ["100","120"] | ["0.4173","0.4356"] | ["104.49"] | ["XPHO"] | 100.0000 | 120.0000 | 114 | 114 | false | true | false | ||||||||||
| 01a0cea5-219f-7cb1-83e4-cbc740b2fd60 | GDX | 2026-09-23 10:22 | call_vertical_spread | 2 | 1 | 10000 | 110000.00 | long | ask | 93.1900 | 0.0700 | ["99","103"] | ["0.5281","0.5552"] | ["99.09"] | ["EDGO"] | 99.0000 | 103.0000 | 2 | 2 | false | true | false | ||||||||||
| 01a0c4bb-55d7-71d2-943d-d4d75dcbf71b | GDX | 2026-09-21 12:10 | call_vertical_spread | 2 | 1 | 9 | 102843.00 | long | ask | 94.4090 | 7.6000 | ["35","40"] | ["2.0747","1.8502"] | ["39.97"] | ["XISX"] | 35.0000 | 40.0000 | 18 | 18 | false | false | false | ||||||||||
| 01a0c4bb-32af-7ab2-94d9-25cb7713f078 | GDX | 2026-09-21 12:09 | call_vertical_spread | 2 | 1 | 10 | 114270.00 | long | ask | 94.4150 | 7.6000 | ["35","40"] | ["2.0622","1.8401"] | ["39.97"] | ["XISX"] | 35.0000 | 40.0000 | 18 | 18 | false | false | false | ||||||||||
| 01a0b604-93af-7823-a77a-7f6b261bd8e1 | GDX | 2026-09-18 15:35 | call_vertical_spread | 2 | 1 | 16 | 217024.00 | long | ask | 95.2727 | 7.0000 | ["25","30"] | ["4.9708","2.0422"] | ["29.98"] | ["XPHO"] | 25.0000 | 30.0000 | 14 | 14 | false | false | false | ||||||||||
| 01a0b5ff-fbe8-74a0-a938-43cefdfe9e98 | GDX | 2026-09-18 15:30 | call_vertical_spread | 2 | 1 | 17 | 163200.00 | long | ask | 95.3150 | 3.7000 | ["45","50"] | ["1.6112","0.7302"] | ["49.96"] | ["XPHO"] | 45.0000 | 50.0000 | 35 | 35 | false | false | false | ||||||||||
| 01a0b5f9-c9f8-72a3-b039-b53221428c3d | GDX | 2026-09-18 15:23 | call_vertical_spread | 2 | 1 | 18 | 208800.00 | long | ask | 95.3050 | 5.3000 | ["35","40"] | ["1.0229","0.9796"] | ["39.96"] | ["XPHO"] | 35.0000 | 40.0000 | 42 | 42 | false | false | false | ||||||||||
| 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 | ||||||||||
| 01a0b59f-9c07-7d21-b78c-16a0db7ac9bb | GDX | 2026-09-18 13:45 | call_vertical_spread | 2 | 1 | 5000 | 2815000.00 | long | ask | 95.7950 | 0.3600 | ["110","125"] | ["0.4431","0.4621"] | ["112.25"] | ["AMXO"] | 110.0000 | 125.0000 | 91 | 91 | false | true | false | ||||||||||
| 01a0b59f-3a60-7182-aa30-b8d6bbd3ee46 | GDX | 2026-09-18 13:45 | call_vertical_spread | 2 | 1 | 5000 | 2815000.00 | long | ask | 95.7850 | 0.3600 | ["110","125"] | ["0.4433","0.4622"] | ["112.25"] | ["AMXO"] | 110.0000 | 125.0000 | 91 | 91 | false | true | false | ||||||||||
| 01a0b589-31c0-7be1-918a-e4dae02af960 | GDX | 2026-09-18 13:20 | call_vertical_spread | 2 | 1 | 530 | 113420.00 | long | ask | 95.4100 | 0.3100 | ["97","101"] | ["0.4250","0.4353"] | ["98.02"] | ["XBOX"] | 97.0000 | 101.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 | ||||||||||
| 01a0aff5-1073-7880-99c6-7f41f0dba9d6 | GDX | 2026-09-17 11:21 | call_vertical_spread | 2 | 1 | 10 | 137330.00 | long | ask | 95.9450 | 4.8000 | ["25","30"] | ["2.5115","2.2226"] | ["29.97"] | ["XPHO"] | 25.0000 | 30.0000 | 22 | 22 | false | false | false | ||||||||||
| 01a0aff4-d1f3-7203-96f2-fd88cd562df1 | GDX | 2026-09-17 11:20 | call_vertical_spread | 2 | 1 | 10 | 137390.00 | long | ask | 96.0000 | 4.9000 | ["25","30"] | ["2.4491","2.1726"] | ["29.97"] | ["XPHO"] | 25.0000 | 30.0000 | 22 | 22 | false | false | 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 | ||||||||||
| 01a0aff3-bc9b-7a70-bf4d-af009a355a2c | GDX | 2026-09-17 11:19 | call_vertical_spread | 2 | 1 | 15 | 206115.00 | long | ask | 96.2000 | 4.9000 | ["25","30"] | ["3.6239","3.1847"] | ["29.97"] | ["XISX"] | 25.0000 | 30.0000 | 22 | 22 | false | false | 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 | ||||||||||
| 01a0ab4c-1a03-78c0-8c22-ab102965e7d6 | GDX | 2026-09-16 13:38 | call_vertical_spread | 2 | 1 | 56 | 696360.00 | long | ask | 94.3550 | 6.5000 | ["30","35"] | ["2.2576","1.9959"] | ["34.97"] | ["EDGO"] | 30.0000 | 35.0000 | 23 | 23 | false | false | false | ||||||||||
| 01a0ab35-425b-7871-a270-5924486b4739 | GDX | 2026-09-16 13:13 | call_vertical_spread | 2 | 1 | 46 | 481850.00 | long | ask | 94.0800 | 5.8000 | ["40","45"] | ["2.0968","1.8501"] | ["44.97"] | ["XPHO"] | 40.0000 | 45.0000 | 23 | 23 | false | false | false | ||||||||||
| 01a0a649-910e-7f12-b239-e694a40964ee | GDX | 2026-09-15 14:17 | call_vertical_spread | 2 | 1 | 25 | 307225.00 | long | ask | 93.8600 | 7.0000 | ["30","35"] | ["1.8770","1.7870"] | ["34.97"] | ["XMIO"] | 30.0000 | 35.0000 | 17 | 17 | false | false | false | ||||||||||
| 01a0a628-3215-77f0-a6a7-6476a098a566 | GDX | 2026-09-15 13:40 | call_vertical_spread | 2 | 1 | 12 | 134868.00 | long | ask | 93.6500 | 5.5500 | ["35","40"] | ["3.2180","2.8507"] | ["39.97"] | ["EDGO"] | 35.0000 | 40.0000 | 17 | 17 | false | false | false | ||||||||||
| 01a0a5c0-c96e-7ea0-a1f6-3489e4b04dd9 | GDX | 2026-09-15 11:47 | call_vertical_spread | 2 | 1 | 50 | 557750.00 | long | ask | 93.1380 | 6.6000 | ["35","40"] | ["1.4740","1.3488"] | ["39.97"] | ["XISX"] | 35.0000 | 40.0000 | 24 | 24 | false | false | false | ||||||||||
| 01a0a582-e996-7831-ac91-d4c7b2b884e5 | GDX | 2026-09-15 10:40 | call_vertical_spread | 2 | 1 | 53 | 544363.00 | long | ask | 93.0400 | 6.0500 | ["40","45"] | ["2.4477","2.1582"] | ["44.97"] | ["XPHO"] | 40.0000 | 45.0000 | 17 | 17 | false | false | false | ||||||||||
| 01a0a554-e456-7952-ace7-64d646e5edc2 | GDX | 2026-09-15 09:49 | call_vertical_spread | 2 | 2 | 257 | 349520.00 | long | ask | 94.0000 | 0.7000 | ["95","105"] | ["0.4514","0.4567"] | ["98.56"] | ["BATO","XISX"] | 95.0000 | 105.0000 | 94 | 94 | false | true | false | ||||||||||
| 01a0a13d-3a00-7f33-9153-1a1b7667d506 | GDX | 2026-09-14 14:45 | call_vertical_spread | 2 | 1 | 237 | 409299.00 | long | ask | 94.6050 | 0.4500 | ["92","100"] | ["0.4490","0.4521"] | ["95.49"] | ["BATO"] | 92.0000 | 100.0000 | 95 | 95 | false | false | false | ||||||||||
| 01a0a13b-ab90-7c90-bb7c-54091eef295a | GDX | 2026-09-14 14:43 | call_vertical_spread | 2 | 4 | 211 | 364608.00 | long | ask | 94.5400 | 0.4500 | ["92","100"] | ["0.4517","0.4537"] | ["95.50"] | ["XMIO"] | 92.0000 | 100.0000 | 95 | 95 | false | false | 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 | ||||||||||
| 01a08ce1-4c19-7f93-ad82-b5fc76dcac77 | GDX | 2026-09-10 15:52 | call_vertical_spread | 2 | 3 | 128 | 105579.00 | long | ask | 95.9800 | 0.1900 | ["90","100"] | ["0.5222","0.5110"] | ["95.46"] | ["EDGO","XCBO","XISX"] | 90.0000 | 100.0000 | 8 | 8 | false | false | false | ||||||||||
| 01a086b5-6ae0-74c1-bf75-717afba929de | GDX | 2026-09-09 11:07 | call_vertical_spread | 2 | 1 | 910 | 336700.00 | long | ask | 99.0000 | 0.4700 | ["108","123"] | ["0.4872","0.4959"] | ["110.28"] | ["XPHO"] | 108.0000 | 123.0000 | 37 | 37 | false | true | false |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T18:20:35Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlat |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-23T14:22:03Z"} |
| 2026-09-23 |
| 2026-09-23 17:15 |
| 2026-09-23 17:15 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-21T16:10:14Z"} |
| 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-21T16:10:14Z"} |
| 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:36:07Z"} |
| 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-18T19:30:55Z"} |
| 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-18T19:24:15Z"} |
| 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-18T19:19:45Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:45:43Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlct |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:45:17Z"} |
| 2026-09-18 |
| 2026-09-18 17:15 |
| 2026-09-18 17:15 |
| false |
| mlft |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-18T17:21:12Z"} |
| 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 |
| false |
| mlet |
| 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 |
| false |
| mlet |
| 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 |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-17T15:19:52Z"} |
| 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 |
| false |
| mlet |
| market_whale |
| uw_multileg |
| /api/option-trades/multi-leg |
| {"limit":500,"older_than":"2026-09-16T17:38:54Z"} |
| 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-16T17:13:26Z"} |
| 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-15T18:17: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-15T17:40:58Z"} |
| 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-15T15:48:16Z"} |
| 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-15T14:40:39Z"} |
| 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-15T13:50:19Z"} |
| 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-14T18:46:04Z"} |
| 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-14T18:44:16Z"} |
| 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-14T15:30:30Z"} |
| 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-10T19:52:53Z"} |
| 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-09T15:07:16Z"} |
| 2026-09-09 |
| 2026-09-09 17:15 |
| 2026-09-09 17:15 |