PREVIEW / futures_1hour / 2008-05-28
file: by_date/futures_1hour/2008/2008-05-28.parquet size: 42 KB rows: 1,226
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-05-28 00:00:00 | ES | Futures | 1288.09 | 1288.32 | 1286.0 | 1286.0 | 1921.0 |
| 2008-05-28 01:00:00 | ES | Futures | 1286.0 | 1287.39 | 1285.76 | 1286.23 | 1450.0 |
| 2008-05-28 02:00:00 | ES | Futures | 1286.0 | 1288.56 | 1285.53 | 1287.86 | 4045.0 |
| 2008-05-28 03:00:00 | ES | Futures | 1287.86 | 1288.79 | 1285.76 | 1286.69 | 11888.0 |
| 2008-05-28 04:00:00 | ES | Futures | 1286.46 | 1291.82 | 1286.0 | 1289.26 | 17874.0 |
| 2008-05-28 05:00:00 | ES | Futures | 1289.49 | 1292.28 | 1289.26 | 1290.65 | 13428.0 |
| 2008-05-28 06:00:00 | ES | Futures | 1290.65 | 1293.45 | 1290.19 | 1291.35 | 14607.0 |
| 2008-05-28 07:00:00 | ES | Futures | 1291.35 | 1294.61 | 1291.12 | 1294.15 | 22235.0 |
| 2008-05-28 08:00:00 | ES | Futures | 1294.38 | 1297.64 | 1292.28 | 1295.31 | 88875.0 |
| 2008-05-28 09:00:00 | ES | Futures | 1295.08 | 1295.31 | 1289.72 | 1291.12 | 206360.0 |
| 2008-05-28 10:00:00 | ES | Futures | 1291.35 | 1291.58 | 1285.53 | 1290.19 | 314475.0 |
| 2008-05-28 11:00:00 | ES | Futures | 1290.42 | 1290.65 | 1286.23 | 1286.46 | 169200.0 |
| 2008-05-28 12:00:00 | ES | Futures | 1286.46 | 1288.79 | 1283.2 | 1288.32 | 192430.0 |
| 2008-05-28 13:00:00 | ES | Futures | 1288.09 | 1291.12 | 1285.76 | 1287.86 | 146371.0 |
| 2008-05-28 14:00:00 | ES | Futures | 1287.63 | 1290.19 | 1285.06 | 1288.79 | 143516.0 |
| 2008-05-28 15:00:00 | ES | Futures | 1288.56 | 1296.01 | 1288.32 | 1296.01 | 270857.0 |
| 2008-05-28 16:00:00 | ES | Futures | 1296.01 | 1297.64 | 1294.15 | 1294.61 | 77788.0 |
| 2008-05-28 17:00:00 | ES | Futures | 1294.61 | 1294.84 | 1292.98 | 1293.91 | 2612.0 |
| 2008-05-28 18:00:00 | ES | Futures | 1293.68 | 1294.15 | 1293.45 | 1293.45 | 738.0 |
| 2008-05-28 19:00:00 | ES | Futures | 1293.68 | 1294.38 | 1293.68 | 1293.68 | 723.0 |
| 2008-05-28 20:00:00 | ES | Futures | 1293.68 | 1294.61 | 1292.98 | 1294.38 | 2211.0 |
| 2008-05-28 21:00:00 | ES | Futures | 1294.38 | 1296.01 | 1294.38 | 1295.54 | 2443.0 |
| 2008-05-28 22:00:00 | ES | Futures | 1295.54 | 1296.47 | 1295.54 | 1295.54 | 889.0 |
| 2008-05-28 23:00:00 | ES | Futures | 1295.78 | 1295.78 | 1294.15 | 1295.08 | 1172.0 |
| 2008-05-28 00:00:00 | NQ | Futures | 2253.86 | 2253.86 | 2249.05 | 2249.34 | 165.0 |
| 2008-05-28 01:00:00 | NQ | Futures | 2249.34 | 2251.03 | 2248.49 | 2249.34 | 90.0 |
| 2008-05-28 02:00:00 | NQ | Futures | 2249.05 | 2253.3 | 2248.2 | 2251.32 | 436.0 |
| 2008-05-28 03:00:00 | NQ | Futures | 2251.03 | 2252.45 | 2247.64 | 2249.05 | 1087.0 |
| 2008-05-28 04:00:00 | NQ | Futures | 2248.77 | 2256.69 | 2248.2 | 2252.73 | 2043.0 |
| 2008-05-28 05:00:00 | NQ | Futures | 2252.73 | 2258.95 | 2252.73 | 2256.69 | 829.0 |
| 2008-05-28 06:00:00 | NQ | Futures | 2256.69 | 2260.65 | 2255.84 | 2258.1 | 1273.0 |
| 2008-05-28 07:00:00 | NQ | Futures | 2258.67 | 2266.31 | 2258.1 | 2266.02 | 3822.0 |
| 2008-05-28 08:00:00 | NQ | Futures | 2265.46 | 2272.53 | 2262.35 | 2270.83 | 10468.0 |
| 2008-05-28 09:00:00 | NQ | Futures | 2271.11 | 2271.68 | 2257.54 | 2261.5 | 50899.0 |
| 2008-05-28 10:00:00 | NQ | Futures | 2261.78 | 2261.78 | 2248.49 | 2258.95 | 64472.0 |
| 2008-05-28 11:00:00 | NQ | Futures | 2258.95 | 2259.8 | 2248.77 | 2251.6 | 35304.0 |
| 2008-05-28 12:00:00 | NQ | Futures | 2251.6 | 2251.88 | 2243.68 | 2249.9 | 34306.0 |
| 2008-05-28 13:00:00 | NQ | Futures | 2249.62 | 2258.39 | 2248.49 | 2252.45 | 30590.0 |
| 2008-05-28 14:00:00 | NQ | Futures | 2252.45 | 2256.97 | 2247.64 | 2253.3 | 24473.0 |
| 2008-05-28 15:00:00 | NQ | Futures | 2253.58 | 2266.31 | 2252.73 | 2265.46 | 40545.0 |
| 2008-05-28 16:00:00 | NQ | Futures | 2265.46 | 2270.27 | 2264.89 | 2265.46 | 9282.0 |
| 2008-05-28 17:00:00 | NQ | Futures | 2265.46 | 2265.46 | 2263.76 | 2264.61 | 263.0 |
| 2008-05-28 18:00:00 | NQ | Futures | 2265.17 | 2266.02 | 2264.61 | 2264.89 | 138.0 |
| 2008-05-28 19:00:00 | NQ | Futures | 2264.61 | 2265.17 | 2264.33 | 2264.89 | 59.0 |
| 2008-05-28 20:00:00 | NQ | Futures | 2265.17 | 2266.59 | 2264.04 | 2266.02 | 235.0 |
| 2008-05-28 21:00:00 | NQ | Futures | 2266.02 | 2269.98 | 2266.02 | 2268.29 | 180.0 |
| 2008-05-28 22:00:00 | NQ | Futures | 2268.0 | 2269.98 | 2267.72 | 2268.0 | 32.0 |
| 2008-05-28 23:00:00 | NQ | Futures | 2268.57 | 2268.57 | 2266.59 | 2268.0 | 46.0 |
| 2008-05-28 00:00:00 | YM | Futures | 11392.7 | 11393.6 | 11373.6 | 11375.4 | 223.0 |
| 2008-05-28 01:00:00 | YM | Futures | 11377.2 | 11382.7 | 11371.8 | 11373.6 | 85.0 |
> showing 50 of 1,226 rows — these rows as CSV