PREVIEW / futures_1hour / 2008-08-10
file: by_date/futures_1hour/2008/2008-08-10.parquet size: 13 KB rows: 237
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-08-10 18:00:00 | ES | Futures | 1200.66 | 1201.12 | 1199.26 | 1200.43 | 4007.0 |
| 2008-08-10 19:00:00 | ES | Futures | 1200.66 | 1201.12 | 1199.73 | 1200.66 | 1510.0 |
| 2008-08-10 20:00:00 | ES | Futures | 1200.66 | 1202.05 | 1199.5 | 1200.43 | 2951.0 |
| 2008-08-10 21:00:00 | ES | Futures | 1200.43 | 1200.66 | 1198.8 | 1198.8 | 2371.0 |
| 2008-08-10 22:00:00 | ES | Futures | 1199.03 | 1199.26 | 1198.33 | 1198.8 | 815.0 |
| 2008-08-10 23:00:00 | ES | Futures | 1199.03 | 1200.19 | 1198.8 | 1200.19 | 744.0 |
| 2008-08-10 18:00:00 | NQ | Futures | 2161.42 | 2163.39 | 2159.74 | 2163.39 | 511.0 |
| 2008-08-10 19:00:00 | NQ | Futures | 2162.27 | 2162.55 | 2161.42 | 2162.27 | 133.0 |
| 2008-08-10 20:00:00 | NQ | Futures | 2161.99 | 2164.8 | 2161.42 | 2162.55 | 182.0 |
| 2008-08-10 21:00:00 | NQ | Futures | 2162.55 | 2163.39 | 2160.02 | 2160.02 | 197.0 |
| 2008-08-10 22:00:00 | NQ | Futures | 2160.02 | 2161.42 | 2158.89 | 2160.02 | 59.0 |
| 2008-08-10 23:00:00 | NQ | Futures | 2160.3 | 2161.42 | 2158.89 | 2161.42 | 100.0 |
| 2008-08-10 18:00:00 | YM | Futures | 10621.1 | 10631.1 | 10608.4 | 10613.8 | 136.0 |
| 2008-08-10 19:00:00 | YM | Futures | 10611.1 | 10618.4 | 10610.2 | 10615.7 | 39.0 |
| 2008-08-10 20:00:00 | YM | Futures | 10614.7 | 10625.6 | 10608.4 | 10612.9 | 123.0 |
| 2008-08-10 21:00:00 | YM | Futures | 10612.9 | 10617.5 | 10601.1 | 10602.9 | 166.0 |
| 2008-08-10 22:00:00 | YM | Futures | 10603.8 | 10603.8 | 10599.3 | 10602.0 | 52.0 |
| 2008-08-10 23:00:00 | YM | Futures | 10602.0 | 10609.3 | 10598.4 | 10607.5 | 53.0 |
| 2008-08-10 18:00:00 | CL | Futures | 435.57 | 440.06 | 435.57 | 438.06 | 1621.0 |
| 2008-08-10 19:00:00 | CL | Futures | 438.21 | 440.48 | 438.21 | 438.55 | 922.0 |
| 2008-08-10 20:00:00 | CL | Futures | 438.63 | 440.03 | 436.89 | 439.65 | 796.0 |
| 2008-08-10 21:00:00 | CL | Futures | 439.35 | 440.48 | 439.27 | 439.95 | 373.0 |
| 2008-08-10 22:00:00 | CL | Futures | 439.91 | 440.48 | 438.97 | 440.48 | 623.0 |
| 2008-08-10 23:00:00 | CL | Futures | 440.44 | 441.39 | 440.22 | 441.09 | 588.0 |
| 2008-08-10 18:00:00 | GC | Futures | 1232.3 | 1240.5 | 1230.8 | 1239.1 | 1298.0 |
| 2008-08-10 19:00:00 | GC | Futures | 1239.3 | 1241.1 | 1234.3 | 1235.0 | 856.0 |
| 2008-08-10 20:00:00 | GC | Futures | 1235.1 | 1239.3 | 1234.8 | 1236.5 | 787.0 |
| 2008-08-10 21:00:00 | GC | Futures | 1236.7 | 1241.0 | 1236.3 | 1239.3 | 1238.0 |
| 2008-08-10 22:00:00 | GC | Futures | 1239.3 | 1241.4 | 1238.8 | 1240.1 | 518.0 |
| 2008-08-10 23:00:00 | GC | Futures | 1239.8 | 1241.5 | 1239.7 | 1241.5 | 376.0 |
| 2008-08-10 18:00:00 | ZN | Futures | 86.458964 | 86.470665 | 86.41216 | 86.435562 | 817.0 |
| 2008-08-10 19:00:00 | ZN | Futures | 86.435562 | 86.482366 | 86.41216 | 86.470665 | 1883.0 |
| 2008-08-10 20:00:00 | ZN | Futures | 86.470665 | 86.575974 | 86.470665 | 86.564273 | 3723.0 |
| 2008-08-10 21:00:00 | ZN | Futures | 86.564273 | 86.587675 | 86.540871 | 86.564273 | 3224.0 |
| 2008-08-10 22:00:00 | ZN | Futures | 86.564273 | 86.564273 | 86.52917 | 86.52917 | 1153.0 |
| 2008-08-10 23:00:00 | ZN | Futures | 86.52917 | 86.52917 | 86.482366 | 86.505768 | 2072.0 |
> showing 36 of 237 rows — these rows as CSV