PREVIEW / futures_1hour / 2018-09-09
file: by_date/futures_1hour/2018/2018-09-09.parquet size: 14 KB rows: 285
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-09-09 18:00:00 | ES | Futures | 3132.0 | 3135.27 | 3131.46 | 3134.45 | 4543.0 |
| 2018-09-09 19:00:00 | ES | Futures | 3134.72 | 3135.27 | 3131.46 | 3133.63 | 3794.0 |
| 2018-09-09 20:00:00 | ES | Futures | 3133.63 | 3137.99 | 3133.63 | 3137.99 | 9393.0 |
| 2018-09-09 21:00:00 | ES | Futures | 3137.99 | 3140.72 | 3137.18 | 3137.72 | 14743.0 |
| 2018-09-09 22:00:00 | ES | Futures | 3137.99 | 3140.45 | 3136.63 | 3139.08 | 8166.0 |
| 2018-09-09 23:00:00 | ES | Futures | 3139.08 | 3140.72 | 3137.45 | 3138.54 | 4902.0 |
| 2018-09-09 18:00:00 | NQ | Futures | 8753.64 | 8769.83 | 8752.46 | 8767.77 | 2171.0 |
| 2018-09-09 19:00:00 | NQ | Futures | 8767.48 | 8771.89 | 8757.76 | 8763.95 | 1651.0 |
| 2018-09-09 20:00:00 | NQ | Futures | 8764.24 | 8778.67 | 8763.65 | 8777.19 | 4289.0 |
| 2018-09-09 21:00:00 | NQ | Futures | 8777.19 | 8787.79 | 8774.25 | 8777.78 | 4809.0 |
| 2018-09-09 22:00:00 | NQ | Futures | 8777.19 | 8786.91 | 8772.48 | 8781.02 | 4246.0 |
| 2018-09-09 23:00:00 | NQ | Futures | 8781.02 | 8785.73 | 8776.31 | 8780.14 | 2306.0 |
| 2018-09-09 18:00:00 | YM | Futures | 28200.4 | 28241.7 | 28200.4 | 28230.8 | 809.0 |
| 2018-09-09 19:00:00 | YM | Futures | 28230.8 | 28246.1 | 28210.2 | 28228.7 | 1131.0 |
| 2018-09-09 20:00:00 | YM | Futures | 28229.7 | 28265.6 | 28227.6 | 28263.4 | 1995.0 |
| 2018-09-09 21:00:00 | YM | Futures | 28262.4 | 28286.3 | 28255.8 | 28260.2 | 2731.0 |
| 2018-09-09 22:00:00 | YM | Futures | 28259.1 | 28279.8 | 28247.1 | 28270.0 | 1710.0 |
| 2018-09-09 23:00:00 | YM | Futures | 28270.0 | 28280.8 | 28253.7 | 28262.4 | 1346.0 |
| 2018-09-09 18:00:00 | CL | Futures | 62.27 | 62.59 | 62.27 | 62.51 | 5901.0 |
| 2018-09-09 19:00:00 | CL | Futures | 62.5 | 62.56 | 62.45 | 62.53 | 1882.0 |
| 2018-09-09 20:00:00 | CL | Futures | 62.53 | 62.57 | 62.41 | 62.53 | 5053.0 |
| 2018-09-09 21:00:00 | CL | Futures | 62.53 | 62.53 | 62.39 | 62.43 | 5478.0 |
| 2018-09-09 22:00:00 | CL | Futures | 62.43 | 62.69 | 62.43 | 62.63 | 7102.0 |
| 2018-09-09 23:00:00 | CL | Futures | 62.63 | 62.64 | 62.57 | 62.61 | 2674.0 |
| 2018-09-09 18:00:00 | GC | Futures | 1564.3 | 1566.2 | 1563.8 | 1564.1 | 2436.0 |
| 2018-09-09 19:00:00 | GC | Futures | 1564.1 | 1565.6 | 1563.9 | 1565.4 | 2205.0 |
| 2018-09-09 20:00:00 | GC | Futures | 1565.4 | 1565.5 | 1562.6 | 1564.6 | 5905.0 |
| 2018-09-09 21:00:00 | GC | Futures | 1564.5 | 1565.6 | 1562.6 | 1562.9 | 9747.0 |
| 2018-09-09 22:00:00 | GC | Futures | 1562.9 | 1564.2 | 1562.4 | 1563.2 | 5853.0 |
| 2018-09-09 23:00:00 | GC | Futures | 1563.0 | 1564.3 | 1562.8 | 1562.9 | 3659.0 |
| 2018-09-09 18:00:00 | ZN | Futures | 120.479484 | 120.495223 | 120.463745 | 120.495223 | 6417.0 |
| 2018-09-09 19:00:00 | ZN | Futures | 120.495223 | 120.542439 | 120.463745 | 120.5267 | 7923.0 |
| 2018-09-09 20:00:00 | ZN | Futures | 120.5267 | 120.5267 | 120.463745 | 120.495223 | 13188.0 |
| 2018-09-09 21:00:00 | ZN | Futures | 120.495223 | 120.5267 | 120.495223 | 120.510961 | 11036.0 |
| 2018-09-09 22:00:00 | ZN | Futures | 120.510961 | 120.542439 | 120.510961 | 120.5267 | 5344.0 |
| 2018-09-09 23:00:00 | ZN | Futures | 120.5267 | 120.542439 | 120.5267 | 120.542439 | 1431.0 |
> showing 36 of 285 rows — these rows as CSV