PREVIEW / futures_30min / 2010-05-28
file: by_date/futures_30min/2010/2010-05-28.parquet size: 61 KB rows: 2,003
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-05-28 00:00:00 | ES | Futures | 1074.01 | 1074.99 | 1072.79 | 1073.28 | 1617.0 |
| 2010-05-28 00:30:00 | ES | Futures | 1073.28 | 1074.25 | 1072.05 | 1072.79 | 2365.0 |
| 2010-05-28 01:00:00 | ES | Futures | 1072.54 | 1074.01 | 1072.3 | 1073.52 | 1576.0 |
| 2010-05-28 01:30:00 | ES | Futures | 1073.52 | 1075.23 | 1073.52 | 1074.5 | 2678.0 |
| 2010-05-28 02:00:00 | ES | Futures | 1074.25 | 1075.72 | 1073.03 | 1073.28 | 6610.0 |
| 2010-05-28 02:30:00 | ES | Futures | 1073.28 | 1077.92 | 1073.28 | 1076.7 | 9122.0 |
| 2010-05-28 03:00:00 | ES | Futures | 1076.45 | 1076.94 | 1072.54 | 1074.01 | 20084.0 |
| 2010-05-28 03:30:00 | ES | Futures | 1074.01 | 1075.96 | 1073.28 | 1075.48 | 21603.0 |
| 2010-05-28 04:00:00 | ES | Futures | 1075.48 | 1077.43 | 1074.99 | 1076.21 | 12500.0 |
| 2010-05-28 04:30:00 | ES | Futures | 1076.21 | 1080.12 | 1075.72 | 1078.16 | 17086.0 |
| 2010-05-28 05:00:00 | ES | Futures | 1078.16 | 1079.14 | 1076.94 | 1077.92 | 10372.0 |
| 2010-05-28 05:30:00 | ES | Futures | 1077.92 | 1079.39 | 1077.43 | 1078.65 | 7829.0 |
| 2010-05-28 06:00:00 | ES | Futures | 1078.9 | 1079.39 | 1077.92 | 1078.16 | 6346.0 |
| 2010-05-28 06:30:00 | ES | Futures | 1078.41 | 1078.9 | 1076.45 | 1077.68 | 7530.0 |
| 2010-05-28 07:00:00 | ES | Futures | 1077.92 | 1078.16 | 1076.7 | 1077.43 | 9232.0 |
| 2010-05-28 07:30:00 | ES | Futures | 1077.43 | 1082.08 | 1077.43 | 1080.36 | 26337.0 |
| 2010-05-28 08:00:00 | ES | Futures | 1080.36 | 1081.59 | 1078.16 | 1078.65 | 30308.0 |
| 2010-05-28 08:30:00 | ES | Futures | 1078.9 | 1079.39 | 1076.45 | 1077.43 | 38457.0 |
| 2010-05-28 09:00:00 | ES | Futures | 1077.43 | 1079.14 | 1076.21 | 1076.7 | 31614.0 |
| 2010-05-28 09:30:00 | ES | Futures | 1076.94 | 1077.19 | 1069.61 | 1074.5 | 247290.0 |
| 2010-05-28 10:00:00 | ES | Futures | 1074.5 | 1076.94 | 1073.28 | 1073.52 | 136624.0 |
| 2010-05-28 10:30:00 | ES | Futures | 1073.76 | 1076.21 | 1068.88 | 1070.59 | 148652.0 |
| 2010-05-28 11:00:00 | ES | Futures | 1070.59 | 1071.81 | 1066.19 | 1069.12 | 149875.0 |
| 2010-05-28 11:30:00 | ES | Futures | 1068.88 | 1073.03 | 1068.39 | 1071.08 | 90799.0 |
| 2010-05-28 12:00:00 | ES | Futures | 1071.08 | 1073.52 | 1070.1 | 1072.79 | 56018.0 |
| 2010-05-28 12:30:00 | ES | Futures | 1072.79 | 1073.52 | 1060.32 | 1065.94 | 263757.0 |
| 2010-05-28 13:00:00 | ES | Futures | 1065.7 | 1068.14 | 1064.23 | 1066.68 | 78460.0 |
| 2010-05-28 13:30:00 | ES | Futures | 1066.92 | 1067.65 | 1062.03 | 1062.77 | 64626.0 |
| 2010-05-28 14:00:00 | ES | Futures | 1062.52 | 1064.97 | 1059.1 | 1064.48 | 102217.0 |
| 2010-05-28 14:30:00 | ES | Futures | 1064.72 | 1072.05 | 1063.74 | 1068.63 | 110691.0 |
| 2010-05-28 15:00:00 | ES | Futures | 1068.63 | 1074.01 | 1067.41 | 1073.28 | 104885.0 |
| 2010-05-28 15:30:00 | ES | Futures | 1073.28 | 1074.99 | 1062.77 | 1064.72 | 291464.0 |
| 2010-05-28 16:00:00 | ES | Futures | 1064.23 | 1065.45 | 1059.83 | 1063.25 | 192763.0 |
| 2010-05-28 00:00:00 | NQ | Futures | 2130.04 | 2131.18 | 2128.03 | 2128.89 | 225.0 |
| 2010-05-28 00:30:00 | NQ | Futures | 2129.18 | 2130.33 | 2126.6 | 2128.03 | 245.0 |
| 2010-05-28 01:00:00 | NQ | Futures | 2127.46 | 2130.04 | 2124.03 | 2128.61 | 648.0 |
| 2010-05-28 01:30:00 | NQ | Futures | 2128.32 | 2132.04 | 2128.32 | 2130.9 | 326.0 |
| 2010-05-28 02:00:00 | NQ | Futures | 2130.61 | 2132.62 | 2128.61 | 2128.89 | 723.0 |
| 2010-05-28 02:30:00 | NQ | Futures | 2128.61 | 2135.77 | 2128.61 | 2134.33 | 964.0 |
| 2010-05-28 03:00:00 | NQ | Futures | 2134.05 | 2134.05 | 2125.17 | 2127.75 | 2022.0 |
| 2010-05-28 03:30:00 | NQ | Futures | 2127.75 | 2133.19 | 2126.89 | 2132.9 | 2169.0 |
| 2010-05-28 04:00:00 | NQ | Futures | 2132.62 | 2135.19 | 2130.9 | 2132.62 | 1315.0 |
| 2010-05-28 04:30:00 | NQ | Futures | 2132.9 | 2140.92 | 2132.33 | 2137.2 | 1583.0 |
| 2010-05-28 05:00:00 | NQ | Futures | 2137.2 | 2138.92 | 2134.91 | 2136.91 | 485.0 |
| 2010-05-28 05:30:00 | NQ | Futures | 2137.2 | 2139.2 | 2136.05 | 2138.06 | 465.0 |
| 2010-05-28 06:00:00 | NQ | Futures | 2138.34 | 2138.63 | 2136.63 | 2136.63 | 576.0 |
| 2010-05-28 06:30:00 | NQ | Futures | 2136.91 | 2137.77 | 2134.05 | 2135.48 | 627.0 |
| 2010-05-28 07:00:00 | NQ | Futures | 2135.77 | 2138.06 | 2134.05 | 2137.77 | 1379.0 |
| 2010-05-28 07:30:00 | NQ | Futures | 2137.77 | 2146.94 | 2137.49 | 2143.5 | 2785.0 |
| 2010-05-28 08:00:00 | NQ | Futures | 2143.5 | 2146.36 | 2140.64 | 2141.49 | 4759.0 |
> showing 50 of 2,003 rows — these rows as CSV