PREVIEW / futures_1hour / 2015-03-12
file: by_date/futures_1hour/2015/2015-03-12.parquet size: 50 KB rows: 1,501
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-12 00:00:00 | ES | Futures | 2151.79 | 2152.58 | 2151.0 | 2151.79 | 2953.0 |
| 2015-03-12 01:00:00 | ES | Futures | 2151.53 | 2153.11 | 2151.27 | 2151.79 | 2874.0 |
| 2015-03-12 02:00:00 | ES | Futures | 2151.53 | 2154.16 | 2151.0 | 2154.16 | 4044.0 |
| 2015-03-12 03:00:00 | ES | Futures | 2153.9 | 2154.95 | 2152.85 | 2153.63 | 12171.0 |
| 2015-03-12 04:00:00 | ES | Futures | 2153.9 | 2155.48 | 2152.58 | 2154.95 | 17884.0 |
| 2015-03-12 05:00:00 | ES | Futures | 2155.21 | 2155.74 | 2150.21 | 2152.06 | 18419.0 |
| 2015-03-12 06:00:00 | ES | Futures | 2152.06 | 2154.42 | 2150.21 | 2153.11 | 12261.0 |
| 2015-03-12 07:00:00 | ES | Futures | 2153.11 | 2153.9 | 2150.21 | 2153.9 | 14201.0 |
| 2015-03-12 08:00:00 | ES | Futures | 2153.63 | 2158.63 | 2150.74 | 2158.63 | 61679.0 |
| 2015-03-12 09:00:00 | ES | Futures | 2158.63 | 2167.06 | 2153.9 | 2164.69 | 218454.0 |
| 2015-03-12 10:00:00 | ES | Futures | 2164.42 | 2166.53 | 2161.79 | 2165.48 | 175856.0 |
| 2015-03-12 11:00:00 | ES | Futures | 2165.21 | 2169.95 | 2163.9 | 2167.58 | 129094.0 |
| 2015-03-12 12:00:00 | ES | Futures | 2167.32 | 2168.11 | 2164.95 | 2167.06 | 73871.0 |
| 2015-03-12 13:00:00 | ES | Futures | 2167.32 | 2169.95 | 2166.27 | 2168.9 | 73425.0 |
| 2015-03-12 14:00:00 | ES | Futures | 2168.63 | 2172.06 | 2167.06 | 2171.53 | 76228.0 |
| 2015-03-12 15:00:00 | ES | Futures | 2171.79 | 2175.21 | 2171.53 | 2174.16 | 149541.0 |
| 2015-03-12 16:00:00 | ES | Futures | 2174.16 | 2174.42 | 2172.06 | 2174.16 | 78417.0 |
| 2015-03-12 17:00:00 | ES | Futures | 2173.63 | 2174.16 | 2172.58 | 2172.84 | 2118.0 |
| 2015-03-12 18:00:00 | ES | Futures | 2172.84 | 2174.16 | 2172.58 | 2174.16 | 2261.0 |
| 2015-03-12 19:00:00 | ES | Futures | 2174.16 | 2175.21 | 2173.63 | 2174.95 | 3284.0 |
| 2015-03-12 20:00:00 | ES | Futures | 2174.95 | 2175.21 | 2171.27 | 2172.84 | 4346.0 |
| 2015-03-12 21:00:00 | ES | Futures | 2173.11 | 2177.32 | 2172.84 | 2176.53 | 5411.0 |
| 2015-03-12 22:00:00 | ES | Futures | 2176.53 | 2177.58 | 2174.42 | 2174.42 | 3431.0 |
| 2015-03-12 23:00:00 | ES | Futures | 2174.42 | 2175.74 | 2174.16 | 2175.48 | 1587.0 |
| 2015-03-12 00:00:00 | NQ | Futures | 5071.7 | 5074.64 | 5071.12 | 5072.88 | 686.0 |
| 2015-03-12 01:00:00 | NQ | Futures | 5072.59 | 5075.23 | 5071.41 | 5071.7 | 466.0 |
| 2015-03-12 02:00:00 | NQ | Futures | 5071.41 | 5075.82 | 5070.82 | 5075.52 | 640.0 |
| 2015-03-12 03:00:00 | NQ | Futures | 5075.52 | 5076.99 | 5073.47 | 5075.23 | 1725.0 |
| 2015-03-12 04:00:00 | NQ | Futures | 5075.52 | 5078.75 | 5073.76 | 5077.29 | 2720.0 |
| 2015-03-12 05:00:00 | NQ | Futures | 5077.29 | 5078.75 | 5068.47 | 5072.59 | 2939.0 |
| 2015-03-12 06:00:00 | NQ | Futures | 5072.59 | 5077.58 | 5068.47 | 5075.52 | 2121.0 |
| 2015-03-12 07:00:00 | NQ | Futures | 5075.52 | 5077.87 | 5069.94 | 5077.29 | 3117.0 |
| 2015-03-12 08:00:00 | NQ | Futures | 5077.29 | 5079.05 | 5068.18 | 5078.75 | 10125.0 |
| 2015-03-12 09:00:00 | NQ | Futures | 5078.46 | 5087.56 | 5049.97 | 5079.05 | 54918.0 |
| 2015-03-12 10:00:00 | NQ | Futures | 5079.05 | 5085.21 | 5070.53 | 5078.17 | 30434.0 |
| 2015-03-12 11:00:00 | NQ | Futures | 5078.17 | 5091.97 | 5074.64 | 5081.4 | 21003.0 |
| 2015-03-12 12:00:00 | NQ | Futures | 5081.69 | 5084.63 | 5076.99 | 5081.98 | 11614.0 |
| 2015-03-12 13:00:00 | NQ | Futures | 5081.69 | 5090.5 | 5079.34 | 5088.15 | 10779.0 |
| 2015-03-12 14:00:00 | NQ | Futures | 5088.45 | 5089.03 | 5077.29 | 5087.86 | 12002.0 |
| 2015-03-12 15:00:00 | NQ | Futures | 5088.15 | 5097.84 | 5087.56 | 5092.26 | 24107.0 |
| 2015-03-12 16:00:00 | NQ | Futures | 5092.26 | 5094.91 | 5086.98 | 5090.79 | 5331.0 |
| 2015-03-12 17:00:00 | NQ | Futures | 5091.09 | 5091.09 | 5087.86 | 5087.86 | 101.0 |
| 2015-03-12 18:00:00 | NQ | Futures | 5088.74 | 5094.32 | 5087.56 | 5091.97 | 324.0 |
| 2015-03-12 19:00:00 | NQ | Futures | 5092.26 | 5093.14 | 5091.38 | 5092.85 | 161.0 |
| 2015-03-12 20:00:00 | NQ | Futures | 5092.26 | 5092.26 | 5085.51 | 5089.33 | 272.0 |
| 2015-03-12 21:00:00 | NQ | Futures | 5089.03 | 5097.26 | 5089.03 | 5096.37 | 524.0 |
| 2015-03-12 22:00:00 | NQ | Futures | 5096.37 | 5097.84 | 5091.68 | 5092.26 | 249.0 |
| 2015-03-12 23:00:00 | NQ | Futures | 5091.97 | 5094.32 | 5090.5 | 5093.44 | 225.0 |
| 2015-03-12 00:00:00 | YM | Futures | 18464.9 | 18472.3 | 18461.8 | 18464.9 | 82.0 |
| 2015-03-12 01:00:00 | YM | Futures | 18467.0 | 18475.4 | 18463.9 | 18467.0 | 138.0 |
> showing 50 of 1,501 rows — these rows as CSV