PREVIEW / futures_1hour / 2013-08-04
file: by_date/futures_1hour/2013/2013-08-04.parquet size: 14 KB rows: 263
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-04 18:00:00 | ES | Futures | 1760.61 | 1761.64 | 1759.06 | 1760.35 | 3389.0 |
| 2013-08-04 19:00:00 | ES | Futures | 1760.35 | 1760.87 | 1759.83 | 1760.35 | 2204.0 |
| 2013-08-04 20:00:00 | ES | Futures | 1760.35 | 1760.61 | 1759.06 | 1759.32 | 3261.0 |
| 2013-08-04 21:00:00 | ES | Futures | 1759.32 | 1760.35 | 1759.06 | 1759.32 | 2832.0 |
| 2013-08-04 22:00:00 | ES | Futures | 1759.57 | 1760.35 | 1759.32 | 1760.09 | 1264.0 |
| 2013-08-04 23:00:00 | ES | Futures | 1760.09 | 1760.35 | 1759.57 | 1760.09 | 1445.0 |
| 2013-08-04 18:00:00 | NQ | Futures | 3666.1 | 3666.39 | 3662.59 | 3664.64 | 612.0 |
| 2013-08-04 19:00:00 | NQ | Futures | 3664.35 | 3665.51 | 3663.47 | 3664.64 | 222.0 |
| 2013-08-04 20:00:00 | NQ | Futures | 3664.64 | 3664.64 | 3661.72 | 3662.3 | 490.0 |
| 2013-08-04 21:00:00 | NQ | Futures | 3662.3 | 3664.35 | 3661.72 | 3662.88 | 507.0 |
| 2013-08-04 22:00:00 | NQ | Futures | 3662.88 | 3664.35 | 3662.59 | 3664.05 | 322.0 |
| 2013-08-04 23:00:00 | NQ | Futures | 3664.05 | 3665.22 | 3663.47 | 3664.64 | 279.0 |
| 2013-08-04 18:00:00 | YM | Futures | 15829.4 | 15834.5 | 15817.2 | 15825.3 | 331.0 |
| 2013-08-04 19:00:00 | YM | Futures | 15825.3 | 15831.4 | 15821.3 | 15829.4 | 182.0 |
| 2013-08-04 20:00:00 | YM | Futures | 15827.4 | 15827.4 | 15817.2 | 15818.2 | 543.0 |
| 2013-08-04 21:00:00 | YM | Futures | 15819.2 | 15826.3 | 15817.2 | 15820.3 | 564.0 |
| 2013-08-04 22:00:00 | YM | Futures | 15820.3 | 15825.3 | 15819.2 | 15825.3 | 273.0 |
| 2013-08-04 23:00:00 | YM | Futures | 15824.3 | 15825.3 | 15818.2 | 15823.3 | 195.0 |
| 2013-08-04 18:00:00 | CL | Futures | 167.94 | 168.08 | 167.55 | 167.93 | 707.0 |
| 2013-08-04 19:00:00 | CL | Futures | 167.94 | 167.96 | 167.58 | 167.64 | 707.0 |
| 2013-08-04 20:00:00 | CL | Futures | 167.66 | 167.66 | 166.64 | 167.01 | 3035.0 |
| 2013-08-04 21:00:00 | CL | Futures | 167.0 | 167.94 | 166.98 | 167.74 | 1909.0 |
| 2013-08-04 22:00:00 | CL | Futures | 167.72 | 168.35 | 167.72 | 168.08 | 1732.0 |
| 2013-08-04 23:00:00 | CL | Futures | 168.11 | 168.55 | 167.96 | 168.44 | 1097.0 |
| 2013-08-04 18:00:00 | GC | Futures | 1798.7 | 1801.7 | 1796.5 | 1800.6 | 846.0 |
| 2013-08-04 19:00:00 | GC | Futures | 1800.2 | 1800.6 | 1797.2 | 1798.2 | 600.0 |
| 2013-08-04 20:00:00 | GC | Futures | 1798.3 | 1800.2 | 1796.5 | 1798.0 | 1306.0 |
| 2013-08-04 21:00:00 | GC | Futures | 1797.9 | 1802.3 | 1797.8 | 1800.8 | 1863.0 |
| 2013-08-04 22:00:00 | GC | Futures | 1800.6 | 1802.3 | 1800.1 | 1801.9 | 1112.0 |
| 2013-08-04 23:00:00 | GC | Futures | 1801.6 | 1809.8 | 1801.6 | 1804.8 | 3494.0 |
| 2013-08-04 18:00:00 | ZN | Futures | 114.623012 | 114.693767 | 114.623012 | 114.651314 | 3670.0 |
| 2013-08-04 19:00:00 | ZN | Futures | 114.651314 | 114.665465 | 114.608861 | 114.637163 | 3373.0 |
| 2013-08-04 20:00:00 | ZN | Futures | 114.637163 | 114.651314 | 114.552257 | 114.552257 | 6634.0 |
| 2013-08-04 21:00:00 | ZN | Futures | 114.552257 | 114.580559 | 114.509804 | 114.566408 | 10369.0 |
| 2013-08-04 22:00:00 | ZN | Futures | 114.552257 | 114.566408 | 114.509804 | 114.552257 | 4185.0 |
| 2013-08-04 23:00:00 | ZN | Futures | 114.552257 | 114.59471 | 114.538106 | 114.566408 | 2131.0 |
> showing 36 of 263 rows — these rows as CSV