PREVIEW / futures_1hour / 2008-05-09
file: by_date/futures_1hour/2008/2008-05-09.parquet size: 36 KB rows: 1,012
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-09 00:00:00 | ES | Futures | 1292.28 | 1293.68 | 1292.05 | 1292.98 | 1710.0 |
| 2008-05-09 01:00:00 | ES | Futures | 1292.98 | 1294.15 | 1292.52 | 1292.98 | 1754.0 |
| 2008-05-09 02:00:00 | ES | Futures | 1292.98 | 1294.38 | 1292.52 | 1294.15 | 4656.0 |
| 2008-05-09 03:00:00 | ES | Futures | 1294.15 | 1294.38 | 1289.26 | 1290.65 | 18375.0 |
| 2008-05-09 04:00:00 | ES | Futures | 1290.65 | 1291.35 | 1288.79 | 1291.12 | 13758.0 |
| 2008-05-09 05:00:00 | ES | Futures | 1291.12 | 1291.35 | 1286.93 | 1287.86 | 18255.0 |
| 2008-05-09 06:00:00 | ES | Futures | 1288.09 | 1289.95 | 1287.86 | 1289.49 | 10501.0 |
| 2008-05-09 07:00:00 | ES | Futures | 1289.49 | 1290.19 | 1287.63 | 1287.86 | 14844.0 |
| 2008-05-09 08:00:00 | ES | Futures | 1288.09 | 1290.65 | 1287.86 | 1289.95 | 48422.0 |
| 2008-05-09 09:00:00 | ES | Futures | 1289.95 | 1293.21 | 1288.79 | 1290.19 | 224903.0 |
| 2008-05-09 10:00:00 | ES | Futures | 1290.42 | 1297.64 | 1290.19 | 1295.31 | 328116.0 |
| 2008-05-09 11:00:00 | ES | Futures | 1295.08 | 1295.78 | 1291.12 | 1292.28 | 195230.0 |
| 2008-05-09 12:00:00 | ES | Futures | 1292.52 | 1293.68 | 1290.65 | 1293.45 | 123289.0 |
| 2008-05-09 13:00:00 | ES | Futures | 1293.45 | 1293.45 | 1289.26 | 1292.52 | 148494.0 |
| 2008-05-09 14:00:00 | ES | Futures | 1292.75 | 1294.15 | 1290.42 | 1292.05 | 132828.0 |
| 2008-05-09 15:00:00 | ES | Futures | 1292.05 | 1297.41 | 1291.58 | 1293.21 | 230880.0 |
| 2008-05-09 16:00:00 | ES | Futures | 1292.98 | 1295.78 | 1292.28 | 1293.68 | 81226.0 |
| 2008-05-09 00:00:00 | NQ | Futures | 2217.66 | 2220.49 | 2217.38 | 2219.92 | 67.0 |
| 2008-05-09 01:00:00 | NQ | Futures | 2219.64 | 2219.92 | 2217.94 | 2218.51 | 27.0 |
| 2008-05-09 02:00:00 | NQ | Futures | 2217.94 | 2220.2 | 2217.66 | 2219.36 | 335.0 |
| 2008-05-09 03:00:00 | NQ | Futures | 2219.64 | 2220.2 | 2211.72 | 2215.4 | 1685.0 |
| 2008-05-09 04:00:00 | NQ | Futures | 2215.4 | 2215.96 | 2210.87 | 2213.98 | 983.0 |
| 2008-05-09 05:00:00 | NQ | Futures | 2213.98 | 2215.11 | 2209.17 | 2211.44 | 1017.0 |
| 2008-05-09 06:00:00 | NQ | Futures | 2210.87 | 2214.27 | 2210.02 | 2214.27 | 463.0 |
| 2008-05-09 07:00:00 | NQ | Futures | 2213.98 | 2214.27 | 2209.17 | 2209.46 | 976.0 |
| 2008-05-09 08:00:00 | NQ | Futures | 2209.74 | 2215.4 | 2209.74 | 2211.72 | 3874.0 |
| 2008-05-09 09:00:00 | NQ | Futures | 2211.44 | 2215.68 | 2207.48 | 2211.15 | 40842.0 |
| 2008-05-09 10:00:00 | NQ | Futures | 2211.44 | 2232.65 | 2211.44 | 2226.71 | 56311.0 |
| 2008-05-09 11:00:00 | NQ | Futures | 2226.71 | 2228.69 | 2216.25 | 2220.49 | 30816.0 |
| 2008-05-09 12:00:00 | NQ | Futures | 2220.77 | 2221.05 | 2213.13 | 2220.77 | 23247.0 |
| 2008-05-09 13:00:00 | NQ | Futures | 2220.77 | 2222.47 | 2212.0 | 2221.05 | 23809.0 |
| 2008-05-09 14:00:00 | NQ | Futures | 2221.05 | 2226.43 | 2217.66 | 2219.07 | 26141.0 |
| 2008-05-09 15:00:00 | NQ | Futures | 2218.79 | 2227.56 | 2217.38 | 2220.77 | 37337.0 |
| 2008-05-09 16:00:00 | NQ | Futures | 2221.34 | 2225.58 | 2220.2 | 2222.47 | 9663.0 |
| 2008-05-09 00:00:00 | YM | Futures | 11614.4 | 11622.6 | 11612.6 | 11618.9 | 94.0 |
| 2008-05-09 01:00:00 | YM | Futures | 11620.7 | 11626.2 | 11614.4 | 11619.8 | 145.0 |
| 2008-05-09 02:00:00 | YM | Futures | 11618.0 | 11625.3 | 11610.7 | 11625.3 | 487.0 |
| 2008-05-09 03:00:00 | YM | Futures | 11625.3 | 11626.2 | 11588.0 | 11598.9 | 1316.0 |
| 2008-05-09 04:00:00 | YM | Futures | 11597.1 | 11601.7 | 11584.4 | 11597.1 | 705.0 |
| 2008-05-09 05:00:00 | YM | Futures | 11598.9 | 11600.8 | 11565.3 | 11566.2 | 1174.0 |
| 2008-05-09 06:00:00 | YM | Futures | 11566.2 | 11584.4 | 11564.4 | 11583.5 | 671.0 |
| 2008-05-09 07:00:00 | YM | Futures | 11582.6 | 11584.4 | 11567.1 | 11569.9 | 701.0 |
| 2008-05-09 08:00:00 | YM | Futures | 11569.9 | 11591.7 | 11569.0 | 11586.2 | 2180.0 |
| 2008-05-09 09:00:00 | YM | Futures | 11586.2 | 11598.9 | 11557.1 | 11576.2 | 17377.0 |
| 2008-05-09 10:00:00 | YM | Futures | 11576.2 | 11621.7 | 11574.4 | 11603.5 | 23848.0 |
| 2008-05-09 11:00:00 | YM | Futures | 11604.4 | 11608.0 | 11575.3 | 11583.5 | 16563.0 |
| 2008-05-09 12:00:00 | YM | Futures | 11583.5 | 11594.4 | 11575.3 | 11592.6 | 10984.0 |
| 2008-05-09 13:00:00 | YM | Futures | 11592.6 | 11593.5 | 11544.4 | 11570.8 | 17026.0 |
| 2008-05-09 14:00:00 | YM | Futures | 11570.8 | 11582.6 | 11550.8 | 11564.4 | 13983.0 |
| 2008-05-09 15:00:00 | YM | Futures | 11564.4 | 11608.0 | 11557.1 | 11577.1 | 17866.0 |
> showing 50 of 1,012 rows — these rows as CSV