PREVIEW / futures_1hour / 2018-02-04
file: by_date/futures_1hour/2018/2018-02-04.parquet size: 16 KB rows: 307
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-02-04 18:00:00 | ES | Futures | 3014.26 | 3014.26 | 2988.02 | 2996.5 | 70291.0 |
| 2018-02-04 19:00:00 | ES | Futures | 2996.77 | 3003.6 | 2992.67 | 2998.41 | 29618.0 |
| 2018-02-04 20:00:00 | ES | Futures | 2998.41 | 3004.97 | 2994.04 | 3002.51 | 23240.0 |
| 2018-02-04 21:00:00 | ES | Futures | 3002.24 | 3002.24 | 2997.59 | 2999.23 | 11052.0 |
| 2018-02-04 22:00:00 | ES | Futures | 2998.96 | 3004.42 | 2998.96 | 3003.6 | 10929.0 |
| 2018-02-04 23:00:00 | ES | Futures | 3003.33 | 3008.52 | 3003.06 | 3006.61 | 14208.0 |
| 2018-02-04 18:00:00 | NQ | Futures | 8010.71 | 8019.02 | 7960.59 | 7980.76 | 12706.0 |
| 2018-02-04 19:00:00 | NQ | Futures | 7980.76 | 7995.59 | 7967.11 | 7986.69 | 7159.0 |
| 2018-02-04 20:00:00 | NQ | Futures | 7986.69 | 8000.33 | 7970.97 | 7992.62 | 5159.0 |
| 2018-02-04 21:00:00 | NQ | Futures | 7992.62 | 7992.92 | 7977.2 | 7983.43 | 5857.0 |
| 2018-02-04 22:00:00 | NQ | Futures | 7983.43 | 7996.18 | 7983.43 | 7992.62 | 3091.0 |
| 2018-02-04 23:00:00 | NQ | Futures | 7993.51 | 8006.27 | 7992.92 | 8000.63 | 2415.0 |
| 2018-02-04 18:00:00 | YM | Futures | 27640.5 | 27650.2 | 27330.7 | 27444.8 | 12979.0 |
| 2018-02-04 19:00:00 | YM | Futures | 27441.6 | 27498.1 | 27392.6 | 27441.6 | 8875.0 |
| 2018-02-04 20:00:00 | YM | Futures | 27443.7 | 27498.1 | 27414.4 | 27479.6 | 3912.0 |
| 2018-02-04 21:00:00 | YM | Futures | 27478.5 | 27479.6 | 27426.3 | 27439.4 | 3308.0 |
| 2018-02-04 22:00:00 | YM | Futures | 27440.5 | 27489.4 | 27437.2 | 27476.3 | 2049.0 |
| 2018-02-04 23:00:00 | YM | Futures | 27477.4 | 27524.2 | 27474.2 | 27506.8 | 2174.0 |
| 2018-02-04 18:00:00 | CL | Futures | 57.82 | 57.82 | 57.61 | 57.74 | 4482.0 |
| 2018-02-04 19:00:00 | CL | Futures | 57.74 | 57.74 | 57.52 | 57.65 | 7816.0 |
| 2018-02-04 20:00:00 | CL | Futures | 57.65 | 57.72 | 57.56 | 57.66 | 8186.0 |
| 2018-02-04 21:00:00 | CL | Futures | 57.65 | 57.65 | 57.39 | 57.44 | 8614.0 |
| 2018-02-04 22:00:00 | CL | Futures | 57.44 | 57.57 | 57.41 | 57.52 | 4220.0 |
| 2018-02-04 23:00:00 | CL | Futures | 57.52 | 57.58 | 57.5 | 57.53 | 2373.0 |
| 2018-02-04 18:00:00 | GC | Futures | 1766.1 | 1768.9 | 1762.8 | 1767.2 | 6696.0 |
| 2018-02-04 19:00:00 | GC | Futures | 1767.2 | 1768.2 | 1764.8 | 1768.2 | 6888.0 |
| 2018-02-04 20:00:00 | GC | Futures | 1768.2 | 1768.5 | 1763.1 | 1765.2 | 10329.0 |
| 2018-02-04 21:00:00 | GC | Futures | 1765.2 | 1765.4 | 1762.1 | 1764.6 | 7664.0 |
| 2018-02-04 22:00:00 | GC | Futures | 1764.8 | 1766.0 | 1763.5 | 1763.9 | 3716.0 |
| 2018-02-04 23:00:00 | GC | Futures | 1763.9 | 1764.9 | 1763.3 | 1764.1 | 3165.0 |
| 2018-02-04 18:00:00 | ZN | Futures | 120.556893 | 120.603669 | 120.510118 | 120.556893 | 27055.0 |
| 2018-02-04 19:00:00 | ZN | Futures | 120.541301 | 120.541301 | 120.385382 | 120.416566 | 56968.0 |
| 2018-02-04 20:00:00 | ZN | Futures | 120.432158 | 120.494526 | 120.416566 | 120.463342 | 21203.0 |
| 2018-02-04 21:00:00 | ZN | Futures | 120.463342 | 120.463342 | 120.416566 | 120.463342 | 18278.0 |
| 2018-02-04 22:00:00 | ZN | Futures | 120.44775 | 120.494526 | 120.432158 | 120.463342 | 11827.0 |
| 2018-02-04 23:00:00 | ZN | Futures | 120.478934 | 120.478934 | 120.416566 | 120.416566 | 12589.0 |
> showing 36 of 307 rows — these rows as CSV