PREVIEW / futures_1hour / 2011-03-13
file: by_date/futures_1hour/2011/2011-03-13.parquet size: 14 KB rows: 272
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-13 18:00:00 | ES | Futures | 1288.85 | 1290.33 | 1279.94 | 1283.9 | 17516.0 |
| 2011-03-13 19:00:00 | ES | Futures | 1284.15 | 1292.31 | 1282.41 | 1283.4 | 9134.0 |
| 2011-03-13 20:00:00 | ES | Futures | 1283.4 | 1289.59 | 1282.91 | 1288.6 | 6721.0 |
| 2011-03-13 21:00:00 | ES | Futures | 1289.1 | 1289.1 | 1286.13 | 1286.37 | 3420.0 |
| 2011-03-13 22:00:00 | ES | Futures | 1286.62 | 1287.86 | 1283.65 | 1286.62 | 3646.0 |
| 2011-03-13 23:00:00 | ES | Futures | 1286.87 | 1289.34 | 1285.63 | 1286.37 | 2328.0 |
| 2011-03-13 18:00:00 | NQ | Futures | 2636.68 | 2646.15 | 2616.59 | 2626.92 | 914.0 |
| 2011-03-13 19:00:00 | NQ | Futures | 2626.92 | 2641.56 | 2622.33 | 2626.06 | 330.0 |
| 2011-03-13 20:00:00 | NQ | Futures | 2624.62 | 2637.25 | 2622.62 | 2636.11 | 278.0 |
| 2011-03-13 21:00:00 | NQ | Futures | 2635.82 | 2635.82 | 2629.22 | 2629.79 | 109.0 |
| 2011-03-13 22:00:00 | NQ | Futures | 2631.23 | 2634.38 | 2625.2 | 2632.66 | 303.0 |
| 2011-03-13 23:00:00 | NQ | Futures | 2631.8 | 2636.11 | 2628.36 | 2628.64 | 145.0 |
| 2011-03-13 18:00:00 | YM | Futures | 11542.8 | 11542.8 | 11449.4 | 11489.9 | 1415.0 |
| 2011-03-13 19:00:00 | YM | Futures | 11491.8 | 11552.5 | 11478.3 | 11487.0 | 864.0 |
| 2011-03-13 20:00:00 | YM | Futures | 11485.1 | 11530.3 | 11478.3 | 11526.5 | 763.0 |
| 2011-03-13 21:00:00 | YM | Futures | 11524.5 | 11527.4 | 11505.3 | 11506.2 | 458.0 |
| 2011-03-13 22:00:00 | YM | Futures | 11506.2 | 11518.8 | 11483.1 | 11509.1 | 732.0 |
| 2011-03-13 23:00:00 | YM | Futures | 11511.1 | 11529.4 | 11501.4 | 11507.2 | 383.0 |
| 2011-03-13 18:00:00 | CL | Futures | 177.19 | 178.67 | 175.19 | 175.63 | 6200.0 |
| 2011-03-13 19:00:00 | CL | Futures | 175.58 | 176.8 | 175.4 | 176.53 | 2230.0 |
| 2011-03-13 20:00:00 | CL | Futures | 176.55 | 177.17 | 175.95 | 177.08 | 2019.0 |
| 2011-03-13 21:00:00 | CL | Futures | 177.1 | 177.19 | 176.3 | 176.34 | 1315.0 |
| 2011-03-13 22:00:00 | CL | Futures | 176.39 | 176.43 | 175.28 | 175.77 | 2434.0 |
| 2011-03-13 23:00:00 | CL | Futures | 175.77 | 176.46 | 175.69 | 175.95 | 1865.0 |
| 2011-03-13 18:00:00 | GC | Futures | 1984.8 | 2001.0 | 1982.4 | 1997.5 | 5470.0 |
| 2011-03-13 19:00:00 | GC | Futures | 1997.7 | 1998.2 | 1989.6 | 1992.4 | 1936.0 |
| 2011-03-13 20:00:00 | GC | Futures | 1992.4 | 1995.4 | 1989.8 | 1994.8 | 1934.0 |
| 2011-03-13 21:00:00 | GC | Futures | 1994.7 | 1995.5 | 1987.6 | 1987.6 | 2305.0 |
| 2011-03-13 22:00:00 | GC | Futures | 1988.0 | 1989.1 | 1979.6 | 1981.3 | 4329.0 |
| 2011-03-13 23:00:00 | GC | Futures | 1981.3 | 1986.6 | 1980.9 | 1985.9 | 868.0 |
| 2011-03-13 18:00:00 | ZN | Futures | 102.009326 | 102.155662 | 101.929507 | 101.969417 | 13152.0 |
| 2011-03-13 19:00:00 | ZN | Futures | 101.969417 | 102.049236 | 101.916204 | 102.02263 | 8294.0 |
| 2011-03-13 20:00:00 | ZN | Futures | 102.02263 | 102.035933 | 101.9029 | 101.929507 | 11045.0 |
| 2011-03-13 21:00:00 | ZN | Futures | 101.916204 | 101.956113 | 101.876294 | 101.889597 | 7416.0 |
| 2011-03-13 22:00:00 | ZN | Futures | 101.889597 | 102.02263 | 101.876294 | 101.94281 | 12705.0 |
| 2011-03-13 23:00:00 | ZN | Futures | 101.94281 | 101.98272 | 101.9029 | 101.969417 | 2802.0 |
> showing 36 of 272 rows — these rows as CSV