PREVIEW / futures_1hour / 2016-01-24
file: by_date/futures_1hour/2016/2016-01-24.parquet size: 15 KB rows: 289
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 |
|---|---|---|---|---|---|---|---|
| 2016-01-24 18:00:00 | ES | Futures | 2041.65 | 2046.76 | 2040.85 | 2042.19 | 15072.0 |
| 2016-01-24 19:00:00 | ES | Futures | 2042.19 | 2042.46 | 2037.62 | 2039.77 | 15968.0 |
| 2016-01-24 20:00:00 | ES | Futures | 2039.77 | 2041.65 | 2035.47 | 2040.58 | 14866.0 |
| 2016-01-24 21:00:00 | ES | Futures | 2040.58 | 2044.34 | 2038.96 | 2041.92 | 12692.0 |
| 2016-01-24 22:00:00 | ES | Futures | 2041.65 | 2044.61 | 2040.04 | 2041.38 | 7802.0 |
| 2016-01-24 23:00:00 | ES | Futures | 2041.38 | 2044.34 | 2040.58 | 2043.8 | 6607.0 |
| 2016-01-24 18:00:00 | NQ | Futures | 5044.86 | 5059.71 | 5042.19 | 5044.86 | 2881.0 |
| 2016-01-24 19:00:00 | NQ | Futures | 5044.27 | 5044.27 | 5030.91 | 5038.03 | 3684.0 |
| 2016-01-24 20:00:00 | NQ | Futures | 5037.44 | 5042.78 | 5026.16 | 5040.11 | 3319.0 |
| 2016-01-24 21:00:00 | NQ | Futures | 5041.0 | 5047.54 | 5036.25 | 5041.89 | 3027.0 |
| 2016-01-24 22:00:00 | NQ | Futures | 5042.49 | 5048.72 | 5036.85 | 5040.41 | 1422.0 |
| 2016-01-24 23:00:00 | NQ | Futures | 5040.71 | 5049.91 | 5039.52 | 5048.43 | 1291.0 |
| 2016-01-24 18:00:00 | YM | Futures | 17040.2 | 17073.2 | 17028.5 | 17044.4 | 1925.0 |
| 2016-01-24 19:00:00 | YM | Futures | 17045.5 | 17045.5 | 16998.7 | 17016.7 | 2804.0 |
| 2016-01-24 20:00:00 | YM | Futures | 17015.7 | 17031.7 | 16984.8 | 17023.1 | 2765.0 |
| 2016-01-24 21:00:00 | YM | Futures | 17023.1 | 17049.7 | 17009.3 | 17029.5 | 2323.0 |
| 2016-01-24 22:00:00 | YM | Futures | 17031.7 | 17054.0 | 17018.9 | 17030.6 | 1668.0 |
| 2016-01-24 23:00:00 | YM | Futures | 17030.6 | 17056.1 | 17027.4 | 17052.9 | 1362.0 |
| 2016-01-24 18:00:00 | CL | Futures | 40.83 | 41.58 | 40.7 | 41.22 | 8925.0 |
| 2016-01-24 19:00:00 | CL | Futures | 41.22 | 41.32 | 40.94 | 41.21 | 5343.0 |
| 2016-01-24 20:00:00 | CL | Futures | 41.21 | 41.21 | 40.89 | 41.09 | 3766.0 |
| 2016-01-24 21:00:00 | CL | Futures | 41.11 | 41.13 | 40.97 | 41.11 | 2352.0 |
| 2016-01-24 22:00:00 | CL | Futures | 41.11 | 41.31 | 41.04 | 41.14 | 1952.0 |
| 2016-01-24 23:00:00 | CL | Futures | 41.14 | 41.44 | 41.14 | 41.41 | 2841.0 |
| 2016-01-24 18:00:00 | GC | Futures | 1499.3 | 1500.4 | 1499.0 | 1500.0 | 760.0 |
| 2016-01-24 19:00:00 | GC | Futures | 1499.8 | 1502.0 | 1499.7 | 1500.2 | 1377.0 |
| 2016-01-24 20:00:00 | GC | Futures | 1500.2 | 1504.3 | 1500.0 | 1503.0 | 3164.0 |
| 2016-01-24 21:00:00 | GC | Futures | 1503.0 | 1504.1 | 1502.3 | 1504.1 | 1328.0 |
| 2016-01-24 22:00:00 | GC | Futures | 1503.9 | 1505.7 | 1503.8 | 1505.1 | 1759.0 |
| 2016-01-24 23:00:00 | GC | Futures | 1505.1 | 1505.6 | 1504.3 | 1505.4 | 522.0 |
| 2016-01-24 18:00:00 | ZN | Futures | 124.495438 | 124.510598 | 124.419637 | 124.449957 | 5810.0 |
| 2016-01-24 19:00:00 | ZN | Futures | 124.465118 | 124.556079 | 124.465118 | 124.510598 | 9609.0 |
| 2016-01-24 20:00:00 | ZN | Futures | 124.510598 | 124.616719 | 124.495438 | 124.540919 | 10797.0 |
| 2016-01-24 21:00:00 | ZN | Futures | 124.540919 | 124.556079 | 124.449957 | 124.495438 | 6754.0 |
| 2016-01-24 22:00:00 | ZN | Futures | 124.510598 | 124.510598 | 124.449957 | 124.449957 | 6507.0 |
| 2016-01-24 23:00:00 | ZN | Futures | 124.465118 | 124.465118 | 124.419637 | 124.434797 | 4700.0 |
> showing 36 of 289 rows — these rows as CSV