PREVIEW / futures_1hour / 2008-03-26
file: by_date/futures_1hour/2008/2008-03-26.parquet size: 43 KB rows: 1,229
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-03-26 00:00:00 | ES | Futures | 1255.49 | 1256.66 | 1255.26 | 1256.42 | 1704.0 |
| 2008-03-26 01:00:00 | ES | Futures | 1256.42 | 1256.42 | 1255.49 | 1256.19 | 1484.0 |
| 2008-03-26 02:00:00 | ES | Futures | 1255.96 | 1256.66 | 1254.79 | 1255.03 | 1352.0 |
| 2008-03-26 03:00:00 | ES | Futures | 1255.26 | 1255.73 | 1252.23 | 1252.23 | 7466.0 |
| 2008-03-26 04:00:00 | ES | Futures | 1252.47 | 1254.79 | 1251.07 | 1254.79 | 12663.0 |
| 2008-03-26 05:00:00 | ES | Futures | 1254.79 | 1256.42 | 1253.63 | 1254.33 | 13658.0 |
| 2008-03-26 06:00:00 | ES | Futures | 1254.56 | 1257.59 | 1253.16 | 1253.86 | 15075.0 |
| 2008-03-26 07:00:00 | ES | Futures | 1253.86 | 1256.89 | 1252.0 | 1252.47 | 21331.0 |
| 2008-03-26 08:00:00 | ES | Futures | 1252.7 | 1256.89 | 1252.23 | 1254.33 | 56303.0 |
| 2008-03-26 09:00:00 | ES | Futures | 1254.33 | 1255.73 | 1249.67 | 1252.7 | 188546.0 |
| 2008-03-26 10:00:00 | ES | Futures | 1252.23 | 1256.19 | 1245.71 | 1248.97 | 322957.0 |
| 2008-03-26 11:00:00 | ES | Futures | 1248.74 | 1252.93 | 1247.11 | 1250.84 | 176322.0 |
| 2008-03-26 12:00:00 | ES | Futures | 1251.07 | 1252.7 | 1247.11 | 1248.74 | 110254.0 |
| 2008-03-26 13:00:00 | ES | Futures | 1248.74 | 1250.37 | 1246.41 | 1248.04 | 115627.0 |
| 2008-03-26 14:00:00 | ES | Futures | 1248.04 | 1256.89 | 1246.41 | 1256.42 | 172155.0 |
| 2008-03-26 15:00:00 | ES | Futures | 1256.42 | 1256.89 | 1247.34 | 1249.67 | 254543.0 |
| 2008-03-26 16:00:00 | ES | Futures | 1249.67 | 1250.37 | 1242.45 | 1244.32 | 115329.0 |
| 2008-03-26 17:00:00 | ES | Futures | 1244.32 | 1245.25 | 1242.92 | 1244.08 | 2949.0 |
| 2008-03-26 18:00:00 | ES | Futures | 1243.85 | 1244.08 | 1240.59 | 1242.45 | 5138.0 |
| 2008-03-26 19:00:00 | ES | Futures | 1242.45 | 1244.55 | 1241.76 | 1244.32 | 3129.0 |
| 2008-03-26 20:00:00 | ES | Futures | 1243.85 | 1244.55 | 1242.92 | 1243.15 | 1581.0 |
| 2008-03-26 21:00:00 | ES | Futures | 1243.15 | 1244.55 | 1242.69 | 1243.39 | 2216.0 |
| 2008-03-26 22:00:00 | ES | Futures | 1243.15 | 1243.85 | 1241.29 | 1242.22 | 3632.0 |
| 2008-03-26 23:00:00 | ES | Futures | 1241.99 | 1244.32 | 1241.76 | 1243.85 | 2321.0 |
| 2008-03-26 00:00:00 | NQ | Futures | 2062.39 | 2063.8 | 2062.1 | 2063.23 | 46.0 |
| 2008-03-26 01:00:00 | NQ | Futures | 2062.1 | 2064.65 | 2061.54 | 2064.65 | 58.0 |
| 2008-03-26 02:00:00 | NQ | Futures | 2064.37 | 2066.06 | 2060.69 | 2062.39 | 113.0 |
| 2008-03-26 03:00:00 | NQ | Futures | 2063.52 | 2063.8 | 2058.71 | 2058.71 | 382.0 |
| 2008-03-26 04:00:00 | NQ | Futures | 2058.43 | 2064.08 | 2057.58 | 2062.39 | 1071.0 |
| 2008-03-26 05:00:00 | NQ | Futures | 2062.67 | 2066.06 | 2059.84 | 2061.82 | 1061.0 |
| 2008-03-26 06:00:00 | NQ | Futures | 2062.1 | 2066.91 | 2058.99 | 2060.12 | 469.0 |
| 2008-03-26 07:00:00 | NQ | Futures | 2061.54 | 2065.21 | 2057.01 | 2057.86 | 1334.0 |
| 2008-03-26 08:00:00 | NQ | Futures | 2058.14 | 2064.65 | 2056.45 | 2059.84 | 6701.0 |
| 2008-03-26 09:00:00 | NQ | Futures | 2059.56 | 2064.65 | 2050.79 | 2055.03 | 46613.0 |
| 2008-03-26 10:00:00 | NQ | Futures | 2055.03 | 2060.97 | 2043.72 | 2052.77 | 60708.0 |
| 2008-03-26 11:00:00 | NQ | Futures | 2052.77 | 2059.28 | 2049.38 | 2054.47 | 29826.0 |
| 2008-03-26 12:00:00 | NQ | Futures | 2054.47 | 2055.32 | 2050.51 | 2053.34 | 19221.0 |
| 2008-03-26 13:00:00 | NQ | Futures | 2053.05 | 2056.73 | 2047.11 | 2051.36 | 21728.0 |
| 2008-03-26 14:00:00 | NQ | Futures | 2051.36 | 2068.89 | 2047.68 | 2068.33 | 37106.0 |
| 2008-03-26 15:00:00 | NQ | Futures | 2068.61 | 2070.02 | 2054.47 | 2062.67 | 52270.0 |
| 2008-03-26 16:00:00 | NQ | Futures | 2062.67 | 2063.8 | 2039.48 | 2045.42 | 25860.0 |
| 2008-03-26 17:00:00 | NQ | Futures | 2045.42 | 2049.38 | 2044.0 | 2046.55 | 1266.0 |
| 2008-03-26 18:00:00 | NQ | Futures | 2045.42 | 2045.42 | 2040.33 | 2042.87 | 522.0 |
| 2008-03-26 19:00:00 | NQ | Futures | 2043.44 | 2046.27 | 2042.02 | 2045.98 | 139.0 |
| 2008-03-26 20:00:00 | NQ | Futures | 2044.85 | 2045.98 | 2043.72 | 2044.57 | 43.0 |
| 2008-03-26 21:00:00 | NQ | Futures | 2044.0 | 2046.55 | 2043.72 | 2043.72 | 83.0 |
| 2008-03-26 22:00:00 | NQ | Futures | 2044.29 | 2044.85 | 2041.74 | 2042.02 | 83.0 |
| 2008-03-26 23:00:00 | NQ | Futures | 2043.15 | 2045.42 | 2043.15 | 2044.85 | 40.0 |
| 2008-03-26 00:00:00 | YM | Futures | 11351.8 | 11355.4 | 11347.2 | 11354.5 | 60.0 |
| 2008-03-26 01:00:00 | YM | Futures | 11355.4 | 11356.3 | 11348.1 | 11351.8 | 137.0 |
> showing 50 of 1,229 rows — these rows as CSV