PREVIEW / futures_1hour / 2015-08-11
file: by_date/futures_1hour/2015/2015-08-11.parquet size: 53 KB rows: 1,588
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-08-11 00:00:00 | ES | Futures | 2226.63 | 2227.7 | 2223.97 | 2227.43 | 10655.0 |
| 2015-08-11 01:00:00 | ES | Futures | 2227.17 | 2228.76 | 2226.37 | 2226.37 | 5476.0 |
| 2015-08-11 02:00:00 | ES | Futures | 2226.37 | 2228.5 | 2225.3 | 2228.23 | 11100.0 |
| 2015-08-11 03:00:00 | ES | Futures | 2227.97 | 2229.83 | 2226.1 | 2226.63 | 22862.0 |
| 2015-08-11 04:00:00 | ES | Futures | 2226.63 | 2230.89 | 2225.57 | 2226.63 | 21420.0 |
| 2015-08-11 05:00:00 | ES | Futures | 2226.37 | 2226.9 | 2221.04 | 2222.37 | 28486.0 |
| 2015-08-11 06:00:00 | ES | Futures | 2222.11 | 2228.23 | 2221.04 | 2227.7 | 26354.0 |
| 2015-08-11 07:00:00 | ES | Futures | 2227.7 | 2228.23 | 2222.91 | 2224.5 | 34328.0 |
| 2015-08-11 08:00:00 | ES | Futures | 2224.24 | 2224.5 | 2216.25 | 2216.52 | 55293.0 |
| 2015-08-11 09:00:00 | ES | Futures | 2216.78 | 2222.11 | 2215.72 | 2218.65 | 266190.0 |
| 2015-08-11 10:00:00 | ES | Futures | 2218.91 | 2223.97 | 2216.78 | 2217.85 | 225685.0 |
| 2015-08-11 11:00:00 | ES | Futures | 2217.85 | 2218.91 | 2208.53 | 2209.86 | 246216.0 |
| 2015-08-11 12:00:00 | ES | Futures | 2210.13 | 2214.12 | 2208.53 | 2209.33 | 130995.0 |
| 2015-08-11 13:00:00 | ES | Futures | 2209.33 | 2211.19 | 2205.33 | 2206.93 | 167136.0 |
| 2015-08-11 14:00:00 | ES | Futures | 2206.93 | 2212.26 | 2205.87 | 2211.46 | 139877.0 |
| 2015-08-11 15:00:00 | ES | Futures | 2211.19 | 2216.52 | 2209.59 | 2214.92 | 237980.0 |
| 2015-08-11 16:00:00 | ES | Futures | 2215.19 | 2217.32 | 2214.12 | 2215.98 | 86205.0 |
| 2015-08-11 17:00:00 | ES | Futures | 2215.98 | 2216.25 | 2215.45 | 2215.98 | 1361.0 |
| 2015-08-11 18:00:00 | ES | Futures | 2215.98 | 2217.32 | 2215.19 | 2216.78 | 3577.0 |
| 2015-08-11 19:00:00 | ES | Futures | 2216.78 | 2218.91 | 2216.25 | 2218.91 | 3085.0 |
| 2015-08-11 20:00:00 | ES | Futures | 2218.65 | 2220.78 | 2218.11 | 2219.45 | 6467.0 |
| 2015-08-11 21:00:00 | ES | Futures | 2219.45 | 2220.24 | 2199.48 | 2203.47 | 53888.0 |
| 2015-08-11 22:00:00 | ES | Futures | 2203.74 | 2205.07 | 2200.81 | 2203.47 | 12487.0 |
| 2015-08-11 23:00:00 | ES | Futures | 2203.2 | 2204.27 | 2200.01 | 2200.28 | 5943.0 |
| 2015-08-11 00:00:00 | NQ | Futures | 5394.61 | 5396.09 | 5387.21 | 5394.61 | 1095.0 |
| 2015-08-11 01:00:00 | NQ | Futures | 5395.2 | 5399.34 | 5392.24 | 5393.42 | 975.0 |
| 2015-08-11 02:00:00 | NQ | Futures | 5393.72 | 5401.41 | 5390.47 | 5400.82 | 1385.0 |
| 2015-08-11 03:00:00 | NQ | Futures | 5400.52 | 5405.85 | 5395.79 | 5399.04 | 2487.0 |
| 2015-08-11 04:00:00 | NQ | Futures | 5399.34 | 5409.4 | 5391.65 | 5393.42 | 3299.0 |
| 2015-08-11 05:00:00 | NQ | Futures | 5394.02 | 5395.2 | 5381.59 | 5383.96 | 4036.0 |
| 2015-08-11 06:00:00 | NQ | Futures | 5383.96 | 5400.23 | 5381.59 | 5399.93 | 3610.0 |
| 2015-08-11 07:00:00 | NQ | Futures | 5399.93 | 5400.82 | 5387.51 | 5390.76 | 6503.0 |
| 2015-08-11 08:00:00 | NQ | Futures | 5390.76 | 5391.06 | 5364.73 | 5365.92 | 7858.0 |
| 2015-08-11 09:00:00 | NQ | Futures | 5365.92 | 5399.04 | 5364.14 | 5387.21 | 47018.0 |
| 2015-08-11 10:00:00 | NQ | Futures | 5386.92 | 5391.35 | 5366.51 | 5366.8 | 37264.0 |
| 2015-08-11 11:00:00 | NQ | Futures | 5366.8 | 5370.65 | 5331.31 | 5336.63 | 41863.0 |
| 2015-08-11 12:00:00 | NQ | Futures | 5336.63 | 5346.99 | 5327.76 | 5328.94 | 22077.0 |
| 2015-08-11 13:00:00 | NQ | Futures | 5328.94 | 5329.53 | 5310.9 | 5312.08 | 33512.0 |
| 2015-08-11 14:00:00 | NQ | Futures | 5312.08 | 5328.65 | 5307.05 | 5325.98 | 27810.0 |
| 2015-08-11 15:00:00 | NQ | Futures | 5325.98 | 5343.14 | 5322.73 | 5336.93 | 39089.0 |
| 2015-08-11 16:00:00 | NQ | Futures | 5336.93 | 5344.03 | 5334.86 | 5340.48 | 7353.0 |
| 2015-08-11 17:00:00 | NQ | Futures | 5340.48 | 5342.25 | 5340.18 | 5342.25 | 82.0 |
| 2015-08-11 18:00:00 | NQ | Futures | 5339.29 | 5344.91 | 5339.29 | 5344.62 | 853.0 |
| 2015-08-11 19:00:00 | NQ | Futures | 5344.91 | 5350.83 | 5342.55 | 5349.94 | 628.0 |
| 2015-08-11 20:00:00 | NQ | Futures | 5349.65 | 5354.08 | 5348.76 | 5350.53 | 986.0 |
| 2015-08-11 21:00:00 | NQ | Futures | 5350.53 | 5352.61 | 5294.33 | 5313.27 | 11020.0 |
| 2015-08-11 22:00:00 | NQ | Futures | 5313.27 | 5317.41 | 5304.98 | 5313.27 | 2208.0 |
| 2015-08-11 23:00:00 | NQ | Futures | 5312.67 | 5314.74 | 5302.03 | 5302.62 | 1336.0 |
| 2015-08-11 00:00:00 | YM | Futures | 18414.5 | 18417.6 | 18392.4 | 18414.5 | 2130.0 |
| 2015-08-11 01:00:00 | YM | Futures | 18415.5 | 18426.1 | 18407.1 | 18410.3 | 1137.0 |
> showing 50 of 1,588 rows — these rows as CSV