PREVIEW / futures_1hour / 2015-02-13
file: by_date/futures_1hour/2015/2015-02-13.parquet size: 44 KB rows: 1,280
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-02-13 00:00:00 | ES | Futures | 2193.9 | 2194.69 | 2193.63 | 2194.16 | 2371.0 |
| 2015-02-13 01:00:00 | ES | Futures | 2194.42 | 2196.27 | 2194.16 | 2194.69 | 4148.0 |
| 2015-02-13 02:00:00 | ES | Futures | 2194.69 | 2195.48 | 2192.84 | 2194.69 | 5257.0 |
| 2015-02-13 03:00:00 | ES | Futures | 2194.95 | 2198.11 | 2193.63 | 2196.53 | 16946.0 |
| 2015-02-13 04:00:00 | ES | Futures | 2196.27 | 2199.69 | 2196.27 | 2198.11 | 11966.0 |
| 2015-02-13 05:00:00 | ES | Futures | 2197.84 | 2198.63 | 2197.05 | 2197.84 | 5760.0 |
| 2015-02-13 06:00:00 | ES | Futures | 2197.84 | 2198.37 | 2196.27 | 2197.05 | 4685.0 |
| 2015-02-13 07:00:00 | ES | Futures | 2197.05 | 2198.11 | 2195.74 | 2197.05 | 8624.0 |
| 2015-02-13 08:00:00 | ES | Futures | 2196.79 | 2198.9 | 2196.53 | 2198.11 | 18420.0 |
| 2015-02-13 09:00:00 | ES | Futures | 2198.11 | 2199.95 | 2193.9 | 2199.16 | 183937.0 |
| 2015-02-13 10:00:00 | ES | Futures | 2199.69 | 2200.74 | 2195.74 | 2198.9 | 233467.0 |
| 2015-02-13 11:00:00 | ES | Futures | 2199.16 | 2202.05 | 2198.37 | 2200.74 | 148866.0 |
| 2015-02-13 12:00:00 | ES | Futures | 2201.0 | 2201.27 | 2197.32 | 2197.58 | 75165.0 |
| 2015-02-13 13:00:00 | ES | Futures | 2197.84 | 2199.42 | 2192.32 | 2195.21 | 121664.0 |
| 2015-02-13 14:00:00 | ES | Futures | 2195.21 | 2198.9 | 2194.42 | 2198.63 | 90015.0 |
| 2015-02-13 15:00:00 | ES | Futures | 2198.63 | 2203.9 | 2197.58 | 2203.37 | 185848.0 |
| 2015-02-13 16:00:00 | ES | Futures | 2203.37 | 2204.95 | 2202.58 | 2204.42 | 74455.0 |
| 2015-02-13 17:00:00 | ES | Futures | 2204.69 | 2205.21 | 2204.42 | 2204.95 | 2217.0 |
| 2015-02-13 00:00:00 | NQ | Futures | 5106.07 | 5108.42 | 5106.07 | 5108.12 | 314.0 |
| 2015-02-13 01:00:00 | NQ | Futures | 5107.83 | 5112.53 | 5106.95 | 5109.0 | 729.0 |
| 2015-02-13 02:00:00 | NQ | Futures | 5108.42 | 5110.77 | 5104.89 | 5109.3 | 636.0 |
| 2015-02-13 03:00:00 | NQ | Futures | 5109.3 | 5119.28 | 5106.95 | 5118.7 | 4224.0 |
| 2015-02-13 04:00:00 | NQ | Futures | 5118.7 | 5124.28 | 5116.64 | 5120.16 | 3286.0 |
| 2015-02-13 05:00:00 | NQ | Futures | 5120.46 | 5121.04 | 5117.52 | 5119.28 | 863.0 |
| 2015-02-13 06:00:00 | NQ | Futures | 5119.58 | 5120.46 | 5116.64 | 5117.52 | 907.0 |
| 2015-02-13 07:00:00 | NQ | Futures | 5117.23 | 5118.7 | 5114.29 | 5115.46 | 2169.0 |
| 2015-02-13 08:00:00 | NQ | Futures | 5115.17 | 5120.75 | 5114.0 | 5119.28 | 4043.0 |
| 2015-02-13 09:00:00 | NQ | Futures | 5119.58 | 5126.62 | 5111.94 | 5120.16 | 34721.0 |
| 2015-02-13 10:00:00 | NQ | Futures | 5120.16 | 5123.39 | 5107.83 | 5116.64 | 38681.0 |
| 2015-02-13 11:00:00 | NQ | Futures | 5116.93 | 5131.03 | 5116.93 | 5129.56 | 19791.0 |
| 2015-02-13 12:00:00 | NQ | Futures | 5129.86 | 5131.03 | 5123.69 | 5126.62 | 10259.0 |
| 2015-02-13 13:00:00 | NQ | Futures | 5126.33 | 5132.5 | 5113.12 | 5121.04 | 17687.0 |
| 2015-02-13 14:00:00 | NQ | Futures | 5121.34 | 5128.68 | 5117.81 | 5128.09 | 12670.0 |
| 2015-02-13 15:00:00 | NQ | Futures | 5127.8 | 5147.77 | 5126.33 | 5146.6 | 30016.0 |
| 2015-02-13 16:00:00 | NQ | Futures | 5146.3 | 5146.6 | 5141.02 | 5144.54 | 6532.0 |
| 2015-02-13 17:00:00 | NQ | Futures | 5144.83 | 5145.42 | 5143.95 | 5145.42 | 144.0 |
| 2015-02-13 00:00:00 | YM | Futures | 18725.1 | 18733.4 | 18724.0 | 18729.2 | 360.0 |
| 2015-02-13 01:00:00 | YM | Futures | 18729.2 | 18749.1 | 18727.2 | 18734.5 | 976.0 |
| 2015-02-13 02:00:00 | YM | Futures | 18730.3 | 18741.8 | 18718.8 | 18737.6 | 768.0 |
| 2015-02-13 03:00:00 | YM | Futures | 18738.6 | 18766.8 | 18728.2 | 18753.3 | 2668.0 |
| 2015-02-13 04:00:00 | YM | Futures | 18753.3 | 18774.1 | 18752.2 | 18760.6 | 2015.0 |
| 2015-02-13 05:00:00 | YM | Futures | 18761.6 | 18766.8 | 18754.3 | 18761.6 | 864.0 |
| 2015-02-13 06:00:00 | YM | Futures | 18761.6 | 18763.7 | 18752.2 | 18756.4 | 640.0 |
| 2015-02-13 07:00:00 | YM | Futures | 18756.4 | 18761.6 | 18744.9 | 18753.3 | 1354.0 |
| 2015-02-13 08:00:00 | YM | Futures | 18753.3 | 18768.9 | 18751.2 | 18766.8 | 2536.0 |
| 2015-02-13 09:00:00 | YM | Futures | 18765.8 | 18779.4 | 18730.3 | 18773.1 | 15651.0 |
| 2015-02-13 10:00:00 | YM | Futures | 18771.0 | 18799.2 | 18739.7 | 18776.2 | 18992.0 |
| 2015-02-13 11:00:00 | YM | Futures | 18777.3 | 18796.1 | 18760.6 | 18776.2 | 8964.0 |
| 2015-02-13 12:00:00 | YM | Futures | 18776.2 | 18782.5 | 18754.3 | 18758.5 | 5808.0 |
| 2015-02-13 13:00:00 | YM | Futures | 18757.4 | 18767.9 | 18716.7 | 18737.6 | 10625.0 |
> showing 50 of 1,280 rows — these rows as CSV