PREVIEW / futures_1hour / 2019-03-10
file: by_date/futures_1hour/2019/2019-03-10.parquet size: 14 KB rows: 294
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 |
|---|---|---|---|---|---|---|---|
| 2019-03-10 18:00:00 | ES | Futures | 2982.54 | 2983.36 | 2979.28 | 2981.46 | 5481.0 |
| 2019-03-10 19:00:00 | ES | Futures | 2981.73 | 2985.53 | 2980.37 | 2980.64 | 5036.0 |
| 2019-03-10 20:00:00 | ES | Futures | 2980.64 | 2982.0 | 2973.58 | 2974.39 | 9417.0 |
| 2019-03-10 21:00:00 | ES | Futures | 2974.39 | 2983.63 | 2973.04 | 2982.81 | 8369.0 |
| 2019-03-10 22:00:00 | ES | Futures | 2983.08 | 2985.26 | 2981.46 | 2982.81 | 5166.0 |
| 2019-03-10 23:00:00 | ES | Futures | 2982.81 | 2986.07 | 2982.27 | 2984.71 | 3440.0 |
| 2019-03-10 18:00:00 | NQ | Futures | 8207.31 | 8211.4 | 8197.08 | 8205.55 | 1126.0 |
| 2019-03-10 19:00:00 | NQ | Futures | 8206.72 | 8219.58 | 8202.05 | 8202.05 | 1823.0 |
| 2019-03-10 20:00:00 | NQ | Futures | 8202.63 | 8206.72 | 8178.38 | 8181.89 | 2557.0 |
| 2019-03-10 21:00:00 | NQ | Futures | 8181.59 | 8213.73 | 8180.42 | 8212.86 | 2209.0 |
| 2019-03-10 22:00:00 | NQ | Futures | 8212.86 | 8218.12 | 8204.09 | 8209.64 | 1256.0 |
| 2019-03-10 23:00:00 | NQ | Futures | 8209.35 | 8219.58 | 8207.89 | 8217.24 | 1037.0 |
| 2019-03-10 18:00:00 | YM | Futures | 27709.4 | 27735.5 | 27685.5 | 27708.3 | 2267.0 |
| 2019-03-10 19:00:00 | YM | Futures | 27708.3 | 27745.3 | 27687.7 | 27687.7 | 2125.0 |
| 2019-03-10 20:00:00 | YM | Futures | 27688.7 | 27699.6 | 27602.8 | 27611.5 | 3586.0 |
| 2019-03-10 21:00:00 | YM | Futures | 27611.5 | 27684.4 | 27601.7 | 27675.7 | 4107.0 |
| 2019-03-10 22:00:00 | YM | Futures | 27675.7 | 27695.3 | 27647.4 | 27660.5 | 2754.0 |
| 2019-03-10 23:00:00 | YM | Futures | 27660.5 | 27681.1 | 27652.9 | 27663.7 | 1439.0 |
| 2019-03-10 18:00:00 | CL | Futures | 50.52 | 50.62 | 50.42 | 50.62 | 3230.0 |
| 2019-03-10 19:00:00 | CL | Futures | 50.61 | 50.73 | 50.58 | 50.59 | 3485.0 |
| 2019-03-10 20:00:00 | CL | Futures | 50.6 | 50.71 | 50.57 | 50.59 | 3881.0 |
| 2019-03-10 21:00:00 | CL | Futures | 50.59 | 50.76 | 50.5 | 50.72 | 9136.0 |
| 2019-03-10 22:00:00 | CL | Futures | 50.71 | 50.84 | 50.68 | 50.83 | 6299.0 |
| 2019-03-10 23:00:00 | CL | Futures | 50.84 | 50.89 | 50.77 | 50.78 | 5568.0 |
| 2019-03-10 18:00:00 | GC | Futures | 1674.0 | 1674.4 | 1671.8 | 1672.5 | 2688.0 |
| 2019-03-10 19:00:00 | GC | Futures | 1672.4 | 1673.4 | 1672.4 | 1673.3 | 1874.0 |
| 2019-03-10 20:00:00 | GC | Futures | 1673.3 | 1674.7 | 1672.2 | 1674.5 | 2806.0 |
| 2019-03-10 21:00:00 | GC | Futures | 1674.4 | 1674.5 | 1671.5 | 1671.7 | 5549.0 |
| 2019-03-10 22:00:00 | GC | Futures | 1671.7 | 1673.1 | 1670.8 | 1672.4 | 4969.0 |
| 2019-03-10 23:00:00 | GC | Futures | 1672.5 | 1673.0 | 1672.1 | 1673.0 | 2343.0 |
| 2019-03-10 18:00:00 | ZN | Futures | 123.34404 | 123.422583 | 123.34404 | 123.422583 | 5382.0 |
| 2019-03-10 19:00:00 | ZN | Futures | 123.406874 | 123.422583 | 123.359748 | 123.375457 | 9460.0 |
| 2019-03-10 20:00:00 | ZN | Futures | 123.375457 | 123.438291 | 123.359748 | 123.422583 | 12814.0 |
| 2019-03-10 21:00:00 | ZN | Futures | 123.438291 | 123.438291 | 123.296914 | 123.328331 | 25629.0 |
| 2019-03-10 22:00:00 | ZN | Futures | 123.312622 | 123.34404 | 123.312622 | 123.34404 | 5161.0 |
| 2019-03-10 23:00:00 | ZN | Futures | 123.34404 | 123.34404 | 123.296914 | 123.312622 | 4286.0 |
> showing 36 of 294 rows — these rows as CSV