PREVIEW / futures_1hour / 2018-04-22
file: by_date/futures_1hour/2018/2018-04-22.parquet size: 15 KB rows: 299
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-04-22 18:00:00 | ES | Futures | 2928.85 | 2930.76 | 2922.3 | 2923.94 | 11709.0 |
| 2018-04-22 19:00:00 | ES | Futures | 2923.94 | 2923.94 | 2917.93 | 2922.85 | 7632.0 |
| 2018-04-22 20:00:00 | ES | Futures | 2922.57 | 2924.48 | 2920.12 | 2922.03 | 6631.0 |
| 2018-04-22 21:00:00 | ES | Futures | 2922.03 | 2924.48 | 2921.21 | 2922.3 | 5872.0 |
| 2018-04-22 22:00:00 | ES | Futures | 2922.3 | 2923.12 | 2918.75 | 2921.75 | 5029.0 |
| 2018-04-22 23:00:00 | ES | Futures | 2921.75 | 2924.48 | 2920.66 | 2923.39 | 3637.0 |
| 2018-04-22 18:00:00 | NQ | Futures | 7926.76 | 7943.9 | 7910.21 | 7914.94 | 3663.0 |
| 2018-04-22 19:00:00 | NQ | Futures | 7915.24 | 7917.31 | 7899.57 | 7915.24 | 1980.0 |
| 2018-04-22 20:00:00 | NQ | Futures | 7914.65 | 7922.63 | 7906.67 | 7911.69 | 2047.0 |
| 2018-04-22 21:00:00 | NQ | Futures | 7912.58 | 7920.56 | 7909.33 | 7911.99 | 1719.0 |
| 2018-04-22 22:00:00 | NQ | Futures | 7912.28 | 7914.94 | 7896.91 | 7912.58 | 2700.0 |
| 2018-04-22 23:00:00 | NQ | Futures | 7912.58 | 7917.6 | 7908.44 | 7914.35 | 1330.0 |
| 2018-04-22 18:00:00 | YM | Futures | 26653.2 | 26666.2 | 26590.2 | 26605.4 | 2441.0 |
| 2018-04-22 19:00:00 | YM | Futures | 26605.4 | 26611.9 | 26556.5 | 26600.0 | 2246.0 |
| 2018-04-22 20:00:00 | YM | Futures | 26598.9 | 26626.0 | 26581.5 | 26597.8 | 1847.0 |
| 2018-04-22 21:00:00 | YM | Futures | 26594.5 | 26623.9 | 26589.1 | 26603.2 | 2070.0 |
| 2018-04-22 22:00:00 | YM | Futures | 26602.1 | 26609.7 | 26575.0 | 26602.1 | 1854.0 |
| 2018-04-22 23:00:00 | YM | Futures | 26603.2 | 26614.1 | 26594.5 | 26605.4 | 1153.0 |
| 2018-04-22 18:00:00 | CL | Futures | 60.97 | 61.13 | 60.9 | 61.05 | 4436.0 |
| 2018-04-22 19:00:00 | CL | Futures | 61.05 | 61.11 | 60.95 | 60.99 | 2488.0 |
| 2018-04-22 20:00:00 | CL | Futures | 61.0 | 61.02 | 60.89 | 60.93 | 3332.0 |
| 2018-04-22 21:00:00 | CL | Futures | 60.93 | 61.08 | 60.87 | 61.03 | 6017.0 |
| 2018-04-22 22:00:00 | CL | Futures | 61.04 | 61.06 | 60.91 | 61.01 | 4418.0 |
| 2018-04-22 23:00:00 | CL | Futures | 61.02 | 61.13 | 60.98 | 61.07 | 5045.0 |
| 2018-04-22 18:00:00 | GC | Futures | 1760.5 | 1762.0 | 1756.6 | 1758.9 | 5911.0 |
| 2018-04-22 19:00:00 | GC | Futures | 1758.8 | 1760.9 | 1758.1 | 1758.8 | 3621.0 |
| 2018-04-22 20:00:00 | GC | Futures | 1758.8 | 1760.3 | 1757.9 | 1759.3 | 5215.0 |
| 2018-04-22 21:00:00 | GC | Futures | 1759.2 | 1760.8 | 1757.9 | 1760.8 | 8547.0 |
| 2018-04-22 22:00:00 | GC | Futures | 1760.6 | 1761.2 | 1759.1 | 1759.3 | 7357.0 |
| 2018-04-22 23:00:00 | GC | Futures | 1759.3 | 1760.4 | 1758.7 | 1760.3 | 4297.0 |
| 2018-04-22 18:00:00 | ZN | Futures | 119.852089 | 119.867762 | 119.789396 | 119.805069 | 14415.0 |
| 2018-04-22 19:00:00 | ZN | Futures | 119.789396 | 119.820742 | 119.773723 | 119.805069 | 10311.0 |
| 2018-04-22 20:00:00 | ZN | Futures | 119.805069 | 119.820742 | 119.789396 | 119.805069 | 11992.0 |
| 2018-04-22 21:00:00 | ZN | Futures | 119.820742 | 119.820742 | 119.773723 | 119.789396 | 12826.0 |
| 2018-04-22 22:00:00 | ZN | Futures | 119.773723 | 119.789396 | 119.773723 | 119.773723 | 5436.0 |
| 2018-04-22 23:00:00 | ZN | Futures | 119.773723 | 119.773723 | 119.695358 | 119.726704 | 27294.0 |
> showing 36 of 299 rows — these rows as CSV