PREVIEW / futures_1hour / 2016-01-03
file: by_date/futures_1hour/2016/2016-01-03.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 |
|---|---|---|---|---|---|---|---|
| 2016-01-03 18:00:00 | ES | Futures | 2190.25 | 2196.43 | 2189.98 | 2192.93 | 10915.0 |
| 2016-01-03 19:00:00 | ES | Futures | 2193.2 | 2195.35 | 2192.67 | 2195.08 | 5204.0 |
| 2016-01-03 20:00:00 | ES | Futures | 2195.35 | 2195.89 | 2188.64 | 2189.17 | 11246.0 |
| 2016-01-03 21:00:00 | ES | Futures | 2189.17 | 2189.17 | 2177.35 | 2181.11 | 20977.0 |
| 2016-01-03 22:00:00 | ES | Futures | 2181.38 | 2184.87 | 2178.69 | 2180.04 | 9782.0 |
| 2016-01-03 23:00:00 | ES | Futures | 2180.04 | 2180.84 | 2168.75 | 2169.02 | 14220.0 |
| 2016-01-03 18:00:00 | NQ | Futures | 5454.63 | 5471.55 | 5454.63 | 5464.13 | 1559.0 |
| 2016-01-03 19:00:00 | NQ | Futures | 5463.83 | 5468.58 | 5463.24 | 5467.99 | 808.0 |
| 2016-01-03 20:00:00 | NQ | Futures | 5467.99 | 5470.07 | 5451.07 | 5452.85 | 1903.0 |
| 2016-01-03 21:00:00 | NQ | Futures | 5452.25 | 5452.25 | 5421.08 | 5431.47 | 4088.0 |
| 2016-01-03 22:00:00 | NQ | Futures | 5430.58 | 5439.49 | 5423.15 | 5427.31 | 2045.0 |
| 2016-01-03 23:00:00 | NQ | Futures | 5426.72 | 5428.5 | 5394.05 | 5395.54 | 3305.0 |
| 2016-01-03 18:00:00 | YM | Futures | 18465.5 | 18520.9 | 18460.2 | 18495.3 | 1267.0 |
| 2016-01-03 19:00:00 | YM | Futures | 18497.4 | 18510.2 | 18493.2 | 18507.0 | 826.0 |
| 2016-01-03 20:00:00 | YM | Futures | 18509.1 | 18515.5 | 18453.8 | 18459.1 | 2028.0 |
| 2016-01-03 21:00:00 | YM | Futures | 18459.1 | 18459.1 | 18364.4 | 18391.0 | 4045.0 |
| 2016-01-03 22:00:00 | YM | Futures | 18388.9 | 18418.7 | 18375.0 | 18384.6 | 1966.0 |
| 2016-01-03 23:00:00 | YM | Futures | 18384.6 | 18391.0 | 18290.9 | 18290.9 | 3149.0 |
| 2016-01-03 18:00:00 | CL | Futures | 49.31 | 50.25 | 49.31 | 49.75 | 7939.0 |
| 2016-01-03 19:00:00 | CL | Futures | 49.75 | 49.95 | 49.65 | 49.78 | 2416.0 |
| 2016-01-03 20:00:00 | CL | Futures | 49.78 | 49.78 | 49.41 | 49.46 | 3461.0 |
| 2016-01-03 21:00:00 | CL | Futures | 49.46 | 49.46 | 49.14 | 49.41 | 4427.0 |
| 2016-01-03 22:00:00 | CL | Futures | 49.4 | 49.67 | 49.37 | 49.6 | 2747.0 |
| 2016-01-03 23:00:00 | CL | Futures | 49.6 | 49.67 | 49.45 | 49.58 | 1871.0 |
| 2016-01-03 18:00:00 | GC | Futures | 1449.7 | 1455.6 | 1449.0 | 1450.8 | 2693.0 |
| 2016-01-03 19:00:00 | GC | Futures | 1450.8 | 1453.3 | 1450.4 | 1452.8 | 1521.0 |
| 2016-01-03 20:00:00 | GC | Futures | 1453.0 | 1454.1 | 1449.7 | 1451.3 | 4507.0 |
| 2016-01-03 21:00:00 | GC | Futures | 1451.2 | 1452.8 | 1451.1 | 1452.4 | 3126.0 |
| 2016-01-03 22:00:00 | GC | Futures | 1452.4 | 1453.0 | 1451.6 | 1451.6 | 1275.0 |
| 2016-01-03 23:00:00 | GC | Futures | 1451.6 | 1453.8 | 1451.2 | 1453.8 | 1228.0 |
| 2016-01-03 18:00:00 | ZN | Futures | 122.130449 | 122.145609 | 122.039488 | 122.054648 | 6257.0 |
| 2016-01-03 19:00:00 | ZN | Futures | 122.039488 | 122.069808 | 122.024328 | 122.054648 | 6397.0 |
| 2016-01-03 20:00:00 | ZN | Futures | 122.054648 | 122.23657 | 122.039488 | 122.20625 | 12609.0 |
| 2016-01-03 21:00:00 | ZN | Futures | 122.20625 | 122.297211 | 122.20625 | 122.251731 | 11749.0 |
| 2016-01-03 22:00:00 | ZN | Futures | 122.251731 | 122.357852 | 122.22141 | 122.342692 | 10325.0 |
| 2016-01-03 23:00:00 | ZN | Futures | 122.342692 | 122.418493 | 122.312371 | 122.403332 | 11586.0 |
> showing 36 of 298 rows — these rows as CSV