PREVIEW / futures_1hour / 2013-09-08
file: by_date/futures_1hour/2013/2013-09-08.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-09-08 18:00:00 | ES | Futures | 1708.13 | 1714.34 | 1708.13 | 1712.27 | 10507.0 |
| 2013-09-08 19:00:00 | ES | Futures | 1712.27 | 1713.56 | 1711.75 | 1712.79 | 2365.0 |
| 2013-09-08 20:00:00 | ES | Futures | 1712.79 | 1713.3 | 1710.98 | 1711.75 | 4538.0 |
| 2013-09-08 21:00:00 | ES | Futures | 1711.49 | 1713.05 | 1710.98 | 1712.27 | 3723.0 |
| 2013-09-08 22:00:00 | ES | Futures | 1712.27 | 1713.05 | 1710.98 | 1712.79 | 2797.0 |
| 2013-09-08 23:00:00 | ES | Futures | 1713.05 | 1715.63 | 1712.79 | 1714.08 | 5650.0 |
| 2013-09-08 18:00:00 | NQ | Futures | 3662.01 | 3670.19 | 3659.38 | 3666.98 | 1032.0 |
| 2013-09-08 19:00:00 | NQ | Futures | 3666.68 | 3669.9 | 3666.1 | 3669.02 | 390.0 |
| 2013-09-08 20:00:00 | NQ | Futures | 3669.31 | 3669.61 | 3665.51 | 3666.39 | 541.0 |
| 2013-09-08 21:00:00 | NQ | Futures | 3666.98 | 3669.31 | 3665.51 | 3668.14 | 416.0 |
| 2013-09-08 22:00:00 | NQ | Futures | 3667.85 | 3669.9 | 3665.51 | 3669.31 | 437.0 |
| 2013-09-08 23:00:00 | NQ | Futures | 3669.31 | 3673.7 | 3669.02 | 3671.65 | 848.0 |
| 2013-09-08 18:00:00 | YM | Futures | 15141.8 | 15173.3 | 15125.5 | 15163.1 | 1690.0 |
| 2013-09-08 19:00:00 | YM | Futures | 15163.1 | 15170.2 | 15160.1 | 15169.2 | 264.0 |
| 2013-09-08 20:00:00 | YM | Futures | 15168.2 | 15169.2 | 15155.0 | 15160.1 | 657.0 |
| 2013-09-08 21:00:00 | YM | Futures | 15161.1 | 15170.2 | 15156.0 | 15166.2 | 881.0 |
| 2013-09-08 22:00:00 | YM | Futures | 15166.2 | 15168.2 | 15156.0 | 15168.2 | 549.0 |
| 2013-09-08 23:00:00 | YM | Futures | 15168.2 | 15186.5 | 15167.2 | 15179.4 | 765.0 |
| 2013-09-08 18:00:00 | CL | Futures | 174.1 | 174.1 | 173.28 | 173.52 | 1938.0 |
| 2013-09-08 19:00:00 | CL | Futures | 173.55 | 173.77 | 173.38 | 173.53 | 773.0 |
| 2013-09-08 20:00:00 | CL | Futures | 173.53 | 174.26 | 173.5 | 173.93 | 2000.0 |
| 2013-09-08 21:00:00 | CL | Futures | 173.94 | 174.12 | 173.77 | 174.07 | 768.0 |
| 2013-09-08 22:00:00 | CL | Futures | 174.05 | 174.26 | 173.93 | 174.2 | 767.0 |
| 2013-09-08 23:00:00 | CL | Futures | 174.16 | 174.21 | 174.09 | 174.15 | 327.0 |
| 2013-09-08 18:00:00 | GC | Futures | 1906.9 | 1912.2 | 1898.5 | 1901.5 | 1865.0 |
| 2013-09-08 19:00:00 | GC | Futures | 1901.4 | 1903.7 | 1901.4 | 1903.7 | 570.0 |
| 2013-09-08 20:00:00 | GC | Futures | 1903.3 | 1906.2 | 1900.3 | 1905.4 | 1814.0 |
| 2013-09-08 21:00:00 | GC | Futures | 1905.2 | 1907.8 | 1903.2 | 1904.4 | 2056.0 |
| 2013-09-08 22:00:00 | GC | Futures | 1904.7 | 1905.2 | 1901.5 | 1903.6 | 1600.0 |
| 2013-09-08 23:00:00 | GC | Futures | 1903.6 | 1904.0 | 1901.9 | 1902.8 | 556.0 |
| 2013-09-08 18:00:00 | ZN | Futures | 112.415455 | 112.44402 | 112.372609 | 112.386891 | 6320.0 |
| 2013-09-08 19:00:00 | ZN | Futures | 112.386891 | 112.386891 | 112.358326 | 112.372609 | 4499.0 |
| 2013-09-08 20:00:00 | ZN | Futures | 112.372609 | 112.401173 | 112.31548 | 112.386891 | 11597.0 |
| 2013-09-08 21:00:00 | ZN | Futures | 112.386891 | 112.386891 | 112.329762 | 112.344044 | 8541.0 |
| 2013-09-08 22:00:00 | ZN | Futures | 112.344044 | 112.386891 | 112.329762 | 112.358326 | 2047.0 |
| 2013-09-08 23:00:00 | ZN | Futures | 112.358326 | 112.372609 | 112.329762 | 112.358326 | 2900.0 |
> showing 36 of 263 rows — these rows as CSV