PREVIEW / futures_30min / 2010-02-25
file: by_date/futures_30min/2010/2010-02-25.parquet size: 71 KB rows: 2,537
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-02-25 00:00:00 | ES | Futures | 1066.2 | 1066.69 | 1065.47 | 1065.72 | 2796.0 |
| 2010-02-25 00:30:00 | ES | Futures | 1065.72 | 1066.45 | 1065.47 | 1065.72 | 1839.0 |
| 2010-02-25 01:00:00 | ES | Futures | 1065.72 | 1067.42 | 1065.47 | 1066.2 | 3815.0 |
| 2010-02-25 01:30:00 | ES | Futures | 1065.96 | 1067.42 | 1065.96 | 1066.93 | 3506.0 |
| 2010-02-25 02:00:00 | ES | Futures | 1067.18 | 1067.66 | 1065.96 | 1067.18 | 5249.0 |
| 2010-02-25 02:30:00 | ES | Futures | 1066.93 | 1067.91 | 1065.47 | 1067.18 | 8131.0 |
| 2010-02-25 03:00:00 | ES | Futures | 1067.42 | 1069.12 | 1065.47 | 1067.91 | 19581.0 |
| 2010-02-25 03:30:00 | ES | Futures | 1067.66 | 1069.61 | 1067.18 | 1069.37 | 16328.0 |
| 2010-02-25 04:00:00 | ES | Futures | 1069.37 | 1069.61 | 1067.42 | 1068.39 | 7138.0 |
| 2010-02-25 04:30:00 | ES | Futures | 1068.39 | 1071.8 | 1067.91 | 1070.58 | 16597.0 |
| 2010-02-25 05:00:00 | ES | Futures | 1070.58 | 1071.31 | 1070.1 | 1070.58 | 9042.0 |
| 2010-02-25 05:30:00 | ES | Futures | 1070.34 | 1070.58 | 1068.88 | 1069.12 | 6485.0 |
| 2010-02-25 06:00:00 | ES | Futures | 1069.12 | 1069.37 | 1068.15 | 1069.12 | 6240.0 |
| 2010-02-25 06:30:00 | ES | Futures | 1069.12 | 1070.1 | 1068.15 | 1069.12 | 7625.0 |
| 2010-02-25 07:00:00 | ES | Futures | 1069.12 | 1069.37 | 1066.69 | 1066.69 | 8014.0 |
| 2010-02-25 07:30:00 | ES | Futures | 1066.69 | 1067.66 | 1065.72 | 1067.18 | 22698.0 |
| 2010-02-25 08:00:00 | ES | Futures | 1067.18 | 1068.15 | 1066.2 | 1066.45 | 24216.0 |
| 2010-02-25 08:30:00 | ES | Futures | 1066.2 | 1066.2 | 1061.82 | 1063.04 | 118218.0 |
| 2010-02-25 09:00:00 | ES | Futures | 1062.8 | 1063.04 | 1057.93 | 1058.42 | 109782.0 |
| 2010-02-25 09:30:00 | ES | Futures | 1058.18 | 1059.64 | 1055.26 | 1058.66 | 277713.0 |
| 2010-02-25 10:00:00 | ES | Futures | 1058.66 | 1060.37 | 1056.47 | 1060.37 | 203967.0 |
| 2010-02-25 10:30:00 | ES | Futures | 1060.12 | 1060.85 | 1058.42 | 1059.15 | 137737.0 |
| 2010-02-25 11:00:00 | ES | Futures | 1059.15 | 1060.12 | 1057.2 | 1058.18 | 117315.0 |
| 2010-02-25 11:30:00 | ES | Futures | 1057.93 | 1058.42 | 1056.23 | 1057.2 | 108523.0 |
| 2010-02-25 12:00:00 | ES | Futures | 1057.45 | 1059.88 | 1056.72 | 1058.91 | 70526.0 |
| 2010-02-25 12:30:00 | ES | Futures | 1058.66 | 1061.34 | 1058.66 | 1059.88 | 93877.0 |
| 2010-02-25 13:00:00 | ES | Futures | 1059.88 | 1060.61 | 1058.91 | 1059.39 | 60510.0 |
| 2010-02-25 13:30:00 | ES | Futures | 1059.15 | 1066.69 | 1059.15 | 1066.69 | 215051.0 |
| 2010-02-25 14:00:00 | ES | Futures | 1066.69 | 1068.88 | 1065.47 | 1066.2 | 266605.0 |
| 2010-02-25 14:30:00 | ES | Futures | 1066.2 | 1068.39 | 1065.96 | 1067.66 | 109555.0 |
| 2010-02-25 15:00:00 | ES | Futures | 1067.42 | 1071.55 | 1066.69 | 1070.1 | 190380.0 |
| 2010-02-25 15:30:00 | ES | Futures | 1070.1 | 1073.01 | 1069.37 | 1072.53 | 289115.0 |
| 2010-02-25 16:00:00 | ES | Futures | 1072.77 | 1073.26 | 1071.07 | 1072.53 | 100281.0 |
| 2010-02-25 16:30:00 | ES | Futures | 1072.28 | 1072.28 | 1071.31 | 1072.04 | 5132.0 |
| 2010-02-25 17:00:00 | ES | Futures | 1071.8 | 1073.01 | 1071.31 | 1071.55 | 4029.0 |
| 2010-02-25 18:00:00 | ES | Futures | 1072.04 | 1072.28 | 1071.55 | 1072.04 | 3089.0 |
| 2010-02-25 18:30:00 | ES | Futures | 1072.04 | 1073.74 | 1072.04 | 1073.5 | 3157.0 |
| 2010-02-25 19:00:00 | ES | Futures | 1073.26 | 1074.96 | 1073.01 | 1073.99 | 5795.0 |
| 2010-02-25 19:30:00 | ES | Futures | 1073.99 | 1074.96 | 1073.5 | 1074.23 | 2474.0 |
| 2010-02-25 20:00:00 | ES | Futures | 1074.23 | 1074.72 | 1073.5 | 1074.72 | 2057.0 |
| 2010-02-25 20:30:00 | ES | Futures | 1074.47 | 1077.88 | 1074.47 | 1076.66 | 8809.0 |
| 2010-02-25 21:00:00 | ES | Futures | 1076.91 | 1076.91 | 1075.69 | 1076.91 | 2046.0 |
| 2010-02-25 21:30:00 | ES | Futures | 1076.66 | 1077.15 | 1075.93 | 1076.18 | 1588.0 |
| 2010-02-25 22:00:00 | ES | Futures | 1076.18 | 1076.42 | 1074.96 | 1076.42 | 2341.0 |
| 2010-02-25 22:30:00 | ES | Futures | 1076.18 | 1076.42 | 1075.45 | 1075.93 | 1216.0 |
| 2010-02-25 23:00:00 | ES | Futures | 1075.93 | 1076.66 | 1075.69 | 1076.42 | 1130.0 |
| 2010-02-25 23:30:00 | ES | Futures | 1076.42 | 1076.66 | 1075.69 | 1075.69 | 839.0 |
| 2010-02-25 00:00:00 | NQ | Futures | 2057.67 | 2057.96 | 2055.96 | 2056.53 | 193.0 |
| 2010-02-25 00:30:00 | NQ | Futures | 2056.53 | 2058.24 | 2055.67 | 2057.1 | 158.0 |
| 2010-02-25 01:00:00 | NQ | Futures | 2057.1 | 2059.1 | 2056.82 | 2057.96 | 290.0 |
> showing 50 of 2,537 rows — these rows as CSV