PREVIEW / futures_1hour / 2010-12-19
file: by_date/futures_1hour/2010/2010-12-19.parquet size: 14 KB rows: 257
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 |
|---|---|---|---|---|---|---|---|
| 2010-12-19 18:00:00 | ES | Futures | 1227.24 | 1227.73 | 1226.5 | 1227.49 | 5479.0 |
| 2010-12-19 19:00:00 | ES | Futures | 1227.49 | 1227.98 | 1225.26 | 1225.51 | 4865.0 |
| 2010-12-19 20:00:00 | ES | Futures | 1225.75 | 1226.0 | 1225.01 | 1225.01 | 2708.0 |
| 2010-12-19 21:00:00 | ES | Futures | 1225.26 | 1226.5 | 1225.26 | 1226.0 | 1721.0 |
| 2010-12-19 22:00:00 | ES | Futures | 1226.0 | 1226.0 | 1221.55 | 1222.04 | 12301.0 |
| 2010-12-19 23:00:00 | ES | Futures | 1222.04 | 1222.78 | 1221.3 | 1222.29 | 3296.0 |
| 2010-12-19 18:00:00 | NQ | Futures | 2544.26 | 2545.98 | 2543.39 | 2544.83 | 398.0 |
| 2010-12-19 19:00:00 | NQ | Futures | 2545.12 | 2545.69 | 2541.39 | 2542.53 | 295.0 |
| 2010-12-19 20:00:00 | NQ | Futures | 2542.53 | 2542.82 | 2540.81 | 2541.1 | 291.0 |
| 2010-12-19 21:00:00 | NQ | Futures | 2541.39 | 2543.39 | 2541.1 | 2541.96 | 150.0 |
| 2010-12-19 22:00:00 | NQ | Futures | 2541.96 | 2541.96 | 2534.21 | 2535.07 | 929.0 |
| 2010-12-19 23:00:00 | NQ | Futures | 2535.07 | 2536.22 | 2533.92 | 2534.5 | 289.0 |
| 2010-12-19 18:00:00 | YM | Futures | 10959.9 | 10963.7 | 10954.2 | 10958.0 | 253.0 |
| 2010-12-19 19:00:00 | YM | Futures | 10959.9 | 10975.2 | 10945.5 | 10948.4 | 367.0 |
| 2010-12-19 20:00:00 | YM | Futures | 10949.4 | 10951.3 | 10941.7 | 10941.7 | 132.0 |
| 2010-12-19 21:00:00 | YM | Futures | 10944.6 | 10951.3 | 10944.6 | 10947.5 | 82.0 |
| 2010-12-19 22:00:00 | YM | Futures | 10946.5 | 10946.5 | 10913.9 | 10915.8 | 374.0 |
| 2010-12-19 23:00:00 | YM | Futures | 10917.8 | 10923.5 | 10914.9 | 10919.7 | 203.0 |
| 2010-12-19 18:00:00 | CL | Futures | 164.68 | 165.08 | 164.42 | 165.08 | 800.0 |
| 2010-12-19 19:00:00 | CL | Futures | 165.07 | 165.2 | 164.86 | 164.92 | 1022.0 |
| 2010-12-19 20:00:00 | CL | Futures | 164.92 | 165.1 | 164.82 | 164.94 | 649.0 |
| 2010-12-19 21:00:00 | CL | Futures | 164.94 | 165.08 | 164.71 | 164.75 | 652.0 |
| 2010-12-19 22:00:00 | CL | Futures | 164.75 | 164.77 | 163.86 | 164.03 | 1710.0 |
| 2010-12-19 23:00:00 | CL | Futures | 164.05 | 164.21 | 163.9 | 163.9 | 584.0 |
| 2010-12-19 18:00:00 | GC | Futures | 1923.4 | 1932.3 | 1923.4 | 1930.4 | 3684.0 |
| 2010-12-19 19:00:00 | GC | Futures | 1930.2 | 1935.1 | 1928.6 | 1932.6 | 3292.0 |
| 2010-12-19 20:00:00 | GC | Futures | 1932.6 | 1936.4 | 1932.6 | 1934.7 | 2139.0 |
| 2010-12-19 21:00:00 | GC | Futures | 1934.7 | 1935.7 | 1933.6 | 1934.7 | 922.0 |
| 2010-12-19 22:00:00 | GC | Futures | 1934.6 | 1935.4 | 1932.9 | 1933.3 | 981.0 |
| 2010-12-19 23:00:00 | GC | Futures | 1933.4 | 1934.4 | 1931.9 | 1931.9 | 1708.0 |
| 2010-12-19 18:00:00 | ZN | Futures | 101.114745 | 101.114745 | 101.022763 | 101.101605 | 2977.0 |
| 2010-12-19 19:00:00 | ZN | Futures | 101.088465 | 101.193587 | 101.062184 | 101.167307 | 3491.0 |
| 2010-12-19 20:00:00 | ZN | Futures | 101.167307 | 101.31185 | 101.154166 | 101.29871 | 3863.0 |
| 2010-12-19 21:00:00 | ZN | Futures | 101.29871 | 101.31185 | 101.233008 | 101.259289 | 2896.0 |
| 2010-12-19 22:00:00 | ZN | Futures | 101.272429 | 101.338131 | 101.246149 | 101.28557 | 4681.0 |
| 2010-12-19 23:00:00 | ZN | Futures | 101.272429 | 101.351271 | 101.219868 | 101.28557 | 3577.0 |
> showing 36 of 257 rows — these rows as CSV