PREVIEW / futures_1hour / 2013-05-19
file: by_date/futures_1hour/2013/2013-05-19.parquet size: 14 KB rows: 269
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-05-19 18:00:00 | ES | Futures | 1712.94 | 1714.22 | 1711.65 | 1713.97 | 7873.0 |
| 2013-05-19 19:00:00 | ES | Futures | 1713.71 | 1714.48 | 1712.94 | 1713.19 | 2451.0 |
| 2013-05-19 20:00:00 | ES | Futures | 1713.19 | 1713.71 | 1712.42 | 1712.94 | 3717.0 |
| 2013-05-19 21:00:00 | ES | Futures | 1712.68 | 1715.0 | 1712.68 | 1713.97 | 6767.0 |
| 2013-05-19 22:00:00 | ES | Futures | 1714.22 | 1714.74 | 1713.45 | 1713.97 | 3504.0 |
| 2013-05-19 23:00:00 | ES | Futures | 1713.97 | 1714.74 | 1711.91 | 1713.45 | 12093.0 |
| 2013-05-19 18:00:00 | NQ | Futures | 3524.81 | 3527.14 | 3521.6 | 3526.85 | 1888.0 |
| 2013-05-19 19:00:00 | NQ | Futures | 3526.56 | 3527.72 | 3523.64 | 3523.93 | 555.0 |
| 2013-05-19 20:00:00 | NQ | Futures | 3523.93 | 3525.1 | 3522.18 | 3523.06 | 1001.0 |
| 2013-05-19 21:00:00 | NQ | Futures | 3522.77 | 3529.18 | 3522.77 | 3528.02 | 1094.0 |
| 2013-05-19 22:00:00 | NQ | Futures | 3527.72 | 3528.02 | 3526.27 | 3527.14 | 699.0 |
| 2013-05-19 23:00:00 | NQ | Futures | 3526.56 | 3528.31 | 3523.06 | 3525.39 | 983.0 |
| 2013-05-19 18:00:00 | YM | Futures | 15468.5 | 15484.6 | 15459.4 | 15480.6 | 1329.0 |
| 2013-05-19 19:00:00 | YM | Futures | 15480.6 | 15486.7 | 15477.6 | 15479.6 | 439.0 |
| 2013-05-19 20:00:00 | YM | Futures | 15479.6 | 15483.6 | 15473.5 | 15477.6 | 695.0 |
| 2013-05-19 21:00:00 | YM | Futures | 15477.6 | 15492.7 | 15476.6 | 15488.7 | 672.0 |
| 2013-05-19 22:00:00 | YM | Futures | 15488.7 | 15491.7 | 15483.6 | 15487.7 | 511.0 |
| 2013-05-19 23:00:00 | YM | Futures | 15487.7 | 15492.7 | 15471.5 | 15482.6 | 1070.0 |
| 2013-05-19 18:00:00 | CL | Futures | 150.8 | 151.27 | 150.08 | 150.52 | 1656.0 |
| 2013-05-19 19:00:00 | CL | Futures | 150.52 | 150.85 | 150.46 | 150.63 | 778.0 |
| 2013-05-19 20:00:00 | CL | Futures | 150.63 | 151.04 | 150.58 | 150.91 | 900.0 |
| 2013-05-19 21:00:00 | CL | Futures | 150.91 | 151.0 | 150.69 | 150.78 | 726.0 |
| 2013-05-19 22:00:00 | CL | Futures | 150.78 | 150.86 | 150.77 | 150.82 | 196.0 |
| 2013-05-19 23:00:00 | CL | Futures | 150.8 | 150.86 | 150.58 | 150.82 | 786.0 |
| 2013-05-19 18:00:00 | GC | Futures | 1869.7 | 1873.4 | 1836.5 | 1843.1 | 14948.0 |
| 2013-05-19 19:00:00 | GC | Futures | 1843.3 | 1851.4 | 1840.9 | 1849.8 | 5745.0 |
| 2013-05-19 20:00:00 | GC | Futures | 1849.6 | 1850.6 | 1835.4 | 1849.4 | 7185.0 |
| 2013-05-19 21:00:00 | GC | Futures | 1848.8 | 1854.2 | 1844.6 | 1847.3 | 7305.0 |
| 2013-05-19 22:00:00 | GC | Futures | 1847.2 | 1852.4 | 1846.8 | 1849.4 | 3962.0 |
| 2013-05-19 23:00:00 | GC | Futures | 1849.4 | 1849.6 | 1840.4 | 1844.4 | 5718.0 |
| 2013-05-19 18:00:00 | ZN | Futures | 118.529666 | 118.543708 | 118.403287 | 118.417329 | 8340.0 |
| 2013-05-19 19:00:00 | ZN | Futures | 118.417329 | 118.459455 | 118.403287 | 118.445413 | 6900.0 |
| 2013-05-19 20:00:00 | ZN | Futures | 118.445413 | 118.48754 | 118.445413 | 118.473497 | 6102.0 |
| 2013-05-19 21:00:00 | ZN | Futures | 118.473497 | 118.473497 | 118.403287 | 118.445413 | 6612.0 |
| 2013-05-19 22:00:00 | ZN | Futures | 118.445413 | 118.459455 | 118.431371 | 118.445413 | 2375.0 |
| 2013-05-19 23:00:00 | ZN | Futures | 118.445413 | 118.445413 | 118.347118 | 118.36116 | 14721.0 |
> showing 36 of 269 rows — these rows as CSV