PREVIEW / futures_1hour / 2013-09-15
file: by_date/futures_1hour/2013/2013-09-15.parquet size: 14 KB rows: 275
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-15 18:00:00 | ES | Futures | 1746.91 | 1758.0 | 1745.88 | 1754.9 | 64976.0 |
| 2013-09-15 19:00:00 | ES | Futures | 1754.9 | 1755.94 | 1753.36 | 1754.13 | 11627.0 |
| 2013-09-15 20:00:00 | ES | Futures | 1753.87 | 1754.65 | 1753.36 | 1753.87 | 8065.0 |
| 2013-09-15 21:00:00 | ES | Futures | 1753.87 | 1754.39 | 1753.1 | 1753.61 | 5161.0 |
| 2013-09-15 22:00:00 | ES | Futures | 1753.36 | 1754.13 | 1753.1 | 1754.13 | 2466.0 |
| 2013-09-15 23:00:00 | ES | Futures | 1754.13 | 1754.9 | 1753.61 | 1754.9 | 2791.0 |
| 2013-09-15 18:00:00 | NQ | Futures | 3718.12 | 3732.93 | 3713.76 | 3726.83 | 5284.0 |
| 2013-09-15 19:00:00 | NQ | Futures | 3726.83 | 3728.57 | 3721.89 | 3722.76 | 1477.0 |
| 2013-09-15 20:00:00 | NQ | Futures | 3722.76 | 3723.34 | 3721.31 | 3721.89 | 979.0 |
| 2013-09-15 21:00:00 | NQ | Futures | 3721.6 | 3722.47 | 3720.44 | 3721.02 | 530.0 |
| 2013-09-15 22:00:00 | NQ | Futures | 3720.73 | 3722.76 | 3719.86 | 3721.89 | 295.0 |
| 2013-09-15 23:00:00 | NQ | Futures | 3722.18 | 3724.51 | 3721.89 | 3723.34 | 341.0 |
| 2013-09-15 18:00:00 | YM | Futures | 15696.6 | 15840.6 | 15696.6 | 15817.1 | 5337.0 |
| 2013-09-15 19:00:00 | YM | Futures | 15816.1 | 15823.2 | 15803.8 | 15809.9 | 741.0 |
| 2013-09-15 20:00:00 | YM | Futures | 15807.9 | 15809.9 | 15800.7 | 15802.8 | 843.0 |
| 2013-09-15 21:00:00 | YM | Futures | 15803.8 | 15804.8 | 15797.7 | 15798.7 | 332.0 |
| 2013-09-15 22:00:00 | YM | Futures | 15798.7 | 15802.8 | 15797.7 | 15801.8 | 349.0 |
| 2013-09-15 23:00:00 | YM | Futures | 15801.8 | 15810.9 | 15800.7 | 15808.9 | 240.0 |
| 2013-09-15 18:00:00 | CL | Futures | 170.38 | 170.38 | 168.68 | 169.59 | 1892.0 |
| 2013-09-15 19:00:00 | CL | Futures | 169.59 | 169.61 | 169.34 | 169.51 | 277.0 |
| 2013-09-15 20:00:00 | CL | Futures | 169.51 | 170.0 | 169.46 | 169.96 | 372.0 |
| 2013-09-15 21:00:00 | CL | Futures | 169.97 | 169.97 | 169.65 | 169.78 | 394.0 |
| 2013-09-15 22:00:00 | CL | Futures | 169.78 | 169.8 | 169.59 | 169.65 | 134.0 |
| 2013-09-15 23:00:00 | CL | Futures | 169.65 | 169.7 | 169.46 | 169.7 | 128.0 |
| 2013-09-15 18:00:00 | GC | Futures | 1827.9 | 1831.3 | 1816.1 | 1824.5 | 8281.0 |
| 2013-09-15 19:00:00 | GC | Futures | 1824.2 | 1825.2 | 1818.3 | 1822.8 | 2346.0 |
| 2013-09-15 20:00:00 | GC | Futures | 1822.8 | 1826.1 | 1818.9 | 1824.9 | 2692.0 |
| 2013-09-15 21:00:00 | GC | Futures | 1824.5 | 1825.6 | 1813.8 | 1823.1 | 7030.0 |
| 2013-09-15 22:00:00 | GC | Futures | 1823.1 | 1827.1 | 1821.3 | 1824.9 | 2379.0 |
| 2013-09-15 23:00:00 | GC | Futures | 1825.0 | 1826.1 | 1823.3 | 1823.4 | 1267.0 |
| 2013-09-15 18:00:00 | ZN | Futures | 113.529469 | 114.057912 | 113.486623 | 113.872243 | 60035.0 |
| 2013-09-15 19:00:00 | ZN | Futures | 113.872243 | 113.886525 | 113.78655 | 113.800832 | 15521.0 |
| 2013-09-15 20:00:00 | ZN | Futures | 113.800832 | 113.857961 | 113.772267 | 113.843679 | 13947.0 |
| 2013-09-15 21:00:00 | ZN | Futures | 113.843679 | 113.857961 | 113.743703 | 113.843679 | 11684.0 |
| 2013-09-15 22:00:00 | ZN | Futures | 113.843679 | 113.886525 | 113.815114 | 113.843679 | 7940.0 |
| 2013-09-15 23:00:00 | ZN | Futures | 113.857961 | 113.900807 | 113.829396 | 113.886525 | 4742.0 |
> showing 36 of 275 rows — these rows as CSV