PREVIEW / futures_1hour / 2015-02-22
file: by_date/futures_1hour/2015/2015-02-22.parquet size: 14 KB rows: 267
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-22 18:00:00 | ES | Futures | 2218.11 | 2218.9 | 2216.79 | 2217.84 | 4464.0 |
| 2015-02-22 19:00:00 | ES | Futures | 2218.11 | 2218.37 | 2217.32 | 2218.11 | 3573.0 |
| 2015-02-22 20:00:00 | ES | Futures | 2217.84 | 2218.11 | 2217.05 | 2217.58 | 2633.0 |
| 2015-02-22 21:00:00 | ES | Futures | 2217.84 | 2217.84 | 2217.32 | 2217.32 | 2085.0 |
| 2015-02-22 22:00:00 | ES | Futures | 2217.58 | 2217.84 | 2217.05 | 2217.32 | 1427.0 |
| 2015-02-22 23:00:00 | ES | Futures | 2217.05 | 2217.58 | 2217.05 | 2217.05 | 1079.0 |
| 2015-02-22 18:00:00 | NQ | Futures | 5215.61 | 5218.26 | 5213.26 | 5217.67 | 807.0 |
| 2015-02-22 19:00:00 | NQ | Futures | 5217.67 | 5219.43 | 5216.79 | 5218.26 | 301.0 |
| 2015-02-22 20:00:00 | NQ | Futures | 5217.96 | 5218.55 | 5216.49 | 5217.37 | 182.0 |
| 2015-02-22 21:00:00 | NQ | Futures | 5217.37 | 5218.55 | 5217.08 | 5217.67 | 214.0 |
| 2015-02-22 22:00:00 | NQ | Futures | 5217.67 | 5218.84 | 5216.79 | 5216.79 | 172.0 |
| 2015-02-22 23:00:00 | NQ | Futures | 5216.79 | 5217.96 | 5216.49 | 5216.79 | 142.0 |
| 2015-02-22 18:00:00 | YM | Futures | 18906.7 | 18907.7 | 18892.1 | 18901.5 | 547.0 |
| 2015-02-22 19:00:00 | YM | Futures | 18901.5 | 18901.5 | 18896.3 | 18899.4 | 256.0 |
| 2015-02-22 20:00:00 | YM | Futures | 18898.4 | 18900.4 | 18894.2 | 18898.4 | 248.0 |
| 2015-02-22 21:00:00 | YM | Futures | 18899.4 | 18902.5 | 18896.3 | 18898.4 | 251.0 |
| 2015-02-22 22:00:00 | YM | Futures | 18898.4 | 18900.4 | 18894.2 | 18894.2 | 180.0 |
| 2015-02-22 23:00:00 | YM | Futures | 18894.2 | 18897.3 | 18892.1 | 18892.1 | 171.0 |
| 2015-02-22 18:00:00 | CL | Futures | 83.83 | 83.91 | 82.94 | 83.25 | 3546.0 |
| 2015-02-22 19:00:00 | CL | Futures | 83.25 | 83.63 | 83.22 | 83.58 | 1603.0 |
| 2015-02-22 20:00:00 | CL | Futures | 83.58 | 84.03 | 83.44 | 83.96 | 2405.0 |
| 2015-02-22 21:00:00 | CL | Futures | 83.98 | 84.23 | 83.96 | 84.08 | 2089.0 |
| 2015-02-22 22:00:00 | CL | Futures | 84.08 | 84.21 | 83.96 | 84.06 | 1086.0 |
| 2015-02-22 23:00:00 | CL | Futures | 84.06 | 84.21 | 84.06 | 84.16 | 564.0 |
| 2015-02-22 18:00:00 | GC | Futures | 1644.8 | 1645.2 | 1640.8 | 1643.0 | 1695.0 |
| 2015-02-22 19:00:00 | GC | Futures | 1643.0 | 1644.6 | 1641.6 | 1644.4 | 1444.0 |
| 2015-02-22 20:00:00 | GC | Futures | 1644.2 | 1644.2 | 1640.9 | 1643.1 | 1825.0 |
| 2015-02-22 21:00:00 | GC | Futures | 1643.3 | 1644.0 | 1642.2 | 1643.1 | 1093.0 |
| 2015-02-22 22:00:00 | GC | Futures | 1643.1 | 1644.8 | 1642.5 | 1643.7 | 652.0 |
| 2015-02-22 23:00:00 | GC | Futures | 1643.5 | 1646.3 | 1643.5 | 1646.0 | 730.0 |
| 2015-02-22 18:00:00 | ZN | Futures | 121.24105 | 121.300482 | 121.211334 | 121.285624 | 6751.0 |
| 2015-02-22 19:00:00 | ZN | Futures | 121.300482 | 121.389629 | 121.285624 | 121.359913 | 9234.0 |
| 2015-02-22 20:00:00 | ZN | Futures | 121.359913 | 121.359913 | 121.300482 | 121.300482 | 3547.0 |
| 2015-02-22 21:00:00 | ZN | Futures | 121.300482 | 121.31534 | 121.255908 | 121.285624 | 4112.0 |
| 2015-02-22 22:00:00 | ZN | Futures | 121.285624 | 121.345056 | 121.270766 | 121.31534 | 4002.0 |
| 2015-02-22 23:00:00 | ZN | Futures | 121.330198 | 121.345056 | 121.300482 | 121.31534 | 2267.0 |
> showing 36 of 267 rows — these rows as CSV