PREVIEW / futures_1hour / 2015-11-26
file: by_date/futures_1hour/2015/2015-11-26.parquet size: 35 KB rows: 1,098
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-26 00:00:00 | ES | Futures | 2237.74 | 2238.01 | 2236.41 | 2236.67 | 1660.0 |
| 2015-11-26 01:00:00 | ES | Futures | 2236.94 | 2237.21 | 2235.07 | 2237.21 | 2531.0 |
| 2015-11-26 02:00:00 | ES | Futures | 2237.21 | 2237.48 | 2235.6 | 2236.67 | 3843.0 |
| 2015-11-26 03:00:00 | ES | Futures | 2236.94 | 2240.69 | 2235.6 | 2239.88 | 14563.0 |
| 2015-11-26 04:00:00 | ES | Futures | 2239.62 | 2244.7 | 2238.28 | 2243.9 | 15973.0 |
| 2015-11-26 05:00:00 | ES | Futures | 2243.9 | 2244.43 | 2242.56 | 2243.36 | 6845.0 |
| 2015-11-26 06:00:00 | ES | Futures | 2243.36 | 2245.77 | 2242.83 | 2244.43 | 11991.0 |
| 2015-11-26 07:00:00 | ES | Futures | 2244.7 | 2245.5 | 2243.09 | 2244.17 | 6168.0 |
| 2015-11-26 08:00:00 | ES | Futures | 2244.17 | 2244.97 | 2242.29 | 2242.83 | 5949.0 |
| 2015-11-26 09:00:00 | ES | Futures | 2242.56 | 2243.09 | 2240.42 | 2241.22 | 10541.0 |
| 2015-11-26 10:00:00 | ES | Futures | 2241.49 | 2243.09 | 2240.95 | 2242.56 | 7941.0 |
| 2015-11-26 11:00:00 | ES | Futures | 2242.56 | 2244.17 | 2241.76 | 2243.63 | 7852.0 |
| 2015-11-26 12:00:00 | ES | Futures | 2243.63 | 2244.43 | 2241.76 | 2242.56 | 4858.0 |
| 2015-11-26 18:00:00 | ES | Futures | 2242.02 | 2243.09 | 2242.02 | 2242.83 | 846.0 |
| 2015-11-26 19:00:00 | ES | Futures | 2243.09 | 2243.36 | 2242.29 | 2242.56 | 1526.0 |
| 2015-11-26 20:00:00 | ES | Futures | 2242.56 | 2243.36 | 2239.08 | 2239.88 | 5586.0 |
| 2015-11-26 21:00:00 | ES | Futures | 2239.62 | 2240.69 | 2238.28 | 2238.81 | 2321.0 |
| 2015-11-26 22:00:00 | ES | Futures | 2239.08 | 2239.62 | 2238.01 | 2238.01 | 2751.0 |
| 2015-11-26 23:00:00 | ES | Futures | 2238.01 | 2239.88 | 2238.01 | 2239.62 | 1329.0 |
| 2015-11-26 00:00:00 | NQ | Futures | 5554.46 | 5556.24 | 5550.9 | 5551.79 | 423.0 |
| 2015-11-26 01:00:00 | NQ | Futures | 5552.39 | 5553.87 | 5548.83 | 5553.57 | 340.0 |
| 2015-11-26 02:00:00 | NQ | Futures | 5552.68 | 5554.46 | 5550.61 | 5553.28 | 862.0 |
| 2015-11-26 03:00:00 | NQ | Futures | 5553.57 | 5564.25 | 5550.31 | 5562.17 | 1797.0 |
| 2015-11-26 04:00:00 | NQ | Futures | 5561.88 | 5572.25 | 5558.91 | 5570.77 | 1797.0 |
| 2015-11-26 05:00:00 | NQ | Futures | 5570.47 | 5572.25 | 5566.92 | 5569.29 | 892.0 |
| 2015-11-26 06:00:00 | NQ | Futures | 5569.88 | 5577.89 | 5568.4 | 5574.03 | 2137.0 |
| 2015-11-26 07:00:00 | NQ | Futures | 5574.33 | 5577.0 | 5572.85 | 5576.4 | 1218.0 |
| 2015-11-26 08:00:00 | NQ | Futures | 5576.4 | 5577.89 | 5570.18 | 5571.36 | 1013.0 |
| 2015-11-26 09:00:00 | NQ | Futures | 5571.07 | 5572.85 | 5565.43 | 5568.4 | 2850.0 |
| 2015-11-26 10:00:00 | NQ | Futures | 5568.69 | 5571.07 | 5567.51 | 5569.88 | 1163.0 |
| 2015-11-26 11:00:00 | NQ | Futures | 5569.88 | 5575.22 | 5568.69 | 5573.73 | 894.0 |
| 2015-11-26 12:00:00 | NQ | Futures | 5573.73 | 5574.33 | 5557.43 | 5568.69 | 1999.0 |
| 2015-11-26 18:00:00 | NQ | Futures | 5566.62 | 5570.47 | 5566.62 | 5569.88 | 186.0 |
| 2015-11-26 19:00:00 | NQ | Futures | 5570.77 | 5571.66 | 5568.1 | 5570.18 | 426.0 |
| 2015-11-26 20:00:00 | NQ | Futures | 5570.47 | 5572.85 | 5560.69 | 5562.76 | 1548.0 |
| 2015-11-26 21:00:00 | NQ | Futures | 5562.76 | 5565.43 | 5560.99 | 5562.17 | 531.0 |
| 2015-11-26 22:00:00 | NQ | Futures | 5561.58 | 5563.36 | 5557.13 | 5557.43 | 695.0 |
| 2015-11-26 23:00:00 | NQ | Futures | 5557.43 | 5562.47 | 5557.43 | 5562.17 | 200.0 |
| 2015-11-26 00:00:00 | YM | Futures | 18881.2 | 18886.5 | 18865.3 | 18869.5 | 462.0 |
| 2015-11-26 01:00:00 | YM | Futures | 18870.6 | 18872.7 | 18855.8 | 18870.6 | 526.0 |
| 2015-11-26 02:00:00 | YM | Futures | 18868.5 | 18873.8 | 18858.9 | 18867.4 | 439.0 |
| 2015-11-26 03:00:00 | YM | Futures | 18866.4 | 18899.2 | 18858.9 | 18891.8 | 1379.0 |
| 2015-11-26 04:00:00 | YM | Futures | 18891.8 | 18928.9 | 18882.3 | 18920.4 | 1759.0 |
| 2015-11-26 05:00:00 | YM | Futures | 18920.4 | 18921.4 | 18904.5 | 18913.0 | 1104.0 |
| 2015-11-26 06:00:00 | YM | Futures | 18914.0 | 18934.2 | 18907.7 | 18924.6 | 1136.0 |
| 2015-11-26 07:00:00 | YM | Futures | 18922.5 | 18926.7 | 18910.9 | 18919.3 | 684.0 |
| 2015-11-26 08:00:00 | YM | Futures | 18919.3 | 18921.4 | 18904.5 | 18910.9 | 804.0 |
| 2015-11-26 09:00:00 | YM | Futures | 18908.7 | 18913.0 | 18895.0 | 18899.2 | 1407.0 |
| 2015-11-26 10:00:00 | YM | Futures | 18900.3 | 18910.9 | 18897.1 | 18903.4 | 1145.0 |
| 2015-11-26 11:00:00 | YM | Futures | 18904.5 | 18917.2 | 18898.1 | 18913.0 | 828.0 |
> showing 50 of 1,098 rows — these rows as CSV