PREVIEW / futures_1hour / 2011-03-20
file: by_date/futures_1hour/2011/2011-03-20.parquet size: 14 KB rows: 277
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 |
|---|---|---|---|---|---|---|---|
| 2011-03-20 18:00:00 | ES | Futures | 1268.24 | 1272.96 | 1266.75 | 1268.49 | 25320.0 |
| 2011-03-20 19:00:00 | ES | Futures | 1268.49 | 1272.96 | 1268.24 | 1272.71 | 8290.0 |
| 2011-03-20 20:00:00 | ES | Futures | 1272.96 | 1273.7 | 1269.48 | 1270.47 | 7972.0 |
| 2011-03-20 21:00:00 | ES | Futures | 1270.47 | 1273.7 | 1269.98 | 1273.21 | 6484.0 |
| 2011-03-20 22:00:00 | ES | Futures | 1272.96 | 1276.19 | 1272.96 | 1273.95 | 8414.0 |
| 2011-03-20 23:00:00 | ES | Futures | 1273.7 | 1275.19 | 1273.21 | 1274.2 | 2390.0 |
| 2011-03-20 18:00:00 | NQ | Futures | 2554.8 | 2561.7 | 2550.21 | 2555.67 | 1966.0 |
| 2011-03-20 19:00:00 | NQ | Futures | 2555.38 | 2566.87 | 2555.09 | 2566.01 | 1055.0 |
| 2011-03-20 20:00:00 | NQ | Futures | 2566.3 | 2567.16 | 2557.96 | 2561.12 | 1257.0 |
| 2011-03-20 21:00:00 | NQ | Futures | 2561.12 | 2567.16 | 2559.97 | 2565.72 | 628.0 |
| 2011-03-20 22:00:00 | NQ | Futures | 2566.01 | 2571.75 | 2565.43 | 2567.16 | 1300.0 |
| 2011-03-20 23:00:00 | NQ | Futures | 2567.16 | 2569.17 | 2565.43 | 2566.58 | 369.0 |
| 2011-03-20 18:00:00 | YM | Futures | 11373.3 | 11412.8 | 11367.5 | 11380.1 | 446.0 |
| 2011-03-20 19:00:00 | YM | Futures | 11380.1 | 11420.5 | 11378.1 | 11416.7 | 638.0 |
| 2011-03-20 20:00:00 | YM | Futures | 11415.7 | 11423.4 | 11392.6 | 11399.3 | 552.0 |
| 2011-03-20 21:00:00 | YM | Futures | 11400.3 | 11421.5 | 11393.5 | 11419.6 | 325.0 |
| 2011-03-20 22:00:00 | YM | Futures | 11420.5 | 11446.5 | 11420.5 | 11424.4 | 588.0 |
| 2011-03-20 23:00:00 | YM | Futures | 11423.4 | 11435.0 | 11418.6 | 11425.3 | 349.0 |
| 2011-03-20 18:00:00 | CL | Futures | 179.75 | 181.55 | 179.72 | 181.13 | 7385.0 |
| 2011-03-20 19:00:00 | CL | Futures | 181.13 | 181.29 | 180.52 | 181.2 | 2009.0 |
| 2011-03-20 20:00:00 | CL | Futures | 181.2 | 181.9 | 181.08 | 181.81 | 1886.0 |
| 2011-03-20 21:00:00 | CL | Futures | 181.81 | 181.93 | 181.2 | 181.74 | 1887.0 |
| 2011-03-20 22:00:00 | CL | Futures | 181.76 | 181.81 | 180.59 | 181.29 | 1911.0 |
| 2011-03-20 23:00:00 | CL | Futures | 181.31 | 181.32 | 180.94 | 181.24 | 672.0 |
| 2011-03-20 18:00:00 | GC | Futures | 1988.0 | 1992.3 | 1987.0 | 1990.3 | 4008.0 |
| 2011-03-20 19:00:00 | GC | Futures | 1990.5 | 1992.6 | 1988.0 | 1989.9 | 1298.0 |
| 2011-03-20 20:00:00 | GC | Futures | 1990.2 | 1993.4 | 1987.4 | 1993.4 | 1455.0 |
| 2011-03-20 21:00:00 | GC | Futures | 1993.4 | 1994.1 | 1992.0 | 1993.1 | 1374.0 |
| 2011-03-20 22:00:00 | GC | Futures | 1993.6 | 1994.4 | 1992.0 | 1992.7 | 920.0 |
| 2011-03-20 23:00:00 | GC | Futures | 1993.1 | 1995.7 | 1993.1 | 1995.2 | 1303.0 |
| 2011-03-20 18:00:00 | ZN | Futures | 102.780915 | 102.794218 | 102.607973 | 102.647882 | 4564.0 |
| 2011-03-20 19:00:00 | ZN | Futures | 102.647882 | 102.661186 | 102.501547 | 102.528153 | 5339.0 |
| 2011-03-20 20:00:00 | ZN | Futures | 102.51485 | 102.607973 | 102.51485 | 102.594669 | 2498.0 |
| 2011-03-20 21:00:00 | ZN | Futures | 102.607973 | 102.647882 | 102.51485 | 102.51485 | 3672.0 |
| 2011-03-20 22:00:00 | ZN | Futures | 102.501547 | 102.51485 | 102.341908 | 102.43503 | 9971.0 |
| 2011-03-20 23:00:00 | ZN | Futures | 102.43503 | 102.461637 | 102.395121 | 102.448334 | 2840.0 |
> showing 36 of 277 rows — these rows as CSV