PREVIEW / futures_1hour / 2015-12-28
file: by_date/futures_1hour/2015/2015-12-28.parquet size: 46 KB rows: 1,443
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-12-28 00:00:00 | ES | Futures | 2205.56 | 2205.83 | 2201.53 | 2202.61 | 3942.0 |
| 2015-12-28 01:00:00 | ES | Futures | 2202.61 | 2203.68 | 2202.07 | 2202.61 | 1431.0 |
| 2015-12-28 02:00:00 | ES | Futures | 2202.61 | 2205.3 | 2201.8 | 2202.88 | 5393.0 |
| 2015-12-28 03:00:00 | ES | Futures | 2202.88 | 2203.68 | 2199.65 | 2200.19 | 8795.0 |
| 2015-12-28 04:00:00 | ES | Futures | 2199.92 | 2201.0 | 2198.58 | 2199.38 | 6648.0 |
| 2015-12-28 05:00:00 | ES | Futures | 2199.11 | 2199.38 | 2196.97 | 2198.04 | 5883.0 |
| 2015-12-28 06:00:00 | ES | Futures | 2198.31 | 2198.58 | 2196.16 | 2196.97 | 5097.0 |
| 2015-12-28 07:00:00 | ES | Futures | 2196.97 | 2197.5 | 2192.93 | 2194.28 | 14212.0 |
| 2015-12-28 08:00:00 | ES | Futures | 2194.55 | 2197.23 | 2193.74 | 2195.89 | 11168.0 |
| 2015-12-28 09:00:00 | ES | Futures | 2196.16 | 2199.92 | 2194.01 | 2196.43 | 82486.0 |
| 2015-12-28 10:00:00 | ES | Futures | 2196.43 | 2196.43 | 2187.56 | 2188.64 | 128793.0 |
| 2015-12-28 11:00:00 | ES | Futures | 2188.64 | 2195.62 | 2188.1 | 2192.93 | 77439.0 |
| 2015-12-28 12:00:00 | ES | Futures | 2192.93 | 2195.62 | 2191.59 | 2192.93 | 55359.0 |
| 2015-12-28 13:00:00 | ES | Futures | 2193.2 | 2201.8 | 2192.93 | 2195.89 | 78275.0 |
| 2015-12-28 14:00:00 | ES | Futures | 2196.16 | 2199.92 | 2195.35 | 2199.11 | 52251.0 |
| 2015-12-28 15:00:00 | ES | Futures | 2199.11 | 2201.53 | 2196.7 | 2201.0 | 103268.0 |
| 2015-12-28 16:00:00 | ES | Futures | 2201.0 | 2204.76 | 2199.92 | 2203.41 | 40311.0 |
| 2015-12-28 18:00:00 | ES | Futures | 2203.15 | 2203.95 | 2201.8 | 2202.07 | 2165.0 |
| 2015-12-28 19:00:00 | ES | Futures | 2202.34 | 2202.88 | 2200.73 | 2202.07 | 2766.0 |
| 2015-12-28 20:00:00 | ES | Futures | 2202.07 | 2203.95 | 2202.07 | 2202.61 | 2734.0 |
| 2015-12-28 21:00:00 | ES | Futures | 2202.61 | 2203.95 | 2201.26 | 2203.68 | 1773.0 |
| 2015-12-28 22:00:00 | ES | Futures | 2203.68 | 2205.03 | 2202.88 | 2205.03 | 1866.0 |
| 2015-12-28 23:00:00 | ES | Futures | 2204.76 | 2206.1 | 2204.76 | 2205.56 | 1613.0 |
| 2015-12-28 00:00:00 | NQ | Futures | 5483.73 | 5484.02 | 5474.52 | 5474.82 | 813.0 |
| 2015-12-28 01:00:00 | NQ | Futures | 5474.82 | 5478.09 | 5473.93 | 5475.41 | 243.0 |
| 2015-12-28 02:00:00 | NQ | Futures | 5475.71 | 5481.95 | 5472.44 | 5475.41 | 924.0 |
| 2015-12-28 03:00:00 | NQ | Futures | 5475.71 | 5477.2 | 5468.58 | 5468.88 | 1893.0 |
| 2015-12-28 04:00:00 | NQ | Futures | 5468.58 | 5471.26 | 5465.32 | 5467.1 | 1057.0 |
| 2015-12-28 05:00:00 | NQ | Futures | 5466.8 | 5467.1 | 5462.94 | 5465.02 | 1057.0 |
| 2015-12-28 06:00:00 | NQ | Futures | 5465.32 | 5466.21 | 5459.38 | 5463.24 | 1146.0 |
| 2015-12-28 07:00:00 | NQ | Futures | 5463.54 | 5463.54 | 5454.63 | 5459.38 | 2197.0 |
| 2015-12-28 08:00:00 | NQ | Futures | 5459.68 | 5466.21 | 5457.9 | 5465.02 | 2048.0 |
| 2015-12-28 09:00:00 | NQ | Futures | 5465.02 | 5472.44 | 5459.97 | 5463.54 | 13983.0 |
| 2015-12-28 10:00:00 | NQ | Futures | 5463.54 | 5464.43 | 5429.69 | 5433.25 | 23106.0 |
| 2015-12-28 11:00:00 | NQ | Futures | 5432.95 | 5457.6 | 5430.87 | 5451.07 | 14235.0 |
| 2015-12-28 12:00:00 | NQ | Futures | 5451.66 | 5456.71 | 5444.53 | 5452.85 | 8763.0 |
| 2015-12-28 13:00:00 | NQ | Futures | 5453.14 | 5474.52 | 5452.25 | 5462.94 | 12128.0 |
| 2015-12-28 14:00:00 | NQ | Futures | 5463.24 | 5473.04 | 5462.05 | 5470.37 | 7851.0 |
| 2015-12-28 15:00:00 | NQ | Futures | 5470.37 | 5481.06 | 5464.72 | 5479.27 | 12989.0 |
| 2015-12-28 16:00:00 | NQ | Futures | 5479.27 | 5486.7 | 5474.52 | 5484.92 | 5199.0 |
| 2015-12-28 18:00:00 | NQ | Futures | 5484.62 | 5486.4 | 5479.57 | 5481.65 | 268.0 |
| 2015-12-28 19:00:00 | NQ | Futures | 5481.06 | 5481.95 | 5476.01 | 5479.87 | 619.0 |
| 2015-12-28 20:00:00 | NQ | Futures | 5480.16 | 5484.02 | 5479.57 | 5481.35 | 437.0 |
| 2015-12-28 21:00:00 | NQ | Futures | 5481.65 | 5485.21 | 5478.38 | 5485.21 | 285.0 |
| 2015-12-28 22:00:00 | NQ | Futures | 5484.62 | 5487.29 | 5482.54 | 5487.29 | 266.0 |
| 2015-12-28 23:00:00 | NQ | Futures | 5487.59 | 5491.45 | 5487.59 | 5489.07 | 488.0 |
| 2015-12-28 00:00:00 | YM | Futures | 18585.8 | 18587.9 | 18552.8 | 18559.2 | 1149.0 |
| 2015-12-28 01:00:00 | YM | Futures | 18560.2 | 18570.9 | 18557.0 | 18563.4 | 348.0 |
| 2015-12-28 02:00:00 | YM | Futures | 18564.5 | 18581.5 | 18558.1 | 18563.4 | 942.0 |
| 2015-12-28 03:00:00 | YM | Futures | 18563.4 | 18567.7 | 18527.2 | 18536.8 | 2201.0 |
> showing 50 of 1,443 rows — these rows as CSV