PREVIEW / futures_1hour / 2015-04-03
file: by_date/futures_1hour/2015/2015-04-03.parquet size: 15 KB rows: 298
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-04-03 00:00:00 | ES | Futures | 2176.86 | 2177.39 | 2174.75 | 2176.07 | 1224.0 |
| 2015-04-03 01:00:00 | ES | Futures | 2176.07 | 2177.39 | 2175.8 | 2177.39 | 758.0 |
| 2015-04-03 02:00:00 | ES | Futures | 2177.39 | 2179.24 | 2176.33 | 2177.39 | 1400.0 |
| 2015-04-03 03:00:00 | ES | Futures | 2177.39 | 2177.65 | 2176.86 | 2177.65 | 264.0 |
| 2015-04-03 04:00:00 | ES | Futures | 2177.39 | 2180.03 | 2177.39 | 2179.24 | 1818.0 |
| 2015-04-03 05:00:00 | ES | Futures | 2179.24 | 2179.76 | 2178.97 | 2179.24 | 314.0 |
| 2015-04-03 06:00:00 | ES | Futures | 2179.24 | 2180.29 | 2178.97 | 2179.76 | 1106.0 |
| 2015-04-03 07:00:00 | ES | Futures | 2179.76 | 2180.03 | 2176.86 | 2177.12 | 2357.0 |
| 2015-04-03 08:00:00 | ES | Futures | 2177.12 | 2179.5 | 2157.58 | 2157.84 | 55770.0 |
| 2015-04-03 09:00:00 | ES | Futures | 2157.84 | 2158.9 | 2153.09 | 2154.94 | 25624.0 |
| 2015-04-03 00:00:00 | NQ | Futures | 5065.83 | 5067.3 | 5062.89 | 5065.54 | 201.0 |
| 2015-04-03 01:00:00 | NQ | Futures | 5065.54 | 5067.6 | 5064.36 | 5067.6 | 143.0 |
| 2015-04-03 02:00:00 | NQ | Futures | 5068.19 | 5072.01 | 5066.42 | 5069.66 | 246.0 |
| 2015-04-03 03:00:00 | NQ | Futures | 5069.66 | 5070.24 | 5068.77 | 5070.24 | 82.0 |
| 2015-04-03 04:00:00 | NQ | Futures | 5069.95 | 5074.07 | 5069.95 | 5072.6 | 195.0 |
| 2015-04-03 05:00:00 | NQ | Futures | 5072.01 | 5072.3 | 5070.54 | 5072.01 | 70.0 |
| 2015-04-03 06:00:00 | NQ | Futures | 5071.42 | 5073.77 | 5071.13 | 5073.18 | 206.0 |
| 2015-04-03 07:00:00 | NQ | Futures | 5072.89 | 5072.89 | 5068.19 | 5072.01 | 385.0 |
| 2015-04-03 08:00:00 | NQ | Futures | 5072.3 | 5073.77 | 5028.49 | 5029.07 | 7152.0 |
| 2015-04-03 09:00:00 | NQ | Futures | 5028.49 | 5031.43 | 5013.2 | 5014.37 | 2342.0 |
| 2015-04-03 00:00:00 | YM | Futures | 18542.5 | 18547.8 | 18511.1 | 18524.7 | 1486.0 |
| 2015-04-03 01:00:00 | YM | Futures | 18523.6 | 18542.5 | 18521.5 | 18542.5 | 500.0 |
| 2015-04-03 02:00:00 | YM | Futures | 18543.6 | 18563.5 | 18532.0 | 18542.5 | 1731.0 |
| 2015-04-03 03:00:00 | YM | Futures | 18543.6 | 18549.9 | 18540.4 | 18548.8 | 123.0 |
| 2015-04-03 04:00:00 | YM | Futures | 18548.8 | 18559.3 | 18543.6 | 18554.1 | 604.0 |
| 2015-04-03 05:00:00 | YM | Futures | 18552.0 | 18556.2 | 18552.0 | 18554.1 | 60.0 |
| 2015-04-03 06:00:00 | YM | Futures | 18555.1 | 18562.4 | 18550.9 | 18559.3 | 221.0 |
| 2015-04-03 07:00:00 | YM | Futures | 18558.3 | 18558.3 | 18538.3 | 18539.4 | 393.0 |
| 2015-04-03 08:00:00 | YM | Futures | 18542.5 | 18563.5 | 18378.9 | 18381.0 | 7177.0 |
| 2015-04-03 09:00:00 | YM | Futures | 18380.0 | 18390.5 | 18346.4 | 18363.2 | 2227.0 |
| 2015-04-03 00:00:00 | ZN | Futures | 123.410179 | 123.454979 | 123.410179 | 123.454979 | 1060.0 |
| 2015-04-03 01:00:00 | ZN | Futures | 123.454979 | 123.469913 | 123.440046 | 123.454979 | 991.0 |
| 2015-04-03 02:00:00 | ZN | Futures | 123.469913 | 123.469913 | 123.440046 | 123.454979 | 1716.0 |
| 2015-04-03 03:00:00 | ZN | Futures | 123.454979 | 123.469913 | 123.440046 | 123.469913 | 1260.0 |
| 2015-04-03 04:00:00 | ZN | Futures | 123.454979 | 123.49978 | 123.440046 | 123.469913 | 2726.0 |
| 2015-04-03 05:00:00 | ZN | Futures | 123.469913 | 123.49978 | 123.469913 | 123.484846 | 1012.0 |
| 2015-04-03 06:00:00 | ZN | Futures | 123.484846 | 123.484846 | 123.440046 | 123.469913 | 3271.0 |
| 2015-04-03 07:00:00 | ZN | Futures | 123.469913 | 123.514713 | 123.425112 | 123.514713 | 14098.0 |
| 2015-04-03 08:00:00 | ZN | Futures | 123.49978 | 124.365921 | 123.484846 | 124.306187 | 205380.0 |
| 2015-04-03 09:00:00 | ZN | Futures | 124.306187 | 124.32112 | 124.097118 | 124.186719 | 73093.0 |
| 2015-04-03 10:00:00 | ZN | Futures | 124.186719 | 124.261387 | 124.141919 | 124.171786 | 33216.0 |
| 2015-04-03 11:00:00 | ZN | Futures | 124.171786 | 124.171786 | 124.126985 | 124.141919 | 6490.0 |
> showing 42 of 298 rows — these rows as CSV