PREVIEW / futures_1hour / 2015-01-30
file: by_date/futures_1hour/2015/2015-01-30.parquet size: 46 KB rows: 1,314
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-01-30 00:00:00 | ES | Futures | 2119.43 | 2120.74 | 2117.85 | 2119.43 | 3973.0 |
| 2015-01-30 01:00:00 | ES | Futures | 2119.16 | 2121.53 | 2119.16 | 2120.48 | 2786.0 |
| 2015-01-30 02:00:00 | ES | Futures | 2120.48 | 2121.0 | 2118.37 | 2118.64 | 6208.0 |
| 2015-01-30 03:00:00 | ES | Futures | 2118.37 | 2119.43 | 2113.11 | 2114.16 | 24874.0 |
| 2015-01-30 04:00:00 | ES | Futures | 2113.9 | 2115.48 | 2107.32 | 2108.37 | 24086.0 |
| 2015-01-30 05:00:00 | ES | Futures | 2108.37 | 2111.0 | 2106.0 | 2108.9 | 17921.0 |
| 2015-01-30 06:00:00 | ES | Futures | 2108.9 | 2113.37 | 2108.37 | 2111.79 | 17561.0 |
| 2015-01-30 07:00:00 | ES | Futures | 2111.79 | 2112.06 | 2107.58 | 2108.37 | 20369.0 |
| 2015-01-30 08:00:00 | ES | Futures | 2108.64 | 2108.9 | 2100.21 | 2102.58 | 81442.0 |
| 2015-01-30 09:00:00 | ES | Futures | 2102.58 | 2118.37 | 2101.27 | 2112.58 | 287997.0 |
| 2015-01-30 10:00:00 | ES | Futures | 2112.58 | 2115.21 | 2100.74 | 2106.53 | 287992.0 |
| 2015-01-30 11:00:00 | ES | Futures | 2106.27 | 2108.9 | 2098.11 | 2106.53 | 249525.0 |
| 2015-01-30 12:00:00 | ES | Futures | 2106.53 | 2115.74 | 2105.48 | 2106.79 | 187038.0 |
| 2015-01-30 13:00:00 | ES | Futures | 2106.79 | 2115.48 | 2103.11 | 2115.21 | 154707.0 |
| 2015-01-30 14:00:00 | ES | Futures | 2115.21 | 2123.37 | 2105.74 | 2107.85 | 265450.0 |
| 2015-01-30 15:00:00 | ES | Futures | 2107.58 | 2110.48 | 2090.74 | 2094.43 | 525432.0 |
| 2015-01-30 16:00:00 | ES | Futures | 2094.16 | 2096.53 | 2091.79 | 2093.9 | 164548.0 |
| 2015-01-30 17:00:00 | ES | Futures | 2093.64 | 2094.69 | 2093.37 | 2094.43 | 1928.0 |
| 2015-01-30 00:00:00 | NQ | Futures | 4922.8 | 4927.21 | 4919.57 | 4923.1 | 680.0 |
| 2015-01-30 01:00:00 | NQ | Futures | 4921.92 | 4927.21 | 4921.04 | 4926.62 | 233.0 |
| 2015-01-30 02:00:00 | NQ | Futures | 4925.74 | 4928.97 | 4922.22 | 4922.8 | 734.0 |
| 2015-01-30 03:00:00 | NQ | Futures | 4922.8 | 4923.1 | 4906.06 | 4908.71 | 3644.0 |
| 2015-01-30 04:00:00 | NQ | Futures | 4909.0 | 4913.11 | 4894.32 | 4899.02 | 3607.0 |
| 2015-01-30 05:00:00 | NQ | Futures | 4899.31 | 4905.18 | 4893.14 | 4901.37 | 2205.0 |
| 2015-01-30 06:00:00 | NQ | Futures | 4900.48 | 4911.94 | 4899.31 | 4906.36 | 3576.0 |
| 2015-01-30 07:00:00 | NQ | Futures | 4906.65 | 4906.65 | 4895.49 | 4897.25 | 3421.0 |
| 2015-01-30 08:00:00 | NQ | Futures | 4897.55 | 4899.31 | 4883.74 | 4891.09 | 11632.0 |
| 2015-01-30 09:00:00 | NQ | Futures | 4890.79 | 4937.78 | 4889.03 | 4911.64 | 52189.0 |
| 2015-01-30 10:00:00 | NQ | Futures | 4910.76 | 4919.57 | 4880.22 | 4899.02 | 51958.0 |
| 2015-01-30 11:00:00 | NQ | Futures | 4898.72 | 4910.18 | 4886.09 | 4909.3 | 31940.0 |
| 2015-01-30 12:00:00 | NQ | Futures | 4909.3 | 4931.32 | 4908.12 | 4911.35 | 32005.0 |
| 2015-01-30 13:00:00 | NQ | Futures | 4911.06 | 4923.39 | 4899.6 | 4920.75 | 22728.0 |
| 2015-01-30 14:00:00 | NQ | Futures | 4920.46 | 4936.61 | 4895.49 | 4902.54 | 32737.0 |
| 2015-01-30 15:00:00 | NQ | Futures | 4902.25 | 4907.24 | 4858.78 | 4866.71 | 73832.0 |
| 2015-01-30 16:00:00 | NQ | Futures | 4866.71 | 4873.17 | 4862.6 | 4864.36 | 13075.0 |
| 2015-01-30 17:00:00 | NQ | Futures | 4865.54 | 4867.0 | 4864.07 | 4867.0 | 101.0 |
| 2015-01-30 00:00:00 | YM | Futures | 18138.4 | 18146.8 | 18129.0 | 18139.5 | 552.0 |
| 2015-01-30 01:00:00 | YM | Futures | 18136.3 | 18154.1 | 18133.2 | 18146.8 | 274.0 |
| 2015-01-30 02:00:00 | YM | Futures | 18147.8 | 18150.9 | 18128.0 | 18131.1 | 711.0 |
| 2015-01-30 03:00:00 | YM | Futures | 18129.0 | 18132.1 | 18077.9 | 18085.2 | 3946.0 |
| 2015-01-30 04:00:00 | YM | Futures | 18086.2 | 18100.8 | 18038.2 | 18049.7 | 4582.0 |
| 2015-01-30 05:00:00 | YM | Futures | 18051.8 | 18074.7 | 18027.8 | 18055.9 | 3190.0 |
| 2015-01-30 06:00:00 | YM | Futures | 18054.9 | 18090.4 | 18049.7 | 18076.8 | 3669.0 |
| 2015-01-30 07:00:00 | YM | Futures | 18077.9 | 18077.9 | 18040.3 | 18046.6 | 2549.0 |
| 2015-01-30 08:00:00 | YM | Futures | 18046.6 | 18050.7 | 17988.1 | 18001.7 | 9899.0 |
| 2015-01-30 09:00:00 | YM | Futures | 18001.7 | 18113.4 | 17994.4 | 18058.0 | 32535.0 |
| 2015-01-30 10:00:00 | YM | Futures | 18060.1 | 18078.9 | 17954.7 | 18002.7 | 29887.0 |
| 2015-01-30 11:00:00 | YM | Futures | 18001.7 | 18023.6 | 17916.1 | 17985.0 | 25135.0 |
| 2015-01-30 12:00:00 | YM | Futures | 17983.9 | 18051.8 | 17968.3 | 17978.7 | 18276.0 |
| 2015-01-30 13:00:00 | YM | Futures | 17977.7 | 18037.2 | 17945.3 | 18037.2 | 17621.0 |
> showing 50 of 1,314 rows — these rows as CSV