PREVIEW / futures_30min / 2011-06-07
file: by_date/futures_30min/2011/2011-06-07.parquet size: 73 KB rows: 2,679
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-07 00:00:00 | ES | Futures | 1278.92 | 1280.16 | 1278.92 | 1279.67 | 3546.0 |
| 2011-06-07 00:30:00 | ES | Futures | 1279.42 | 1279.91 | 1278.42 | 1279.67 | 3346.0 |
| 2011-06-07 01:00:00 | ES | Futures | 1279.42 | 1279.91 | 1278.18 | 1279.91 | 3496.0 |
| 2011-06-07 01:30:00 | ES | Futures | 1279.91 | 1280.91 | 1279.67 | 1280.66 | 5009.0 |
| 2011-06-07 02:00:00 | ES | Futures | 1280.66 | 1281.65 | 1280.41 | 1281.4 | 6851.0 |
| 2011-06-07 02:30:00 | ES | Futures | 1281.4 | 1282.15 | 1280.66 | 1281.9 | 10244.0 |
| 2011-06-07 03:00:00 | ES | Futures | 1281.65 | 1284.39 | 1281.16 | 1283.14 | 26329.0 |
| 2011-06-07 03:30:00 | ES | Futures | 1283.39 | 1284.39 | 1282.4 | 1283.64 | 13660.0 |
| 2011-06-07 04:00:00 | ES | Futures | 1283.64 | 1284.39 | 1282.9 | 1283.39 | 10642.0 |
| 2011-06-07 04:30:00 | ES | Futures | 1283.39 | 1285.13 | 1283.39 | 1284.39 | 10937.0 |
| 2011-06-07 05:00:00 | ES | Futures | 1284.39 | 1284.88 | 1282.4 | 1282.65 | 8381.0 |
| 2011-06-07 05:30:00 | ES | Futures | 1282.65 | 1283.39 | 1281.9 | 1282.9 | 8316.0 |
| 2011-06-07 06:00:00 | ES | Futures | 1282.9 | 1285.63 | 1282.65 | 1285.38 | 16910.0 |
| 2011-06-07 06:30:00 | ES | Futures | 1285.38 | 1285.63 | 1283.89 | 1283.89 | 12604.0 |
| 2011-06-07 07:00:00 | ES | Futures | 1283.89 | 1284.14 | 1281.9 | 1282.4 | 18012.0 |
| 2011-06-07 07:30:00 | ES | Futures | 1282.15 | 1283.39 | 1282.15 | 1282.4 | 11392.0 |
| 2011-06-07 08:00:00 | ES | Futures | 1282.4 | 1283.39 | 1281.16 | 1282.9 | 28852.0 |
| 2011-06-07 08:30:00 | ES | Futures | 1282.9 | 1284.39 | 1281.9 | 1284.39 | 21407.0 |
| 2011-06-07 09:00:00 | ES | Futures | 1284.39 | 1285.13 | 1283.39 | 1283.64 | 28719.0 |
| 2011-06-07 09:30:00 | ES | Futures | 1283.39 | 1283.89 | 1280.16 | 1281.9 | 240896.0 |
| 2011-06-07 10:00:00 | ES | Futures | 1281.9 | 1285.63 | 1281.9 | 1283.89 | 182133.0 |
| 2011-06-07 10:30:00 | ES | Futures | 1284.14 | 1286.62 | 1282.9 | 1285.38 | 161931.0 |
| 2011-06-07 11:00:00 | ES | Futures | 1285.63 | 1285.88 | 1282.9 | 1283.14 | 109089.0 |
| 2011-06-07 11:30:00 | ES | Futures | 1283.14 | 1283.64 | 1281.16 | 1283.39 | 132502.0 |
| 2011-06-07 12:00:00 | ES | Futures | 1283.14 | 1284.39 | 1281.9 | 1283.39 | 50030.0 |
| 2011-06-07 12:30:00 | ES | Futures | 1283.39 | 1284.63 | 1281.65 | 1284.39 | 58167.0 |
| 2011-06-07 13:00:00 | ES | Futures | 1284.14 | 1285.63 | 1283.39 | 1284.14 | 52773.0 |
| 2011-06-07 13:30:00 | ES | Futures | 1283.89 | 1285.38 | 1283.64 | 1284.14 | 35114.0 |
| 2011-06-07 14:00:00 | ES | Futures | 1284.39 | 1287.37 | 1283.89 | 1286.87 | 71299.0 |
| 2011-06-07 14:30:00 | ES | Futures | 1286.62 | 1286.87 | 1283.39 | 1284.63 | 68966.0 |
| 2011-06-07 15:00:00 | ES | Futures | 1284.63 | 1285.38 | 1281.4 | 1282.4 | 83238.0 |
| 2011-06-07 15:30:00 | ES | Futures | 1282.15 | 1282.4 | 1275.19 | 1275.94 | 342142.0 |
| 2011-06-07 16:00:00 | ES | Futures | 1275.69 | 1277.43 | 1274.45 | 1276.68 | 118850.0 |
| 2011-06-07 16:30:00 | ES | Futures | 1276.93 | 1277.93 | 1276.44 | 1277.68 | 9986.0 |
| 2011-06-07 17:00:00 | ES | Futures | 1277.43 | 1279.17 | 1277.18 | 1278.92 | 3889.0 |
| 2011-06-07 18:00:00 | ES | Futures | 1278.92 | 1279.42 | 1278.18 | 1278.42 | 3586.0 |
| 2011-06-07 18:30:00 | ES | Futures | 1278.18 | 1278.92 | 1277.93 | 1278.18 | 1348.0 |
| 2011-06-07 19:00:00 | ES | Futures | 1278.18 | 1278.92 | 1278.18 | 1278.67 | 702.0 |
| 2011-06-07 19:30:00 | ES | Futures | 1278.67 | 1279.17 | 1278.42 | 1278.67 | 934.0 |
| 2011-06-07 20:00:00 | ES | Futures | 1278.67 | 1279.67 | 1277.93 | 1278.18 | 3229.0 |
| 2011-06-07 20:30:00 | ES | Futures | 1277.93 | 1278.18 | 1276.19 | 1276.44 | 4945.0 |
| 2011-06-07 21:00:00 | ES | Futures | 1276.68 | 1276.93 | 1274.7 | 1275.94 | 6607.0 |
| 2011-06-07 21:30:00 | ES | Futures | 1275.69 | 1276.19 | 1273.95 | 1274.2 | 3352.0 |
| 2011-06-07 22:00:00 | ES | Futures | 1273.95 | 1274.7 | 1273.21 | 1273.21 | 5645.0 |
| 2011-06-07 22:30:00 | ES | Futures | 1273.21 | 1273.95 | 1272.96 | 1273.45 | 4239.0 |
| 2011-06-07 23:00:00 | ES | Futures | 1273.7 | 1274.7 | 1273.45 | 1274.45 | 2838.0 |
| 2011-06-07 23:30:00 | ES | Futures | 1274.45 | 1274.95 | 1274.2 | 1274.45 | 1108.0 |
| 2011-06-07 00:00:00 | NQ | Futures | 2615.71 | 2618.01 | 2615.71 | 2617.15 | 192.0 |
| 2011-06-07 00:30:00 | NQ | Futures | 2617.15 | 2617.15 | 2615.14 | 2616.86 | 118.0 |
| 2011-06-07 01:00:00 | NQ | Futures | 2616.86 | 2617.15 | 2614.28 | 2616.58 | 541.0 |
> showing 50 of 2,679 rows — these rows as CSV