PREVIEW / futures_1hour / 2012-12-02
file: by_date/futures_1hour/2012/2012-12-02.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 |
|---|---|---|---|---|---|---|---|
| 2012-12-02 18:00:00 | ES | Futures | 1444.14 | 1445.41 | 1443.63 | 1444.14 | 8204.0 |
| 2012-12-02 19:00:00 | ES | Futures | 1444.14 | 1445.16 | 1443.88 | 1445.16 | 4744.0 |
| 2012-12-02 20:00:00 | ES | Futures | 1444.9 | 1449.5 | 1444.65 | 1449.25 | 11445.0 |
| 2012-12-02 21:00:00 | ES | Futures | 1449.5 | 1449.5 | 1447.97 | 1448.22 | 4250.0 |
| 2012-12-02 22:00:00 | ES | Futures | 1447.97 | 1449.5 | 1447.46 | 1448.73 | 4545.0 |
| 2012-12-02 23:00:00 | ES | Futures | 1448.99 | 1449.5 | 1447.46 | 1448.22 | 3523.0 |
| 2012-12-02 18:00:00 | NQ | Futures | 3110.33 | 3115.27 | 3110.04 | 3113.53 | 1763.0 |
| 2012-12-02 19:00:00 | NQ | Futures | 3113.24 | 3114.98 | 3112.65 | 3114.69 | 1381.0 |
| 2012-12-02 20:00:00 | NQ | Futures | 3114.69 | 3125.15 | 3114.4 | 3124.28 | 1720.0 |
| 2012-12-02 21:00:00 | NQ | Futures | 3124.57 | 3124.86 | 3121.95 | 3122.24 | 866.0 |
| 2012-12-02 22:00:00 | NQ | Futures | 3122.53 | 3123.99 | 3120.5 | 3122.82 | 775.0 |
| 2012-12-02 23:00:00 | NQ | Futures | 3122.82 | 3124.28 | 3120.5 | 3121.37 | 469.0 |
| 2012-12-02 18:00:00 | YM | Futures | 13009.7 | 13016.7 | 13004.7 | 13013.7 | 645.0 |
| 2012-12-02 19:00:00 | YM | Futures | 13012.7 | 13020.7 | 13009.7 | 13020.7 | 802.0 |
| 2012-12-02 20:00:00 | YM | Futures | 13021.7 | 13055.7 | 13019.7 | 13052.7 | 1009.0 |
| 2012-12-02 21:00:00 | YM | Futures | 13053.7 | 13053.7 | 13042.7 | 13044.7 | 471.0 |
| 2012-12-02 22:00:00 | YM | Futures | 13043.7 | 13050.7 | 13037.7 | 13047.7 | 568.0 |
| 2012-12-02 23:00:00 | YM | Futures | 13048.7 | 13053.7 | 13036.7 | 13041.7 | 261.0 |
| 2012-12-02 18:00:00 | CL | Futures | 143.53 | 143.97 | 143.39 | 143.78 | 1377.0 |
| 2012-12-02 19:00:00 | CL | Futures | 143.78 | 143.86 | 143.45 | 143.57 | 1296.0 |
| 2012-12-02 20:00:00 | CL | Futures | 143.53 | 144.21 | 143.47 | 144.16 | 1832.0 |
| 2012-12-02 21:00:00 | CL | Futures | 144.2 | 144.26 | 143.97 | 143.97 | 749.0 |
| 2012-12-02 22:00:00 | CL | Futures | 143.99 | 144.1 | 143.9 | 144.05 | 381.0 |
| 2012-12-02 23:00:00 | CL | Futures | 144.07 | 144.11 | 143.94 | 144.1 | 408.0 |
| 2012-12-02 18:00:00 | GC | Futures | 2362.7 | 2367.6 | 2362.7 | 2366.7 | 2135.0 |
| 2012-12-02 19:00:00 | GC | Futures | 2366.5 | 2369.4 | 2365.4 | 2368.6 | 1940.0 |
| 2012-12-02 20:00:00 | GC | Futures | 2368.7 | 2372.3 | 2365.7 | 2370.9 | 2892.0 |
| 2012-12-02 21:00:00 | GC | Futures | 2370.8 | 2372.0 | 2369.7 | 2369.7 | 2001.0 |
| 2012-12-02 22:00:00 | GC | Futures | 2369.7 | 2370.9 | 2368.6 | 2370.0 | 1200.0 |
| 2012-12-02 23:00:00 | GC | Futures | 2370.1 | 2371.4 | 2369.4 | 2371.2 | 1070.0 |
| 2012-12-02 18:00:00 | ZN | Futures | 118.935971 | 118.977562 | 118.935971 | 118.935971 | 186.0 |
| 2012-12-02 19:00:00 | ZN | Futures | 118.949835 | 118.963698 | 118.922107 | 118.949835 | 680.0 |
| 2012-12-02 20:00:00 | ZN | Futures | 118.949835 | 118.949835 | 118.852789 | 118.866653 | 877.0 |
| 2012-12-02 21:00:00 | ZN | Futures | 118.880516 | 118.89438 | 118.866653 | 118.880516 | 502.0 |
| 2012-12-02 22:00:00 | ZN | Futures | 118.880516 | 118.89438 | 118.880516 | 118.89438 | 115.0 |
| 2012-12-02 23:00:00 | ZN | Futures | 118.89438 | 118.922107 | 118.89438 | 118.922107 | 181.0 |
> showing 36 of 270 rows — these rows as CSV