PREVIEW / futures_1hour / 2008-12-21
file: by_date/futures_1hour/2008/2008-12-21.parquet size: 13 KB rows: 220
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-21 18:00:00 | ES | Futures | 838.92 | 840.11 | 836.32 | 839.87 | 3930.0 |
| 2008-12-21 19:00:00 | ES | Futures | 839.87 | 843.91 | 839.87 | 843.91 | 2809.0 |
| 2008-12-21 20:00:00 | ES | Futures | 843.67 | 845.8 | 843.19 | 844.38 | 2249.0 |
| 2008-12-21 21:00:00 | ES | Futures | 844.62 | 844.62 | 841.77 | 842.25 | 1995.0 |
| 2008-12-21 22:00:00 | ES | Futures | 842.01 | 843.43 | 839.64 | 842.72 | 1891.0 |
| 2008-12-21 23:00:00 | ES | Futures | 842.96 | 842.96 | 838.69 | 839.4 | 1312.0 |
| 2008-12-21 18:00:00 | NQ | Futures | 1368.42 | 1374.35 | 1367.0 | 1373.78 | 290.0 |
| 2008-12-21 19:00:00 | NQ | Futures | 1374.06 | 1379.71 | 1373.78 | 1379.43 | 83.0 |
| 2008-12-21 20:00:00 | NQ | Futures | 1379.99 | 1381.97 | 1378.58 | 1379.71 | 67.0 |
| 2008-12-21 21:00:00 | NQ | Futures | 1380.28 | 1380.56 | 1376.89 | 1377.17 | 62.0 |
| 2008-12-21 22:00:00 | NQ | Futures | 1376.89 | 1378.58 | 1372.65 | 1377.45 | 52.0 |
| 2008-12-21 23:00:00 | NQ | Futures | 1374.63 | 1375.19 | 1372.93 | 1374.35 | 14.0 |
| 2008-12-21 18:00:00 | YM | Futures | 7785.9 | 7809.6 | 7781.4 | 7808.7 | 323.0 |
| 2008-12-21 19:00:00 | YM | Futures | 7810.5 | 7842.4 | 7808.7 | 7839.7 | 288.0 |
| 2008-12-21 20:00:00 | YM | Futures | 7840.6 | 7854.3 | 7832.4 | 7843.3 | 293.0 |
| 2008-12-21 21:00:00 | YM | Futures | 7844.2 | 7847.0 | 7827.8 | 7829.7 | 360.0 |
| 2008-12-21 22:00:00 | YM | Futures | 7829.7 | 7840.6 | 7810.5 | 7834.2 | 200.0 |
| 2008-12-21 23:00:00 | YM | Futures | 7832.4 | 7832.4 | 7806.0 | 7809.6 | 201.0 |
| 2008-12-21 18:00:00 | CL | Futures | 149.35 | 150.37 | 148.34 | 148.73 | 576.0 |
| 2008-12-21 19:00:00 | CL | Futures | 148.87 | 151.62 | 148.66 | 151.2 | 835.0 |
| 2008-12-21 20:00:00 | CL | Futures | 151.34 | 151.62 | 150.65 | 150.79 | 365.0 |
| 2008-12-21 21:00:00 | CL | Futures | 150.79 | 150.96 | 150.65 | 150.89 | 143.0 |
| 2008-12-21 22:00:00 | CL | Futures | 150.85 | 150.96 | 150.02 | 150.16 | 467.0 |
| 2008-12-21 23:00:00 | CL | Futures | 150.19 | 150.37 | 149.95 | 150.26 | 323.0 |
| 2008-12-21 18:00:00 | GC | Futures | 1196.8 | 1199.3 | 1193.0 | 1199.3 | 408.0 |
| 2008-12-21 19:00:00 | GC | Futures | 1199.4 | 1209.2 | 1198.3 | 1207.8 | 1721.0 |
| 2008-12-21 20:00:00 | GC | Futures | 1207.8 | 1211.1 | 1207.1 | 1209.0 | 992.0 |
| 2008-12-21 21:00:00 | GC | Futures | 1209.0 | 1209.0 | 1204.2 | 1206.0 | 900.0 |
| 2008-12-21 22:00:00 | GC | Futures | 1205.8 | 1205.8 | 1202.0 | 1203.2 | 348.0 |
| 2008-12-21 23:00:00 | GC | Futures | 1203.1 | 1204.7 | 1202.0 | 1204.4 | 326.0 |
| 2008-12-21 18:00:00 | ZN | Futures | 97.885325 | 97.957663 | 97.812987 | 97.957663 | 778.0 |
| 2008-12-21 19:00:00 | ZN | Futures | 97.969719 | 97.969719 | 97.93355 | 97.945606 | 1258.0 |
| 2008-12-21 20:00:00 | ZN | Futures | 97.945606 | 97.945606 | 97.909437 | 97.909437 | 809.0 |
| 2008-12-21 21:00:00 | ZN | Futures | 97.921494 | 97.93355 | 97.909437 | 97.921494 | 724.0 |
| 2008-12-21 22:00:00 | ZN | Futures | 97.921494 | 97.921494 | 97.897381 | 97.909437 | 1076.0 |
| 2008-12-21 23:00:00 | ZN | Futures | 97.909437 | 97.945606 | 97.909437 | 97.921494 | 282.0 |
> showing 36 of 220 rows — these rows as CSV