PREVIEW / futures_1hour / 2018-04-08
file: by_date/futures_1hour/2018/2018-04-08.parquet size: 15 KB rows: 304
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-04-08 18:00:00 | ES | Futures | 2846.43 | 2856.8 | 2846.43 | 2852.43 | 16742.0 |
| 2018-04-08 19:00:00 | ES | Futures | 2852.43 | 2855.16 | 2848.34 | 2854.07 | 7129.0 |
| 2018-04-08 20:00:00 | ES | Futures | 2854.07 | 2861.17 | 2853.25 | 2859.26 | 13065.0 |
| 2018-04-08 21:00:00 | ES | Futures | 2859.26 | 2860.9 | 2853.25 | 2856.53 | 13230.0 |
| 2018-04-08 22:00:00 | ES | Futures | 2856.53 | 2858.98 | 2855.98 | 2858.71 | 6112.0 |
| 2018-04-08 23:00:00 | ES | Futures | 2858.98 | 2866.08 | 2858.44 | 2863.9 | 9206.0 |
| 2018-04-08 18:00:00 | NQ | Futures | 7640.1 | 7666.1 | 7639.51 | 7652.51 | 3655.0 |
| 2018-04-08 19:00:00 | NQ | Futures | 7652.8 | 7662.26 | 7636.55 | 7659.9 | 2207.0 |
| 2018-04-08 20:00:00 | NQ | Futures | 7659.01 | 7691.22 | 7657.53 | 7684.43 | 4185.0 |
| 2018-04-08 21:00:00 | NQ | Futures | 7684.43 | 7688.86 | 7665.51 | 7674.38 | 4562.0 |
| 2018-04-08 22:00:00 | NQ | Futures | 7675.27 | 7688.56 | 7672.61 | 7685.9 | 1969.0 |
| 2018-04-08 23:00:00 | NQ | Futures | 7686.5 | 7705.71 | 7685.9 | 7700.09 | 3515.0 |
| 2018-04-08 18:00:00 | YM | Futures | 26008.1 | 26092.8 | 25999.4 | 26047.2 | 2396.0 |
| 2018-04-08 19:00:00 | YM | Futures | 26048.3 | 26075.4 | 26012.4 | 26064.6 | 1741.0 |
| 2018-04-08 20:00:00 | YM | Futures | 26064.6 | 26149.3 | 26055.9 | 26133.0 | 3552.0 |
| 2018-04-08 21:00:00 | YM | Futures | 26133.0 | 26151.4 | 26075.4 | 26089.5 | 5149.0 |
| 2018-04-08 22:00:00 | YM | Futures | 26089.5 | 26123.2 | 26078.7 | 26119.9 | 2937.0 |
| 2018-04-08 23:00:00 | YM | Futures | 26119.9 | 26188.4 | 26110.2 | 26167.7 | 3690.0 |
| 2018-04-08 18:00:00 | CL | Futures | 55.32 | 55.49 | 55.25 | 55.44 | 4649.0 |
| 2018-04-08 19:00:00 | CL | Futures | 55.44 | 55.48 | 55.34 | 55.46 | 2973.0 |
| 2018-04-08 20:00:00 | CL | Futures | 55.46 | 55.58 | 55.42 | 55.57 | 6064.0 |
| 2018-04-08 21:00:00 | CL | Futures | 55.57 | 55.61 | 55.44 | 55.49 | 7621.0 |
| 2018-04-08 22:00:00 | CL | Futures | 55.49 | 55.58 | 55.48 | 55.57 | 3753.0 |
| 2018-04-08 23:00:00 | CL | Futures | 55.57 | 55.64 | 55.55 | 55.59 | 4870.0 |
| 2018-04-08 18:00:00 | GC | Futures | 1762.9 | 1763.5 | 1760.0 | 1761.7 | 3135.0 |
| 2018-04-08 19:00:00 | GC | Futures | 1761.7 | 1762.4 | 1759.2 | 1760.3 | 2717.0 |
| 2018-04-08 20:00:00 | GC | Futures | 1760.1 | 1760.5 | 1758.5 | 1758.8 | 3772.0 |
| 2018-04-08 21:00:00 | GC | Futures | 1758.8 | 1760.0 | 1756.6 | 1758.8 | 7591.0 |
| 2018-04-08 22:00:00 | GC | Futures | 1758.8 | 1761.4 | 1758.7 | 1761.2 | 6217.0 |
| 2018-04-08 23:00:00 | GC | Futures | 1761.2 | 1761.4 | 1759.9 | 1760.1 | 3715.0 |
| 2018-04-08 18:00:00 | ZN | Futures | 121.356705 | 121.372378 | 121.278339 | 121.309686 | 11617.0 |
| 2018-04-08 19:00:00 | ZN | Futures | 121.325359 | 121.325359 | 121.294012 | 121.294012 | 5694.0 |
| 2018-04-08 20:00:00 | ZN | Futures | 121.309686 | 121.325359 | 121.246993 | 121.278339 | 20697.0 |
| 2018-04-08 21:00:00 | ZN | Futures | 121.262666 | 121.294012 | 121.246993 | 121.262666 | 9983.0 |
| 2018-04-08 22:00:00 | ZN | Futures | 121.262666 | 121.262666 | 121.23132 | 121.246993 | 3564.0 |
| 2018-04-08 23:00:00 | ZN | Futures | 121.246993 | 121.262666 | 121.199974 | 121.199974 | 13203.0 |
> showing 36 of 304 rows — these rows as CSV