PREVIEW / futures_1hour / 2012-04-29
file: by_date/futures_1hour/2012/2012-04-29.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-04-29 18:00:00 | ES | Futures | 1416.97 | 1419.24 | 1416.46 | 1416.97 | 6896.0 |
| 2012-04-29 19:00:00 | ES | Futures | 1416.71 | 1417.98 | 1416.21 | 1416.97 | 2342.0 |
| 2012-04-29 20:00:00 | ES | Futures | 1416.71 | 1417.22 | 1414.69 | 1415.7 | 4860.0 |
| 2012-04-29 21:00:00 | ES | Futures | 1415.7 | 1417.47 | 1415.19 | 1417.47 | 3976.0 |
| 2012-04-29 22:00:00 | ES | Futures | 1417.22 | 1417.72 | 1416.21 | 1416.97 | 2683.0 |
| 2012-04-29 23:00:00 | ES | Futures | 1416.71 | 1417.72 | 1416.71 | 1416.97 | 906.0 |
| 2012-04-29 18:00:00 | NQ | Futures | 3170.79 | 3174.55 | 3168.77 | 3170.22 | 1027.0 |
| 2012-04-29 19:00:00 | NQ | Futures | 3170.22 | 3171.95 | 3169.35 | 3169.93 | 271.0 |
| 2012-04-29 20:00:00 | NQ | Futures | 3169.35 | 3170.22 | 3166.17 | 3168.19 | 437.0 |
| 2012-04-29 21:00:00 | NQ | Futures | 3168.19 | 3171.66 | 3167.04 | 3170.22 | 663.0 |
| 2012-04-29 22:00:00 | NQ | Futures | 3170.22 | 3170.51 | 3168.19 | 3169.64 | 357.0 |
| 2012-04-29 23:00:00 | NQ | Futures | 3169.64 | 3171.66 | 3169.64 | 3170.79 | 134.0 |
| 2012-04-29 18:00:00 | YM | Futures | 13128.2 | 13144.2 | 13125.3 | 13130.2 | 470.0 |
| 2012-04-29 19:00:00 | YM | Futures | 13130.2 | 13137.2 | 13126.2 | 13130.2 | 112.0 |
| 2012-04-29 20:00:00 | YM | Futures | 13130.2 | 13130.2 | 13115.3 | 13122.3 | 344.0 |
| 2012-04-29 21:00:00 | YM | Futures | 13122.3 | 13135.2 | 13118.3 | 13133.2 | 374.0 |
| 2012-04-29 22:00:00 | YM | Futures | 13133.2 | 13135.2 | 13125.3 | 13131.2 | 128.0 |
| 2012-04-29 23:00:00 | YM | Futures | 13130.2 | 13138.2 | 13130.2 | 13134.2 | 75.0 |
| 2012-04-29 18:00:00 | CL | Futures | 174.44 | 174.51 | 173.99 | 174.09 | 504.0 |
| 2012-04-29 19:00:00 | CL | Futures | 174.12 | 174.22 | 174.07 | 174.22 | 231.0 |
| 2012-04-29 20:00:00 | CL | Futures | 174.22 | 174.22 | 173.99 | 173.99 | 207.0 |
| 2012-04-29 21:00:00 | CL | Futures | 174.04 | 174.19 | 173.99 | 174.19 | 170.0 |
| 2012-04-29 22:00:00 | CL | Futures | 174.17 | 174.19 | 174.07 | 174.12 | 157.0 |
| 2012-04-29 23:00:00 | CL | Futures | 174.11 | 174.21 | 174.09 | 174.19 | 116.0 |
| 2012-04-29 18:00:00 | GC | Futures | 2304.7 | 2308.3 | 2304.4 | 2306.5 | 613.0 |
| 2012-04-29 19:00:00 | GC | Futures | 2306.5 | 2308.4 | 2306.5 | 2308.2 | 223.0 |
| 2012-04-29 20:00:00 | GC | Futures | 2308.4 | 2308.4 | 2305.5 | 2306.4 | 405.0 |
| 2012-04-29 21:00:00 | GC | Futures | 2306.6 | 2308.2 | 2305.9 | 2307.0 | 411.0 |
| 2012-04-29 22:00:00 | GC | Futures | 2307.3 | 2308.0 | 2306.5 | 2306.5 | 313.0 |
| 2012-04-29 23:00:00 | GC | Futures | 2306.6 | 2307.3 | 2306.4 | 2306.4 | 318.0 |
| 2012-04-29 18:00:00 | ZN | Futures | 115.612912 | 115.626583 | 115.585571 | 115.599242 | 4424.0 |
| 2012-04-29 19:00:00 | ZN | Futures | 115.612912 | 115.626583 | 115.585571 | 115.599242 | 1333.0 |
| 2012-04-29 20:00:00 | ZN | Futures | 115.599242 | 115.681266 | 115.585571 | 115.653924 | 3064.0 |
| 2012-04-29 21:00:00 | ZN | Futures | 115.640254 | 115.653924 | 115.55823 | 115.585571 | 4665.0 |
| 2012-04-29 22:00:00 | ZN | Futures | 115.585571 | 115.599242 | 115.5719 | 115.585571 | 774.0 |
| 2012-04-29 23:00:00 | ZN | Futures | 115.585571 | 115.585571 | 115.530888 | 115.544559 | 2015.0 |
> showing 36 of 256 rows — these rows as CSV