PREVIEW / futures_30min / 2010-08-10
file: by_date/futures_30min/2010/2010-08-10.parquet size: 71 KB rows: 2,522
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-10 00:00:00 | ES | Futures | 1100.04 | 1100.28 | 1099.55 | 1099.55 | 1121.0 |
| 2010-08-10 00:30:00 | ES | Futures | 1099.55 | 1100.04 | 1099.3 | 1099.79 | 2742.0 |
| 2010-08-10 01:00:00 | ES | Futures | 1100.04 | 1100.28 | 1099.55 | 1100.04 | 1093.0 |
| 2010-08-10 01:30:00 | ES | Futures | 1100.04 | 1101.02 | 1099.79 | 1100.53 | 2030.0 |
| 2010-08-10 02:00:00 | ES | Futures | 1100.77 | 1100.77 | 1099.3 | 1099.79 | 5160.0 |
| 2010-08-10 02:30:00 | ES | Futures | 1099.79 | 1100.28 | 1099.3 | 1099.55 | 2911.0 |
| 2010-08-10 03:00:00 | ES | Futures | 1099.55 | 1100.53 | 1098.56 | 1098.56 | 13633.0 |
| 2010-08-10 03:30:00 | ES | Futures | 1098.56 | 1098.81 | 1095.86 | 1096.36 | 22559.0 |
| 2010-08-10 04:00:00 | ES | Futures | 1096.36 | 1098.81 | 1095.86 | 1098.56 | 16790.0 |
| 2010-08-10 04:30:00 | ES | Futures | 1098.81 | 1099.05 | 1097.58 | 1097.58 | 9901.0 |
| 2010-08-10 05:00:00 | ES | Futures | 1097.58 | 1097.83 | 1096.36 | 1096.85 | 8490.0 |
| 2010-08-10 05:30:00 | ES | Futures | 1096.6 | 1098.07 | 1096.11 | 1097.83 | 6722.0 |
| 2010-08-10 06:00:00 | ES | Futures | 1097.83 | 1099.05 | 1097.09 | 1098.07 | 8210.0 |
| 2010-08-10 06:30:00 | ES | Futures | 1098.07 | 1099.05 | 1097.58 | 1098.32 | 8304.0 |
| 2010-08-10 07:00:00 | ES | Futures | 1098.56 | 1099.3 | 1097.34 | 1097.83 | 10351.0 |
| 2010-08-10 07:30:00 | ES | Futures | 1097.83 | 1098.07 | 1096.6 | 1096.85 | 20231.0 |
| 2010-08-10 08:00:00 | ES | Futures | 1096.85 | 1097.09 | 1092.67 | 1094.15 | 48842.0 |
| 2010-08-10 08:30:00 | ES | Futures | 1094.15 | 1095.13 | 1092.18 | 1094.39 | 42724.0 |
| 2010-08-10 09:00:00 | ES | Futures | 1094.15 | 1095.62 | 1093.41 | 1094.39 | 33769.0 |
| 2010-08-10 09:30:00 | ES | Futures | 1094.64 | 1096.36 | 1087.77 | 1090.71 | 248947.0 |
| 2010-08-10 10:00:00 | ES | Futures | 1090.96 | 1093.41 | 1089.49 | 1092.67 | 110440.0 |
| 2010-08-10 10:30:00 | ES | Futures | 1092.43 | 1092.67 | 1089.73 | 1090.96 | 90513.0 |
| 2010-08-10 11:00:00 | ES | Futures | 1090.96 | 1093.41 | 1090.71 | 1093.17 | 58691.0 |
| 2010-08-10 11:30:00 | ES | Futures | 1093.17 | 1094.39 | 1092.67 | 1093.9 | 49080.0 |
| 2010-08-10 12:00:00 | ES | Futures | 1093.66 | 1094.15 | 1092.67 | 1093.66 | 25833.0 |
| 2010-08-10 12:30:00 | ES | Futures | 1093.9 | 1093.9 | 1092.43 | 1092.92 | 33058.0 |
| 2010-08-10 13:00:00 | ES | Futures | 1092.67 | 1093.17 | 1089.98 | 1090.22 | 43663.0 |
| 2010-08-10 13:30:00 | ES | Futures | 1090.47 | 1092.18 | 1089.73 | 1091.45 | 45665.0 |
| 2010-08-10 14:00:00 | ES | Futures | 1091.45 | 1101.26 | 1091.45 | 1098.07 | 297173.0 |
| 2010-08-10 14:30:00 | ES | Futures | 1098.07 | 1103.72 | 1098.07 | 1099.79 | 255227.0 |
| 2010-08-10 15:00:00 | ES | Futures | 1100.04 | 1102.49 | 1095.62 | 1099.05 | 182707.0 |
| 2010-08-10 15:30:00 | ES | Futures | 1099.3 | 1101.75 | 1096.85 | 1098.32 | 194479.0 |
| 2010-08-10 16:00:00 | ES | Futures | 1098.32 | 1100.28 | 1098.07 | 1098.81 | 100255.0 |
| 2010-08-10 16:30:00 | ES | Futures | 1098.56 | 1099.05 | 1098.32 | 1098.81 | 3368.0 |
| 2010-08-10 17:00:00 | ES | Futures | 1098.56 | 1098.81 | 1098.32 | 1098.56 | 973.0 |
| 2010-08-10 18:00:00 | ES | Futures | 1098.56 | 1098.81 | 1097.83 | 1098.32 | 1900.0 |
| 2010-08-10 18:30:00 | ES | Futures | 1098.32 | 1098.56 | 1098.07 | 1098.32 | 165.0 |
| 2010-08-10 19:00:00 | ES | Futures | 1098.07 | 1098.32 | 1097.83 | 1098.32 | 894.0 |
| 2010-08-10 19:30:00 | ES | Futures | 1098.32 | 1098.32 | 1096.11 | 1096.6 | 4350.0 |
| 2010-08-10 20:00:00 | ES | Futures | 1096.6 | 1096.85 | 1091.69 | 1092.18 | 11915.0 |
| 2010-08-10 20:30:00 | ES | Futures | 1092.18 | 1093.41 | 1089.73 | 1091.94 | 10034.0 |
| 2010-08-10 21:00:00 | ES | Futures | 1091.94 | 1092.92 | 1090.96 | 1090.96 | 4280.0 |
| 2010-08-10 21:30:00 | ES | Futures | 1090.96 | 1092.67 | 1090.71 | 1092.67 | 4759.0 |
| 2010-08-10 22:00:00 | ES | Futures | 1092.43 | 1094.64 | 1092.18 | 1093.66 | 4977.0 |
| 2010-08-10 22:30:00 | ES | Futures | 1093.9 | 1093.9 | 1093.17 | 1093.17 | 2019.0 |
| 2010-08-10 23:00:00 | ES | Futures | 1093.17 | 1093.9 | 1092.43 | 1092.67 | 2479.0 |
| 2010-08-10 23:30:00 | ES | Futures | 1092.67 | 1092.92 | 1091.69 | 1092.43 | 1601.0 |
| 2010-08-10 00:00:00 | NQ | Futures | 2187.93 | 2188.22 | 2186.21 | 2186.5 | 69.0 |
| 2010-08-10 00:30:00 | NQ | Futures | 2186.5 | 2186.5 | 2185.64 | 2186.21 | 169.0 |
| 2010-08-10 01:00:00 | NQ | Futures | 2186.21 | 2187.07 | 2186.21 | 2186.5 | 89.0 |
> showing 50 of 2,522 rows — these rows as CSV