PREVIEW / futures_30min / 2011-06-21
file: by_date/futures_30min/2011/2011-06-21.parquet size: 74 KB rows: 2,718
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-21 00:00:00 | ES | Futures | 1269.47 | 1269.72 | 1268.73 | 1269.22 | 1437.0 |
| 2011-06-21 00:30:00 | ES | Futures | 1269.22 | 1271.47 | 1268.98 | 1270.97 | 1914.0 |
| 2011-06-21 01:00:00 | ES | Futures | 1270.97 | 1272.97 | 1270.97 | 1272.22 | 2242.0 |
| 2011-06-21 01:30:00 | ES | Futures | 1272.47 | 1272.47 | 1271.72 | 1271.97 | 1285.0 |
| 2011-06-21 02:00:00 | ES | Futures | 1271.72 | 1274.71 | 1271.47 | 1274.46 | 9665.0 |
| 2011-06-21 02:30:00 | ES | Futures | 1274.71 | 1275.21 | 1273.46 | 1274.21 | 5850.0 |
| 2011-06-21 03:00:00 | ES | Futures | 1274.46 | 1275.96 | 1273.46 | 1274.96 | 13769.0 |
| 2011-06-21 03:30:00 | ES | Futures | 1275.21 | 1277.95 | 1274.96 | 1276.71 | 15855.0 |
| 2011-06-21 04:00:00 | ES | Futures | 1276.71 | 1277.95 | 1276.21 | 1277.21 | 10614.0 |
| 2011-06-21 04:30:00 | ES | Futures | 1277.21 | 1277.7 | 1276.46 | 1276.71 | 5196.0 |
| 2011-06-21 05:00:00 | ES | Futures | 1276.71 | 1276.71 | 1274.46 | 1275.71 | 9924.0 |
| 2011-06-21 05:30:00 | ES | Futures | 1275.71 | 1275.96 | 1274.96 | 1275.21 | 4803.0 |
| 2011-06-21 06:00:00 | ES | Futures | 1275.21 | 1276.96 | 1274.46 | 1276.96 | 7280.0 |
| 2011-06-21 06:30:00 | ES | Futures | 1276.96 | 1277.7 | 1276.71 | 1276.71 | 5323.0 |
| 2011-06-21 07:00:00 | ES | Futures | 1276.71 | 1277.46 | 1274.96 | 1276.46 | 19329.0 |
| 2011-06-21 07:30:00 | ES | Futures | 1276.46 | 1278.7 | 1275.96 | 1277.46 | 25637.0 |
| 2011-06-21 08:00:00 | ES | Futures | 1277.7 | 1278.2 | 1276.96 | 1277.7 | 27151.0 |
| 2011-06-21 08:30:00 | ES | Futures | 1277.7 | 1277.95 | 1275.71 | 1276.71 | 23545.0 |
| 2011-06-21 09:00:00 | ES | Futures | 1276.46 | 1276.96 | 1275.46 | 1276.21 | 22074.0 |
| 2011-06-21 09:30:00 | ES | Futures | 1276.21 | 1278.7 | 1274.46 | 1277.7 | 195714.0 |
| 2011-06-21 10:00:00 | ES | Futures | 1277.7 | 1282.44 | 1277.7 | 1281.7 | 199618.0 |
| 2011-06-21 10:30:00 | ES | Futures | 1281.7 | 1284.19 | 1280.45 | 1283.69 | 152441.0 |
| 2011-06-21 11:00:00 | ES | Futures | 1283.69 | 1286.43 | 1282.69 | 1286.18 | 153146.0 |
| 2011-06-21 11:30:00 | ES | Futures | 1285.93 | 1288.18 | 1285.93 | 1286.43 | 184019.0 |
| 2011-06-21 12:00:00 | ES | Futures | 1286.68 | 1287.43 | 1285.44 | 1285.93 | 102466.0 |
| 2011-06-21 12:30:00 | ES | Futures | 1285.93 | 1286.68 | 1284.94 | 1286.18 | 77026.0 |
| 2011-06-21 13:00:00 | ES | Futures | 1286.18 | 1286.18 | 1283.69 | 1283.69 | 103416.0 |
| 2011-06-21 13:30:00 | ES | Futures | 1283.94 | 1284.94 | 1283.19 | 1284.44 | 64620.0 |
| 2011-06-21 14:00:00 | ES | Futures | 1284.44 | 1286.93 | 1284.44 | 1286.68 | 80414.0 |
| 2011-06-21 14:30:00 | ES | Futures | 1286.68 | 1289.68 | 1286.43 | 1288.68 | 118928.0 |
| 2011-06-21 15:00:00 | ES | Futures | 1288.93 | 1289.18 | 1286.43 | 1286.43 | 78482.0 |
| 2011-06-21 15:30:00 | ES | Futures | 1286.43 | 1288.43 | 1284.94 | 1286.68 | 214797.0 |
| 2011-06-21 16:00:00 | ES | Futures | 1286.93 | 1287.18 | 1283.94 | 1284.19 | 99505.0 |
| 2011-06-21 16:30:00 | ES | Futures | 1284.69 | 1285.69 | 1284.19 | 1285.69 | 8174.0 |
| 2011-06-21 17:00:00 | ES | Futures | 1285.44 | 1286.18 | 1283.19 | 1285.44 | 4948.0 |
| 2011-06-21 18:00:00 | ES | Futures | 1286.43 | 1286.43 | 1283.19 | 1285.19 | 16942.0 |
| 2011-06-21 18:30:00 | ES | Futures | 1285.19 | 1285.44 | 1284.44 | 1285.19 | 2361.0 |
| 2011-06-21 19:00:00 | ES | Futures | 1284.94 | 1285.44 | 1283.94 | 1285.44 | 1882.0 |
| 2011-06-21 19:30:00 | ES | Futures | 1285.69 | 1286.43 | 1285.19 | 1285.69 | 2038.0 |
| 2011-06-21 20:00:00 | ES | Futures | 1285.69 | 1286.68 | 1285.44 | 1285.69 | 2878.0 |
| 2011-06-21 20:30:00 | ES | Futures | 1285.93 | 1285.93 | 1284.69 | 1285.69 | 1407.0 |
| 2011-06-21 21:00:00 | ES | Futures | 1285.44 | 1285.69 | 1282.94 | 1283.69 | 3781.0 |
| 2011-06-21 21:30:00 | ES | Futures | 1283.44 | 1283.69 | 1282.44 | 1282.94 | 4079.0 |
| 2011-06-21 22:00:00 | ES | Futures | 1282.94 | 1284.44 | 1282.44 | 1283.19 | 2958.0 |
| 2011-06-21 22:30:00 | ES | Futures | 1283.19 | 1283.69 | 1282.44 | 1283.69 | 1018.0 |
| 2011-06-21 23:00:00 | ES | Futures | 1283.69 | 1283.69 | 1282.19 | 1282.19 | 1606.0 |
| 2011-06-21 23:30:00 | ES | Futures | 1282.19 | 1282.94 | 1281.94 | 1282.69 | 1125.0 |
| 2011-06-21 00:00:00 | NQ | Futures | 2531.18 | 2531.47 | 2530.03 | 2530.61 | 136.0 |
| 2011-06-21 00:30:00 | NQ | Futures | 2530.61 | 2533.77 | 2530.03 | 2533.49 | 330.0 |
| 2011-06-21 01:00:00 | NQ | Futures | 2533.49 | 2535.79 | 2533.49 | 2535.21 | 313.0 |
> showing 50 of 2,718 rows — these rows as CSV