PREVIEW / futures_1hour / 2016-04-10
file: by_date/futures_1hour/2016/2016-04-10.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-04-10 18:00:00 | ES | Futures | 2204.12 | 2205.2 | 2201.42 | 2204.12 | 6751.0 |
| 2016-04-10 19:00:00 | ES | Futures | 2204.12 | 2206.55 | 2203.85 | 2205.2 | 4097.0 |
| 2016-04-10 20:00:00 | ES | Futures | 2204.93 | 2205.2 | 2200.07 | 2201.69 | 10527.0 |
| 2016-04-10 21:00:00 | ES | Futures | 2201.69 | 2201.96 | 2195.75 | 2199.53 | 15631.0 |
| 2016-04-10 22:00:00 | ES | Futures | 2199.26 | 2203.85 | 2197.1 | 2202.77 | 9809.0 |
| 2016-04-10 23:00:00 | ES | Futures | 2203.04 | 2204.12 | 2200.88 | 2202.5 | 5575.0 |
| 2016-04-10 18:00:00 | NQ | Futures | 5319.83 | 5319.83 | 5310.31 | 5317.75 | 708.0 |
| 2016-04-10 19:00:00 | NQ | Futures | 5316.86 | 5325.48 | 5316.86 | 5321.91 | 659.0 |
| 2016-04-10 20:00:00 | NQ | Futures | 5321.91 | 5321.91 | 5304.66 | 5309.12 | 1100.0 |
| 2016-04-10 21:00:00 | NQ | Futures | 5308.52 | 5309.42 | 5293.95 | 5304.06 | 2105.0 |
| 2016-04-10 22:00:00 | NQ | Futures | 5304.66 | 5315.96 | 5298.41 | 5313.58 | 1064.0 |
| 2016-04-10 23:00:00 | NQ | Futures | 5313.29 | 5317.75 | 5308.82 | 5312.99 | 705.0 |
| 2016-04-10 18:00:00 | YM | Futures | 18717.9 | 18726.5 | 18699.7 | 18715.8 | 770.0 |
| 2016-04-10 19:00:00 | YM | Futures | 18716.8 | 18736.1 | 18712.6 | 18724.3 | 581.0 |
| 2016-04-10 20:00:00 | YM | Futures | 18726.5 | 18726.5 | 18683.7 | 18696.5 | 1300.0 |
| 2016-04-10 21:00:00 | YM | Futures | 18695.4 | 18696.5 | 18652.6 | 18682.6 | 2305.0 |
| 2016-04-10 22:00:00 | YM | Futures | 18681.5 | 18711.5 | 18663.3 | 18705.1 | 1393.0 |
| 2016-04-10 23:00:00 | YM | Futures | 18706.1 | 18713.6 | 18693.3 | 18704.0 | 703.0 |
| 2016-04-10 18:00:00 | CL | Futures | 44.09 | 44.92 | 43.99 | 44.67 | 8569.0 |
| 2016-04-10 19:00:00 | CL | Futures | 44.68 | 44.75 | 44.51 | 44.61 | 3962.0 |
| 2016-04-10 20:00:00 | CL | Futures | 44.61 | 44.64 | 44.5 | 44.55 | 2908.0 |
| 2016-04-10 21:00:00 | CL | Futures | 44.57 | 44.58 | 44.12 | 44.25 | 6746.0 |
| 2016-04-10 22:00:00 | CL | Futures | 44.25 | 44.42 | 44.12 | 44.35 | 4309.0 |
| 2016-04-10 23:00:00 | CL | Futures | 44.37 | 44.4 | 44.13 | 44.24 | 3637.0 |
| 2016-04-10 18:00:00 | GC | Futures | 1693.6 | 1704.6 | 1693.4 | 1700.5 | 4463.0 |
| 2016-04-10 19:00:00 | GC | Futures | 1700.5 | 1701.8 | 1699.0 | 1699.9 | 1129.0 |
| 2016-04-10 20:00:00 | GC | Futures | 1700.1 | 1702.1 | 1699.0 | 1701.0 | 3003.0 |
| 2016-04-10 21:00:00 | GC | Futures | 1700.9 | 1708.5 | 1699.4 | 1707.0 | 10323.0 |
| 2016-04-10 22:00:00 | GC | Futures | 1707.1 | 1710.1 | 1706.9 | 1708.4 | 5022.0 |
| 2016-04-10 23:00:00 | GC | Futures | 1708.2 | 1708.8 | 1706.2 | 1707.1 | 2424.0 |
| 2016-04-10 18:00:00 | ZN | Futures | 127.640582 | 127.671012 | 127.503644 | 127.51886 | 4193.0 |
| 2016-04-10 19:00:00 | ZN | Futures | 127.534075 | 127.54929 | 127.488429 | 127.534075 | 4537.0 |
| 2016-04-10 20:00:00 | ZN | Futures | 127.534075 | 127.686227 | 127.534075 | 127.655797 | 11400.0 |
| 2016-04-10 21:00:00 | ZN | Futures | 127.671012 | 127.747088 | 127.655797 | 127.686227 | 12179.0 |
| 2016-04-10 22:00:00 | ZN | Futures | 127.686227 | 127.716658 | 127.610151 | 127.640582 | 7432.0 |
| 2016-04-10 23:00:00 | ZN | Futures | 127.640582 | 127.655797 | 127.594936 | 127.625366 | 7629.0 |
> showing 36 of 289 rows — these rows as CSV