PREVIEW / futures_30min / 2013-08-06
file: by_date/futures_30min/2013/2013-08-06.parquet size: 75 KB rows: 2,823
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 |
|---|---|---|---|---|---|---|---|
| 2013-08-06 00:00:00 | ES | Futures | 1756.73 | 1757.25 | 1756.47 | 1756.73 | 1091.0 |
| 2013-08-06 00:30:00 | ES | Futures | 1756.73 | 1757.51 | 1756.73 | 1757.25 | 1834.0 |
| 2013-08-06 01:00:00 | ES | Futures | 1757.25 | 1757.25 | 1756.47 | 1756.99 | 1346.0 |
| 2013-08-06 01:30:00 | ES | Futures | 1756.99 | 1757.76 | 1756.73 | 1757.76 | 1524.0 |
| 2013-08-06 02:00:00 | ES | Futures | 1757.51 | 1758.54 | 1757.51 | 1758.28 | 2918.0 |
| 2013-08-06 02:30:00 | ES | Futures | 1758.28 | 1758.8 | 1758.02 | 1758.28 | 1305.0 |
| 2013-08-06 03:00:00 | ES | Futures | 1758.28 | 1760.35 | 1757.76 | 1759.06 | 10412.0 |
| 2013-08-06 03:30:00 | ES | Futures | 1759.06 | 1759.57 | 1758.54 | 1759.32 | 6980.0 |
| 2013-08-06 04:00:00 | ES | Futures | 1759.57 | 1760.61 | 1759.32 | 1759.57 | 5410.0 |
| 2013-08-06 04:30:00 | ES | Futures | 1759.83 | 1760.35 | 1759.32 | 1760.09 | 3096.0 |
| 2013-08-06 05:00:00 | ES | Futures | 1759.83 | 1761.38 | 1759.83 | 1761.13 | 7256.0 |
| 2013-08-06 05:30:00 | ES | Futures | 1761.13 | 1761.38 | 1759.06 | 1759.57 | 5211.0 |
| 2013-08-06 06:00:00 | ES | Futures | 1759.57 | 1759.57 | 1756.99 | 1757.51 | 8224.0 |
| 2013-08-06 06:30:00 | ES | Futures | 1757.76 | 1758.02 | 1756.99 | 1756.99 | 6258.0 |
| 2013-08-06 07:00:00 | ES | Futures | 1757.25 | 1757.76 | 1756.47 | 1757.51 | 8343.0 |
| 2013-08-06 07:30:00 | ES | Futures | 1757.51 | 1758.02 | 1757.25 | 1757.25 | 7674.0 |
| 2013-08-06 08:00:00 | ES | Futures | 1757.51 | 1757.76 | 1756.47 | 1757.76 | 8965.0 |
| 2013-08-06 08:30:00 | ES | Futures | 1757.76 | 1758.8 | 1757.25 | 1757.51 | 11625.0 |
| 2013-08-06 09:00:00 | ES | Futures | 1757.51 | 1757.76 | 1755.7 | 1756.73 | 20632.0 |
| 2013-08-06 09:30:00 | ES | Futures | 1756.47 | 1758.28 | 1753.11 | 1754.66 | 155013.0 |
| 2013-08-06 10:00:00 | ES | Futures | 1754.92 | 1754.92 | 1751.3 | 1751.56 | 147463.0 |
| 2013-08-06 10:30:00 | ES | Futures | 1751.82 | 1751.82 | 1746.65 | 1746.65 | 194217.0 |
| 2013-08-06 11:00:00 | ES | Futures | 1746.91 | 1750.53 | 1746.13 | 1750.01 | 101919.0 |
| 2013-08-06 11:30:00 | ES | Futures | 1750.01 | 1750.79 | 1749.49 | 1750.53 | 49113.0 |
| 2013-08-06 12:00:00 | ES | Futures | 1750.53 | 1751.3 | 1748.72 | 1749.49 | 43744.0 |
| 2013-08-06 12:30:00 | ES | Futures | 1749.75 | 1752.34 | 1749.49 | 1752.34 | 33960.0 |
| 2013-08-06 13:00:00 | ES | Futures | 1752.34 | 1752.59 | 1751.56 | 1752.08 | 29517.0 |
| 2013-08-06 13:30:00 | ES | Futures | 1752.08 | 1752.34 | 1749.49 | 1749.75 | 34494.0 |
| 2013-08-06 14:00:00 | ES | Futures | 1750.01 | 1751.3 | 1748.2 | 1750.79 | 53869.0 |
| 2013-08-06 14:30:00 | ES | Futures | 1750.79 | 1751.3 | 1748.98 | 1750.01 | 42812.0 |
| 2013-08-06 15:00:00 | ES | Futures | 1750.01 | 1751.3 | 1749.49 | 1751.04 | 52712.0 |
| 2013-08-06 15:30:00 | ES | Futures | 1751.04 | 1752.08 | 1748.98 | 1750.53 | 108639.0 |
| 2013-08-06 16:00:00 | ES | Futures | 1750.53 | 1752.08 | 1750.27 | 1751.56 | 70424.0 |
| 2013-08-06 16:30:00 | ES | Futures | 1751.3 | 1751.56 | 1750.53 | 1751.04 | 4441.0 |
| 2013-08-06 17:00:00 | ES | Futures | 1751.04 | 1751.04 | 1750.01 | 1750.01 | 2382.0 |
| 2013-08-06 18:00:00 | ES | Futures | 1750.27 | 1751.04 | 1749.49 | 1750.01 | 2417.0 |
| 2013-08-06 18:30:00 | ES | Futures | 1750.01 | 1750.01 | 1749.49 | 1749.75 | 672.0 |
| 2013-08-06 19:00:00 | ES | Futures | 1749.75 | 1750.01 | 1748.98 | 1749.23 | 938.0 |
| 2013-08-06 19:30:00 | ES | Futures | 1749.49 | 1749.75 | 1748.72 | 1749.49 | 1144.0 |
| 2013-08-06 20:00:00 | ES | Futures | 1749.49 | 1749.75 | 1748.72 | 1749.49 | 1383.0 |
| 2013-08-06 20:30:00 | ES | Futures | 1749.49 | 1749.49 | 1748.72 | 1748.98 | 2126.0 |
| 2013-08-06 21:00:00 | ES | Futures | 1748.72 | 1748.98 | 1746.91 | 1747.94 | 4896.0 |
| 2013-08-06 21:30:00 | ES | Futures | 1747.94 | 1748.46 | 1747.68 | 1747.94 | 1732.0 |
| 2013-08-06 22:00:00 | ES | Futures | 1747.94 | 1748.72 | 1747.17 | 1748.46 | 1995.0 |
| 2013-08-06 22:30:00 | ES | Futures | 1748.46 | 1748.72 | 1748.2 | 1748.2 | 1260.0 |
| 2013-08-06 23:00:00 | ES | Futures | 1748.2 | 1748.98 | 1748.2 | 1748.46 | 878.0 |
| 2013-08-06 23:30:00 | ES | Futures | 1748.72 | 1748.98 | 1747.68 | 1747.94 | 1384.0 |
| 2013-08-06 00:00:00 | NQ | Futures | 3661.72 | 3662.3 | 3660.84 | 3661.72 | 73.0 |
| 2013-08-06 00:30:00 | NQ | Futures | 3662.01 | 3662.88 | 3661.42 | 3662.3 | 234.0 |
| 2013-08-06 01:00:00 | NQ | Futures | 3662.01 | 3662.01 | 3660.55 | 3661.42 | 124.0 |
> showing 50 of 2,823 rows — these rows as CSV