PREVIEW / futures_1hour / 2013-02-24
file: by_date/futures_1hour/2013/2013-02-24.parquet size: 14 KB rows: 264
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 |
|---|---|---|---|---|---|---|---|
| 2013-02-24 18:00:00 | ES | Futures | 1555.46 | 1556.22 | 1554.43 | 1556.22 | 12921.0 |
| 2013-02-24 19:00:00 | ES | Futures | 1556.22 | 1556.22 | 1554.17 | 1554.43 | 5771.0 |
| 2013-02-24 20:00:00 | ES | Futures | 1554.69 | 1554.69 | 1551.61 | 1551.61 | 13617.0 |
| 2013-02-24 21:00:00 | ES | Futures | 1551.86 | 1552.89 | 1551.35 | 1552.89 | 5468.0 |
| 2013-02-24 22:00:00 | ES | Futures | 1552.63 | 1553.15 | 1552.63 | 1553.15 | 2810.0 |
| 2013-02-24 23:00:00 | ES | Futures | 1552.89 | 1553.92 | 1552.38 | 1553.4 | 2034.0 |
| 2013-02-24 18:00:00 | NQ | Futures | 3186.33 | 3188.66 | 3185.46 | 3188.37 | 1212.0 |
| 2013-02-24 19:00:00 | NQ | Futures | 3188.66 | 3188.66 | 3184.3 | 3184.88 | 447.0 |
| 2013-02-24 20:00:00 | NQ | Futures | 3184.88 | 3184.88 | 3179.35 | 3179.35 | 1103.0 |
| 2013-02-24 21:00:00 | NQ | Futures | 3179.35 | 3181.97 | 3179.06 | 3181.39 | 546.0 |
| 2013-02-24 22:00:00 | NQ | Futures | 3181.68 | 3182.55 | 3181.09 | 3181.68 | 258.0 |
| 2013-02-24 23:00:00 | NQ | Futures | 3181.68 | 3182.84 | 3180.8 | 3182.55 | 172.0 |
| 2013-02-24 18:00:00 | YM | Futures | 14069.3 | 14076.3 | 14065.2 | 14075.3 | 924.0 |
| 2013-02-24 19:00:00 | YM | Futures | 14076.3 | 14076.3 | 14061.2 | 14064.2 | 494.0 |
| 2013-02-24 20:00:00 | YM | Futures | 14063.2 | 14063.2 | 14038.1 | 14039.1 | 1443.0 |
| 2013-02-24 21:00:00 | YM | Futures | 14040.1 | 14051.1 | 14039.1 | 14050.1 | 618.0 |
| 2013-02-24 22:00:00 | YM | Futures | 14050.1 | 14053.2 | 14048.1 | 14050.1 | 227.0 |
| 2013-02-24 23:00:00 | YM | Futures | 14052.2 | 14056.2 | 14047.1 | 14054.2 | 207.0 |
| 2013-02-24 18:00:00 | CL | Futures | 148.13 | 148.29 | 147.97 | 148.19 | 1009.0 |
| 2013-02-24 19:00:00 | CL | Futures | 148.21 | 148.22 | 147.95 | 147.98 | 787.0 |
| 2013-02-24 20:00:00 | CL | Futures | 147.98 | 148.1 | 147.78 | 147.78 | 1319.0 |
| 2013-02-24 21:00:00 | CL | Futures | 147.79 | 147.84 | 147.7 | 147.81 | 825.0 |
| 2013-02-24 22:00:00 | CL | Futures | 147.83 | 147.87 | 147.78 | 147.79 | 231.0 |
| 2013-02-24 23:00:00 | CL | Futures | 147.81 | 147.9 | 147.78 | 147.83 | 450.0 |
| 2013-02-24 18:00:00 | GC | Futures | 2172.4 | 2173.7 | 2169.3 | 2170.2 | 1943.0 |
| 2013-02-24 19:00:00 | GC | Futures | 2170.0 | 2170.9 | 2165.5 | 2167.8 | 3701.0 |
| 2013-02-24 20:00:00 | GC | Futures | 2167.7 | 2175.4 | 2167.7 | 2174.4 | 5381.0 |
| 2013-02-24 21:00:00 | GC | Futures | 2174.6 | 2179.2 | 2173.7 | 2176.9 | 3758.0 |
| 2013-02-24 22:00:00 | GC | Futures | 2177.0 | 2178.7 | 2175.7 | 2176.6 | 2137.0 |
| 2013-02-24 23:00:00 | GC | Futures | 2176.8 | 2178.1 | 2175.5 | 2176.9 | 1466.0 |
| 2013-02-24 18:00:00 | ZN | Futures | 117.37821 | 117.392119 | 117.280847 | 117.322574 | 17183.0 |
| 2013-02-24 19:00:00 | ZN | Futures | 117.336483 | 117.364301 | 117.308665 | 117.364301 | 6303.0 |
| 2013-02-24 20:00:00 | ZN | Futures | 117.364301 | 117.37821 | 117.322574 | 117.350392 | 12422.0 |
| 2013-02-24 21:00:00 | ZN | Futures | 117.350392 | 117.37821 | 117.336483 | 117.350392 | 4338.0 |
| 2013-02-24 22:00:00 | ZN | Futures | 117.336483 | 117.364301 | 117.336483 | 117.350392 | 1412.0 |
| 2013-02-24 23:00:00 | ZN | Futures | 117.350392 | 117.364301 | 117.336483 | 117.350392 | 1878.0 |
> showing 36 of 264 rows — these rows as CSV