PREVIEW / futures_1hour / 2015-10-25
file: by_date/futures_1hour/2015/2015-10-25.parquet size: 14 KB rows: 282
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 |
|---|---|---|---|---|---|---|---|
| 2015-10-25 18:00:00 | ES | Futures | 2211.25 | 2211.25 | 2209.11 | 2210.72 | 3134.0 |
| 2015-10-25 19:00:00 | ES | Futures | 2210.45 | 2210.72 | 2208.31 | 2208.85 | 2135.0 |
| 2015-10-25 20:00:00 | ES | Futures | 2208.85 | 2211.25 | 2206.7 | 2210.45 | 7683.0 |
| 2015-10-25 21:00:00 | ES | Futures | 2210.45 | 2211.52 | 2207.51 | 2208.04 | 7381.0 |
| 2015-10-25 22:00:00 | ES | Futures | 2207.77 | 2209.38 | 2207.51 | 2207.51 | 3441.0 |
| 2015-10-25 23:00:00 | ES | Futures | 2207.77 | 2208.85 | 2206.7 | 2206.97 | 3571.0 |
| 2015-10-25 18:00:00 | NQ | Futures | 5472.04 | 5472.04 | 5466.11 | 5470.85 | 1056.0 |
| 2015-10-25 19:00:00 | NQ | Futures | 5470.85 | 5470.85 | 5463.14 | 5465.52 | 579.0 |
| 2015-10-25 20:00:00 | NQ | Futures | 5465.52 | 5470.56 | 5459.88 | 5468.78 | 1177.0 |
| 2015-10-25 21:00:00 | NQ | Futures | 5468.78 | 5470.85 | 5460.77 | 5462.55 | 1324.0 |
| 2015-10-25 22:00:00 | NQ | Futures | 5462.25 | 5466.4 | 5461.96 | 5463.44 | 631.0 |
| 2015-10-25 23:00:00 | NQ | Futures | 5463.44 | 5466.11 | 5459.88 | 5460.18 | 515.0 |
| 2015-10-25 18:00:00 | YM | Futures | 18585.7 | 18587.8 | 18568.7 | 18579.3 | 610.0 |
| 2015-10-25 19:00:00 | YM | Futures | 18578.2 | 18579.3 | 18559.2 | 18563.4 | 318.0 |
| 2015-10-25 20:00:00 | YM | Futures | 18563.4 | 18580.4 | 18550.7 | 18575.1 | 747.0 |
| 2015-10-25 21:00:00 | YM | Futures | 18576.1 | 18581.4 | 18558.1 | 18566.6 | 1003.0 |
| 2015-10-25 22:00:00 | YM | Futures | 18563.4 | 18575.1 | 18559.2 | 18565.5 | 377.0 |
| 2015-10-25 23:00:00 | YM | Futures | 18563.4 | 18570.8 | 18553.9 | 18557.1 | 347.0 |
| 2015-10-25 18:00:00 | CL | Futures | 63.31 | 63.37 | 63.07 | 63.12 | 1064.0 |
| 2015-10-25 19:00:00 | CL | Futures | 63.12 | 63.17 | 63.09 | 63.12 | 324.0 |
| 2015-10-25 20:00:00 | CL | Futures | 63.13 | 63.16 | 62.89 | 62.9 | 982.0 |
| 2015-10-25 21:00:00 | CL | Futures | 62.89 | 63.17 | 62.89 | 63.16 | 1145.0 |
| 2015-10-25 22:00:00 | CL | Futures | 63.16 | 63.26 | 63.13 | 63.23 | 1024.0 |
| 2015-10-25 23:00:00 | CL | Futures | 63.23 | 63.4 | 63.22 | 63.31 | 1128.0 |
| 2015-10-25 18:00:00 | GC | Futures | 1589.0 | 1589.1 | 1586.6 | 1587.9 | 782.0 |
| 2015-10-25 19:00:00 | GC | Futures | 1587.7 | 1589.5 | 1587.5 | 1589.4 | 359.0 |
| 2015-10-25 20:00:00 | GC | Futures | 1589.4 | 1589.5 | 1586.5 | 1587.5 | 1541.0 |
| 2015-10-25 21:00:00 | GC | Futures | 1587.5 | 1590.5 | 1587.2 | 1590.1 | 2896.0 |
| 2015-10-25 22:00:00 | GC | Futures | 1590.1 | 1591.0 | 1589.2 | 1589.8 | 1958.0 |
| 2015-10-25 23:00:00 | GC | Futures | 1589.7 | 1590.2 | 1589.2 | 1589.7 | 943.0 |
| 2015-10-25 18:00:00 | ZN | Futures | 123.988895 | 124.01907 | 123.973808 | 123.988895 | 3816.0 |
| 2015-10-25 19:00:00 | ZN | Futures | 124.003983 | 124.003983 | 123.95872 | 123.973808 | 2633.0 |
| 2015-10-25 20:00:00 | ZN | Futures | 123.973808 | 124.064333 | 123.973808 | 124.003983 | 10588.0 |
| 2015-10-25 21:00:00 | ZN | Futures | 124.003983 | 124.034158 | 123.988895 | 124.034158 | 5668.0 |
| 2015-10-25 22:00:00 | ZN | Futures | 124.034158 | 124.049245 | 124.01907 | 124.01907 | 2249.0 |
| 2015-10-25 23:00:00 | ZN | Futures | 124.01907 | 124.049245 | 124.01907 | 124.01907 | 3246.0 |
> showing 36 of 282 rows — these rows as CSV