PREVIEW / futures_1hour / 2012-03-04
file: by_date/futures_1hour/2012/2012-03-04.parquet size: 13 KB rows: 256
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-04 18:00:00 | ES | Futures | 1378.12 | 1380.39 | 1377.87 | 1378.63 | 6500.0 |
| 2012-03-04 19:00:00 | ES | Futures | 1378.63 | 1379.89 | 1378.37 | 1379.38 | 3972.0 |
| 2012-03-04 20:00:00 | ES | Futures | 1379.38 | 1380.39 | 1379.13 | 1379.89 | 4232.0 |
| 2012-03-04 21:00:00 | ES | Futures | 1379.63 | 1379.89 | 1376.61 | 1377.11 | 6644.0 |
| 2012-03-04 22:00:00 | ES | Futures | 1376.86 | 1377.62 | 1376.11 | 1376.61 | 3555.0 |
| 2012-03-04 23:00:00 | ES | Futures | 1376.61 | 1377.11 | 1376.11 | 1376.36 | 2633.0 |
| 2012-03-04 18:00:00 | NQ | Futures | 3049.42 | 3055.49 | 3049.42 | 3051.73 | 561.0 |
| 2012-03-04 19:00:00 | NQ | Futures | 3051.44 | 3054.04 | 3051.15 | 3052.6 | 198.0 |
| 2012-03-04 20:00:00 | NQ | Futures | 3053.46 | 3054.62 | 3053.18 | 3054.04 | 166.0 |
| 2012-03-04 21:00:00 | NQ | Futures | 3053.75 | 3053.75 | 3047.69 | 3048.56 | 331.0 |
| 2012-03-04 22:00:00 | NQ | Futures | 3047.98 | 3049.42 | 3046.25 | 3047.11 | 206.0 |
| 2012-03-04 23:00:00 | NQ | Futures | 3046.82 | 3047.4 | 3045.96 | 3045.96 | 388.0 |
| 2012-03-04 18:00:00 | YM | Futures | 12845.1 | 12860.0 | 12841.1 | 12845.1 | 255.0 |
| 2012-03-04 19:00:00 | YM | Futures | 12843.1 | 12853.0 | 12842.1 | 12849.1 | 201.0 |
| 2012-03-04 20:00:00 | YM | Futures | 12851.1 | 12858.0 | 12848.1 | 12852.1 | 243.0 |
| 2012-03-04 21:00:00 | YM | Futures | 12852.1 | 12852.1 | 12828.3 | 12832.2 | 458.0 |
| 2012-03-04 22:00:00 | YM | Futures | 12831.2 | 12837.2 | 12826.3 | 12830.2 | 316.0 |
| 2012-03-04 23:00:00 | YM | Futures | 12830.2 | 12832.2 | 12827.3 | 12828.3 | 190.0 |
| 2012-03-04 18:00:00 | CL | Futures | 179.11 | 179.46 | 178.7 | 179.28 | 1573.0 |
| 2012-03-04 19:00:00 | CL | Futures | 179.31 | 179.83 | 179.26 | 179.68 | 1119.0 |
| 2012-03-04 20:00:00 | CL | Futures | 179.68 | 180.01 | 179.68 | 179.88 | 1154.0 |
| 2012-03-04 21:00:00 | CL | Futures | 179.88 | 179.88 | 179.46 | 179.53 | 721.0 |
| 2012-03-04 22:00:00 | CL | Futures | 179.51 | 179.61 | 179.36 | 179.41 | 573.0 |
| 2012-03-04 23:00:00 | CL | Futures | 179.39 | 179.56 | 179.38 | 179.38 | 507.0 |
| 2012-03-04 18:00:00 | GC | Futures | 2376.7 | 2380.3 | 2374.4 | 2378.8 | 1678.0 |
| 2012-03-04 19:00:00 | GC | Futures | 2378.7 | 2380.1 | 2375.7 | 2379.4 | 2296.0 |
| 2012-03-04 20:00:00 | GC | Futures | 2379.5 | 2384.5 | 2379.4 | 2380.9 | 3910.0 |
| 2012-03-04 21:00:00 | GC | Futures | 2380.9 | 2381.9 | 2378.9 | 2380.6 | 1646.0 |
| 2012-03-04 22:00:00 | GC | Futures | 2380.3 | 2380.3 | 2377.1 | 2378.1 | 1227.0 |
| 2012-03-04 23:00:00 | GC | Futures | 2378.0 | 2378.8 | 2377.3 | 2377.8 | 980.0 |
| 2012-03-04 18:00:00 | ZN | Futures | 114.737986 | 114.737986 | 114.669788 | 114.710707 | 100.0 |
| 2012-03-04 19:00:00 | ZN | Futures | 114.683427 | 114.683427 | 114.683427 | 114.683427 | 23.0 |
| 2012-03-04 20:00:00 | ZN | Futures | 114.683427 | 114.683427 | 114.669788 | 114.669788 | 85.0 |
| 2012-03-04 21:00:00 | ZN | Futures | 114.683427 | 114.697067 | 114.656148 | 114.683427 | 177.0 |
| 2012-03-04 22:00:00 | ZN | Futures | 114.697067 | 114.697067 | 114.669788 | 114.683427 | 296.0 |
| 2012-03-04 23:00:00 | ZN | Futures | 114.683427 | 114.710707 | 114.683427 | 114.697067 | 95.0 |
> showing 36 of 256 rows — these rows as CSV