PREVIEW / futures_1hour / 2010-08-22
file: by_date/futures_1hour/2010/2010-08-22.parquet size: 13 KB rows: 230
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-22 18:00:00 | ES | Futures | 1050.22 | 1054.4 | 1049.24 | 1053.17 | 8037.0 |
| 2010-08-22 19:00:00 | ES | Futures | 1053.17 | 1053.41 | 1052.19 | 1052.19 | 2306.0 |
| 2010-08-22 20:00:00 | ES | Futures | 1052.19 | 1053.91 | 1052.19 | 1052.92 | 6261.0 |
| 2010-08-22 21:00:00 | ES | Futures | 1052.92 | 1054.4 | 1052.19 | 1054.15 | 6532.0 |
| 2010-08-22 22:00:00 | ES | Futures | 1054.15 | 1054.89 | 1053.41 | 1054.15 | 4414.0 |
| 2010-08-22 23:00:00 | ES | Futures | 1053.91 | 1054.4 | 1052.19 | 1053.17 | 3818.0 |
| 2010-08-22 18:00:00 | NQ | Futures | 2091.65 | 2100.53 | 2091.36 | 2098.52 | 772.0 |
| 2010-08-22 19:00:00 | NQ | Futures | 2098.24 | 2099.1 | 2096.8 | 2097.66 | 577.0 |
| 2010-08-22 20:00:00 | NQ | Futures | 2097.66 | 2100.24 | 2096.8 | 2097.95 | 543.0 |
| 2010-08-22 21:00:00 | NQ | Futures | 2097.95 | 2100.53 | 2095.37 | 2099.96 | 567.0 |
| 2010-08-22 22:00:00 | NQ | Futures | 2100.24 | 2101.1 | 2098.52 | 2099.38 | 372.0 |
| 2010-08-22 23:00:00 | NQ | Futures | 2099.38 | 2100.24 | 2096.23 | 2098.52 | 245.0 |
| 2010-08-22 18:00:00 | YM | Futures | 9657.3 | 9686.6 | 9646.9 | 9680.9 | 260.0 |
| 2010-08-22 19:00:00 | YM | Futures | 9677.2 | 9678.1 | 9669.6 | 9670.5 | 156.0 |
| 2010-08-22 20:00:00 | YM | Futures | 9669.6 | 9682.8 | 9668.6 | 9676.2 | 200.0 |
| 2010-08-22 21:00:00 | YM | Futures | 9676.2 | 9684.7 | 9667.7 | 9682.8 | 289.0 |
| 2010-08-22 22:00:00 | YM | Futures | 9683.8 | 9688.5 | 9679.1 | 9683.8 | 351.0 |
| 2010-08-22 23:00:00 | YM | Futures | 9683.8 | 9686.6 | 9668.6 | 9677.2 | 143.0 |
| 2010-08-22 18:00:00 | CL | Futures | 141.25 | 141.67 | 141.08 | 141.37 | 885.0 |
| 2010-08-22 19:00:00 | CL | Futures | 141.37 | 141.41 | 140.99 | 141.14 | 564.0 |
| 2010-08-22 20:00:00 | CL | Futures | 141.12 | 141.46 | 141.01 | 141.31 | 583.0 |
| 2010-08-22 21:00:00 | CL | Futures | 141.33 | 141.6 | 141.18 | 141.58 | 517.0 |
| 2010-08-22 22:00:00 | CL | Futures | 141.6 | 142.02 | 141.56 | 141.6 | 1101.0 |
| 2010-08-22 23:00:00 | CL | Futures | 141.6 | 141.96 | 141.48 | 141.66 | 495.0 |
| 2010-08-22 18:00:00 | GC | Futures | 1719.7 | 1722.4 | 1718.2 | 1721.8 | 504.0 |
| 2010-08-22 19:00:00 | GC | Futures | 1721.8 | 1722.5 | 1718.4 | 1718.6 | 562.0 |
| 2010-08-22 20:00:00 | GC | Futures | 1718.4 | 1721.9 | 1717.9 | 1720.8 | 1210.0 |
| 2010-08-22 21:00:00 | GC | Futures | 1721.0 | 1721.9 | 1719.8 | 1720.8 | 516.0 |
| 2010-08-22 22:00:00 | GC | Futures | 1720.8 | 1723.3 | 1720.8 | 1721.4 | 857.0 |
| 2010-08-22 23:00:00 | GC | Futures | 1721.7 | 1721.8 | 1721.0 | 1721.1 | 229.0 |
| 2010-08-22 18:00:00 | ZN | Futures | 103.84706 | 103.872922 | 103.808268 | 103.859991 | 2111.0 |
| 2010-08-22 19:00:00 | ZN | Futures | 103.84706 | 103.898783 | 103.84706 | 103.84706 | 2510.0 |
| 2010-08-22 20:00:00 | ZN | Futures | 103.859991 | 103.950507 | 103.84706 | 103.937576 | 4843.0 |
| 2010-08-22 21:00:00 | ZN | Futures | 103.937576 | 103.963437 | 103.911714 | 103.911714 | 4057.0 |
| 2010-08-22 22:00:00 | ZN | Futures | 103.911714 | 103.937576 | 103.885853 | 103.885853 | 4026.0 |
| 2010-08-22 23:00:00 | ZN | Futures | 103.898783 | 103.911714 | 103.885853 | 103.898783 | 2100.0 |
> showing 36 of 230 rows — these rows as CSV