PREVIEW / futures_1hour / 2012-08-19
file: by_date/futures_1hour/2012/2012-08-19.parquet size: 13 KB rows: 252
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-08-19 18:00:00 | ES | Futures | 1439.24 | 1441.79 | 1438.99 | 1439.5 | 9646.0 |
| 2012-08-19 19:00:00 | ES | Futures | 1439.5 | 1440.26 | 1439.24 | 1439.5 | 2462.0 |
| 2012-08-19 20:00:00 | ES | Futures | 1439.24 | 1440.26 | 1438.74 | 1440.01 | 4336.0 |
| 2012-08-19 21:00:00 | ES | Futures | 1439.75 | 1440.26 | 1438.74 | 1438.99 | 5090.0 |
| 2012-08-19 22:00:00 | ES | Futures | 1438.99 | 1439.24 | 1437.97 | 1438.99 | 3171.0 |
| 2012-08-19 23:00:00 | ES | Futures | 1438.99 | 1439.75 | 1438.74 | 1438.99 | 2007.0 |
| 2012-08-19 18:00:00 | NQ | Futures | 3217.43 | 3223.81 | 3217.43 | 3220.04 | 611.0 |
| 2012-08-19 19:00:00 | NQ | Futures | 3219.75 | 3221.2 | 3219.17 | 3220.62 | 359.0 |
| 2012-08-19 20:00:00 | NQ | Futures | 3220.33 | 3221.49 | 3218.88 | 3221.2 | 472.0 |
| 2012-08-19 21:00:00 | NQ | Futures | 3221.2 | 3221.49 | 3218.59 | 3219.17 | 357.0 |
| 2012-08-19 22:00:00 | NQ | Futures | 3219.17 | 3219.17 | 3217.14 | 3218.59 | 364.0 |
| 2012-08-19 23:00:00 | NQ | Futures | 3218.59 | 3220.04 | 3218.01 | 3218.3 | 177.0 |
| 2012-08-19 18:00:00 | YM | Futures | 13174.8 | 13193.7 | 13170.9 | 13177.8 | 722.0 |
| 2012-08-19 19:00:00 | YM | Futures | 13176.8 | 13182.8 | 13174.8 | 13176.8 | 120.0 |
| 2012-08-19 20:00:00 | YM | Futures | 13176.8 | 13181.8 | 13170.9 | 13179.8 | 232.0 |
| 2012-08-19 21:00:00 | YM | Futures | 13177.8 | 13181.8 | 13168.9 | 13171.9 | 279.0 |
| 2012-08-19 22:00:00 | YM | Futures | 13172.9 | 13173.8 | 13163.9 | 13171.9 | 263.0 |
| 2012-08-19 23:00:00 | YM | Futures | 13172.9 | 13176.8 | 13171.9 | 13172.9 | 159.0 |
| 2012-08-19 18:00:00 | CL | Futures | 158.19 | 158.29 | 157.84 | 157.99 | 823.0 |
| 2012-08-19 19:00:00 | CL | Futures | 157.99 | 158.04 | 157.91 | 157.96 | 164.0 |
| 2012-08-19 20:00:00 | CL | Futures | 157.97 | 158.11 | 157.83 | 157.99 | 474.0 |
| 2012-08-19 21:00:00 | CL | Futures | 158.02 | 158.11 | 157.88 | 157.99 | 378.0 |
| 2012-08-19 22:00:00 | CL | Futures | 158.01 | 158.3 | 157.89 | 158.04 | 576.0 |
| 2012-08-19 23:00:00 | CL | Futures | 157.99 | 158.27 | 157.99 | 158.11 | 256.0 |
| 2012-08-19 18:00:00 | GC | Futures | 2232.8 | 2235.3 | 2231.0 | 2234.8 | 771.0 |
| 2012-08-19 19:00:00 | GC | Futures | 2234.7 | 2234.7 | 2233.6 | 2234.2 | 205.0 |
| 2012-08-19 20:00:00 | GC | Futures | 2234.2 | 2234.7 | 2232.9 | 2233.7 | 550.0 |
| 2012-08-19 21:00:00 | GC | Futures | 2233.7 | 2234.0 | 2231.9 | 2233.6 | 999.0 |
| 2012-08-19 22:00:00 | GC | Futures | 2233.6 | 2236.1 | 2232.8 | 2235.7 | 820.0 |
| 2012-08-19 23:00:00 | GC | Futures | 2235.4 | 2237.6 | 2235.3 | 2236.1 | 910.0 |
| 2012-08-19 18:00:00 | ZN | Futures | 116.645486 | 116.65924 | 116.590471 | 116.631733 | 2808.0 |
| 2012-08-19 19:00:00 | ZN | Futures | 116.631733 | 116.65924 | 116.576718 | 116.65924 | 2645.0 |
| 2012-08-19 20:00:00 | ZN | Futures | 116.65924 | 116.686748 | 116.617979 | 116.631733 | 3813.0 |
| 2012-08-19 21:00:00 | ZN | Futures | 116.631733 | 116.672994 | 116.617979 | 116.65924 | 1993.0 |
| 2012-08-19 22:00:00 | ZN | Futures | 116.645486 | 116.672994 | 116.645486 | 116.65924 | 856.0 |
| 2012-08-19 23:00:00 | ZN | Futures | 116.65924 | 116.672994 | 116.631733 | 116.645486 | 1051.0 |
> showing 36 of 252 rows — these rows as CSV