PREVIEW / futures_30min / 2010-08-12
file: by_date/futures_30min/2010/2010-08-12.parquet size: 71 KB rows: 2,530
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-08-12 00:00:00 | ES | Futures | 1060.53 | 1060.78 | 1059.79 | 1059.79 | 1766.0 |
| 2010-08-12 00:30:00 | ES | Futures | 1059.79 | 1062.98 | 1059.79 | 1061.51 | 5357.0 |
| 2010-08-12 01:00:00 | ES | Futures | 1061.76 | 1063.47 | 1060.04 | 1062.98 | 2889.0 |
| 2010-08-12 01:30:00 | ES | Futures | 1063.23 | 1063.97 | 1062.49 | 1063.47 | 4276.0 |
| 2010-08-12 02:00:00 | ES | Futures | 1063.72 | 1064.7 | 1062.98 | 1063.23 | 10415.0 |
| 2010-08-12 02:30:00 | ES | Futures | 1063.47 | 1064.21 | 1061.76 | 1062.25 | 9082.0 |
| 2010-08-12 03:00:00 | ES | Futures | 1062.49 | 1066.42 | 1062.49 | 1066.17 | 25041.0 |
| 2010-08-12 03:30:00 | ES | Futures | 1066.17 | 1067.4 | 1065.44 | 1066.91 | 16781.0 |
| 2010-08-12 04:00:00 | ES | Futures | 1066.66 | 1066.91 | 1063.97 | 1064.21 | 16807.0 |
| 2010-08-12 04:30:00 | ES | Futures | 1064.21 | 1064.21 | 1062.49 | 1063.72 | 15928.0 |
| 2010-08-12 05:00:00 | ES | Futures | 1063.72 | 1064.95 | 1062.0 | 1063.97 | 15715.0 |
| 2010-08-12 05:30:00 | ES | Futures | 1064.21 | 1064.7 | 1061.27 | 1061.76 | 13156.0 |
| 2010-08-12 06:00:00 | ES | Futures | 1061.76 | 1064.21 | 1061.51 | 1063.97 | 8950.0 |
| 2010-08-12 06:30:00 | ES | Futures | 1063.97 | 1064.7 | 1062.98 | 1063.23 | 10703.0 |
| 2010-08-12 07:00:00 | ES | Futures | 1063.23 | 1064.95 | 1062.98 | 1063.97 | 12758.0 |
| 2010-08-12 07:30:00 | ES | Futures | 1063.97 | 1063.97 | 1060.28 | 1061.02 | 28919.0 |
| 2010-08-12 08:00:00 | ES | Futures | 1061.02 | 1061.02 | 1058.08 | 1058.81 | 45136.0 |
| 2010-08-12 08:30:00 | ES | Futures | 1058.57 | 1058.57 | 1052.92 | 1054.89 | 114524.0 |
| 2010-08-12 09:00:00 | ES | Futures | 1054.89 | 1055.13 | 1050.72 | 1051.21 | 83729.0 |
| 2010-08-12 09:30:00 | ES | Futures | 1051.45 | 1059.55 | 1050.72 | 1058.08 | 309910.0 |
| 2010-08-12 10:00:00 | ES | Futures | 1058.32 | 1061.76 | 1057.09 | 1057.59 | 191829.0 |
| 2010-08-12 10:30:00 | ES | Futures | 1057.59 | 1063.72 | 1057.09 | 1061.76 | 164974.0 |
| 2010-08-12 11:00:00 | ES | Futures | 1062.0 | 1064.21 | 1059.3 | 1063.72 | 126020.0 |
| 2010-08-12 11:30:00 | ES | Futures | 1063.72 | 1064.46 | 1061.27 | 1062.25 | 84191.0 |
| 2010-08-12 12:00:00 | ES | Futures | 1062.0 | 1063.23 | 1060.28 | 1062.0 | 56637.0 |
| 2010-08-12 12:30:00 | ES | Futures | 1061.76 | 1063.97 | 1061.76 | 1063.97 | 47483.0 |
| 2010-08-12 13:00:00 | ES | Futures | 1063.97 | 1064.46 | 1061.27 | 1061.51 | 61602.0 |
| 2010-08-12 13:30:00 | ES | Futures | 1061.51 | 1062.0 | 1058.32 | 1059.06 | 78170.0 |
| 2010-08-12 14:00:00 | ES | Futures | 1058.81 | 1060.53 | 1058.08 | 1059.79 | 62171.0 |
| 2010-08-12 14:30:00 | ES | Futures | 1060.04 | 1061.27 | 1057.34 | 1060.53 | 77027.0 |
| 2010-08-12 15:00:00 | ES | Futures | 1060.28 | 1064.7 | 1060.28 | 1062.49 | 126552.0 |
| 2010-08-12 15:30:00 | ES | Futures | 1062.25 | 1064.7 | 1059.3 | 1061.27 | 163598.0 |
| 2010-08-12 16:00:00 | ES | Futures | 1061.27 | 1061.27 | 1058.57 | 1059.3 | 84746.0 |
| 2010-08-12 16:30:00 | ES | Futures | 1059.55 | 1060.28 | 1059.06 | 1059.55 | 3974.0 |
| 2010-08-12 17:00:00 | ES | Futures | 1059.55 | 1060.53 | 1059.3 | 1059.79 | 1240.0 |
| 2010-08-12 18:00:00 | ES | Futures | 1060.04 | 1060.04 | 1059.55 | 1059.79 | 418.0 |
| 2010-08-12 18:30:00 | ES | Futures | 1060.04 | 1061.02 | 1059.79 | 1061.02 | 1243.0 |
| 2010-08-12 19:00:00 | ES | Futures | 1060.78 | 1061.76 | 1060.78 | 1060.78 | 1984.0 |
| 2010-08-12 19:30:00 | ES | Futures | 1060.78 | 1062.49 | 1060.78 | 1061.51 | 2411.0 |
| 2010-08-12 20:00:00 | ES | Futures | 1061.51 | 1062.0 | 1060.04 | 1060.78 | 3496.0 |
| 2010-08-12 20:30:00 | ES | Futures | 1060.78 | 1063.72 | 1060.78 | 1062.25 | 4916.0 |
| 2010-08-12 21:00:00 | ES | Futures | 1062.49 | 1062.49 | 1060.28 | 1061.76 | 2211.0 |
| 2010-08-12 21:30:00 | ES | Futures | 1061.51 | 1062.74 | 1060.78 | 1062.74 | 1722.0 |
| 2010-08-12 22:00:00 | ES | Futures | 1062.74 | 1063.72 | 1062.0 | 1063.47 | 1646.0 |
| 2010-08-12 22:30:00 | ES | Futures | 1063.23 | 1064.7 | 1062.74 | 1063.23 | 3176.0 |
| 2010-08-12 23:00:00 | ES | Futures | 1063.23 | 1064.21 | 1062.25 | 1063.97 | 1230.0 |
| 2010-08-12 23:30:00 | ES | Futures | 1063.97 | 1065.93 | 1063.72 | 1065.93 | 4613.0 |
| 2010-08-12 00:00:00 | NQ | Futures | 2091.36 | 2092.22 | 2090.5 | 2091.36 | 120.0 |
| 2010-08-12 00:30:00 | NQ | Futures | 2091.07 | 2097.09 | 2091.07 | 2095.08 | 607.0 |
| 2010-08-12 01:00:00 | NQ | Futures | 2094.8 | 2097.66 | 2092.22 | 2097.09 | 292.0 |
> showing 50 of 2,530 rows — these rows as CSV