PREVIEW / futures_1hour / 2016-05-15
file: by_date/futures_1hour/2016/2016-05-15.parquet size: 15 KB rows: 288
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-05-15 18:00:00 | ES | Futures | 2204.39 | 2204.66 | 2197.64 | 2200.88 | 14482.0 |
| 2016-05-15 19:00:00 | ES | Futures | 2200.88 | 2204.39 | 2200.61 | 2203.58 | 8580.0 |
| 2016-05-15 20:00:00 | ES | Futures | 2203.31 | 2209.25 | 2203.31 | 2208.17 | 18556.0 |
| 2016-05-15 21:00:00 | ES | Futures | 2208.17 | 2208.17 | 2204.93 | 2206.01 | 8659.0 |
| 2016-05-15 22:00:00 | ES | Futures | 2206.28 | 2210.6 | 2205.47 | 2210.6 | 8542.0 |
| 2016-05-15 23:00:00 | ES | Futures | 2210.6 | 2213.03 | 2210.6 | 2211.95 | 9300.0 |
| 2016-05-15 18:00:00 | NQ | Futures | 5136.55 | 5141.31 | 5124.06 | 5130.6 | 1192.0 |
| 2016-05-15 19:00:00 | NQ | Futures | 5130.9 | 5137.45 | 5130.6 | 5136.26 | 1261.0 |
| 2016-05-15 20:00:00 | NQ | Futures | 5136.26 | 5149.64 | 5135.96 | 5147.56 | 1983.0 |
| 2016-05-15 21:00:00 | NQ | Futures | 5147.86 | 5148.16 | 5139.83 | 5143.99 | 1202.0 |
| 2016-05-15 22:00:00 | NQ | Futures | 5143.1 | 5155.59 | 5142.21 | 5154.7 | 1152.0 |
| 2016-05-15 23:00:00 | NQ | Futures | 5155.3 | 5160.65 | 5155.3 | 5159.46 | 968.0 |
| 2016-05-15 18:00:00 | YM | Futures | 18697.6 | 18704.0 | 18647.3 | 18679.4 | 2055.0 |
| 2016-05-15 19:00:00 | YM | Futures | 18679.4 | 18701.9 | 18678.3 | 18695.4 | 1361.0 |
| 2016-05-15 20:00:00 | YM | Futures | 18695.4 | 18740.4 | 18693.3 | 18734.0 | 2852.0 |
| 2016-05-15 21:00:00 | YM | Futures | 18734.0 | 18739.3 | 18716.8 | 18727.5 | 2152.0 |
| 2016-05-15 22:00:00 | YM | Futures | 18725.4 | 18762.9 | 18722.2 | 18760.7 | 1689.0 |
| 2016-05-15 23:00:00 | YM | Futures | 18761.8 | 18777.9 | 18761.8 | 18768.2 | 1372.0 |
| 2016-05-15 18:00:00 | CL | Futures | 49.82 | 50.06 | 49.7 | 49.83 | 1144.0 |
| 2016-05-15 19:00:00 | CL | Futures | 49.85 | 49.9 | 49.81 | 49.89 | 200.0 |
| 2016-05-15 20:00:00 | CL | Futures | 49.88 | 49.92 | 49.8 | 49.84 | 670.0 |
| 2016-05-15 21:00:00 | CL | Futures | 49.82 | 50.27 | 49.76 | 50.22 | 2032.0 |
| 2016-05-15 22:00:00 | CL | Futures | 50.24 | 50.62 | 50.21 | 50.51 | 4515.0 |
| 2016-05-15 23:00:00 | CL | Futures | 50.51 | 50.52 | 50.36 | 50.39 | 1349.0 |
| 2016-05-15 18:00:00 | GC | Futures | 1736.3 | 1740.2 | 1735.1 | 1737.6 | 1803.0 |
| 2016-05-15 19:00:00 | GC | Futures | 1737.7 | 1741.0 | 1737.2 | 1739.2 | 1140.0 |
| 2016-05-15 20:00:00 | GC | Futures | 1739.1 | 1741.4 | 1738.2 | 1738.8 | 2583.0 |
| 2016-05-15 21:00:00 | GC | Futures | 1738.9 | 1739.9 | 1737.2 | 1738.9 | 3615.0 |
| 2016-05-15 22:00:00 | GC | Futures | 1739.1 | 1747.1 | 1738.8 | 1743.4 | 11269.0 |
| 2016-05-15 23:00:00 | GC | Futures | 1743.4 | 1744.0 | 1741.7 | 1742.9 | 3896.0 |
| 2016-05-15 18:00:00 | ZN | Futures | 127.594936 | 127.671012 | 127.564505 | 127.655797 | 10614.0 |
| 2016-05-15 19:00:00 | ZN | Futures | 127.655797 | 127.655797 | 127.564505 | 127.564505 | 6463.0 |
| 2016-05-15 20:00:00 | ZN | Futures | 127.564505 | 127.579721 | 127.488429 | 127.51886 | 16050.0 |
| 2016-05-15 21:00:00 | ZN | Futures | 127.503644 | 127.54929 | 127.503644 | 127.503644 | 6826.0 |
| 2016-05-15 22:00:00 | ZN | Futures | 127.51886 | 127.51886 | 127.442784 | 127.442784 | 9004.0 |
| 2016-05-15 23:00:00 | ZN | Futures | 127.442784 | 127.488429 | 127.427568 | 127.457999 | 7307.0 |
> showing 36 of 288 rows — these rows as CSV