PREVIEW / futures_1hour / 2010-09-19
file: by_date/futures_1hour/2010/2010-09-19.parquet size: 13 KB rows: 246
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-09-19 18:00:00 | ES | Futures | 1102.75 | 1104.47 | 1101.51 | 1101.76 | 8517.0 |
| 2010-09-19 19:00:00 | ES | Futures | 1102.01 | 1102.5 | 1101.27 | 1102.01 | 3247.0 |
| 2010-09-19 20:00:00 | ES | Futures | 1102.01 | 1104.47 | 1102.01 | 1104.23 | 3063.0 |
| 2010-09-19 21:00:00 | ES | Futures | 1103.98 | 1105.7 | 1103.73 | 1104.96 | 4404.0 |
| 2010-09-19 22:00:00 | ES | Futures | 1104.96 | 1106.44 | 1103.24 | 1103.98 | 4870.0 |
| 2010-09-19 23:00:00 | ES | Futures | 1103.73 | 1104.47 | 1102.25 | 1104.23 | 4760.0 |
| 2010-09-19 18:00:00 | NQ | Futures | 2238.41 | 2242.72 | 2237.27 | 2237.55 | 857.0 |
| 2010-09-19 19:00:00 | NQ | Futures | 2237.27 | 2239.27 | 2234.68 | 2238.41 | 1447.0 |
| 2010-09-19 20:00:00 | NQ | Futures | 2238.41 | 2242.72 | 2238.13 | 2242.43 | 393.0 |
| 2010-09-19 21:00:00 | NQ | Futures | 2242.43 | 2244.73 | 2241.86 | 2243.86 | 308.0 |
| 2010-09-19 22:00:00 | NQ | Futures | 2244.15 | 2247.59 | 2241.86 | 2242.14 | 459.0 |
| 2010-09-19 23:00:00 | NQ | Futures | 2241.86 | 2243.0 | 2240.13 | 2242.72 | 269.0 |
| 2010-09-19 18:00:00 | YM | Futures | 10031.5 | 10041.0 | 10016.2 | 10016.2 | 251.0 |
| 2010-09-19 19:00:00 | YM | Futures | 10020.0 | 10024.8 | 10014.3 | 10020.0 | 107.0 |
| 2010-09-19 20:00:00 | YM | Futures | 10020.0 | 10039.1 | 10020.0 | 10037.2 | 178.0 |
| 2010-09-19 21:00:00 | YM | Futures | 10035.3 | 10049.6 | 10032.4 | 10045.7 | 235.0 |
| 2010-09-19 22:00:00 | YM | Futures | 10045.7 | 10056.2 | 10032.4 | 10034.3 | 236.0 |
| 2010-09-19 23:00:00 | YM | Futures | 10035.3 | 10041.0 | 10023.8 | 10035.3 | 272.0 |
| 2010-09-19 18:00:00 | CL | Futures | 141.54 | 141.94 | 141.51 | 141.58 | 550.0 |
| 2010-09-19 19:00:00 | CL | Futures | 141.58 | 141.7 | 141.56 | 141.64 | 147.0 |
| 2010-09-19 20:00:00 | CL | Futures | 141.62 | 142.09 | 141.56 | 142.04 | 537.0 |
| 2010-09-19 21:00:00 | CL | Futures | 142.04 | 142.38 | 141.96 | 142.38 | 925.0 |
| 2010-09-19 22:00:00 | CL | Futures | 142.38 | 142.6 | 142.09 | 142.09 | 737.0 |
| 2010-09-19 23:00:00 | CL | Futures | 142.09 | 142.55 | 142.09 | 142.51 | 394.0 |
| 2010-09-19 18:00:00 | GC | Futures | 1787.6 | 1792.2 | 1787.6 | 1788.8 | 1315.0 |
| 2010-09-19 19:00:00 | GC | Futures | 1788.9 | 1789.9 | 1784.6 | 1787.6 | 1158.0 |
| 2010-09-19 20:00:00 | GC | Futures | 1788.5 | 1788.7 | 1785.3 | 1788.1 | 622.0 |
| 2010-09-19 21:00:00 | GC | Futures | 1788.1 | 1789.8 | 1787.8 | 1789.8 | 704.0 |
| 2010-09-19 22:00:00 | GC | Futures | 1789.9 | 1793.1 | 1788.8 | 1789.5 | 1680.0 |
| 2010-09-19 23:00:00 | GC | Futures | 1789.5 | 1792.2 | 1788.9 | 1790.5 | 1010.0 |
| 2010-09-19 18:00:00 | ZN | Futures | 103.518173 | 103.648433 | 103.505147 | 103.622381 | 1953.0 |
| 2010-09-19 19:00:00 | ZN | Futures | 103.622381 | 103.674486 | 103.609355 | 103.635407 | 4234.0 |
| 2010-09-19 20:00:00 | ZN | Futures | 103.635407 | 103.674486 | 103.622381 | 103.635407 | 2117.0 |
| 2010-09-19 21:00:00 | ZN | Futures | 103.635407 | 103.635407 | 103.622381 | 103.635407 | 1044.0 |
| 2010-09-19 22:00:00 | ZN | Futures | 103.622381 | 103.648433 | 103.609355 | 103.648433 | 867.0 |
| 2010-09-19 23:00:00 | ZN | Futures | 103.648433 | 103.674486 | 103.635407 | 103.648433 | 1984.0 |
> showing 36 of 246 rows — these rows as CSV