PREVIEW / futures_30min / 2014-09-07
file: by_date/futures_30min/2014/2014-09-07.parquet size: 18 KB rows: 471
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 |
|---|---|---|---|---|---|---|---|
| 2014-09-07 18:00:00 | ES | Futures | 2091.69 | 2091.95 | 2089.34 | 2089.86 | 6537.0 |
| 2014-09-07 18:30:00 | ES | Futures | 2090.12 | 2090.38 | 2089.86 | 2090.38 | 835.0 |
| 2014-09-07 19:00:00 | ES | Futures | 2090.12 | 2090.91 | 2090.12 | 2090.65 | 640.0 |
| 2014-09-07 19:30:00 | ES | Futures | 2090.65 | 2091.43 | 2089.86 | 2091.17 | 1564.0 |
| 2014-09-07 20:00:00 | ES | Futures | 2091.17 | 2091.17 | 2089.6 | 2089.86 | 2049.0 |
| 2014-09-07 20:30:00 | ES | Futures | 2089.86 | 2090.38 | 2089.6 | 2090.12 | 2094.0 |
| 2014-09-07 21:00:00 | ES | Futures | 2089.86 | 2090.12 | 2089.34 | 2089.6 | 1503.0 |
| 2014-09-07 21:30:00 | ES | Futures | 2089.86 | 2089.86 | 2089.08 | 2089.6 | 921.0 |
| 2014-09-07 22:00:00 | ES | Futures | 2089.34 | 2089.86 | 2088.82 | 2089.34 | 1553.0 |
| 2014-09-07 22:30:00 | ES | Futures | 2089.6 | 2089.6 | 2088.56 | 2088.56 | 1623.0 |
| 2014-09-07 23:00:00 | ES | Futures | 2088.56 | 2089.08 | 2088.56 | 2089.08 | 866.0 |
| 2014-09-07 23:30:00 | ES | Futures | 2089.08 | 2089.34 | 2088.82 | 2089.08 | 841.0 |
| 2014-09-07 18:00:00 | NQ | Futures | 4773.27 | 4774.44 | 4770.06 | 4771.52 | 828.0 |
| 2014-09-07 18:30:00 | NQ | Futures | 4771.52 | 4772.69 | 4770.06 | 4771.52 | 200.0 |
| 2014-09-07 19:00:00 | NQ | Futures | 4772.1 | 4773.27 | 4771.81 | 4772.69 | 66.0 |
| 2014-09-07 19:30:00 | NQ | Futures | 4772.98 | 4774.15 | 4771.23 | 4773.86 | 175.0 |
| 2014-09-07 20:00:00 | NQ | Futures | 4773.56 | 4773.86 | 4769.77 | 4771.52 | 368.0 |
| 2014-09-07 20:30:00 | NQ | Futures | 4771.23 | 4772.69 | 4770.94 | 4772.1 | 250.0 |
| 2014-09-07 21:00:00 | NQ | Futures | 4772.1 | 4772.1 | 4770.64 | 4771.23 | 185.0 |
| 2014-09-07 21:30:00 | NQ | Futures | 4771.23 | 4771.81 | 4770.06 | 4771.52 | 97.0 |
| 2014-09-07 22:00:00 | NQ | Futures | 4771.52 | 4772.1 | 4768.89 | 4771.23 | 253.0 |
| 2014-09-07 22:30:00 | NQ | Futures | 4770.94 | 4770.94 | 4769.18 | 4769.18 | 228.0 |
| 2014-09-07 23:00:00 | NQ | Futures | 4769.18 | 4770.64 | 4769.18 | 4770.64 | 99.0 |
| 2014-09-07 23:30:00 | NQ | Futures | 4770.35 | 4771.23 | 4770.35 | 4770.35 | 68.0 |
| 2014-09-07 18:00:00 | YM | Futures | 17710.7 | 17713.8 | 17695.2 | 17702.5 | 483.0 |
| 2014-09-07 18:30:00 | YM | Futures | 17701.4 | 17705.6 | 17700.4 | 17703.5 | 166.0 |
| 2014-09-07 19:00:00 | YM | Futures | 17704.5 | 17707.6 | 17704.5 | 17707.6 | 73.0 |
| 2014-09-07 19:30:00 | YM | Futures | 17706.6 | 17709.7 | 17700.4 | 17709.7 | 288.0 |
| 2014-09-07 20:00:00 | YM | Futures | 17710.7 | 17710.7 | 17696.3 | 17700.4 | 431.0 |
| 2014-09-07 20:30:00 | YM | Futures | 17701.4 | 17702.5 | 17698.3 | 17701.4 | 192.0 |
| 2014-09-07 21:00:00 | YM | Futures | 17701.4 | 17701.4 | 17696.3 | 17700.4 | 85.0 |
| 2014-09-07 21:30:00 | YM | Futures | 17700.4 | 17700.4 | 17695.2 | 17697.3 | 77.0 |
| 2014-09-07 22:00:00 | YM | Futures | 17697.3 | 17700.4 | 17691.1 | 17696.3 | 256.0 |
| 2014-09-07 22:30:00 | YM | Futures | 17696.3 | 17696.3 | 17685.9 | 17689.0 | 683.0 |
| 2014-09-07 23:00:00 | YM | Futures | 17689.0 | 17695.2 | 17689.0 | 17694.2 | 517.0 |
| 2014-09-07 23:30:00 | YM | Futures | 17695.2 | 17698.3 | 17695.2 | 17696.3 | 216.0 |
| 2014-09-07 18:00:00 | CL | Futures | 154.2 | 154.42 | 154.02 | 154.32 | 487.0 |
| 2014-09-07 18:30:00 | CL | Futures | 154.35 | 154.35 | 153.99 | 154.17 | 341.0 |
| 2014-09-07 19:00:00 | CL | Futures | 154.17 | 154.2 | 154.16 | 154.2 | 82.0 |
| 2014-09-07 19:30:00 | CL | Futures | 154.2 | 154.2 | 154.16 | 154.17 | 52.0 |
| 2014-09-07 20:00:00 | CL | Futures | 154.17 | 154.17 | 153.78 | 153.81 | 585.0 |
| 2014-09-07 20:30:00 | CL | Futures | 153.83 | 153.91 | 153.76 | 153.78 | 391.0 |
| 2014-09-07 21:00:00 | CL | Futures | 153.78 | 153.84 | 153.73 | 153.74 | 371.0 |
| 2014-09-07 21:30:00 | CL | Futures | 153.74 | 153.78 | 153.59 | 153.61 | 451.0 |
| 2014-09-07 22:00:00 | CL | Futures | 153.63 | 153.86 | 153.63 | 153.84 | 609.0 |
| 2014-09-07 22:30:00 | CL | Futures | 153.83 | 154.04 | 153.79 | 153.81 | 757.0 |
| 2014-09-07 23:00:00 | CL | Futures | 153.83 | 153.96 | 153.79 | 153.89 | 172.0 |
| 2014-09-07 23:30:00 | CL | Futures | 153.89 | 153.96 | 153.79 | 153.91 | 150.0 |
| 2014-09-07 18:00:00 | GC | Futures | 1737.9 | 1740.1 | 1736.6 | 1739.7 | 505.0 |
| 2014-09-07 18:30:00 | GC | Futures | 1739.5 | 1740.2 | 1737.3 | 1737.5 | 349.0 |
> showing 50 of 471 rows — these rows as CSV