PREVIEW / futures_1hour / 2019-02-10
file: by_date/futures_1hour/2019/2019-02-10.parquet size: 16 KB rows: 340
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-10 18:00:00 | ES | Futures | 2944.79 | 2946.96 | 2939.9 | 2939.9 | 13608.0 |
| 2019-02-10 19:00:00 | ES | Futures | 2940.17 | 2940.99 | 2936.37 | 2937.19 | 7073.0 |
| 2019-02-10 20:00:00 | ES | Futures | 2937.19 | 2938.27 | 2933.66 | 2935.29 | 8422.0 |
| 2019-02-10 21:00:00 | ES | Futures | 2935.56 | 2940.45 | 2935.01 | 2939.09 | 6482.0 |
| 2019-02-10 22:00:00 | ES | Futures | 2939.36 | 2939.9 | 2937.73 | 2938.27 | 3058.0 |
| 2019-02-10 23:00:00 | ES | Futures | 2938.27 | 2938.82 | 2936.37 | 2938.0 | 4350.0 |
| 2019-02-10 18:00:00 | NQ | Futures | 8089.85 | 8111.18 | 8079.62 | 8080.5 | 3434.0 |
| 2019-02-10 19:00:00 | NQ | Futures | 8080.5 | 8084.0 | 8068.52 | 8071.73 | 3859.0 |
| 2019-02-10 20:00:00 | NQ | Futures | 8072.02 | 8076.99 | 8061.21 | 8064.43 | 4092.0 |
| 2019-02-10 21:00:00 | NQ | Futures | 8064.43 | 8081.66 | 8062.96 | 8078.45 | 3112.0 |
| 2019-02-10 22:00:00 | NQ | Futures | 8078.74 | 8080.79 | 8070.85 | 8074.94 | 1908.0 |
| 2019-02-10 23:00:00 | NQ | Futures | 8074.94 | 8075.82 | 8066.47 | 8071.44 | 1356.0 |
| 2019-02-10 18:00:00 | YM | Futures | 27239.3 | 27294.7 | 27218.7 | 27220.8 | 2363.0 |
| 2019-02-10 19:00:00 | YM | Futures | 27221.9 | 27228.4 | 27188.3 | 27194.8 | 1940.0 |
| 2019-02-10 20:00:00 | YM | Futures | 27194.8 | 27205.6 | 27161.1 | 27179.6 | 2207.0 |
| 2019-02-10 21:00:00 | YM | Futures | 27179.6 | 27224.1 | 27175.2 | 27210.0 | 1478.0 |
| 2019-02-10 22:00:00 | YM | Futures | 27211.1 | 27213.2 | 27194.8 | 27200.2 | 804.0 |
| 2019-02-10 23:00:00 | YM | Futures | 27200.2 | 27202.4 | 27177.4 | 27197.0 | 1075.0 |
| 2019-02-10 18:00:00 | CL | Futures | 47.79 | 47.9 | 47.63 | 47.64 | 3245.0 |
| 2019-02-10 19:00:00 | CL | Futures | 47.64 | 47.66 | 47.45 | 47.56 | 5835.0 |
| 2019-02-10 20:00:00 | CL | Futures | 47.56 | 47.56 | 47.1 | 47.19 | 18380.0 |
| 2019-02-10 21:00:00 | CL | Futures | 47.19 | 47.37 | 47.13 | 47.33 | 8370.0 |
| 2019-02-10 22:00:00 | CL | Futures | 47.34 | 47.36 | 47.26 | 47.28 | 3566.0 |
| 2019-02-10 23:00:00 | CL | Futures | 47.27 | 47.29 | 47.16 | 47.22 | 3081.0 |
| 2019-02-10 18:00:00 | GC | Futures | 1699.7 | 1699.9 | 1698.5 | 1698.8 | 1300.0 |
| 2019-02-10 19:00:00 | GC | Futures | 1698.8 | 1698.9 | 1697.8 | 1697.9 | 1319.0 |
| 2019-02-10 20:00:00 | GC | Futures | 1697.9 | 1700.5 | 1697.0 | 1699.2 | 5514.0 |
| 2019-02-10 21:00:00 | GC | Futures | 1699.2 | 1699.3 | 1696.7 | 1696.9 | 3022.0 |
| 2019-02-10 22:00:00 | GC | Futures | 1696.9 | 1697.1 | 1695.7 | 1696.5 | 3779.0 |
| 2019-02-10 23:00:00 | GC | Futures | 1696.3 | 1696.9 | 1694.8 | 1695.4 | 1762.0 |
| 2019-02-10 18:00:00 | ZN | Futures | 123.233946 | 123.265427 | 123.202465 | 123.249687 | 14123.0 |
| 2019-02-10 19:00:00 | ZN | Futures | 123.265427 | 123.281168 | 123.249687 | 123.265427 | 8038.0 |
| 2019-02-10 20:00:00 | ZN | Futures | 123.281168 | 123.281168 | 123.265427 | 123.281168 | 3566.0 |
| 2019-02-10 21:00:00 | ZN | Futures | 123.281168 | 123.281168 | 123.233946 | 123.249687 | 8508.0 |
| 2019-02-10 22:00:00 | ZN | Futures | 123.233946 | 123.281168 | 123.233946 | 123.281168 | 5055.0 |
| 2019-02-10 23:00:00 | ZN | Futures | 123.265427 | 123.281168 | 123.265427 | 123.265427 | 898.0 |
> showing 36 of 340 rows — these rows as CSV