PREVIEW / futures_1hour / 2010-02-17
file: by_date/futures_1hour/2010/2010-02-17.parquet size: 45 KB rows: 1,362
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-02-17 00:00:00 | ES | Futures | 1065.96 | 1066.45 | 1065.72 | 1065.96 | 1649.0 |
| 2010-02-17 01:00:00 | ES | Futures | 1065.96 | 1066.45 | 1064.99 | 1065.47 | 3232.0 |
| 2010-02-17 02:00:00 | ES | Futures | 1065.47 | 1067.18 | 1063.04 | 1066.69 | 18688.0 |
| 2010-02-17 03:00:00 | ES | Futures | 1066.93 | 1069.12 | 1066.45 | 1067.66 | 34307.0 |
| 2010-02-17 04:00:00 | ES | Futures | 1067.91 | 1069.12 | 1066.45 | 1067.66 | 16361.0 |
| 2010-02-17 05:00:00 | ES | Futures | 1067.66 | 1068.15 | 1066.69 | 1067.18 | 13460.0 |
| 2010-02-17 06:00:00 | ES | Futures | 1066.93 | 1068.15 | 1065.72 | 1067.42 | 14683.0 |
| 2010-02-17 07:00:00 | ES | Futures | 1067.18 | 1070.34 | 1066.69 | 1069.61 | 40973.0 |
| 2010-02-17 08:00:00 | ES | Futures | 1069.61 | 1070.34 | 1068.39 | 1069.37 | 49715.0 |
| 2010-02-17 09:00:00 | ES | Futures | 1069.37 | 1069.61 | 1065.72 | 1066.93 | 260820.0 |
| 2010-02-17 10:00:00 | ES | Futures | 1066.93 | 1069.85 | 1064.99 | 1066.69 | 275174.0 |
| 2010-02-17 11:00:00 | ES | Futures | 1066.93 | 1067.18 | 1063.28 | 1065.72 | 233964.0 |
| 2010-02-17 12:00:00 | ES | Futures | 1065.47 | 1067.91 | 1065.47 | 1067.66 | 105190.0 |
| 2010-02-17 13:00:00 | ES | Futures | 1067.66 | 1068.64 | 1065.96 | 1066.93 | 98002.0 |
| 2010-02-17 14:00:00 | ES | Futures | 1066.69 | 1067.91 | 1064.26 | 1067.91 | 184483.0 |
| 2010-02-17 15:00:00 | ES | Futures | 1067.91 | 1069.12 | 1066.69 | 1068.39 | 192274.0 |
| 2010-02-17 16:00:00 | ES | Futures | 1068.39 | 1070.34 | 1067.91 | 1069.12 | 105130.0 |
| 2010-02-17 17:00:00 | ES | Futures | 1069.12 | 1070.1 | 1069.12 | 1069.85 | 1932.0 |
| 2010-02-17 18:00:00 | ES | Futures | 1069.61 | 1069.85 | 1068.88 | 1068.88 | 3348.0 |
| 2010-02-17 19:00:00 | ES | Futures | 1068.88 | 1069.37 | 1067.42 | 1067.66 | 6321.0 |
| 2010-02-17 20:00:00 | ES | Futures | 1067.66 | 1068.39 | 1067.42 | 1067.42 | 2084.0 |
| 2010-02-17 21:00:00 | ES | Futures | 1067.66 | 1068.15 | 1066.93 | 1067.42 | 2654.0 |
| 2010-02-17 22:00:00 | ES | Futures | 1067.42 | 1068.39 | 1066.93 | 1067.91 | 2460.0 |
| 2010-02-17 23:00:00 | ES | Futures | 1067.91 | 1068.39 | 1067.42 | 1067.66 | 1110.0 |
| 2010-02-17 00:00:00 | NQ | Futures | 2059.39 | 2059.67 | 2056.82 | 2059.1 | 288.0 |
| 2010-02-17 01:00:00 | NQ | Futures | 2059.1 | 2059.96 | 2058.24 | 2058.53 | 217.0 |
| 2010-02-17 02:00:00 | NQ | Futures | 2058.81 | 2061.39 | 2055.39 | 2060.81 | 1592.0 |
| 2010-02-17 03:00:00 | NQ | Futures | 2061.1 | 2064.24 | 2060.53 | 2062.53 | 3087.0 |
| 2010-02-17 04:00:00 | NQ | Futures | 2062.81 | 2064.53 | 2060.81 | 2062.24 | 2232.0 |
| 2010-02-17 05:00:00 | NQ | Futures | 2062.24 | 2062.53 | 2060.53 | 2060.81 | 1371.0 |
| 2010-02-17 06:00:00 | NQ | Futures | 2060.81 | 2062.53 | 2058.81 | 2061.67 | 972.0 |
| 2010-02-17 07:00:00 | NQ | Futures | 2061.67 | 2065.67 | 2058.24 | 2063.67 | 3870.0 |
| 2010-02-17 08:00:00 | NQ | Futures | 2063.96 | 2067.1 | 2062.24 | 2065.38 | 5879.0 |
| 2010-02-17 09:00:00 | NQ | Futures | 2065.67 | 2066.81 | 2056.82 | 2061.39 | 43166.0 |
| 2010-02-17 10:00:00 | NQ | Futures | 2061.67 | 2067.95 | 2059.39 | 2064.81 | 41007.0 |
| 2010-02-17 11:00:00 | NQ | Futures | 2064.81 | 2064.81 | 2053.67 | 2058.24 | 36849.0 |
| 2010-02-17 12:00:00 | NQ | Futures | 2058.53 | 2063.1 | 2057.96 | 2062.81 | 18146.0 |
| 2010-02-17 13:00:00 | NQ | Futures | 2062.81 | 2065.96 | 2062.53 | 2063.67 | 17356.0 |
| 2010-02-17 14:00:00 | NQ | Futures | 2063.96 | 2065.1 | 2060.24 | 2064.81 | 20168.0 |
| 2010-02-17 15:00:00 | NQ | Futures | 2064.81 | 2067.95 | 2063.96 | 2067.95 | 26557.0 |
| 2010-02-17 16:00:00 | NQ | Futures | 2067.95 | 2071.95 | 2067.1 | 2069.1 | 13130.0 |
| 2010-02-17 17:00:00 | NQ | Futures | 2069.38 | 2069.95 | 2069.1 | 2069.67 | 122.0 |
| 2010-02-17 18:00:00 | NQ | Futures | 2069.67 | 2069.67 | 2068.24 | 2068.53 | 259.0 |
| 2010-02-17 19:00:00 | NQ | Futures | 2068.24 | 2068.53 | 2066.24 | 2067.38 | 505.0 |
| 2010-02-17 20:00:00 | NQ | Futures | 2067.38 | 2067.38 | 2066.24 | 2066.24 | 186.0 |
| 2010-02-17 21:00:00 | NQ | Futures | 2066.24 | 2067.67 | 2065.67 | 2066.81 | 204.0 |
| 2010-02-17 22:00:00 | NQ | Futures | 2066.53 | 2068.53 | 2065.96 | 2067.67 | 160.0 |
| 2010-02-17 23:00:00 | NQ | Futures | 2067.67 | 2068.24 | 2066.53 | 2067.67 | 123.0 |
| 2010-02-17 00:00:00 | YM | Futures | 9599.6 | 9600.5 | 9596.7 | 9597.7 | 124.0 |
| 2010-02-17 01:00:00 | YM | Futures | 9598.6 | 9602.4 | 9588.3 | 9592.1 | 222.0 |
> showing 50 of 1,362 rows — these rows as CSV