PREVIEW / futures_30min / 2010-07-13
file: by_date/futures_30min/2010/2010-07-13.parquet size: 72 KB rows: 2,505
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-13 00:00:00 | ES | Futures | 1055.87 | 1057.09 | 1055.13 | 1056.85 | 2231.0 |
| 2010-07-13 00:30:00 | ES | Futures | 1056.85 | 1056.85 | 1054.64 | 1054.89 | 1954.0 |
| 2010-07-13 01:00:00 | ES | Futures | 1054.89 | 1055.38 | 1054.15 | 1054.64 | 1874.0 |
| 2010-07-13 01:30:00 | ES | Futures | 1054.89 | 1055.13 | 1053.91 | 1054.64 | 2369.0 |
| 2010-07-13 02:00:00 | ES | Futures | 1054.64 | 1055.13 | 1053.17 | 1053.41 | 5643.0 |
| 2010-07-13 02:30:00 | ES | Futures | 1053.41 | 1055.13 | 1053.17 | 1054.4 | 4364.0 |
| 2010-07-13 03:00:00 | ES | Futures | 1054.4 | 1057.83 | 1053.41 | 1054.64 | 23417.0 |
| 2010-07-13 03:30:00 | ES | Futures | 1054.89 | 1057.34 | 1054.15 | 1055.13 | 19955.0 |
| 2010-07-13 04:00:00 | ES | Futures | 1055.38 | 1058.57 | 1054.4 | 1058.32 | 12857.0 |
| 2010-07-13 04:30:00 | ES | Futures | 1058.32 | 1061.76 | 1057.83 | 1060.78 | 25279.0 |
| 2010-07-13 05:00:00 | ES | Futures | 1060.78 | 1064.21 | 1059.79 | 1063.72 | 22573.0 |
| 2010-07-13 05:30:00 | ES | Futures | 1063.72 | 1063.97 | 1062.49 | 1063.72 | 11000.0 |
| 2010-07-13 06:00:00 | ES | Futures | 1063.72 | 1063.97 | 1062.49 | 1063.23 | 11978.0 |
| 2010-07-13 06:30:00 | ES | Futures | 1063.47 | 1063.97 | 1062.74 | 1062.98 | 6206.0 |
| 2010-07-13 07:00:00 | ES | Futures | 1062.98 | 1064.95 | 1062.25 | 1064.95 | 13199.0 |
| 2010-07-13 07:30:00 | ES | Futures | 1064.7 | 1065.44 | 1063.97 | 1064.7 | 18982.0 |
| 2010-07-13 08:00:00 | ES | Futures | 1064.7 | 1065.68 | 1064.46 | 1065.68 | 17333.0 |
| 2010-07-13 08:30:00 | ES | Futures | 1065.44 | 1066.66 | 1064.7 | 1065.93 | 30633.0 |
| 2010-07-13 09:00:00 | ES | Futures | 1066.17 | 1068.14 | 1065.93 | 1066.42 | 49752.0 |
| 2010-07-13 09:30:00 | ES | Futures | 1066.17 | 1068.63 | 1064.21 | 1066.66 | 240357.0 |
| 2010-07-13 10:00:00 | ES | Futures | 1066.66 | 1070.84 | 1066.66 | 1068.63 | 191692.0 |
| 2010-07-13 10:30:00 | ES | Futures | 1068.63 | 1068.87 | 1065.93 | 1067.16 | 125278.0 |
| 2010-07-13 11:00:00 | ES | Futures | 1067.16 | 1069.85 | 1066.91 | 1069.36 | 81460.0 |
| 2010-07-13 11:30:00 | ES | Futures | 1069.36 | 1073.78 | 1069.12 | 1070.59 | 166964.0 |
| 2010-07-13 12:00:00 | ES | Futures | 1070.59 | 1072.8 | 1070.35 | 1072.55 | 68761.0 |
| 2010-07-13 12:30:00 | ES | Futures | 1072.31 | 1073.04 | 1070.35 | 1070.59 | 46971.0 |
| 2010-07-13 13:00:00 | ES | Futures | 1070.84 | 1072.55 | 1067.89 | 1068.87 | 87912.0 |
| 2010-07-13 13:30:00 | ES | Futures | 1068.63 | 1070.59 | 1067.65 | 1068.38 | 69708.0 |
| 2010-07-13 14:00:00 | ES | Futures | 1068.63 | 1071.82 | 1068.38 | 1070.1 | 79507.0 |
| 2010-07-13 14:30:00 | ES | Futures | 1069.85 | 1072.31 | 1069.85 | 1072.31 | 75687.0 |
| 2010-07-13 15:00:00 | ES | Futures | 1072.31 | 1074.52 | 1072.06 | 1074.03 | 106405.0 |
| 2010-07-13 15:30:00 | ES | Futures | 1074.03 | 1075.74 | 1070.59 | 1071.33 | 225073.0 |
| 2010-07-13 16:00:00 | ES | Futures | 1071.33 | 1072.06 | 1069.12 | 1069.36 | 105660.0 |
| 2010-07-13 16:30:00 | ES | Futures | 1074.76 | 1077.95 | 1074.27 | 1076.73 | 47247.0 |
| 2010-07-13 17:00:00 | ES | Futures | 1076.73 | 1078.69 | 1076.48 | 1077.46 | 7293.0 |
| 2010-07-13 18:00:00 | ES | Futures | 1077.71 | 1078.44 | 1077.22 | 1077.71 | 4789.0 |
| 2010-07-13 18:30:00 | ES | Futures | 1077.71 | 1077.71 | 1076.73 | 1076.97 | 2039.0 |
| 2010-07-13 19:00:00 | ES | Futures | 1076.97 | 1077.46 | 1076.73 | 1077.22 | 878.0 |
| 2010-07-13 19:30:00 | ES | Futures | 1077.22 | 1077.71 | 1076.73 | 1077.46 | 1237.0 |
| 2010-07-13 20:00:00 | ES | Futures | 1077.71 | 1077.95 | 1076.97 | 1077.95 | 2845.0 |
| 2010-07-13 20:30:00 | ES | Futures | 1077.71 | 1078.2 | 1076.97 | 1077.46 | 2403.0 |
| 2010-07-13 21:00:00 | ES | Futures | 1077.46 | 1077.71 | 1076.97 | 1077.71 | 1852.0 |
| 2010-07-13 21:30:00 | ES | Futures | 1077.46 | 1077.71 | 1076.97 | 1077.22 | 777.0 |
| 2010-07-13 22:00:00 | ES | Futures | 1077.22 | 1077.46 | 1076.97 | 1077.22 | 648.0 |
| 2010-07-13 22:30:00 | ES | Futures | 1077.22 | 1077.71 | 1076.73 | 1077.46 | 820.0 |
| 2010-07-13 23:00:00 | ES | Futures | 1077.46 | 1077.95 | 1076.73 | 1077.46 | 849.0 |
| 2010-07-13 23:30:00 | ES | Futures | 1077.46 | 1077.71 | 1076.97 | 1077.46 | 1511.0 |
| 2010-07-13 00:00:00 | NQ | Futures | 2087.06 | 2089.07 | 2086.2 | 2089.07 | 155.0 |
| 2010-07-13 00:30:00 | NQ | Futures | 2089.35 | 2089.35 | 2085.63 | 2086.2 | 111.0 |
| 2010-07-13 01:00:00 | NQ | Futures | 2086.2 | 2087.06 | 2085.05 | 2085.34 | 151.0 |
> showing 50 of 2,505 rows — these rows as CSV