PREVIEW / futures_1hour / 2008-04-14
file: by_date/futures_1hour/2008/2008-04-14.parquet size: 42 KB rows: 1,220
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-04-14 00:00:00 | ES | Futures | 1238.96 | 1240.59 | 1238.26 | 1239.89 | 970.0 |
| 2008-04-14 01:00:00 | ES | Futures | 1239.89 | 1241.29 | 1239.89 | 1241.06 | 1103.0 |
| 2008-04-14 02:00:00 | ES | Futures | 1241.29 | 1242.22 | 1239.19 | 1241.29 | 5236.0 |
| 2008-04-14 03:00:00 | ES | Futures | 1241.29 | 1243.62 | 1238.5 | 1239.89 | 14285.0 |
| 2008-04-14 04:00:00 | ES | Futures | 1239.66 | 1242.45 | 1239.66 | 1242.22 | 6783.0 |
| 2008-04-14 05:00:00 | ES | Futures | 1242.45 | 1244.55 | 1241.52 | 1244.08 | 10134.0 |
| 2008-04-14 06:00:00 | ES | Futures | 1243.85 | 1243.85 | 1237.8 | 1238.96 | 15840.0 |
| 2008-04-14 07:00:00 | ES | Futures | 1238.96 | 1239.43 | 1236.4 | 1236.63 | 20179.0 |
| 2008-04-14 08:00:00 | ES | Futures | 1236.63 | 1241.06 | 1234.77 | 1240.36 | 67826.0 |
| 2008-04-14 09:00:00 | ES | Futures | 1240.59 | 1243.15 | 1240.13 | 1242.22 | 185158.0 |
| 2008-04-14 10:00:00 | ES | Futures | 1242.22 | 1243.85 | 1238.03 | 1242.22 | 279340.0 |
| 2008-04-14 11:00:00 | ES | Futures | 1242.22 | 1243.15 | 1236.4 | 1239.43 | 172244.0 |
| 2008-04-14 12:00:00 | ES | Futures | 1239.66 | 1245.25 | 1238.26 | 1245.02 | 169770.0 |
| 2008-04-14 13:00:00 | ES | Futures | 1244.78 | 1245.48 | 1239.66 | 1240.82 | 123440.0 |
| 2008-04-14 14:00:00 | ES | Futures | 1240.82 | 1241.99 | 1237.56 | 1238.03 | 137206.0 |
| 2008-04-14 15:00:00 | ES | Futures | 1238.26 | 1240.36 | 1236.17 | 1238.5 | 181200.0 |
| 2008-04-14 16:00:00 | ES | Futures | 1238.73 | 1240.82 | 1238.26 | 1240.13 | 49470.0 |
| 2008-04-14 17:00:00 | ES | Futures | 1240.13 | 1240.82 | 1238.5 | 1239.19 | 1564.0 |
| 2008-04-14 18:00:00 | ES | Futures | 1238.96 | 1239.66 | 1238.5 | 1238.96 | 1715.0 |
| 2008-04-14 19:00:00 | ES | Futures | 1238.96 | 1241.29 | 1238.73 | 1241.29 | 3498.0 |
| 2008-04-14 20:00:00 | ES | Futures | 1241.29 | 1241.29 | 1240.36 | 1240.82 | 1007.0 |
| 2008-04-14 21:00:00 | ES | Futures | 1240.82 | 1243.15 | 1240.82 | 1242.92 | 2856.0 |
| 2008-04-14 22:00:00 | ES | Futures | 1242.92 | 1243.39 | 1239.19 | 1239.43 | 2680.0 |
| 2008-04-14 23:00:00 | ES | Futures | 1239.66 | 1242.22 | 1239.19 | 1240.82 | 898.0 |
| 2008-04-14 00:00:00 | NQ | Futures | 2036.37 | 2038.91 | 2036.37 | 2037.78 | 95.0 |
| 2008-04-14 01:00:00 | NQ | Futures | 2038.35 | 2039.48 | 2036.93 | 2039.48 | 36.0 |
| 2008-04-14 02:00:00 | NQ | Futures | 2038.91 | 2042.02 | 2036.93 | 2039.48 | 120.0 |
| 2008-04-14 03:00:00 | NQ | Futures | 2040.33 | 2045.13 | 2036.08 | 2036.93 | 948.0 |
| 2008-04-14 04:00:00 | NQ | Futures | 2037.21 | 2042.31 | 2037.21 | 2042.02 | 517.0 |
| 2008-04-14 05:00:00 | NQ | Futures | 2042.02 | 2045.98 | 2040.33 | 2043.72 | 992.0 |
| 2008-04-14 06:00:00 | NQ | Futures | 2043.44 | 2043.44 | 2033.54 | 2034.67 | 1108.0 |
| 2008-04-14 07:00:00 | NQ | Futures | 2034.67 | 2035.52 | 2030.71 | 2030.99 | 2175.0 |
| 2008-04-14 08:00:00 | NQ | Futures | 2030.99 | 2037.78 | 2026.75 | 2035.8 | 4345.0 |
| 2008-04-14 09:00:00 | NQ | Futures | 2035.52 | 2042.31 | 2027.88 | 2035.52 | 38033.0 |
| 2008-04-14 10:00:00 | NQ | Futures | 2035.52 | 2045.13 | 2031.28 | 2043.44 | 44832.0 |
| 2008-04-14 11:00:00 | NQ | Futures | 2043.15 | 2046.27 | 2029.86 | 2037.21 | 28686.0 |
| 2008-04-14 12:00:00 | NQ | Futures | 2037.21 | 2052.2 | 2033.82 | 2048.53 | 34285.0 |
| 2008-04-14 13:00:00 | NQ | Futures | 2048.53 | 2050.22 | 2038.63 | 2040.89 | 22273.0 |
| 2008-04-14 14:00:00 | NQ | Futures | 2040.61 | 2043.44 | 2032.97 | 2033.25 | 26422.0 |
| 2008-04-14 15:00:00 | NQ | Futures | 2033.25 | 2036.65 | 2029.86 | 2031.56 | 36632.0 |
| 2008-04-14 16:00:00 | NQ | Futures | 2031.28 | 2035.23 | 2030.99 | 2033.25 | 9264.0 |
| 2008-04-14 17:00:00 | NQ | Futures | 2033.25 | 2034.1 | 2030.71 | 2030.71 | 70.0 |
| 2008-04-14 18:00:00 | NQ | Futures | 2030.99 | 2031.28 | 2028.73 | 2029.58 | 171.0 |
| 2008-04-14 19:00:00 | NQ | Futures | 2029.01 | 2034.1 | 2028.73 | 2032.97 | 62.0 |
| 2008-04-14 20:00:00 | NQ | Futures | 2032.97 | 2034.1 | 2032.69 | 2032.97 | 72.0 |
| 2008-04-14 21:00:00 | NQ | Futures | 2033.25 | 2036.93 | 2033.25 | 2036.37 | 453.0 |
| 2008-04-14 22:00:00 | NQ | Futures | 2036.37 | 2037.78 | 2032.12 | 2032.41 | 461.0 |
| 2008-04-14 23:00:00 | NQ | Futures | 2032.41 | 2037.21 | 2032.41 | 2035.23 | 217.0 |
| 2008-04-14 00:00:00 | YM | Futures | 11169.1 | 11186.4 | 11169.1 | 11181.0 | 165.0 |
| 2008-04-14 01:00:00 | YM | Futures | 11182.8 | 11190.0 | 11178.2 | 11189.1 | 55.0 |
> showing 50 of 1,220 rows — these rows as CSV