PREVIEW / futures_1hour / 2010-12-12
file: by_date/futures_1hour/2010/2010-12-12.parquet size: 14 KB rows: 255
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-12 18:00:00 | ES | Futures | 1224.51 | 1225.25 | 1220.56 | 1221.3 | 4127.0 |
| 2010-12-12 19:00:00 | ES | Futures | 1221.55 | 1223.03 | 1221.3 | 1221.8 | 904.0 |
| 2010-12-12 20:00:00 | ES | Futures | 1222.04 | 1223.27 | 1219.33 | 1223.03 | 4235.0 |
| 2010-12-12 21:00:00 | ES | Futures | 1222.78 | 1223.52 | 1222.29 | 1222.78 | 957.0 |
| 2010-12-12 22:00:00 | ES | Futures | 1222.78 | 1223.52 | 1222.29 | 1222.78 | 926.0 |
| 2010-12-12 23:00:00 | ES | Futures | 1223.27 | 1223.27 | 1221.8 | 1221.8 | 840.0 |
| 2010-12-12 18:00:00 | NQ | Futures | 2545.11 | 2563.76 | 2537.37 | 2538.51 | 295.0 |
| 2010-12-12 19:00:00 | NQ | Futures | 2539.66 | 2543.1 | 2539.09 | 2543.1 | 89.0 |
| 2010-12-12 20:00:00 | NQ | Futures | 2541.96 | 2545.69 | 2538.8 | 2545.4 | 125.0 |
| 2010-12-12 21:00:00 | NQ | Futures | 2545.11 | 2545.4 | 2543.1 | 2544.83 | 88.0 |
| 2010-12-12 22:00:00 | NQ | Futures | 2543.96 | 2545.4 | 2543.39 | 2545.4 | 57.0 |
| 2010-12-12 23:00:00 | NQ | Futures | 2543.68 | 2544.54 | 2541.96 | 2541.96 | 36.0 |
| 2010-12-12 18:00:00 | YM | Futures | 10876.6 | 10883.3 | 10838.3 | 10845.0 | 197.0 |
| 2010-12-12 19:00:00 | YM | Futures | 10847.8 | 10862.2 | 10847.8 | 10856.5 | 231.0 |
| 2010-12-12 20:00:00 | YM | Futures | 10857.4 | 10865.1 | 10838.3 | 10865.1 | 274.0 |
| 2010-12-12 21:00:00 | YM | Futures | 10865.1 | 10867.0 | 10859.3 | 10864.1 | 82.0 |
| 2010-12-12 22:00:00 | YM | Futures | 10864.1 | 10869.9 | 10858.4 | 10868.0 | 137.0 |
| 2010-12-12 23:00:00 | YM | Futures | 10865.1 | 10866.0 | 10855.5 | 10856.5 | 68.0 |
| 2010-12-12 18:00:00 | CL | Futures | 163.63 | 164.12 | 163.18 | 163.24 | 1074.0 |
| 2010-12-12 19:00:00 | CL | Futures | 163.26 | 163.8 | 163.24 | 163.61 | 772.0 |
| 2010-12-12 20:00:00 | CL | Futures | 163.61 | 163.95 | 163.57 | 163.93 | 873.0 |
| 2010-12-12 21:00:00 | CL | Futures | 163.93 | 164.53 | 163.93 | 164.45 | 1219.0 |
| 2010-12-12 22:00:00 | CL | Futures | 164.45 | 164.71 | 164.36 | 164.41 | 981.0 |
| 2010-12-12 23:00:00 | CL | Futures | 164.45 | 164.45 | 164.17 | 164.23 | 911.0 |
| 2010-12-12 18:00:00 | GC | Futures | 1934.6 | 1935.3 | 1928.7 | 1929.7 | 1545.0 |
| 2010-12-12 19:00:00 | GC | Futures | 1929.7 | 1934.3 | 1929.0 | 1933.0 | 1439.0 |
| 2010-12-12 20:00:00 | GC | Futures | 1933.3 | 1937.4 | 1932.9 | 1935.8 | 2118.0 |
| 2010-12-12 21:00:00 | GC | Futures | 1935.8 | 1936.8 | 1935.4 | 1936.5 | 783.0 |
| 2010-12-12 22:00:00 | GC | Futures | 1936.5 | 1940.1 | 1936.1 | 1937.9 | 1510.0 |
| 2010-12-12 23:00:00 | GC | Futures | 1937.6 | 1939.4 | 1936.5 | 1937.9 | 1041.0 |
| 2010-12-12 18:00:00 | ZN | Futures | 100.917641 | 100.996483 | 100.9045 | 100.957062 | 4640.0 |
| 2010-12-12 19:00:00 | ZN | Futures | 100.957062 | 101.035904 | 100.957062 | 100.983342 | 3019.0 |
| 2010-12-12 20:00:00 | ZN | Futures | 100.983342 | 100.996483 | 100.943921 | 100.957062 | 3343.0 |
| 2010-12-12 21:00:00 | ZN | Futures | 100.957062 | 100.957062 | 100.681115 | 100.786237 | 15304.0 |
| 2010-12-12 22:00:00 | ZN | Futures | 100.786237 | 100.799378 | 100.628554 | 100.667975 | 7892.0 |
| 2010-12-12 23:00:00 | ZN | Futures | 100.667975 | 100.667975 | 100.378888 | 100.523431 | 17130.0 |
> showing 36 of 255 rows — these rows as CSV