PREVIEW / futures_30min / 2010-07-29
file: by_date/futures_30min/2010/2010-07-29.parquet size: 71 KB rows: 2,531
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-07-29 00:00:00 | ES | Futures | 1084.82 | 1085.07 | 1083.84 | 1084.09 | 813.0 |
| 2010-07-29 00:30:00 | ES | Futures | 1084.09 | 1084.09 | 1083.84 | 1084.09 | 323.0 |
| 2010-07-29 01:00:00 | ES | Futures | 1083.84 | 1084.58 | 1082.61 | 1083.35 | 2266.0 |
| 2010-07-29 01:30:00 | ES | Futures | 1083.35 | 1085.56 | 1083.11 | 1085.07 | 2505.0 |
| 2010-07-29 02:00:00 | ES | Futures | 1085.07 | 1087.03 | 1085.07 | 1086.05 | 5868.0 |
| 2010-07-29 02:30:00 | ES | Futures | 1086.05 | 1087.28 | 1085.8 | 1086.05 | 5410.0 |
| 2010-07-29 03:00:00 | ES | Futures | 1086.05 | 1088.01 | 1084.82 | 1085.31 | 14014.0 |
| 2010-07-29 03:30:00 | ES | Futures | 1085.07 | 1086.05 | 1084.82 | 1085.31 | 7473.0 |
| 2010-07-29 04:00:00 | ES | Futures | 1085.07 | 1089.24 | 1085.07 | 1088.01 | 17685.0 |
| 2010-07-29 04:30:00 | ES | Futures | 1087.77 | 1088.99 | 1087.03 | 1087.77 | 10212.0 |
| 2010-07-29 05:00:00 | ES | Futures | 1087.77 | 1088.5 | 1087.03 | 1087.03 | 4714.0 |
| 2010-07-29 05:30:00 | ES | Futures | 1087.28 | 1088.26 | 1087.03 | 1087.28 | 4864.0 |
| 2010-07-29 06:00:00 | ES | Futures | 1087.52 | 1088.26 | 1087.03 | 1087.52 | 4440.0 |
| 2010-07-29 06:30:00 | ES | Futures | 1087.52 | 1088.26 | 1086.79 | 1087.03 | 6739.0 |
| 2010-07-29 07:00:00 | ES | Futures | 1087.03 | 1088.26 | 1087.03 | 1088.26 | 7372.0 |
| 2010-07-29 07:30:00 | ES | Futures | 1088.26 | 1089.24 | 1086.54 | 1087.03 | 17194.0 |
| 2010-07-29 08:00:00 | ES | Futures | 1086.79 | 1088.01 | 1085.56 | 1086.05 | 22458.0 |
| 2010-07-29 08:30:00 | ES | Futures | 1086.3 | 1089.98 | 1085.8 | 1089.73 | 54301.0 |
| 2010-07-29 09:00:00 | ES | Futures | 1089.73 | 1090.22 | 1088.5 | 1089.49 | 20473.0 |
| 2010-07-29 09:30:00 | ES | Futures | 1089.49 | 1092.43 | 1087.52 | 1088.5 | 188450.0 |
| 2010-07-29 10:00:00 | ES | Futures | 1088.5 | 1088.75 | 1083.84 | 1085.07 | 170014.0 |
| 2010-07-29 10:30:00 | ES | Futures | 1084.82 | 1086.3 | 1083.11 | 1085.07 | 140714.0 |
| 2010-07-29 11:00:00 | ES | Futures | 1085.07 | 1085.31 | 1075.25 | 1075.5 | 231089.0 |
| 2010-07-29 11:30:00 | ES | Futures | 1075.5 | 1075.5 | 1071.33 | 1072.31 | 178405.0 |
| 2010-07-29 12:00:00 | ES | Futures | 1072.31 | 1073.78 | 1068.63 | 1073.04 | 143511.0 |
| 2010-07-29 12:30:00 | ES | Futures | 1073.04 | 1074.27 | 1069.85 | 1073.78 | 89344.0 |
| 2010-07-29 13:00:00 | ES | Futures | 1073.78 | 1076.48 | 1073.29 | 1076.23 | 85011.0 |
| 2010-07-29 13:30:00 | ES | Futures | 1076.23 | 1078.93 | 1075.99 | 1076.97 | 89698.0 |
| 2010-07-29 14:00:00 | ES | Futures | 1076.97 | 1079.67 | 1074.52 | 1079.18 | 100885.0 |
| 2010-07-29 14:30:00 | ES | Futures | 1079.18 | 1083.11 | 1077.95 | 1081.88 | 159600.0 |
| 2010-07-29 15:00:00 | ES | Futures | 1081.63 | 1084.09 | 1079.67 | 1082.37 | 114738.0 |
| 2010-07-29 15:30:00 | ES | Futures | 1082.37 | 1083.11 | 1076.97 | 1077.46 | 203300.0 |
| 2010-07-29 16:00:00 | ES | Futures | 1077.46 | 1077.46 | 1075.25 | 1076.48 | 114727.0 |
| 2010-07-29 16:30:00 | ES | Futures | 1075.99 | 1076.73 | 1075.74 | 1076.73 | 3662.0 |
| 2010-07-29 17:00:00 | ES | Futures | 1076.73 | 1076.73 | 1076.23 | 1076.23 | 1951.0 |
| 2010-07-29 18:00:00 | ES | Futures | 1076.48 | 1076.97 | 1076.23 | 1076.73 | 1617.0 |
| 2010-07-29 18:30:00 | ES | Futures | 1076.73 | 1076.73 | 1075.99 | 1076.23 | 906.0 |
| 2010-07-29 19:00:00 | ES | Futures | 1075.99 | 1076.73 | 1075.99 | 1076.48 | 1775.0 |
| 2010-07-29 19:30:00 | ES | Futures | 1076.23 | 1076.48 | 1075.74 | 1075.74 | 1523.0 |
| 2010-07-29 20:00:00 | ES | Futures | 1075.74 | 1076.23 | 1073.78 | 1074.03 | 7222.0 |
| 2010-07-29 20:30:00 | ES | Futures | 1074.03 | 1074.52 | 1072.06 | 1073.29 | 5535.0 |
| 2010-07-29 21:00:00 | ES | Futures | 1073.04 | 1073.29 | 1072.06 | 1073.04 | 2099.0 |
| 2010-07-29 21:30:00 | ES | Futures | 1073.04 | 1073.29 | 1071.82 | 1072.8 | 1814.0 |
| 2010-07-29 22:00:00 | ES | Futures | 1072.8 | 1074.03 | 1072.8 | 1073.54 | 2027.0 |
| 2010-07-29 22:30:00 | ES | Futures | 1073.78 | 1074.52 | 1072.31 | 1072.55 | 2482.0 |
| 2010-07-29 23:00:00 | ES | Futures | 1072.8 | 1072.8 | 1070.1 | 1070.59 | 4653.0 |
| 2010-07-29 23:30:00 | ES | Futures | 1070.84 | 1071.82 | 1070.35 | 1071.82 | 1824.0 |
| 2010-07-29 00:00:00 | NQ | Futures | 2147.24 | 2147.24 | 2145.52 | 2146.09 | 67.0 |
| 2010-07-29 00:30:00 | NQ | Futures | 2145.81 | 2146.09 | 2144.37 | 2144.95 | 51.0 |
| 2010-07-29 01:00:00 | NQ | Futures | 2144.95 | 2146.09 | 2142.94 | 2144.37 | 137.0 |
> showing 50 of 2,531 rows — these rows as CSV