PREVIEW / futures_30min / 2014-07-23
file: by_date/futures_30min/2014/2014-07-23.parquet size: 70 KB rows: 2,876
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2014-07-23 00:00:00 | ES | Futures | 2058.59 | 2059.11 | 2058.59 | 2058.85 | 568.0 |
| 2014-07-23 00:30:00 | ES | Futures | 2058.85 | 2059.11 | 2058.33 | 2058.59 | 528.0 |
| 2014-07-23 01:00:00 | ES | Futures | 2058.59 | 2058.85 | 2058.33 | 2058.85 | 334.0 |
| 2014-07-23 01:30:00 | ES | Futures | 2058.85 | 2058.85 | 2057.55 | 2057.55 | 1246.0 |
| 2014-07-23 02:00:00 | ES | Futures | 2057.81 | 2059.63 | 2057.81 | 2059.37 | 2869.0 |
| 2014-07-23 02:30:00 | ES | Futures | 2059.37 | 2059.37 | 2058.59 | 2059.11 | 1950.0 |
| 2014-07-23 03:00:00 | ES | Futures | 2059.11 | 2061.98 | 2058.33 | 2061.46 | 17533.0 |
| 2014-07-23 03:30:00 | ES | Futures | 2061.46 | 2061.46 | 2059.89 | 2060.15 | 6449.0 |
| 2014-07-23 04:00:00 | ES | Futures | 2060.15 | 2061.72 | 2060.15 | 2061.2 | 5872.0 |
| 2014-07-23 04:30:00 | ES | Futures | 2061.46 | 2061.72 | 2060.41 | 2060.67 | 4156.0 |
| 2014-07-23 05:00:00 | ES | Futures | 2060.67 | 2062.24 | 2060.15 | 2061.98 | 5540.0 |
| 2014-07-23 05:30:00 | ES | Futures | 2061.98 | 2062.24 | 2061.2 | 2061.72 | 3184.0 |
| 2014-07-23 06:00:00 | ES | Futures | 2061.98 | 2063.54 | 2061.72 | 2062.76 | 9277.0 |
| 2014-07-23 06:30:00 | ES | Futures | 2062.76 | 2063.28 | 2061.46 | 2061.72 | 6953.0 |
| 2014-07-23 07:00:00 | ES | Futures | 2061.72 | 2063.02 | 2061.46 | 2062.5 | 7157.0 |
| 2014-07-23 07:30:00 | ES | Futures | 2062.5 | 2063.02 | 2060.94 | 2060.94 | 9642.0 |
| 2014-07-23 08:00:00 | ES | Futures | 2060.94 | 2062.5 | 2060.94 | 2061.98 | 10146.0 |
| 2014-07-23 08:30:00 | ES | Futures | 2061.72 | 2063.02 | 2061.72 | 2062.76 | 10323.0 |
| 2014-07-23 09:00:00 | ES | Futures | 2062.76 | 2064.32 | 2061.98 | 2064.06 | 23195.0 |
| 2014-07-23 09:30:00 | ES | Futures | 2064.06 | 2065.11 | 2059.63 | 2061.72 | 207704.0 |
| 2014-07-23 10:00:00 | ES | Futures | 2061.98 | 2064.84 | 2060.67 | 2064.84 | 107043.0 |
| 2014-07-23 10:30:00 | ES | Futures | 2064.84 | 2067.71 | 2064.58 | 2066.15 | 124114.0 |
| 2014-07-23 11:00:00 | ES | Futures | 2066.15 | 2066.93 | 2065.37 | 2065.63 | 69451.0 |
| 2014-07-23 11:30:00 | ES | Futures | 2065.89 | 2067.19 | 2065.37 | 2066.41 | 45715.0 |
| 2014-07-23 12:00:00 | ES | Futures | 2066.41 | 2066.67 | 2064.58 | 2064.58 | 43807.0 |
| 2014-07-23 12:30:00 | ES | Futures | 2064.84 | 2064.84 | 2062.24 | 2063.8 | 70120.0 |
| 2014-07-23 13:00:00 | ES | Futures | 2063.54 | 2064.58 | 2063.02 | 2064.58 | 31369.0 |
| 2014-07-23 13:30:00 | ES | Futures | 2064.32 | 2066.67 | 2063.8 | 2066.15 | 44744.0 |
| 2014-07-23 14:00:00 | ES | Futures | 2066.41 | 2066.93 | 2065.37 | 2065.63 | 33194.0 |
| 2014-07-23 14:30:00 | ES | Futures | 2065.63 | 2066.67 | 2065.11 | 2065.89 | 44756.0 |
| 2014-07-23 15:00:00 | ES | Futures | 2065.89 | 2066.93 | 2065.11 | 2066.41 | 43263.0 |
| 2014-07-23 15:30:00 | ES | Futures | 2066.67 | 2066.93 | 2064.84 | 2065.63 | 67544.0 |
| 2014-07-23 16:00:00 | ES | Futures | 2065.63 | 2066.15 | 2064.32 | 2065.11 | 65405.0 |
| 2014-07-23 16:30:00 | ES | Futures | 2065.11 | 2065.63 | 2064.58 | 2065.37 | 5334.0 |
| 2014-07-23 17:00:00 | ES | Futures | 2065.11 | 2065.63 | 2064.84 | 2065.37 | 2680.0 |
| 2014-07-23 18:00:00 | ES | Futures | 2065.11 | 2065.63 | 2064.58 | 2065.11 | 2763.0 |
| 2014-07-23 18:30:00 | ES | Futures | 2064.84 | 2065.11 | 2064.32 | 2064.58 | 1692.0 |
| 2014-07-23 19:00:00 | ES | Futures | 2064.84 | 2065.63 | 2064.58 | 2065.37 | 477.0 |
| 2014-07-23 19:30:00 | ES | Futures | 2065.11 | 2065.37 | 2064.84 | 2065.11 | 584.0 |
| 2014-07-23 20:00:00 | ES | Futures | 2065.37 | 2065.63 | 2065.11 | 2065.37 | 765.0 |
| 2014-07-23 20:30:00 | ES | Futures | 2065.37 | 2065.63 | 2065.11 | 2065.63 | 493.0 |
| 2014-07-23 21:00:00 | ES | Futures | 2065.63 | 2066.15 | 2065.63 | 2065.63 | 1419.0 |
| 2014-07-23 21:30:00 | ES | Futures | 2065.63 | 2067.71 | 2064.84 | 2064.84 | 7199.0 |
| 2014-07-23 22:00:00 | ES | Futures | 2065.11 | 2065.37 | 2063.54 | 2063.8 | 4184.0 |
| 2014-07-23 22:30:00 | ES | Futures | 2063.8 | 2064.06 | 2063.28 | 2063.54 | 1156.0 |
| 2014-07-23 23:00:00 | ES | Futures | 2063.54 | 2063.8 | 2062.76 | 2063.02 | 2200.0 |
| 2014-07-23 23:30:00 | ES | Futures | 2063.02 | 2063.02 | 2062.5 | 2062.5 | 1778.0 |
| 2014-07-23 00:00:00 | NQ | Futures | 4611.2 | 4614.42 | 4611.2 | 4612.96 | 253.0 |
| 2014-07-23 00:30:00 | NQ | Futures | 4613.25 | 4613.54 | 4612.37 | 4612.96 | 75.0 |
| 2014-07-23 01:00:00 | NQ | Futures | 4612.37 | 4612.96 | 4612.08 | 4612.66 | 45.0 |
> showing 50 of 2,876 rows — these rows as CSV