PREVIEW / futures_1hour / 2015-10-19
file: by_date/futures_1hour/2015/2015-10-19.parquet size: 49 KB rows: 1,540
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-19 00:00:00 | ES | Futures | 2162.02 | 2162.82 | 2161.22 | 2162.55 | 2847.0 |
| 2015-10-19 01:00:00 | ES | Futures | 2162.29 | 2163.09 | 2160.95 | 2163.09 | 4121.0 |
| 2015-10-19 02:00:00 | ES | Futures | 2163.09 | 2164.43 | 2160.41 | 2163.62 | 6479.0 |
| 2015-10-19 03:00:00 | ES | Futures | 2163.62 | 2170.58 | 2163.36 | 2168.17 | 24498.0 |
| 2015-10-19 04:00:00 | ES | Futures | 2168.17 | 2168.98 | 2165.5 | 2166.84 | 13164.0 |
| 2015-10-19 05:00:00 | ES | Futures | 2166.84 | 2167.64 | 2165.23 | 2165.5 | 8069.0 |
| 2015-10-19 06:00:00 | ES | Futures | 2165.77 | 2166.84 | 2164.43 | 2164.69 | 7926.0 |
| 2015-10-19 07:00:00 | ES | Futures | 2164.96 | 2165.23 | 2160.95 | 2161.75 | 19697.0 |
| 2015-10-19 08:00:00 | ES | Futures | 2161.75 | 2162.29 | 2157.74 | 2158.27 | 34401.0 |
| 2015-10-19 09:00:00 | ES | Futures | 2158.27 | 2164.43 | 2155.86 | 2164.16 | 174978.0 |
| 2015-10-19 10:00:00 | ES | Futures | 2164.16 | 2166.3 | 2159.61 | 2164.43 | 223582.0 |
| 2015-10-19 11:00:00 | ES | Futures | 2164.16 | 2169.24 | 2161.48 | 2167.37 | 163382.0 |
| 2015-10-19 12:00:00 | ES | Futures | 2167.37 | 2168.71 | 2163.62 | 2165.77 | 93373.0 |
| 2015-10-19 13:00:00 | ES | Futures | 2165.5 | 2166.57 | 2158.27 | 2162.29 | 123500.0 |
| 2015-10-19 14:00:00 | ES | Futures | 2162.02 | 2164.43 | 2159.88 | 2163.89 | 104890.0 |
| 2015-10-19 15:00:00 | ES | Futures | 2163.89 | 2169.51 | 2163.09 | 2168.98 | 194756.0 |
| 2015-10-19 16:00:00 | ES | Futures | 2169.24 | 2170.31 | 2167.64 | 2169.78 | 60847.0 |
| 2015-10-19 18:00:00 | ES | Futures | 2168.98 | 2169.24 | 2167.37 | 2167.64 | 2696.0 |
| 2015-10-19 19:00:00 | ES | Futures | 2167.91 | 2168.71 | 2167.1 | 2167.91 | 1771.0 |
| 2015-10-19 20:00:00 | ES | Futures | 2167.91 | 2168.17 | 2166.3 | 2167.37 | 4221.0 |
| 2015-10-19 21:00:00 | ES | Futures | 2167.37 | 2167.64 | 2165.23 | 2166.84 | 4353.0 |
| 2015-10-19 22:00:00 | ES | Futures | 2166.84 | 2167.91 | 2166.03 | 2167.37 | 3338.0 |
| 2015-10-19 23:00:00 | ES | Futures | 2167.1 | 2168.98 | 2167.1 | 2168.71 | 2055.0 |
| 2015-10-19 00:00:00 | NQ | Futures | 5245.82 | 5247.89 | 5244.63 | 5247.0 | 342.0 |
| 2015-10-19 01:00:00 | NQ | Futures | 5246.71 | 5247.0 | 5243.44 | 5246.11 | 689.0 |
| 2015-10-19 02:00:00 | NQ | Futures | 5246.41 | 5249.37 | 5240.18 | 5246.71 | 1399.0 |
| 2015-10-19 03:00:00 | NQ | Futures | 5246.41 | 5270.42 | 5246.41 | 5262.72 | 4689.0 |
| 2015-10-19 04:00:00 | NQ | Futures | 5262.42 | 5264.49 | 5256.19 | 5259.45 | 1950.0 |
| 2015-10-19 05:00:00 | NQ | Futures | 5259.75 | 5260.94 | 5254.41 | 5255.9 | 903.0 |
| 2015-10-19 06:00:00 | NQ | Futures | 5256.19 | 5259.75 | 5254.71 | 5255.3 | 1400.0 |
| 2015-10-19 07:00:00 | NQ | Futures | 5255.01 | 5256.49 | 5245.52 | 5247.3 | 2860.0 |
| 2015-10-19 08:00:00 | NQ | Futures | 5247.3 | 5248.19 | 5233.07 | 5233.96 | 7281.0 |
| 2015-10-19 09:00:00 | NQ | Futures | 5234.25 | 5257.97 | 5231.29 | 5257.08 | 27502.0 |
| 2015-10-19 10:00:00 | NQ | Futures | 5257.68 | 5267.16 | 5247.0 | 5267.16 | 36991.0 |
| 2015-10-19 11:00:00 | NQ | Futures | 5266.57 | 5283.47 | 5260.05 | 5281.1 | 27249.0 |
| 2015-10-19 12:00:00 | NQ | Futures | 5281.1 | 5283.17 | 5266.27 | 5272.2 | 15356.0 |
| 2015-10-19 13:00:00 | NQ | Futures | 5272.5 | 5275.46 | 5245.22 | 5257.97 | 19127.0 |
| 2015-10-19 14:00:00 | NQ | Futures | 5258.27 | 5271.31 | 5253.52 | 5270.42 | 16764.0 |
| 2015-10-19 15:00:00 | NQ | Futures | 5270.42 | 5282.28 | 5267.46 | 5280.21 | 22441.0 |
| 2015-10-19 16:00:00 | NQ | Futures | 5280.51 | 5284.06 | 5277.54 | 5281.1 | 5686.0 |
| 2015-10-19 18:00:00 | NQ | Futures | 5279.32 | 5280.51 | 5276.06 | 5277.24 | 633.0 |
| 2015-10-19 19:00:00 | NQ | Futures | 5277.54 | 5280.51 | 5275.76 | 5279.02 | 356.0 |
| 2015-10-19 20:00:00 | NQ | Futures | 5277.54 | 5279.02 | 5273.69 | 5277.54 | 670.0 |
| 2015-10-19 21:00:00 | NQ | Futures | 5277.54 | 5277.54 | 5272.8 | 5276.35 | 785.0 |
| 2015-10-19 22:00:00 | NQ | Futures | 5276.65 | 5277.54 | 5273.09 | 5276.35 | 585.0 |
| 2015-10-19 23:00:00 | NQ | Futures | 5275.76 | 5279.62 | 5275.46 | 5279.32 | 373.0 |
| 2015-10-19 00:00:00 | YM | Futures | 18081.5 | 18089.9 | 18077.2 | 18082.5 | 406.0 |
| 2015-10-19 01:00:00 | YM | Futures | 18083.6 | 18091.0 | 18073.0 | 18088.9 | 638.0 |
| 2015-10-19 02:00:00 | YM | Futures | 18089.9 | 18098.4 | 18071.9 | 18093.1 | 941.0 |
| 2015-10-19 03:00:00 | YM | Futures | 18092.0 | 18151.4 | 18092.0 | 18127.0 | 3241.0 |
> showing 50 of 1,540 rows — these rows as CSV