PREVIEW / futures_1hour / 2015-03-10
file: by_date/futures_1hour/2015/2015-03-10.parquet size: 48 KB rows: 1,462
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-03-10 00:00:00 | ES | Futures | 2185.21 | 2185.48 | 2181.79 | 2182.06 | 6649.0 |
| 2015-03-10 01:00:00 | ES | Futures | 2182.06 | 2182.84 | 2181.53 | 2181.53 | 2677.0 |
| 2015-03-10 02:00:00 | ES | Futures | 2181.53 | 2183.11 | 2181.53 | 2182.58 | 2058.0 |
| 2015-03-10 03:00:00 | ES | Futures | 2182.58 | 2183.11 | 2181.79 | 2182.58 | 4666.0 |
| 2015-03-10 04:00:00 | ES | Futures | 2182.84 | 2184.16 | 2177.32 | 2177.58 | 26928.0 |
| 2015-03-10 05:00:00 | ES | Futures | 2177.58 | 2178.37 | 2174.95 | 2175.48 | 16340.0 |
| 2015-03-10 06:00:00 | ES | Futures | 2175.48 | 2175.74 | 2170.48 | 2173.37 | 27182.0 |
| 2015-03-10 07:00:00 | ES | Futures | 2173.37 | 2174.16 | 2167.06 | 2168.37 | 41969.0 |
| 2015-03-10 08:00:00 | ES | Futures | 2168.37 | 2170.48 | 2163.63 | 2168.63 | 76061.0 |
| 2015-03-10 09:00:00 | ES | Futures | 2168.37 | 2171.53 | 2162.58 | 2165.74 | 248366.0 |
| 2015-03-10 10:00:00 | ES | Futures | 2165.74 | 2167.84 | 2159.16 | 2163.37 | 293598.0 |
| 2015-03-10 11:00:00 | ES | Futures | 2163.37 | 2169.42 | 2157.85 | 2157.85 | 191786.0 |
| 2015-03-10 12:00:00 | ES | Futures | 2158.11 | 2160.48 | 2155.21 | 2157.58 | 225645.0 |
| 2015-03-10 13:00:00 | ES | Futures | 2157.85 | 2162.32 | 2156.79 | 2159.16 | 116986.0 |
| 2015-03-10 14:00:00 | ES | Futures | 2159.16 | 2161.53 | 2154.16 | 2154.42 | 127525.0 |
| 2015-03-10 15:00:00 | ES | Futures | 2154.42 | 2159.69 | 2151.53 | 2151.79 | 255388.0 |
| 2015-03-10 16:00:00 | ES | Futures | 2151.79 | 2152.32 | 2148.63 | 2151.27 | 130425.0 |
| 2015-03-10 17:00:00 | ES | Futures | 2151.53 | 2151.79 | 2151.0 | 2151.53 | 3250.0 |
| 2015-03-10 18:00:00 | ES | Futures | 2151.79 | 2152.32 | 2150.21 | 2151.79 | 4981.0 |
| 2015-03-10 19:00:00 | ES | Futures | 2151.79 | 2154.42 | 2150.74 | 2154.16 | 5621.0 |
| 2015-03-10 20:00:00 | ES | Futures | 2154.16 | 2154.69 | 2152.58 | 2154.69 | 5607.0 |
| 2015-03-10 21:00:00 | ES | Futures | 2154.69 | 2156.53 | 2154.42 | 2155.48 | 7883.0 |
| 2015-03-10 22:00:00 | ES | Futures | 2155.74 | 2156.79 | 2155.21 | 2156.79 | 4144.0 |
| 2015-03-10 23:00:00 | ES | Futures | 2156.79 | 2157.06 | 2155.21 | 2156.27 | 3481.0 |
| 2015-03-10 00:00:00 | NQ | Futures | 5181.84 | 5182.43 | 5175.08 | 5175.08 | 1056.0 |
| 2015-03-10 01:00:00 | NQ | Futures | 5175.08 | 5178.31 | 5175.08 | 5175.08 | 335.0 |
| 2015-03-10 02:00:00 | NQ | Futures | 5175.38 | 5177.43 | 5175.08 | 5175.67 | 273.0 |
| 2015-03-10 03:00:00 | NQ | Futures | 5176.26 | 5177.73 | 5174.2 | 5176.55 | 806.0 |
| 2015-03-10 04:00:00 | NQ | Futures | 5176.55 | 5180.37 | 5165.98 | 5166.27 | 3748.0 |
| 2015-03-10 05:00:00 | NQ | Futures | 5166.27 | 5169.5 | 5161.87 | 5163.92 | 2805.0 |
| 2015-03-10 06:00:00 | NQ | Futures | 5163.63 | 5163.92 | 5146.89 | 5154.82 | 6314.0 |
| 2015-03-10 07:00:00 | NQ | Futures | 5154.82 | 5155.11 | 5142.48 | 5146.3 | 5973.0 |
| 2015-03-10 08:00:00 | NQ | Futures | 5146.3 | 5150.71 | 5135.44 | 5147.18 | 9231.0 |
| 2015-03-10 09:00:00 | NQ | Futures | 5146.89 | 5152.47 | 5120.46 | 5126.62 | 48302.0 |
| 2015-03-10 10:00:00 | NQ | Futures | 5126.62 | 5133.38 | 5099.9 | 5110.18 | 52352.0 |
| 2015-03-10 11:00:00 | NQ | Futures | 5110.18 | 5128.97 | 5100.78 | 5100.78 | 34552.0 |
| 2015-03-10 12:00:00 | NQ | Futures | 5101.07 | 5109.0 | 5094.32 | 5102.84 | 35297.0 |
| 2015-03-10 13:00:00 | NQ | Futures | 5103.13 | 5115.76 | 5100.49 | 5109.88 | 22965.0 |
| 2015-03-10 14:00:00 | NQ | Futures | 5110.18 | 5116.93 | 5095.2 | 5097.26 | 24585.0 |
| 2015-03-10 15:00:00 | NQ | Futures | 5097.26 | 5109.59 | 5088.15 | 5089.62 | 46978.0 |
| 2015-03-10 16:00:00 | NQ | Futures | 5089.33 | 5091.68 | 5084.92 | 5091.68 | 11243.0 |
| 2015-03-10 17:00:00 | NQ | Futures | 5091.97 | 5093.44 | 5090.79 | 5091.38 | 454.0 |
| 2015-03-10 18:00:00 | NQ | Futures | 5091.68 | 5093.44 | 5089.91 | 5092.26 | 466.0 |
| 2015-03-10 19:00:00 | NQ | Futures | 5092.26 | 5099.02 | 5091.38 | 5097.84 | 694.0 |
| 2015-03-10 20:00:00 | NQ | Futures | 5098.14 | 5099.02 | 5094.03 | 5098.43 | 789.0 |
| 2015-03-10 21:00:00 | NQ | Futures | 5098.43 | 5101.95 | 5098.14 | 5099.61 | 1041.0 |
| 2015-03-10 22:00:00 | NQ | Futures | 5099.61 | 5101.95 | 5099.31 | 5101.37 | 588.0 |
| 2015-03-10 23:00:00 | NQ | Futures | 5101.37 | 5102.25 | 5097.84 | 5101.07 | 594.0 |
| 2015-03-10 00:00:00 | YM | Futures | 18742.8 | 18742.8 | 18721.8 | 18731.3 | 32.0 |
| 2015-03-10 01:00:00 | YM | Futures | 18726.0 | 18727.1 | 18722.9 | 18722.9 | 3.0 |
> showing 50 of 1,462 rows — these rows as CSV