PREVIEW / futures_1hour / 2018-06-10
file: by_date/futures_1hour/2018/2018-06-10.parquet size: 14 KB rows: 282
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-06-10 18:00:00 | ES | Futures | 3024.91 | 3028.46 | 3024.37 | 3026.55 | 5207.0 |
| 2018-06-10 19:00:00 | ES | Futures | 3026.55 | 3027.91 | 3024.37 | 3027.64 | 2278.0 |
| 2018-06-10 20:00:00 | ES | Futures | 3027.91 | 3031.46 | 3027.64 | 3030.64 | 3477.0 |
| 2018-06-10 21:00:00 | ES | Futures | 3030.92 | 3032.28 | 3027.91 | 3030.64 | 3974.0 |
| 2018-06-10 22:00:00 | ES | Futures | 3030.92 | 3031.46 | 3029.01 | 3031.19 | 2608.0 |
| 2018-06-10 23:00:00 | ES | Futures | 3031.46 | 3032.01 | 3030.64 | 3032.01 | 1752.0 |
| 2018-06-10 18:00:00 | NQ | Futures | 8434.49 | 8443.94 | 8422.67 | 8435.67 | 1090.0 |
| 2018-06-10 19:00:00 | NQ | Futures | 8435.67 | 8439.51 | 8426.21 | 8438.33 | 765.0 |
| 2018-06-10 20:00:00 | NQ | Futures | 8438.92 | 8449.85 | 8436.56 | 8447.2 | 920.0 |
| 2018-06-10 21:00:00 | NQ | Futures | 8447.2 | 8451.92 | 8432.42 | 8443.65 | 791.0 |
| 2018-06-10 22:00:00 | NQ | Futures | 8443.06 | 8446.01 | 8438.62 | 8445.72 | 523.0 |
| 2018-06-10 23:00:00 | NQ | Futures | 8445.72 | 8448.67 | 8443.06 | 8447.49 | 399.0 |
| 2018-06-10 18:00:00 | YM | Futures | 27504.6 | 27504.6 | 27457.9 | 27482.9 | 1239.0 |
| 2018-06-10 19:00:00 | YM | Futures | 27482.9 | 27501.4 | 27462.2 | 27500.3 | 782.0 |
| 2018-06-10 20:00:00 | YM | Futures | 27500.3 | 27542.7 | 27499.2 | 27532.9 | 1941.0 |
| 2018-06-10 21:00:00 | YM | Futures | 27535.1 | 27548.1 | 27501.4 | 27528.5 | 1425.0 |
| 2018-06-10 22:00:00 | YM | Futures | 27531.8 | 27543.8 | 27514.4 | 27541.6 | 866.0 |
| 2018-06-10 23:00:00 | YM | Futures | 27542.7 | 27548.1 | 27532.9 | 27545.9 | 409.0 |
| 2018-06-10 18:00:00 | CL | Futures | 58.62 | 58.64 | 58.39 | 58.62 | 2330.0 |
| 2018-06-10 19:00:00 | CL | Futures | 58.62 | 58.63 | 58.53 | 58.6 | 1358.0 |
| 2018-06-10 20:00:00 | CL | Futures | 58.6 | 58.7 | 58.59 | 58.67 | 3120.0 |
| 2018-06-10 21:00:00 | CL | Futures | 58.67 | 58.75 | 58.62 | 58.7 | 4350.0 |
| 2018-06-10 22:00:00 | CL | Futures | 58.7 | 58.78 | 58.68 | 58.76 | 3677.0 |
| 2018-06-10 23:00:00 | CL | Futures | 58.76 | 58.76 | 58.7 | 58.71 | 1617.0 |
| 2018-06-10 18:00:00 | GC | Futures | 1711.5 | 1712.6 | 1709.9 | 1710.7 | 1571.0 |
| 2018-06-10 19:00:00 | GC | Futures | 1710.6 | 1712.0 | 1710.6 | 1711.2 | 1817.0 |
| 2018-06-10 20:00:00 | GC | Futures | 1711.2 | 1711.5 | 1710.2 | 1711.2 | 3641.0 |
| 2018-06-10 21:00:00 | GC | Futures | 1711.2 | 1714.4 | 1710.7 | 1713.1 | 8812.0 |
| 2018-06-10 22:00:00 | GC | Futures | 1713.1 | 1713.9 | 1710.9 | 1711.9 | 6371.0 |
| 2018-06-10 23:00:00 | GC | Futures | 1711.8 | 1712.2 | 1711.1 | 1711.4 | 2657.0 |
| 2018-06-10 18:00:00 | ZN | Futures | 120.25946 | 120.306608 | 120.180879 | 120.212312 | 9448.0 |
| 2018-06-10 19:00:00 | ZN | Futures | 120.212312 | 120.243744 | 120.165163 | 120.180879 | 7769.0 |
| 2018-06-10 20:00:00 | ZN | Futures | 120.180879 | 120.180879 | 120.118015 | 120.149447 | 18181.0 |
| 2018-06-10 21:00:00 | ZN | Futures | 120.149447 | 120.165163 | 120.086583 | 120.118015 | 16279.0 |
| 2018-06-10 22:00:00 | ZN | Futures | 120.118015 | 120.149447 | 120.102299 | 120.118015 | 6720.0 |
| 2018-06-10 23:00:00 | ZN | Futures | 120.118015 | 120.149447 | 120.118015 | 120.133731 | 2436.0 |
> showing 36 of 282 rows — these rows as CSV