PREVIEW / futures_1hour / 2012-05-27
file: by_date/futures_1hour/2012/2012-05-27.parquet size: 12 KB rows: 212
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-05-27 18:00:00 | ES | Futures | 1337.78 | 1338.29 | 1336.01 | 1337.53 | 7752.0 |
| 2012-05-27 19:00:00 | ES | Futures | 1337.53 | 1339.81 | 1337.02 | 1339.55 | 5560.0 |
| 2012-05-27 20:00:00 | ES | Futures | 1339.55 | 1341.32 | 1338.54 | 1340.06 | 9701.0 |
| 2012-05-27 21:00:00 | ES | Futures | 1340.31 | 1342.33 | 1339.81 | 1341.58 | 7031.0 |
| 2012-05-27 22:00:00 | ES | Futures | 1341.58 | 1341.83 | 1340.06 | 1341.07 | 2709.0 |
| 2012-05-27 23:00:00 | ES | Futures | 1340.82 | 1342.08 | 1340.56 | 1341.32 | 1776.0 |
| 2012-05-27 18:00:00 | NQ | Futures | 2930.47 | 2935.96 | 2930.47 | 2935.67 | 880.0 |
| 2012-05-27 19:00:00 | NQ | Futures | 2935.96 | 2935.96 | 2930.47 | 2935.1 | 571.0 |
| 2012-05-27 20:00:00 | NQ | Futures | 2935.1 | 2938.86 | 2932.49 | 2938.86 | 639.0 |
| 2012-05-27 21:00:00 | NQ | Futures | 2938.28 | 2942.9 | 2937.99 | 2940.01 | 678.0 |
| 2012-05-27 22:00:00 | NQ | Futures | 2940.3 | 2940.59 | 2936.25 | 2940.01 | 430.0 |
| 2012-05-27 23:00:00 | NQ | Futures | 2940.01 | 2942.33 | 2939.43 | 2941.46 | 367.0 |
| 2012-05-27 18:00:00 | YM | Futures | 12419.9 | 12461.7 | 12419.9 | 12445.8 | 725.0 |
| 2012-05-27 19:00:00 | YM | Futures | 12445.8 | 12451.8 | 12433.8 | 12446.8 | 429.0 |
| 2012-05-27 20:00:00 | YM | Futures | 12445.8 | 12455.7 | 12438.8 | 12445.8 | 611.0 |
| 2012-05-27 21:00:00 | YM | Futures | 12444.8 | 12464.7 | 12444.8 | 12459.7 | 481.0 |
| 2012-05-27 22:00:00 | YM | Futures | 12460.7 | 12460.7 | 12446.8 | 12453.7 | 249.0 |
| 2012-05-27 23:00:00 | YM | Futures | 12452.7 | 12460.7 | 12449.8 | 12455.7 | 258.0 |
| 2012-05-27 18:00:00 | CL | Futures | 150.68 | 151.3 | 150.6 | 151.18 | 1222.0 |
| 2012-05-27 19:00:00 | CL | Futures | 151.15 | 151.3 | 151.11 | 151.2 | 344.0 |
| 2012-05-27 20:00:00 | CL | Futures | 151.21 | 151.68 | 151.15 | 151.51 | 1040.0 |
| 2012-05-27 21:00:00 | CL | Futures | 151.54 | 151.99 | 151.51 | 151.94 | 1228.0 |
| 2012-05-27 22:00:00 | CL | Futures | 151.96 | 151.97 | 151.69 | 151.76 | 300.0 |
| 2012-05-27 23:00:00 | CL | Futures | 151.79 | 152.04 | 151.68 | 151.97 | 418.0 |
| 2012-05-27 18:00:00 | GC | Futures | 2180.1 | 2184.1 | 2180.1 | 2183.7 | 462.0 |
| 2012-05-27 19:00:00 | GC | Futures | 2183.7 | 2184.4 | 2177.1 | 2181.1 | 504.0 |
| 2012-05-27 20:00:00 | GC | Futures | 2180.9 | 2182.7 | 2180.2 | 2180.7 | 462.0 |
| 2012-05-27 21:00:00 | GC | Futures | 2180.8 | 2184.8 | 2179.1 | 2184.0 | 1121.0 |
| 2012-05-27 22:00:00 | GC | Futures | 2183.8 | 2184.0 | 2181.9 | 2183.0 | 344.0 |
| 2012-05-27 23:00:00 | GC | Futures | 2183.0 | 2184.8 | 2179.0 | 2184.3 | 1127.0 |
| 2012-05-27 18:00:00 | ZN | Futures | 117.020992 | 117.034663 | 116.897956 | 116.897956 | 7481.0 |
| 2012-05-27 19:00:00 | ZN | Futures | 116.911627 | 116.925297 | 116.856944 | 116.870615 | 3731.0 |
| 2012-05-27 20:00:00 | ZN | Futures | 116.884285 | 116.911627 | 116.870615 | 116.897956 | 4124.0 |
| 2012-05-27 21:00:00 | ZN | Futures | 116.897956 | 116.897956 | 116.843273 | 116.856944 | 3615.0 |
| 2012-05-27 22:00:00 | ZN | Futures | 116.856944 | 116.884285 | 116.843273 | 116.856944 | 3372.0 |
| 2012-05-27 23:00:00 | ZN | Futures | 116.856944 | 116.897956 | 116.843273 | 116.870615 | 2218.0 |
> showing 36 of 212 rows — these rows as CSV