PREVIEW / futures_1hour / 2012-03-11
file: by_date/futures_1hour/2012/2012-03-11.parquet size: 13 KB rows: 250
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-11 18:00:00 | ES | Futures | 1383.67 | 1383.67 | 1380.89 | 1381.9 | 1289.0 |
| 2012-03-11 19:00:00 | ES | Futures | 1382.15 | 1383.16 | 1381.65 | 1382.91 | 872.0 |
| 2012-03-11 20:00:00 | ES | Futures | 1382.91 | 1382.91 | 1380.39 | 1380.89 | 3196.0 |
| 2012-03-11 21:00:00 | ES | Futures | 1380.89 | 1381.4 | 1379.89 | 1380.89 | 2031.0 |
| 2012-03-11 22:00:00 | ES | Futures | 1380.89 | 1380.89 | 1379.13 | 1380.14 | 3193.0 |
| 2012-03-11 23:00:00 | ES | Futures | 1380.14 | 1380.64 | 1379.13 | 1379.63 | 1266.0 |
| 2012-03-11 18:00:00 | NQ | Futures | 3060.4 | 3060.4 | 3050.58 | 3056.06 | 171.0 |
| 2012-03-11 19:00:00 | NQ | Futures | 3056.06 | 3057.51 | 3055.78 | 3057.51 | 70.0 |
| 2012-03-11 20:00:00 | NQ | Futures | 3057.51 | 3057.8 | 3052.02 | 3053.18 | 136.0 |
| 2012-03-11 21:00:00 | NQ | Futures | 3053.18 | 3054.04 | 3051.44 | 3053.46 | 111.0 |
| 2012-03-11 22:00:00 | NQ | Futures | 3052.02 | 3053.75 | 3050.29 | 3052.02 | 153.0 |
| 2012-03-11 23:00:00 | NQ | Futures | 3052.6 | 3052.89 | 3050.58 | 3050.87 | 116.0 |
| 2012-03-11 18:00:00 | YM | Futures | 12811.4 | 12816.4 | 12799.5 | 12801.5 | 123.0 |
| 2012-03-11 19:00:00 | YM | Futures | 12803.4 | 12812.4 | 12802.4 | 12811.4 | 101.0 |
| 2012-03-11 20:00:00 | YM | Futures | 12812.4 | 12812.4 | 12791.5 | 12796.5 | 187.0 |
| 2012-03-11 21:00:00 | YM | Futures | 12795.5 | 12798.5 | 12787.5 | 12796.5 | 313.0 |
| 2012-03-11 22:00:00 | YM | Futures | 12796.5 | 12796.5 | 12782.5 | 12790.5 | 326.0 |
| 2012-03-11 23:00:00 | YM | Futures | 12791.5 | 12793.5 | 12784.5 | 12786.5 | 144.0 |
| 2012-03-11 18:00:00 | CL | Futures | 180.37 | 180.47 | 179.78 | 179.88 | 960.0 |
| 2012-03-11 19:00:00 | CL | Futures | 179.93 | 179.93 | 179.58 | 179.76 | 833.0 |
| 2012-03-11 20:00:00 | CL | Futures | 179.73 | 179.81 | 179.41 | 179.54 | 809.0 |
| 2012-03-11 21:00:00 | CL | Futures | 179.49 | 179.56 | 179.26 | 179.39 | 976.0 |
| 2012-03-11 22:00:00 | CL | Futures | 179.39 | 179.46 | 178.97 | 179.24 | 1623.0 |
| 2012-03-11 23:00:00 | CL | Futures | 179.26 | 179.34 | 179.07 | 179.24 | 362.0 |
| 2012-03-11 18:00:00 | GC | Futures | 2380.3 | 2383.7 | 2379.1 | 2379.6 | 789.0 |
| 2012-03-11 19:00:00 | GC | Futures | 2379.8 | 2380.1 | 2376.2 | 2378.7 | 861.0 |
| 2012-03-11 20:00:00 | GC | Futures | 2378.7 | 2379.2 | 2373.4 | 2377.0 | 1922.0 |
| 2012-03-11 21:00:00 | GC | Futures | 2376.9 | 2378.7 | 2370.6 | 2372.4 | 3346.0 |
| 2012-03-11 22:00:00 | GC | Futures | 2372.3 | 2373.9 | 2369.8 | 2373.8 | 2806.0 |
| 2012-03-11 23:00:00 | GC | Futures | 2373.8 | 2374.4 | 2370.9 | 2371.2 | 1102.0 |
| 2012-03-11 18:00:00 | ZN | Futures | 114.396222 | 114.478246 | 114.382551 | 114.437234 | 3588.0 |
| 2012-03-11 19:00:00 | ZN | Futures | 114.437234 | 114.491917 | 114.423563 | 114.464575 | 2330.0 |
| 2012-03-11 20:00:00 | ZN | Futures | 114.464575 | 114.491917 | 114.450905 | 114.478246 | 3353.0 |
| 2012-03-11 21:00:00 | ZN | Futures | 114.478246 | 114.532929 | 114.464575 | 114.519258 | 5946.0 |
| 2012-03-11 22:00:00 | ZN | Futures | 114.519258 | 114.532929 | 114.478246 | 114.519258 | 4477.0 |
| 2012-03-11 23:00:00 | ZN | Futures | 114.505588 | 114.519258 | 114.491917 | 114.505588 | 1828.0 |
> showing 36 of 250 rows — these rows as CSV