PREVIEW / futures_1hour / 2015-11-19
file: by_date/futures_1hour/2015/2015-11-19.parquet size: 51 KB rows: 1,588
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-19 00:00:00 | ES | Futures | 2228.91 | 2230.25 | 2228.38 | 2229.18 | 3554.0 |
| 2015-11-19 01:00:00 | ES | Futures | 2229.45 | 2229.72 | 2227.84 | 2229.45 | 3247.0 |
| 2015-11-19 02:00:00 | ES | Futures | 2229.45 | 2233.19 | 2228.65 | 2232.93 | 12840.0 |
| 2015-11-19 03:00:00 | ES | Futures | 2233.19 | 2234.53 | 2230.52 | 2231.59 | 29498.0 |
| 2015-11-19 04:00:00 | ES | Futures | 2231.32 | 2234.8 | 2230.52 | 2234.53 | 14476.0 |
| 2015-11-19 05:00:00 | ES | Futures | 2234.53 | 2235.07 | 2232.93 | 2233.73 | 12545.0 |
| 2015-11-19 06:00:00 | ES | Futures | 2233.73 | 2236.14 | 2233.46 | 2233.73 | 17903.0 |
| 2015-11-19 07:00:00 | ES | Futures | 2234.0 | 2234.53 | 2230.25 | 2230.79 | 23004.0 |
| 2015-11-19 08:00:00 | ES | Futures | 2230.79 | 2232.66 | 2227.31 | 2228.11 | 43187.0 |
| 2015-11-19 09:00:00 | ES | Futures | 2228.11 | 2230.25 | 2223.03 | 2228.11 | 230153.0 |
| 2015-11-19 10:00:00 | ES | Futures | 2228.11 | 2230.25 | 2222.22 | 2225.43 | 272124.0 |
| 2015-11-19 11:00:00 | ES | Futures | 2225.17 | 2228.65 | 2221.15 | 2222.22 | 150882.0 |
| 2015-11-19 12:00:00 | ES | Futures | 2222.22 | 2228.65 | 2222.22 | 2228.38 | 100868.0 |
| 2015-11-19 13:00:00 | ES | Futures | 2228.38 | 2229.72 | 2225.7 | 2225.97 | 83098.0 |
| 2015-11-19 14:00:00 | ES | Futures | 2226.24 | 2227.31 | 2223.03 | 2225.7 | 86061.0 |
| 2015-11-19 15:00:00 | ES | Futures | 2225.7 | 2227.84 | 2223.03 | 2224.63 | 128544.0 |
| 2015-11-19 16:00:00 | ES | Futures | 2224.9 | 2226.51 | 2224.36 | 2225.43 | 39298.0 |
| 2015-11-19 18:00:00 | ES | Futures | 2224.36 | 2224.36 | 2221.96 | 2223.03 | 4091.0 |
| 2015-11-19 19:00:00 | ES | Futures | 2223.03 | 2223.56 | 2221.96 | 2223.03 | 3493.0 |
| 2015-11-19 20:00:00 | ES | Futures | 2223.03 | 2224.1 | 2222.22 | 2223.03 | 2200.0 |
| 2015-11-19 21:00:00 | ES | Futures | 2223.29 | 2223.83 | 2223.03 | 2223.03 | 1578.0 |
| 2015-11-19 22:00:00 | ES | Futures | 2223.29 | 2224.1 | 2222.76 | 2224.1 | 1533.0 |
| 2015-11-19 23:00:00 | ES | Futures | 2223.83 | 2224.9 | 2223.83 | 2224.1 | 1288.0 |
| 2015-11-19 00:00:00 | NQ | Futures | 5523.33 | 5526.3 | 5520.96 | 5523.63 | 583.0 |
| 2015-11-19 01:00:00 | NQ | Futures | 5523.92 | 5523.92 | 5520.37 | 5523.33 | 595.0 |
| 2015-11-19 02:00:00 | NQ | Futures | 5523.03 | 5532.23 | 5520.96 | 5531.34 | 1471.0 |
| 2015-11-19 03:00:00 | NQ | Futures | 5531.63 | 5537.56 | 5526.3 | 5531.34 | 3406.0 |
| 2015-11-19 04:00:00 | NQ | Futures | 5531.63 | 5539.64 | 5528.96 | 5539.64 | 2070.0 |
| 2015-11-19 05:00:00 | NQ | Futures | 5539.34 | 5540.53 | 5535.49 | 5537.56 | 1914.0 |
| 2015-11-19 06:00:00 | NQ | Futures | 5537.56 | 5543.2 | 5535.78 | 5537.56 | 2152.0 |
| 2015-11-19 07:00:00 | NQ | Futures | 5537.86 | 5539.93 | 5533.41 | 5534.0 | 3156.0 |
| 2015-11-19 08:00:00 | NQ | Futures | 5534.3 | 5536.67 | 5522.74 | 5524.52 | 6495.0 |
| 2015-11-19 09:00:00 | NQ | Futures | 5524.81 | 5531.93 | 5510.88 | 5527.48 | 34852.0 |
| 2015-11-19 10:00:00 | NQ | Futures | 5527.78 | 5534.89 | 5513.55 | 5525.7 | 42683.0 |
| 2015-11-19 11:00:00 | NQ | Futures | 5525.41 | 5537.86 | 5518.88 | 5524.52 | 27325.0 |
| 2015-11-19 12:00:00 | NQ | Futures | 5524.52 | 5542.6 | 5523.92 | 5541.71 | 18524.0 |
| 2015-11-19 13:00:00 | NQ | Futures | 5541.71 | 5546.75 | 5534.0 | 5534.3 | 16350.0 |
| 2015-11-19 14:00:00 | NQ | Futures | 5534.6 | 5535.49 | 5522.74 | 5524.52 | 15856.0 |
| 2015-11-19 15:00:00 | NQ | Futures | 5524.81 | 5533.12 | 5517.4 | 5520.37 | 23101.0 |
| 2015-11-19 16:00:00 | NQ | Futures | 5520.66 | 5529.26 | 5520.37 | 5526.89 | 4480.0 |
| 2015-11-19 18:00:00 | NQ | Futures | 5522.74 | 5522.74 | 5517.4 | 5520.37 | 896.0 |
| 2015-11-19 19:00:00 | NQ | Futures | 5520.66 | 5521.55 | 5517.7 | 5520.37 | 504.0 |
| 2015-11-19 20:00:00 | NQ | Futures | 5520.37 | 5522.74 | 5517.7 | 5520.07 | 321.0 |
| 2015-11-19 21:00:00 | NQ | Futures | 5520.07 | 5521.85 | 5519.48 | 5519.77 | 110.0 |
| 2015-11-19 22:00:00 | NQ | Futures | 5520.07 | 5523.03 | 5519.18 | 5522.74 | 193.0 |
| 2015-11-19 23:00:00 | NQ | Futures | 5522.74 | 5524.52 | 5521.85 | 5522.44 | 318.0 |
| 2015-11-19 00:00:00 | YM | Futures | 18772.1 | 18781.6 | 18766.8 | 18773.1 | 496.0 |
| 2015-11-19 01:00:00 | YM | Futures | 18772.1 | 18777.4 | 18763.6 | 18772.1 | 481.0 |
| 2015-11-19 02:00:00 | YM | Futures | 18771.0 | 18801.7 | 18764.7 | 18801.7 | 2077.0 |
| 2015-11-19 03:00:00 | YM | Futures | 18801.7 | 18815.5 | 18783.7 | 18791.2 | 3115.0 |
> showing 50 of 1,588 rows — these rows as CSV