PREVIEW / futures_1hour / 2015-05-19
file: by_date/futures_1hour/2015/2015-05-19.parquet size: 52 KB rows: 1,575
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-19 00:00:00 | ES | Futures | 2248.7 | 2248.96 | 2247.91 | 2248.7 | 965.0 |
| 2015-05-19 01:00:00 | ES | Futures | 2248.7 | 2248.96 | 2247.91 | 2247.91 | 1629.0 |
| 2015-05-19 02:00:00 | ES | Futures | 2248.17 | 2249.23 | 2247.38 | 2248.43 | 9537.0 |
| 2015-05-19 03:00:00 | ES | Futures | 2248.7 | 2254.51 | 2248.43 | 2252.13 | 48898.0 |
| 2015-05-19 04:00:00 | ES | Futures | 2252.13 | 2252.92 | 2251.08 | 2252.4 | 13308.0 |
| 2015-05-19 05:00:00 | ES | Futures | 2252.13 | 2253.19 | 2251.6 | 2252.13 | 13205.0 |
| 2015-05-19 06:00:00 | ES | Futures | 2252.4 | 2252.92 | 2251.34 | 2251.6 | 9047.0 |
| 2015-05-19 07:00:00 | ES | Futures | 2251.87 | 2252.13 | 2250.02 | 2251.34 | 13038.0 |
| 2015-05-19 08:00:00 | ES | Futures | 2251.6 | 2252.4 | 2247.38 | 2248.7 | 28795.0 |
| 2015-05-19 09:00:00 | ES | Futures | 2248.7 | 2249.23 | 2242.1 | 2245.0 | 188490.0 |
| 2015-05-19 10:00:00 | ES | Futures | 2245.27 | 2247.64 | 2242.89 | 2245.27 | 145812.0 |
| 2015-05-19 11:00:00 | ES | Futures | 2245.53 | 2248.43 | 2243.68 | 2246.59 | 104812.0 |
| 2015-05-19 12:00:00 | ES | Futures | 2246.59 | 2247.64 | 2245.27 | 2246.59 | 44690.0 |
| 2015-05-19 13:00:00 | ES | Futures | 2246.85 | 2250.55 | 2246.06 | 2249.49 | 56439.0 |
| 2015-05-19 14:00:00 | ES | Futures | 2249.49 | 2249.76 | 2244.21 | 2246.32 | 64765.0 |
| 2015-05-19 15:00:00 | ES | Futures | 2246.59 | 2246.59 | 2241.04 | 2244.74 | 182156.0 |
| 2015-05-19 16:00:00 | ES | Futures | 2244.74 | 2245.0 | 2243.42 | 2244.21 | 53083.0 |
| 2015-05-19 17:00:00 | ES | Futures | 2243.94 | 2244.21 | 2243.68 | 2243.94 | 1237.0 |
| 2015-05-19 18:00:00 | ES | Futures | 2244.21 | 2244.74 | 2243.68 | 2244.47 | 1613.0 |
| 2015-05-19 19:00:00 | ES | Futures | 2244.74 | 2244.74 | 2243.68 | 2244.21 | 1021.0 |
| 2015-05-19 20:00:00 | ES | Futures | 2244.21 | 2244.47 | 2242.1 | 2244.47 | 6515.0 |
| 2015-05-19 21:00:00 | ES | Futures | 2244.21 | 2245.0 | 2241.83 | 2242.62 | 4722.0 |
| 2015-05-19 22:00:00 | ES | Futures | 2242.62 | 2243.68 | 2241.57 | 2243.42 | 4782.0 |
| 2015-05-19 23:00:00 | ES | Futures | 2243.15 | 2243.94 | 2243.15 | 2243.42 | 1446.0 |
| 2015-05-19 00:00:00 | NQ | Futures | 5309.02 | 5309.61 | 5307.55 | 5308.73 | 120.0 |
| 2015-05-19 01:00:00 | NQ | Futures | 5309.32 | 5309.61 | 5308.14 | 5308.14 | 135.0 |
| 2015-05-19 02:00:00 | NQ | Futures | 5308.14 | 5311.67 | 5306.67 | 5309.32 | 991.0 |
| 2015-05-19 03:00:00 | NQ | Futures | 5309.61 | 5324.31 | 5309.61 | 5318.43 | 5189.0 |
| 2015-05-19 04:00:00 | NQ | Futures | 5318.43 | 5322.26 | 5318.43 | 5321.96 | 1832.0 |
| 2015-05-19 05:00:00 | NQ | Futures | 5321.96 | 5323.43 | 5319.02 | 5321.08 | 1642.0 |
| 2015-05-19 06:00:00 | NQ | Futures | 5321.67 | 5323.73 | 5320.49 | 5320.79 | 1571.0 |
| 2015-05-19 07:00:00 | NQ | Futures | 5321.08 | 5322.55 | 5317.55 | 5322.26 | 2096.0 |
| 2015-05-19 08:00:00 | NQ | Futures | 5322.26 | 5324.02 | 5311.08 | 5314.32 | 4761.0 |
| 2015-05-19 09:00:00 | NQ | Futures | 5314.61 | 5317.26 | 5302.55 | 5310.2 | 27948.0 |
| 2015-05-19 10:00:00 | NQ | Futures | 5310.49 | 5314.02 | 5296.38 | 5300.5 | 21391.0 |
| 2015-05-19 11:00:00 | NQ | Futures | 5300.5 | 5305.79 | 5294.91 | 5301.08 | 13563.0 |
| 2015-05-19 12:00:00 | NQ | Futures | 5301.08 | 5304.32 | 5297.26 | 5302.85 | 6173.0 |
| 2015-05-19 13:00:00 | NQ | Futures | 5302.55 | 5310.79 | 5299.32 | 5307.55 | 7236.0 |
| 2015-05-19 14:00:00 | NQ | Futures | 5307.85 | 5310.79 | 5296.97 | 5302.26 | 8429.0 |
| 2015-05-19 15:00:00 | NQ | Futures | 5302.55 | 5302.55 | 5289.03 | 5296.67 | 19792.0 |
| 2015-05-19 16:00:00 | NQ | Futures | 5296.67 | 5297.55 | 5292.26 | 5293.73 | 3222.0 |
| 2015-05-19 17:00:00 | NQ | Futures | 5294.03 | 5294.61 | 5292.85 | 5293.73 | 116.0 |
| 2015-05-19 18:00:00 | NQ | Futures | 5295.2 | 5295.2 | 5291.67 | 5293.73 | 269.0 |
| 2015-05-19 19:00:00 | NQ | Futures | 5294.03 | 5294.32 | 5292.85 | 5292.85 | 131.0 |
| 2015-05-19 20:00:00 | NQ | Futures | 5293.14 | 5296.08 | 5289.32 | 5295.5 | 1007.0 |
| 2015-05-19 21:00:00 | NQ | Futures | 5295.79 | 5296.97 | 5290.5 | 5292.26 | 492.0 |
| 2015-05-19 22:00:00 | NQ | Futures | 5291.97 | 5294.91 | 5289.91 | 5294.61 | 450.0 |
| 2015-05-19 23:00:00 | NQ | Futures | 5294.61 | 5295.5 | 5294.03 | 5294.61 | 180.0 |
| 2015-05-19 00:00:00 | YM | Futures | 19171.7 | 19172.8 | 19166.5 | 19170.7 | 105.0 |
| 2015-05-19 01:00:00 | YM | Futures | 19170.7 | 19171.7 | 19165.4 | 19165.4 | 157.0 |
> showing 50 of 1,575 rows — these rows as CSV