PREVIEW / futures_1hour / 2015-09-06
file: by_date/futures_1hour/2015/2015-09-06.parquet size: 13 KB rows: 221
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 |
|---|---|---|---|---|---|---|---|
| 2015-09-06 18:00:00 | ES | Futures | 2041.33 | 2054.37 | 2040.26 | 2050.64 | 8128.0 |
| 2015-09-06 19:00:00 | ES | Futures | 2050.91 | 2051.18 | 2047.45 | 2050.64 | 3478.0 |
| 2015-09-06 20:00:00 | ES | Futures | 2050.91 | 2051.44 | 2043.46 | 2050.64 | 9593.0 |
| 2015-09-06 21:00:00 | ES | Futures | 2050.64 | 2066.09 | 2047.98 | 2060.23 | 26099.0 |
| 2015-09-06 22:00:00 | ES | Futures | 2060.5 | 2063.16 | 2056.77 | 2060.23 | 8005.0 |
| 2015-09-06 23:00:00 | ES | Futures | 2060.23 | 2070.88 | 2059.7 | 2066.62 | 13151.0 |
| 2015-09-06 18:00:00 | NQ | Futures | 4947.67 | 4986.42 | 4945.6 | 4979.61 | 1264.0 |
| 2015-09-06 19:00:00 | NQ | Futures | 4979.32 | 4981.09 | 4973.11 | 4979.32 | 565.0 |
| 2015-09-06 20:00:00 | NQ | Futures | 4979.32 | 4983.16 | 4964.53 | 4980.8 | 2361.0 |
| 2015-09-06 21:00:00 | NQ | Futures | 4981.09 | 5021.03 | 4975.47 | 5006.24 | 3509.0 |
| 2015-09-06 22:00:00 | NQ | Futures | 5006.53 | 5010.67 | 4994.4 | 5003.87 | 2334.0 |
| 2015-09-06 23:00:00 | NQ | Futures | 5002.98 | 5020.73 | 5001.8 | 5011.86 | 2642.0 |
| 2015-09-06 18:00:00 | YM | Futures | 16950.2 | 17037.6 | 16867.0 | 17014.4 | 991.0 |
| 2015-09-06 19:00:00 | YM | Futures | 17014.4 | 17021.8 | 16994.4 | 17018.6 | 512.0 |
| 2015-09-06 20:00:00 | YM | Futures | 17016.5 | 17021.8 | 16962.8 | 17015.5 | 1412.0 |
| 2015-09-06 21:00:00 | YM | Futures | 17015.5 | 17144.0 | 16978.6 | 17080.8 | 7714.0 |
| 2015-09-06 22:00:00 | YM | Futures | 17084.0 | 17100.8 | 17046.0 | 17079.7 | 1983.0 |
| 2015-09-06 23:00:00 | YM | Futures | 17079.7 | 17150.3 | 17076.6 | 17125.0 | 2136.0 |
| 2015-09-06 18:00:00 | CL | Futures | 66.34 | 66.49 | 65.95 | 66.22 | 796.0 |
| 2015-09-06 19:00:00 | CL | Futures | 66.27 | 66.28 | 66.12 | 66.2 | 230.0 |
| 2015-09-06 20:00:00 | CL | Futures | 66.2 | 66.21 | 65.37 | 65.53 | 3007.0 |
| 2015-09-06 21:00:00 | CL | Futures | 65.5 | 66.46 | 65.5 | 66.24 | 2345.0 |
| 2015-09-06 22:00:00 | CL | Futures | 66.25 | 66.51 | 66.01 | 66.09 | 1486.0 |
| 2015-09-06 23:00:00 | CL | Futures | 66.11 | 66.49 | 66.11 | 66.37 | 1269.0 |
| 2015-09-06 18:00:00 | GC | Futures | 1533.3 | 1533.4 | 1531.1 | 1531.4 | 466.0 |
| 2015-09-06 19:00:00 | GC | Futures | 1531.4 | 1532.2 | 1528.6 | 1529.0 | 405.0 |
| 2015-09-06 20:00:00 | GC | Futures | 1529.2 | 1529.3 | 1526.2 | 1527.3 | 1812.0 |
| 2015-09-06 21:00:00 | GC | Futures | 1527.1 | 1533.5 | 1525.1 | 1533.1 | 3656.0 |
| 2015-09-06 22:00:00 | GC | Futures | 1533.1 | 1534.8 | 1531.9 | 1532.2 | 2568.0 |
| 2015-09-06 23:00:00 | GC | Futures | 1532.3 | 1533.4 | 1532.0 | 1532.6 | 1041.0 |
| 2015-09-06 19:00:00 | ZN | Futures | 123.355105 | 123.355105 | 123.325044 | 123.325044 | 3.0 |
| 2015-09-06 20:00:00 | ZN | Futures | 123.294983 | 123.294983 | 123.294983 | 123.294983 | 1.0 |
| 2015-09-06 21:00:00 | ZN | Futures | 123.264922 | 123.264922 | 123.18977 | 123.18977 | 6.0 |
| 2015-09-06 22:00:00 | ZN | Futures | 123.2048 | 123.219831 | 123.2048 | 123.219831 | 2.0 |
| 2015-09-06 23:00:00 | ZN | Futures | 123.219831 | 123.219831 | 123.219831 | 123.219831 | 2.0 |
> showing 35 of 221 rows — these rows as CSV