PREVIEW / futures_1hour / 2015-10-16
file: by_date/futures_1hour/2015/2015-10-16.parquet size: 42 KB rows: 1,284
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-16 00:00:00 | ES | Futures | 2159.08 | 2160.68 | 2158.81 | 2159.34 | 2214.0 |
| 2015-10-16 01:00:00 | ES | Futures | 2159.34 | 2160.15 | 2158.81 | 2159.88 | 2790.0 |
| 2015-10-16 02:00:00 | ES | Futures | 2159.61 | 2160.41 | 2157.74 | 2159.88 | 7234.0 |
| 2015-10-16 03:00:00 | ES | Futures | 2159.88 | 2163.09 | 2158.01 | 2160.95 | 19025.0 |
| 2015-10-16 04:00:00 | ES | Futures | 2160.68 | 2164.16 | 2159.88 | 2162.02 | 15298.0 |
| 2015-10-16 05:00:00 | ES | Futures | 2161.75 | 2163.36 | 2161.22 | 2162.55 | 10184.0 |
| 2015-10-16 06:00:00 | ES | Futures | 2162.55 | 2162.82 | 2156.67 | 2157.74 | 20298.0 |
| 2015-10-16 07:00:00 | ES | Futures | 2157.47 | 2159.34 | 2155.33 | 2158.81 | 24052.0 |
| 2015-10-16 08:00:00 | ES | Futures | 2158.54 | 2160.15 | 2156.67 | 2159.34 | 27896.0 |
| 2015-10-16 09:00:00 | ES | Futures | 2159.34 | 2166.03 | 2159.34 | 2161.48 | 266730.0 |
| 2015-10-16 10:00:00 | ES | Futures | 2161.75 | 2163.89 | 2156.94 | 2160.15 | 181163.0 |
| 2015-10-16 11:00:00 | ES | Futures | 2160.41 | 2165.23 | 2159.88 | 2164.96 | 140281.0 |
| 2015-10-16 12:00:00 | ES | Futures | 2164.96 | 2165.23 | 2157.47 | 2160.41 | 102439.0 |
| 2015-10-16 13:00:00 | ES | Futures | 2160.41 | 2161.22 | 2155.6 | 2156.13 | 85552.0 |
| 2015-10-16 14:00:00 | ES | Futures | 2156.13 | 2164.43 | 2153.72 | 2162.82 | 134364.0 |
| 2015-10-16 15:00:00 | ES | Futures | 2162.82 | 2168.44 | 2162.29 | 2166.84 | 196400.0 |
| 2015-10-16 16:00:00 | ES | Futures | 2167.1 | 2168.98 | 2166.03 | 2168.71 | 79182.0 |
| 2015-10-16 00:00:00 | NQ | Futures | 5230.1 | 5233.66 | 5228.92 | 5229.81 | 401.0 |
| 2015-10-16 01:00:00 | NQ | Futures | 5229.81 | 5232.18 | 5228.32 | 5230.69 | 338.0 |
| 2015-10-16 02:00:00 | NQ | Futures | 5230.1 | 5233.07 | 5224.17 | 5232.47 | 1530.0 |
| 2015-10-16 03:00:00 | NQ | Futures | 5232.47 | 5241.66 | 5225.36 | 5238.7 | 2993.0 |
| 2015-10-16 04:00:00 | NQ | Futures | 5238.7 | 5249.67 | 5236.92 | 5243.15 | 3645.0 |
| 2015-10-16 05:00:00 | NQ | Futures | 5243.15 | 5247.59 | 5241.37 | 5246.11 | 1751.0 |
| 2015-10-16 06:00:00 | NQ | Futures | 5245.52 | 5246.41 | 5231.58 | 5234.55 | 3262.0 |
| 2015-10-16 07:00:00 | NQ | Futures | 5234.25 | 5235.44 | 5227.73 | 5233.36 | 3327.0 |
| 2015-10-16 08:00:00 | NQ | Futures | 5233.07 | 5235.73 | 5228.62 | 5231.58 | 4098.0 |
| 2015-10-16 09:00:00 | NQ | Futures | 5231.58 | 5241.37 | 5223.88 | 5230.1 | 44652.0 |
| 2015-10-16 10:00:00 | NQ | Futures | 5229.81 | 5241.96 | 5221.8 | 5238.11 | 26739.0 |
| 2015-10-16 11:00:00 | NQ | Futures | 5237.81 | 5245.82 | 5234.25 | 5244.33 | 19666.0 |
| 2015-10-16 12:00:00 | NQ | Futures | 5244.63 | 5244.93 | 5221.8 | 5230.69 | 14527.0 |
| 2015-10-16 13:00:00 | NQ | Futures | 5230.69 | 5233.96 | 5219.13 | 5220.32 | 11140.0 |
| 2015-10-16 14:00:00 | NQ | Futures | 5220.32 | 5239.29 | 5213.5 | 5231.29 | 19430.0 |
| 2015-10-16 15:00:00 | NQ | Futures | 5231.58 | 5253.52 | 5230.99 | 5251.15 | 28959.0 |
| 2015-10-16 16:00:00 | NQ | Futures | 5250.86 | 5264.49 | 5248.78 | 5264.2 | 11627.0 |
| 2015-10-16 00:00:00 | YM | Futures | 18064.5 | 18076.2 | 18062.4 | 18064.5 | 337.0 |
| 2015-10-16 01:00:00 | YM | Futures | 18064.5 | 18070.9 | 18057.1 | 18065.6 | 503.0 |
| 2015-10-16 02:00:00 | YM | Futures | 18065.6 | 18073.0 | 18047.6 | 18068.7 | 1614.0 |
| 2015-10-16 03:00:00 | YM | Futures | 18070.9 | 18091.0 | 18050.7 | 18074.0 | 2663.0 |
| 2015-10-16 04:00:00 | YM | Futures | 18073.0 | 18101.6 | 18064.5 | 18081.5 | 1970.0 |
| 2015-10-16 05:00:00 | YM | Futures | 18083.6 | 18093.1 | 18076.2 | 18086.8 | 1397.0 |
| 2015-10-16 06:00:00 | YM | Futures | 18086.8 | 18086.8 | 18042.3 | 18052.9 | 2000.0 |
| 2015-10-16 07:00:00 | YM | Futures | 18051.8 | 18063.4 | 18034.8 | 18058.2 | 2268.0 |
| 2015-10-16 08:00:00 | YM | Futures | 18057.1 | 18073.0 | 18043.3 | 18063.4 | 2850.0 |
| 2015-10-16 09:00:00 | YM | Futures | 18064.5 | 18131.2 | 18045.4 | 18081.5 | 22954.0 |
| 2015-10-16 10:00:00 | YM | Futures | 18082.5 | 18099.5 | 18056.0 | 18068.7 | 14107.0 |
| 2015-10-16 11:00:00 | YM | Futures | 18066.6 | 18127.0 | 18066.6 | 18125.9 | 10410.0 |
| 2015-10-16 12:00:00 | YM | Futures | 18124.9 | 18127.0 | 18066.6 | 18084.6 | 7435.0 |
| 2015-10-16 13:00:00 | YM | Futures | 18084.6 | 18088.9 | 18030.6 | 18032.7 | 6677.0 |
| 2015-10-16 14:00:00 | YM | Futures | 18033.8 | 18101.6 | 18020.0 | 18087.8 | 11229.0 |
| 2015-10-16 15:00:00 | YM | Futures | 18087.8 | 18140.8 | 18085.7 | 18131.2 | 11469.0 |
> showing 50 of 1,284 rows — these rows as CSV