PREVIEW / futures_1hour / 2018-11-18
file: by_date/futures_1hour/2018/2018-11-18.parquet size: 16 KB rows: 312
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-11-18 18:00:00 | ES | Futures | 2973.48 | 2975.66 | 2968.86 | 2974.03 | 13193.0 |
| 2018-11-18 19:00:00 | ES | Futures | 2974.03 | 2978.38 | 2973.48 | 2974.03 | 9041.0 |
| 2018-11-18 20:00:00 | ES | Futures | 2974.3 | 2977.56 | 2971.31 | 2976.2 | 8927.0 |
| 2018-11-18 21:00:00 | ES | Futures | 2976.2 | 2976.48 | 2971.04 | 2972.4 | 4809.0 |
| 2018-11-18 22:00:00 | ES | Futures | 2972.67 | 2975.66 | 2971.58 | 2975.12 | 4133.0 |
| 2018-11-18 23:00:00 | ES | Futures | 2975.12 | 2975.39 | 2973.21 | 2973.48 | 1881.0 |
| 2018-11-18 18:00:00 | NQ | Futures | 8066.14 | 8068.49 | 8041.21 | 8057.93 | 4686.0 |
| 2018-11-18 19:00:00 | NQ | Futures | 8058.22 | 8074.06 | 8055.58 | 8060.86 | 3809.0 |
| 2018-11-18 20:00:00 | NQ | Futures | 8060.86 | 8077.87 | 8050.89 | 8072.3 | 4755.0 |
| 2018-11-18 21:00:00 | NQ | Futures | 8072.3 | 8074.35 | 8054.99 | 8061.15 | 2925.0 |
| 2018-11-18 22:00:00 | NQ | Futures | 8060.27 | 8069.95 | 8056.75 | 8068.49 | 2082.0 |
| 2018-11-18 23:00:00 | NQ | Futures | 8069.07 | 8069.37 | 8061.15 | 8062.03 | 984.0 |
| 2018-11-18 18:00:00 | YM | Futures | 27581.1 | 27606.1 | 27535.5 | 27583.3 | 2745.0 |
| 2018-11-18 19:00:00 | YM | Futures | 27583.3 | 27623.5 | 27576.8 | 27583.3 | 2226.0 |
| 2018-11-18 20:00:00 | YM | Futures | 27584.4 | 27610.5 | 27558.3 | 27596.3 | 2692.0 |
| 2018-11-18 21:00:00 | YM | Futures | 27596.3 | 27601.8 | 27548.5 | 27563.7 | 1542.0 |
| 2018-11-18 22:00:00 | YM | Futures | 27562.6 | 27588.7 | 27555.0 | 27585.5 | 1297.0 |
| 2018-11-18 23:00:00 | YM | Futures | 27584.4 | 27587.6 | 27559.4 | 27560.5 | 707.0 |
| 2018-11-18 18:00:00 | CL | Futures | 52.28 | 52.6 | 52.17 | 52.53 | 5420.0 |
| 2018-11-18 19:00:00 | CL | Futures | 52.53 | 52.59 | 52.49 | 52.52 | 2510.0 |
| 2018-11-18 20:00:00 | CL | Futures | 52.51 | 52.71 | 52.41 | 52.65 | 7825.0 |
| 2018-11-18 21:00:00 | CL | Futures | 52.65 | 52.76 | 52.51 | 52.6 | 7306.0 |
| 2018-11-18 22:00:00 | CL | Futures | 52.6 | 52.65 | 52.54 | 52.56 | 4184.0 |
| 2018-11-18 23:00:00 | CL | Futures | 52.56 | 52.62 | 52.53 | 52.58 | 2321.0 |
| 2018-11-18 18:00:00 | GC | Futures | 1592.9 | 1593.8 | 1592.2 | 1593.5 | 1719.0 |
| 2018-11-18 19:00:00 | GC | Futures | 1593.4 | 1594.3 | 1592.7 | 1593.5 | 2651.0 |
| 2018-11-18 20:00:00 | GC | Futures | 1593.5 | 1595.0 | 1592.7 | 1593.1 | 4478.0 |
| 2018-11-18 21:00:00 | GC | Futures | 1593.1 | 1593.3 | 1591.4 | 1592.1 | 3615.0 |
| 2018-11-18 22:00:00 | GC | Futures | 1592.0 | 1592.6 | 1590.7 | 1590.9 | 2786.0 |
| 2018-11-18 23:00:00 | GC | Futures | 1590.8 | 1591.3 | 1589.7 | 1589.9 | 2542.0 |
| 2018-11-18 18:00:00 | ZN | Futures | 120.117495 | 120.180449 | 120.101756 | 120.148972 | 24597.0 |
| 2018-11-18 19:00:00 | ZN | Futures | 120.148972 | 120.148972 | 120.070279 | 120.133233 | 21591.0 |
| 2018-11-18 20:00:00 | ZN | Futures | 120.117495 | 120.164711 | 120.101756 | 120.117495 | 17277.0 |
| 2018-11-18 21:00:00 | ZN | Futures | 120.117495 | 120.133233 | 120.101756 | 120.117495 | 9935.0 |
| 2018-11-18 22:00:00 | ZN | Futures | 120.117495 | 120.117495 | 120.070279 | 120.086017 | 9893.0 |
| 2018-11-18 23:00:00 | ZN | Futures | 120.086017 | 120.101756 | 120.070279 | 120.086017 | 3181.0 |
> showing 36 of 312 rows — these rows as CSV