PREVIEW / futures_1hour / 2010-05-09
file: by_date/futures_1hour/2010/2010-05-09.parquet size: 14 KB rows: 260
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-05-09 18:00:00 | ES | Futures | 1100.16 | 1105.54 | 1098.21 | 1101.14 | 63850.0 |
| 2010-05-09 19:00:00 | ES | Futures | 1101.38 | 1103.83 | 1096.5 | 1100.16 | 26872.0 |
| 2010-05-09 20:00:00 | ES | Futures | 1100.41 | 1107.5 | 1099.92 | 1106.76 | 47352.0 |
| 2010-05-09 21:00:00 | ES | Futures | 1107.01 | 1110.18 | 1104.32 | 1109.7 | 39633.0 |
| 2010-05-09 22:00:00 | ES | Futures | 1109.7 | 1111.65 | 1109.21 | 1109.45 | 22270.0 |
| 2010-05-09 23:00:00 | ES | Futures | 1109.45 | 1113.12 | 1107.98 | 1112.14 | 19614.0 |
| 2010-05-09 18:00:00 | NQ | Futures | 2146.36 | 2161.83 | 2144.64 | 2153.81 | 3243.0 |
| 2010-05-09 19:00:00 | NQ | Futures | 2152.95 | 2158.68 | 2144.64 | 2151.52 | 1787.0 |
| 2010-05-09 20:00:00 | NQ | Futures | 2151.23 | 2164.4 | 2150.37 | 2163.26 | 2338.0 |
| 2010-05-09 21:00:00 | NQ | Futures | 2162.97 | 2170.99 | 2158.68 | 2169.85 | 2548.0 |
| 2010-05-09 22:00:00 | NQ | Futures | 2170.13 | 2173.85 | 2168.13 | 2168.7 | 1224.0 |
| 2010-05-09 23:00:00 | NQ | Futures | 2169.27 | 2175.86 | 2165.84 | 2174.14 | 1968.0 |
| 2010-05-09 18:00:00 | YM | Futures | 9847.4 | 9907.6 | 9847.4 | 9871.8 | 1527.0 |
| 2010-05-09 19:00:00 | YM | Futures | 9872.8 | 9889.7 | 9834.2 | 9862.4 | 878.0 |
| 2010-05-09 20:00:00 | YM | Futures | 9861.5 | 9915.1 | 9858.6 | 9911.3 | 2656.0 |
| 2010-05-09 21:00:00 | YM | Futures | 9912.3 | 9933.0 | 9890.6 | 9929.2 | 2714.0 |
| 2010-05-09 22:00:00 | YM | Futures | 9928.3 | 9946.2 | 9924.5 | 9926.4 | 1048.0 |
| 2010-05-09 23:00:00 | YM | Futures | 9925.5 | 9953.7 | 9916.0 | 9945.2 | 1101.0 |
| 2010-05-09 18:00:00 | CL | Futures | 159.18 | 159.98 | 158.53 | 159.26 | 5218.0 |
| 2010-05-09 19:00:00 | CL | Futures | 159.26 | 159.56 | 158.6 | 159.14 | 1608.0 |
| 2010-05-09 20:00:00 | CL | Futures | 159.12 | 160.0 | 159.06 | 159.6 | 3537.0 |
| 2010-05-09 21:00:00 | CL | Futures | 159.6 | 160.52 | 159.22 | 160.16 | 2575.0 |
| 2010-05-09 22:00:00 | CL | Futures | 160.23 | 160.67 | 159.93 | 160.39 | 2146.0 |
| 2010-05-09 23:00:00 | CL | Futures | 160.37 | 160.81 | 160.29 | 160.69 | 1209.0 |
| 2010-05-09 18:00:00 | GC | Futures | 1697.1 | 1697.1 | 1681.8 | 1689.0 | 4810.0 |
| 2010-05-09 19:00:00 | GC | Futures | 1689.0 | 1690.8 | 1685.7 | 1688.1 | 1312.0 |
| 2010-05-09 20:00:00 | GC | Futures | 1688.1 | 1694.3 | 1684.9 | 1692.1 | 4162.0 |
| 2010-05-09 21:00:00 | GC | Futures | 1691.5 | 1696.4 | 1690.1 | 1691.6 | 2706.0 |
| 2010-05-09 22:00:00 | GC | Futures | 1691.6 | 1691.9 | 1685.6 | 1689.7 | 2648.0 |
| 2010-05-09 23:00:00 | GC | Futures | 1689.5 | 1689.5 | 1682.2 | 1686.7 | 3215.0 |
| 2010-05-09 18:00:00 | ZN | Futures | 98.104835 | 98.104835 | 97.899273 | 97.963511 | 24516.0 |
| 2010-05-09 19:00:00 | ZN | Futures | 97.963511 | 98.091988 | 97.963511 | 98.040597 | 7118.0 |
| 2010-05-09 20:00:00 | ZN | Futures | 98.040597 | 98.053445 | 97.69371 | 97.745101 | 34353.0 |
| 2010-05-09 21:00:00 | ZN | Futures | 97.745101 | 97.809339 | 97.629471 | 97.706558 | 21627.0 |
| 2010-05-09 22:00:00 | ZN | Futures | 97.69371 | 97.706558 | 97.616624 | 97.680862 | 7590.0 |
| 2010-05-09 23:00:00 | ZN | Futures | 97.668014 | 97.668014 | 97.513842 | 97.552385 | 9331.0 |
> showing 36 of 260 rows — these rows as CSV