PREVIEW / futures_1hour / 2011-04-03
file: by_date/futures_1hour/2011/2011-04-03.parquet size: 14 KB rows: 270
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-04-03 18:00:00 | ES | Futures | 1318.67 | 1319.66 | 1318.42 | 1319.41 | 4768.0 |
| 2011-04-03 19:00:00 | ES | Futures | 1319.17 | 1321.15 | 1319.17 | 1319.91 | 4781.0 |
| 2011-04-03 20:00:00 | ES | Futures | 1319.91 | 1321.15 | 1319.17 | 1319.41 | 4056.0 |
| 2011-04-03 21:00:00 | ES | Futures | 1319.17 | 1319.66 | 1316.93 | 1317.43 | 9361.0 |
| 2011-04-03 22:00:00 | ES | Futures | 1317.43 | 1318.67 | 1316.93 | 1317.18 | 3461.0 |
| 2011-04-03 23:00:00 | ES | Futures | 1317.18 | 1318.92 | 1316.93 | 1317.92 | 2562.0 |
| 2011-04-03 18:00:00 | NQ | Futures | 2686.11 | 2689.84 | 2686.11 | 2688.98 | 577.0 |
| 2011-04-03 19:00:00 | NQ | Futures | 2688.98 | 2695.3 | 2688.98 | 2692.14 | 627.0 |
| 2011-04-03 20:00:00 | NQ | Futures | 2692.14 | 2694.73 | 2690.99 | 2691.85 | 231.0 |
| 2011-04-03 21:00:00 | NQ | Futures | 2691.28 | 2692.14 | 2686.97 | 2687.83 | 541.0 |
| 2011-04-03 22:00:00 | NQ | Futures | 2687.83 | 2690.13 | 2686.39 | 2686.68 | 249.0 |
| 2011-04-03 23:00:00 | NQ | Futures | 2686.97 | 2690.42 | 2686.39 | 2688.69 | 168.0 |
| 2011-04-03 18:00:00 | YM | Futures | 11855.9 | 11861.7 | 11851.1 | 11854.9 | 304.0 |
| 2011-04-03 19:00:00 | YM | Futures | 11856.8 | 11867.4 | 11856.8 | 11858.8 | 462.0 |
| 2011-04-03 20:00:00 | YM | Futures | 11858.8 | 11867.4 | 11852.0 | 11855.9 | 114.0 |
| 2011-04-03 21:00:00 | YM | Futures | 11852.0 | 11856.8 | 11835.7 | 11839.5 | 324.0 |
| 2011-04-03 22:00:00 | YM | Futures | 11841.4 | 11848.2 | 11835.7 | 11837.6 | 130.0 |
| 2011-04-03 23:00:00 | YM | Futures | 11836.6 | 11849.1 | 11834.7 | 11842.4 | 213.0 |
| 2011-04-03 18:00:00 | CL | Futures | 188.95 | 189.49 | 188.55 | 188.91 | 1577.0 |
| 2011-04-03 19:00:00 | CL | Futures | 188.93 | 189.32 | 188.84 | 189.21 | 460.0 |
| 2011-04-03 20:00:00 | CL | Futures | 189.16 | 189.3 | 188.81 | 189.19 | 536.0 |
| 2011-04-03 21:00:00 | CL | Futures | 189.21 | 189.73 | 189.19 | 189.52 | 998.0 |
| 2011-04-03 22:00:00 | CL | Futures | 189.54 | 189.61 | 189.32 | 189.47 | 464.0 |
| 2011-04-03 23:00:00 | CL | Futures | 189.42 | 189.61 | 188.84 | 188.93 | 1336.0 |
| 2011-04-03 18:00:00 | GC | Futures | 1995.9 | 1997.9 | 1995.2 | 1995.9 | 524.0 |
| 2011-04-03 19:00:00 | GC | Futures | 1995.8 | 1999.3 | 1994.7 | 1998.6 | 608.0 |
| 2011-04-03 20:00:00 | GC | Futures | 1998.4 | 1999.0 | 1997.3 | 1997.7 | 736.0 |
| 2011-04-03 21:00:00 | GC | Futures | 1998.0 | 1999.3 | 1997.3 | 1997.9 | 602.0 |
| 2011-04-03 22:00:00 | GC | Futures | 1997.9 | 1998.2 | 1996.9 | 1997.3 | 802.0 |
| 2011-04-03 23:00:00 | GC | Futures | 1997.3 | 1998.4 | 1997.3 | 1998.4 | 482.0 |
| 2011-04-03 18:00:00 | ZN | Futures | 101.317557 | 101.344164 | 101.290951 | 101.317557 | 1765.0 |
| 2011-04-03 19:00:00 | ZN | Futures | 101.317557 | 101.344164 | 101.224434 | 101.304254 | 4539.0 |
| 2011-04-03 20:00:00 | ZN | Futures | 101.317557 | 101.344164 | 101.290951 | 101.304254 | 4773.0 |
| 2011-04-03 21:00:00 | ZN | Futures | 101.304254 | 101.397377 | 101.290951 | 101.384073 | 4432.0 |
| 2011-04-03 22:00:00 | ZN | Futures | 101.384073 | 101.41068 | 101.37077 | 101.37077 | 2123.0 |
| 2011-04-03 23:00:00 | ZN | Futures | 101.37077 | 101.397377 | 101.33086 | 101.357467 | 2632.0 |
> showing 36 of 270 rows — these rows as CSV