PREVIEW / futures_30min / 2010-05-07
file: by_date/futures_30min/2010/2010-05-07.parquet size: 69 KB rows: 2,158
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-07 00:00:00 | ES | Futures | 1103.83 | 1104.56 | 1102.61 | 1104.07 | 5251.0 |
| 2010-05-07 00:30:00 | ES | Futures | 1104.32 | 1105.3 | 1100.41 | 1101.14 | 4587.0 |
| 2010-05-07 01:00:00 | ES | Futures | 1101.38 | 1102.36 | 1096.74 | 1097.23 | 6695.0 |
| 2010-05-07 01:30:00 | ES | Futures | 1097.23 | 1098.7 | 1091.36 | 1094.3 | 11530.0 |
| 2010-05-07 02:00:00 | ES | Futures | 1094.3 | 1101.14 | 1091.61 | 1097.72 | 21279.0 |
| 2010-05-07 02:30:00 | ES | Futures | 1097.96 | 1099.67 | 1091.61 | 1094.79 | 22706.0 |
| 2010-05-07 03:00:00 | ES | Futures | 1094.54 | 1103.83 | 1094.3 | 1098.45 | 46112.0 |
| 2010-05-07 03:30:00 | ES | Futures | 1098.45 | 1103.58 | 1097.72 | 1100.16 | 37867.0 |
| 2010-05-07 04:00:00 | ES | Futures | 1100.41 | 1107.25 | 1098.21 | 1106.27 | 40867.0 |
| 2010-05-07 04:30:00 | ES | Futures | 1106.52 | 1107.74 | 1100.16 | 1100.65 | 26716.0 |
| 2010-05-07 05:00:00 | ES | Futures | 1100.9 | 1102.12 | 1097.47 | 1099.92 | 22416.0 |
| 2010-05-07 05:30:00 | ES | Futures | 1100.16 | 1104.81 | 1099.43 | 1101.87 | 21404.0 |
| 2010-05-07 06:00:00 | ES | Futures | 1101.87 | 1106.76 | 1101.63 | 1104.07 | 25465.0 |
| 2010-05-07 06:30:00 | ES | Futures | 1104.07 | 1108.47 | 1103.58 | 1107.98 | 25671.0 |
| 2010-05-07 07:00:00 | ES | Futures | 1108.23 | 1108.72 | 1103.83 | 1105.05 | 30252.0 |
| 2010-05-07 07:30:00 | ES | Futures | 1104.81 | 1106.76 | 1100.41 | 1100.9 | 36842.0 |
| 2010-05-07 08:00:00 | ES | Futures | 1100.9 | 1106.76 | 1098.21 | 1105.54 | 78137.0 |
| 2010-05-07 08:30:00 | ES | Futures | 1105.54 | 1110.18 | 1099.67 | 1103.58 | 165713.0 |
| 2010-05-07 09:00:00 | ES | Futures | 1103.83 | 1104.81 | 1096.5 | 1096.74 | 85039.0 |
| 2010-05-07 09:30:00 | ES | Futures | 1096.5 | 1107.5 | 1091.61 | 1095.52 | 474636.0 |
| 2010-05-07 10:00:00 | ES | Futures | 1095.27 | 1096.74 | 1066.43 | 1073.76 | 587080.0 |
| 2010-05-07 10:30:00 | ES | Futures | 1073.76 | 1084.52 | 1073.52 | 1080.12 | 503137.0 |
| 2010-05-07 11:00:00 | ES | Futures | 1080.12 | 1100.9 | 1077.92 | 1087.7 | 478024.0 |
| 2010-05-07 11:30:00 | ES | Futures | 1087.7 | 1097.96 | 1081.1 | 1094.3 | 329407.0 |
| 2010-05-07 12:00:00 | ES | Futures | 1094.3 | 1102.61 | 1090.39 | 1092.59 | 264823.0 |
| 2010-05-07 12:30:00 | ES | Futures | 1092.34 | 1095.76 | 1087.7 | 1089.65 | 174876.0 |
| 2010-05-07 13:00:00 | ES | Futures | 1089.9 | 1092.59 | 1083.3 | 1085.99 | 177357.0 |
| 2010-05-07 13:30:00 | ES | Futures | 1085.99 | 1094.79 | 1085.5 | 1090.14 | 130993.0 |
| 2010-05-07 14:00:00 | ES | Futures | 1090.14 | 1092.1 | 1082.32 | 1082.56 | 169780.0 |
| 2010-05-07 14:30:00 | ES | Futures | 1082.32 | 1089.9 | 1081.59 | 1085.25 | 152908.0 |
| 2010-05-07 15:00:00 | ES | Futures | 1085.25 | 1085.99 | 1077.19 | 1081.83 | 249201.0 |
| 2010-05-07 15:30:00 | ES | Futures | 1081.59 | 1085.99 | 1076.21 | 1083.54 | 333971.0 |
| 2010-05-07 16:00:00 | ES | Futures | 1083.3 | 1083.3 | 1079.14 | 1082.81 | 123064.0 |
| 2010-05-07 00:00:00 | NQ | Futures | 2173.28 | 2174.71 | 2170.99 | 2174.43 | 270.0 |
| 2010-05-07 00:30:00 | NQ | Futures | 2174.14 | 2175.86 | 2166.98 | 2168.13 | 393.0 |
| 2010-05-07 01:00:00 | NQ | Futures | 2168.41 | 2171.28 | 2158.96 | 2159.82 | 585.0 |
| 2010-05-07 01:30:00 | NQ | Futures | 2159.54 | 2162.97 | 2146.94 | 2152.38 | 1283.0 |
| 2010-05-07 02:00:00 | NQ | Futures | 2152.38 | 2165.55 | 2148.65 | 2158.68 | 2266.0 |
| 2010-05-07 02:30:00 | NQ | Futures | 2158.68 | 2162.69 | 2149.23 | 2152.66 | 2237.0 |
| 2010-05-07 03:00:00 | NQ | Futures | 2152.38 | 2171.28 | 2152.38 | 2161.54 | 3303.0 |
| 2010-05-07 03:30:00 | NQ | Futures | 2161.25 | 2171.85 | 2160.68 | 2165.84 | 2168.0 |
| 2010-05-07 04:00:00 | NQ | Futures | 2165.55 | 2181.01 | 2162.4 | 2177.0 | 2965.0 |
| 2010-05-07 04:30:00 | NQ | Futures | 2177.58 | 2179.58 | 2166.12 | 2167.27 | 2246.0 |
| 2010-05-07 05:00:00 | NQ | Futures | 2167.27 | 2169.27 | 2159.54 | 2165.26 | 2329.0 |
| 2010-05-07 05:30:00 | NQ | Futures | 2165.55 | 2172.71 | 2164.12 | 2169.56 | 1946.0 |
| 2010-05-07 06:00:00 | NQ | Futures | 2169.56 | 2180.15 | 2169.56 | 2176.15 | 2514.0 |
| 2010-05-07 06:30:00 | NQ | Futures | 2176.15 | 2185.31 | 2175.86 | 2183.59 | 1757.0 |
| 2010-05-07 07:00:00 | NQ | Futures | 2183.88 | 2184.16 | 2175.86 | 2178.44 | 2698.0 |
| 2010-05-07 07:30:00 | NQ | Futures | 2178.15 | 2181.3 | 2168.7 | 2168.7 | 3171.0 |
| 2010-05-07 08:00:00 | NQ | Futures | 2168.7 | 2178.44 | 2163.83 | 2175.57 | 9398.0 |
> showing 50 of 2,158 rows — these rows as CSV