PREVIEW / futures_1hour / 2011-04-10
file: by_date/futures_1hour/2011/2011-04-10.parquet size: 14 KB rows: 273
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-10 18:00:00 | ES | Futures | 1317.43 | 1320.66 | 1317.43 | 1319.41 | 17654.0 |
| 2011-04-10 19:00:00 | ES | Futures | 1319.41 | 1321.4 | 1319.17 | 1320.16 | 6376.0 |
| 2011-04-10 20:00:00 | ES | Futures | 1320.41 | 1320.41 | 1317.92 | 1318.67 | 8631.0 |
| 2011-04-10 21:00:00 | ES | Futures | 1318.67 | 1318.67 | 1316.43 | 1317.68 | 8573.0 |
| 2011-04-10 22:00:00 | ES | Futures | 1317.92 | 1318.42 | 1317.43 | 1318.42 | 3361.0 |
| 2011-04-10 23:00:00 | ES | Futures | 1318.17 | 1319.41 | 1316.93 | 1317.18 | 4635.0 |
| 2011-04-10 18:00:00 | NQ | Futures | 2669.44 | 2675.76 | 2668.58 | 2673.18 | 1563.0 |
| 2011-04-10 19:00:00 | NQ | Futures | 2673.75 | 2682.37 | 2673.46 | 2678.06 | 1958.0 |
| 2011-04-10 20:00:00 | NQ | Futures | 2678.06 | 2678.35 | 2673.75 | 2674.04 | 640.0 |
| 2011-04-10 21:00:00 | NQ | Futures | 2673.46 | 2673.46 | 2670.3 | 2673.46 | 869.0 |
| 2011-04-10 22:00:00 | NQ | Futures | 2673.46 | 2674.61 | 2672.03 | 2674.33 | 363.0 |
| 2011-04-10 23:00:00 | NQ | Futures | 2674.33 | 2676.62 | 2671.17 | 2671.74 | 245.0 |
| 2011-04-10 18:00:00 | YM | Futures | 11884.8 | 11915.6 | 11884.8 | 11906.9 | 903.0 |
| 2011-04-10 19:00:00 | YM | Futures | 11907.9 | 11920.4 | 11906.0 | 11911.7 | 486.0 |
| 2011-04-10 20:00:00 | YM | Futures | 11914.6 | 11914.6 | 11897.3 | 11900.2 | 192.0 |
| 2011-04-10 21:00:00 | YM | Futures | 11898.3 | 11898.3 | 11883.8 | 11894.4 | 346.0 |
| 2011-04-10 22:00:00 | YM | Futures | 11895.4 | 11901.1 | 11892.5 | 11899.2 | 220.0 |
| 2011-04-10 23:00:00 | YM | Futures | 11901.1 | 11909.8 | 11888.6 | 11891.5 | 180.0 |
| 2011-04-10 18:00:00 | CL | Futures | 197.66 | 197.97 | 197.17 | 197.45 | 2901.0 |
| 2011-04-10 19:00:00 | CL | Futures | 197.46 | 197.73 | 197.25 | 197.69 | 719.0 |
| 2011-04-10 20:00:00 | CL | Futures | 197.69 | 197.73 | 197.31 | 197.34 | 806.0 |
| 2011-04-10 21:00:00 | CL | Futures | 197.32 | 197.32 | 195.93 | 196.29 | 3684.0 |
| 2011-04-10 22:00:00 | CL | Futures | 196.29 | 196.75 | 196.1 | 196.7 | 1294.0 |
| 2011-04-10 23:00:00 | CL | Futures | 196.7 | 196.8 | 196.47 | 196.75 | 750.0 |
| 2011-04-10 18:00:00 | GC | Futures | 2060.6 | 2062.9 | 2057.5 | 2060.3 | 1475.0 |
| 2011-04-10 19:00:00 | GC | Futures | 2060.7 | 2062.1 | 2059.3 | 2061.7 | 1284.0 |
| 2011-04-10 20:00:00 | GC | Futures | 2061.5 | 2062.4 | 2060.0 | 2061.8 | 1076.0 |
| 2011-04-10 21:00:00 | GC | Futures | 2061.7 | 2062.2 | 2059.0 | 2059.6 | 1729.0 |
| 2011-04-10 22:00:00 | GC | Futures | 2059.4 | 2060.1 | 2055.3 | 2058.3 | 2477.0 |
| 2011-04-10 23:00:00 | GC | Futures | 2058.2 | 2058.7 | 2055.5 | 2057.8 | 1222.0 |
| 2011-04-10 18:00:00 | ZN | Futures | 100.665698 | 100.665698 | 100.559272 | 100.612485 | 3379.0 |
| 2011-04-10 19:00:00 | ZN | Futures | 100.612485 | 100.652395 | 100.519362 | 100.559272 | 6236.0 |
| 2011-04-10 20:00:00 | ZN | Futures | 100.559272 | 100.585878 | 100.545969 | 100.585878 | 6389.0 |
| 2011-04-10 21:00:00 | ZN | Futures | 100.585878 | 100.625788 | 100.572575 | 100.599182 | 4437.0 |
| 2011-04-10 22:00:00 | ZN | Futures | 100.599182 | 100.625788 | 100.585878 | 100.599182 | 2719.0 |
| 2011-04-10 23:00:00 | ZN | Futures | 100.599182 | 100.612485 | 100.585878 | 100.599182 | 2416.0 |
> showing 36 of 273 rows — these rows as CSV