PREVIEW / futures_30min / 2010-01-25
file: by_date/futures_30min/2010/2010-01-25.parquet size: 69 KB rows: 2,543
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-01-25 00:00:00 | ES | Futures | 1067.42 | 1067.91 | 1066.93 | 1066.93 | 2354.0 |
| 2010-01-25 00:30:00 | ES | Futures | 1067.18 | 1067.18 | 1066.69 | 1066.93 | 1187.0 |
| 2010-01-25 01:00:00 | ES | Futures | 1066.93 | 1067.66 | 1066.93 | 1067.18 | 1422.0 |
| 2010-01-25 01:30:00 | ES | Futures | 1067.18 | 1067.42 | 1066.69 | 1066.93 | 1173.0 |
| 2010-01-25 02:00:00 | ES | Futures | 1066.69 | 1067.91 | 1066.45 | 1067.18 | 6212.0 |
| 2010-01-25 02:30:00 | ES | Futures | 1067.18 | 1069.37 | 1066.93 | 1069.37 | 13168.0 |
| 2010-01-25 03:00:00 | ES | Futures | 1069.37 | 1070.1 | 1068.64 | 1069.85 | 27021.0 |
| 2010-01-25 03:30:00 | ES | Futures | 1069.85 | 1071.8 | 1068.88 | 1071.07 | 29820.0 |
| 2010-01-25 04:00:00 | ES | Futures | 1070.83 | 1071.55 | 1069.85 | 1070.83 | 14623.0 |
| 2010-01-25 04:30:00 | ES | Futures | 1070.58 | 1071.55 | 1070.34 | 1070.83 | 8250.0 |
| 2010-01-25 05:00:00 | ES | Futures | 1070.58 | 1072.53 | 1070.34 | 1071.31 | 17683.0 |
| 2010-01-25 05:30:00 | ES | Futures | 1071.55 | 1073.26 | 1071.55 | 1072.04 | 16904.0 |
| 2010-01-25 06:00:00 | ES | Futures | 1072.04 | 1073.26 | 1071.31 | 1071.8 | 11067.0 |
| 2010-01-25 06:30:00 | ES | Futures | 1071.8 | 1072.53 | 1070.1 | 1070.83 | 10383.0 |
| 2010-01-25 07:00:00 | ES | Futures | 1070.83 | 1071.31 | 1069.12 | 1071.07 | 12690.0 |
| 2010-01-25 07:30:00 | ES | Futures | 1070.83 | 1071.07 | 1067.18 | 1068.39 | 34970.0 |
| 2010-01-25 08:00:00 | ES | Futures | 1068.15 | 1069.85 | 1068.15 | 1069.12 | 23976.0 |
| 2010-01-25 08:30:00 | ES | Futures | 1068.88 | 1069.12 | 1067.42 | 1068.39 | 25891.0 |
| 2010-01-25 09:00:00 | ES | Futures | 1068.15 | 1070.34 | 1067.66 | 1067.91 | 33745.0 |
| 2010-01-25 09:30:00 | ES | Futures | 1068.15 | 1069.37 | 1066.2 | 1067.42 | 217502.0 |
| 2010-01-25 10:00:00 | ES | Futures | 1067.42 | 1069.37 | 1062.31 | 1066.69 | 292114.0 |
| 2010-01-25 10:30:00 | ES | Futures | 1066.45 | 1067.18 | 1063.28 | 1065.72 | 142563.0 |
| 2010-01-25 11:00:00 | ES | Futures | 1065.47 | 1065.96 | 1061.09 | 1063.04 | 156298.0 |
| 2010-01-25 11:30:00 | ES | Futures | 1063.28 | 1065.72 | 1060.37 | 1064.26 | 127484.0 |
| 2010-01-25 12:00:00 | ES | Futures | 1064.01 | 1067.66 | 1064.01 | 1065.47 | 93592.0 |
| 2010-01-25 12:30:00 | ES | Futures | 1065.47 | 1067.91 | 1065.23 | 1066.93 | 51178.0 |
| 2010-01-25 13:00:00 | ES | Futures | 1066.93 | 1068.15 | 1065.72 | 1067.18 | 42746.0 |
| 2010-01-25 13:30:00 | ES | Futures | 1067.18 | 1067.66 | 1064.99 | 1066.2 | 50225.0 |
| 2010-01-25 14:00:00 | ES | Futures | 1065.96 | 1068.15 | 1065.96 | 1067.91 | 48310.0 |
| 2010-01-25 14:30:00 | ES | Futures | 1068.15 | 1069.61 | 1066.2 | 1069.37 | 98411.0 |
| 2010-01-25 15:00:00 | ES | Futures | 1069.37 | 1069.85 | 1066.45 | 1066.93 | 90247.0 |
| 2010-01-25 15:30:00 | ES | Futures | 1066.93 | 1068.64 | 1063.04 | 1063.77 | 209328.0 |
| 2010-01-25 16:00:00 | ES | Futures | 1063.77 | 1064.01 | 1062.31 | 1063.53 | 97682.0 |
| 2010-01-25 16:30:00 | ES | Futures | 1064.5 | 1066.2 | 1060.61 | 1064.01 | 56149.0 |
| 2010-01-25 17:00:00 | ES | Futures | 1064.01 | 1064.26 | 1060.85 | 1062.07 | 8561.0 |
| 2010-01-25 17:30:00 | ES | Futures | 1062.07 | 1062.07 | 1062.07 | 1062.07 | 10.0 |
| 2010-01-25 18:00:00 | ES | Futures | 1063.04 | 1063.77 | 1062.8 | 1063.04 | 3358.0 |
| 2010-01-25 18:30:00 | ES | Futures | 1063.04 | 1063.53 | 1062.31 | 1063.53 | 1716.0 |
| 2010-01-25 19:00:00 | ES | Futures | 1063.53 | 1064.74 | 1063.04 | 1064.26 | 3239.0 |
| 2010-01-25 19:30:00 | ES | Futures | 1064.26 | 1065.47 | 1064.01 | 1064.99 | 2432.0 |
| 2010-01-25 20:00:00 | ES | Futures | 1064.99 | 1065.96 | 1064.74 | 1065.96 | 2931.0 |
| 2010-01-25 20:30:00 | ES | Futures | 1065.96 | 1066.45 | 1064.99 | 1065.23 | 3122.0 |
| 2010-01-25 21:00:00 | ES | Futures | 1065.23 | 1065.23 | 1062.07 | 1062.55 | 4379.0 |
| 2010-01-25 21:30:00 | ES | Futures | 1062.55 | 1062.55 | 1060.85 | 1061.34 | 4340.0 |
| 2010-01-25 22:00:00 | ES | Futures | 1061.58 | 1061.58 | 1056.72 | 1057.69 | 13844.0 |
| 2010-01-25 22:30:00 | ES | Futures | 1057.93 | 1058.18 | 1052.82 | 1055.26 | 16137.0 |
| 2010-01-25 23:00:00 | ES | Futures | 1055.01 | 1056.23 | 1054.53 | 1056.23 | 2944.0 |
| 2010-01-25 23:30:00 | ES | Futures | 1056.23 | 1056.23 | 1052.82 | 1052.82 | 8635.0 |
| 2010-01-25 00:00:00 | NQ | Futures | 2061.1 | 2061.39 | 2059.96 | 2060.24 | 84.0 |
| 2010-01-25 00:30:00 | NQ | Futures | 2059.96 | 2060.24 | 2059.39 | 2060.24 | 71.0 |
> showing 50 of 2,543 rows — these rows as CSV