PREVIEW / futures_1hour / 2015-11-13
file: by_date/futures_1hour/2015/2015-11-13.parquet size: 45 KB rows: 1,315
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-11-13 00:00:00 | ES | Futures | 2185.03 | 2186.64 | 2184.23 | 2185.03 | 3398.0 |
| 2015-11-13 01:00:00 | ES | Futures | 2185.3 | 2187.44 | 2184.76 | 2185.03 | 3305.0 |
| 2015-11-13 02:00:00 | ES | Futures | 2185.03 | 2188.51 | 2184.76 | 2187.71 | 13940.0 |
| 2015-11-13 03:00:00 | ES | Futures | 2187.71 | 2189.85 | 2184.5 | 2188.24 | 28680.0 |
| 2015-11-13 04:00:00 | ES | Futures | 2188.24 | 2188.51 | 2183.43 | 2185.3 | 14562.0 |
| 2015-11-13 05:00:00 | ES | Futures | 2185.3 | 2186.9 | 2183.69 | 2184.23 | 11734.0 |
| 2015-11-13 06:00:00 | ES | Futures | 2184.23 | 2184.76 | 2177.0 | 2179.95 | 35632.0 |
| 2015-11-13 07:00:00 | ES | Futures | 2179.68 | 2181.82 | 2179.41 | 2179.95 | 24409.0 |
| 2015-11-13 08:00:00 | ES | Futures | 2179.95 | 2183.43 | 2176.47 | 2180.75 | 60330.0 |
| 2015-11-13 09:00:00 | ES | Futures | 2180.75 | 2182.89 | 2174.33 | 2176.47 | 226624.0 |
| 2015-11-13 10:00:00 | ES | Futures | 2176.47 | 2178.34 | 2164.96 | 2171.12 | 426174.0 |
| 2015-11-13 11:00:00 | ES | Futures | 2171.38 | 2174.06 | 2163.36 | 2174.06 | 252920.0 |
| 2015-11-13 12:00:00 | ES | Futures | 2173.79 | 2179.95 | 2170.05 | 2172.45 | 197903.0 |
| 2015-11-13 13:00:00 | ES | Futures | 2172.45 | 2173.53 | 2165.77 | 2167.37 | 155590.0 |
| 2015-11-13 14:00:00 | ES | Futures | 2167.37 | 2169.51 | 2159.34 | 2160.95 | 192491.0 |
| 2015-11-13 15:00:00 | ES | Futures | 2161.22 | 2165.23 | 2158.54 | 2159.88 | 332359.0 |
| 2015-11-13 16:00:00 | ES | Futures | 2159.88 | 2162.02 | 2152.92 | 2154.53 | 109134.0 |
| 2015-11-13 00:00:00 | NQ | Futures | 5432.9 | 5437.94 | 5431.42 | 5434.38 | 643.0 |
| 2015-11-13 01:00:00 | NQ | Futures | 5434.68 | 5440.02 | 5432.9 | 5434.09 | 484.0 |
| 2015-11-13 02:00:00 | NQ | Futures | 5434.38 | 5441.8 | 5432.61 | 5438.83 | 1755.0 |
| 2015-11-13 03:00:00 | NQ | Futures | 5438.83 | 5443.87 | 5431.42 | 5440.31 | 3384.0 |
| 2015-11-13 04:00:00 | NQ | Futures | 5440.31 | 5440.61 | 5427.27 | 5431.12 | 2122.0 |
| 2015-11-13 05:00:00 | NQ | Futures | 5431.12 | 5435.87 | 5427.86 | 5430.53 | 1995.0 |
| 2015-11-13 06:00:00 | NQ | Futures | 5430.83 | 5431.42 | 5413.63 | 5420.45 | 4572.0 |
| 2015-11-13 07:00:00 | NQ | Futures | 5420.15 | 5423.41 | 5418.37 | 5418.97 | 2660.0 |
| 2015-11-13 08:00:00 | NQ | Futures | 5418.97 | 5429.05 | 5412.74 | 5423.71 | 8299.0 |
| 2015-11-13 09:00:00 | NQ | Futures | 5423.71 | 5428.45 | 5399.4 | 5407.4 | 41570.0 |
| 2015-11-13 10:00:00 | NQ | Futures | 5407.4 | 5410.66 | 5370.05 | 5384.57 | 75747.0 |
| 2015-11-13 11:00:00 | NQ | Futures | 5384.87 | 5385.46 | 5361.15 | 5383.68 | 41947.0 |
| 2015-11-13 12:00:00 | NQ | Futures | 5383.39 | 5399.69 | 5373.01 | 5379.53 | 29184.0 |
| 2015-11-13 13:00:00 | NQ | Futures | 5379.83 | 5383.09 | 5361.15 | 5368.56 | 26634.0 |
| 2015-11-13 14:00:00 | NQ | Futures | 5368.56 | 5370.93 | 5342.47 | 5348.99 | 34694.0 |
| 2015-11-13 15:00:00 | NQ | Futures | 5348.99 | 5359.37 | 5331.8 | 5335.36 | 47648.0 |
| 2015-11-13 16:00:00 | NQ | Futures | 5335.65 | 5340.69 | 5319.94 | 5323.79 | 9865.0 |
| 2015-11-13 00:00:00 | YM | Futures | 18438.4 | 18449.0 | 18428.9 | 18436.3 | 703.0 |
| 2015-11-13 01:00:00 | YM | Futures | 18440.5 | 18455.4 | 18436.3 | 18438.4 | 361.0 |
| 2015-11-13 02:00:00 | YM | Futures | 18439.5 | 18467.0 | 18438.4 | 18460.7 | 1312.0 |
| 2015-11-13 03:00:00 | YM | Futures | 18460.7 | 18478.7 | 18433.1 | 18463.8 | 3445.0 |
| 2015-11-13 04:00:00 | YM | Futures | 18462.8 | 18463.8 | 18421.5 | 18439.5 | 1841.0 |
| 2015-11-13 05:00:00 | YM | Futures | 18439.5 | 18453.3 | 18422.5 | 18428.9 | 1528.0 |
| 2015-11-13 06:00:00 | YM | Futures | 18428.9 | 18428.9 | 18365.3 | 18387.6 | 4292.0 |
| 2015-11-13 07:00:00 | YM | Futures | 18387.6 | 18401.4 | 18382.3 | 18383.3 | 2620.0 |
| 2015-11-13 08:00:00 | YM | Futures | 18383.3 | 18416.2 | 18360.0 | 18391.8 | 6834.0 |
| 2015-11-13 09:00:00 | YM | Futures | 18391.8 | 18421.5 | 18332.5 | 18338.9 | 21845.0 |
| 2015-11-13 10:00:00 | YM | Futures | 18343.1 | 18357.9 | 18254.1 | 18298.6 | 32174.0 |
| 2015-11-13 11:00:00 | YM | Futures | 18298.6 | 18321.9 | 18238.2 | 18321.9 | 18410.0 |
| 2015-11-13 12:00:00 | YM | Futures | 18321.9 | 18379.1 | 18299.7 | 18313.4 | 16589.0 |
| 2015-11-13 13:00:00 | YM | Futures | 18314.5 | 18319.8 | 18253.1 | 18267.9 | 13292.0 |
| 2015-11-13 14:00:00 | YM | Futures | 18267.9 | 18281.7 | 18212.8 | 18229.8 | 17002.0 |
| 2015-11-13 15:00:00 | YM | Futures | 18229.8 | 18255.2 | 18206.4 | 18214.9 | 24734.0 |
> showing 50 of 1,315 rows — these rows as CSV