PREVIEW / futures_1hour / 2015-04-29
file: by_date/futures_1hour/2015/2015-04-29.parquet size: 54 KB rows: 1,616
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-29 00:00:00 | ES | Futures | 2229.15 | 2229.42 | 2228.1 | 2228.36 | 1086.0 |
| 2015-04-29 01:00:00 | ES | Futures | 2228.63 | 2229.42 | 2227.57 | 2228.1 | 2008.0 |
| 2015-04-29 02:00:00 | ES | Futures | 2228.36 | 2229.95 | 2227.83 | 2228.1 | 5508.0 |
| 2015-04-29 03:00:00 | ES | Futures | 2228.36 | 2230.21 | 2227.04 | 2229.95 | 23479.0 |
| 2015-04-29 04:00:00 | ES | Futures | 2229.95 | 2231.8 | 2229.15 | 2230.21 | 12295.0 |
| 2015-04-29 05:00:00 | ES | Futures | 2229.95 | 2231.0 | 2228.36 | 2229.15 | 9825.0 |
| 2015-04-29 06:00:00 | ES | Futures | 2229.15 | 2229.95 | 2228.36 | 2228.89 | 6801.0 |
| 2015-04-29 07:00:00 | ES | Futures | 2228.89 | 2229.15 | 2224.93 | 2226.51 | 18506.0 |
| 2015-04-29 08:00:00 | ES | Futures | 2226.51 | 2226.78 | 2216.21 | 2217.8 | 106127.0 |
| 2015-04-29 09:00:00 | ES | Futures | 2217.8 | 2225.98 | 2213.57 | 2222.02 | 271377.0 |
| 2015-04-29 10:00:00 | ES | Futures | 2222.29 | 2223.61 | 2214.1 | 2218.85 | 296713.0 |
| 2015-04-29 11:00:00 | ES | Futures | 2218.85 | 2223.08 | 2216.21 | 2217.8 | 144875.0 |
| 2015-04-29 12:00:00 | ES | Futures | 2217.8 | 2218.33 | 2208.55 | 2214.36 | 159982.0 |
| 2015-04-29 13:00:00 | ES | Futures | 2214.36 | 2220.7 | 2210.4 | 2219.12 | 111313.0 |
| 2015-04-29 14:00:00 | ES | Futures | 2219.12 | 2226.78 | 2213.57 | 2221.49 | 281270.0 |
| 2015-04-29 15:00:00 | ES | Futures | 2221.76 | 2223.08 | 2215.68 | 2218.59 | 193928.0 |
| 2015-04-29 16:00:00 | ES | Futures | 2218.59 | 2219.65 | 2215.95 | 2216.74 | 75668.0 |
| 2015-04-29 17:00:00 | ES | Futures | 2216.74 | 2216.74 | 2216.21 | 2216.48 | 1202.0 |
| 2015-04-29 18:00:00 | ES | Futures | 2216.74 | 2217.53 | 2215.68 | 2215.95 | 3070.0 |
| 2015-04-29 19:00:00 | ES | Futures | 2215.95 | 2216.74 | 2215.16 | 2215.42 | 2028.0 |
| 2015-04-29 20:00:00 | ES | Futures | 2215.42 | 2219.91 | 2215.16 | 2218.85 | 7760.0 |
| 2015-04-29 21:00:00 | ES | Futures | 2218.85 | 2220.7 | 2216.21 | 2216.74 | 6799.0 |
| 2015-04-29 22:00:00 | ES | Futures | 2216.74 | 2217.53 | 2215.95 | 2216.48 | 2708.0 |
| 2015-04-29 23:00:00 | ES | Futures | 2216.21 | 2217.53 | 2216.21 | 2217.27 | 1774.0 |
| 2015-04-29 00:00:00 | NQ | Futures | 5302.85 | 5303.14 | 5299.91 | 5300.5 | 178.0 |
| 2015-04-29 01:00:00 | NQ | Futures | 5300.2 | 5301.97 | 5298.14 | 5299.61 | 359.0 |
| 2015-04-29 02:00:00 | NQ | Futures | 5299.61 | 5303.14 | 5298.44 | 5300.2 | 886.0 |
| 2015-04-29 03:00:00 | NQ | Futures | 5300.5 | 5302.85 | 5293.44 | 5301.38 | 3499.0 |
| 2015-04-29 04:00:00 | NQ | Futures | 5301.08 | 5307.55 | 5300.5 | 5302.85 | 1654.0 |
| 2015-04-29 05:00:00 | NQ | Futures | 5302.85 | 5305.49 | 5299.91 | 5301.97 | 1730.0 |
| 2015-04-29 06:00:00 | NQ | Futures | 5301.67 | 5303.73 | 5300.5 | 5301.67 | 1261.0 |
| 2015-04-29 07:00:00 | NQ | Futures | 5301.67 | 5302.55 | 5292.85 | 5296.67 | 3115.0 |
| 2015-04-29 08:00:00 | NQ | Futures | 5296.67 | 5300.79 | 5276.68 | 5281.09 | 12700.0 |
| 2015-04-29 09:00:00 | NQ | Futures | 5280.5 | 5306.08 | 5268.74 | 5293.73 | 50351.0 |
| 2015-04-29 10:00:00 | NQ | Futures | 5293.14 | 5298.73 | 5271.38 | 5278.44 | 45933.0 |
| 2015-04-29 11:00:00 | NQ | Futures | 5278.44 | 5290.5 | 5271.38 | 5273.74 | 20671.0 |
| 2015-04-29 12:00:00 | NQ | Futures | 5273.44 | 5275.5 | 5241.68 | 5256.68 | 33757.0 |
| 2015-04-29 13:00:00 | NQ | Futures | 5256.97 | 5279.32 | 5248.15 | 5275.21 | 17294.0 |
| 2015-04-29 14:00:00 | NQ | Futures | 5275.21 | 5294.32 | 5256.39 | 5284.32 | 54660.0 |
| 2015-04-29 15:00:00 | NQ | Futures | 5284.32 | 5286.97 | 5266.09 | 5270.5 | 33600.0 |
| 2015-04-29 16:00:00 | NQ | Futures | 5270.79 | 5271.09 | 5261.38 | 5262.86 | 7341.0 |
| 2015-04-29 17:00:00 | NQ | Futures | 5262.56 | 5263.15 | 5261.09 | 5261.38 | 142.0 |
| 2015-04-29 18:00:00 | NQ | Futures | 5262.56 | 5264.33 | 5258.44 | 5259.33 | 531.0 |
| 2015-04-29 19:00:00 | NQ | Futures | 5259.33 | 5260.8 | 5255.8 | 5256.68 | 551.0 |
| 2015-04-29 20:00:00 | NQ | Futures | 5256.97 | 5266.09 | 5256.97 | 5264.03 | 1350.0 |
| 2015-04-29 21:00:00 | NQ | Futures | 5264.03 | 5267.56 | 5256.68 | 5258.15 | 1088.0 |
| 2015-04-29 22:00:00 | NQ | Futures | 5257.56 | 5260.21 | 5256.68 | 5257.56 | 360.0 |
| 2015-04-29 23:00:00 | NQ | Futures | 5257.56 | 5260.5 | 5257.56 | 5259.91 | 204.0 |
| 2015-04-29 00:00:00 | YM | Futures | 18919.0 | 18919.0 | 18911.7 | 18912.7 | 202.0 |
| 2015-04-29 01:00:00 | YM | Futures | 18912.7 | 18919.0 | 18908.5 | 18912.7 | 284.0 |
> showing 50 of 1,616 rows — these rows as CSV