PREVIEW / futures_1hour / 2018-02-25
file: by_date/futures_1hour/2018/2018-02-25.parquet size: 16 KB rows: 305
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-02-25 18:00:00 | ES | Futures | 3008.25 | 3011.8 | 3005.79 | 3009.07 | 11666.0 |
| 2018-02-25 19:00:00 | ES | Futures | 3008.79 | 3009.61 | 2998.41 | 3001.69 | 12391.0 |
| 2018-02-25 20:00:00 | ES | Futures | 3001.42 | 3005.51 | 3000.05 | 3002.24 | 7279.0 |
| 2018-02-25 21:00:00 | ES | Futures | 3002.24 | 3005.51 | 2999.5 | 3003.87 | 4535.0 |
| 2018-02-25 22:00:00 | ES | Futures | 3003.6 | 3007.7 | 3003.6 | 3006.06 | 4530.0 |
| 2018-02-25 23:00:00 | ES | Futures | 3006.06 | 3007.43 | 3005.51 | 3006.61 | 2675.0 |
| 2018-02-25 18:00:00 | NQ | Futures | 8207.65 | 8220.11 | 8201.42 | 8203.5 | 3891.0 |
| 2018-02-25 19:00:00 | NQ | Futures | 8203.5 | 8204.39 | 8174.14 | 8177.4 | 6910.0 |
| 2018-02-25 20:00:00 | NQ | Futures | 8177.1 | 8190.75 | 8175.62 | 8181.85 | 5106.0 |
| 2018-02-25 21:00:00 | NQ | Futures | 8181.26 | 8192.23 | 8175.62 | 8186.0 | 3185.0 |
| 2018-02-25 22:00:00 | NQ | Futures | 8185.7 | 8196.09 | 8185.11 | 8188.37 | 1938.0 |
| 2018-02-25 23:00:00 | NQ | Futures | 8188.08 | 8192.82 | 8185.41 | 8189.86 | 1128.0 |
| 2018-02-25 18:00:00 | YM | Futures | 27528.5 | 27606.8 | 27528.5 | 27581.8 | 2558.0 |
| 2018-02-25 19:00:00 | YM | Futures | 27581.8 | 27589.4 | 27498.1 | 27516.5 | 5157.0 |
| 2018-02-25 20:00:00 | YM | Futures | 27517.6 | 27562.2 | 27510.0 | 27532.8 | 4519.0 |
| 2018-02-25 21:00:00 | YM | Futures | 27533.9 | 27560.0 | 27510.0 | 27547.0 | 3037.0 |
| 2018-02-25 22:00:00 | YM | Futures | 27547.0 | 27589.4 | 27544.8 | 27567.6 | 1829.0 |
| 2018-02-25 23:00:00 | YM | Futures | 27567.6 | 27582.8 | 27558.9 | 27570.9 | 1088.0 |
| 2018-02-25 18:00:00 | CL | Futures | 56.75 | 56.79 | 56.71 | 56.73 | 2235.0 |
| 2018-02-25 19:00:00 | CL | Futures | 56.73 | 56.73 | 56.6 | 56.61 | 3263.0 |
| 2018-02-25 20:00:00 | CL | Futures | 56.61 | 56.73 | 56.61 | 56.71 | 9371.0 |
| 2018-02-25 21:00:00 | CL | Futures | 56.71 | 57.02 | 56.7 | 56.92 | 11526.0 |
| 2018-02-25 22:00:00 | CL | Futures | 56.92 | 56.98 | 56.87 | 56.93 | 6952.0 |
| 2018-02-25 23:00:00 | CL | Futures | 56.93 | 56.95 | 56.87 | 56.9 | 4512.0 |
| 2018-02-25 18:00:00 | GC | Futures | 1760.5 | 1762.1 | 1757.4 | 1758.4 | 4677.0 |
| 2018-02-25 19:00:00 | GC | Futures | 1758.3 | 1760.7 | 1758.3 | 1760.3 | 4933.0 |
| 2018-02-25 20:00:00 | GC | Futures | 1760.1 | 1769.3 | 1760.1 | 1767.2 | 14764.0 |
| 2018-02-25 21:00:00 | GC | Futures | 1767.3 | 1773.0 | 1767.3 | 1771.3 | 13626.0 |
| 2018-02-25 22:00:00 | GC | Futures | 1771.4 | 1772.6 | 1770.6 | 1771.5 | 4676.0 |
| 2018-02-25 23:00:00 | GC | Futures | 1771.5 | 1772.3 | 1771.0 | 1771.5 | 3045.0 |
| 2018-02-25 18:00:00 | ZN | Futures | 120.478934 | 120.478934 | 120.400974 | 120.44775 | 9451.0 |
| 2018-02-25 19:00:00 | ZN | Futures | 120.44775 | 120.525709 | 120.432158 | 120.510118 | 12595.0 |
| 2018-02-25 20:00:00 | ZN | Futures | 120.510118 | 120.603669 | 120.510118 | 120.572485 | 23446.0 |
| 2018-02-25 21:00:00 | ZN | Futures | 120.588077 | 120.634853 | 120.588077 | 120.619261 | 18815.0 |
| 2018-02-25 22:00:00 | ZN | Futures | 120.634853 | 120.634853 | 120.556893 | 120.572485 | 10083.0 |
| 2018-02-25 23:00:00 | ZN | Futures | 120.572485 | 120.572485 | 120.494526 | 120.525709 | 9120.0 |
> showing 36 of 305 rows — these rows as CSV