PREVIEW / futures_30min / 2013-12-22
file: by_date/futures_30min/2013/2013-12-22.parquet size: 18 KB rows: 474
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-22 18:00:00 | ES | Futures | 1879.89 | 1883.0 | 1879.63 | 1881.96 | 5393.0 |
| 2013-12-22 18:30:00 | ES | Futures | 1882.48 | 1882.48 | 1881.96 | 1881.96 | 774.0 |
| 2013-12-22 19:00:00 | ES | Futures | 1882.22 | 1882.74 | 1881.96 | 1882.22 | 1392.0 |
| 2013-12-22 19:30:00 | ES | Futures | 1882.22 | 1883.25 | 1881.96 | 1883.25 | 1658.0 |
| 2013-12-22 20:00:00 | ES | Futures | 1883.0 | 1884.81 | 1883.0 | 1883.25 | 2713.0 |
| 2013-12-22 20:30:00 | ES | Futures | 1883.25 | 1883.77 | 1883.0 | 1883.51 | 1035.0 |
| 2013-12-22 21:00:00 | ES | Futures | 1883.51 | 1884.03 | 1883.25 | 1883.25 | 991.0 |
| 2013-12-22 21:30:00 | ES | Futures | 1883.25 | 1883.25 | 1882.48 | 1882.48 | 952.0 |
| 2013-12-22 22:00:00 | ES | Futures | 1882.74 | 1883.0 | 1882.48 | 1883.0 | 638.0 |
| 2013-12-22 22:30:00 | ES | Futures | 1883.0 | 1883.77 | 1882.74 | 1883.51 | 846.0 |
| 2013-12-22 23:00:00 | ES | Futures | 1883.51 | 1884.55 | 1883.51 | 1884.29 | 887.0 |
| 2013-12-22 23:30:00 | ES | Futures | 1884.29 | 1884.29 | 1882.74 | 1882.74 | 1119.0 |
| 2013-12-22 18:00:00 | NQ | Futures | 4117.26 | 4121.91 | 4117.26 | 4121.62 | 909.0 |
| 2013-12-22 18:30:00 | NQ | Futures | 4121.62 | 4123.94 | 4121.33 | 4123.36 | 350.0 |
| 2013-12-22 19:00:00 | NQ | Futures | 4123.07 | 4123.94 | 4122.78 | 4123.94 | 215.0 |
| 2013-12-22 19:30:00 | NQ | Futures | 4123.65 | 4125.4 | 4123.65 | 4124.82 | 204.0 |
| 2013-12-22 20:00:00 | NQ | Futures | 4124.82 | 4126.85 | 4124.53 | 4125.11 | 589.0 |
| 2013-12-22 20:30:00 | NQ | Futures | 4125.11 | 4125.11 | 4123.36 | 4124.82 | 238.0 |
| 2013-12-22 21:00:00 | NQ | Futures | 4124.82 | 4125.69 | 4124.53 | 4124.53 | 244.0 |
| 2013-12-22 21:30:00 | NQ | Futures | 4124.53 | 4124.82 | 4123.65 | 4124.24 | 255.0 |
| 2013-12-22 22:00:00 | NQ | Futures | 4124.24 | 4124.82 | 4123.65 | 4124.24 | 97.0 |
| 2013-12-22 22:30:00 | NQ | Futures | 4124.53 | 4125.11 | 4123.94 | 4125.11 | 62.0 |
| 2013-12-22 23:00:00 | NQ | Futures | 4125.11 | 4128.89 | 4124.82 | 4127.14 | 525.0 |
| 2013-12-22 23:30:00 | NQ | Futures | 4127.14 | 4127.14 | 4124.53 | 4124.82 | 157.0 |
| 2013-12-22 18:00:00 | YM | Futures | 16619.7 | 16636.1 | 16619.7 | 16631.0 | 498.0 |
| 2013-12-22 18:30:00 | YM | Futures | 16630.0 | 16633.1 | 16630.0 | 16630.0 | 43.0 |
| 2013-12-22 19:00:00 | YM | Futures | 16629.0 | 16632.0 | 16627.9 | 16631.0 | 145.0 |
| 2013-12-22 19:30:00 | YM | Futures | 16631.0 | 16636.1 | 16631.0 | 16636.1 | 171.0 |
| 2013-12-22 20:00:00 | YM | Futures | 16635.1 | 16647.4 | 16635.1 | 16640.2 | 493.0 |
| 2013-12-22 20:30:00 | YM | Futures | 16640.2 | 16640.2 | 16632.0 | 16635.1 | 338.0 |
| 2013-12-22 21:00:00 | YM | Futures | 16635.1 | 16636.1 | 16630.0 | 16631.0 | 360.0 |
| 2013-12-22 21:30:00 | YM | Futures | 16631.0 | 16632.0 | 16623.8 | 16626.9 | 268.0 |
| 2013-12-22 22:00:00 | YM | Futures | 16626.9 | 16629.0 | 16626.9 | 16627.9 | 38.0 |
| 2013-12-22 22:30:00 | YM | Futures | 16627.9 | 16633.1 | 16627.9 | 16633.1 | 103.0 |
| 2013-12-22 23:00:00 | YM | Futures | 16633.1 | 16641.3 | 16633.1 | 16639.2 | 141.0 |
| 2013-12-22 23:30:00 | YM | Futures | 16638.2 | 16638.2 | 16632.0 | 16633.1 | 155.0 |
| 2013-12-22 18:00:00 | CL | Futures | 156.21 | 156.26 | 156.15 | 156.18 | 334.0 |
| 2013-12-22 18:30:00 | CL | Futures | 156.2 | 156.24 | 156.2 | 156.21 | 58.0 |
| 2013-12-22 19:00:00 | CL | Futures | 156.21 | 156.29 | 156.21 | 156.27 | 135.0 |
| 2013-12-22 19:30:00 | CL | Futures | 156.27 | 156.34 | 156.26 | 156.31 | 115.0 |
| 2013-12-22 20:00:00 | CL | Futures | 156.32 | 156.35 | 156.27 | 156.32 | 177.0 |
| 2013-12-22 20:30:00 | CL | Futures | 156.31 | 156.37 | 156.24 | 156.35 | 186.0 |
| 2013-12-22 21:00:00 | CL | Futures | 156.37 | 156.38 | 156.34 | 156.34 | 144.0 |
| 2013-12-22 21:30:00 | CL | Futures | 156.32 | 156.35 | 156.29 | 156.34 | 90.0 |
| 2013-12-22 22:00:00 | CL | Futures | 156.35 | 156.37 | 156.15 | 156.24 | 278.0 |
| 2013-12-22 22:30:00 | CL | Futures | 156.27 | 156.29 | 156.13 | 156.18 | 534.0 |
| 2013-12-22 23:00:00 | CL | Futures | 156.21 | 156.23 | 156.13 | 156.16 | 145.0 |
| 2013-12-22 23:30:00 | CL | Futures | 156.15 | 156.23 | 156.15 | 156.23 | 87.0 |
| 2013-12-22 18:00:00 | GC | Futures | 1648.3 | 1651.8 | 1647.7 | 1650.4 | 617.0 |
| 2013-12-22 18:30:00 | GC | Futures | 1650.3 | 1650.5 | 1648.8 | 1649.2 | 217.0 |
> showing 50 of 474 rows — these rows as CSV