PREVIEW / futures_1hour / 2013-09-29
file: by_date/futures_1hour/2013/2013-09-29.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 |
|---|---|---|---|---|---|---|---|
| 2013-09-29 18:00:00 | ES | Futures | 1728.33 | 1729.62 | 1725.24 | 1729.11 | 29992.0 |
| 2013-09-29 19:00:00 | ES | Futures | 1728.85 | 1729.37 | 1726.79 | 1728.08 | 6938.0 |
| 2013-09-29 20:00:00 | ES | Futures | 1728.08 | 1728.08 | 1724.47 | 1725.5 | 11990.0 |
| 2013-09-29 21:00:00 | ES | Futures | 1725.76 | 1726.79 | 1724.98 | 1725.5 | 7496.0 |
| 2013-09-29 22:00:00 | ES | Futures | 1725.5 | 1728.59 | 1725.24 | 1728.08 | 6055.0 |
| 2013-09-29 23:00:00 | ES | Futures | 1728.33 | 1729.37 | 1727.56 | 1729.37 | 3146.0 |
| 2013-09-29 18:00:00 | NQ | Futures | 3730.9 | 3731.77 | 3721.02 | 3727.41 | 2791.0 |
| 2013-09-29 19:00:00 | NQ | Futures | 3728.28 | 3728.86 | 3723.34 | 3725.67 | 767.0 |
| 2013-09-29 20:00:00 | NQ | Futures | 3725.38 | 3725.67 | 3717.83 | 3720.44 | 1708.0 |
| 2013-09-29 21:00:00 | NQ | Futures | 3720.44 | 3722.47 | 3719.28 | 3720.15 | 973.0 |
| 2013-09-29 22:00:00 | NQ | Futures | 3720.15 | 3726.83 | 3719.86 | 3726.25 | 1087.0 |
| 2013-09-29 23:00:00 | NQ | Futures | 3726.25 | 3728.86 | 3725.67 | 3727.99 | 431.0 |
| 2013-09-29 18:00:00 | YM | Futures | 15438.2 | 15440.2 | 15397.3 | 15415.7 | 2684.0 |
| 2013-09-29 19:00:00 | YM | Futures | 15416.7 | 15417.8 | 15404.5 | 15411.6 | 868.0 |
| 2013-09-29 20:00:00 | YM | Futures | 15410.6 | 15412.7 | 15389.2 | 15395.3 | 1460.0 |
| 2013-09-29 21:00:00 | YM | Futures | 15395.3 | 15402.4 | 15391.2 | 15393.3 | 914.0 |
| 2013-09-29 22:00:00 | YM | Futures | 15393.3 | 15416.7 | 15393.3 | 15413.7 | 905.0 |
| 2013-09-29 23:00:00 | YM | Futures | 15414.7 | 15424.9 | 15411.6 | 15421.9 | 470.0 |
| 2013-09-29 18:00:00 | CL | Futures | 162.91 | 163.04 | 161.86 | 162.29 | 3529.0 |
| 2013-09-29 19:00:00 | CL | Futures | 162.31 | 162.39 | 162.12 | 162.18 | 732.0 |
| 2013-09-29 20:00:00 | CL | Futures | 162.18 | 162.18 | 161.31 | 161.42 | 4565.0 |
| 2013-09-29 21:00:00 | CL | Futures | 161.4 | 161.72 | 161.37 | 161.59 | 1451.0 |
| 2013-09-29 22:00:00 | CL | Futures | 161.59 | 161.72 | 161.58 | 161.67 | 540.0 |
| 2013-09-29 23:00:00 | CL | Futures | 161.66 | 161.67 | 161.45 | 161.51 | 846.0 |
| 2013-09-29 18:00:00 | GC | Futures | 1841.6 | 1855.7 | 1830.8 | 1837.5 | 5076.0 |
| 2013-09-29 19:00:00 | GC | Futures | 1837.5 | 1842.7 | 1837.1 | 1837.8 | 1959.0 |
| 2013-09-29 20:00:00 | GC | Futures | 1837.8 | 1840.7 | 1836.7 | 1837.1 | 1369.0 |
| 2013-09-29 21:00:00 | GC | Futures | 1837.4 | 1838.1 | 1834.6 | 1838.1 | 2171.0 |
| 2013-09-29 22:00:00 | GC | Futures | 1837.9 | 1838.7 | 1834.6 | 1836.8 | 1110.0 |
| 2013-09-29 23:00:00 | GC | Futures | 1836.6 | 1838.1 | 1835.5 | 1836.8 | 792.0 |
| 2013-09-29 18:00:00 | ZN | Futures | 115.671804 | 115.77178 | 115.64324 | 115.714651 | 17916.0 |
| 2013-09-29 19:00:00 | ZN | Futures | 115.728933 | 115.786062 | 115.728933 | 115.728933 | 6476.0 |
| 2013-09-29 20:00:00 | ZN | Futures | 115.728933 | 115.743215 | 115.671804 | 115.686087 | 9116.0 |
| 2013-09-29 21:00:00 | ZN | Futures | 115.686087 | 115.728933 | 115.671804 | 115.714651 | 8035.0 |
| 2013-09-29 22:00:00 | ZN | Futures | 115.714651 | 115.743215 | 115.64324 | 115.671804 | 6055.0 |
| 2013-09-29 23:00:00 | ZN | Futures | 115.671804 | 115.700369 | 115.657522 | 115.657522 | 3443.0 |
> showing 36 of 265 rows — these rows as CSV