PREVIEW / futures_1hour / 2015-04-27
file: by_date/futures_1hour/2015/2015-04-27.parquet size: 51 KB rows: 1,562
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-04-27 00:00:00 | ES | Futures | 2231.53 | 2232.32 | 2231.27 | 2232.32 | 918.0 |
| 2015-04-27 01:00:00 | ES | Futures | 2232.06 | 2232.32 | 2230.74 | 2231.8 | 1875.0 |
| 2015-04-27 02:00:00 | ES | Futures | 2231.8 | 2233.91 | 2231.53 | 2233.91 | 6997.0 |
| 2015-04-27 03:00:00 | ES | Futures | 2234.17 | 2236.02 | 2227.57 | 2229.42 | 34603.0 |
| 2015-04-27 04:00:00 | ES | Futures | 2229.42 | 2233.12 | 2229.42 | 2232.59 | 15339.0 |
| 2015-04-27 05:00:00 | ES | Futures | 2232.59 | 2233.64 | 2230.21 | 2233.12 | 9006.0 |
| 2015-04-27 06:00:00 | ES | Futures | 2233.12 | 2237.08 | 2233.12 | 2236.55 | 15616.0 |
| 2015-04-27 07:00:00 | ES | Futures | 2236.29 | 2237.61 | 2234.96 | 2236.02 | 16937.0 |
| 2015-04-27 08:00:00 | ES | Futures | 2236.02 | 2236.02 | 2235.23 | 2235.76 | 13662.0 |
| 2015-04-27 09:00:00 | ES | Futures | 2235.76 | 2238.93 | 2232.85 | 2237.87 | 173103.0 |
| 2015-04-27 10:00:00 | ES | Futures | 2237.61 | 2239.45 | 2232.32 | 2233.38 | 128468.0 |
| 2015-04-27 11:00:00 | ES | Futures | 2233.38 | 2235.76 | 2230.47 | 2231.53 | 127832.0 |
| 2015-04-27 12:00:00 | ES | Futures | 2231.53 | 2232.32 | 2224.14 | 2225.72 | 125757.0 |
| 2015-04-27 13:00:00 | ES | Futures | 2225.46 | 2228.1 | 2223.08 | 2226.25 | 104921.0 |
| 2015-04-27 14:00:00 | ES | Futures | 2226.25 | 2227.83 | 2222.55 | 2224.66 | 104925.0 |
| 2015-04-27 15:00:00 | ES | Futures | 2224.66 | 2226.51 | 2218.85 | 2221.49 | 231376.0 |
| 2015-04-27 16:00:00 | ES | Futures | 2221.23 | 2225.19 | 2220.97 | 2222.02 | 71456.0 |
| 2015-04-27 17:00:00 | ES | Futures | 2222.29 | 2223.08 | 2222.02 | 2222.82 | 1289.0 |
| 2015-04-27 18:00:00 | ES | Futures | 2222.55 | 2223.34 | 2221.76 | 2222.82 | 2885.0 |
| 2015-04-27 19:00:00 | ES | Futures | 2223.08 | 2224.14 | 2222.82 | 2223.61 | 1427.0 |
| 2015-04-27 20:00:00 | ES | Futures | 2223.61 | 2223.87 | 2220.97 | 2221.76 | 5618.0 |
| 2015-04-27 21:00:00 | ES | Futures | 2221.49 | 2222.29 | 2219.65 | 2220.97 | 4375.0 |
| 2015-04-27 22:00:00 | ES | Futures | 2220.97 | 2222.02 | 2220.7 | 2221.76 | 2160.0 |
| 2015-04-27 23:00:00 | ES | Futures | 2221.49 | 2223.34 | 2220.7 | 2221.49 | 2481.0 |
| 2015-04-27 00:00:00 | NQ | Futures | 5331.08 | 5333.14 | 5330.78 | 5333.14 | 172.0 |
| 2015-04-27 01:00:00 | NQ | Futures | 5333.14 | 5333.14 | 5330.49 | 5331.96 | 234.0 |
| 2015-04-27 02:00:00 | NQ | Futures | 5331.37 | 5336.37 | 5331.08 | 5335.78 | 1135.0 |
| 2015-04-27 03:00:00 | NQ | Futures | 5336.08 | 5341.37 | 5323.73 | 5329.9 | 5682.0 |
| 2015-04-27 04:00:00 | NQ | Futures | 5329.61 | 5338.43 | 5329.02 | 5335.19 | 2288.0 |
| 2015-04-27 05:00:00 | NQ | Futures | 5335.19 | 5337.55 | 5330.2 | 5336.67 | 1206.0 |
| 2015-04-27 06:00:00 | NQ | Futures | 5336.08 | 5342.84 | 5335.78 | 5341.96 | 3259.0 |
| 2015-04-27 07:00:00 | NQ | Futures | 5341.66 | 5345.19 | 5339.02 | 5342.84 | 3226.0 |
| 2015-04-27 08:00:00 | NQ | Futures | 5342.55 | 5346.96 | 5342.25 | 5346.08 | 3790.0 |
| 2015-04-27 09:00:00 | NQ | Futures | 5346.37 | 5357.25 | 5337.25 | 5355.49 | 34752.0 |
| 2015-04-27 10:00:00 | NQ | Futures | 5355.49 | 5358.43 | 5340.49 | 5340.78 | 22906.0 |
| 2015-04-27 11:00:00 | NQ | Futures | 5340.78 | 5348.43 | 5331.37 | 5332.55 | 26680.0 |
| 2015-04-27 12:00:00 | NQ | Futures | 5332.55 | 5334.61 | 5318.73 | 5322.84 | 23806.0 |
| 2015-04-27 13:00:00 | NQ | Futures | 5322.55 | 5329.31 | 5317.55 | 5319.61 | 16923.0 |
| 2015-04-27 14:00:00 | NQ | Futures | 5319.9 | 5323.73 | 5309.91 | 5314.9 | 20810.0 |
| 2015-04-27 15:00:00 | NQ | Futures | 5315.2 | 5319.9 | 5304.02 | 5315.49 | 36505.0 |
| 2015-04-27 16:00:00 | NQ | Futures | 5315.79 | 5332.55 | 5313.14 | 5320.49 | 18035.0 |
| 2015-04-27 17:00:00 | NQ | Futures | 5321.08 | 5324.31 | 5320.79 | 5321.96 | 493.0 |
| 2015-04-27 18:00:00 | NQ | Futures | 5321.67 | 5323.14 | 5319.61 | 5321.96 | 566.0 |
| 2015-04-27 19:00:00 | NQ | Futures | 5321.67 | 5325.2 | 5321.67 | 5324.31 | 336.0 |
| 2015-04-27 20:00:00 | NQ | Futures | 5324.02 | 5324.02 | 5318.73 | 5320.49 | 602.0 |
| 2015-04-27 21:00:00 | NQ | Futures | 5320.49 | 5322.55 | 5314.32 | 5320.2 | 1052.0 |
| 2015-04-27 22:00:00 | NQ | Futures | 5320.2 | 5323.43 | 5319.61 | 5321.37 | 637.0 |
| 2015-04-27 23:00:00 | NQ | Futures | 5321.37 | 5324.9 | 5318.14 | 5321.67 | 476.0 |
| 2015-04-27 00:00:00 | YM | Futures | 18899.1 | 18908.5 | 18897.0 | 18904.3 | 176.0 |
| 2015-04-27 01:00:00 | YM | Futures | 18904.3 | 18905.4 | 18894.9 | 18903.3 | 342.0 |
> showing 50 of 1,562 rows — these rows as CSV