PREVIEW / futures_1hour / 2013-02-17
file: by_date/futures_1hour/2013/2013-02-17.parquet size: 12 KB rows: 221
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-02-17 18:00:00 | ES | Futures | 1555.97 | 1558.02 | 1555.71 | 1556.99 | 5369.0 |
| 2013-02-17 19:00:00 | ES | Futures | 1556.99 | 1557.25 | 1555.46 | 1556.48 | 6065.0 |
| 2013-02-17 20:00:00 | ES | Futures | 1556.48 | 1557.76 | 1556.48 | 1557.25 | 4100.0 |
| 2013-02-17 21:00:00 | ES | Futures | 1557.25 | 1557.51 | 1556.74 | 1556.74 | 2638.0 |
| 2013-02-17 22:00:00 | ES | Futures | 1556.99 | 1557.51 | 1556.48 | 1557.25 | 2299.0 |
| 2013-02-17 23:00:00 | ES | Futures | 1557.51 | 1558.28 | 1557.25 | 1557.51 | 2665.0 |
| 2013-02-17 18:00:00 | NQ | Futures | 3213.11 | 3215.15 | 3211.95 | 3212.82 | 719.0 |
| 2013-02-17 19:00:00 | NQ | Futures | 3212.82 | 3213.69 | 3211.37 | 3212.53 | 391.0 |
| 2013-02-17 20:00:00 | NQ | Futures | 3212.53 | 3215.44 | 3212.53 | 3214.57 | 482.0 |
| 2013-02-17 21:00:00 | NQ | Futures | 3214.86 | 3215.44 | 3213.98 | 3214.57 | 318.0 |
| 2013-02-17 22:00:00 | NQ | Futures | 3214.28 | 3215.44 | 3213.98 | 3215.15 | 178.0 |
| 2013-02-17 23:00:00 | NQ | Futures | 3215.15 | 3216.9 | 3215.15 | 3216.02 | 156.0 |
| 2013-02-17 18:00:00 | YM | Futures | 14021.0 | 14038.1 | 14021.0 | 14032.0 | 392.0 |
| 2013-02-17 19:00:00 | YM | Futures | 14032.0 | 14032.0 | 14021.0 | 14028.0 | 313.0 |
| 2013-02-17 20:00:00 | YM | Futures | 14029.0 | 14038.1 | 14029.0 | 14032.0 | 553.0 |
| 2013-02-17 21:00:00 | YM | Futures | 14032.0 | 14034.0 | 14027.0 | 14030.0 | 303.0 |
| 2013-02-17 22:00:00 | YM | Futures | 14030.0 | 14032.0 | 14028.0 | 14032.0 | 222.0 |
| 2013-02-17 23:00:00 | YM | Futures | 14032.0 | 14040.1 | 14031.0 | 14036.1 | 253.0 |
| 2013-02-17 18:00:00 | CL | Futures | 153.15 | 153.31 | 152.5 | 152.78 | 748.0 |
| 2013-02-17 19:00:00 | CL | Futures | 152.8 | 153.1 | 152.8 | 152.99 | 660.0 |
| 2013-02-17 20:00:00 | CL | Futures | 152.99 | 153.01 | 152.75 | 152.83 | 564.0 |
| 2013-02-17 21:00:00 | CL | Futures | 152.83 | 152.85 | 152.73 | 152.78 | 216.0 |
| 2013-02-17 22:00:00 | CL | Futures | 152.77 | 152.85 | 152.75 | 152.77 | 289.0 |
| 2013-02-17 23:00:00 | CL | Futures | 152.78 | 152.83 | 152.72 | 152.73 | 308.0 |
| 2013-02-17 18:00:00 | GC | Futures | 2214.0 | 2218.2 | 2212.3 | 2218.0 | 2733.0 |
| 2013-02-17 19:00:00 | GC | Futures | 2218.0 | 2223.3 | 2217.6 | 2222.3 | 4490.0 |
| 2013-02-17 20:00:00 | GC | Futures | 2222.3 | 2226.1 | 2220.1 | 2225.6 | 6307.0 |
| 2013-02-17 21:00:00 | GC | Futures | 2225.5 | 2225.6 | 2222.8 | 2223.4 | 2944.0 |
| 2013-02-17 22:00:00 | GC | Futures | 2223.4 | 2223.7 | 2219.4 | 2220.5 | 2811.0 |
| 2013-02-17 23:00:00 | GC | Futures | 2220.6 | 2221.6 | 2217.2 | 2217.2 | 1990.0 |
| 2013-02-17 18:00:00 | ZN | Futures | 117.058303 | 117.072212 | 116.988758 | 117.002667 | 3742.0 |
| 2013-02-17 19:00:00 | ZN | Futures | 117.002667 | 117.016576 | 116.974849 | 117.002667 | 2417.0 |
| 2013-02-17 20:00:00 | ZN | Futures | 117.002667 | 117.002667 | 116.919213 | 116.96094 | 3980.0 |
| 2013-02-17 21:00:00 | ZN | Futures | 116.947031 | 116.988758 | 116.947031 | 116.974849 | 1700.0 |
| 2013-02-17 22:00:00 | ZN | Futures | 116.974849 | 116.988758 | 116.947031 | 116.988758 | 1793.0 |
| 2013-02-17 23:00:00 | ZN | Futures | 116.974849 | 116.988758 | 116.947031 | 116.96094 | 1512.0 |
> showing 36 of 221 rows — these rows as CSV