PREVIEW / futures_30min / 2010-09-22
file: by_date/futures_30min/2010/2010-09-22.parquet size: 72 KB rows: 2,604
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-22 00:00:00 | ES | Futures | 1122.96 | 1124.19 | 1122.96 | 1122.96 | 3497.0 |
| 2010-09-22 00:30:00 | ES | Futures | 1123.2 | 1123.7 | 1122.96 | 1123.2 | 1135.0 |
| 2010-09-22 01:00:00 | ES | Futures | 1123.2 | 1123.7 | 1122.96 | 1123.2 | 862.0 |
| 2010-09-22 01:30:00 | ES | Futures | 1123.2 | 1123.45 | 1121.97 | 1122.22 | 2179.0 |
| 2010-09-22 02:00:00 | ES | Futures | 1121.97 | 1122.46 | 1120.99 | 1122.22 | 6001.0 |
| 2010-09-22 02:30:00 | ES | Futures | 1122.46 | 1123.94 | 1121.97 | 1123.2 | 5278.0 |
| 2010-09-22 03:00:00 | ES | Futures | 1122.96 | 1123.2 | 1116.3 | 1117.29 | 25285.0 |
| 2010-09-22 03:30:00 | ES | Futures | 1117.29 | 1118.03 | 1115.07 | 1116.55 | 22486.0 |
| 2010-09-22 04:00:00 | ES | Futures | 1116.3 | 1117.04 | 1113.1 | 1114.33 | 24794.0 |
| 2010-09-22 04:30:00 | ES | Futures | 1114.33 | 1116.3 | 1113.59 | 1115.56 | 13119.0 |
| 2010-09-22 05:00:00 | ES | Futures | 1115.32 | 1116.3 | 1114.33 | 1116.06 | 14047.0 |
| 2010-09-22 05:30:00 | ES | Futures | 1115.81 | 1117.29 | 1115.56 | 1116.55 | 12294.0 |
| 2010-09-22 06:00:00 | ES | Futures | 1116.55 | 1118.77 | 1116.55 | 1117.29 | 10501.0 |
| 2010-09-22 06:30:00 | ES | Futures | 1117.29 | 1117.78 | 1116.06 | 1116.3 | 6997.0 |
| 2010-09-22 07:00:00 | ES | Futures | 1116.3 | 1116.55 | 1114.08 | 1114.58 | 13125.0 |
| 2010-09-22 07:30:00 | ES | Futures | 1114.33 | 1116.55 | 1114.33 | 1116.06 | 10457.0 |
| 2010-09-22 08:00:00 | ES | Futures | 1116.06 | 1118.52 | 1115.56 | 1117.29 | 30900.0 |
| 2010-09-22 08:30:00 | ES | Futures | 1117.29 | 1117.78 | 1115.56 | 1116.06 | 26863.0 |
| 2010-09-22 09:00:00 | ES | Futures | 1116.3 | 1118.27 | 1115.81 | 1117.29 | 35339.0 |
| 2010-09-22 09:30:00 | ES | Futures | 1117.54 | 1123.7 | 1116.8 | 1120.49 | 226539.0 |
| 2010-09-22 10:00:00 | ES | Futures | 1120.74 | 1120.74 | 1116.3 | 1116.55 | 207543.0 |
| 2010-09-22 10:30:00 | ES | Futures | 1116.55 | 1117.29 | 1114.33 | 1117.04 | 171947.0 |
| 2010-09-22 11:00:00 | ES | Futures | 1117.04 | 1117.78 | 1110.63 | 1112.36 | 205260.0 |
| 2010-09-22 11:30:00 | ES | Futures | 1112.61 | 1114.58 | 1111.37 | 1113.84 | 95753.0 |
| 2010-09-22 12:00:00 | ES | Futures | 1113.84 | 1115.32 | 1112.61 | 1114.33 | 77885.0 |
| 2010-09-22 12:30:00 | ES | Futures | 1114.33 | 1114.58 | 1112.36 | 1112.85 | 47740.0 |
| 2010-09-22 13:00:00 | ES | Futures | 1112.61 | 1113.84 | 1110.63 | 1112.85 | 87161.0 |
| 2010-09-22 13:30:00 | ES | Futures | 1112.85 | 1115.07 | 1112.61 | 1114.08 | 58026.0 |
| 2010-09-22 14:00:00 | ES | Futures | 1113.84 | 1114.33 | 1112.11 | 1113.59 | 62956.0 |
| 2010-09-22 14:30:00 | ES | Futures | 1113.84 | 1116.8 | 1113.35 | 1116.06 | 100449.0 |
| 2010-09-22 15:00:00 | ES | Futures | 1116.3 | 1116.8 | 1112.36 | 1113.35 | 105120.0 |
| 2010-09-22 15:30:00 | ES | Futures | 1113.35 | 1115.56 | 1112.61 | 1114.08 | 135597.0 |
| 2010-09-22 16:00:00 | ES | Futures | 1114.08 | 1114.58 | 1113.59 | 1114.08 | 63110.0 |
| 2010-09-22 16:30:00 | ES | Futures | 1114.08 | 1115.81 | 1114.08 | 1115.56 | 3855.0 |
| 2010-09-22 17:00:00 | ES | Futures | 1115.56 | 1116.06 | 1114.82 | 1115.81 | 1658.0 |
| 2010-09-22 18:00:00 | ES | Futures | 1115.81 | 1116.55 | 1115.56 | 1116.06 | 1556.0 |
| 2010-09-22 18:30:00 | ES | Futures | 1116.06 | 1116.55 | 1115.81 | 1115.81 | 1089.0 |
| 2010-09-22 19:00:00 | ES | Futures | 1115.81 | 1116.06 | 1115.56 | 1115.81 | 658.0 |
| 2010-09-22 19:30:00 | ES | Futures | 1115.81 | 1115.81 | 1115.07 | 1115.56 | 885.0 |
| 2010-09-22 20:00:00 | ES | Futures | 1115.56 | 1115.81 | 1115.07 | 1115.56 | 889.0 |
| 2010-09-22 20:30:00 | ES | Futures | 1115.81 | 1116.55 | 1115.56 | 1116.55 | 1099.0 |
| 2010-09-22 21:00:00 | ES | Futures | 1116.3 | 1116.8 | 1116.3 | 1116.55 | 1121.0 |
| 2010-09-22 21:30:00 | ES | Futures | 1116.55 | 1117.29 | 1116.55 | 1116.8 | 1777.0 |
| 2010-09-22 22:00:00 | ES | Futures | 1116.8 | 1117.54 | 1116.55 | 1117.29 | 1060.0 |
| 2010-09-22 22:30:00 | ES | Futures | 1117.54 | 1117.78 | 1117.29 | 1117.54 | 1154.0 |
| 2010-09-22 23:00:00 | ES | Futures | 1117.54 | 1117.78 | 1117.54 | 1117.54 | 370.0 |
| 2010-09-22 23:30:00 | ES | Futures | 1117.78 | 1117.78 | 1116.8 | 1117.04 | 1054.0 |
| 2010-09-22 00:00:00 | NQ | Futures | 2284.32 | 2286.61 | 2284.32 | 2284.32 | 148.0 |
| 2010-09-22 00:30:00 | NQ | Futures | 2284.6 | 2286.61 | 2284.6 | 2286.33 | 74.0 |
| 2010-09-22 01:00:00 | NQ | Futures | 2286.04 | 2286.33 | 2285.18 | 2285.18 | 82.0 |
> showing 50 of 2,604 rows — these rows as CSV