PREVIEW / futures_30min / 2011-06-22
file: by_date/futures_30min/2011/2011-06-22.parquet size: 76 KB rows: 2,742
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 |
|---|---|---|---|---|---|---|---|
| 2011-06-22 00:00:00 | ES | Futures | 1282.69 | 1282.94 | 1282.19 | 1282.94 | 1877.0 |
| 2011-06-22 00:30:00 | ES | Futures | 1282.94 | 1283.19 | 1282.19 | 1283.19 | 1373.0 |
| 2011-06-22 01:00:00 | ES | Futures | 1283.19 | 1283.44 | 1282.69 | 1282.94 | 1445.0 |
| 2011-06-22 01:30:00 | ES | Futures | 1283.19 | 1283.19 | 1282.19 | 1282.19 | 2753.0 |
| 2011-06-22 02:00:00 | ES | Futures | 1282.44 | 1284.44 | 1282.19 | 1284.44 | 6916.0 |
| 2011-06-22 02:30:00 | ES | Futures | 1284.44 | 1284.94 | 1283.19 | 1283.69 | 6744.0 |
| 2011-06-22 03:00:00 | ES | Futures | 1283.69 | 1283.94 | 1282.19 | 1283.19 | 13903.0 |
| 2011-06-22 03:30:00 | ES | Futures | 1283.44 | 1283.69 | 1280.95 | 1282.19 | 15235.0 |
| 2011-06-22 04:00:00 | ES | Futures | 1282.19 | 1283.69 | 1281.45 | 1282.94 | 9001.0 |
| 2011-06-22 04:30:00 | ES | Futures | 1282.94 | 1283.19 | 1281.45 | 1282.44 | 7627.0 |
| 2011-06-22 05:00:00 | ES | Futures | 1282.69 | 1282.69 | 1280.7 | 1281.7 | 10138.0 |
| 2011-06-22 05:30:00 | ES | Futures | 1281.94 | 1282.19 | 1279.2 | 1279.7 | 14151.0 |
| 2011-06-22 06:00:00 | ES | Futures | 1279.7 | 1280.7 | 1278.95 | 1280.2 | 10487.0 |
| 2011-06-22 06:30:00 | ES | Futures | 1280.2 | 1281.45 | 1279.7 | 1279.95 | 15266.0 |
| 2011-06-22 07:00:00 | ES | Futures | 1279.95 | 1281.7 | 1279.95 | 1281.2 | 11111.0 |
| 2011-06-22 07:30:00 | ES | Futures | 1281.2 | 1284.19 | 1280.45 | 1283.94 | 19878.0 |
| 2011-06-22 08:00:00 | ES | Futures | 1284.19 | 1284.44 | 1281.7 | 1282.44 | 22138.0 |
| 2011-06-22 08:30:00 | ES | Futures | 1282.19 | 1282.94 | 1279.95 | 1281.2 | 38714.0 |
| 2011-06-22 09:00:00 | ES | Futures | 1281.2 | 1283.94 | 1281.2 | 1282.94 | 22911.0 |
| 2011-06-22 09:30:00 | ES | Futures | 1282.94 | 1287.93 | 1281.7 | 1287.43 | 198172.0 |
| 2011-06-22 10:00:00 | ES | Futures | 1287.18 | 1288.43 | 1283.94 | 1286.18 | 130714.0 |
| 2011-06-22 10:30:00 | ES | Futures | 1285.93 | 1290.67 | 1285.93 | 1289.68 | 155745.0 |
| 2011-06-22 11:00:00 | ES | Futures | 1289.43 | 1289.93 | 1287.93 | 1288.68 | 101029.0 |
| 2011-06-22 11:30:00 | ES | Futures | 1288.93 | 1289.18 | 1287.18 | 1287.18 | 86463.0 |
| 2011-06-22 12:00:00 | ES | Futures | 1287.18 | 1288.43 | 1285.69 | 1287.43 | 58179.0 |
| 2011-06-22 12:30:00 | ES | Futures | 1287.43 | 1289.68 | 1284.44 | 1288.93 | 91400.0 |
| 2011-06-22 13:00:00 | ES | Futures | 1288.93 | 1288.93 | 1287.43 | 1288.18 | 30861.0 |
| 2011-06-22 13:30:00 | ES | Futures | 1288.18 | 1289.43 | 1287.93 | 1289.18 | 32228.0 |
| 2011-06-22 14:00:00 | ES | Futures | 1289.43 | 1290.17 | 1286.43 | 1287.43 | 98399.0 |
| 2011-06-22 14:30:00 | ES | Futures | 1287.68 | 1287.93 | 1283.44 | 1283.94 | 117483.0 |
| 2011-06-22 15:00:00 | ES | Futures | 1284.19 | 1286.18 | 1283.44 | 1284.19 | 93441.0 |
| 2011-06-22 15:30:00 | ES | Futures | 1284.19 | 1284.19 | 1278.2 | 1278.95 | 271150.0 |
| 2011-06-22 16:00:00 | ES | Futures | 1279.2 | 1279.2 | 1276.46 | 1276.46 | 117122.0 |
| 2011-06-22 16:30:00 | ES | Futures | 1276.96 | 1277.7 | 1275.71 | 1276.46 | 11041.0 |
| 2011-06-22 17:00:00 | ES | Futures | 1276.46 | 1276.96 | 1275.21 | 1275.46 | 4795.0 |
| 2011-06-22 18:00:00 | ES | Futures | 1276.21 | 1276.46 | 1272.72 | 1272.97 | 8783.0 |
| 2011-06-22 18:30:00 | ES | Futures | 1272.97 | 1273.96 | 1272.22 | 1272.47 | 6525.0 |
| 2011-06-22 19:00:00 | ES | Futures | 1272.72 | 1272.97 | 1271.47 | 1272.22 | 4313.0 |
| 2011-06-22 19:30:00 | ES | Futures | 1272.47 | 1273.22 | 1272.22 | 1272.97 | 4079.0 |
| 2011-06-22 20:00:00 | ES | Futures | 1272.72 | 1274.21 | 1272.72 | 1273.96 | 3244.0 |
| 2011-06-22 20:30:00 | ES | Futures | 1273.96 | 1274.21 | 1271.72 | 1273.71 | 5641.0 |
| 2011-06-22 21:00:00 | ES | Futures | 1273.46 | 1274.46 | 1271.72 | 1273.71 | 5402.0 |
| 2011-06-22 21:30:00 | ES | Futures | 1273.46 | 1273.71 | 1272.22 | 1273.22 | 3033.0 |
| 2011-06-22 22:00:00 | ES | Futures | 1272.97 | 1273.46 | 1271.97 | 1273.46 | 3890.0 |
| 2011-06-22 22:30:00 | ES | Futures | 1273.22 | 1273.46 | 1271.97 | 1273.22 | 5484.0 |
| 2011-06-22 23:00:00 | ES | Futures | 1273.22 | 1273.71 | 1272.97 | 1273.46 | 1392.0 |
| 2011-06-22 23:30:00 | ES | Futures | 1273.22 | 1273.46 | 1271.97 | 1272.22 | 1448.0 |
| 2011-06-22 00:00:00 | NQ | Futures | 2575.5 | 2576.36 | 2574.92 | 2576.07 | 183.0 |
| 2011-06-22 00:30:00 | NQ | Futures | 2575.79 | 2576.94 | 2574.64 | 2576.94 | 194.0 |
| 2011-06-22 01:00:00 | NQ | Futures | 2576.94 | 2578.09 | 2575.79 | 2576.65 | 161.0 |
> showing 50 of 2,742 rows — these rows as CSV