PREVIEW / futures_1hour / 2014-02-02
file: by_date/futures_1hour/2014/2014-02-02.parquet size: 14 KB rows: 271
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 |
|---|---|---|---|---|---|---|---|
| 2014-02-02 18:00:00 | ES | Futures | 1839.02 | 1845.49 | 1839.02 | 1844.46 | 10921.0 |
| 2014-02-02 19:00:00 | ES | Futures | 1844.46 | 1845.23 | 1841.87 | 1843.16 | 7709.0 |
| 2014-02-02 20:00:00 | ES | Futures | 1843.16 | 1843.42 | 1838.25 | 1838.77 | 10798.0 |
| 2014-02-02 21:00:00 | ES | Futures | 1838.77 | 1841.61 | 1837.47 | 1841.09 | 9306.0 |
| 2014-02-02 22:00:00 | ES | Futures | 1841.09 | 1842.9 | 1840.32 | 1842.13 | 5117.0 |
| 2014-02-02 23:00:00 | ES | Futures | 1842.39 | 1842.65 | 1840.84 | 1842.13 | 1862.0 |
| 2014-02-02 18:00:00 | NQ | Futures | 4085.86 | 4104.18 | 4085.86 | 4102.14 | 1348.0 |
| 2014-02-02 19:00:00 | NQ | Futures | 4101.85 | 4103.31 | 4095.75 | 4097.78 | 552.0 |
| 2014-02-02 20:00:00 | NQ | Futures | 4098.07 | 4098.07 | 4085.86 | 4086.74 | 1542.0 |
| 2014-02-02 21:00:00 | NQ | Futures | 4086.45 | 4093.71 | 4084.41 | 4092.84 | 1256.0 |
| 2014-02-02 22:00:00 | NQ | Futures | 4093.13 | 4095.75 | 4089.64 | 4093.71 | 811.0 |
| 2014-02-02 23:00:00 | NQ | Futures | 4093.71 | 4094.88 | 4090.52 | 4093.13 | 348.0 |
| 2014-02-02 18:00:00 | YM | Futures | 16041.4 | 16095.7 | 16041.4 | 16087.5 | 912.0 |
| 2014-02-02 19:00:00 | YM | Futures | 16086.5 | 16094.7 | 16060.9 | 16070.1 | 855.0 |
| 2014-02-02 20:00:00 | YM | Futures | 16069.1 | 16071.1 | 16029.1 | 16031.1 | 1503.0 |
| 2014-02-02 21:00:00 | YM | Futures | 16032.2 | 16054.7 | 16024.0 | 16049.6 | 1457.0 |
| 2014-02-02 22:00:00 | YM | Futures | 16050.6 | 16062.9 | 16043.5 | 16059.9 | 769.0 |
| 2014-02-02 23:00:00 | YM | Futures | 16059.9 | 16065.0 | 16049.6 | 16058.8 | 339.0 |
| 2014-02-02 18:00:00 | CL | Futures | 153.01 | 153.23 | 152.7 | 152.7 | 447.0 |
| 2014-02-02 19:00:00 | CL | Futures | 152.7 | 152.79 | 152.04 | 152.24 | 1283.0 |
| 2014-02-02 20:00:00 | CL | Futures | 152.26 | 152.41 | 152.1 | 152.33 | 803.0 |
| 2014-02-02 21:00:00 | CL | Futures | 152.32 | 152.65 | 152.32 | 152.62 | 648.0 |
| 2014-02-02 22:00:00 | CL | Futures | 152.6 | 152.66 | 152.46 | 152.52 | 353.0 |
| 2014-02-02 23:00:00 | CL | Futures | 152.54 | 152.85 | 152.52 | 152.81 | 588.0 |
| 2014-02-02 18:00:00 | GC | Futures | 1701.0 | 1703.6 | 1700.6 | 1702.9 | 1142.0 |
| 2014-02-02 19:00:00 | GC | Futures | 1702.9 | 1705.8 | 1701.3 | 1704.2 | 1025.0 |
| 2014-02-02 20:00:00 | GC | Futures | 1704.2 | 1705.5 | 1702.3 | 1704.4 | 837.0 |
| 2014-02-02 21:00:00 | GC | Futures | 1704.4 | 1705.5 | 1703.9 | 1704.6 | 625.0 |
| 2014-02-02 22:00:00 | GC | Futures | 1704.6 | 1705.0 | 1703.3 | 1703.6 | 668.0 |
| 2014-02-02 23:00:00 | GC | Futures | 1703.3 | 1704.9 | 1702.8 | 1704.3 | 754.0 |
| 2014-02-02 18:00:00 | ZN | Futures | 116.301628 | 116.301628 | 116.229391 | 116.243839 | 13333.0 |
| 2014-02-02 19:00:00 | ZN | Futures | 116.243839 | 116.272733 | 116.214944 | 116.243839 | 8433.0 |
| 2014-02-02 20:00:00 | ZN | Futures | 116.243839 | 116.34497 | 116.229391 | 116.34497 | 7802.0 |
| 2014-02-02 21:00:00 | ZN | Futures | 116.330523 | 116.330523 | 116.272733 | 116.272733 | 4925.0 |
| 2014-02-02 22:00:00 | ZN | Futures | 116.272733 | 116.330523 | 116.272733 | 116.287181 | 4240.0 |
| 2014-02-02 23:00:00 | ZN | Futures | 116.287181 | 116.316076 | 116.287181 | 116.316076 | 2056.0 |
> showing 36 of 271 rows — these rows as CSV