PREVIEW / futures_1hour / 2010-01-10
file: by_date/futures_1hour/2010/2010-01-10.parquet size: 13 KB rows: 243
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 |
|---|---|---|---|---|---|---|---|
| 2010-01-10 18:00:00 | ES | Futures | 1110.96 | 1115.34 | 1109.99 | 1114.61 | 18265.0 |
| 2010-01-10 19:00:00 | ES | Futures | 1114.86 | 1115.58 | 1114.37 | 1114.61 | 4426.0 |
| 2010-01-10 20:00:00 | ES | Futures | 1114.86 | 1115.58 | 1114.13 | 1115.1 | 6362.0 |
| 2010-01-10 21:00:00 | ES | Futures | 1115.34 | 1115.83 | 1115.1 | 1115.83 | 2427.0 |
| 2010-01-10 22:00:00 | ES | Futures | 1115.58 | 1116.56 | 1115.58 | 1116.31 | 7062.0 |
| 2010-01-10 23:00:00 | ES | Futures | 1115.83 | 1116.56 | 1115.83 | 1116.07 | 1023.0 |
| 2010-01-10 18:00:00 | NQ | Futures | 2161.93 | 2168.5 | 2158.79 | 2167.64 | 1411.0 |
| 2010-01-10 19:00:00 | NQ | Futures | 2167.64 | 2169.35 | 2167.35 | 2168.21 | 632.0 |
| 2010-01-10 20:00:00 | NQ | Futures | 2167.93 | 2169.07 | 2166.78 | 2168.21 | 410.0 |
| 2010-01-10 21:00:00 | NQ | Futures | 2168.5 | 2169.35 | 2167.93 | 2169.07 | 195.0 |
| 2010-01-10 22:00:00 | NQ | Futures | 2169.07 | 2170.78 | 2168.78 | 2169.64 | 323.0 |
| 2010-01-10 23:00:00 | NQ | Futures | 2169.64 | 2170.21 | 2169.07 | 2169.92 | 79.0 |
| 2010-01-10 18:00:00 | YM | Futures | 9894.3 | 9923.3 | 9885.0 | 9918.7 | 718.0 |
| 2010-01-10 19:00:00 | YM | Futures | 9916.8 | 9924.3 | 9914.9 | 9918.7 | 223.0 |
| 2010-01-10 20:00:00 | YM | Futures | 9918.7 | 9924.3 | 9914.9 | 9924.3 | 281.0 |
| 2010-01-10 21:00:00 | YM | Futures | 9922.4 | 9927.1 | 9918.7 | 9925.2 | 204.0 |
| 2010-01-10 22:00:00 | YM | Futures | 9925.2 | 9931.8 | 9924.3 | 9928.0 | 213.0 |
| 2010-01-10 23:00:00 | YM | Futures | 9927.1 | 9930.8 | 9926.2 | 9926.2 | 50.0 |
| 2010-01-10 18:00:00 | CL | Futures | 177.98 | 179.22 | 177.98 | 179.03 | 1933.0 |
| 2010-01-10 19:00:00 | CL | Futures | 179.03 | 179.35 | 178.94 | 179.26 | 1498.0 |
| 2010-01-10 20:00:00 | CL | Futures | 179.22 | 179.67 | 179.05 | 179.07 | 1653.0 |
| 2010-01-10 21:00:00 | CL | Futures | 179.07 | 179.11 | 178.88 | 179.07 | 686.0 |
| 2010-01-10 22:00:00 | CL | Futures | 179.09 | 179.2 | 179.03 | 179.09 | 745.0 |
| 2010-01-10 23:00:00 | CL | Futures | 179.09 | 179.39 | 179.05 | 179.24 | 753.0 |
| 2010-01-10 18:00:00 | GC | Futures | 1605.2 | 1639.0 | 1605.2 | 1627.0 | 8992.0 |
| 2010-01-10 19:00:00 | GC | Futures | 1627.3 | 1632.6 | 1624.5 | 1628.1 | 3818.0 |
| 2010-01-10 20:00:00 | GC | Futures | 1628.1 | 1631.2 | 1625.3 | 1627.3 | 3265.0 |
| 2010-01-10 21:00:00 | GC | Futures | 1627.3 | 1630.1 | 1625.2 | 1629.4 | 2037.0 |
| 2010-01-10 22:00:00 | GC | Futures | 1629.4 | 1630.2 | 1627.1 | 1628.1 | 1680.0 |
| 2010-01-10 23:00:00 | GC | Futures | 1628.1 | 1628.7 | 1623.5 | 1624.9 | 1825.0 |
| 2010-01-10 18:00:00 | ZN | Futures | 94.083098 | 94.095789 | 94.01964 | 94.032331 | 3621.0 |
| 2010-01-10 19:00:00 | ZN | Futures | 94.045023 | 94.133864 | 94.01964 | 94.070406 | 2720.0 |
| 2010-01-10 20:00:00 | ZN | Futures | 94.070406 | 94.083098 | 94.01964 | 94.045023 | 1533.0 |
| 2010-01-10 21:00:00 | ZN | Futures | 94.045023 | 94.057714 | 94.032331 | 94.032331 | 745.0 |
| 2010-01-10 22:00:00 | ZN | Futures | 94.032331 | 94.095789 | 94.032331 | 94.083098 | 1293.0 |
| 2010-01-10 23:00:00 | ZN | Futures | 94.083098 | 94.095789 | 94.057714 | 94.083098 | 370.0 |
> showing 36 of 243 rows — these rows as CSV