PREVIEW / futures_1hour / 2008-05-08
file: by_date/futures_1hour/2008/2008-05-08.parquet size: 43 KB rows: 1,243
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-08 00:00:00 | ES | Futures | 1302.29 | 1302.53 | 1301.13 | 1301.36 | 1666.0 |
| 2008-05-08 01:00:00 | ES | Futures | 1301.36 | 1302.06 | 1300.9 | 1301.36 | 1970.0 |
| 2008-05-08 02:00:00 | ES | Futures | 1301.36 | 1302.06 | 1299.27 | 1300.43 | 4744.0 |
| 2008-05-08 03:00:00 | ES | Futures | 1300.66 | 1302.76 | 1299.97 | 1302.29 | 18637.0 |
| 2008-05-08 04:00:00 | ES | Futures | 1302.29 | 1303.69 | 1301.36 | 1302.29 | 8529.0 |
| 2008-05-08 05:00:00 | ES | Futures | 1302.29 | 1303.92 | 1302.06 | 1303.46 | 11487.0 |
| 2008-05-08 06:00:00 | ES | Futures | 1303.46 | 1304.86 | 1302.29 | 1304.16 | 9847.0 |
| 2008-05-08 07:00:00 | ES | Futures | 1304.16 | 1305.32 | 1302.99 | 1303.46 | 22169.0 |
| 2008-05-08 08:00:00 | ES | Futures | 1303.46 | 1304.86 | 1300.43 | 1301.13 | 49009.0 |
| 2008-05-08 09:00:00 | ES | Futures | 1301.13 | 1303.69 | 1298.1 | 1301.13 | 194106.0 |
| 2008-05-08 10:00:00 | ES | Futures | 1300.9 | 1300.9 | 1293.91 | 1297.41 | 331885.0 |
| 2008-05-08 11:00:00 | ES | Futures | 1297.64 | 1303.23 | 1296.71 | 1300.9 | 250776.0 |
| 2008-05-08 12:00:00 | ES | Futures | 1300.66 | 1301.6 | 1297.17 | 1299.97 | 142301.0 |
| 2008-05-08 13:00:00 | ES | Futures | 1299.97 | 1306.72 | 1296.94 | 1306.25 | 216127.0 |
| 2008-05-08 14:00:00 | ES | Futures | 1306.49 | 1306.49 | 1298.34 | 1299.27 | 155012.0 |
| 2008-05-08 15:00:00 | ES | Futures | 1299.04 | 1302.29 | 1296.47 | 1301.83 | 202200.0 |
| 2008-05-08 16:00:00 | ES | Futures | 1301.83 | 1302.29 | 1293.91 | 1294.38 | 69698.0 |
| 2008-05-08 17:00:00 | ES | Futures | 1294.15 | 1295.54 | 1294.15 | 1294.84 | 3114.0 |
| 2008-05-08 18:00:00 | ES | Futures | 1294.84 | 1295.54 | 1293.45 | 1295.31 | 1797.0 |
| 2008-05-08 19:00:00 | ES | Futures | 1295.31 | 1296.01 | 1294.38 | 1296.01 | 2197.0 |
| 2008-05-08 20:00:00 | ES | Futures | 1295.78 | 1296.01 | 1292.98 | 1293.68 | 2453.0 |
| 2008-05-08 21:00:00 | ES | Futures | 1293.91 | 1294.38 | 1292.98 | 1293.45 | 1012.0 |
| 2008-05-08 22:00:00 | ES | Futures | 1293.68 | 1295.54 | 1293.45 | 1294.38 | 1727.0 |
| 2008-05-08 23:00:00 | ES | Futures | 1294.15 | 1294.61 | 1292.05 | 1292.52 | 1577.0 |
| 2008-05-08 00:00:00 | NQ | Futures | 2223.32 | 2224.16 | 2221.9 | 2223.32 | 108.0 |
| 2008-05-08 01:00:00 | NQ | Futures | 2223.03 | 2224.16 | 2221.9 | 2223.03 | 82.0 |
| 2008-05-08 02:00:00 | NQ | Futures | 2223.03 | 2223.88 | 2219.36 | 2220.77 | 450.0 |
| 2008-05-08 03:00:00 | NQ | Futures | 2220.77 | 2225.3 | 2219.92 | 2223.6 | 1396.0 |
| 2008-05-08 04:00:00 | NQ | Futures | 2223.6 | 2225.3 | 2219.07 | 2219.92 | 937.0 |
| 2008-05-08 05:00:00 | NQ | Futures | 2219.92 | 2223.88 | 2219.92 | 2223.6 | 486.0 |
| 2008-05-08 06:00:00 | NQ | Futures | 2223.88 | 2225.3 | 2222.18 | 2224.16 | 305.0 |
| 2008-05-08 07:00:00 | NQ | Futures | 2223.6 | 2226.14 | 2222.75 | 2223.6 | 1073.0 |
| 2008-05-08 08:00:00 | NQ | Futures | 2223.6 | 2226.43 | 2221.05 | 2222.75 | 3190.0 |
| 2008-05-08 09:00:00 | NQ | Futures | 2222.47 | 2229.26 | 2218.22 | 2223.88 | 37459.0 |
| 2008-05-08 10:00:00 | NQ | Futures | 2223.6 | 2227.28 | 2215.11 | 2225.58 | 58850.0 |
| 2008-05-08 11:00:00 | NQ | Futures | 2225.58 | 2238.87 | 2225.01 | 2232.93 | 49915.0 |
| 2008-05-08 12:00:00 | NQ | Futures | 2232.93 | 2235.19 | 2223.03 | 2228.69 | 27364.0 |
| 2008-05-08 13:00:00 | NQ | Futures | 2228.69 | 2244.53 | 2223.88 | 2243.96 | 38363.0 |
| 2008-05-08 14:00:00 | NQ | Futures | 2243.96 | 2244.25 | 2222.47 | 2226.14 | 34506.0 |
| 2008-05-08 15:00:00 | NQ | Futures | 2226.14 | 2231.8 | 2219.92 | 2230.67 | 38948.0 |
| 2008-05-08 16:00:00 | NQ | Futures | 2230.67 | 2231.8 | 2218.79 | 2220.2 | 9644.0 |
| 2008-05-08 17:00:00 | NQ | Futures | 2219.64 | 2222.75 | 2219.36 | 2221.05 | 612.0 |
| 2008-05-08 18:00:00 | NQ | Futures | 2221.05 | 2221.62 | 2218.51 | 2220.77 | 142.0 |
| 2008-05-08 19:00:00 | NQ | Futures | 2221.9 | 2223.6 | 2220.77 | 2222.75 | 125.0 |
| 2008-05-08 20:00:00 | NQ | Futures | 2221.9 | 2222.75 | 2218.22 | 2218.22 | 223.0 |
| 2008-05-08 21:00:00 | NQ | Futures | 2219.36 | 2220.2 | 2219.36 | 2219.64 | 56.0 |
| 2008-05-08 22:00:00 | NQ | Futures | 2220.2 | 2222.47 | 2220.2 | 2220.77 | 123.0 |
| 2008-05-08 23:00:00 | NQ | Futures | 2220.2 | 2220.77 | 2217.38 | 2217.94 | 156.0 |
| 2008-05-08 00:00:00 | YM | Futures | 11681.6 | 11681.6 | 11676.2 | 11676.2 | 59.0 |
| 2008-05-08 01:00:00 | YM | Futures | 11677.1 | 11679.8 | 11672.5 | 11674.4 | 222.0 |
> showing 50 of 1,243 rows — these rows as CSV