PREVIEW / futures_1hour / 2015-03-18
file: by_date/futures_1hour/2015/2015-03-18.parquet size: 54 KB rows: 1,587
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-18 00:00:00 | ES | Futures | 2183.46 | 2184.78 | 2183.2 | 2183.99 | 2535.0 |
| 2015-03-18 01:00:00 | ES | Futures | 2183.99 | 2185.31 | 2183.73 | 2185.05 | 1653.0 |
| 2015-03-18 02:00:00 | ES | Futures | 2184.78 | 2185.31 | 2183.73 | 2183.99 | 1493.0 |
| 2015-03-18 03:00:00 | ES | Futures | 2183.99 | 2185.05 | 2183.2 | 2185.05 | 5483.0 |
| 2015-03-18 04:00:00 | ES | Futures | 2185.05 | 2186.9 | 2183.2 | 2185.84 | 20228.0 |
| 2015-03-18 05:00:00 | ES | Futures | 2185.84 | 2185.84 | 2182.93 | 2183.46 | 14495.0 |
| 2015-03-18 06:00:00 | ES | Futures | 2183.73 | 2183.73 | 2175.8 | 2176.33 | 21241.0 |
| 2015-03-18 07:00:00 | ES | Futures | 2176.33 | 2178.18 | 2173.16 | 2174.22 | 27828.0 |
| 2015-03-18 08:00:00 | ES | Futures | 2174.48 | 2176.59 | 2173.16 | 2175.54 | 24079.0 |
| 2015-03-18 09:00:00 | ES | Futures | 2175.54 | 2177.39 | 2171.84 | 2173.69 | 159256.0 |
| 2015-03-18 10:00:00 | ES | Futures | 2173.69 | 2178.44 | 2173.43 | 2177.65 | 138127.0 |
| 2015-03-18 11:00:00 | ES | Futures | 2177.39 | 2178.44 | 2173.43 | 2175.01 | 126659.0 |
| 2015-03-18 12:00:00 | ES | Futures | 2175.01 | 2176.07 | 2171.84 | 2172.63 | 115157.0 |
| 2015-03-18 13:00:00 | ES | Futures | 2172.9 | 2176.07 | 2168.14 | 2175.27 | 117643.0 |
| 2015-03-18 14:00:00 | ES | Futures | 2175.27 | 2208.55 | 2173.43 | 2205.91 | 439880.0 |
| 2015-03-18 15:00:00 | ES | Futures | 2205.65 | 2218.33 | 2204.33 | 2209.35 | 348033.0 |
| 2015-03-18 16:00:00 | ES | Futures | 2209.61 | 2212.25 | 2208.82 | 2211.19 | 91723.0 |
| 2015-03-18 17:00:00 | ES | Futures | 2211.19 | 2211.19 | 2210.14 | 2210.4 | 2382.0 |
| 2015-03-18 18:00:00 | ES | Futures | 2211.72 | 2213.04 | 2210.93 | 2210.93 | 6480.0 |
| 2015-03-18 19:00:00 | ES | Futures | 2210.93 | 2215.16 | 2210.67 | 2213.31 | 4472.0 |
| 2015-03-18 20:00:00 | ES | Futures | 2213.57 | 2217.53 | 2211.72 | 2212.25 | 13250.0 |
| 2015-03-18 21:00:00 | ES | Futures | 2211.99 | 2214.63 | 2210.93 | 2213.57 | 7343.0 |
| 2015-03-18 22:00:00 | ES | Futures | 2213.57 | 2214.36 | 2212.51 | 2214.1 | 4079.0 |
| 2015-03-18 23:00:00 | ES | Futures | 2214.1 | 2215.68 | 2213.57 | 2213.57 | 4558.0 |
| 2015-03-18 00:00:00 | NQ | Futures | 5143.17 | 5146.41 | 5143.17 | 5145.23 | 500.0 |
| 2015-03-18 01:00:00 | NQ | Futures | 5144.64 | 5146.99 | 5144.35 | 5146.99 | 310.0 |
| 2015-03-18 02:00:00 | NQ | Futures | 5146.7 | 5146.99 | 5143.76 | 5143.76 | 220.0 |
| 2015-03-18 03:00:00 | NQ | Futures | 5143.47 | 5146.11 | 5141.11 | 5145.23 | 933.0 |
| 2015-03-18 04:00:00 | NQ | Futures | 5145.52 | 5150.23 | 5141.99 | 5147.29 | 2753.0 |
| 2015-03-18 05:00:00 | NQ | Futures | 5147.58 | 5147.58 | 5140.52 | 5142.29 | 1928.0 |
| 2015-03-18 06:00:00 | NQ | Futures | 5141.99 | 5141.99 | 5124.06 | 5127.59 | 4753.0 |
| 2015-03-18 07:00:00 | NQ | Futures | 5127.59 | 5131.41 | 5120.82 | 5123.17 | 3728.0 |
| 2015-03-18 08:00:00 | NQ | Futures | 5123.47 | 5126.7 | 5120.23 | 5125.53 | 3552.0 |
| 2015-03-18 09:00:00 | NQ | Futures | 5125.23 | 5129.35 | 5113.18 | 5121.12 | 24588.0 |
| 2015-03-18 10:00:00 | NQ | Futures | 5121.12 | 5130.82 | 5119.65 | 5130.23 | 17875.0 |
| 2015-03-18 11:00:00 | NQ | Futures | 5129.94 | 5132.88 | 5118.47 | 5122.88 | 17222.0 |
| 2015-03-18 12:00:00 | NQ | Futures | 5122.59 | 5123.76 | 5114.65 | 5115.24 | 15502.0 |
| 2015-03-18 13:00:00 | NQ | Futures | 5115.24 | 5118.47 | 5099.94 | 5116.71 | 20369.0 |
| 2015-03-18 14:00:00 | NQ | Futures | 5117.0 | 5192.28 | 5116.12 | 5187.57 | 96752.0 |
| 2015-03-18 15:00:00 | NQ | Futures | 5186.99 | 5215.8 | 5183.16 | 5191.69 | 55545.0 |
| 2015-03-18 16:00:00 | NQ | Futures | 5191.99 | 5202.57 | 5190.22 | 5202.28 | 11625.0 |
| 2015-03-18 17:00:00 | NQ | Futures | 5201.98 | 5201.98 | 5200.51 | 5200.51 | 215.0 |
| 2015-03-18 18:00:00 | NQ | Futures | 5203.45 | 5206.69 | 5201.1 | 5201.69 | 763.0 |
| 2015-03-18 19:00:00 | NQ | Futures | 5201.4 | 5210.51 | 5201.1 | 5205.81 | 603.0 |
| 2015-03-18 20:00:00 | NQ | Futures | 5206.69 | 5216.69 | 5205.22 | 5206.1 | 2344.0 |
| 2015-03-18 21:00:00 | NQ | Futures | 5206.1 | 5210.81 | 5202.87 | 5209.63 | 1113.0 |
| 2015-03-18 22:00:00 | NQ | Futures | 5209.04 | 5210.51 | 5207.28 | 5209.63 | 572.0 |
| 2015-03-18 23:00:00 | NQ | Futures | 5209.63 | 5214.04 | 5207.87 | 5208.45 | 971.0 |
| 2015-03-18 00:00:00 | YM | Futures | 18648.4 | 18658.9 | 18646.3 | 18650.5 | 395.0 |
| 2015-03-18 01:00:00 | YM | Futures | 18652.6 | 18663.1 | 18649.5 | 18663.1 | 318.0 |
> showing 50 of 1,587 rows — these rows as CSV