PREVIEW / futures_1hour / 2015-08-09
file: by_date/futures_1hour/2015/2015-08-09.parquet size: 14 KB rows: 265
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-08-09 18:00:00 | ES | Futures | 2206.67 | 2209.86 | 2206.4 | 2208.0 | 7292.0 |
| 2015-08-09 19:00:00 | ES | Futures | 2208.26 | 2208.8 | 2206.67 | 2208.53 | 1834.0 |
| 2015-08-09 20:00:00 | ES | Futures | 2208.8 | 2212.79 | 2208.26 | 2211.99 | 9666.0 |
| 2015-08-09 21:00:00 | ES | Futures | 2211.99 | 2213.32 | 2210.93 | 2211.72 | 4773.0 |
| 2015-08-09 22:00:00 | ES | Futures | 2211.99 | 2211.99 | 2210.93 | 2211.19 | 1201.0 |
| 2015-08-09 23:00:00 | ES | Futures | 2211.19 | 2214.39 | 2211.19 | 2213.59 | 3900.0 |
| 2015-08-09 18:00:00 | NQ | Futures | 5340.77 | 5347.58 | 5339.89 | 5343.14 | 1216.0 |
| 2015-08-09 19:00:00 | NQ | Futures | 5343.44 | 5344.32 | 5339.29 | 5344.32 | 305.0 |
| 2015-08-09 20:00:00 | NQ | Futures | 5344.91 | 5355.56 | 5343.44 | 5353.2 | 1406.0 |
| 2015-08-09 21:00:00 | NQ | Futures | 5353.2 | 5356.45 | 5352.31 | 5352.61 | 794.0 |
| 2015-08-09 22:00:00 | NQ | Futures | 5353.2 | 5353.2 | 5350.53 | 5351.42 | 198.0 |
| 2015-08-09 23:00:00 | NQ | Futures | 5351.42 | 5359.7 | 5351.42 | 5357.34 | 774.0 |
| 2015-08-09 18:00:00 | YM | Futures | 18235.4 | 18252.3 | 18224.9 | 18237.5 | 1805.0 |
| 2015-08-09 19:00:00 | YM | Futures | 18237.5 | 18247.0 | 18230.1 | 18245.9 | 367.0 |
| 2015-08-09 20:00:00 | YM | Futures | 18245.9 | 18273.3 | 18244.9 | 18267.0 | 2121.0 |
| 2015-08-09 21:00:00 | YM | Futures | 18267.0 | 18278.6 | 18261.7 | 18267.0 | 822.0 |
| 2015-08-09 22:00:00 | YM | Futures | 18267.0 | 18269.1 | 18258.6 | 18260.7 | 370.0 |
| 2015-08-09 23:00:00 | YM | Futures | 18261.7 | 18286.0 | 18261.7 | 18279.6 | 553.0 |
| 2015-08-09 18:00:00 | CL | Futures | 64.3 | 64.39 | 63.96 | 64.28 | 4243.0 |
| 2015-08-09 19:00:00 | CL | Futures | 64.3 | 64.34 | 64.24 | 64.31 | 652.0 |
| 2015-08-09 20:00:00 | CL | Futures | 64.28 | 64.52 | 64.27 | 64.46 | 1598.0 |
| 2015-08-09 21:00:00 | CL | Futures | 64.48 | 64.49 | 64.34 | 64.42 | 1252.0 |
| 2015-08-09 22:00:00 | CL | Futures | 64.42 | 64.46 | 64.26 | 64.33 | 1163.0 |
| 2015-08-09 23:00:00 | CL | Futures | 64.34 | 64.46 | 64.26 | 64.33 | 1035.0 |
| 2015-08-09 18:00:00 | GC | Futures | 1493.7 | 1493.7 | 1490.0 | 1490.4 | 1628.0 |
| 2015-08-09 19:00:00 | GC | Futures | 1490.5 | 1491.2 | 1489.7 | 1489.7 | 359.0 |
| 2015-08-09 20:00:00 | GC | Futures | 1489.8 | 1490.3 | 1486.8 | 1487.9 | 2222.0 |
| 2015-08-09 21:00:00 | GC | Futures | 1488.1 | 1491.9 | 1487.5 | 1491.6 | 3523.0 |
| 2015-08-09 22:00:00 | GC | Futures | 1491.5 | 1492.9 | 1490.5 | 1492.7 | 1539.0 |
| 2015-08-09 23:00:00 | GC | Futures | 1492.7 | 1494.1 | 1492.4 | 1493.7 | 1480.0 |
| 2015-08-09 18:00:00 | ZN | Futures | 122.648673 | 122.663703 | 122.603581 | 122.618612 | 4918.0 |
| 2015-08-09 19:00:00 | ZN | Futures | 122.633642 | 122.633642 | 122.588551 | 122.588551 | 3450.0 |
| 2015-08-09 20:00:00 | ZN | Futures | 122.603581 | 122.603581 | 122.513399 | 122.55849 | 10483.0 |
| 2015-08-09 21:00:00 | ZN | Futures | 122.543459 | 122.588551 | 122.528429 | 122.588551 | 6062.0 |
| 2015-08-09 22:00:00 | ZN | Futures | 122.588551 | 122.588551 | 122.528429 | 122.543459 | 3822.0 |
| 2015-08-09 23:00:00 | ZN | Futures | 122.543459 | 122.543459 | 122.513399 | 122.528429 | 3170.0 |
> showing 36 of 265 rows — these rows as CSV