PREVIEW / futures_1hour / 2013-06-30
file: by_date/futures_1hour/2013/2013-06-30.parquet size: 14 KB rows: 257
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 |
|---|---|---|---|---|---|---|---|
| 2013-06-30 18:00:00 | ES | Futures | 1654.63 | 1655.92 | 1652.82 | 1652.82 | 11789.0 |
| 2013-06-30 19:00:00 | ES | Futures | 1653.07 | 1653.85 | 1651.26 | 1653.33 | 4092.0 |
| 2013-06-30 20:00:00 | ES | Futures | 1653.07 | 1653.07 | 1647.39 | 1648.16 | 11458.0 |
| 2013-06-30 21:00:00 | ES | Futures | 1648.42 | 1650.75 | 1647.65 | 1648.68 | 6982.0 |
| 2013-06-30 22:00:00 | ES | Futures | 1648.94 | 1651.01 | 1647.9 | 1650.49 | 4135.0 |
| 2013-06-30 23:00:00 | ES | Futures | 1650.75 | 1651.01 | 1648.16 | 1649.97 | 2972.0 |
| 2013-06-30 18:00:00 | NQ | Futures | 3393.15 | 3399.0 | 3393.15 | 3393.74 | 464.0 |
| 2013-06-30 19:00:00 | NQ | Futures | 3393.44 | 3394.9 | 3390.81 | 3394.03 | 476.0 |
| 2013-06-30 20:00:00 | NQ | Futures | 3394.03 | 3394.03 | 3383.21 | 3384.68 | 1338.0 |
| 2013-06-30 21:00:00 | NQ | Futures | 3384.68 | 3388.77 | 3383.8 | 3385.26 | 1164.0 |
| 2013-06-30 22:00:00 | NQ | Futures | 3385.26 | 3389.64 | 3383.21 | 3389.35 | 451.0 |
| 2013-06-30 23:00:00 | NQ | Futures | 3389.64 | 3389.94 | 3385.55 | 3387.6 | 554.0 |
| 2013-06-30 18:00:00 | YM | Futures | 15065.6 | 15086.9 | 15062.6 | 15062.6 | 588.0 |
| 2013-06-30 19:00:00 | YM | Futures | 15062.6 | 15065.6 | 15048.3 | 15062.6 | 464.0 |
| 2013-06-30 20:00:00 | YM | Futures | 15061.5 | 15061.5 | 15022.9 | 15028.0 | 1981.0 |
| 2013-06-30 21:00:00 | YM | Futures | 15029.0 | 15046.3 | 15029.0 | 15034.1 | 1598.0 |
| 2013-06-30 22:00:00 | YM | Futures | 15035.1 | 15050.4 | 15028.0 | 15049.3 | 819.0 |
| 2013-06-30 23:00:00 | YM | Futures | 15050.4 | 15051.4 | 15031.1 | 15042.2 | 554.0 |
| 2013-06-30 18:00:00 | CL | Futures | 150.98 | 151.0 | 150.48 | 150.69 | 1267.0 |
| 2013-06-30 19:00:00 | CL | Futures | 150.69 | 150.75 | 150.44 | 150.69 | 586.0 |
| 2013-06-30 20:00:00 | CL | Futures | 150.72 | 150.73 | 150.27 | 150.28 | 1023.0 |
| 2013-06-30 21:00:00 | CL | Futures | 150.28 | 150.41 | 150.19 | 150.36 | 1443.0 |
| 2013-06-30 22:00:00 | CL | Futures | 150.38 | 150.47 | 150.23 | 150.31 | 602.0 |
| 2013-06-30 23:00:00 | CL | Futures | 150.34 | 150.66 | 150.22 | 150.63 | 723.0 |
| 2013-06-30 18:00:00 | GC | Futures | 1690.9 | 1698.4 | 1690.6 | 1698.0 | 2649.0 |
| 2013-06-30 19:00:00 | GC | Futures | 1698.0 | 1707.2 | 1695.7 | 1699.4 | 4523.0 |
| 2013-06-30 20:00:00 | GC | Futures | 1699.1 | 1699.8 | 1684.3 | 1686.0 | 5087.0 |
| 2013-06-30 21:00:00 | GC | Futures | 1685.6 | 1696.9 | 1678.8 | 1696.0 | 8286.0 |
| 2013-06-30 22:00:00 | GC | Futures | 1696.3 | 1703.9 | 1696.1 | 1699.7 | 4522.0 |
| 2013-06-30 23:00:00 | GC | Futures | 1699.8 | 1704.1 | 1698.7 | 1701.7 | 2185.0 |
| 2013-06-30 18:00:00 | ZN | Futures | 114.453201 | 114.552257 | 114.424899 | 114.509804 | 5804.0 |
| 2013-06-30 19:00:00 | ZN | Futures | 114.509804 | 114.523955 | 114.368295 | 114.410748 | 5246.0 |
| 2013-06-30 20:00:00 | ZN | Futures | 114.410748 | 114.509804 | 114.410748 | 114.481503 | 6537.0 |
| 2013-06-30 21:00:00 | ZN | Futures | 114.467352 | 114.481503 | 114.354144 | 114.396597 | 6444.0 |
| 2013-06-30 22:00:00 | ZN | Futures | 114.396597 | 114.410748 | 114.368295 | 114.396597 | 2929.0 |
| 2013-06-30 23:00:00 | ZN | Futures | 114.382446 | 114.396597 | 114.354144 | 114.382446 | 3711.0 |
> showing 36 of 257 rows — these rows as CSV