PREVIEW / futures_1hour / 2008-09-03
file: by_date/futures_1hour/2008/2008-09-03.parquet size: 42 KB rows: 1,246
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 |
|---|---|---|---|---|---|---|---|
| 2008-09-03 00:00:00 | ES | Futures | 1186.25 | 1186.71 | 1183.46 | 1184.16 | 3129.0 |
| 2008-09-03 01:00:00 | ES | Futures | 1184.16 | 1186.02 | 1183.23 | 1185.55 | 1641.0 |
| 2008-09-03 02:00:00 | ES | Futures | 1185.32 | 1187.87 | 1185.09 | 1187.87 | 4792.0 |
| 2008-09-03 03:00:00 | ES | Futures | 1187.87 | 1188.8 | 1185.78 | 1186.95 | 14985.0 |
| 2008-09-03 04:00:00 | ES | Futures | 1186.95 | 1189.73 | 1186.71 | 1187.64 | 11616.0 |
| 2008-09-03 05:00:00 | ES | Futures | 1187.64 | 1187.64 | 1184.16 | 1184.85 | 12769.0 |
| 2008-09-03 06:00:00 | ES | Futures | 1185.09 | 1186.48 | 1183.69 | 1184.16 | 10733.0 |
| 2008-09-03 07:00:00 | ES | Futures | 1183.92 | 1184.85 | 1179.28 | 1180.44 | 37794.0 |
| 2008-09-03 08:00:00 | ES | Futures | 1180.21 | 1185.55 | 1179.74 | 1185.09 | 56448.0 |
| 2008-09-03 09:00:00 | ES | Futures | 1185.32 | 1188.11 | 1181.83 | 1187.64 | 249691.0 |
| 2008-09-03 10:00:00 | ES | Futures | 1187.64 | 1190.9 | 1183.46 | 1185.09 | 373822.0 |
| 2008-09-03 11:00:00 | ES | Futures | 1184.85 | 1189.04 | 1176.95 | 1178.11 | 328124.0 |
| 2008-09-03 12:00:00 | ES | Futures | 1177.88 | 1179.51 | 1176.25 | 1178.11 | 191849.0 |
| 2008-09-03 13:00:00 | ES | Futures | 1178.35 | 1183.46 | 1176.72 | 1182.99 | 170722.0 |
| 2008-09-03 14:00:00 | ES | Futures | 1182.99 | 1184.85 | 1177.18 | 1179.97 | 269982.0 |
| 2008-09-03 15:00:00 | ES | Futures | 1179.97 | 1186.71 | 1177.42 | 1185.78 | 326725.0 |
| 2008-09-03 16:00:00 | ES | Futures | 1185.78 | 1186.25 | 1184.39 | 1185.78 | 69627.0 |
| 2008-09-03 17:00:00 | ES | Futures | 1185.55 | 1186.95 | 1185.55 | 1186.48 | 4450.0 |
| 2008-09-03 18:00:00 | ES | Futures | 1186.48 | 1187.18 | 1185.55 | 1186.95 | 1529.0 |
| 2008-09-03 19:00:00 | ES | Futures | 1186.71 | 1186.95 | 1186.25 | 1186.48 | 462.0 |
| 2008-09-03 20:00:00 | ES | Futures | 1186.25 | 1186.71 | 1184.85 | 1185.09 | 1691.0 |
| 2008-09-03 21:00:00 | ES | Futures | 1185.09 | 1185.32 | 1182.99 | 1185.09 | 3873.0 |
| 2008-09-03 22:00:00 | ES | Futures | 1185.09 | 1185.55 | 1184.62 | 1184.62 | 1133.0 |
| 2008-09-03 23:00:00 | ES | Futures | 1184.62 | 1185.55 | 1184.39 | 1185.09 | 1238.0 |
| 2008-09-03 00:00:00 | NQ | Futures | 2083.51 | 2083.51 | 2079.29 | 2080.69 | 260.0 |
| 2008-09-03 01:00:00 | NQ | Futures | 2080.41 | 2084.35 | 2079.85 | 2081.82 | 463.0 |
| 2008-09-03 02:00:00 | NQ | Futures | 2081.82 | 2084.91 | 2081.26 | 2084.91 | 457.0 |
| 2008-09-03 03:00:00 | NQ | Futures | 2084.63 | 2087.44 | 2082.38 | 2086.04 | 1467.0 |
| 2008-09-03 04:00:00 | NQ | Futures | 2085.76 | 2092.23 | 2085.76 | 2086.88 | 2574.0 |
| 2008-09-03 05:00:00 | NQ | Futures | 2086.6 | 2086.6 | 2075.91 | 2076.47 | 2359.0 |
| 2008-09-03 06:00:00 | NQ | Futures | 2076.19 | 2079.01 | 2073.66 | 2073.94 | 1611.0 |
| 2008-09-03 07:00:00 | NQ | Futures | 2074.79 | 2074.79 | 2066.07 | 2068.88 | 5073.0 |
| 2008-09-03 08:00:00 | NQ | Futures | 2068.88 | 2079.01 | 2068.32 | 2078.44 | 9440.0 |
| 2008-09-03 09:00:00 | NQ | Futures | 2078.44 | 2082.38 | 2070.57 | 2081.54 | 52976.0 |
| 2008-09-03 10:00:00 | NQ | Futures | 2081.54 | 2088.85 | 2070.0 | 2077.32 | 62328.0 |
| 2008-09-03 11:00:00 | NQ | Futures | 2077.32 | 2084.35 | 2055.66 | 2057.91 | 61639.0 |
| 2008-09-03 12:00:00 | NQ | Futures | 2057.91 | 2060.72 | 2051.16 | 2059.03 | 44066.0 |
| 2008-09-03 13:00:00 | NQ | Futures | 2059.03 | 2068.88 | 2054.81 | 2066.35 | 43724.0 |
| 2008-09-03 14:00:00 | NQ | Futures | 2066.63 | 2072.82 | 2054.53 | 2057.06 | 46329.0 |
| 2008-09-03 15:00:00 | NQ | Futures | 2056.78 | 2066.63 | 2049.75 | 2064.94 | 59497.0 |
| 2008-09-03 16:00:00 | NQ | Futures | 2064.94 | 2066.07 | 2061.57 | 2063.53 | 11945.0 |
| 2008-09-03 17:00:00 | NQ | Futures | 2063.82 | 2065.5 | 2063.53 | 2064.66 | 168.0 |
| 2008-09-03 18:00:00 | NQ | Futures | 2063.82 | 2065.22 | 2063.25 | 2065.22 | 57.0 |
| 2008-09-03 19:00:00 | NQ | Futures | 2065.22 | 2065.78 | 2064.38 | 2065.22 | 412.0 |
| 2008-09-03 20:00:00 | NQ | Futures | 2065.78 | 2065.78 | 2062.13 | 2062.97 | 146.0 |
| 2008-09-03 21:00:00 | NQ | Futures | 2062.41 | 2062.97 | 2059.88 | 2062.97 | 243.0 |
| 2008-09-03 22:00:00 | NQ | Futures | 2062.97 | 2063.53 | 2062.41 | 2062.41 | 68.0 |
| 2008-09-03 23:00:00 | NQ | Futures | 2062.41 | 2063.53 | 2060.44 | 2060.72 | 117.0 |
| 2008-09-03 00:00:00 | YM | Futures | 10455.7 | 10462.1 | 10438.4 | 10442.1 | 235.0 |
| 2008-09-03 01:00:00 | YM | Futures | 10442.1 | 10455.7 | 10435.7 | 10451.1 | 140.0 |
> showing 50 of 1,246 rows — these rows as CSV