PREVIEW / futures_30min / 2010-08-11
file: by_date/futures_30min/2010/2010-08-11.parquet size: 74 KB rows: 2,558
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-11 00:00:00 | ES | Futures | 1092.43 | 1092.67 | 1091.69 | 1092.18 | 2349.0 |
| 2010-08-11 00:30:00 | ES | Futures | 1092.18 | 1092.67 | 1091.45 | 1091.45 | 1480.0 |
| 2010-08-11 01:00:00 | ES | Futures | 1091.69 | 1091.69 | 1090.47 | 1090.71 | 2926.0 |
| 2010-08-11 01:30:00 | ES | Futures | 1090.71 | 1090.96 | 1089.73 | 1090.47 | 6782.0 |
| 2010-08-11 02:00:00 | ES | Futures | 1090.71 | 1090.71 | 1086.79 | 1088.75 | 14841.0 |
| 2010-08-11 02:30:00 | ES | Futures | 1088.5 | 1089.49 | 1088.01 | 1088.75 | 8415.0 |
| 2010-08-11 03:00:00 | ES | Futures | 1088.75 | 1088.99 | 1085.8 | 1086.79 | 22257.0 |
| 2010-08-11 03:30:00 | ES | Futures | 1086.79 | 1088.5 | 1085.8 | 1088.26 | 20521.0 |
| 2010-08-11 04:00:00 | ES | Futures | 1088.5 | 1088.75 | 1086.05 | 1086.3 | 8066.0 |
| 2010-08-11 04:30:00 | ES | Futures | 1086.3 | 1088.75 | 1086.05 | 1087.77 | 10997.0 |
| 2010-08-11 05:00:00 | ES | Futures | 1087.77 | 1088.75 | 1084.82 | 1085.07 | 11900.0 |
| 2010-08-11 05:30:00 | ES | Futures | 1085.07 | 1085.56 | 1083.35 | 1083.84 | 19888.0 |
| 2010-08-11 06:00:00 | ES | Futures | 1083.84 | 1083.84 | 1080.9 | 1082.12 | 24452.0 |
| 2010-08-11 06:30:00 | ES | Futures | 1081.88 | 1084.09 | 1081.88 | 1083.84 | 16849.0 |
| 2010-08-11 07:00:00 | ES | Futures | 1083.6 | 1084.58 | 1082.86 | 1084.09 | 13480.0 |
| 2010-08-11 07:30:00 | ES | Futures | 1083.84 | 1084.09 | 1082.37 | 1083.6 | 22586.0 |
| 2010-08-11 08:00:00 | ES | Futures | 1083.35 | 1084.33 | 1082.86 | 1083.6 | 23919.0 |
| 2010-08-11 08:30:00 | ES | Futures | 1083.84 | 1083.84 | 1080.9 | 1081.88 | 47535.0 |
| 2010-08-11 09:00:00 | ES | Futures | 1081.88 | 1082.12 | 1078.93 | 1080.9 | 69337.0 |
| 2010-08-11 09:30:00 | ES | Futures | 1080.9 | 1081.14 | 1073.54 | 1075.99 | 344685.0 |
| 2010-08-11 10:00:00 | ES | Futures | 1075.74 | 1077.46 | 1073.78 | 1075.74 | 190867.0 |
| 2010-08-11 10:30:00 | ES | Futures | 1075.5 | 1075.74 | 1071.82 | 1071.82 | 204310.0 |
| 2010-08-11 11:00:00 | ES | Futures | 1071.82 | 1072.55 | 1068.14 | 1070.1 | 254871.0 |
| 2010-08-11 11:30:00 | ES | Futures | 1070.35 | 1071.57 | 1069.85 | 1070.59 | 122542.0 |
| 2010-08-11 12:00:00 | ES | Futures | 1070.59 | 1070.84 | 1069.12 | 1069.61 | 72447.0 |
| 2010-08-11 12:30:00 | ES | Futures | 1069.61 | 1070.35 | 1066.66 | 1067.16 | 98440.0 |
| 2010-08-11 13:00:00 | ES | Futures | 1067.16 | 1070.35 | 1067.16 | 1069.85 | 78052.0 |
| 2010-08-11 13:30:00 | ES | Futures | 1069.85 | 1070.59 | 1067.89 | 1068.63 | 65397.0 |
| 2010-08-11 14:00:00 | ES | Futures | 1068.38 | 1071.57 | 1068.38 | 1070.84 | 83546.0 |
| 2010-08-11 14:30:00 | ES | Futures | 1070.84 | 1071.08 | 1065.68 | 1067.4 | 141136.0 |
| 2010-08-11 15:00:00 | ES | Futures | 1067.16 | 1068.63 | 1066.17 | 1067.65 | 126248.0 |
| 2010-08-11 15:30:00 | ES | Futures | 1067.65 | 1070.35 | 1065.93 | 1067.4 | 288127.0 |
| 2010-08-11 16:00:00 | ES | Futures | 1067.65 | 1068.14 | 1064.46 | 1064.7 | 162119.0 |
| 2010-08-11 16:30:00 | ES | Futures | 1064.95 | 1065.19 | 1061.27 | 1061.51 | 16207.0 |
| 2010-08-11 17:00:00 | ES | Futures | 1061.51 | 1061.76 | 1053.41 | 1055.87 | 27741.0 |
| 2010-08-11 18:00:00 | ES | Futures | 1056.85 | 1057.09 | 1056.11 | 1056.6 | 5047.0 |
| 2010-08-11 18:30:00 | ES | Futures | 1056.85 | 1058.08 | 1056.36 | 1057.83 | 2692.0 |
| 2010-08-11 19:00:00 | ES | Futures | 1057.59 | 1057.83 | 1057.09 | 1057.59 | 2450.0 |
| 2010-08-11 19:30:00 | ES | Futures | 1057.59 | 1059.3 | 1057.34 | 1059.06 | 7359.0 |
| 2010-08-11 20:00:00 | ES | Futures | 1058.81 | 1061.76 | 1058.81 | 1061.27 | 10255.0 |
| 2010-08-11 20:30:00 | ES | Futures | 1061.51 | 1062.25 | 1060.53 | 1061.76 | 4932.0 |
| 2010-08-11 21:00:00 | ES | Futures | 1061.76 | 1062.74 | 1060.78 | 1060.78 | 4179.0 |
| 2010-08-11 21:30:00 | ES | Futures | 1061.02 | 1061.02 | 1058.81 | 1060.53 | 6279.0 |
| 2010-08-11 22:00:00 | ES | Futures | 1060.78 | 1062.98 | 1060.78 | 1062.0 | 3941.0 |
| 2010-08-11 22:30:00 | ES | Futures | 1062.25 | 1062.25 | 1060.04 | 1060.04 | 3441.0 |
| 2010-08-11 23:00:00 | ES | Futures | 1060.28 | 1061.02 | 1058.32 | 1058.32 | 2998.0 |
| 2010-08-11 23:30:00 | ES | Futures | 1058.57 | 1061.02 | 1058.08 | 1060.53 | 3486.0 |
| 2010-08-11 00:00:00 | NQ | Futures | 2161.85 | 2161.85 | 2159.85 | 2160.13 | 185.0 |
| 2010-08-11 00:30:00 | NQ | Futures | 2159.85 | 2161.28 | 2159.28 | 2159.28 | 149.0 |
| 2010-08-11 01:00:00 | NQ | Futures | 2159.56 | 2159.56 | 2158.13 | 2158.42 | 119.0 |
> showing 50 of 2,558 rows — these rows as CSV