PREVIEW / futures_1hour / 2010-09-12
file: by_date/futures_1hour/2010/2010-09-12.parquet size: 13 KB rows: 249
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-12 18:00:00 | ES | Futures | 1091.94 | 1097.34 | 1091.45 | 1094.88 | 6474.0 |
| 2010-09-12 19:00:00 | ES | Futures | 1094.88 | 1095.86 | 1094.39 | 1095.86 | 1163.0 |
| 2010-09-12 20:00:00 | ES | Futures | 1095.86 | 1097.34 | 1095.62 | 1096.85 | 3881.0 |
| 2010-09-12 21:00:00 | ES | Futures | 1096.85 | 1097.34 | 1095.62 | 1096.11 | 1136.0 |
| 2010-09-12 22:00:00 | ES | Futures | 1096.11 | 1097.83 | 1096.11 | 1097.83 | 1312.0 |
| 2010-09-12 23:00:00 | ES | Futures | 1097.83 | 1098.81 | 1096.6 | 1098.07 | 2607.0 |
| 2010-09-12 18:00:00 | NQ | Futures | 2173.89 | 2181.63 | 2173.89 | 2179.62 | 739.0 |
| 2010-09-12 19:00:00 | NQ | Futures | 2178.47 | 2181.63 | 2178.47 | 2181.63 | 59.0 |
| 2010-09-12 20:00:00 | NQ | Futures | 2181.63 | 2185.07 | 2181.63 | 2183.35 | 325.0 |
| 2010-09-12 21:00:00 | NQ | Futures | 2182.49 | 2184.49 | 2181.91 | 2182.2 | 151.0 |
| 2010-09-12 22:00:00 | NQ | Futures | 2182.49 | 2185.64 | 2182.49 | 2185.35 | 184.0 |
| 2010-09-12 23:00:00 | NQ | Futures | 2185.93 | 2187.93 | 2184.49 | 2187.07 | 61.0 |
| 2010-09-12 18:00:00 | YM | Futures | 9954.3 | 9992.4 | 9927.6 | 9944.8 | 639.0 |
| 2010-09-12 19:00:00 | YM | Futures | 9946.7 | 9959.1 | 9944.8 | 9958.1 | 377.0 |
| 2010-09-12 20:00:00 | YM | Futures | 9959.1 | 9969.5 | 9959.1 | 9965.7 | 458.0 |
| 2010-09-12 21:00:00 | YM | Futures | 9966.7 | 9968.6 | 9959.1 | 9961.0 | 206.0 |
| 2010-09-12 22:00:00 | YM | Futures | 9961.0 | 9974.3 | 9961.0 | 9974.3 | 214.0 |
| 2010-09-12 23:00:00 | YM | Futures | 9973.4 | 9982.9 | 9967.6 | 9980.0 | 204.0 |
| 2010-09-12 18:00:00 | CL | Futures | 145.96 | 147.03 | 145.96 | 146.84 | 1442.0 |
| 2010-09-12 19:00:00 | CL | Futures | 146.8 | 147.06 | 146.74 | 147.05 | 431.0 |
| 2010-09-12 20:00:00 | CL | Futures | 147.05 | 147.79 | 146.99 | 147.68 | 2212.0 |
| 2010-09-12 21:00:00 | CL | Futures | 147.68 | 147.79 | 147.47 | 147.56 | 855.0 |
| 2010-09-12 22:00:00 | CL | Futures | 147.56 | 147.81 | 147.54 | 147.79 | 875.0 |
| 2010-09-12 23:00:00 | CL | Futures | 147.81 | 147.81 | 147.43 | 147.5 | 689.0 |
| 2010-09-12 18:00:00 | GC | Futures | 1745.0 | 1746.4 | 1742.5 | 1743.6 | 419.0 |
| 2010-09-12 19:00:00 | GC | Futures | 1743.9 | 1745.0 | 1741.4 | 1742.2 | 586.0 |
| 2010-09-12 20:00:00 | GC | Futures | 1742.2 | 1744.9 | 1739.8 | 1744.6 | 1901.0 |
| 2010-09-12 21:00:00 | GC | Futures | 1744.5 | 1745.2 | 1743.8 | 1745.0 | 1245.0 |
| 2010-09-12 22:00:00 | GC | Futures | 1745.0 | 1745.3 | 1743.9 | 1745.2 | 604.0 |
| 2010-09-12 23:00:00 | GC | Futures | 1745.0 | 1746.3 | 1744.7 | 1744.7 | 501.0 |
| 2010-09-12 18:00:00 | ZN | Futures | 102.827791 | 102.827791 | 102.69753 | 102.723583 | 6978.0 |
| 2010-09-12 19:00:00 | ZN | Futures | 102.710556 | 102.749635 | 102.671478 | 102.684504 | 4785.0 |
| 2010-09-12 20:00:00 | ZN | Futures | 102.684504 | 102.710556 | 102.671478 | 102.684504 | 16421.0 |
| 2010-09-12 21:00:00 | ZN | Futures | 102.684504 | 102.710556 | 102.606348 | 102.606348 | 10914.0 |
| 2010-09-12 22:00:00 | ZN | Futures | 102.6324 | 102.645426 | 102.56727 | 102.606348 | 6606.0 |
| 2010-09-12 23:00:00 | ZN | Futures | 102.619374 | 102.6324 | 102.56727 | 102.593322 | 2656.0 |
> showing 36 of 249 rows — these rows as CSV