PREVIEW / futures_1hour / 2019-02-17
file: by_date/futures_1hour/2019/2019-02-17.parquet size: 15 KB rows: 303
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 |
|---|---|---|---|---|---|---|---|
| 2019-02-17 18:00:00 | ES | Futures | 3016.76 | 3022.74 | 3015.95 | 3018.66 | 14265.0 |
| 2019-02-17 19:00:00 | ES | Futures | 3018.39 | 3018.66 | 3013.77 | 3014.59 | 8326.0 |
| 2019-02-17 20:00:00 | ES | Futures | 3014.86 | 3018.12 | 3013.77 | 3016.76 | 8365.0 |
| 2019-02-17 21:00:00 | ES | Futures | 3017.03 | 3018.39 | 3016.22 | 3018.12 | 3755.0 |
| 2019-02-17 22:00:00 | ES | Futures | 3018.12 | 3020.56 | 3017.58 | 3017.58 | 4379.0 |
| 2019-02-17 23:00:00 | ES | Futures | 3017.85 | 3018.12 | 3016.22 | 3017.3 | 2851.0 |
| 2019-02-17 18:00:00 | NQ | Futures | 8255.81 | 8273.63 | 8249.67 | 8259.02 | 3899.0 |
| 2019-02-17 19:00:00 | NQ | Futures | 8259.02 | 8259.02 | 8246.75 | 8250.26 | 3933.0 |
| 2019-02-17 20:00:00 | NQ | Futures | 8250.26 | 8263.41 | 8248.21 | 8261.36 | 4315.0 |
| 2019-02-17 21:00:00 | NQ | Futures | 8261.95 | 8268.67 | 8256.1 | 8267.79 | 3331.0 |
| 2019-02-17 22:00:00 | NQ | Futures | 8267.79 | 8277.43 | 8263.41 | 8263.99 | 2580.0 |
| 2019-02-17 23:00:00 | NQ | Futures | 8263.99 | 8266.04 | 8258.73 | 8262.24 | 2002.0 |
| 2019-02-17 18:00:00 | YM | Futures | 28104.6 | 28174.1 | 28102.4 | 28140.4 | 3055.0 |
| 2019-02-17 19:00:00 | YM | Futures | 28139.3 | 28139.3 | 28089.4 | 28106.8 | 2323.0 |
| 2019-02-17 20:00:00 | YM | Futures | 28105.7 | 28137.2 | 28091.6 | 28125.2 | 2571.0 |
| 2019-02-17 21:00:00 | YM | Futures | 28126.3 | 28138.3 | 28115.5 | 28132.8 | 1176.0 |
| 2019-02-17 22:00:00 | YM | Futures | 28133.9 | 28158.9 | 28130.7 | 28130.7 | 1551.0 |
| 2019-02-17 23:00:00 | YM | Futures | 28130.7 | 28133.9 | 28114.4 | 28131.7 | 1403.0 |
| 2019-02-17 18:00:00 | CL | Futures | 50.59 | 50.81 | 50.55 | 50.76 | 4549.0 |
| 2019-02-17 19:00:00 | CL | Futures | 50.75 | 50.76 | 50.65 | 50.69 | 2860.0 |
| 2019-02-17 20:00:00 | CL | Futures | 50.69 | 50.93 | 50.64 | 50.75 | 12882.0 |
| 2019-02-17 21:00:00 | CL | Futures | 50.75 | 50.76 | 50.56 | 50.67 | 7424.0 |
| 2019-02-17 22:00:00 | CL | Futures | 50.68 | 50.73 | 50.6 | 50.61 | 3919.0 |
| 2019-02-17 23:00:00 | CL | Futures | 50.6 | 50.68 | 50.59 | 50.67 | 1994.0 |
| 2019-02-17 18:00:00 | GC | Futures | 1708.6 | 1708.6 | 1707.0 | 1707.7 | 2880.0 |
| 2019-02-17 19:00:00 | GC | Futures | 1707.7 | 1709.1 | 1707.3 | 1708.3 | 3239.0 |
| 2019-02-17 20:00:00 | GC | Futures | 1708.2 | 1712.5 | 1708.2 | 1712.5 | 7173.0 |
| 2019-02-17 21:00:00 | GC | Futures | 1712.3 | 1712.7 | 1711.2 | 1712.2 | 4762.0 |
| 2019-02-17 22:00:00 | GC | Futures | 1712.2 | 1713.1 | 1711.8 | 1712.1 | 3928.0 |
| 2019-02-17 23:00:00 | GC | Futures | 1712.2 | 1712.2 | 1710.7 | 1710.8 | 2285.0 |
| 2019-02-17 18:00:00 | ZN | Futures | 122.950613 | 122.966354 | 122.903391 | 122.903391 | 6166.0 |
| 2019-02-17 19:00:00 | ZN | Futures | 122.919132 | 122.966354 | 122.903391 | 122.934873 | 7698.0 |
| 2019-02-17 20:00:00 | ZN | Futures | 122.950613 | 122.966354 | 122.934873 | 122.950613 | 4519.0 |
| 2019-02-17 21:00:00 | ZN | Futures | 122.950613 | 122.950613 | 122.934873 | 122.950613 | 794.0 |
| 2019-02-17 22:00:00 | ZN | Futures | 122.950613 | 122.950613 | 122.934873 | 122.934873 | 1385.0 |
| 2019-02-17 23:00:00 | ZN | Futures | 122.950613 | 122.966354 | 122.950613 | 122.966354 | 1169.0 |
> showing 36 of 303 rows — these rows as CSV