PREVIEW / futures_1hour / 2018-03-04
file: by_date/futures_1hour/2018/2018-03-04.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-03-04 18:00:00 | ES | Futures | 2933.63 | 2935.54 | 2923.79 | 2931.44 | 24329.0 |
| 2018-03-04 19:00:00 | ES | Futures | 2931.44 | 2940.19 | 2931.44 | 2933.9 | 11990.0 |
| 2018-03-04 20:00:00 | ES | Futures | 2933.9 | 2939.92 | 2930.35 | 2932.54 | 10941.0 |
| 2018-03-04 21:00:00 | ES | Futures | 2932.26 | 2933.36 | 2925.43 | 2927.34 | 10682.0 |
| 2018-03-04 22:00:00 | ES | Futures | 2927.62 | 2928.98 | 2924.88 | 2927.62 | 7639.0 |
| 2018-03-04 23:00:00 | ES | Futures | 2927.62 | 2929.26 | 2920.78 | 2921.6 | 6413.0 |
| 2018-03-04 18:00:00 | NQ | Futures | 8062.32 | 8069.74 | 8042.45 | 8059.36 | 5733.0 |
| 2018-03-04 19:00:00 | NQ | Futures | 8059.36 | 8081.6 | 8059.36 | 8064.4 | 5448.0 |
| 2018-03-04 20:00:00 | NQ | Futures | 8063.8 | 8080.12 | 8056.09 | 8059.06 | 5776.0 |
| 2018-03-04 21:00:00 | NQ | Futures | 8059.06 | 8060.84 | 8038.59 | 8039.19 | 6021.0 |
| 2018-03-04 22:00:00 | NQ | Futures | 8038.3 | 8046.9 | 8031.48 | 8043.93 | 3721.0 |
| 2018-03-04 23:00:00 | NQ | Futures | 8044.23 | 8047.2 | 8024.36 | 8025.25 | 2857.0 |
| 2018-03-04 18:00:00 | YM | Futures | 26610.1 | 26615.5 | 26521.0 | 26588.4 | 4325.0 |
| 2018-03-04 19:00:00 | YM | Futures | 26588.4 | 26694.9 | 26588.4 | 26629.7 | 4394.0 |
| 2018-03-04 20:00:00 | YM | Futures | 26628.6 | 26681.8 | 26596.0 | 26609.0 | 5061.0 |
| 2018-03-04 21:00:00 | YM | Futures | 26609.0 | 26616.6 | 26547.0 | 26564.4 | 5007.0 |
| 2018-03-04 22:00:00 | YM | Futures | 26564.4 | 26582.9 | 26535.1 | 26569.9 | 3652.0 |
| 2018-03-04 23:00:00 | YM | Futures | 26569.9 | 26584.0 | 26514.4 | 26517.7 | 2601.0 |
| 2018-03-04 18:00:00 | CL | Futures | 54.92 | 55.1 | 54.86 | 54.94 | 7403.0 |
| 2018-03-04 19:00:00 | CL | Futures | 54.94 | 55.01 | 54.94 | 54.97 | 4345.0 |
| 2018-03-04 20:00:00 | CL | Futures | 54.98 | 55.06 | 54.91 | 54.93 | 8096.0 |
| 2018-03-04 21:00:00 | CL | Futures | 54.93 | 54.99 | 54.82 | 54.86 | 7970.0 |
| 2018-03-04 22:00:00 | CL | Futures | 54.86 | 54.91 | 54.82 | 54.91 | 6138.0 |
| 2018-03-04 23:00:00 | CL | Futures | 54.91 | 54.96 | 54.8 | 54.8 | 4635.0 |
| 2018-03-04 18:00:00 | GC | Futures | 1753.3 | 1753.9 | 1747.4 | 1752.2 | 4254.0 |
| 2018-03-04 19:00:00 | GC | Futures | 1752.3 | 1754.7 | 1751.3 | 1753.7 | 4292.0 |
| 2018-03-04 20:00:00 | GC | Futures | 1753.5 | 1757.1 | 1753.3 | 1756.2 | 8401.0 |
| 2018-03-04 21:00:00 | GC | Futures | 1756.2 | 1756.8 | 1755.1 | 1755.5 | 5198.0 |
| 2018-03-04 22:00:00 | GC | Futures | 1755.6 | 1757.6 | 1754.9 | 1757.1 | 5905.0 |
| 2018-03-04 23:00:00 | GC | Futures | 1757.2 | 1757.5 | 1756.3 | 1756.8 | 3410.0 |
| 2018-03-04 18:00:00 | ZN | Futures | 120.525709 | 120.650445 | 120.494526 | 120.634853 | 172.0 |
| 2018-03-04 19:00:00 | ZN | Futures | 120.588077 | 120.666037 | 120.572485 | 120.666037 | 113.0 |
| 2018-03-04 20:00:00 | ZN | Futures | 120.681629 | 120.697221 | 120.619261 | 120.697221 | 76.0 |
| 2018-03-04 21:00:00 | ZN | Futures | 120.712813 | 120.728405 | 120.697221 | 120.712813 | 328.0 |
| 2018-03-04 22:00:00 | ZN | Futures | 120.712813 | 120.743997 | 120.681629 | 120.712813 | 199.0 |
| 2018-03-04 23:00:00 | ZN | Futures | 120.712813 | 120.743997 | 120.697221 | 120.743997 | 128.0 |
> showing 36 of 299 rows — these rows as CSV