PREVIEW / futures_1hour / 2015-11-12
file: by_date/futures_1hour/2015/2015-11-12.parquet size: 52 KB rows: 1,597
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-12 00:00:00 | ES | Futures | 2219.55 | 2220.62 | 2219.01 | 2220.62 | 2104.0 |
| 2015-11-12 01:00:00 | ES | Futures | 2220.35 | 2220.62 | 2218.21 | 2219.01 | 3654.0 |
| 2015-11-12 02:00:00 | ES | Futures | 2219.01 | 2221.15 | 2217.68 | 2219.82 | 7638.0 |
| 2015-11-12 03:00:00 | ES | Futures | 2219.82 | 2223.56 | 2214.73 | 2219.55 | 28061.0 |
| 2015-11-12 04:00:00 | ES | Futures | 2219.28 | 2220.08 | 2214.2 | 2215.8 | 18522.0 |
| 2015-11-12 05:00:00 | ES | Futures | 2215.8 | 2215.8 | 2210.72 | 2211.52 | 16478.0 |
| 2015-11-12 06:00:00 | ES | Futures | 2211.79 | 2216.34 | 2210.45 | 2214.73 | 13804.0 |
| 2015-11-12 07:00:00 | ES | Futures | 2214.73 | 2216.07 | 2210.72 | 2210.99 | 13170.0 |
| 2015-11-12 08:00:00 | ES | Futures | 2210.99 | 2211.52 | 2206.44 | 2208.85 | 49806.0 |
| 2015-11-12 09:00:00 | ES | Futures | 2208.58 | 2208.85 | 2198.14 | 2202.42 | 288438.0 |
| 2015-11-12 10:00:00 | ES | Futures | 2202.42 | 2207.24 | 2197.61 | 2206.44 | 299728.0 |
| 2015-11-12 11:00:00 | ES | Futures | 2206.7 | 2208.58 | 2197.87 | 2200.82 | 229640.0 |
| 2015-11-12 12:00:00 | ES | Futures | 2200.82 | 2202.16 | 2193.06 | 2198.14 | 164281.0 |
| 2015-11-12 13:00:00 | ES | Futures | 2198.41 | 2202.16 | 2196.54 | 2199.48 | 110079.0 |
| 2015-11-12 14:00:00 | ES | Futures | 2199.48 | 2200.28 | 2189.31 | 2192.26 | 157301.0 |
| 2015-11-12 15:00:00 | ES | Futures | 2191.99 | 2194.13 | 2184.5 | 2185.03 | 272986.0 |
| 2015-11-12 16:00:00 | ES | Futures | 2185.03 | 2186.9 | 2182.89 | 2183.96 | 92896.0 |
| 2015-11-12 18:00:00 | ES | Futures | 2183.96 | 2186.64 | 2181.55 | 2186.37 | 7699.0 |
| 2015-11-12 19:00:00 | ES | Futures | 2186.37 | 2187.97 | 2185.03 | 2185.57 | 5740.0 |
| 2015-11-12 20:00:00 | ES | Futures | 2185.3 | 2189.04 | 2185.3 | 2188.51 | 9702.0 |
| 2015-11-12 21:00:00 | ES | Futures | 2188.51 | 2188.78 | 2186.37 | 2187.17 | 4080.0 |
| 2015-11-12 22:00:00 | ES | Futures | 2187.44 | 2188.51 | 2185.3 | 2185.83 | 3905.0 |
| 2015-11-12 23:00:00 | ES | Futures | 2185.83 | 2186.64 | 2183.69 | 2185.03 | 3355.0 |
| 2015-11-12 00:00:00 | NQ | Futures | 5508.8 | 5511.47 | 5507.91 | 5511.47 | 474.0 |
| 2015-11-12 01:00:00 | NQ | Futures | 5511.77 | 5512.36 | 5505.84 | 5507.02 | 447.0 |
| 2015-11-12 02:00:00 | NQ | Futures | 5507.62 | 5512.66 | 5502.87 | 5509.1 | 1160.0 |
| 2015-11-12 03:00:00 | NQ | Futures | 5508.8 | 5518.59 | 5493.98 | 5507.02 | 4562.0 |
| 2015-11-12 04:00:00 | NQ | Futures | 5507.62 | 5508.51 | 5493.39 | 5498.72 | 3003.0 |
| 2015-11-12 05:00:00 | NQ | Futures | 5498.43 | 5498.43 | 5484.19 | 5485.08 | 3641.0 |
| 2015-11-12 06:00:00 | NQ | Futures | 5485.68 | 5496.94 | 5483.01 | 5492.79 | 1822.0 |
| 2015-11-12 07:00:00 | NQ | Futures | 5492.79 | 5495.76 | 5483.3 | 5483.9 | 1857.0 |
| 2015-11-12 08:00:00 | NQ | Futures | 5484.19 | 5485.08 | 5473.82 | 5482.12 | 6498.0 |
| 2015-11-12 09:00:00 | NQ | Futures | 5482.12 | 5483.3 | 5460.48 | 5481.82 | 47679.0 |
| 2015-11-12 10:00:00 | NQ | Futures | 5481.23 | 5495.76 | 5470.85 | 5493.98 | 48230.0 |
| 2015-11-12 11:00:00 | NQ | Futures | 5494.57 | 5499.61 | 5473.82 | 5483.3 | 31111.0 |
| 2015-11-12 12:00:00 | NQ | Futures | 5483.6 | 5486.27 | 5467.0 | 5480.64 | 22376.0 |
| 2015-11-12 13:00:00 | NQ | Futures | 5480.64 | 5489.83 | 5474.11 | 5479.75 | 14091.0 |
| 2015-11-12 14:00:00 | NQ | Futures | 5479.45 | 5481.23 | 5452.77 | 5458.99 | 22589.0 |
| 2015-11-12 15:00:00 | NQ | Futures | 5458.7 | 5466.11 | 5437.94 | 5440.31 | 41698.0 |
| 2015-11-12 16:00:00 | NQ | Futures | 5440.61 | 5446.24 | 5433.2 | 5435.57 | 8604.0 |
| 2015-11-12 18:00:00 | NQ | Futures | 5436.16 | 5440.02 | 5427.56 | 5439.72 | 1613.0 |
| 2015-11-12 19:00:00 | NQ | Futures | 5439.13 | 5442.69 | 5435.57 | 5435.87 | 973.0 |
| 2015-11-12 20:00:00 | NQ | Futures | 5436.46 | 5444.17 | 5436.46 | 5442.69 | 1308.0 |
| 2015-11-12 21:00:00 | NQ | Futures | 5442.09 | 5443.58 | 5436.76 | 5438.83 | 491.0 |
| 2015-11-12 22:00:00 | NQ | Futures | 5439.13 | 5441.5 | 5433.2 | 5434.09 | 604.0 |
| 2015-11-12 23:00:00 | NQ | Futures | 5434.09 | 5436.46 | 5430.23 | 5433.2 | 653.0 |
| 2015-11-12 00:00:00 | YM | Futures | 18737.1 | 18746.7 | 18735.0 | 18746.7 | 348.0 |
| 2015-11-12 01:00:00 | YM | Futures | 18745.6 | 18748.8 | 18731.8 | 18735.0 | 589.0 |
| 2015-11-12 02:00:00 | YM | Futures | 18735.0 | 18747.7 | 18722.3 | 18738.2 | 1205.0 |
| 2015-11-12 03:00:00 | YM | Futures | 18738.2 | 18764.7 | 18692.6 | 18731.8 | 5382.0 |
> showing 50 of 1,597 rows — these rows as CSV