PREVIEW / futures_1hour / 2018-07-22
file: by_date/futures_1hour/2018/2018-07-22.parquet size: 15 KB rows: 295
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 |
|---|---|---|---|---|---|---|---|
| 2018-07-22 18:00:00 | ES | Futures | 3057.34 | 3058.16 | 3054.89 | 3056.53 | 3803.0 |
| 2018-07-22 19:00:00 | ES | Futures | 3056.53 | 3057.07 | 3053.8 | 3053.8 | 2636.0 |
| 2018-07-22 20:00:00 | ES | Futures | 3053.8 | 3054.62 | 3048.35 | 3048.9 | 11317.0 |
| 2018-07-22 21:00:00 | ES | Futures | 3048.9 | 3049.17 | 3045.36 | 3047.54 | 14361.0 |
| 2018-07-22 22:00:00 | ES | Futures | 3047.26 | 3047.81 | 3043.45 | 3046.45 | 8533.0 |
| 2018-07-22 23:00:00 | ES | Futures | 3046.45 | 3048.35 | 3045.36 | 3048.08 | 6049.0 |
| 2018-07-22 18:00:00 | NQ | Futures | 8677.09 | 8688.28 | 8670.61 | 8680.33 | 1573.0 |
| 2018-07-22 19:00:00 | NQ | Futures | 8680.33 | 8682.1 | 8672.09 | 8672.09 | 860.0 |
| 2018-07-22 20:00:00 | NQ | Futures | 8672.09 | 8677.09 | 8655.3 | 8658.84 | 3023.0 |
| 2018-07-22 21:00:00 | NQ | Futures | 8658.84 | 8659.13 | 8638.52 | 8646.18 | 4971.0 |
| 2018-07-22 22:00:00 | NQ | Futures | 8645.88 | 8646.18 | 8629.1 | 8636.46 | 3003.0 |
| 2018-07-22 23:00:00 | NQ | Futures | 8637.05 | 8642.35 | 8635.28 | 8640.88 | 1517.0 |
| 2018-07-22 18:00:00 | YM | Futures | 27274.2 | 27274.2 | 27243.7 | 27261.1 | 956.0 |
| 2018-07-22 19:00:00 | YM | Futures | 27261.1 | 27263.3 | 27232.8 | 27232.8 | 696.0 |
| 2018-07-22 20:00:00 | YM | Futures | 27232.8 | 27241.5 | 27179.6 | 27187.2 | 2501.0 |
| 2018-07-22 21:00:00 | YM | Futures | 27187.2 | 27188.3 | 27153.5 | 27177.4 | 3227.0 |
| 2018-07-22 22:00:00 | YM | Futures | 27175.2 | 27185.0 | 27126.3 | 27170.9 | 2647.0 |
| 2018-07-22 23:00:00 | YM | Futures | 27169.8 | 27190.4 | 27158.9 | 27188.3 | 1291.0 |
| 2018-07-22 18:00:00 | CL | Futures | 61.96 | 62.12 | 61.82 | 62.06 | 2875.0 |
| 2018-07-22 19:00:00 | CL | Futures | 62.06 | 62.12 | 62.01 | 62.06 | 1675.0 |
| 2018-07-22 20:00:00 | CL | Futures | 62.07 | 62.11 | 61.9 | 61.91 | 3916.0 |
| 2018-07-22 21:00:00 | CL | Futures | 61.91 | 61.98 | 61.82 | 61.87 | 5153.0 |
| 2018-07-22 22:00:00 | CL | Futures | 61.86 | 61.92 | 61.77 | 61.88 | 3202.0 |
| 2018-07-22 23:00:00 | CL | Futures | 61.88 | 62.01 | 61.87 | 61.98 | 2645.0 |
| 2018-07-22 18:00:00 | GC | Futures | 1617.2 | 1617.6 | 1615.3 | 1617.5 | 2371.0 |
| 2018-07-22 19:00:00 | GC | Futures | 1617.5 | 1619.5 | 1617.0 | 1618.8 | 6636.0 |
| 2018-07-22 20:00:00 | GC | Futures | 1618.7 | 1621.8 | 1616.6 | 1620.4 | 10579.0 |
| 2018-07-22 21:00:00 | GC | Futures | 1620.4 | 1621.6 | 1616.7 | 1619.1 | 12387.0 |
| 2018-07-22 22:00:00 | GC | Futures | 1619.2 | 1619.5 | 1617.1 | 1617.4 | 5730.0 |
| 2018-07-22 23:00:00 | GC | Futures | 1617.4 | 1618.4 | 1617.1 | 1618.3 | 3030.0 |
| 2018-07-22 18:00:00 | ZN | Futures | 120.715226 | 120.730942 | 120.652362 | 120.683794 | 7560.0 |
| 2018-07-22 19:00:00 | ZN | Futures | 120.683794 | 120.69951 | 120.652362 | 120.69951 | 6957.0 |
| 2018-07-22 20:00:00 | ZN | Futures | 120.69951 | 120.746658 | 120.683794 | 120.746658 | 25254.0 |
| 2018-07-22 21:00:00 | ZN | Futures | 120.746658 | 120.778091 | 120.69951 | 120.715226 | 34863.0 |
| 2018-07-22 22:00:00 | ZN | Futures | 120.730942 | 120.730942 | 120.69951 | 120.69951 | 6429.0 |
| 2018-07-22 23:00:00 | ZN | Futures | 120.715226 | 120.730942 | 120.69951 | 120.69951 | 4436.0 |
> showing 36 of 295 rows — these rows as CSV