PREVIEW / futures_1hour / 2015-07-26
file: by_date/futures_1hour/2015/2015-07-26.parquet size: 14 KB rows: 272
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-26 18:00:00 | ES | Futures | 2213.32 | 2213.59 | 2211.46 | 2212.52 | 6276.0 |
| 2015-07-26 19:00:00 | ES | Futures | 2212.79 | 2212.79 | 2210.66 | 2211.99 | 3787.0 |
| 2015-07-26 20:00:00 | ES | Futures | 2211.99 | 2213.85 | 2211.19 | 2213.59 | 5294.0 |
| 2015-07-26 21:00:00 | ES | Futures | 2213.59 | 2215.98 | 2213.32 | 2215.19 | 6298.0 |
| 2015-07-26 22:00:00 | ES | Futures | 2215.19 | 2215.19 | 2212.52 | 2213.06 | 2454.0 |
| 2015-07-26 23:00:00 | ES | Futures | 2213.06 | 2213.59 | 2212.52 | 2212.79 | 3219.0 |
| 2015-07-26 18:00:00 | NQ | Futures | 5397.86 | 5398.75 | 5393.42 | 5395.79 | 1059.0 |
| 2015-07-26 19:00:00 | NQ | Futures | 5396.38 | 5396.68 | 5391.95 | 5395.2 | 548.0 |
| 2015-07-26 20:00:00 | NQ | Futures | 5395.49 | 5399.34 | 5393.13 | 5398.45 | 605.0 |
| 2015-07-26 21:00:00 | NQ | Futures | 5398.16 | 5404.96 | 5398.16 | 5402.0 | 712.0 |
| 2015-07-26 22:00:00 | NQ | Futures | 5402.0 | 5402.3 | 5395.49 | 5396.68 | 395.0 |
| 2015-07-26 23:00:00 | NQ | Futures | 5396.68 | 5398.75 | 5394.9 | 5395.49 | 703.0 |
| 2015-07-26 18:00:00 | YM | Futures | 18464.0 | 18466.1 | 18448.2 | 18455.6 | 946.0 |
| 2015-07-26 19:00:00 | YM | Futures | 18456.6 | 18457.7 | 18439.8 | 18451.4 | 287.0 |
| 2015-07-26 20:00:00 | YM | Futures | 18452.4 | 18469.3 | 18450.3 | 18466.1 | 1018.0 |
| 2015-07-26 21:00:00 | YM | Futures | 18465.0 | 18485.1 | 18465.0 | 18475.6 | 891.0 |
| 2015-07-26 22:00:00 | YM | Futures | 18477.7 | 18477.7 | 18457.7 | 18461.9 | 444.0 |
| 2015-07-26 23:00:00 | YM | Futures | 18461.9 | 18466.1 | 18453.5 | 18453.5 | 633.0 |
| 2015-07-26 18:00:00 | CL | Futures | 70.82 | 71.01 | 70.72 | 70.95 | 1498.0 |
| 2015-07-26 19:00:00 | CL | Futures | 70.95 | 71.01 | 70.84 | 70.98 | 353.0 |
| 2015-07-26 20:00:00 | CL | Futures | 70.98 | 71.04 | 70.78 | 70.94 | 1185.0 |
| 2015-07-26 21:00:00 | CL | Futures | 70.94 | 70.98 | 70.75 | 70.85 | 1080.0 |
| 2015-07-26 22:00:00 | CL | Futures | 70.87 | 70.94 | 70.73 | 70.81 | 963.0 |
| 2015-07-26 23:00:00 | CL | Futures | 70.81 | 70.87 | 70.76 | 70.85 | 685.0 |
| 2015-07-26 18:00:00 | GC | Futures | 1499.4 | 1502.5 | 1495.0 | 1495.9 | 193.0 |
| 2015-07-26 19:00:00 | GC | Futures | 1495.4 | 1498.3 | 1495.3 | 1497.5 | 74.0 |
| 2015-07-26 20:00:00 | GC | Futures | 1497.5 | 1498.2 | 1495.3 | 1496.9 | 150.0 |
| 2015-07-26 21:00:00 | GC | Futures | 1497.5 | 1500.5 | 1493.7 | 1498.7 | 395.0 |
| 2015-07-26 22:00:00 | GC | Futures | 1499.1 | 1499.3 | 1496.8 | 1497.4 | 184.0 |
| 2015-07-26 23:00:00 | GC | Futures | 1498.4 | 1499.3 | 1496.9 | 1498.7 | 153.0 |
| 2015-07-26 18:00:00 | ZN | Futures | 121.957271 | 122.002362 | 121.942241 | 122.002362 | 2125.0 |
| 2015-07-26 19:00:00 | ZN | Futures | 122.002362 | 122.002362 | 121.957271 | 121.972301 | 1313.0 |
| 2015-07-26 20:00:00 | ZN | Futures | 121.972301 | 122.017393 | 121.957271 | 122.002362 | 2668.0 |
| 2015-07-26 21:00:00 | ZN | Futures | 121.987332 | 121.987332 | 121.942241 | 121.942241 | 3237.0 |
| 2015-07-26 22:00:00 | ZN | Futures | 121.942241 | 122.002362 | 121.942241 | 122.002362 | 2030.0 |
| 2015-07-26 23:00:00 | ZN | Futures | 122.002362 | 122.017393 | 121.972301 | 122.017393 | 2482.0 |
> showing 36 of 272 rows — these rows as CSV