PREVIEW / futures_1hour / 2015-04-26
file: by_date/futures_1hour/2015/2015-04-26.parquet size: 14 KB rows: 268
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-04-26 18:00:00 | ES | Futures | 2232.59 | 2232.59 | 2230.47 | 2232.06 | 3502.0 |
| 2015-04-26 19:00:00 | ES | Futures | 2232.06 | 2232.59 | 2231.27 | 2231.53 | 1318.0 |
| 2015-04-26 20:00:00 | ES | Futures | 2231.53 | 2231.8 | 2230.47 | 2231.53 | 3359.0 |
| 2015-04-26 21:00:00 | ES | Futures | 2231.53 | 2231.8 | 2230.21 | 2231.53 | 2913.0 |
| 2015-04-26 22:00:00 | ES | Futures | 2231.8 | 2232.06 | 2231.27 | 2231.53 | 1631.0 |
| 2015-04-26 23:00:00 | ES | Futures | 2231.8 | 2232.06 | 2231.0 | 2231.53 | 1156.0 |
| 2015-04-26 18:00:00 | NQ | Futures | 5331.96 | 5333.43 | 5329.61 | 5332.55 | 934.0 |
| 2015-04-26 19:00:00 | NQ | Futures | 5332.84 | 5334.02 | 5331.08 | 5331.67 | 164.0 |
| 2015-04-26 20:00:00 | NQ | Futures | 5331.67 | 5332.55 | 5329.02 | 5331.67 | 469.0 |
| 2015-04-26 21:00:00 | NQ | Futures | 5331.96 | 5332.84 | 5329.9 | 5332.84 | 423.0 |
| 2015-04-26 22:00:00 | NQ | Futures | 5332.84 | 5333.14 | 5331.67 | 5332.25 | 351.0 |
| 2015-04-26 23:00:00 | NQ | Futures | 5331.96 | 5332.25 | 5330.2 | 5331.37 | 356.0 |
| 2015-04-26 18:00:00 | YM | Futures | 18906.4 | 18910.6 | 18887.5 | 18900.1 | 355.0 |
| 2015-04-26 19:00:00 | YM | Futures | 18900.1 | 18903.3 | 18894.9 | 18897.0 | 108.0 |
| 2015-04-26 20:00:00 | YM | Futures | 18895.9 | 18899.1 | 18884.4 | 18895.9 | 435.0 |
| 2015-04-26 21:00:00 | YM | Futures | 18898.0 | 18901.2 | 18888.6 | 18900.1 | 401.0 |
| 2015-04-26 22:00:00 | YM | Futures | 18901.2 | 18902.2 | 18898.0 | 18901.2 | 188.0 |
| 2015-04-26 23:00:00 | YM | Futures | 18900.1 | 18902.2 | 18897.0 | 18898.0 | 224.0 |
| 2015-04-26 18:00:00 | CL | Futures | 87.36 | 87.6 | 87.06 | 87.21 | 893.0 |
| 2015-04-26 19:00:00 | CL | Futures | 87.22 | 87.3 | 87.07 | 87.3 | 507.0 |
| 2015-04-26 20:00:00 | CL | Futures | 87.3 | 87.3 | 87.09 | 87.13 | 777.0 |
| 2015-04-26 21:00:00 | CL | Futures | 87.13 | 87.22 | 87.02 | 87.07 | 1031.0 |
| 2015-04-26 22:00:00 | CL | Futures | 87.07 | 87.13 | 86.99 | 87.02 | 687.0 |
| 2015-04-26 23:00:00 | CL | Futures | 87.02 | 87.02 | 86.69 | 86.72 | 969.0 |
| 2015-04-26 18:00:00 | GC | Futures | 1610.6 | 1610.6 | 1608.6 | 1609.1 | 1161.0 |
| 2015-04-26 19:00:00 | GC | Futures | 1609.1 | 1611.0 | 1609.0 | 1610.1 | 729.0 |
| 2015-04-26 20:00:00 | GC | Futures | 1610.2 | 1613.2 | 1610.2 | 1610.6 | 2391.0 |
| 2015-04-26 21:00:00 | GC | Futures | 1610.5 | 1612.9 | 1608.3 | 1612.7 | 3602.0 |
| 2015-04-26 22:00:00 | GC | Futures | 1612.8 | 1615.3 | 1612.7 | 1614.3 | 3651.0 |
| 2015-04-26 23:00:00 | GC | Futures | 1614.2 | 1615.0 | 1613.8 | 1613.8 | 1467.0 |
| 2015-04-26 18:00:00 | ZN | Futures | 123.693915 | 123.738715 | 123.693915 | 123.723782 | 1491.0 |
| 2015-04-26 19:00:00 | ZN | Futures | 123.708848 | 123.738715 | 123.708848 | 123.738715 | 1774.0 |
| 2015-04-26 20:00:00 | ZN | Futures | 123.738715 | 123.768582 | 123.723782 | 123.753649 | 2774.0 |
| 2015-04-26 21:00:00 | ZN | Futures | 123.753649 | 123.753649 | 123.708848 | 123.723782 | 3392.0 |
| 2015-04-26 22:00:00 | ZN | Futures | 123.738715 | 123.768582 | 123.738715 | 123.753649 | 1504.0 |
| 2015-04-26 23:00:00 | ZN | Futures | 123.753649 | 123.783516 | 123.738715 | 123.768582 | 5036.0 |
> showing 36 of 268 rows — these rows as CSV