PREVIEW / futures_1hour / 2008-07-10
file: by_date/futures_1hour/2008/2008-07-10.parquet size: 40 KB rows: 1,206
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-10 00:00:00 | ES | Futures | 1160.45 | 1161.61 | 1159.99 | 1161.38 | 2992.0 |
| 2008-07-10 01:00:00 | ES | Futures | 1161.38 | 1162.08 | 1160.91 | 1160.91 | 2794.0 |
| 2008-07-10 02:00:00 | ES | Futures | 1160.91 | 1162.31 | 1159.99 | 1161.38 | 5812.0 |
| 2008-07-10 03:00:00 | ES | Futures | 1161.38 | 1163.94 | 1160.45 | 1162.54 | 14440.0 |
| 2008-07-10 04:00:00 | ES | Futures | 1162.31 | 1163.94 | 1159.99 | 1163.24 | 14939.0 |
| 2008-07-10 05:00:00 | ES | Futures | 1163.24 | 1164.17 | 1161.61 | 1162.31 | 8796.0 |
| 2008-07-10 06:00:00 | ES | Futures | 1162.08 | 1163.01 | 1159.75 | 1159.99 | 8001.0 |
| 2008-07-10 07:00:00 | ES | Futures | 1160.22 | 1170.68 | 1159.75 | 1166.49 | 59857.0 |
| 2008-07-10 08:00:00 | ES | Futures | 1166.49 | 1170.21 | 1159.29 | 1159.52 | 91131.0 |
| 2008-07-10 09:00:00 | ES | Futures | 1159.52 | 1165.8 | 1154.87 | 1158.59 | 401587.0 |
| 2008-07-10 10:00:00 | ES | Futures | 1158.82 | 1161.61 | 1150.46 | 1156.73 | 636502.0 |
| 2008-07-10 11:00:00 | ES | Futures | 1156.5 | 1163.7 | 1154.64 | 1160.91 | 365704.0 |
| 2008-07-10 12:00:00 | ES | Futures | 1160.91 | 1166.49 | 1158.36 | 1159.29 | 203368.0 |
| 2008-07-10 13:00:00 | ES | Futures | 1159.29 | 1170.21 | 1159.29 | 1166.49 | 243805.0 |
| 2008-07-10 14:00:00 | ES | Futures | 1166.73 | 1166.96 | 1149.99 | 1152.55 | 387220.0 |
| 2008-07-10 15:00:00 | ES | Futures | 1152.78 | 1166.96 | 1152.08 | 1166.49 | 468477.0 |
| 2008-07-10 16:00:00 | ES | Futures | 1166.49 | 1169.51 | 1165.1 | 1168.82 | 75003.0 |
| 2008-07-10 17:00:00 | ES | Futures | 1168.58 | 1169.28 | 1166.96 | 1168.35 | 1799.0 |
| 2008-07-10 18:00:00 | ES | Futures | 1167.89 | 1168.58 | 1166.96 | 1168.35 | 1789.0 |
| 2008-07-10 19:00:00 | ES | Futures | 1168.35 | 1169.51 | 1166.96 | 1167.42 | 1800.0 |
| 2008-07-10 20:00:00 | ES | Futures | 1167.65 | 1167.89 | 1163.7 | 1163.7 | 6080.0 |
| 2008-07-10 21:00:00 | ES | Futures | 1163.94 | 1164.87 | 1163.47 | 1164.4 | 3021.0 |
| 2008-07-10 22:00:00 | ES | Futures | 1164.63 | 1164.87 | 1162.31 | 1163.7 | 3972.0 |
| 2008-07-10 23:00:00 | ES | Futures | 1163.7 | 1166.03 | 1163.01 | 1165.56 | 2226.0 |
| 2008-07-10 00:00:00 | NQ | Futures | 2061.57 | 2064.1 | 2061.57 | 2064.1 | 172.0 |
| 2008-07-10 01:00:00 | NQ | Futures | 2063.82 | 2064.66 | 2062.69 | 2062.97 | 168.0 |
| 2008-07-10 02:00:00 | NQ | Futures | 2062.13 | 2064.1 | 2061.57 | 2063.25 | 397.0 |
| 2008-07-10 03:00:00 | NQ | Futures | 2063.82 | 2068.88 | 2061.85 | 2066.91 | 2095.0 |
| 2008-07-10 04:00:00 | NQ | Futures | 2066.63 | 2067.19 | 2059.6 | 2065.78 | 1786.0 |
| 2008-07-10 05:00:00 | NQ | Futures | 2065.78 | 2067.19 | 2062.13 | 2062.13 | 524.0 |
| 2008-07-10 06:00:00 | NQ | Futures | 2061.85 | 2063.53 | 2057.63 | 2057.91 | 590.0 |
| 2008-07-10 07:00:00 | NQ | Futures | 2057.63 | 2077.6 | 2057.35 | 2069.72 | 5331.0 |
| 2008-07-10 08:00:00 | NQ | Futures | 2069.72 | 2075.35 | 2057.35 | 2057.91 | 11081.0 |
| 2008-07-10 09:00:00 | NQ | Futures | 2057.63 | 2079.01 | 2046.38 | 2065.22 | 64622.0 |
| 2008-07-10 10:00:00 | NQ | Futures | 2064.66 | 2077.32 | 2052.0 | 2066.91 | 93469.0 |
| 2008-07-10 11:00:00 | NQ | Futures | 2066.63 | 2075.63 | 2060.16 | 2066.91 | 55978.0 |
| 2008-07-10 12:00:00 | NQ | Futures | 2066.91 | 2079.57 | 2062.97 | 2066.07 | 47909.0 |
| 2008-07-10 13:00:00 | NQ | Futures | 2066.07 | 2084.63 | 2065.78 | 2075.35 | 44553.0 |
| 2008-07-10 14:00:00 | NQ | Futures | 2075.07 | 2078.16 | 2035.97 | 2042.16 | 76774.0 |
| 2008-07-10 15:00:00 | NQ | Futures | 2041.88 | 2077.88 | 2040.47 | 2077.32 | 96625.0 |
| 2008-07-10 16:00:00 | NQ | Futures | 2077.32 | 2080.69 | 2073.66 | 2080.13 | 14993.0 |
| 2008-07-10 17:00:00 | NQ | Futures | 2080.41 | 2082.38 | 2078.72 | 2081.82 | 248.0 |
| 2008-07-10 18:00:00 | NQ | Futures | 2082.1 | 2082.38 | 2078.16 | 2079.57 | 278.0 |
| 2008-07-10 19:00:00 | NQ | Futures | 2080.41 | 2081.82 | 2078.16 | 2080.13 | 259.0 |
| 2008-07-10 20:00:00 | NQ | Futures | 2080.13 | 2080.13 | 2073.1 | 2073.38 | 87.0 |
| 2008-07-10 21:00:00 | NQ | Futures | 2073.38 | 2074.5 | 2073.38 | 2074.5 | 94.0 |
| 2008-07-10 22:00:00 | NQ | Futures | 2074.79 | 2074.79 | 2071.69 | 2073.66 | 95.0 |
| 2008-07-10 23:00:00 | NQ | Futures | 2073.1 | 2077.32 | 2072.25 | 2077.32 | 163.0 |
| 2008-07-10 00:00:00 | YM | Futures | 10137.6 | 10146.7 | 10137.6 | 10145.8 | 330.0 |
| 2008-07-10 01:00:00 | YM | Futures | 10142.1 | 10147.6 | 10139.4 | 10139.4 | 177.0 |
> showing 50 of 1,206 rows — these rows as CSV