PREVIEW / futures_1hour / 2013-01-20
file: by_date/futures_1hour/2013/2013-01-20.parquet size: 12 KB rows: 228
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-01-20 18:00:00 | ES | Futures | 1516.97 | 1520.56 | 1516.97 | 1519.79 | 6871.0 |
| 2013-01-20 19:00:00 | ES | Futures | 1519.79 | 1520.05 | 1517.74 | 1518.25 | 6603.0 |
| 2013-01-20 20:00:00 | ES | Futures | 1518.25 | 1519.28 | 1517.74 | 1519.02 | 4551.0 |
| 2013-01-20 21:00:00 | ES | Futures | 1518.76 | 1520.82 | 1518.76 | 1519.79 | 5409.0 |
| 2013-01-20 22:00:00 | ES | Futures | 1519.79 | 1520.56 | 1519.02 | 1519.79 | 2346.0 |
| 2013-01-20 23:00:00 | ES | Futures | 1519.79 | 1519.79 | 1519.28 | 1519.28 | 1525.0 |
| 2013-01-20 18:00:00 | NQ | Futures | 3183.42 | 3187.5 | 3182.84 | 3186.33 | 334.0 |
| 2013-01-20 19:00:00 | NQ | Futures | 3186.04 | 3186.33 | 3184.0 | 3185.17 | 574.0 |
| 2013-01-20 20:00:00 | NQ | Futures | 3184.88 | 3187.5 | 3184.3 | 3186.62 | 345.0 |
| 2013-01-20 21:00:00 | NQ | Futures | 3186.92 | 3189.53 | 3186.62 | 3188.37 | 322.0 |
| 2013-01-20 22:00:00 | NQ | Futures | 3188.08 | 3189.83 | 3187.21 | 3188.95 | 328.0 |
| 2013-01-20 23:00:00 | NQ | Futures | 3188.95 | 3189.24 | 3188.08 | 3188.37 | 121.0 |
| 2013-01-20 18:00:00 | YM | Futures | 13655.8 | 13686.0 | 13648.7 | 13678.9 | 879.0 |
| 2013-01-20 19:00:00 | YM | Futures | 13678.9 | 13679.9 | 13657.8 | 13661.8 | 790.0 |
| 2013-01-20 20:00:00 | YM | Futures | 13660.8 | 13666.8 | 13655.8 | 13663.8 | 454.0 |
| 2013-01-20 21:00:00 | YM | Futures | 13663.8 | 13673.9 | 13662.8 | 13667.9 | 368.0 |
| 2013-01-20 22:00:00 | YM | Futures | 13667.9 | 13672.9 | 13662.8 | 13665.8 | 253.0 |
| 2013-01-20 23:00:00 | YM | Futures | 13665.8 | 13668.9 | 13661.8 | 13664.8 | 156.0 |
| 2013-01-20 18:00:00 | CL | Futures | 152.96 | 153.18 | 152.94 | 153.17 | 444.0 |
| 2013-01-20 19:00:00 | CL | Futures | 153.17 | 153.18 | 152.91 | 152.99 | 496.0 |
| 2013-01-20 20:00:00 | CL | Futures | 153.01 | 153.09 | 152.93 | 153.02 | 615.0 |
| 2013-01-20 21:00:00 | CL | Futures | 153.02 | 153.1 | 152.96 | 153.02 | 394.0 |
| 2013-01-20 22:00:00 | CL | Futures | 153.01 | 153.04 | 152.88 | 152.94 | 534.0 |
| 2013-01-20 23:00:00 | CL | Futures | 152.93 | 153.01 | 152.88 | 152.88 | 484.0 |
| 2013-01-20 18:00:00 | GC | Futures | 2322.7 | 2326.9 | 2320.4 | 2325.4 | 1837.0 |
| 2013-01-20 19:00:00 | GC | Futures | 2325.4 | 2325.9 | 2322.5 | 2324.8 | 2041.0 |
| 2013-01-20 20:00:00 | GC | Futures | 2324.8 | 2329.1 | 2324.7 | 2326.7 | 2600.0 |
| 2013-01-20 21:00:00 | GC | Futures | 2326.9 | 2328.1 | 2325.9 | 2327.0 | 1290.0 |
| 2013-01-20 22:00:00 | GC | Futures | 2326.9 | 2328.0 | 2325.5 | 2326.5 | 1169.0 |
| 2013-01-20 23:00:00 | GC | Futures | 2326.6 | 2328.0 | 2325.9 | 2327.6 | 1261.0 |
| 2013-01-20 18:00:00 | ZN | Futures | 117.614664 | 117.614664 | 117.545119 | 117.572937 | 5957.0 |
| 2013-01-20 19:00:00 | ZN | Futures | 117.572937 | 117.628573 | 117.559028 | 117.600755 | 3913.0 |
| 2013-01-20 20:00:00 | ZN | Futures | 117.600755 | 117.628573 | 117.572937 | 117.572937 | 1757.0 |
| 2013-01-20 21:00:00 | ZN | Futures | 117.572937 | 117.586846 | 117.53121 | 117.545119 | 2906.0 |
| 2013-01-20 22:00:00 | ZN | Futures | 117.545119 | 117.559028 | 117.53121 | 117.545119 | 3467.0 |
| 2013-01-20 23:00:00 | ZN | Futures | 117.545119 | 117.559028 | 117.475574 | 117.517301 | 5468.0 |
> showing 36 of 228 rows — these rows as CSV