PREVIEW / futures_1hour / 2013-08-25
file: by_date/futures_1hour/2013/2013-08-25.parquet size: 13 KB rows: 237
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-25 18:00:00 | ES | Futures | 1717.18 | 1718.99 | 1716.92 | 1717.18 | 2961.0 |
| 2013-08-25 19:00:00 | ES | Futures | 1717.44 | 1717.96 | 1716.92 | 1716.92 | 1449.0 |
| 2013-08-25 20:00:00 | ES | Futures | 1716.92 | 1717.96 | 1716.92 | 1717.7 | 3617.0 |
| 2013-08-25 21:00:00 | ES | Futures | 1717.96 | 1717.96 | 1716.92 | 1717.96 | 2526.0 |
| 2013-08-25 22:00:00 | ES | Futures | 1717.96 | 1718.99 | 1717.18 | 1718.73 | 2316.0 |
| 2013-08-25 23:00:00 | ES | Futures | 1718.73 | 1722.35 | 1718.47 | 1722.09 | 8004.0 |
| 2013-08-25 18:00:00 | NQ | Futures | 3647.4 | 3651.19 | 3647.1 | 3648.27 | 261.0 |
| 2013-08-25 19:00:00 | NQ | Futures | 3648.27 | 3649.44 | 3646.52 | 3647.69 | 217.0 |
| 2013-08-25 20:00:00 | NQ | Futures | 3647.4 | 3649.73 | 3646.81 | 3649.15 | 284.0 |
| 2013-08-25 21:00:00 | NQ | Futures | 3649.44 | 3649.73 | 3647.4 | 3649.44 | 326.0 |
| 2013-08-25 22:00:00 | NQ | Futures | 3649.73 | 3651.49 | 3647.98 | 3651.49 | 268.0 |
| 2013-08-25 23:00:00 | NQ | Futures | 3651.19 | 3657.33 | 3651.19 | 3657.04 | 802.0 |
| 2013-08-25 18:00:00 | YM | Futures | 15220.0 | 15231.2 | 15212.9 | 15221.0 | 220.0 |
| 2013-08-25 19:00:00 | YM | Futures | 15220.0 | 15227.1 | 15218.0 | 15221.0 | 199.0 |
| 2013-08-25 20:00:00 | YM | Futures | 15220.0 | 15229.1 | 15219.0 | 15227.1 | 540.0 |
| 2013-08-25 21:00:00 | YM | Futures | 15228.1 | 15231.2 | 15221.0 | 15230.1 | 581.0 |
| 2013-08-25 22:00:00 | YM | Futures | 15230.1 | 15235.2 | 15225.1 | 15233.2 | 462.0 |
| 2013-08-25 23:00:00 | YM | Futures | 15233.2 | 15257.6 | 15233.2 | 15257.6 | 802.0 |
| 2013-08-25 18:00:00 | CL | Futures | 168.78 | 169.51 | 168.62 | 168.81 | 2801.0 |
| 2013-08-25 19:00:00 | CL | Futures | 168.8 | 169.24 | 168.8 | 169.21 | 653.0 |
| 2013-08-25 20:00:00 | CL | Futures | 169.22 | 169.29 | 168.81 | 169.05 | 930.0 |
| 2013-08-25 21:00:00 | CL | Futures | 169.02 | 169.1 | 168.58 | 168.69 | 915.0 |
| 2013-08-25 22:00:00 | CL | Futures | 168.67 | 168.91 | 168.56 | 168.86 | 606.0 |
| 2013-08-25 23:00:00 | CL | Futures | 168.83 | 169.02 | 168.81 | 168.97 | 584.0 |
| 2013-08-25 18:00:00 | GC | Futures | 1917.7 | 1924.1 | 1915.1 | 1924.0 | 4085.0 |
| 2013-08-25 19:00:00 | GC | Futures | 1924.0 | 1928.7 | 1905.8 | 1913.3 | 6026.0 |
| 2013-08-25 20:00:00 | GC | Futures | 1913.5 | 1915.1 | 1906.7 | 1908.9 | 4149.0 |
| 2013-08-25 21:00:00 | GC | Futures | 1909.2 | 1915.1 | 1909.1 | 1911.7 | 3414.0 |
| 2013-08-25 22:00:00 | GC | Futures | 1911.7 | 1912.1 | 1909.2 | 1910.4 | 1630.0 |
| 2013-08-25 23:00:00 | GC | Futures | 1910.4 | 1914.4 | 1910.2 | 1913.3 | 1363.0 |
| 2013-08-25 18:00:00 | ZN | Futures | 113.15131 | 113.165461 | 113.038102 | 113.094706 | 3568.0 |
| 2013-08-25 19:00:00 | ZN | Futures | 113.094706 | 113.108857 | 113.066404 | 113.080555 | 2059.0 |
| 2013-08-25 20:00:00 | ZN | Futures | 113.066404 | 113.080555 | 113.023951 | 113.066404 | 3695.0 |
| 2013-08-25 21:00:00 | ZN | Futures | 113.052253 | 113.108857 | 113.052253 | 113.094706 | 6845.0 |
| 2013-08-25 22:00:00 | ZN | Futures | 113.080555 | 113.094706 | 113.066404 | 113.080555 | 2943.0 |
| 2013-08-25 23:00:00 | ZN | Futures | 113.080555 | 113.094706 | 113.023951 | 113.038102 | 2996.0 |
> showing 36 of 237 rows — these rows as CSV