PREVIEW / futures_1hour / 2015-11-03
file: by_date/futures_1hour/2015/2015-11-03.parquet size: 52 KB rows: 1,600
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-03 00:00:00 | ES | Futures | 2242.29 | 2242.83 | 2241.22 | 2241.22 | 1898.0 |
| 2015-11-03 01:00:00 | ES | Futures | 2241.49 | 2242.02 | 2240.69 | 2241.76 | 1480.0 |
| 2015-11-03 02:00:00 | ES | Futures | 2241.49 | 2242.02 | 2240.95 | 2241.22 | 6538.0 |
| 2015-11-03 03:00:00 | ES | Futures | 2240.95 | 2242.56 | 2239.08 | 2239.88 | 16680.0 |
| 2015-11-03 04:00:00 | ES | Futures | 2239.88 | 2241.22 | 2238.81 | 2240.42 | 14689.0 |
| 2015-11-03 05:00:00 | ES | Futures | 2240.42 | 2240.69 | 2238.55 | 2239.62 | 8073.0 |
| 2015-11-03 06:00:00 | ES | Futures | 2239.62 | 2239.88 | 2237.21 | 2237.48 | 10396.0 |
| 2015-11-03 07:00:00 | ES | Futures | 2237.48 | 2238.28 | 2235.87 | 2237.21 | 17724.0 |
| 2015-11-03 08:00:00 | ES | Futures | 2237.48 | 2239.35 | 2235.87 | 2238.28 | 24042.0 |
| 2015-11-03 09:00:00 | ES | Futures | 2238.55 | 2243.09 | 2237.48 | 2239.08 | 207567.0 |
| 2015-11-03 10:00:00 | ES | Futures | 2239.35 | 2246.57 | 2239.35 | 2244.17 | 221989.0 |
| 2015-11-03 11:00:00 | ES | Futures | 2243.9 | 2250.85 | 2242.83 | 2250.05 | 163774.0 |
| 2015-11-03 12:00:00 | ES | Futures | 2250.05 | 2250.85 | 2246.57 | 2249.52 | 100966.0 |
| 2015-11-03 13:00:00 | ES | Futures | 2249.52 | 2253.8 | 2248.71 | 2252.19 | 120719.0 |
| 2015-11-03 14:00:00 | ES | Futures | 2252.19 | 2258.61 | 2252.19 | 2255.67 | 169349.0 |
| 2015-11-03 15:00:00 | ES | Futures | 2255.67 | 2256.21 | 2248.45 | 2250.85 | 184067.0 |
| 2015-11-03 16:00:00 | ES | Futures | 2251.12 | 2251.12 | 2248.98 | 2250.32 | 47086.0 |
| 2015-11-03 18:00:00 | ES | Futures | 2250.32 | 2250.32 | 2248.98 | 2249.25 | 2276.0 |
| 2015-11-03 19:00:00 | ES | Futures | 2249.52 | 2249.52 | 2248.18 | 2248.71 | 4241.0 |
| 2015-11-03 20:00:00 | ES | Futures | 2248.71 | 2254.6 | 2248.45 | 2254.6 | 8794.0 |
| 2015-11-03 21:00:00 | ES | Futures | 2254.33 | 2257.01 | 2253.53 | 2255.94 | 9654.0 |
| 2015-11-03 22:00:00 | ES | Futures | 2255.94 | 2256.21 | 2253.53 | 2253.8 | 3953.0 |
| 2015-11-03 23:00:00 | ES | Futures | 2253.53 | 2254.6 | 2251.92 | 2252.73 | 4302.0 |
| 2015-11-03 00:00:00 | NQ | Futures | 5566.92 | 5567.51 | 5562.76 | 5563.06 | 466.0 |
| 2015-11-03 01:00:00 | NQ | Futures | 5563.06 | 5564.25 | 5560.99 | 5563.65 | 355.0 |
| 2015-11-03 02:00:00 | NQ | Futures | 5563.06 | 5564.25 | 5561.28 | 5561.28 | 795.0 |
| 2015-11-03 03:00:00 | NQ | Futures | 5561.58 | 5564.54 | 5555.65 | 5558.02 | 3004.0 |
| 2015-11-03 04:00:00 | NQ | Futures | 5558.02 | 5561.28 | 5555.95 | 5558.91 | 1859.0 |
| 2015-11-03 05:00:00 | NQ | Futures | 5558.61 | 5558.91 | 5554.17 | 5555.65 | 1532.0 |
| 2015-11-03 06:00:00 | NQ | Futures | 5556.24 | 5557.13 | 5550.9 | 5551.79 | 1875.0 |
| 2015-11-03 07:00:00 | NQ | Futures | 5552.09 | 5554.46 | 5549.42 | 5552.09 | 2374.0 |
| 2015-11-03 08:00:00 | NQ | Futures | 5552.39 | 5555.35 | 5546.75 | 5551.5 | 4623.0 |
| 2015-11-03 09:00:00 | NQ | Futures | 5551.5 | 5563.06 | 5547.35 | 5555.06 | 30038.0 |
| 2015-11-03 10:00:00 | NQ | Futures | 5555.35 | 5571.07 | 5554.46 | 5562.76 | 30984.0 |
| 2015-11-03 11:00:00 | NQ | Futures | 5563.06 | 5585.3 | 5560.69 | 5583.22 | 25908.0 |
| 2015-11-03 12:00:00 | NQ | Futures | 5583.22 | 5587.08 | 5577.59 | 5583.22 | 14533.0 |
| 2015-11-03 13:00:00 | NQ | Futures | 5583.22 | 5595.08 | 5582.63 | 5593.01 | 15136.0 |
| 2015-11-03 14:00:00 | NQ | Futures | 5592.71 | 5606.65 | 5592.12 | 5601.01 | 20625.0 |
| 2015-11-03 15:00:00 | NQ | Futures | 5600.72 | 5601.01 | 5579.37 | 5586.78 | 24505.0 |
| 2015-11-03 16:00:00 | NQ | Futures | 5586.78 | 5589.15 | 5580.85 | 5589.15 | 4779.0 |
| 2015-11-03 18:00:00 | NQ | Futures | 5587.97 | 5588.26 | 5583.82 | 5586.78 | 444.0 |
| 2015-11-03 19:00:00 | NQ | Futures | 5586.48 | 5586.48 | 5583.52 | 5585.0 | 563.0 |
| 2015-11-03 20:00:00 | NQ | Futures | 5585.0 | 5601.31 | 5584.41 | 5601.01 | 1591.0 |
| 2015-11-03 21:00:00 | NQ | Futures | 5601.6 | 5607.24 | 5599.23 | 5604.57 | 1668.0 |
| 2015-11-03 22:00:00 | NQ | Futures | 5605.16 | 5605.76 | 5599.83 | 5600.12 | 740.0 |
| 2015-11-03 23:00:00 | NQ | Futures | 5600.42 | 5603.38 | 5596.56 | 5597.45 | 840.0 |
| 2015-11-03 00:00:00 | YM | Futures | 18786.9 | 18791.2 | 18774.2 | 18774.2 | 769.0 |
| 2015-11-03 01:00:00 | YM | Futures | 18774.2 | 18779.5 | 18768.9 | 18778.4 | 431.0 |
| 2015-11-03 02:00:00 | YM | Futures | 18776.3 | 18779.5 | 18770.0 | 18773.1 | 743.0 |
| 2015-11-03 03:00:00 | YM | Futures | 18772.1 | 18782.7 | 18754.1 | 18763.6 | 2491.0 |
> showing 50 of 1,600 rows — these rows as CSV