PREVIEW / futures_1hour / 2015-05-31
file: by_date/futures_1hour/2015/2015-05-31.parquet size: 14 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-31 18:00:00 | ES | Futures | 2225.98 | 2229.42 | 2224.4 | 2226.51 | 7074.0 |
| 2015-05-31 19:00:00 | ES | Futures | 2226.51 | 2226.78 | 2224.93 | 2225.98 | 2195.0 |
| 2015-05-31 20:00:00 | ES | Futures | 2226.25 | 2227.57 | 2225.72 | 2227.31 | 5651.0 |
| 2015-05-31 21:00:00 | ES | Futures | 2227.31 | 2228.63 | 2226.51 | 2228.1 | 3793.0 |
| 2015-05-31 22:00:00 | ES | Futures | 2228.1 | 2228.63 | 2227.57 | 2228.1 | 892.0 |
| 2015-05-31 23:00:00 | ES | Futures | 2228.36 | 2228.89 | 2227.83 | 2228.89 | 1731.0 |
| 2015-05-31 18:00:00 | NQ | Futures | 5309.61 | 5319.02 | 5307.55 | 5314.02 | 1188.0 |
| 2015-05-31 19:00:00 | NQ | Futures | 5314.02 | 5315.2 | 5310.49 | 5313.14 | 274.0 |
| 2015-05-31 20:00:00 | NQ | Futures | 5313.43 | 5315.79 | 5311.67 | 5314.9 | 526.0 |
| 2015-05-31 21:00:00 | NQ | Futures | 5314.61 | 5318.14 | 5312.85 | 5316.96 | 456.0 |
| 2015-05-31 22:00:00 | NQ | Futures | 5316.96 | 5317.84 | 5316.08 | 5317.84 | 247.0 |
| 2015-05-31 23:00:00 | NQ | Futures | 5317.55 | 5319.02 | 5315.79 | 5318.73 | 299.0 |
| 2015-05-31 18:00:00 | YM | Futures | 18897.0 | 18923.2 | 18886.5 | 18905.4 | 972.0 |
| 2015-05-31 19:00:00 | YM | Futures | 18905.4 | 18909.6 | 18890.7 | 18901.2 | 332.0 |
| 2015-05-31 20:00:00 | YM | Futures | 18902.2 | 18912.7 | 18898.0 | 18909.6 | 533.0 |
| 2015-05-31 21:00:00 | YM | Futures | 18910.6 | 18922.1 | 18905.4 | 18916.9 | 494.0 |
| 2015-05-31 22:00:00 | YM | Futures | 18919.0 | 18921.1 | 18913.8 | 18921.1 | 274.0 |
| 2015-05-31 23:00:00 | YM | Futures | 18919.0 | 18924.2 | 18914.8 | 18923.2 | 269.0 |
| 2015-05-31 18:00:00 | CL | Futures | 90.4 | 90.46 | 89.82 | 89.88 | 1629.0 |
| 2015-05-31 19:00:00 | CL | Futures | 89.88 | 90.0 | 89.85 | 89.88 | 754.0 |
| 2015-05-31 20:00:00 | CL | Futures | 89.86 | 89.88 | 89.68 | 89.71 | 1741.0 |
| 2015-05-31 21:00:00 | CL | Futures | 89.73 | 89.83 | 89.58 | 89.76 | 1792.0 |
| 2015-05-31 22:00:00 | CL | Futures | 89.76 | 89.91 | 89.67 | 89.73 | 2110.0 |
| 2015-05-31 23:00:00 | CL | Futures | 89.71 | 89.79 | 89.62 | 89.71 | 597.0 |
| 2015-05-31 18:00:00 | GC | Futures | 1624.0 | 1634.8 | 1623.9 | 1629.5 | 3553.0 |
| 2015-05-31 19:00:00 | GC | Futures | 1629.5 | 1629.5 | 1625.9 | 1626.2 | 931.0 |
| 2015-05-31 20:00:00 | GC | Futures | 1626.2 | 1627.0 | 1624.3 | 1625.7 | 1510.0 |
| 2015-05-31 21:00:00 | GC | Futures | 1625.7 | 1625.9 | 1623.6 | 1625.5 | 2123.0 |
| 2015-05-31 22:00:00 | GC | Futures | 1625.4 | 1626.6 | 1624.4 | 1624.7 | 1685.0 |
| 2015-05-31 23:00:00 | GC | Futures | 1624.6 | 1626.3 | 1624.6 | 1625.9 | 1067.0 |
| 2015-05-31 18:00:00 | ZN | Futures | 122.46937 | 122.484304 | 122.454437 | 122.46937 | 113.0 |
| 2015-05-31 19:00:00 | ZN | Futures | 122.454437 | 122.454437 | 122.394703 | 122.42457 | 327.0 |
| 2015-05-31 20:00:00 | ZN | Futures | 122.42457 | 122.439504 | 122.349903 | 122.364836 | 1052.0 |
| 2015-05-31 21:00:00 | ZN | Futures | 122.364836 | 122.439504 | 122.364836 | 122.42457 | 1941.0 |
| 2015-05-31 22:00:00 | ZN | Futures | 122.42457 | 122.439504 | 122.409637 | 122.439504 | 845.0 |
| 2015-05-31 23:00:00 | ZN | Futures | 122.439504 | 122.484304 | 122.42457 | 122.484304 | 1199.0 |
> showing 36 of 263 rows — these rows as CSV