PREVIEW / futures_1hour / 2010-07-18
file: by_date/futures_1hour/2010/2010-07-18.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-07-18 18:00:00 | ES | Futures | 1042.13 | 1042.86 | 1040.41 | 1041.88 | 7746.0 |
| 2010-07-18 19:00:00 | ES | Futures | 1041.88 | 1043.35 | 1041.88 | 1041.88 | 3041.0 |
| 2010-07-18 20:00:00 | ES | Futures | 1042.13 | 1043.35 | 1040.9 | 1041.15 | 5866.0 |
| 2010-07-18 21:00:00 | ES | Futures | 1040.9 | 1043.84 | 1040.9 | 1043.6 | 4673.0 |
| 2010-07-18 22:00:00 | ES | Futures | 1043.35 | 1045.81 | 1043.35 | 1045.07 | 5790.0 |
| 2010-07-18 23:00:00 | ES | Futures | 1045.32 | 1045.32 | 1044.09 | 1044.34 | 1967.0 |
| 2010-07-18 18:00:00 | NQ | Futures | 2063.85 | 2064.71 | 2043.22 | 2061.84 | 2015.0 |
| 2010-07-18 19:00:00 | NQ | Futures | 2061.84 | 2064.99 | 2061.84 | 2062.13 | 299.0 |
| 2010-07-18 20:00:00 | NQ | Futures | 2062.7 | 2064.42 | 2060.41 | 2060.98 | 685.0 |
| 2010-07-18 21:00:00 | NQ | Futures | 2061.27 | 2065.57 | 2060.98 | 2065.28 | 461.0 |
| 2010-07-18 22:00:00 | NQ | Futures | 2065.28 | 2070.15 | 2065.28 | 2068.72 | 476.0 |
| 2010-07-18 23:00:00 | NQ | Futures | 2068.72 | 2068.72 | 2067.29 | 2067.29 | 136.0 |
| 2010-07-18 18:00:00 | YM | Futures | 9509.6 | 9520.0 | 9492.6 | 9507.7 | 474.0 |
| 2010-07-18 19:00:00 | YM | Futures | 9507.7 | 9519.1 | 9507.7 | 9509.6 | 144.0 |
| 2010-07-18 20:00:00 | YM | Futures | 9508.7 | 9518.1 | 9500.1 | 9503.9 | 587.0 |
| 2010-07-18 21:00:00 | YM | Futures | 9503.0 | 9521.0 | 9502.0 | 9521.0 | 451.0 |
| 2010-07-18 22:00:00 | YM | Futures | 9520.0 | 9540.8 | 9519.1 | 9535.2 | 487.0 |
| 2010-07-18 23:00:00 | YM | Futures | 9535.2 | 9535.2 | 9528.5 | 9529.5 | 155.0 |
| 2010-07-18 18:00:00 | CL | Futures | 146.0 | 146.25 | 145.58 | 146.0 | 560.0 |
| 2010-07-18 19:00:00 | CL | Futures | 146.02 | 146.17 | 145.69 | 145.79 | 163.0 |
| 2010-07-18 20:00:00 | CL | Futures | 145.73 | 146.13 | 145.71 | 145.98 | 263.0 |
| 2010-07-18 21:00:00 | CL | Futures | 145.98 | 146.27 | 145.73 | 145.86 | 436.0 |
| 2010-07-18 22:00:00 | CL | Futures | 145.9 | 146.34 | 145.9 | 146.27 | 343.0 |
| 2010-07-18 23:00:00 | CL | Futures | 146.29 | 146.38 | 146.11 | 146.17 | 167.0 |
| 2010-07-18 18:00:00 | GC | Futures | 1675.4 | 1675.5 | 1671.1 | 1674.9 | 863.0 |
| 2010-07-18 19:00:00 | GC | Futures | 1674.7 | 1675.2 | 1672.0 | 1672.8 | 428.0 |
| 2010-07-18 20:00:00 | GC | Futures | 1673.0 | 1674.2 | 1672.5 | 1673.1 | 590.0 |
| 2010-07-18 21:00:00 | GC | Futures | 1673.2 | 1675.2 | 1673.2 | 1674.2 | 1018.0 |
| 2010-07-18 22:00:00 | GC | Futures | 1674.4 | 1675.5 | 1674.1 | 1674.4 | 564.0 |
| 2010-07-18 23:00:00 | GC | Futures | 1674.4 | 1674.8 | 1673.2 | 1673.5 | 407.0 |
| 2010-07-18 18:00:00 | ZN | Futures | 102.101406 | 102.101406 | 102.036752 | 102.049683 | 2671.0 |
| 2010-07-18 19:00:00 | ZN | Futures | 102.062613 | 102.088475 | 102.036752 | 102.088475 | 1685.0 |
| 2010-07-18 20:00:00 | ZN | Futures | 102.088475 | 102.101406 | 102.049683 | 102.075544 | 1716.0 |
| 2010-07-18 21:00:00 | ZN | Futures | 102.075544 | 102.088475 | 102.049683 | 102.049683 | 1627.0 |
| 2010-07-18 22:00:00 | ZN | Futures | 102.049683 | 102.049683 | 101.972098 | 101.985029 | 3610.0 |
| 2010-07-18 23:00:00 | ZN | Futures | 101.985029 | 102.036752 | 101.985029 | 102.036752 | 1120.0 |
> showing 36 of 230 rows — these rows as CSV