PREVIEW / futures_1hour / 2008-12-14
file: by_date/futures_1hour/2008/2008-12-14.parquet size: 13 KB rows: 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-12-14 18:00:00 | ES | Futures | 838.21 | 846.99 | 835.13 | 842.01 | 9948.0 |
| 2008-12-14 19:00:00 | ES | Futures | 841.77 | 845.8 | 841.3 | 842.01 | 4769.0 |
| 2008-12-14 20:00:00 | ES | Futures | 841.77 | 844.38 | 841.77 | 843.19 | 2679.0 |
| 2008-12-14 21:00:00 | ES | Futures | 843.19 | 843.19 | 841.06 | 841.53 | 2671.0 |
| 2008-12-14 22:00:00 | ES | Futures | 841.53 | 843.67 | 841.53 | 843.19 | 2092.0 |
| 2008-12-14 23:00:00 | ES | Futures | 842.96 | 846.51 | 842.48 | 845.57 | 2021.0 |
| 2008-12-14 18:00:00 | NQ | Futures | 1371.24 | 1381.41 | 1362.77 | 1375.76 | 473.0 |
| 2008-12-14 19:00:00 | NQ | Futures | 1376.04 | 1381.12 | 1373.5 | 1374.63 | 153.0 |
| 2008-12-14 20:00:00 | NQ | Futures | 1375.76 | 1379.43 | 1374.91 | 1376.89 | 92.0 |
| 2008-12-14 21:00:00 | NQ | Futures | 1376.89 | 1376.89 | 1373.78 | 1374.63 | 39.0 |
| 2008-12-14 22:00:00 | NQ | Futures | 1374.91 | 1377.74 | 1374.91 | 1377.74 | 79.0 |
| 2008-12-14 23:00:00 | NQ | Futures | 1378.02 | 1382.82 | 1376.89 | 1380.84 | 93.0 |
| 2008-12-14 18:00:00 | YM | Futures | 7891.6 | 7954.5 | 7860.6 | 7915.3 | 483.0 |
| 2008-12-14 19:00:00 | YM | Futures | 7914.4 | 7946.3 | 7909.9 | 7912.6 | 479.0 |
| 2008-12-14 20:00:00 | YM | Futures | 7915.3 | 7936.3 | 7915.3 | 7929.9 | 234.0 |
| 2008-12-14 21:00:00 | YM | Futures | 7929.9 | 7929.9 | 7914.4 | 7919.0 | 247.0 |
| 2008-12-14 22:00:00 | YM | Futures | 7919.9 | 7935.4 | 7919.0 | 7929.9 | 179.0 |
| 2008-12-14 23:00:00 | YM | Futures | 7933.6 | 7960.0 | 7926.3 | 7950.0 | 208.0 |
| 2008-12-14 18:00:00 | CL | Futures | 172.04 | 175.22 | 172.04 | 174.14 | 151.0 |
| 2008-12-14 19:00:00 | CL | Futures | 174.14 | 174.87 | 174.0 | 174.24 | 70.0 |
| 2008-12-14 20:00:00 | CL | Futures | 174.17 | 174.66 | 173.47 | 174.35 | 51.0 |
| 2008-12-14 21:00:00 | CL | Futures | 174.59 | 175.85 | 174.59 | 175.74 | 135.0 |
| 2008-12-14 22:00:00 | CL | Futures | 175.88 | 175.88 | 174.21 | 174.52 | 60.0 |
| 2008-12-14 23:00:00 | CL | Futures | 174.21 | 175.01 | 172.57 | 173.93 | 105.0 |
| 2008-12-14 18:00:00 | GC | Futures | 1176.3 | 1182.0 | 1174.9 | 1180.0 | 1035.0 |
| 2008-12-14 19:00:00 | GC | Futures | 1179.9 | 1183.7 | 1178.7 | 1179.4 | 1050.0 |
| 2008-12-14 20:00:00 | GC | Futures | 1179.6 | 1186.8 | 1179.0 | 1185.3 | 1237.0 |
| 2008-12-14 21:00:00 | GC | Futures | 1186.0 | 1186.1 | 1182.0 | 1182.9 | 627.0 |
| 2008-12-14 22:00:00 | GC | Futures | 1182.9 | 1186.4 | 1180.7 | 1186.1 | 725.0 |
| 2008-12-14 23:00:00 | GC | Futures | 1186.1 | 1187.6 | 1184.3 | 1186.8 | 752.0 |
| 2008-12-14 18:00:00 | ZN | Futures | 95.908087 | 95.944256 | 95.727242 | 95.763411 | 1301.0 |
| 2008-12-14 19:00:00 | ZN | Futures | 95.763411 | 95.787524 | 95.703129 | 95.751355 | 1566.0 |
| 2008-12-14 20:00:00 | ZN | Futures | 95.751355 | 95.847805 | 95.739298 | 95.787524 | 1283.0 |
| 2008-12-14 21:00:00 | ZN | Futures | 95.775467 | 95.859862 | 95.763411 | 95.811636 | 472.0 |
| 2008-12-14 22:00:00 | ZN | Futures | 95.811636 | 95.811636 | 95.751355 | 95.763411 | 400.0 |
| 2008-12-14 23:00:00 | ZN | Futures | 95.751355 | 95.896031 | 95.739298 | 95.811636 | 1226.0 |
> showing 36 of 226 rows — these rows as CSV