PREVIEW / futures_1hour / 2011-01-16
file: by_date/futures_1hour/2011/2011-01-16.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-01-16 18:00:00 | ES | Futures | 1276.23 | 1278.21 | 1275.24 | 1275.49 | 11482.0 |
| 2011-01-16 19:00:00 | ES | Futures | 1275.49 | 1275.73 | 1273.75 | 1274.5 | 7260.0 |
| 2011-01-16 20:00:00 | ES | Futures | 1274.5 | 1275.24 | 1274.0 | 1274.74 | 2511.0 |
| 2011-01-16 21:00:00 | ES | Futures | 1274.74 | 1274.99 | 1273.26 | 1273.51 | 2906.0 |
| 2011-01-16 22:00:00 | ES | Futures | 1273.51 | 1273.75 | 1272.76 | 1273.75 | 3836.0 |
| 2011-01-16 23:00:00 | ES | Futures | 1273.75 | 1273.75 | 1272.76 | 1272.76 | 974.0 |
| 2011-01-16 18:00:00 | NQ | Futures | 2665.1 | 2669.4 | 2662.23 | 2662.23 | 955.0 |
| 2011-01-16 19:00:00 | NQ | Futures | 2662.51 | 2662.8 | 2660.22 | 2661.94 | 534.0 |
| 2011-01-16 20:00:00 | NQ | Futures | 2661.65 | 2664.52 | 2661.65 | 2663.66 | 346.0 |
| 2011-01-16 21:00:00 | NQ | Futures | 2663.66 | 2663.66 | 2660.22 | 2661.08 | 227.0 |
| 2011-01-16 22:00:00 | NQ | Futures | 2661.08 | 2661.36 | 2659.93 | 2661.08 | 259.0 |
| 2011-01-16 23:00:00 | NQ | Futures | 2661.08 | 2661.65 | 2660.22 | 2660.22 | 110.0 |
| 2011-01-16 18:00:00 | YM | Futures | 11233.8 | 11249.2 | 11228.1 | 11228.1 | 253.0 |
| 2011-01-16 19:00:00 | YM | Futures | 11229.0 | 11229.0 | 11217.5 | 11220.4 | 308.0 |
| 2011-01-16 20:00:00 | YM | Futures | 11220.4 | 11227.1 | 11219.5 | 11223.3 | 141.0 |
| 2011-01-16 21:00:00 | YM | Futures | 11222.3 | 11223.3 | 11214.7 | 11216.6 | 92.0 |
| 2011-01-16 22:00:00 | YM | Futures | 11215.6 | 11218.5 | 11210.8 | 11218.5 | 226.0 |
| 2011-01-16 23:00:00 | YM | Futures | 11218.5 | 11218.5 | 11213.7 | 11214.7 | 29.0 |
| 2011-01-16 18:00:00 | CL | Futures | 169.73 | 169.97 | 169.58 | 169.66 | 272.0 |
| 2011-01-16 19:00:00 | CL | Futures | 169.71 | 169.79 | 169.36 | 169.4 | 146.0 |
| 2011-01-16 20:00:00 | CL | Futures | 169.53 | 169.64 | 169.35 | 169.58 | 142.0 |
| 2011-01-16 21:00:00 | CL | Futures | 169.62 | 169.68 | 169.44 | 169.46 | 166.0 |
| 2011-01-16 22:00:00 | CL | Futures | 169.47 | 169.51 | 169.42 | 169.49 | 115.0 |
| 2011-01-16 23:00:00 | CL | Futures | 169.49 | 169.55 | 169.27 | 169.29 | 178.0 |
| 2011-01-16 18:00:00 | GC | Futures | 1901.3 | 1906.1 | 1900.5 | 1905.1 | 1671.0 |
| 2011-01-16 19:00:00 | GC | Futures | 1904.7 | 1905.9 | 1901.6 | 1905.1 | 1143.0 |
| 2011-01-16 20:00:00 | GC | Futures | 1904.9 | 1905.9 | 1904.0 | 1905.6 | 915.0 |
| 2011-01-16 21:00:00 | GC | Futures | 1905.9 | 1907.3 | 1905.4 | 1906.3 | 1344.0 |
| 2011-01-16 22:00:00 | GC | Futures | 1906.6 | 1907.2 | 1906.1 | 1906.5 | 607.0 |
| 2011-01-16 23:00:00 | GC | Futures | 1906.5 | 1907.0 | 1904.4 | 1904.4 | 990.0 |
| 2011-01-16 18:00:00 | ZN | Futures | 101.666639 | 101.692919 | 101.614077 | 101.692919 | 1955.0 |
| 2011-01-16 19:00:00 | ZN | Futures | 101.692919 | 101.73234 | 101.666639 | 101.666639 | 1998.0 |
| 2011-01-16 20:00:00 | ZN | Futures | 101.666639 | 101.679779 | 101.600937 | 101.627218 | 2184.0 |
| 2011-01-16 21:00:00 | ZN | Futures | 101.627218 | 101.653498 | 101.614077 | 101.627218 | 2134.0 |
| 2011-01-16 22:00:00 | ZN | Futures | 101.627218 | 101.640358 | 101.614077 | 101.627218 | 1251.0 |
| 2011-01-16 23:00:00 | ZN | Futures | 101.627218 | 101.627218 | 101.587797 | 101.614077 | 901.0 |
> showing 36 of 207 rows — these rows as CSV