PREVIEW / futures_1hour / 2015-11-18
file: by_date/futures_1hour/2015/2015-11-18.parquet size: 52 KB rows: 1,600
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-18 00:00:00 | ES | Futures | 2191.99 | 2192.52 | 2189.04 | 2190.65 | 4005.0 |
| 2015-11-18 01:00:00 | ES | Futures | 2190.65 | 2191.19 | 2189.85 | 2190.38 | 2166.0 |
| 2015-11-18 02:00:00 | ES | Futures | 2190.38 | 2191.99 | 2189.04 | 2190.11 | 7659.0 |
| 2015-11-18 03:00:00 | ES | Futures | 2190.11 | 2191.45 | 2187.44 | 2189.58 | 22596.0 |
| 2015-11-18 04:00:00 | ES | Futures | 2189.31 | 2191.19 | 2187.71 | 2189.58 | 11420.0 |
| 2015-11-18 05:00:00 | ES | Futures | 2189.58 | 2189.85 | 2186.64 | 2187.97 | 13633.0 |
| 2015-11-18 06:00:00 | ES | Futures | 2188.24 | 2196.54 | 2188.24 | 2196.54 | 17641.0 |
| 2015-11-18 07:00:00 | ES | Futures | 2196.8 | 2198.41 | 2194.4 | 2195.2 | 19437.0 |
| 2015-11-18 08:00:00 | ES | Futures | 2195.47 | 2201.35 | 2194.66 | 2200.55 | 39423.0 |
| 2015-11-18 09:00:00 | ES | Futures | 2200.55 | 2205.37 | 2197.07 | 2202.42 | 207000.0 |
| 2015-11-18 10:00:00 | ES | Futures | 2202.69 | 2205.1 | 2198.41 | 2202.69 | 210806.0 |
| 2015-11-18 11:00:00 | ES | Futures | 2202.96 | 2210.45 | 2199.75 | 2207.51 | 180588.0 |
| 2015-11-18 12:00:00 | ES | Futures | 2207.51 | 2210.18 | 2204.3 | 2207.51 | 106635.0 |
| 2015-11-18 13:00:00 | ES | Futures | 2207.24 | 2211.25 | 2206.7 | 2206.97 | 87925.0 |
| 2015-11-18 14:00:00 | ES | Futures | 2206.97 | 2219.82 | 2205.1 | 2219.55 | 216238.0 |
| 2015-11-18 15:00:00 | ES | Futures | 2219.28 | 2228.91 | 2216.6 | 2226.77 | 269004.0 |
| 2015-11-18 16:00:00 | ES | Futures | 2226.51 | 2227.84 | 2224.63 | 2224.63 | 89344.0 |
| 2015-11-18 18:00:00 | ES | Futures | 2224.36 | 2228.11 | 2223.83 | 2227.84 | 5411.0 |
| 2015-11-18 19:00:00 | ES | Futures | 2227.58 | 2230.25 | 2225.97 | 2228.91 | 7524.0 |
| 2015-11-18 20:00:00 | ES | Futures | 2228.91 | 2231.59 | 2227.84 | 2230.52 | 5751.0 |
| 2015-11-18 21:00:00 | ES | Futures | 2230.25 | 2231.05 | 2228.11 | 2228.38 | 3533.0 |
| 2015-11-18 22:00:00 | ES | Futures | 2228.65 | 2229.72 | 2226.51 | 2228.11 | 4818.0 |
| 2015-11-18 23:00:00 | ES | Futures | 2228.11 | 2229.18 | 2226.77 | 2228.91 | 2956.0 |
| 2015-11-18 00:00:00 | NQ | Futures | 5413.63 | 5415.71 | 5407.7 | 5410.07 | 649.0 |
| 2015-11-18 01:00:00 | NQ | Futures | 5409.48 | 5411.85 | 5407.7 | 5408.59 | 347.0 |
| 2015-11-18 02:00:00 | NQ | Futures | 5408.59 | 5414.52 | 5406.81 | 5410.66 | 1622.0 |
| 2015-11-18 03:00:00 | NQ | Futures | 5410.66 | 5413.63 | 5403.55 | 5409.48 | 3574.0 |
| 2015-11-18 04:00:00 | NQ | Futures | 5409.48 | 5415.11 | 5405.92 | 5411.85 | 1900.0 |
| 2015-11-18 05:00:00 | NQ | Futures | 5411.85 | 5411.85 | 5405.03 | 5407.7 | 1587.0 |
| 2015-11-18 06:00:00 | NQ | Futures | 5408.89 | 5427.27 | 5408.29 | 5426.97 | 3504.0 |
| 2015-11-18 07:00:00 | NQ | Futures | 5426.97 | 5433.49 | 5426.08 | 5429.05 | 3666.0 |
| 2015-11-18 08:00:00 | NQ | Futures | 5429.05 | 5443.28 | 5428.45 | 5441.8 | 5825.0 |
| 2015-11-18 09:00:00 | NQ | Futures | 5442.09 | 5453.66 | 5430.23 | 5445.65 | 33023.0 |
| 2015-11-18 10:00:00 | NQ | Futures | 5445.65 | 5457.21 | 5441.8 | 5453.36 | 31864.0 |
| 2015-11-18 11:00:00 | NQ | Futures | 5453.36 | 5472.93 | 5445.35 | 5467.59 | 26907.0 |
| 2015-11-18 12:00:00 | NQ | Futures | 5467.89 | 5473.82 | 5459.59 | 5464.63 | 16714.0 |
| 2015-11-18 13:00:00 | NQ | Futures | 5464.92 | 5477.67 | 5463.74 | 5472.63 | 15212.0 |
| 2015-11-18 14:00:00 | NQ | Futures | 5472.63 | 5500.8 | 5465.81 | 5500.5 | 41108.0 |
| 2015-11-18 15:00:00 | NQ | Futures | 5499.91 | 5522.74 | 5489.53 | 5517.1 | 39920.0 |
| 2015-11-18 16:00:00 | NQ | Futures | 5517.4 | 5521.85 | 5515.62 | 5515.62 | 9149.0 |
| 2015-11-18 18:00:00 | NQ | Futures | 5514.44 | 5523.63 | 5511.77 | 5522.74 | 1303.0 |
| 2015-11-18 19:00:00 | NQ | Futures | 5521.85 | 5529.26 | 5518.88 | 5526.59 | 1622.0 |
| 2015-11-18 20:00:00 | NQ | Futures | 5526.59 | 5533.12 | 5524.81 | 5530.15 | 1158.0 |
| 2015-11-18 21:00:00 | NQ | Futures | 5530.15 | 5530.45 | 5522.44 | 5523.03 | 1018.0 |
| 2015-11-18 22:00:00 | NQ | Futures | 5523.03 | 5526.0 | 5516.22 | 5520.37 | 1250.0 |
| 2015-11-18 23:00:00 | NQ | Futures | 5520.37 | 5523.92 | 5517.7 | 5523.33 | 611.0 |
| 2015-11-18 00:00:00 | YM | Futures | 18480.8 | 18486.1 | 18458.5 | 18472.3 | 819.0 |
| 2015-11-18 01:00:00 | YM | Futures | 18470.2 | 18478.7 | 18463.8 | 18467.0 | 424.0 |
| 2015-11-18 02:00:00 | YM | Futures | 18467.0 | 18481.9 | 18457.5 | 18466.0 | 835.0 |
| 2015-11-18 03:00:00 | YM | Futures | 18466.0 | 18478.7 | 18446.9 | 18464.9 | 3130.0 |
> showing 50 of 1,600 rows — these rows as CSV