PREVIEW / futures_1hour / 2015-11-16
file: by_date/futures_1hour/2015/2015-11-16.parquet size: 52 KB rows: 1,586
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-16 00:00:00 | ES | Futures | 2151.85 | 2151.85 | 2149.44 | 2149.98 | 2941.0 |
| 2015-11-16 01:00:00 | ES | Futures | 2150.25 | 2152.39 | 2149.44 | 2150.25 | 4677.0 |
| 2015-11-16 02:00:00 | ES | Futures | 2150.25 | 2158.01 | 2149.18 | 2155.6 | 19565.0 |
| 2015-11-16 03:00:00 | ES | Futures | 2155.86 | 2164.43 | 2155.33 | 2161.48 | 44316.0 |
| 2015-11-16 04:00:00 | ES | Futures | 2161.22 | 2167.1 | 2161.22 | 2163.36 | 26201.0 |
| 2015-11-16 05:00:00 | ES | Futures | 2163.36 | 2167.91 | 2162.29 | 2162.55 | 20615.0 |
| 2015-11-16 06:00:00 | ES | Futures | 2162.82 | 2166.84 | 2161.22 | 2166.3 | 16174.0 |
| 2015-11-16 07:00:00 | ES | Futures | 2166.03 | 2168.17 | 2163.89 | 2164.43 | 30170.0 |
| 2015-11-16 08:00:00 | ES | Futures | 2164.43 | 2166.57 | 2157.74 | 2158.27 | 51350.0 |
| 2015-11-16 09:00:00 | ES | Futures | 2158.27 | 2172.99 | 2154.53 | 2166.57 | 315437.0 |
| 2015-11-16 10:00:00 | ES | Futures | 2166.3 | 2172.45 | 2162.55 | 2163.62 | 211991.0 |
| 2015-11-16 11:00:00 | ES | Futures | 2163.36 | 2169.51 | 2161.22 | 2167.64 | 166009.0 |
| 2015-11-16 12:00:00 | ES | Futures | 2167.64 | 2175.93 | 2166.3 | 2173.53 | 133747.0 |
| 2015-11-16 13:00:00 | ES | Futures | 2173.53 | 2181.02 | 2172.45 | 2181.02 | 126641.0 |
| 2015-11-16 14:00:00 | ES | Futures | 2180.75 | 2186.1 | 2179.68 | 2184.5 | 135256.0 |
| 2015-11-16 15:00:00 | ES | Futures | 2184.23 | 2193.59 | 2184.23 | 2193.06 | 231839.0 |
| 2015-11-16 16:00:00 | ES | Futures | 2193.06 | 2195.2 | 2190.92 | 2192.79 | 93542.0 |
| 2015-11-16 18:00:00 | ES | Futures | 2191.72 | 2192.26 | 2189.58 | 2191.19 | 5770.0 |
| 2015-11-16 19:00:00 | ES | Futures | 2190.92 | 2191.72 | 2189.85 | 2190.65 | 4542.0 |
| 2015-11-16 20:00:00 | ES | Futures | 2190.65 | 2194.66 | 2190.11 | 2194.13 | 6748.0 |
| 2015-11-16 21:00:00 | ES | Futures | 2194.13 | 2197.87 | 2193.86 | 2194.66 | 7683.0 |
| 2015-11-16 22:00:00 | ES | Futures | 2194.93 | 2195.2 | 2193.06 | 2194.4 | 3205.0 |
| 2015-11-16 23:00:00 | ES | Futures | 2194.4 | 2195.73 | 2194.13 | 2195.47 | 2205.0 |
| 2015-11-16 00:00:00 | NQ | Futures | 5316.97 | 5316.97 | 5311.34 | 5313.12 | 416.0 |
| 2015-11-16 01:00:00 | NQ | Futures | 5313.42 | 5319.35 | 5312.53 | 5314.01 | 717.0 |
| 2015-11-16 02:00:00 | NQ | Futures | 5313.71 | 5332.09 | 5310.75 | 5327.05 | 2978.0 |
| 2015-11-16 03:00:00 | NQ | Futures | 5326.76 | 5347.22 | 5326.16 | 5343.06 | 5795.0 |
| 2015-11-16 04:00:00 | NQ | Futures | 5342.77 | 5357.59 | 5341.29 | 5346.92 | 3823.0 |
| 2015-11-16 05:00:00 | NQ | Futures | 5346.03 | 5357.0 | 5344.55 | 5345.73 | 2926.0 |
| 2015-11-16 06:00:00 | NQ | Futures | 5345.73 | 5353.15 | 5343.06 | 5350.48 | 2427.0 |
| 2015-11-16 07:00:00 | NQ | Futures | 5350.18 | 5352.55 | 5342.18 | 5342.18 | 3846.0 |
| 2015-11-16 08:00:00 | NQ | Futures | 5342.18 | 5343.95 | 5326.16 | 5327.94 | 8363.0 |
| 2015-11-16 09:00:00 | NQ | Futures | 5327.94 | 5359.96 | 5317.27 | 5342.77 | 56697.0 |
| 2015-11-16 10:00:00 | NQ | Futures | 5342.77 | 5364.41 | 5331.5 | 5333.58 | 44587.0 |
| 2015-11-16 11:00:00 | NQ | Futures | 5333.58 | 5342.77 | 5322.61 | 5338.32 | 30623.0 |
| 2015-11-16 12:00:00 | NQ | Futures | 5338.62 | 5362.04 | 5335.36 | 5357.89 | 23307.0 |
| 2015-11-16 13:00:00 | NQ | Futures | 5358.19 | 5383.09 | 5355.52 | 5382.2 | 23860.0 |
| 2015-11-16 14:00:00 | NQ | Futures | 5382.5 | 5398.51 | 5378.94 | 5395.84 | 22743.0 |
| 2015-11-16 15:00:00 | NQ | Futures | 5395.84 | 5412.15 | 5395.84 | 5410.07 | 29588.0 |
| 2015-11-16 16:00:00 | NQ | Futures | 5410.37 | 5414.52 | 5405.92 | 5410.96 | 7264.0 |
| 2015-11-16 18:00:00 | NQ | Futures | 5408.89 | 5410.37 | 5403.55 | 5407.7 | 760.0 |
| 2015-11-16 19:00:00 | NQ | Futures | 5407.4 | 5410.66 | 5405.03 | 5407.4 | 898.0 |
| 2015-11-16 20:00:00 | NQ | Futures | 5407.7 | 5415.71 | 5405.33 | 5414.52 | 836.0 |
| 2015-11-16 21:00:00 | NQ | Futures | 5414.52 | 5423.12 | 5413.93 | 5415.11 | 1940.0 |
| 2015-11-16 22:00:00 | NQ | Futures | 5415.41 | 5415.71 | 5410.07 | 5412.74 | 773.0 |
| 2015-11-16 23:00:00 | NQ | Futures | 5413.04 | 5414.82 | 5412.44 | 5414.82 | 582.0 |
| 2015-11-16 00:00:00 | YM | Futures | 18160.9 | 18162.0 | 18140.8 | 18147.1 | 714.0 |
| 2015-11-16 01:00:00 | YM | Futures | 18144.0 | 18162.0 | 18141.8 | 18146.1 | 739.0 |
| 2015-11-16 02:00:00 | YM | Futures | 18147.1 | 18201.2 | 18137.6 | 18182.1 | 3123.0 |
| 2015-11-16 03:00:00 | YM | Futures | 18181.0 | 18246.7 | 18181.0 | 18230.8 | 5510.0 |
> showing 50 of 1,586 rows — these rows as CSV