PREVIEW / futures_1hour / 2008-05-25
file: by_date/futures_1hour/2008/2008-05-25.parquet size: 10 KB rows: 150
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-25 18:00:00 | ES | Futures | 1279.94 | 1281.8 | 1279.71 | 1281.11 | 1038.0 |
| 2008-05-25 19:00:00 | ES | Futures | 1281.11 | 1282.74 | 1280.64 | 1282.5 | 605.0 |
| 2008-05-25 20:00:00 | ES | Futures | 1282.74 | 1282.74 | 1279.48 | 1279.71 | 1178.0 |
| 2008-05-25 21:00:00 | ES | Futures | 1279.94 | 1280.17 | 1278.78 | 1279.24 | 1026.0 |
| 2008-05-25 22:00:00 | ES | Futures | 1279.24 | 1280.17 | 1279.24 | 1279.71 | 412.0 |
| 2008-05-25 23:00:00 | ES | Futures | 1279.71 | 1279.71 | 1279.01 | 1279.24 | 270.0 |
| 2008-05-25 18:00:00 | NQ | Futures | 2217.66 | 2220.77 | 2217.66 | 2220.49 | 153.0 |
| 2008-05-25 19:00:00 | NQ | Futures | 2219.07 | 2220.2 | 2218.79 | 2219.36 | 46.0 |
| 2008-05-25 20:00:00 | NQ | Futures | 2220.2 | 2220.49 | 2216.81 | 2216.81 | 61.0 |
| 2008-05-25 21:00:00 | NQ | Futures | 2217.66 | 2217.94 | 2210.59 | 2215.68 | 108.0 |
| 2008-05-25 22:00:00 | NQ | Futures | 2216.81 | 2217.38 | 2216.81 | 2216.81 | 7.0 |
| 2008-05-25 23:00:00 | NQ | Futures | 2216.25 | 2217.66 | 2216.25 | 2216.81 | 6.0 |
| 2008-05-25 18:00:00 | YM | Futures | 11340.0 | 11348.1 | 11336.3 | 11345.4 | 123.0 |
| 2008-05-25 19:00:00 | YM | Futures | 11345.4 | 11353.6 | 11342.7 | 11353.6 | 41.0 |
| 2008-05-25 20:00:00 | YM | Futures | 11351.8 | 11354.5 | 11333.6 | 11333.6 | 165.0 |
| 2008-05-25 21:00:00 | YM | Futures | 11333.6 | 11338.2 | 11323.6 | 11329.1 | 84.0 |
| 2008-05-25 22:00:00 | YM | Futures | 11330.0 | 11337.2 | 11330.0 | 11334.5 | 62.0 |
| 2008-05-25 23:00:00 | YM | Futures | 11332.7 | 11334.5 | 11328.2 | 11329.1 | 40.0 |
| 2008-05-25 18:00:00 | CL | Futures | 501.92 | 502.38 | 501.58 | 502.34 | 76.0 |
| 2008-05-25 19:00:00 | CL | Futures | 502.19 | 504.63 | 502.19 | 504.28 | 219.0 |
| 2008-05-25 20:00:00 | CL | Futures | 504.28 | 505.54 | 504.28 | 505.43 | 201.0 |
| 2008-05-25 21:00:00 | CL | Futures | 505.43 | 506.27 | 505.24 | 505.69 | 268.0 |
| 2008-05-25 22:00:00 | CL | Futures | 505.66 | 505.66 | 505.01 | 505.05 | 113.0 |
| 2008-05-25 23:00:00 | CL | Futures | 505.05 | 506.3 | 505.05 | 506.19 | 126.0 |
| 2008-05-25 18:00:00 | GC | Futures | 1339.9 | 1340.4 | 1337.8 | 1339.3 | 110.0 |
| 2008-05-25 19:00:00 | GC | Futures | 1338.7 | 1342.0 | 1338.7 | 1341.6 | 146.0 |
| 2008-05-25 20:00:00 | GC | Futures | 1341.2 | 1344.8 | 1341.0 | 1344.1 | 372.0 |
| 2008-05-25 21:00:00 | GC | Futures | 1344.2 | 1344.4 | 1342.5 | 1342.5 | 188.0 |
| 2008-05-25 22:00:00 | GC | Futures | 1343.2 | 1343.2 | 1341.7 | 1342.5 | 50.0 |
| 2008-05-25 23:00:00 | GC | Futures | 1342.5 | 1342.8 | 1342.0 | 1342.3 | 129.0 |
| 2008-05-25 18:00:00 | ZN | Futures | 85.442088 | 85.488335 | 85.430526 | 85.465211 | 2044.0 |
| 2008-05-25 19:00:00 | ZN | Futures | 85.465211 | 85.499897 | 85.430526 | 85.430526 | 1648.0 |
| 2008-05-25 20:00:00 | ZN | Futures | 85.430526 | 85.442088 | 85.384279 | 85.407402 | 2096.0 |
| 2008-05-25 21:00:00 | ZN | Futures | 85.407402 | 85.418964 | 85.372717 | 85.407402 | 1512.0 |
| 2008-05-25 22:00:00 | ZN | Futures | 85.407402 | 85.442088 | 85.39584 | 85.430526 | 608.0 |
| 2008-05-25 23:00:00 | ZN | Futures | 85.418964 | 85.465211 | 85.418964 | 85.442088 | 772.0 |
> showing 36 of 150 rows — these rows as CSV