PREVIEW / futures_1hour / 2015-05-14
file: by_date/futures_1hour/2015/2015-05-14.parquet size: 51 KB rows: 1,546
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-05-14 00:00:00 | ES | Futures | 2213.31 | 2214.1 | 2213.04 | 2213.84 | 1138.0 |
| 2015-05-14 01:00:00 | ES | Futures | 2213.84 | 2214.36 | 2213.57 | 2213.84 | 1798.0 |
| 2015-05-14 02:00:00 | ES | Futures | 2213.57 | 2215.16 | 2211.46 | 2215.16 | 9543.0 |
| 2015-05-14 03:00:00 | ES | Futures | 2215.16 | 2222.55 | 2210.14 | 2220.44 | 33533.0 |
| 2015-05-14 04:00:00 | ES | Futures | 2220.44 | 2224.4 | 2218.06 | 2222.82 | 23989.0 |
| 2015-05-14 05:00:00 | ES | Futures | 2223.08 | 2223.61 | 2221.49 | 2221.49 | 10033.0 |
| 2015-05-14 06:00:00 | ES | Futures | 2221.76 | 2223.34 | 2220.7 | 2222.82 | 8993.0 |
| 2015-05-14 07:00:00 | ES | Futures | 2222.82 | 2226.78 | 2221.23 | 2225.98 | 32322.0 |
| 2015-05-14 08:00:00 | ES | Futures | 2225.98 | 2226.78 | 2223.87 | 2225.46 | 30163.0 |
| 2015-05-14 09:00:00 | ES | Futures | 2225.72 | 2228.36 | 2222.29 | 2224.14 | 172084.0 |
| 2015-05-14 10:00:00 | ES | Futures | 2224.14 | 2230.21 | 2222.55 | 2228.63 | 155789.0 |
| 2015-05-14 11:00:00 | ES | Futures | 2228.63 | 2229.95 | 2226.78 | 2229.15 | 99909.0 |
| 2015-05-14 12:00:00 | ES | Futures | 2229.42 | 2233.38 | 2228.1 | 2232.85 | 100666.0 |
| 2015-05-14 13:00:00 | ES | Futures | 2233.12 | 2236.02 | 2232.32 | 2234.7 | 96169.0 |
| 2015-05-14 14:00:00 | ES | Futures | 2234.7 | 2236.02 | 2233.91 | 2235.49 | 75153.0 |
| 2015-05-14 15:00:00 | ES | Futures | 2235.76 | 2237.34 | 2234.44 | 2236.29 | 159375.0 |
| 2015-05-14 16:00:00 | ES | Futures | 2236.02 | 2237.87 | 2235.76 | 2237.08 | 72363.0 |
| 2015-05-14 17:00:00 | ES | Futures | 2237.08 | 2237.34 | 2236.81 | 2236.81 | 1501.0 |
| 2015-05-14 18:00:00 | ES | Futures | 2236.81 | 2237.08 | 2235.76 | 2236.55 | 2052.0 |
| 2015-05-14 19:00:00 | ES | Futures | 2236.55 | 2236.81 | 2236.02 | 2236.55 | 1152.0 |
| 2015-05-14 20:00:00 | ES | Futures | 2236.55 | 2239.19 | 2236.02 | 2237.61 | 5385.0 |
| 2015-05-14 21:00:00 | ES | Futures | 2237.87 | 2238.13 | 2236.81 | 2237.08 | 2023.0 |
| 2015-05-14 22:00:00 | ES | Futures | 2237.34 | 2237.34 | 2236.29 | 2236.55 | 2662.0 |
| 2015-05-14 23:00:00 | ES | Futures | 2236.81 | 2237.61 | 2235.76 | 2236.81 | 2201.0 |
| 2015-05-14 00:00:00 | NQ | Futures | 5202.57 | 5203.75 | 5200.81 | 5203.75 | 164.0 |
| 2015-05-14 01:00:00 | NQ | Futures | 5203.16 | 5204.63 | 5202.28 | 5202.57 | 313.0 |
| 2015-05-14 02:00:00 | NQ | Futures | 5202.87 | 5205.81 | 5196.98 | 5205.81 | 1039.0 |
| 2015-05-14 03:00:00 | NQ | Futures | 5205.81 | 5226.39 | 5190.52 | 5221.39 | 7921.0 |
| 2015-05-14 04:00:00 | NQ | Futures | 5221.39 | 5236.68 | 5215.8 | 5232.86 | 4782.0 |
| 2015-05-14 05:00:00 | NQ | Futures | 5233.45 | 5234.33 | 5229.04 | 5230.21 | 1733.0 |
| 2015-05-14 06:00:00 | NQ | Futures | 5230.21 | 5232.57 | 5226.98 | 5230.8 | 1340.0 |
| 2015-05-14 07:00:00 | NQ | Futures | 5231.39 | 5241.68 | 5227.57 | 5240.51 | 4989.0 |
| 2015-05-14 08:00:00 | NQ | Futures | 5240.21 | 5242.56 | 5235.8 | 5241.09 | 6056.0 |
| 2015-05-14 09:00:00 | NQ | Futures | 5241.68 | 5250.5 | 5227.27 | 5235.51 | 36073.0 |
| 2015-05-14 10:00:00 | NQ | Futures | 5235.8 | 5257.56 | 5231.39 | 5255.8 | 29336.0 |
| 2015-05-14 11:00:00 | NQ | Futures | 5255.21 | 5264.33 | 5253.15 | 5261.97 | 19235.0 |
| 2015-05-14 12:00:00 | NQ | Futures | 5262.27 | 5270.5 | 5258.15 | 5269.91 | 15674.0 |
| 2015-05-14 13:00:00 | NQ | Futures | 5270.21 | 5278.15 | 5269.32 | 5274.32 | 15011.0 |
| 2015-05-14 14:00:00 | NQ | Futures | 5274.62 | 5279.91 | 5272.56 | 5276.97 | 10559.0 |
| 2015-05-14 15:00:00 | NQ | Futures | 5276.97 | 5284.62 | 5275.21 | 5280.2 | 20976.0 |
| 2015-05-14 16:00:00 | NQ | Futures | 5279.91 | 5284.91 | 5278.73 | 5281.09 | 6110.0 |
| 2015-05-14 17:00:00 | NQ | Futures | 5281.38 | 5282.56 | 5280.5 | 5282.56 | 157.0 |
| 2015-05-14 18:00:00 | NQ | Futures | 5280.2 | 5281.09 | 5279.03 | 5280.79 | 373.0 |
| 2015-05-14 19:00:00 | NQ | Futures | 5280.79 | 5281.68 | 5279.91 | 5281.68 | 201.0 |
| 2015-05-14 20:00:00 | NQ | Futures | 5281.97 | 5289.03 | 5281.97 | 5284.91 | 1136.0 |
| 2015-05-14 21:00:00 | NQ | Futures | 5285.2 | 5286.38 | 5283.73 | 5284.91 | 369.0 |
| 2015-05-14 22:00:00 | NQ | Futures | 5284.62 | 5284.91 | 5281.97 | 5283.44 | 434.0 |
| 2015-05-14 23:00:00 | NQ | Futures | 5283.44 | 5286.38 | 5282.56 | 5284.91 | 352.0 |
| 2015-05-14 00:00:00 | YM | Futures | 18895.9 | 18899.1 | 18891.7 | 18899.1 | 272.0 |
| 2015-05-14 01:00:00 | YM | Futures | 18898.0 | 18902.2 | 18895.9 | 18899.1 | 384.0 |
> showing 50 of 1,546 rows — these rows as CSV