PREVIEW / futures_1hour / 2018-03-25
file: by_date/futures_1hour/2018/2018-03-25.parquet size: 15 KB rows: 301
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-03-25 18:00:00 | ES | Futures | 2832.79 | 2843.43 | 2828.42 | 2832.24 | 29851.0 |
| 2018-03-25 19:00:00 | ES | Futures | 2832.24 | 2844.79 | 2831.97 | 2843.43 | 14961.0 |
| 2018-03-25 20:00:00 | ES | Futures | 2842.88 | 2848.34 | 2840.15 | 2847.52 | 17788.0 |
| 2018-03-25 21:00:00 | ES | Futures | 2847.52 | 2854.07 | 2845.61 | 2853.8 | 18129.0 |
| 2018-03-25 22:00:00 | ES | Futures | 2854.07 | 2854.07 | 2847.25 | 2848.89 | 10182.0 |
| 2018-03-25 23:00:00 | ES | Futures | 2848.89 | 2852.43 | 2844.79 | 2851.34 | 7308.0 |
| 2018-03-25 18:00:00 | NQ | Futures | 7742.65 | 7753.88 | 7713.39 | 7728.46 | 5547.0 |
| 2018-03-25 19:00:00 | NQ | Futures | 7728.17 | 7772.2 | 7726.1 | 7765.7 | 4645.0 |
| 2018-03-25 20:00:00 | NQ | Futures | 7765.4 | 7788.16 | 7759.2 | 7785.5 | 6606.0 |
| 2018-03-25 21:00:00 | NQ | Futures | 7785.5 | 7815.05 | 7780.77 | 7813.87 | 9626.0 |
| 2018-03-25 22:00:00 | NQ | Futures | 7813.87 | 7816.23 | 7788.45 | 7795.25 | 5413.0 |
| 2018-03-25 23:00:00 | NQ | Futures | 7794.66 | 7809.73 | 7780.47 | 7806.48 | 4358.0 |
| 2018-03-25 18:00:00 | YM | Futures | 25639.9 | 25733.3 | 25576.9 | 25631.2 | 4521.0 |
| 2018-03-25 19:00:00 | YM | Futures | 25632.3 | 25723.5 | 25624.7 | 25705.1 | 2517.0 |
| 2018-03-25 20:00:00 | YM | Futures | 25704.0 | 25757.2 | 25679.0 | 25750.7 | 5673.0 |
| 2018-03-25 21:00:00 | YM | Futures | 25751.8 | 25802.8 | 25721.4 | 25800.7 | 5411.0 |
| 2018-03-25 22:00:00 | YM | Futures | 25799.6 | 25799.6 | 25723.5 | 25740.9 | 3928.0 |
| 2018-03-25 23:00:00 | YM | Futures | 25739.8 | 25784.4 | 25701.8 | 25773.5 | 3813.0 |
| 2018-03-25 18:00:00 | CL | Futures | 58.79 | 58.96 | 58.57 | 58.76 | 6596.0 |
| 2018-03-25 19:00:00 | CL | Futures | 58.75 | 59.37 | 58.7 | 59.25 | 15438.0 |
| 2018-03-25 20:00:00 | CL | Futures | 59.24 | 59.27 | 59.08 | 59.15 | 7070.0 |
| 2018-03-25 21:00:00 | CL | Futures | 59.15 | 59.29 | 58.76 | 58.95 | 25521.0 |
| 2018-03-25 22:00:00 | CL | Futures | 58.95 | 58.98 | 58.4 | 58.47 | 21895.0 |
| 2018-03-25 23:00:00 | CL | Futures | 58.47 | 58.64 | 58.44 | 58.6 | 7023.0 |
| 2018-03-25 18:00:00 | GC | Futures | 1782.5 | 1788.1 | 1782.5 | 1786.7 | 5157.0 |
| 2018-03-25 19:00:00 | GC | Futures | 1786.9 | 1787.0 | 1784.2 | 1784.4 | 3784.0 |
| 2018-03-25 20:00:00 | GC | Futures | 1784.4 | 1785.8 | 1780.9 | 1781.6 | 7729.0 |
| 2018-03-25 21:00:00 | GC | Futures | 1781.6 | 1783.4 | 1781.3 | 1782.5 | 7861.0 |
| 2018-03-25 22:00:00 | GC | Futures | 1782.5 | 1783.6 | 1781.9 | 1783.2 | 4806.0 |
| 2018-03-25 23:00:00 | GC | Futures | 1783.3 | 1785.6 | 1783.3 | 1783.8 | 5039.0 |
| 2018-03-25 18:00:00 | ZN | Futures | 121.011897 | 121.090262 | 121.011897 | 121.090262 | 14275.0 |
| 2018-03-25 19:00:00 | ZN | Futures | 121.090262 | 121.105935 | 120.996224 | 121.011897 | 12225.0 |
| 2018-03-25 20:00:00 | ZN | Futures | 121.02757 | 121.058916 | 120.996224 | 121.011897 | 17808.0 |
| 2018-03-25 21:00:00 | ZN | Futures | 121.011897 | 121.02757 | 120.949205 | 120.964878 | 22246.0 |
| 2018-03-25 22:00:00 | ZN | Futures | 120.964878 | 120.980551 | 120.933531 | 120.964878 | 15892.0 |
| 2018-03-25 23:00:00 | ZN | Futures | 120.964878 | 120.980551 | 120.949205 | 120.949205 | 5752.0 |
> showing 36 of 301 rows — these rows as CSV