PREVIEW / futures_1hour / 2013-04-14
file: by_date/futures_1hour/2013/2013-04-14.parquet size: 15 KB rows: 283
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-04-14 18:00:00 | ES | Futures | 1630.25 | 1631.02 | 1627.68 | 1627.68 | 8092.0 |
| 2013-04-14 19:00:00 | ES | Futures | 1627.93 | 1628.96 | 1626.65 | 1628.45 | 4826.0 |
| 2013-04-14 20:00:00 | ES | Futures | 1628.45 | 1629.99 | 1628.19 | 1629.48 | 6473.0 |
| 2013-04-14 21:00:00 | ES | Futures | 1629.48 | 1631.02 | 1628.96 | 1629.99 | 12492.0 |
| 2013-04-14 22:00:00 | ES | Futures | 1629.74 | 1629.74 | 1623.81 | 1625.36 | 26789.0 |
| 2013-04-14 23:00:00 | ES | Futures | 1625.36 | 1626.39 | 1623.04 | 1623.55 | 9649.0 |
| 2013-04-14 18:00:00 | NQ | Futures | 3320.93 | 3322.68 | 3315.97 | 3315.97 | 727.0 |
| 2013-04-14 19:00:00 | NQ | Futures | 3315.97 | 3318.6 | 3314.22 | 3317.43 | 272.0 |
| 2013-04-14 20:00:00 | NQ | Futures | 3317.14 | 3323.56 | 3316.85 | 3321.81 | 544.0 |
| 2013-04-14 21:00:00 | NQ | Futures | 3321.81 | 3326.18 | 3320.93 | 3323.85 | 861.0 |
| 2013-04-14 22:00:00 | NQ | Futures | 3323.56 | 3323.56 | 3311.31 | 3313.64 | 2335.0 |
| 2013-04-14 23:00:00 | NQ | Futures | 3313.35 | 3314.81 | 3308.68 | 3309.27 | 713.0 |
| 2013-04-14 18:00:00 | YM | Futures | 14948.8 | 14953.9 | 14933.7 | 14933.7 | 428.0 |
| 2013-04-14 19:00:00 | YM | Futures | 14932.7 | 14943.8 | 14924.6 | 14939.7 | 692.0 |
| 2013-04-14 20:00:00 | YM | Futures | 14938.7 | 14950.9 | 14938.7 | 14947.8 | 784.0 |
| 2013-04-14 21:00:00 | YM | Futures | 14946.8 | 14959.0 | 14943.8 | 14951.9 | 1219.0 |
| 2013-04-14 22:00:00 | YM | Futures | 14950.9 | 14950.9 | 14906.4 | 14917.5 | 3867.0 |
| 2013-04-14 23:00:00 | YM | Futures | 14917.5 | 14924.6 | 14898.3 | 14901.3 | 1195.0 |
| 2013-04-14 18:00:00 | CL | Futures | 143.47 | 143.47 | 142.61 | 142.64 | 453.0 |
| 2013-04-14 19:00:00 | CL | Futures | 142.64 | 143.0 | 142.61 | 142.71 | 184.0 |
| 2013-04-14 20:00:00 | CL | Futures | 142.71 | 142.89 | 142.7 | 142.75 | 195.0 |
| 2013-04-14 21:00:00 | CL | Futures | 142.76 | 142.79 | 142.35 | 142.37 | 398.0 |
| 2013-04-14 22:00:00 | CL | Futures | 142.35 | 142.35 | 140.97 | 141.1 | 2889.0 |
| 2013-04-14 23:00:00 | CL | Futures | 141.14 | 141.32 | 139.9 | 140.11 | 1563.0 |
| 2013-04-14 18:00:00 | GC | Futures | 2034.1 | 2038.8 | 2028.6 | 2036.7 | 8448.0 |
| 2013-04-14 19:00:00 | GC | Futures | 2036.7 | 2046.5 | 2036.2 | 2045.6 | 5186.0 |
| 2013-04-14 20:00:00 | GC | Futures | 2045.6 | 2053.3 | 2037.5 | 2039.5 | 10484.0 |
| 2013-04-14 21:00:00 | GC | Futures | 2039.5 | 2039.7 | 1982.5 | 1986.2 | 32544.0 |
| 2013-04-14 22:00:00 | GC | Futures | 1985.8 | 1990.6 | 1953.3 | 1979.4 | 31952.0 |
| 2013-04-14 23:00:00 | GC | Futures | 1979.2 | 1994.3 | 1969.3 | 1979.0 | 14579.0 |
| 2013-04-14 18:00:00 | ZN | Futures | 119.526658 | 119.568784 | 119.512616 | 119.568784 | 2081.0 |
| 2013-04-14 19:00:00 | ZN | Futures | 119.554742 | 119.582826 | 119.498573 | 119.512616 | 4716.0 |
| 2013-04-14 20:00:00 | ZN | Futures | 119.512616 | 119.512616 | 119.442405 | 119.470489 | 6847.0 |
| 2013-04-14 21:00:00 | ZN | Futures | 119.456447 | 119.470489 | 119.428363 | 119.470489 | 9415.0 |
| 2013-04-14 22:00:00 | ZN | Futures | 119.470489 | 119.512616 | 119.456447 | 119.484531 | 13537.0 |
| 2013-04-14 23:00:00 | ZN | Futures | 119.498573 | 119.568784 | 119.484531 | 119.554742 | 7315.0 |
> showing 36 of 283 rows — these rows as CSV