PREVIEW / futures_1hour / 2008-09-21
file: by_date/futures_1hour/2008/2008-09-21.parquet size: 13 KB rows: 225
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-09-21 18:00:00 | ES | Futures | 1177.57 | 1178.04 | 1159.58 | 1161.48 | 48745.0 |
| 2008-09-21 19:00:00 | ES | Futures | 1161.24 | 1173.07 | 1158.16 | 1171.42 | 22983.0 |
| 2008-09-21 20:00:00 | ES | Futures | 1171.65 | 1173.31 | 1166.68 | 1169.76 | 11046.0 |
| 2008-09-21 21:00:00 | ES | Futures | 1170.0 | 1172.84 | 1165.5 | 1169.76 | 11090.0 |
| 2008-09-21 22:00:00 | ES | Futures | 1170.0 | 1170.71 | 1168.1 | 1170.71 | 6019.0 |
| 2008-09-21 23:00:00 | ES | Futures | 1170.71 | 1172.13 | 1169.05 | 1171.42 | 1999.0 |
| 2008-09-21 18:00:00 | NQ | Futures | 1963.77 | 1963.77 | 1938.86 | 1939.71 | 3144.0 |
| 2008-09-21 19:00:00 | NQ | Futures | 1939.15 | 1956.41 | 1930.38 | 1956.41 | 1549.0 |
| 2008-09-21 20:00:00 | NQ | Futures | 1956.41 | 1957.54 | 1948.49 | 1954.99 | 347.0 |
| 2008-09-21 21:00:00 | NQ | Futures | 1953.58 | 1959.24 | 1947.07 | 1956.13 | 1261.0 |
| 2008-09-21 22:00:00 | NQ | Futures | 1956.13 | 1956.69 | 1952.45 | 1956.69 | 302.0 |
| 2008-09-21 23:00:00 | NQ | Futures | 1956.69 | 1957.54 | 1953.58 | 1955.28 | 313.0 |
| 2008-09-21 18:00:00 | YM | Futures | 10301.2 | 10304.8 | 10156.6 | 10163.9 | 2335.0 |
| 2008-09-21 19:00:00 | YM | Futures | 10163.9 | 10253.0 | 10141.1 | 10238.5 | 1308.0 |
| 2008-09-21 20:00:00 | YM | Futures | 10234.8 | 10241.2 | 10196.6 | 10229.4 | 531.0 |
| 2008-09-21 21:00:00 | YM | Futures | 10227.5 | 10250.3 | 10197.5 | 10230.3 | 784.0 |
| 2008-09-21 22:00:00 | YM | Futures | 10228.4 | 10241.2 | 10211.2 | 10241.2 | 289.0 |
| 2008-09-21 23:00:00 | YM | Futures | 10237.5 | 10243.9 | 10223.9 | 10240.3 | 169.0 |
| 2008-09-21 18:00:00 | CL | Futures | 386.52 | 388.1 | 385.01 | 385.01 | 517.0 |
| 2008-09-21 19:00:00 | CL | Futures | 385.01 | 386.4 | 384.63 | 386.21 | 489.0 |
| 2008-09-21 20:00:00 | CL | Futures | 386.4 | 392.25 | 386.21 | 391.31 | 1090.0 |
| 2008-09-21 21:00:00 | CL | Futures | 391.31 | 391.31 | 387.8 | 389.8 | 795.0 |
| 2008-09-21 22:00:00 | CL | Futures | 389.42 | 390.48 | 389.04 | 389.12 | 406.0 |
| 2008-09-21 23:00:00 | CL | Futures | 389.12 | 391.49 | 389.04 | 391.46 | 398.0 |
| 2008-09-21 18:00:00 | GC | Futures | 1248.2 | 1266.4 | 1248.2 | 1258.2 | 1986.0 |
| 2008-09-21 19:00:00 | GC | Futures | 1257.8 | 1263.1 | 1252.4 | 1254.5 | 1341.0 |
| 2008-09-21 20:00:00 | GC | Futures | 1255.0 | 1255.5 | 1248.1 | 1249.1 | 2461.0 |
| 2008-09-21 21:00:00 | GC | Futures | 1249.1 | 1249.4 | 1236.3 | 1240.3 | 3382.0 |
| 2008-09-21 22:00:00 | GC | Futures | 1240.7 | 1249.5 | 1239.7 | 1244.0 | 1975.0 |
| 2008-09-21 23:00:00 | GC | Futures | 1244.1 | 1247.7 | 1244.1 | 1245.2 | 1211.0 |
| 2008-09-21 18:00:00 | ZN | Futures | 87.151437 | 87.375871 | 86.974252 | 87.163249 | 14314.0 |
| 2008-09-21 19:00:00 | ZN | Futures | 87.163249 | 87.411308 | 87.151437 | 87.245936 | 8363.0 |
| 2008-09-21 20:00:00 | ZN | Futures | 87.245936 | 87.364059 | 87.234123 | 87.340434 | 7512.0 |
| 2008-09-21 21:00:00 | ZN | Futures | 87.352247 | 87.423121 | 87.293185 | 87.328622 | 6155.0 |
| 2008-09-21 22:00:00 | ZN | Futures | 87.31681 | 87.340434 | 87.257748 | 87.257748 | 2092.0 |
| 2008-09-21 23:00:00 | ZN | Futures | 87.257748 | 87.328622 | 87.257748 | 87.293185 | 1723.0 |
> showing 36 of 225 rows — these rows as CSV