PREVIEW / futures_30min / 2010-06-15
file: by_date/futures_30min/2010/2010-06-15.parquet size: 72 KB rows: 2,538
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-06-15 00:00:00 | ES | Futures | 1069.36 | 1070.1 | 1068.87 | 1069.36 | 2061.0 |
| 2010-06-15 00:30:00 | ES | Futures | 1069.61 | 1069.61 | 1067.4 | 1067.89 | 1810.0 |
| 2010-06-15 01:00:00 | ES | Futures | 1067.65 | 1068.87 | 1067.4 | 1068.63 | 916.0 |
| 2010-06-15 01:30:00 | ES | Futures | 1068.63 | 1069.61 | 1068.63 | 1068.87 | 1420.0 |
| 2010-06-15 02:00:00 | ES | Futures | 1068.87 | 1069.36 | 1065.44 | 1065.93 | 7237.0 |
| 2010-06-15 02:30:00 | ES | Futures | 1065.68 | 1066.17 | 1064.21 | 1064.46 | 6884.0 |
| 2010-06-15 03:00:00 | ES | Futures | 1064.21 | 1068.38 | 1064.21 | 1067.65 | 22474.0 |
| 2010-06-15 03:30:00 | ES | Futures | 1067.4 | 1068.14 | 1065.19 | 1068.14 | 19499.0 |
| 2010-06-15 04:00:00 | ES | Futures | 1068.14 | 1069.36 | 1067.65 | 1068.38 | 12249.0 |
| 2010-06-15 04:30:00 | ES | Futures | 1068.38 | 1071.82 | 1068.14 | 1071.08 | 17183.0 |
| 2010-06-15 05:00:00 | ES | Futures | 1071.08 | 1072.06 | 1068.14 | 1070.84 | 21354.0 |
| 2010-06-15 05:30:00 | ES | Futures | 1071.08 | 1074.76 | 1070.59 | 1074.03 | 23458.0 |
| 2010-06-15 06:00:00 | ES | Futures | 1074.03 | 1074.76 | 1073.04 | 1073.54 | 11484.0 |
| 2010-06-15 06:30:00 | ES | Futures | 1073.54 | 1074.03 | 1072.8 | 1073.04 | 10424.0 |
| 2010-06-15 07:00:00 | ES | Futures | 1073.29 | 1074.27 | 1070.84 | 1071.57 | 33089.0 |
| 2010-06-15 07:30:00 | ES | Futures | 1071.82 | 1072.8 | 1071.08 | 1072.8 | 13977.0 |
| 2010-06-15 08:00:00 | ES | Futures | 1072.55 | 1072.55 | 1070.1 | 1071.82 | 39777.0 |
| 2010-06-15 08:30:00 | ES | Futures | 1071.82 | 1074.52 | 1071.57 | 1072.55 | 45675.0 |
| 2010-06-15 09:00:00 | ES | Futures | 1072.55 | 1074.27 | 1072.06 | 1072.8 | 38461.0 |
| 2010-06-15 09:30:00 | ES | Futures | 1072.8 | 1076.73 | 1071.08 | 1075.25 | 248985.0 |
| 2010-06-15 10:00:00 | ES | Futures | 1075.25 | 1076.73 | 1072.31 | 1075.5 | 202070.0 |
| 2010-06-15 10:30:00 | ES | Futures | 1075.74 | 1078.2 | 1074.76 | 1077.95 | 168499.0 |
| 2010-06-15 11:00:00 | ES | Futures | 1077.71 | 1078.69 | 1076.23 | 1077.22 | 112188.0 |
| 2010-06-15 11:30:00 | ES | Futures | 1077.22 | 1079.92 | 1075.74 | 1078.93 | 103291.0 |
| 2010-06-15 12:00:00 | ES | Futures | 1078.93 | 1080.9 | 1078.69 | 1079.42 | 77377.0 |
| 2010-06-15 12:30:00 | ES | Futures | 1079.42 | 1080.65 | 1077.71 | 1080.65 | 67249.0 |
| 2010-06-15 13:00:00 | ES | Futures | 1080.65 | 1083.6 | 1078.44 | 1081.88 | 120929.0 |
| 2010-06-15 13:30:00 | ES | Futures | 1082.12 | 1083.6 | 1081.63 | 1083.35 | 58941.0 |
| 2010-06-15 14:00:00 | ES | Futures | 1083.35 | 1087.28 | 1083.11 | 1086.05 | 136532.0 |
| 2010-06-15 14:30:00 | ES | Futures | 1086.3 | 1086.54 | 1084.58 | 1085.07 | 86115.0 |
| 2010-06-15 15:00:00 | ES | Futures | 1085.07 | 1088.5 | 1084.09 | 1088.01 | 106938.0 |
| 2010-06-15 15:30:00 | ES | Futures | 1088.26 | 1090.96 | 1087.03 | 1089.73 | 257208.0 |
| 2010-06-15 16:00:00 | ES | Futures | 1089.73 | 1089.98 | 1088.26 | 1088.75 | 124179.0 |
| 2010-06-15 16:30:00 | ES | Futures | 1088.75 | 1088.75 | 1087.28 | 1088.26 | 6081.0 |
| 2010-06-15 17:00:00 | ES | Futures | 1088.26 | 1088.26 | 1087.28 | 1087.52 | 3061.0 |
| 2010-06-15 18:00:00 | ES | Futures | 1087.52 | 1087.52 | 1086.3 | 1086.54 | 3541.0 |
| 2010-06-15 18:30:00 | ES | Futures | 1086.79 | 1087.52 | 1086.79 | 1087.03 | 1165.0 |
| 2010-06-15 19:00:00 | ES | Futures | 1086.79 | 1087.03 | 1086.05 | 1086.3 | 2167.0 |
| 2010-06-15 19:30:00 | ES | Futures | 1086.54 | 1087.28 | 1086.05 | 1086.79 | 1765.0 |
| 2010-06-15 20:00:00 | ES | Futures | 1086.79 | 1086.79 | 1085.8 | 1086.05 | 1652.0 |
| 2010-06-15 20:30:00 | ES | Futures | 1086.3 | 1087.03 | 1086.05 | 1086.3 | 1518.0 |
| 2010-06-15 21:00:00 | ES | Futures | 1086.3 | 1087.28 | 1086.05 | 1086.79 | 1526.0 |
| 2010-06-15 21:30:00 | ES | Futures | 1086.79 | 1087.03 | 1085.8 | 1086.05 | 1441.0 |
| 2010-06-15 22:00:00 | ES | Futures | 1086.05 | 1086.54 | 1085.8 | 1086.3 | 910.0 |
| 2010-06-15 22:30:00 | ES | Futures | 1086.3 | 1086.54 | 1086.05 | 1086.05 | 1269.0 |
| 2010-06-15 23:00:00 | ES | Futures | 1086.05 | 1086.54 | 1086.05 | 1086.3 | 557.0 |
| 2010-06-15 23:30:00 | ES | Futures | 1086.3 | 1087.77 | 1086.3 | 1087.28 | 1653.0 |
| 2010-06-15 00:00:00 | NQ | Futures | 2123.45 | 2124.89 | 2122.88 | 2124.6 | 39.0 |
| 2010-06-15 00:30:00 | NQ | Futures | 2124.03 | 2124.03 | 2120.88 | 2121.45 | 106.0 |
| 2010-06-15 01:00:00 | NQ | Futures | 2121.45 | 2122.31 | 2120.88 | 2122.02 | 46.0 |
> showing 50 of 2,538 rows — these rows as CSV