PREVIEW / futures_30min / 2013-10-15
file: by_date/futures_30min/2013/2013-10-15.parquet size: 77 KB rows: 2,919
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-10-15 00:00:00 | ES | Futures | 1760.32 | 1760.84 | 1760.06 | 1760.32 | 578.0 |
| 2013-10-15 00:30:00 | ES | Futures | 1760.32 | 1760.84 | 1760.06 | 1760.06 | 1177.0 |
| 2013-10-15 01:00:00 | ES | Futures | 1760.32 | 1760.58 | 1759.29 | 1759.81 | 1750.0 |
| 2013-10-15 01:30:00 | ES | Futures | 1759.55 | 1759.55 | 1758.52 | 1758.52 | 2597.0 |
| 2013-10-15 02:00:00 | ES | Futures | 1758.52 | 1760.84 | 1758.52 | 1760.84 | 3212.0 |
| 2013-10-15 02:30:00 | ES | Futures | 1760.58 | 1761.1 | 1759.29 | 1759.55 | 1740.0 |
| 2013-10-15 03:00:00 | ES | Futures | 1759.29 | 1760.06 | 1758.26 | 1758.52 | 7376.0 |
| 2013-10-15 03:30:00 | ES | Futures | 1758.26 | 1759.81 | 1757.23 | 1757.48 | 9296.0 |
| 2013-10-15 04:00:00 | ES | Futures | 1757.74 | 1759.29 | 1757.48 | 1758.77 | 5030.0 |
| 2013-10-15 04:30:00 | ES | Futures | 1758.77 | 1760.06 | 1758.52 | 1759.55 | 4085.0 |
| 2013-10-15 05:00:00 | ES | Futures | 1759.55 | 1762.39 | 1759.29 | 1762.39 | 10160.0 |
| 2013-10-15 05:30:00 | ES | Futures | 1762.13 | 1762.64 | 1761.1 | 1761.1 | 5480.0 |
| 2013-10-15 06:00:00 | ES | Futures | 1761.1 | 1761.35 | 1759.81 | 1760.32 | 4842.0 |
| 2013-10-15 06:30:00 | ES | Futures | 1760.32 | 1761.35 | 1759.81 | 1761.35 | 6116.0 |
| 2013-10-15 07:00:00 | ES | Futures | 1761.35 | 1761.61 | 1759.29 | 1760.32 | 8406.0 |
| 2013-10-15 07:30:00 | ES | Futures | 1760.32 | 1760.32 | 1755.94 | 1755.94 | 22186.0 |
| 2013-10-15 08:00:00 | ES | Futures | 1755.94 | 1757.48 | 1754.39 | 1755.68 | 24781.0 |
| 2013-10-15 08:30:00 | ES | Futures | 1755.68 | 1757.48 | 1755.16 | 1756.97 | 21442.0 |
| 2013-10-15 09:00:00 | ES | Futures | 1756.97 | 1758.52 | 1751.29 | 1754.39 | 85796.0 |
| 2013-10-15 09:30:00 | ES | Futures | 1754.13 | 1756.19 | 1748.97 | 1754.65 | 242117.0 |
| 2013-10-15 10:00:00 | ES | Futures | 1754.65 | 1758.0 | 1752.58 | 1757.48 | 143184.0 |
| 2013-10-15 10:30:00 | ES | Futures | 1757.23 | 1758.52 | 1752.84 | 1753.36 | 102641.0 |
| 2013-10-15 11:00:00 | ES | Futures | 1753.61 | 1760.84 | 1751.04 | 1759.29 | 182541.0 |
| 2013-10-15 11:30:00 | ES | Futures | 1759.03 | 1760.06 | 1754.39 | 1756.45 | 83258.0 |
| 2013-10-15 12:00:00 | ES | Futures | 1756.45 | 1756.71 | 1753.1 | 1754.65 | 47162.0 |
| 2013-10-15 12:30:00 | ES | Futures | 1754.39 | 1756.71 | 1753.61 | 1754.9 | 42812.0 |
| 2013-10-15 13:00:00 | ES | Futures | 1754.9 | 1755.94 | 1752.58 | 1752.84 | 36127.0 |
| 2013-10-15 13:30:00 | ES | Futures | 1753.1 | 1755.42 | 1752.07 | 1754.39 | 41608.0 |
| 2013-10-15 14:00:00 | ES | Futures | 1754.39 | 1755.94 | 1749.49 | 1750.0 | 93907.0 |
| 2013-10-15 14:30:00 | ES | Futures | 1750.0 | 1750.26 | 1743.3 | 1748.97 | 217702.0 |
| 2013-10-15 15:00:00 | ES | Futures | 1748.97 | 1753.36 | 1747.42 | 1751.55 | 129813.0 |
| 2013-10-15 15:30:00 | ES | Futures | 1751.55 | 1751.81 | 1745.36 | 1745.62 | 138414.0 |
| 2013-10-15 16:00:00 | ES | Futures | 1745.62 | 1747.94 | 1745.62 | 1746.13 | 69609.0 |
| 2013-10-15 16:30:00 | ES | Futures | 1746.91 | 1751.55 | 1745.1 | 1748.46 | 38478.0 |
| 2013-10-15 17:00:00 | ES | Futures | 1748.46 | 1749.49 | 1747.68 | 1748.71 | 3042.0 |
| 2013-10-15 18:00:00 | ES | Futures | 1748.2 | 1749.75 | 1746.91 | 1747.42 | 6086.0 |
| 2013-10-15 18:30:00 | ES | Futures | 1747.42 | 1752.84 | 1745.36 | 1745.62 | 9644.0 |
| 2013-10-15 19:00:00 | ES | Futures | 1745.62 | 1751.55 | 1745.1 | 1751.29 | 6812.0 |
| 2013-10-15 19:30:00 | ES | Futures | 1751.29 | 1758.52 | 1750.0 | 1758.0 | 17567.0 |
| 2013-10-15 20:00:00 | ES | Futures | 1758.0 | 1760.84 | 1755.16 | 1757.74 | 19054.0 |
| 2013-10-15 20:30:00 | ES | Futures | 1757.48 | 1759.29 | 1756.45 | 1757.74 | 4732.0 |
| 2013-10-15 21:00:00 | ES | Futures | 1757.74 | 1758.52 | 1756.45 | 1757.48 | 4233.0 |
| 2013-10-15 21:30:00 | ES | Futures | 1757.48 | 1757.74 | 1754.39 | 1755.68 | 5312.0 |
| 2013-10-15 22:00:00 | ES | Futures | 1755.68 | 1756.45 | 1752.58 | 1753.1 | 7054.0 |
| 2013-10-15 22:30:00 | ES | Futures | 1752.84 | 1756.45 | 1752.84 | 1754.13 | 5809.0 |
| 2013-10-15 23:00:00 | ES | Futures | 1754.39 | 1757.48 | 1754.39 | 1756.45 | 3244.0 |
| 2013-10-15 23:30:00 | ES | Futures | 1756.19 | 1756.97 | 1754.65 | 1754.9 | 2888.0 |
| 2013-10-15 00:00:00 | NQ | Futures | 3780.56 | 3781.43 | 3779.69 | 3780.56 | 147.0 |
| 2013-10-15 00:30:00 | NQ | Futures | 3780.56 | 3781.43 | 3779.69 | 3779.98 | 326.0 |
| 2013-10-15 01:00:00 | NQ | Futures | 3779.98 | 3780.85 | 3777.95 | 3777.95 | 432.0 |
> showing 50 of 2,919 rows — these rows as CSV