PREVIEW / futures_1hour / 2014-04-13
file: by_date/futures_1hour/2014/2014-04-13.parquet size: 14 KB rows: 277
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 |
|---|---|---|---|---|---|---|---|
| 2014-04-13 18:00:00 | ES | Futures | 1875.86 | 1878.2 | 1873.01 | 1875.35 | 21893.0 |
| 2014-04-13 19:00:00 | ES | Futures | 1875.6 | 1877.68 | 1874.83 | 1877.42 | 6158.0 |
| 2014-04-13 20:00:00 | ES | Futures | 1877.16 | 1881.06 | 1876.9 | 1877.16 | 12529.0 |
| 2014-04-13 21:00:00 | ES | Futures | 1877.16 | 1881.06 | 1876.64 | 1880.54 | 7366.0 |
| 2014-04-13 22:00:00 | ES | Futures | 1880.54 | 1881.06 | 1877.68 | 1878.46 | 6117.0 |
| 2014-04-13 23:00:00 | ES | Futures | 1878.46 | 1879.24 | 1877.68 | 1878.46 | 2597.0 |
| 2014-04-13 18:00:00 | NQ | Futures | 4002.27 | 4002.56 | 3990.04 | 3997.03 | 2473.0 |
| 2014-04-13 19:00:00 | NQ | Futures | 3996.44 | 4003.72 | 3995.57 | 4002.27 | 1017.0 |
| 2014-04-13 20:00:00 | NQ | Futures | 4002.85 | 4011.88 | 3998.77 | 3999.36 | 2736.0 |
| 2014-04-13 21:00:00 | NQ | Futures | 3999.65 | 4008.97 | 3999.06 | 4008.67 | 1285.0 |
| 2014-04-13 22:00:00 | NQ | Futures | 4008.67 | 4009.26 | 4002.85 | 4004.6 | 1205.0 |
| 2014-04-13 23:00:00 | NQ | Futures | 4004.89 | 4007.22 | 4003.43 | 4005.76 | 522.0 |
| 2014-04-13 18:00:00 | YM | Futures | 16423.2 | 16424.2 | 16355.2 | 16406.7 | 1915.0 |
| 2014-04-13 19:00:00 | YM | Futures | 16407.7 | 16417.0 | 16398.5 | 16416.0 | 1028.0 |
| 2014-04-13 20:00:00 | YM | Futures | 16413.9 | 16444.8 | 16413.9 | 16416.0 | 1684.0 |
| 2014-04-13 21:00:00 | YM | Futures | 16416.0 | 16442.7 | 16413.9 | 16441.7 | 888.0 |
| 2014-04-13 22:00:00 | YM | Futures | 16441.7 | 16442.7 | 16421.1 | 16424.2 | 719.0 |
| 2014-04-13 23:00:00 | YM | Futures | 16423.2 | 16431.4 | 16423.2 | 16427.3 | 462.0 |
| 2014-04-13 18:00:00 | CL | Futures | 163.94 | 165.24 | 163.94 | 165.11 | 573.0 |
| 2014-04-13 19:00:00 | CL | Futures | 165.13 | 165.17 | 164.98 | 165.14 | 117.0 |
| 2014-04-13 20:00:00 | CL | Futures | 165.14 | 165.57 | 165.14 | 165.46 | 332.0 |
| 2014-04-13 21:00:00 | CL | Futures | 165.43 | 165.53 | 165.37 | 165.46 | 191.0 |
| 2014-04-13 22:00:00 | CL | Futures | 165.46 | 165.56 | 165.4 | 165.43 | 96.0 |
| 2014-04-13 23:00:00 | CL | Futures | 165.48 | 165.59 | 165.4 | 165.49 | 155.0 |
| 2014-04-13 18:00:00 | GC | Futures | 1809.6 | 1820.0 | 1807.4 | 1819.1 | 4881.0 |
| 2014-04-13 19:00:00 | GC | Futures | 1818.9 | 1820.6 | 1816.9 | 1817.6 | 1785.0 |
| 2014-04-13 20:00:00 | GC | Futures | 1817.6 | 1818.1 | 1814.6 | 1816.6 | 2533.0 |
| 2014-04-13 21:00:00 | GC | Futures | 1816.5 | 1819.1 | 1815.8 | 1818.1 | 2446.0 |
| 2014-04-13 22:00:00 | GC | Futures | 1818.1 | 1821.1 | 1817.8 | 1819.4 | 2384.0 |
| 2014-04-13 23:00:00 | GC | Futures | 1819.2 | 1819.5 | 1816.9 | 1817.7 | 1283.0 |
| 2014-04-13 18:00:00 | ZN | Futures | 116.864915 | 117.098967 | 116.835659 | 116.981941 | 19308.0 |
| 2014-04-13 19:00:00 | ZN | Futures | 116.967313 | 116.996569 | 116.938056 | 116.952685 | 4874.0 |
| 2014-04-13 20:00:00 | ZN | Futures | 116.967313 | 116.967313 | 116.879543 | 116.9088 | 10516.0 |
| 2014-04-13 21:00:00 | ZN | Futures | 116.9088 | 116.923428 | 116.850287 | 116.879543 | 8669.0 |
| 2014-04-13 22:00:00 | ZN | Futures | 116.879543 | 116.894172 | 116.864915 | 116.879543 | 2649.0 |
| 2014-04-13 23:00:00 | ZN | Futures | 116.894172 | 116.9088 | 116.879543 | 116.9088 | 1447.0 |
> showing 36 of 277 rows — these rows as CSV