PREVIEW / futures_30min / 2010-09-14
file: by_date/futures_30min/2010/2010-09-14.parquet size: 73 KB rows: 2,582
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-14 00:00:00 | ES | Futures | 1100.28 | 1100.77 | 1100.04 | 1100.53 | 1177.0 |
| 2010-09-14 00:30:00 | ES | Futures | 1100.53 | 1100.53 | 1099.54 | 1099.54 | 895.0 |
| 2010-09-14 01:00:00 | ES | Futures | 1099.54 | 1100.28 | 1099.3 | 1099.3 | 1249.0 |
| 2010-09-14 01:30:00 | ES | Futures | 1099.54 | 1100.04 | 1098.56 | 1099.54 | 3576.0 |
| 2010-09-14 02:00:00 | ES | Futures | 1099.54 | 1100.04 | 1098.8 | 1099.3 | 4621.0 |
| 2010-09-14 02:30:00 | ES | Futures | 1099.54 | 1100.77 | 1098.8 | 1100.28 | 4727.0 |
| 2010-09-14 03:00:00 | ES | Futures | 1100.28 | 1102.01 | 1100.28 | 1101.51 | 12111.0 |
| 2010-09-14 03:30:00 | ES | Futures | 1101.76 | 1101.76 | 1099.05 | 1099.3 | 11868.0 |
| 2010-09-14 04:00:00 | ES | Futures | 1099.3 | 1099.54 | 1097.82 | 1098.56 | 17408.0 |
| 2010-09-14 04:30:00 | ES | Futures | 1098.31 | 1099.54 | 1097.57 | 1099.3 | 7309.0 |
| 2010-09-14 05:00:00 | ES | Futures | 1099.3 | 1099.54 | 1097.08 | 1097.08 | 13764.0 |
| 2010-09-14 05:30:00 | ES | Futures | 1097.08 | 1098.06 | 1097.08 | 1097.82 | 4066.0 |
| 2010-09-14 06:00:00 | ES | Futures | 1097.57 | 1100.28 | 1097.57 | 1100.04 | 5152.0 |
| 2010-09-14 06:30:00 | ES | Futures | 1099.79 | 1100.04 | 1098.8 | 1098.8 | 3409.0 |
| 2010-09-14 07:00:00 | ES | Futures | 1098.8 | 1099.05 | 1096.58 | 1097.08 | 11462.0 |
| 2010-09-14 07:30:00 | ES | Futures | 1097.08 | 1098.31 | 1096.58 | 1098.31 | 10282.0 |
| 2010-09-14 08:00:00 | ES | Futures | 1098.06 | 1101.02 | 1098.06 | 1100.53 | 35819.0 |
| 2010-09-14 08:30:00 | ES | Futures | 1100.28 | 1102.25 | 1097.82 | 1097.82 | 69395.0 |
| 2010-09-14 09:00:00 | ES | Futures | 1097.82 | 1099.3 | 1097.57 | 1098.56 | 33436.0 |
| 2010-09-14 09:30:00 | ES | Futures | 1098.8 | 1099.79 | 1094.61 | 1097.32 | 232512.0 |
| 2010-09-14 10:00:00 | ES | Futures | 1097.08 | 1099.79 | 1096.09 | 1099.05 | 127497.0 |
| 2010-09-14 10:30:00 | ES | Futures | 1099.3 | 1102.5 | 1098.56 | 1101.51 | 166339.0 |
| 2010-09-14 11:00:00 | ES | Futures | 1101.76 | 1104.96 | 1101.02 | 1103.49 | 185788.0 |
| 2010-09-14 11:30:00 | ES | Futures | 1103.49 | 1105.95 | 1103.24 | 1105.7 | 136854.0 |
| 2010-09-14 12:00:00 | ES | Futures | 1105.46 | 1106.69 | 1104.47 | 1105.7 | 71373.0 |
| 2010-09-14 12:30:00 | ES | Futures | 1105.46 | 1105.7 | 1102.5 | 1103.49 | 82386.0 |
| 2010-09-14 13:00:00 | ES | Futures | 1103.24 | 1104.23 | 1101.02 | 1102.25 | 60347.0 |
| 2010-09-14 13:30:00 | ES | Futures | 1102.01 | 1102.99 | 1099.79 | 1101.51 | 89571.0 |
| 2010-09-14 14:00:00 | ES | Futures | 1101.51 | 1102.5 | 1100.77 | 1101.51 | 42829.0 |
| 2010-09-14 14:30:00 | ES | Futures | 1101.51 | 1104.23 | 1101.02 | 1103.73 | 69288.0 |
| 2010-09-14 15:00:00 | ES | Futures | 1103.49 | 1104.72 | 1102.75 | 1104.23 | 46568.0 |
| 2010-09-14 15:30:00 | ES | Futures | 1103.98 | 1105.95 | 1099.79 | 1100.28 | 240090.0 |
| 2010-09-14 16:00:00 | ES | Futures | 1100.28 | 1101.76 | 1099.79 | 1100.04 | 85862.0 |
| 2010-09-14 16:30:00 | ES | Futures | 1099.79 | 1100.28 | 1097.32 | 1097.82 | 10622.0 |
| 2010-09-14 17:00:00 | ES | Futures | 1097.82 | 1098.56 | 1097.57 | 1098.31 | 739.0 |
| 2010-09-14 18:00:00 | ES | Futures | 1098.31 | 1098.56 | 1096.09 | 1096.83 | 5267.0 |
| 2010-09-14 18:30:00 | ES | Futures | 1096.58 | 1097.57 | 1096.34 | 1097.32 | 965.0 |
| 2010-09-14 19:00:00 | ES | Futures | 1097.32 | 1097.57 | 1097.08 | 1097.08 | 231.0 |
| 2010-09-14 19:30:00 | ES | Futures | 1097.32 | 1097.82 | 1097.08 | 1097.32 | 917.0 |
| 2010-09-14 20:00:00 | ES | Futures | 1097.57 | 1099.3 | 1097.08 | 1098.8 | 3050.0 |
| 2010-09-14 20:30:00 | ES | Futures | 1098.56 | 1099.05 | 1098.06 | 1098.56 | 1665.0 |
| 2010-09-14 21:00:00 | ES | Futures | 1098.31 | 1099.05 | 1097.08 | 1097.32 | 3024.0 |
| 2010-09-14 21:30:00 | ES | Futures | 1097.32 | 1102.01 | 1096.83 | 1100.53 | 15590.0 |
| 2010-09-14 22:00:00 | ES | Futures | 1100.53 | 1102.01 | 1100.28 | 1100.77 | 5508.0 |
| 2010-09-14 22:30:00 | ES | Futures | 1100.77 | 1101.76 | 1099.54 | 1101.02 | 3400.0 |
| 2010-09-14 23:00:00 | ES | Futures | 1101.02 | 1101.51 | 1100.04 | 1100.77 | 3875.0 |
| 2010-09-14 23:30:00 | ES | Futures | 1100.77 | 1101.51 | 1100.28 | 1101.27 | 1869.0 |
| 2010-09-14 00:00:00 | NQ | Futures | 2199.11 | 2199.39 | 2198.25 | 2198.82 | 82.0 |
| 2010-09-14 00:30:00 | NQ | Futures | 2198.82 | 2198.82 | 2197.67 | 2197.67 | 46.0 |
| 2010-09-14 01:00:00 | NQ | Futures | 2197.96 | 2198.25 | 2197.39 | 2197.96 | 67.0 |
> showing 50 of 2,582 rows — these rows as CSV