PREVIEW / futures_30min / 2010-07-21
file: by_date/futures_30min/2010/2010-07-21.parquet size: 71 KB rows: 2,496
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-21 00:00:00 | ES | Futures | 1057.59 | 1058.08 | 1057.09 | 1057.34 | 1220.0 |
| 2010-07-21 00:30:00 | ES | Futures | 1057.34 | 1058.08 | 1056.85 | 1057.83 | 2552.0 |
| 2010-07-21 01:00:00 | ES | Futures | 1057.83 | 1058.08 | 1056.6 | 1056.85 | 2281.0 |
| 2010-07-21 01:30:00 | ES | Futures | 1056.6 | 1057.83 | 1056.6 | 1057.59 | 3795.0 |
| 2010-07-21 02:00:00 | ES | Futures | 1057.59 | 1059.3 | 1057.09 | 1058.81 | 5575.0 |
| 2010-07-21 02:30:00 | ES | Futures | 1059.06 | 1059.55 | 1058.08 | 1058.57 | 6141.0 |
| 2010-07-21 03:00:00 | ES | Futures | 1058.81 | 1063.47 | 1058.08 | 1062.98 | 23038.0 |
| 2010-07-21 03:30:00 | ES | Futures | 1063.23 | 1063.97 | 1061.76 | 1062.0 | 16078.0 |
| 2010-07-21 04:00:00 | ES | Futures | 1062.0 | 1062.49 | 1060.53 | 1062.0 | 10295.0 |
| 2010-07-21 04:30:00 | ES | Futures | 1061.76 | 1063.72 | 1061.76 | 1062.49 | 9981.0 |
| 2010-07-21 05:00:00 | ES | Futures | 1062.49 | 1064.7 | 1062.25 | 1063.47 | 10585.0 |
| 2010-07-21 05:30:00 | ES | Futures | 1063.47 | 1064.95 | 1062.74 | 1063.97 | 10369.0 |
| 2010-07-21 06:00:00 | ES | Futures | 1063.72 | 1064.46 | 1061.51 | 1061.76 | 8507.0 |
| 2010-07-21 06:30:00 | ES | Futures | 1061.76 | 1062.49 | 1061.02 | 1062.49 | 9349.0 |
| 2010-07-21 07:00:00 | ES | Futures | 1062.25 | 1063.72 | 1062.0 | 1063.23 | 15591.0 |
| 2010-07-21 07:30:00 | ES | Futures | 1062.98 | 1063.97 | 1061.76 | 1062.74 | 14839.0 |
| 2010-07-21 08:00:00 | ES | Futures | 1062.74 | 1065.44 | 1062.74 | 1064.7 | 39680.0 |
| 2010-07-21 08:30:00 | ES | Futures | 1064.7 | 1067.65 | 1064.7 | 1067.16 | 35951.0 |
| 2010-07-21 09:00:00 | ES | Futures | 1067.16 | 1067.4 | 1064.95 | 1064.95 | 41074.0 |
| 2010-07-21 09:30:00 | ES | Futures | 1064.95 | 1065.44 | 1057.09 | 1059.3 | 291586.0 |
| 2010-07-21 10:00:00 | ES | Futures | 1059.3 | 1061.51 | 1056.85 | 1061.27 | 156257.0 |
| 2010-07-21 10:30:00 | ES | Futures | 1061.27 | 1061.27 | 1058.08 | 1059.06 | 124617.0 |
| 2010-07-21 11:00:00 | ES | Futures | 1059.06 | 1059.55 | 1054.64 | 1056.6 | 156643.0 |
| 2010-07-21 11:30:00 | ES | Futures | 1056.6 | 1058.81 | 1055.13 | 1058.81 | 83052.0 |
| 2010-07-21 12:00:00 | ES | Futures | 1058.57 | 1060.78 | 1058.08 | 1059.55 | 82616.0 |
| 2010-07-21 12:30:00 | ES | Futures | 1059.55 | 1061.27 | 1057.59 | 1058.32 | 68831.0 |
| 2010-07-21 13:00:00 | ES | Futures | 1058.32 | 1059.79 | 1057.83 | 1059.3 | 33381.0 |
| 2010-07-21 13:30:00 | ES | Futures | 1059.06 | 1061.51 | 1058.08 | 1059.3 | 47037.0 |
| 2010-07-21 14:00:00 | ES | Futures | 1059.3 | 1060.28 | 1047.28 | 1048.75 | 321558.0 |
| 2010-07-21 14:30:00 | ES | Futures | 1048.75 | 1049.0 | 1041.39 | 1042.86 | 242221.0 |
| 2010-07-21 15:00:00 | ES | Futures | 1042.62 | 1048.02 | 1041.64 | 1044.34 | 163856.0 |
| 2010-07-21 15:30:00 | ES | Futures | 1044.34 | 1047.77 | 1042.86 | 1046.05 | 238708.0 |
| 2010-07-21 16:00:00 | ES | Futures | 1046.05 | 1046.3 | 1043.6 | 1044.09 | 84170.0 |
| 2010-07-21 16:30:00 | ES | Futures | 1043.6 | 1044.58 | 1042.86 | 1043.11 | 5613.0 |
| 2010-07-21 17:00:00 | ES | Futures | 1043.35 | 1044.34 | 1042.86 | 1043.11 | 1405.0 |
| 2010-07-21 18:00:00 | ES | Futures | 1043.6 | 1045.07 | 1042.62 | 1044.83 | 1516.0 |
| 2010-07-21 18:30:00 | ES | Futures | 1044.83 | 1044.83 | 1044.09 | 1044.34 | 736.0 |
| 2010-07-21 19:00:00 | ES | Futures | 1044.34 | 1045.07 | 1044.34 | 1044.83 | 552.0 |
| 2010-07-21 19:30:00 | ES | Futures | 1044.58 | 1045.56 | 1044.34 | 1045.32 | 1584.0 |
| 2010-07-21 20:00:00 | ES | Futures | 1045.07 | 1046.05 | 1043.35 | 1043.6 | 6169.0 |
| 2010-07-21 20:30:00 | ES | Futures | 1043.6 | 1045.07 | 1043.35 | 1043.84 | 3724.0 |
| 2010-07-21 21:00:00 | ES | Futures | 1043.6 | 1045.32 | 1043.6 | 1044.09 | 3819.0 |
| 2010-07-21 21:30:00 | ES | Futures | 1044.34 | 1045.07 | 1043.84 | 1044.34 | 1677.0 |
| 2010-07-21 22:00:00 | ES | Futures | 1044.34 | 1044.58 | 1043.84 | 1044.09 | 1846.0 |
| 2010-07-21 22:30:00 | ES | Futures | 1044.09 | 1044.09 | 1042.37 | 1043.6 | 2950.0 |
| 2010-07-21 23:00:00 | ES | Futures | 1043.6 | 1043.6 | 1042.86 | 1043.11 | 794.0 |
| 2010-07-21 23:30:00 | ES | Futures | 1042.86 | 1043.11 | 1042.13 | 1042.37 | 1936.0 |
| 2010-07-21 00:00:00 | NQ | Futures | 2115.72 | 2116.0 | 2113.42 | 2113.71 | 103.0 |
| 2010-07-21 00:30:00 | NQ | Futures | 2113.71 | 2116.0 | 2113.71 | 2115.43 | 112.0 |
| 2010-07-21 01:00:00 | NQ | Futures | 2115.43 | 2116.0 | 2113.42 | 2114.0 | 70.0 |
> showing 50 of 2,496 rows — these rows as CSV