PREVIEW / futures_30min / 2010-09-07
file: by_date/futures_30min/2010/2010-09-07.parquet size: 71 KB rows: 2,518
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-09-07 00:00:00 | ES | Futures | 1085.31 | 1085.31 | 1083.84 | 1084.33 | 1182.0 |
| 2010-09-07 00:30:00 | ES | Futures | 1084.09 | 1084.33 | 1082.86 | 1083.11 | 2256.0 |
| 2010-09-07 01:00:00 | ES | Futures | 1083.11 | 1083.6 | 1082.61 | 1082.86 | 1556.0 |
| 2010-09-07 01:30:00 | ES | Futures | 1082.61 | 1083.35 | 1082.37 | 1083.11 | 1776.0 |
| 2010-09-07 02:00:00 | ES | Futures | 1083.35 | 1083.35 | 1079.67 | 1079.92 | 11795.0 |
| 2010-09-07 02:30:00 | ES | Futures | 1080.16 | 1081.63 | 1079.92 | 1081.14 | 6026.0 |
| 2010-09-07 03:00:00 | ES | Futures | 1081.39 | 1081.39 | 1077.95 | 1078.2 | 26239.0 |
| 2010-09-07 03:30:00 | ES | Futures | 1078.2 | 1079.18 | 1076.97 | 1078.44 | 17538.0 |
| 2010-09-07 04:00:00 | ES | Futures | 1078.44 | 1078.69 | 1075.01 | 1076.73 | 26617.0 |
| 2010-09-07 04:30:00 | ES | Futures | 1076.48 | 1078.69 | 1076.23 | 1078.44 | 7131.0 |
| 2010-09-07 05:00:00 | ES | Futures | 1078.44 | 1078.69 | 1076.48 | 1077.22 | 8550.0 |
| 2010-09-07 05:30:00 | ES | Futures | 1077.22 | 1078.2 | 1076.73 | 1077.22 | 6052.0 |
| 2010-09-07 06:00:00 | ES | Futures | 1076.97 | 1076.97 | 1075.25 | 1075.99 | 10294.0 |
| 2010-09-07 06:30:00 | ES | Futures | 1075.99 | 1077.71 | 1075.74 | 1077.46 | 6206.0 |
| 2010-09-07 07:00:00 | ES | Futures | 1077.22 | 1077.95 | 1075.74 | 1076.23 | 8463.0 |
| 2010-09-07 07:30:00 | ES | Futures | 1076.23 | 1078.44 | 1074.76 | 1077.71 | 20786.0 |
| 2010-09-07 08:00:00 | ES | Futures | 1077.95 | 1077.95 | 1075.74 | 1075.74 | 20208.0 |
| 2010-09-07 08:30:00 | ES | Futures | 1075.74 | 1077.22 | 1075.74 | 1076.48 | 15955.0 |
| 2010-09-07 09:00:00 | ES | Futures | 1076.73 | 1078.44 | 1076.48 | 1077.71 | 27970.0 |
| 2010-09-07 09:30:00 | ES | Futures | 1077.71 | 1079.18 | 1072.55 | 1072.8 | 215862.0 |
| 2010-09-07 10:00:00 | ES | Futures | 1072.8 | 1074.76 | 1071.57 | 1074.03 | 150119.0 |
| 2010-09-07 10:30:00 | ES | Futures | 1074.03 | 1075.25 | 1072.55 | 1074.52 | 95315.0 |
| 2010-09-07 11:00:00 | ES | Futures | 1074.52 | 1075.5 | 1072.31 | 1075.25 | 104843.0 |
| 2010-09-07 11:30:00 | ES | Futures | 1075.25 | 1075.99 | 1072.8 | 1075.74 | 81900.0 |
| 2010-09-07 12:00:00 | ES | Futures | 1075.5 | 1076.48 | 1073.78 | 1074.27 | 58588.0 |
| 2010-09-07 12:30:00 | ES | Futures | 1074.27 | 1074.76 | 1072.8 | 1074.03 | 49624.0 |
| 2010-09-07 13:00:00 | ES | Futures | 1074.03 | 1074.27 | 1072.55 | 1073.54 | 56548.0 |
| 2010-09-07 13:30:00 | ES | Futures | 1073.54 | 1075.74 | 1073.29 | 1075.5 | 48579.0 |
| 2010-09-07 14:00:00 | ES | Futures | 1075.5 | 1076.48 | 1074.27 | 1075.01 | 41927.0 |
| 2010-09-07 14:30:00 | ES | Futures | 1075.01 | 1075.25 | 1070.35 | 1071.33 | 83271.0 |
| 2010-09-07 15:00:00 | ES | Futures | 1071.33 | 1072.55 | 1070.1 | 1072.06 | 79888.0 |
| 2010-09-07 15:30:00 | ES | Futures | 1072.06 | 1073.54 | 1069.61 | 1071.08 | 127645.0 |
| 2010-09-07 16:00:00 | ES | Futures | 1071.08 | 1072.31 | 1070.84 | 1071.08 | 64908.0 |
| 2010-09-07 16:30:00 | ES | Futures | 1071.33 | 1071.57 | 1070.35 | 1071.08 | 3481.0 |
| 2010-09-07 17:00:00 | ES | Futures | 1071.08 | 1071.57 | 1070.59 | 1071.33 | 850.0 |
| 2010-09-07 18:00:00 | ES | Futures | 1071.33 | 1071.57 | 1070.35 | 1070.84 | 839.0 |
| 2010-09-07 18:30:00 | ES | Futures | 1070.84 | 1071.08 | 1070.35 | 1070.84 | 559.0 |
| 2010-09-07 19:00:00 | ES | Futures | 1070.84 | 1071.57 | 1070.84 | 1071.57 | 1052.0 |
| 2010-09-07 19:30:00 | ES | Futures | 1071.57 | 1071.57 | 1070.84 | 1070.84 | 1110.0 |
| 2010-09-07 20:00:00 | ES | Futures | 1070.84 | 1072.31 | 1070.84 | 1072.06 | 2223.0 |
| 2010-09-07 20:30:00 | ES | Futures | 1071.82 | 1072.8 | 1071.57 | 1072.31 | 2740.0 |
| 2010-09-07 21:00:00 | ES | Futures | 1072.31 | 1072.55 | 1069.61 | 1069.85 | 4078.0 |
| 2010-09-07 21:30:00 | ES | Futures | 1069.85 | 1070.84 | 1069.61 | 1070.59 | 2552.0 |
| 2010-09-07 22:00:00 | ES | Futures | 1070.59 | 1070.84 | 1069.36 | 1069.61 | 1879.0 |
| 2010-09-07 22:30:00 | ES | Futures | 1069.61 | 1070.1 | 1068.63 | 1068.87 | 2774.0 |
| 2010-09-07 23:00:00 | ES | Futures | 1069.12 | 1069.85 | 1068.38 | 1069.61 | 2484.0 |
| 2010-09-07 23:30:00 | ES | Futures | 1069.61 | 1069.85 | 1068.38 | 1068.63 | 2700.0 |
| 2010-09-07 00:00:00 | NQ | Futures | 2144.95 | 2145.23 | 2142.94 | 2143.51 | 98.0 |
| 2010-09-07 00:30:00 | NQ | Futures | 2143.51 | 2143.51 | 2141.22 | 2141.51 | 211.0 |
| 2010-09-07 01:00:00 | NQ | Futures | 2141.79 | 2142.37 | 2141.22 | 2141.22 | 57.0 |
> showing 50 of 2,518 rows — these rows as CSV