PREVIEW / futures_1hour / 2013-12-15
file: by_date/futures_1hour/2013/2013-12-15.parquet size: 14 KB rows: 264
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-12-15 18:00:00 | ES | Futures | 1829.71 | 1831.52 | 1828.94 | 1831.01 | 4487.0 |
| 2013-12-15 19:00:00 | ES | Futures | 1831.01 | 1832.82 | 1830.49 | 1831.78 | 5723.0 |
| 2013-12-15 20:00:00 | ES | Futures | 1831.78 | 1831.78 | 1829.71 | 1829.97 | 3660.0 |
| 2013-12-15 21:00:00 | ES | Futures | 1829.97 | 1830.75 | 1826.61 | 1827.9 | 5804.0 |
| 2013-12-15 22:00:00 | ES | Futures | 1827.9 | 1827.9 | 1814.71 | 1819.11 | 27289.0 |
| 2013-12-15 23:00:00 | ES | Futures | 1819.37 | 1821.95 | 1819.11 | 1821.44 | 3873.0 |
| 2013-12-15 18:00:00 | NQ | Futures | 4016.39 | 4019.59 | 4014.36 | 4019.01 | 457.0 |
| 2013-12-15 19:00:00 | NQ | Futures | 4018.43 | 4021.33 | 4017.55 | 4019.3 | 716.0 |
| 2013-12-15 20:00:00 | NQ | Futures | 4019.3 | 4019.59 | 4015.81 | 4016.68 | 702.0 |
| 2013-12-15 21:00:00 | NQ | Futures | 4016.97 | 4019.01 | 4010.29 | 4012.61 | 807.0 |
| 2013-12-15 22:00:00 | NQ | Futures | 4012.32 | 4012.61 | 3987.61 | 3994.01 | 5524.0 |
| 2013-12-15 23:00:00 | NQ | Futures | 3994.3 | 3998.95 | 3993.72 | 3998.37 | 932.0 |
| 2013-12-15 18:00:00 | YM | Futures | 16107.0 | 16107.0 | 16090.6 | 16106.0 | 701.0 |
| 2013-12-15 19:00:00 | YM | Futures | 16104.0 | 16114.2 | 16101.9 | 16108.1 | 805.0 |
| 2013-12-15 20:00:00 | YM | Futures | 16108.1 | 16110.1 | 16089.6 | 16094.7 | 1000.0 |
| 2013-12-15 21:00:00 | YM | Futures | 16094.7 | 16101.9 | 16076.3 | 16083.4 | 813.0 |
| 2013-12-15 22:00:00 | YM | Futures | 16083.4 | 16083.4 | 16004.5 | 16020.9 | 5022.0 |
| 2013-12-15 23:00:00 | YM | Futures | 16021.9 | 16039.4 | 16018.8 | 16037.3 | 787.0 |
| 2013-12-15 18:00:00 | CL | Futures | 152.45 | 152.9 | 152.45 | 152.87 | 562.0 |
| 2013-12-15 19:00:00 | CL | Futures | 152.87 | 152.9 | 152.76 | 152.79 | 91.0 |
| 2013-12-15 20:00:00 | CL | Futures | 152.79 | 152.79 | 152.54 | 152.6 | 202.0 |
| 2013-12-15 21:00:00 | CL | Futures | 152.6 | 152.7 | 152.46 | 152.48 | 133.0 |
| 2013-12-15 22:00:00 | CL | Futures | 152.49 | 152.56 | 152.26 | 152.35 | 229.0 |
| 2013-12-15 23:00:00 | CL | Futures | 152.37 | 152.42 | 152.18 | 152.27 | 162.0 |
| 2013-12-15 18:00:00 | GC | Futures | 1696.1 | 1697.3 | 1693.4 | 1693.6 | 856.0 |
| 2013-12-15 19:00:00 | GC | Futures | 1693.6 | 1694.3 | 1692.3 | 1692.8 | 936.0 |
| 2013-12-15 20:00:00 | GC | Futures | 1692.9 | 1694.3 | 1691.8 | 1693.7 | 1614.0 |
| 2013-12-15 21:00:00 | GC | Futures | 1693.9 | 1695.4 | 1693.4 | 1694.4 | 1065.0 |
| 2013-12-15 22:00:00 | GC | Futures | 1694.4 | 1695.0 | 1691.1 | 1693.3 | 1442.0 |
| 2013-12-15 23:00:00 | GC | Futures | 1693.6 | 1693.7 | 1690.2 | 1690.3 | 1020.0 |
| 2013-12-15 18:00:00 | ZN | Futures | 114.929124 | 114.929124 | 114.871335 | 114.885782 | 2608.0 |
| 2013-12-15 19:00:00 | ZN | Futures | 114.90023 | 114.958019 | 114.885782 | 114.943572 | 2654.0 |
| 2013-12-15 20:00:00 | ZN | Futures | 114.943572 | 114.986914 | 114.929124 | 114.986914 | 3525.0 |
| 2013-12-15 21:00:00 | ZN | Futures | 114.986914 | 115.015809 | 114.972467 | 115.001362 | 5671.0 |
| 2013-12-15 22:00:00 | ZN | Futures | 115.001362 | 115.102493 | 115.001362 | 115.073599 | 14004.0 |
| 2013-12-15 23:00:00 | ZN | Futures | 115.088046 | 115.116941 | 115.059151 | 115.059151 | 5213.0 |
> showing 36 of 264 rows — these rows as CSV