PREVIEW / futures_1hour / 2013-01-13
file: by_date/futures_1hour/2013/2013-01-13.parquet size: 14 KB rows: 285
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-13 18:00:00 | ES | Futures | 1505.42 | 1505.93 | 1504.14 | 1505.68 | 5169.0 |
| 2013-01-13 19:00:00 | ES | Futures | 1505.93 | 1507.47 | 1505.16 | 1506.7 | 4745.0 |
| 2013-01-13 20:00:00 | ES | Futures | 1506.7 | 1509.53 | 1506.45 | 1509.01 | 7690.0 |
| 2013-01-13 21:00:00 | ES | Futures | 1509.01 | 1510.04 | 1509.01 | 1509.27 | 4648.0 |
| 2013-01-13 22:00:00 | ES | Futures | 1509.27 | 1509.78 | 1509.01 | 1509.27 | 2546.0 |
| 2013-01-13 23:00:00 | ES | Futures | 1509.01 | 1509.78 | 1508.5 | 1508.5 | 1728.0 |
| 2013-01-13 18:00:00 | NQ | Futures | 3194.77 | 3194.77 | 3190.41 | 3191.86 | 492.0 |
| 2013-01-13 19:00:00 | NQ | Futures | 3192.15 | 3195.36 | 3191.28 | 3193.03 | 514.0 |
| 2013-01-13 20:00:00 | NQ | Futures | 3193.32 | 3199.72 | 3192.74 | 3198.56 | 933.0 |
| 2013-01-13 21:00:00 | NQ | Futures | 3198.56 | 3202.05 | 3197.98 | 3199.14 | 852.0 |
| 2013-01-13 22:00:00 | NQ | Futures | 3199.43 | 3200.3 | 3198.85 | 3198.85 | 374.0 |
| 2013-01-13 23:00:00 | NQ | Futures | 3198.85 | 3199.14 | 3196.52 | 3196.52 | 419.0 |
| 2013-01-13 18:00:00 | YM | Futures | 13512.9 | 13512.9 | 13498.8 | 13507.9 | 392.0 |
| 2013-01-13 19:00:00 | YM | Futures | 13507.9 | 13519.0 | 13504.9 | 13514.9 | 302.0 |
| 2013-01-13 20:00:00 | YM | Futures | 13513.9 | 13536.1 | 13512.9 | 13533.0 | 627.0 |
| 2013-01-13 21:00:00 | YM | Futures | 13532.0 | 13538.1 | 13531.0 | 13532.0 | 342.0 |
| 2013-01-13 22:00:00 | YM | Futures | 13532.0 | 13538.1 | 13531.0 | 13533.0 | 242.0 |
| 2013-01-13 23:00:00 | YM | Futures | 13532.0 | 13536.1 | 13528.0 | 13528.0 | 183.0 |
| 2013-01-13 18:00:00 | CL | Futures | 150.49 | 150.69 | 150.35 | 150.65 | 933.0 |
| 2013-01-13 19:00:00 | CL | Futures | 150.64 | 150.73 | 150.59 | 150.7 | 588.0 |
| 2013-01-13 20:00:00 | CL | Futures | 150.7 | 151.04 | 150.7 | 150.91 | 1614.0 |
| 2013-01-13 21:00:00 | CL | Futures | 150.91 | 151.33 | 150.88 | 151.15 | 1399.0 |
| 2013-01-13 22:00:00 | CL | Futures | 151.17 | 151.18 | 151.12 | 151.12 | 401.0 |
| 2013-01-13 23:00:00 | CL | Futures | 151.14 | 151.18 | 151.09 | 151.15 | 384.0 |
| 2013-01-13 18:00:00 | GC | Futures | 2285.6 | 2291.2 | 2285.6 | 2286.9 | 1840.0 |
| 2013-01-13 19:00:00 | GC | Futures | 2286.9 | 2289.5 | 2286.9 | 2289.1 | 704.0 |
| 2013-01-13 20:00:00 | GC | Futures | 2288.9 | 2295.3 | 2288.9 | 2293.8 | 3112.0 |
| 2013-01-13 21:00:00 | GC | Futures | 2293.5 | 2297.1 | 2292.9 | 2293.7 | 2889.0 |
| 2013-01-13 22:00:00 | GC | Futures | 2293.5 | 2294.6 | 2290.4 | 2293.5 | 2425.0 |
| 2013-01-13 23:00:00 | GC | Futures | 2293.5 | 2294.2 | 2291.6 | 2294.1 | 575.0 |
| 2013-01-13 18:00:00 | ZN | Futures | 117.419938 | 117.545119 | 117.419938 | 117.503392 | 10744.0 |
| 2013-01-13 19:00:00 | ZN | Futures | 117.517301 | 117.53121 | 117.447756 | 117.447756 | 2695.0 |
| 2013-01-13 20:00:00 | ZN | Futures | 117.447756 | 117.461665 | 117.406028 | 117.433847 | 2210.0 |
| 2013-01-13 21:00:00 | ZN | Futures | 117.433847 | 117.447756 | 117.37821 | 117.37821 | 5753.0 |
| 2013-01-13 22:00:00 | ZN | Futures | 117.392119 | 117.406028 | 117.37821 | 117.392119 | 1844.0 |
| 2013-01-13 23:00:00 | ZN | Futures | 117.392119 | 117.419938 | 117.37821 | 117.419938 | 1273.0 |
> showing 36 of 285 rows — these rows as CSV