PREVIEW / futures_1hour / 2010-12-26
file: by_date/futures_1hour/2010/2010-12-26.parquet size: 13 KB rows: 247
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-26 18:00:00 | ES | Futures | 1236.64 | 1237.14 | 1232.68 | 1234.41 | 14676.0 |
| 2010-12-26 19:00:00 | ES | Futures | 1234.41 | 1234.91 | 1233.42 | 1234.41 | 4911.0 |
| 2010-12-26 20:00:00 | ES | Futures | 1234.41 | 1235.16 | 1233.67 | 1234.41 | 2060.0 |
| 2010-12-26 21:00:00 | ES | Futures | 1234.41 | 1237.14 | 1234.17 | 1236.64 | 3964.0 |
| 2010-12-26 22:00:00 | ES | Futures | 1236.64 | 1237.63 | 1235.9 | 1237.14 | 2800.0 |
| 2010-12-26 23:00:00 | ES | Futures | 1237.14 | 1237.63 | 1237.14 | 1237.38 | 534.0 |
| 2010-12-26 18:00:00 | NQ | Futures | 2557.17 | 2557.46 | 2548.27 | 2551.72 | 1776.0 |
| 2010-12-26 19:00:00 | NQ | Futures | 2551.72 | 2553.44 | 2550.28 | 2552.01 | 675.0 |
| 2010-12-26 20:00:00 | NQ | Futures | 2552.58 | 2553.15 | 2550.57 | 2552.01 | 240.0 |
| 2010-12-26 21:00:00 | NQ | Futures | 2552.29 | 2557.46 | 2551.43 | 2556.02 | 455.0 |
| 2010-12-26 22:00:00 | NQ | Futures | 2556.31 | 2558.61 | 2555.45 | 2557.46 | 338.0 |
| 2010-12-26 23:00:00 | NQ | Futures | 2557.46 | 2557.75 | 2557.17 | 2557.46 | 55.0 |
| 2010-12-26 18:00:00 | YM | Futures | 11013.5 | 11013.5 | 10971.4 | 10989.6 | 801.0 |
| 2010-12-26 19:00:00 | YM | Futures | 10983.8 | 10991.5 | 10981.9 | 10989.6 | 248.0 |
| 2010-12-26 20:00:00 | YM | Futures | 10989.6 | 10992.5 | 10984.8 | 10990.6 | 144.0 |
| 2010-12-26 21:00:00 | YM | Futures | 10990.6 | 11009.7 | 10988.6 | 11004.9 | 322.0 |
| 2010-12-26 22:00:00 | YM | Futures | 11004.0 | 11014.5 | 11004.0 | 11010.7 | 202.0 |
| 2010-12-26 23:00:00 | YM | Futures | 11011.6 | 11012.6 | 11009.7 | 11011.6 | 43.0 |
| 2010-12-26 18:00:00 | CL | Futures | 168.92 | 169.18 | 168.4 | 168.52 | 2680.0 |
| 2010-12-26 19:00:00 | CL | Futures | 168.48 | 169.09 | 168.46 | 168.96 | 1260.0 |
| 2010-12-26 20:00:00 | CL | Futures | 168.96 | 169.28 | 168.89 | 169.18 | 662.0 |
| 2010-12-26 21:00:00 | CL | Futures | 169.2 | 169.54 | 169.18 | 169.42 | 747.0 |
| 2010-12-26 22:00:00 | CL | Futures | 169.44 | 169.55 | 169.37 | 169.42 | 499.0 |
| 2010-12-26 23:00:00 | CL | Futures | 169.44 | 169.72 | 169.39 | 169.63 | 462.0 |
| 2010-12-26 18:00:00 | GC | Futures | 1926.0 | 1926.0 | 1917.4 | 1918.6 | 3521.0 |
| 2010-12-26 19:00:00 | GC | Futures | 1918.6 | 1928.8 | 1918.1 | 1926.7 | 2104.0 |
| 2010-12-26 20:00:00 | GC | Futures | 1926.7 | 1928.8 | 1925.8 | 1928.8 | 1127.0 |
| 2010-12-26 21:00:00 | GC | Futures | 1928.7 | 1933.4 | 1928.3 | 1932.9 | 2174.0 |
| 2010-12-26 22:00:00 | GC | Futures | 1933.0 | 1934.6 | 1932.3 | 1933.7 | 742.0 |
| 2010-12-26 23:00:00 | GC | Futures | 1933.9 | 1934.6 | 1932.9 | 1932.9 | 607.0 |
| 2010-12-26 18:00:00 | ZN | Futures | 100.49715 | 100.589133 | 100.48401 | 100.523431 | 3358.0 |
| 2010-12-26 19:00:00 | ZN | Futures | 100.523431 | 100.549712 | 100.431449 | 100.48401 | 2065.0 |
| 2010-12-26 20:00:00 | ZN | Futures | 100.48401 | 100.48401 | 100.378888 | 100.444589 | 2292.0 |
| 2010-12-26 21:00:00 | ZN | Futures | 100.444589 | 100.444589 | 100.286905 | 100.313186 | 2164.0 |
| 2010-12-26 22:00:00 | ZN | Futures | 100.300046 | 100.352607 | 100.260625 | 100.300046 | 1656.0 |
| 2010-12-26 23:00:00 | ZN | Futures | 100.286905 | 100.300046 | 100.247484 | 100.260625 | 1199.0 |
> showing 36 of 247 rows — these rows as CSV