PREVIEW / futures_1hour / 2011-02-20
file: by_date/futures_1hour/2011/2011-02-20.parquet size: 12 KB rows: 207
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-02-20 18:00:00 | ES | Futures | 1328.44 | 1328.68 | 1326.95 | 1327.2 | 10268.0 |
| 2011-02-20 19:00:00 | ES | Futures | 1327.2 | 1327.2 | 1325.22 | 1325.71 | 11958.0 |
| 2011-02-20 20:00:00 | ES | Futures | 1325.71 | 1325.71 | 1324.72 | 1325.47 | 6958.0 |
| 2011-02-20 21:00:00 | ES | Futures | 1325.47 | 1326.7 | 1324.97 | 1326.21 | 4094.0 |
| 2011-02-20 22:00:00 | ES | Futures | 1326.21 | 1327.45 | 1326.21 | 1326.95 | 3925.0 |
| 2011-02-20 23:00:00 | ES | Futures | 1326.95 | 1327.2 | 1326.21 | 1326.7 | 4118.0 |
| 2011-02-20 18:00:00 | NQ | Futures | 2748.05 | 2748.62 | 2744.6 | 2744.6 | 704.0 |
| 2011-02-20 19:00:00 | NQ | Futures | 2744.6 | 2744.89 | 2741.16 | 2742.02 | 436.0 |
| 2011-02-20 20:00:00 | NQ | Futures | 2741.73 | 2741.73 | 2739.44 | 2741.45 | 556.0 |
| 2011-02-20 21:00:00 | NQ | Futures | 2741.73 | 2744.03 | 2740.87 | 2742.6 | 511.0 |
| 2011-02-20 22:00:00 | NQ | Futures | 2742.6 | 2743.46 | 2742.31 | 2742.6 | 448.0 |
| 2011-02-20 23:00:00 | NQ | Futures | 2742.31 | 2743.46 | 2741.45 | 2741.45 | 231.0 |
| 2011-02-20 18:00:00 | YM | Futures | 11848.7 | 11853.5 | 11841.1 | 11842.0 | 334.0 |
| 2011-02-20 19:00:00 | YM | Futures | 11842.0 | 11843.0 | 11830.5 | 11833.4 | 260.0 |
| 2011-02-20 20:00:00 | YM | Futures | 11832.4 | 11833.4 | 11828.6 | 11833.4 | 172.0 |
| 2011-02-20 21:00:00 | YM | Futures | 11832.4 | 11839.1 | 11830.5 | 11834.4 | 185.0 |
| 2011-02-20 22:00:00 | YM | Futures | 11833.4 | 11841.1 | 11833.4 | 11841.1 | 94.0 |
| 2011-02-20 23:00:00 | YM | Futures | 11839.1 | 11839.1 | 11833.4 | 11836.3 | 187.0 |
| 2011-02-20 18:00:00 | CL | Futures | 159.05 | 160.99 | 158.57 | 160.9 | 3708.0 |
| 2011-02-20 19:00:00 | CL | Futures | 160.9 | 161.98 | 160.87 | 161.71 | 2838.0 |
| 2011-02-20 20:00:00 | CL | Futures | 161.7 | 161.85 | 161.36 | 161.47 | 2062.0 |
| 2011-02-20 21:00:00 | CL | Futures | 161.47 | 161.62 | 161.18 | 161.34 | 1115.0 |
| 2011-02-20 22:00:00 | CL | Futures | 161.31 | 161.62 | 161.04 | 161.48 | 1046.0 |
| 2011-02-20 23:00:00 | CL | Futures | 161.47 | 161.54 | 161.2 | 161.29 | 685.0 |
| 2011-02-20 18:00:00 | GC | Futures | 1940.4 | 1942.9 | 1940.4 | 1942.3 | 1148.0 |
| 2011-02-20 19:00:00 | GC | Futures | 1942.3 | 1944.8 | 1941.9 | 1944.6 | 1675.0 |
| 2011-02-20 20:00:00 | GC | Futures | 1944.6 | 1949.0 | 1943.7 | 1948.2 | 2875.0 |
| 2011-02-20 21:00:00 | GC | Futures | 1948.5 | 1949.6 | 1948.1 | 1948.9 | 1171.0 |
| 2011-02-20 22:00:00 | GC | Futures | 1949.2 | 1949.4 | 1945.4 | 1947.6 | 1952.0 |
| 2011-02-20 23:00:00 | GC | Futures | 1947.8 | 1948.9 | 1946.1 | 1947.5 | 1156.0 |
| 2011-02-20 18:00:00 | ZN | Futures | 100.089801 | 100.168643 | 100.07666 | 100.155502 | 4433.0 |
| 2011-02-20 19:00:00 | ZN | Futures | 100.155502 | 100.221204 | 100.155502 | 100.208063 | 4538.0 |
| 2011-02-20 20:00:00 | ZN | Futures | 100.208063 | 100.221204 | 100.168643 | 100.181783 | 1128.0 |
| 2011-02-20 21:00:00 | ZN | Futures | 100.168643 | 100.194923 | 100.155502 | 100.181783 | 1027.0 |
| 2011-02-20 22:00:00 | ZN | Futures | 100.168643 | 100.208063 | 100.168643 | 100.194923 | 1169.0 |
| 2011-02-20 23:00:00 | ZN | Futures | 100.194923 | 100.221204 | 100.181783 | 100.221204 | 635.0 |
> showing 36 of 207 rows — these rows as CSV