PREVIEW / futures_1hour / 2015-12-10
file: by_date/futures_1hour/2015/2015-12-10.parquet size: 48 KB rows: 1,494
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-12-10 00:00:00 | ES | Futures | 2194.4 | 2194.4 | 2192.52 | 2193.06 | 2390.0 |
| 2015-12-10 01:00:00 | ES | Futures | 2192.79 | 2193.59 | 2191.19 | 2191.19 | 2800.0 |
| 2015-12-10 02:00:00 | ES | Futures | 2191.45 | 2196.0 | 2190.65 | 2194.93 | 8393.0 |
| 2015-12-10 03:00:00 | ES | Futures | 2194.66 | 2199.48 | 2189.85 | 2193.33 | 33018.0 |
| 2015-12-10 04:00:00 | ES | Futures | 2193.06 | 2198.41 | 2191.19 | 2194.4 | 20213.0 |
| 2015-12-10 05:00:00 | ES | Futures | 2194.4 | 2198.41 | 2193.33 | 2195.73 | 16484.0 |
| 2015-12-10 06:00:00 | ES | Futures | 2196.0 | 2197.87 | 2190.11 | 2192.52 | 20034.0 |
| 2015-12-10 07:00:00 | ES | Futures | 2192.26 | 2193.86 | 2187.71 | 2192.52 | 26659.0 |
| 2015-12-10 08:00:00 | ES | Futures | 2192.52 | 2194.66 | 2188.24 | 2188.51 | 44012.0 |
| 2015-12-10 09:00:00 | ES | Futures | 2188.51 | 2198.94 | 2188.24 | 2191.19 | 236196.0 |
| 2015-12-10 10:00:00 | ES | Futures | 2190.92 | 2207.51 | 2187.44 | 2202.16 | 273411.0 |
| 2015-12-10 11:00:00 | ES | Futures | 2202.16 | 2204.83 | 2195.73 | 2197.87 | 147506.0 |
| 2015-12-10 12:00:00 | ES | Futures | 2197.87 | 2202.96 | 2192.26 | 2201.89 | 126639.0 |
| 2015-12-10 13:00:00 | ES | Futures | 2201.89 | 2204.56 | 2198.14 | 2202.16 | 86045.0 |
| 2015-12-10 14:00:00 | ES | Futures | 2202.42 | 2212.32 | 2201.62 | 2206.97 | 118733.0 |
| 2015-12-10 15:00:00 | ES | Futures | 2206.97 | 2208.04 | 2192.79 | 2195.2 | 191122.0 |
| 2015-12-10 16:00:00 | ES | Futures | 2195.2 | 2196.0 | 2191.99 | 2194.66 | 60913.0 |
| 2015-12-10 18:00:00 | ES | Futures | 2194.93 | 2196.27 | 2194.4 | 2194.93 | 1874.0 |
| 2015-12-10 19:00:00 | ES | Futures | 2194.93 | 2199.75 | 2194.93 | 2198.41 | 3346.0 |
| 2015-12-10 20:00:00 | ES | Futures | 2198.68 | 2200.82 | 2198.41 | 2199.21 | 3634.0 |
| 2015-12-10 21:00:00 | ES | Futures | 2199.21 | 2199.21 | 2197.07 | 2197.34 | 2447.0 |
| 2015-12-10 22:00:00 | ES | Futures | 2197.07 | 2199.21 | 2195.2 | 2198.14 | 2388.0 |
| 2015-12-10 23:00:00 | ES | Futures | 2198.14 | 2198.41 | 2195.73 | 2196.54 | 1169.0 |
| 2015-12-10 00:00:00 | NQ | Futures | 5496.65 | 5496.94 | 5491.31 | 5492.79 | 460.0 |
| 2015-12-10 01:00:00 | NQ | Futures | 5492.5 | 5494.28 | 5488.94 | 5488.94 | 254.0 |
| 2015-12-10 02:00:00 | NQ | Futures | 5488.64 | 5499.61 | 5487.46 | 5496.94 | 1180.0 |
| 2015-12-10 03:00:00 | NQ | Futures | 5496.94 | 5510.29 | 5483.6 | 5493.68 | 4922.0 |
| 2015-12-10 04:00:00 | NQ | Futures | 5493.68 | 5504.95 | 5488.94 | 5495.46 | 2742.0 |
| 2015-12-10 05:00:00 | NQ | Futures | 5494.87 | 5506.43 | 5493.39 | 5500.8 | 2406.0 |
| 2015-12-10 06:00:00 | NQ | Futures | 5500.8 | 5504.06 | 5484.79 | 5491.31 | 3090.0 |
| 2015-12-10 07:00:00 | NQ | Futures | 5491.31 | 5493.68 | 5479.15 | 5490.12 | 4951.0 |
| 2015-12-10 08:00:00 | NQ | Futures | 5489.53 | 5495.16 | 5483.9 | 5487.46 | 6827.0 |
| 2015-12-10 09:00:00 | NQ | Futures | 5487.16 | 5511.18 | 5478.26 | 5488.64 | 43453.0 |
| 2015-12-10 10:00:00 | NQ | Futures | 5488.35 | 5526.3 | 5477.08 | 5511.47 | 47772.0 |
| 2015-12-10 11:00:00 | NQ | Futures | 5511.47 | 5520.37 | 5501.09 | 5506.43 | 23175.0 |
| 2015-12-10 12:00:00 | NQ | Futures | 5506.43 | 5517.7 | 5492.79 | 5515.33 | 20642.0 |
| 2015-12-10 13:00:00 | NQ | Futures | 5515.33 | 5522.44 | 5509.99 | 5515.03 | 15471.0 |
| 2015-12-10 14:00:00 | NQ | Futures | 5515.03 | 5543.79 | 5513.84 | 5531.34 | 21204.0 |
| 2015-12-10 15:00:00 | NQ | Futures | 5531.34 | 5532.82 | 5495.46 | 5506.13 | 26364.0 |
| 2015-12-10 16:00:00 | NQ | Futures | 5506.13 | 5512.66 | 5503.17 | 5509.99 | 7221.0 |
| 2015-12-10 18:00:00 | NQ | Futures | 5510.29 | 5513.55 | 5509.69 | 5511.18 | 241.0 |
| 2015-12-10 19:00:00 | NQ | Futures | 5511.18 | 5522.44 | 5510.58 | 5519.77 | 542.0 |
| 2015-12-10 20:00:00 | NQ | Futures | 5520.37 | 5525.41 | 5520.37 | 5521.55 | 406.0 |
| 2015-12-10 21:00:00 | NQ | Futures | 5521.55 | 5521.55 | 5516.22 | 5516.22 | 243.0 |
| 2015-12-10 22:00:00 | NQ | Futures | 5516.22 | 5521.85 | 5514.44 | 5519.77 | 231.0 |
| 2015-12-10 23:00:00 | NQ | Futures | 5519.77 | 5520.07 | 5512.95 | 5515.92 | 218.0 |
| 2015-12-10 00:00:00 | YM | Futures | 18559.2 | 18559.2 | 18546.4 | 18546.4 | 20.0 |
| 2015-12-10 01:00:00 | YM | Futures | 18548.5 | 18548.5 | 18539.0 | 18542.1 | 108.0 |
| 2015-12-10 02:00:00 | YM | Futures | 18537.9 | 18566.6 | 18534.7 | 18561.3 | 66.0 |
| 2015-12-10 03:00:00 | YM | Futures | 18547.5 | 18599.6 | 18521.9 | 18546.4 | 263.0 |
> showing 50 of 1,494 rows — these rows as CSV