PREVIEW / futures_30min / 2010-08-19
file: by_date/futures_30min/2010/2010-08-19.parquet size: 71 KB rows: 2,476
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-08-19 00:00:00 | ES | Futures | 1067.65 | 1069.61 | 1067.16 | 1069.36 | 2398.0 |
| 2010-08-19 00:30:00 | ES | Futures | 1069.36 | 1069.61 | 1068.63 | 1069.36 | 1545.0 |
| 2010-08-19 01:00:00 | ES | Futures | 1069.12 | 1069.61 | 1068.14 | 1069.12 | 2713.0 |
| 2010-08-19 01:30:00 | ES | Futures | 1069.36 | 1070.84 | 1069.12 | 1070.84 | 4077.0 |
| 2010-08-19 02:00:00 | ES | Futures | 1070.59 | 1071.82 | 1070.59 | 1071.33 | 6006.0 |
| 2010-08-19 02:30:00 | ES | Futures | 1071.33 | 1071.82 | 1070.59 | 1071.33 | 5820.0 |
| 2010-08-19 03:00:00 | ES | Futures | 1071.08 | 1072.8 | 1068.14 | 1068.63 | 18625.0 |
| 2010-08-19 03:30:00 | ES | Futures | 1068.63 | 1068.87 | 1064.95 | 1066.91 | 29121.0 |
| 2010-08-19 04:00:00 | ES | Futures | 1066.91 | 1067.4 | 1065.19 | 1066.66 | 16067.0 |
| 2010-08-19 04:30:00 | ES | Futures | 1066.66 | 1068.38 | 1066.66 | 1067.89 | 8551.0 |
| 2010-08-19 05:00:00 | ES | Futures | 1067.89 | 1068.87 | 1067.4 | 1067.89 | 5748.0 |
| 2010-08-19 05:30:00 | ES | Futures | 1067.89 | 1068.87 | 1067.4 | 1068.63 | 4740.0 |
| 2010-08-19 06:00:00 | ES | Futures | 1068.63 | 1073.29 | 1068.63 | 1072.31 | 23579.0 |
| 2010-08-19 06:30:00 | ES | Futures | 1072.31 | 1073.04 | 1071.33 | 1072.06 | 7618.0 |
| 2010-08-19 07:00:00 | ES | Futures | 1072.06 | 1072.55 | 1071.08 | 1071.33 | 7583.0 |
| 2010-08-19 07:30:00 | ES | Futures | 1071.33 | 1072.31 | 1070.59 | 1072.06 | 11960.0 |
| 2010-08-19 08:00:00 | ES | Futures | 1072.06 | 1074.76 | 1071.82 | 1072.8 | 30803.0 |
| 2010-08-19 08:30:00 | ES | Futures | 1073.29 | 1074.03 | 1063.23 | 1066.42 | 143921.0 |
| 2010-08-19 09:00:00 | ES | Futures | 1066.42 | 1067.89 | 1065.93 | 1066.42 | 32865.0 |
| 2010-08-19 09:30:00 | ES | Futures | 1066.42 | 1069.36 | 1062.98 | 1064.21 | 232323.0 |
| 2010-08-19 10:00:00 | ES | Futures | 1064.46 | 1064.46 | 1055.13 | 1057.59 | 378564.0 |
| 2010-08-19 10:30:00 | ES | Futures | 1057.34 | 1058.81 | 1053.66 | 1056.6 | 188597.0 |
| 2010-08-19 11:00:00 | ES | Futures | 1056.6 | 1056.85 | 1053.41 | 1055.38 | 123963.0 |
| 2010-08-19 11:30:00 | ES | Futures | 1055.38 | 1055.62 | 1048.75 | 1050.72 | 219978.0 |
| 2010-08-19 12:00:00 | ES | Futures | 1050.96 | 1053.17 | 1049.73 | 1052.68 | 106415.0 |
| 2010-08-19 12:30:00 | ES | Futures | 1052.68 | 1053.66 | 1050.96 | 1052.92 | 62095.0 |
| 2010-08-19 13:00:00 | ES | Futures | 1052.92 | 1054.15 | 1052.19 | 1052.92 | 51155.0 |
| 2010-08-19 13:30:00 | ES | Futures | 1052.92 | 1053.17 | 1050.47 | 1050.72 | 53466.0 |
| 2010-08-19 14:00:00 | ES | Futures | 1050.72 | 1054.15 | 1049.49 | 1052.92 | 78283.0 |
| 2010-08-19 14:30:00 | ES | Futures | 1053.17 | 1054.89 | 1051.7 | 1053.17 | 96963.0 |
| 2010-08-19 15:00:00 | ES | Futures | 1052.92 | 1058.08 | 1051.94 | 1055.62 | 135524.0 |
| 2010-08-19 15:30:00 | ES | Futures | 1055.38 | 1056.85 | 1053.17 | 1053.91 | 191778.0 |
| 2010-08-19 16:00:00 | ES | Futures | 1053.91 | 1053.91 | 1050.72 | 1050.96 | 99130.0 |
| 2010-08-19 16:30:00 | ES | Futures | 1050.96 | 1052.68 | 1050.96 | 1052.43 | 5257.0 |
| 2010-08-19 17:00:00 | ES | Futures | 1052.43 | 1052.92 | 1051.7 | 1052.19 | 1322.0 |
| 2010-08-19 18:00:00 | ES | Futures | 1052.43 | 1053.17 | 1052.19 | 1052.68 | 1716.0 |
| 2010-08-19 18:30:00 | ES | Futures | 1052.68 | 1052.92 | 1051.94 | 1052.43 | 668.0 |
| 2010-08-19 19:00:00 | ES | Futures | 1052.43 | 1053.41 | 1052.43 | 1052.92 | 915.0 |
| 2010-08-19 19:30:00 | ES | Futures | 1053.17 | 1053.41 | 1052.19 | 1052.92 | 1323.0 |
| 2010-08-19 20:00:00 | ES | Futures | 1053.17 | 1053.17 | 1051.94 | 1052.68 | 2860.0 |
| 2010-08-19 20:30:00 | ES | Futures | 1052.92 | 1053.91 | 1052.68 | 1052.92 | 2715.0 |
| 2010-08-19 21:00:00 | ES | Futures | 1052.92 | 1054.64 | 1052.43 | 1054.15 | 4039.0 |
| 2010-08-19 21:30:00 | ES | Futures | 1053.91 | 1054.64 | 1052.68 | 1052.92 | 2204.0 |
| 2010-08-19 22:00:00 | ES | Futures | 1052.68 | 1053.66 | 1052.43 | 1052.68 | 1358.0 |
| 2010-08-19 22:30:00 | ES | Futures | 1052.68 | 1052.68 | 1051.21 | 1052.19 | 2657.0 |
| 2010-08-19 23:00:00 | ES | Futures | 1051.94 | 1052.43 | 1051.21 | 1051.45 | 860.0 |
| 2010-08-19 23:30:00 | ES | Futures | 1051.45 | 1051.94 | 1050.96 | 1051.45 | 1604.0 |
| 2010-08-19 00:00:00 | NQ | Futures | 2107.41 | 2110.85 | 2107.12 | 2110.27 | 124.0 |
| 2010-08-19 00:30:00 | NQ | Futures | 2110.56 | 2111.13 | 2109.7 | 2110.27 | 88.0 |
| 2010-08-19 01:00:00 | NQ | Futures | 2110.27 | 2111.42 | 2108.84 | 2110.85 | 146.0 |
> showing 50 of 2,476 rows — these rows as CSV