PREVIEW / futures_1hour / 2009-06-28
file: by_date/futures_1hour/2009/2009-06-28.parquet size: 12 KB rows: 209
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 |
|---|---|---|---|---|---|---|---|
| 2009-06-28 18:00:00 | ES | Futures | 880.74 | 881.7 | 878.81 | 879.29 | 3792.0 |
| 2009-06-28 19:00:00 | ES | Futures | 879.29 | 880.5 | 878.81 | 879.53 | 2404.0 |
| 2009-06-28 20:00:00 | ES | Futures | 879.77 | 880.26 | 878.57 | 879.29 | 2937.0 |
| 2009-06-28 21:00:00 | ES | Futures | 879.53 | 880.26 | 879.29 | 879.77 | 1521.0 |
| 2009-06-28 22:00:00 | ES | Futures | 879.77 | 879.77 | 878.81 | 879.29 | 1639.0 |
| 2009-06-28 23:00:00 | ES | Futures | 879.53 | 879.53 | 879.05 | 879.29 | 668.0 |
| 2009-06-28 18:00:00 | NQ | Futures | 1681.52 | 1681.52 | 1677.53 | 1678.39 | 154.0 |
| 2009-06-28 19:00:00 | NQ | Futures | 1677.82 | 1680.1 | 1676.96 | 1679.24 | 83.0 |
| 2009-06-28 20:00:00 | NQ | Futures | 1679.24 | 1680.67 | 1677.53 | 1678.39 | 208.0 |
| 2009-06-28 21:00:00 | NQ | Futures | 1678.39 | 1680.67 | 1678.39 | 1680.1 | 106.0 |
| 2009-06-28 22:00:00 | NQ | Futures | 1678.67 | 1679.53 | 1677.25 | 1677.53 | 53.0 |
| 2009-06-28 23:00:00 | NQ | Futures | 1678.1 | 1678.96 | 1678.1 | 1678.67 | 57.0 |
| 2009-06-28 18:00:00 | YM | Futures | 7740.1 | 7741.1 | 7718.9 | 7724.4 | 169.0 |
| 2009-06-28 19:00:00 | YM | Futures | 7724.4 | 7731.8 | 7719.8 | 7730.0 | 60.0 |
| 2009-06-28 20:00:00 | YM | Futures | 7728.1 | 7733.7 | 7719.8 | 7725.4 | 241.0 |
| 2009-06-28 21:00:00 | YM | Futures | 7726.3 | 7732.8 | 7725.4 | 7727.2 | 97.0 |
| 2009-06-28 22:00:00 | YM | Futures | 7728.1 | 7731.8 | 7725.4 | 7725.4 | 160.0 |
| 2009-06-28 23:00:00 | YM | Futures | 7726.3 | 7730.0 | 7724.4 | 7728.1 | 38.0 |
| 2009-06-28 18:00:00 | CL | Futures | 163.985 | 164.245 | 163.251 | 163.748 | 404.0 |
| 2009-06-28 19:00:00 | CL | Futures | 163.748 | 163.795 | 163.061 | 163.369 | 219.0 |
| 2009-06-28 20:00:00 | CL | Futures | 163.322 | 163.7 | 163.298 | 163.416 | 371.0 |
| 2009-06-28 21:00:00 | CL | Futures | 163.44 | 163.44 | 161.877 | 162.067 | 1223.0 |
| 2009-06-28 22:00:00 | CL | Futures | 162.138 | 162.611 | 162.138 | 162.327 | 275.0 |
| 2009-06-28 23:00:00 | CL | Futures | 162.28 | 163.061 | 162.209 | 162.99 | 241.0 |
| 2009-06-28 18:00:00 | GC | Futures | 1332.7 | 1333.0 | 1322.7 | 1327.2 | 921.0 |
| 2009-06-28 19:00:00 | GC | Futures | 1327.2 | 1330.3 | 1327.1 | 1329.8 | 235.0 |
| 2009-06-28 20:00:00 | GC | Futures | 1329.9 | 1330.8 | 1328.1 | 1330.1 | 582.0 |
| 2009-06-28 21:00:00 | GC | Futures | 1330.1 | 1330.2 | 1325.2 | 1327.1 | 1022.0 |
| 2009-06-28 22:00:00 | GC | Futures | 1327.1 | 1327.4 | 1325.5 | 1326.1 | 478.0 |
| 2009-06-28 23:00:00 | GC | Futures | 1326.2 | 1328.6 | 1326.2 | 1328.2 | 462.0 |
| 2009-06-28 18:00:00 | ZN | Futures | 92.295563 | 92.357564 | 92.258362 | 92.283162 | 428.0 |
| 2009-06-28 19:00:00 | ZN | Futures | 92.283162 | 92.320363 | 92.270762 | 92.320363 | 835.0 |
| 2009-06-28 20:00:00 | ZN | Futures | 92.307963 | 92.332764 | 92.208761 | 92.233561 | 1816.0 |
| 2009-06-28 21:00:00 | ZN | Futures | 92.233561 | 92.258362 | 92.208761 | 92.221161 | 1357.0 |
| 2009-06-28 22:00:00 | ZN | Futures | 92.221161 | 92.233561 | 92.159159 | 92.18396 | 1310.0 |
| 2009-06-28 23:00:00 | ZN | Futures | 92.17156 | 92.19636 | 92.146759 | 92.19636 | 1298.0 |
> showing 36 of 209 rows — these rows as CSV