PREVIEW / futures_1hour / 2018-05-06
file: by_date/futures_1hour/2018/2018-05-06.parquet size: 15 KB rows: 298
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-05-06 18:00:00 | ES | Futures | 2906.74 | 2911.93 | 2905.11 | 2910.29 | 6808.0 |
| 2018-05-06 19:00:00 | ES | Futures | 2910.29 | 2917.66 | 2909.75 | 2914.11 | 8048.0 |
| 2018-05-06 20:00:00 | ES | Futures | 2913.84 | 2914.11 | 2910.29 | 2913.02 | 8007.0 |
| 2018-05-06 21:00:00 | ES | Futures | 2913.29 | 2913.84 | 2908.65 | 2912.75 | 8621.0 |
| 2018-05-06 22:00:00 | ES | Futures | 2912.75 | 2917.39 | 2912.2 | 2916.3 | 6840.0 |
| 2018-05-06 23:00:00 | ES | Futures | 2916.02 | 2917.66 | 2915.2 | 2915.75 | 4700.0 |
| 2018-05-06 18:00:00 | NQ | Futures | 8013.65 | 8032.56 | 8005.67 | 8019.56 | 2444.0 |
| 2018-05-06 19:00:00 | NQ | Futures | 8020.15 | 8044.09 | 8018.38 | 8034.93 | 2995.0 |
| 2018-05-06 20:00:00 | NQ | Futures | 8034.63 | 8042.61 | 8029.31 | 8037.59 | 4382.0 |
| 2018-05-06 21:00:00 | NQ | Futures | 8038.47 | 8048.23 | 8026.65 | 8042.02 | 4844.0 |
| 2018-05-06 22:00:00 | NQ | Futures | 8042.32 | 8062.12 | 8040.25 | 8057.09 | 4258.0 |
| 2018-05-06 23:00:00 | NQ | Futures | 8056.8 | 8065.96 | 8055.91 | 8062.71 | 2847.0 |
| 2018-05-06 18:00:00 | YM | Futures | 26310.0 | 26365.4 | 26292.6 | 26355.6 | 1593.0 |
| 2018-05-06 19:00:00 | YM | Futures | 26356.7 | 26430.5 | 26340.4 | 26390.4 | 1957.0 |
| 2018-05-06 20:00:00 | YM | Futures | 26390.4 | 26396.9 | 26360.0 | 26386.0 | 2769.0 |
| 2018-05-06 21:00:00 | YM | Futures | 26387.1 | 26391.5 | 26339.3 | 26366.5 | 3019.0 |
| 2018-05-06 22:00:00 | YM | Futures | 26367.6 | 26412.1 | 26364.3 | 26398.0 | 1961.0 |
| 2018-05-06 23:00:00 | YM | Futures | 26396.9 | 26418.6 | 26392.5 | 26396.9 | 1796.0 |
| 2018-05-06 18:00:00 | CL | Futures | 62.43 | 62.48 | 62.35 | 62.39 | 3780.0 |
| 2018-05-06 19:00:00 | CL | Futures | 62.38 | 62.42 | 62.35 | 62.38 | 2216.0 |
| 2018-05-06 20:00:00 | CL | Futures | 62.38 | 62.42 | 62.31 | 62.33 | 6320.0 |
| 2018-05-06 21:00:00 | CL | Futures | 62.34 | 62.45 | 62.31 | 62.42 | 11488.0 |
| 2018-05-06 22:00:00 | CL | Futures | 62.43 | 62.78 | 62.42 | 62.72 | 19522.0 |
| 2018-05-06 23:00:00 | CL | Futures | 62.72 | 63.18 | 62.71 | 62.96 | 24535.0 |
| 2018-05-06 18:00:00 | GC | Futures | 1734.3 | 1734.3 | 1733.0 | 1733.4 | 1835.0 |
| 2018-05-06 19:00:00 | GC | Futures | 1733.5 | 1734.0 | 1732.5 | 1733.0 | 3082.0 |
| 2018-05-06 20:00:00 | GC | Futures | 1733.0 | 1737.6 | 1732.2 | 1736.7 | 12242.0 |
| 2018-05-06 21:00:00 | GC | Futures | 1736.8 | 1739.3 | 1736.1 | 1736.5 | 11065.0 |
| 2018-05-06 22:00:00 | GC | Futures | 1736.7 | 1738.0 | 1736.0 | 1737.5 | 4883.0 |
| 2018-05-06 23:00:00 | GC | Futures | 1737.6 | 1738.1 | 1736.7 | 1736.8 | 4281.0 |
| 2018-05-06 18:00:00 | ZN | Futures | 119.993146 | 120.008819 | 119.977473 | 120.008819 | 4449.0 |
| 2018-05-06 19:00:00 | ZN | Futures | 120.008819 | 120.024492 | 119.977473 | 120.008819 | 3620.0 |
| 2018-05-06 20:00:00 | ZN | Futures | 120.008819 | 120.071512 | 120.008819 | 120.055839 | 8278.0 |
| 2018-05-06 21:00:00 | ZN | Futures | 120.055839 | 120.087185 | 120.040166 | 120.055839 | 10897.0 |
| 2018-05-06 22:00:00 | ZN | Futures | 120.040166 | 120.055839 | 119.993146 | 120.024492 | 3197.0 |
| 2018-05-06 23:00:00 | ZN | Futures | 120.008819 | 120.024492 | 119.993146 | 120.024492 | 4784.0 |
> showing 36 of 298 rows — these rows as CSV