PREVIEW / futures_30min / 2013-10-16
file: by_date/futures_30min/2013/2013-10-16.parquet size: 78 KB rows: 2,904
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-16 00:00:00 | ES | Futures | 1755.16 | 1755.42 | 1754.13 | 1754.13 | 1735.0 |
| 2013-10-16 00:30:00 | ES | Futures | 1754.39 | 1754.9 | 1753.36 | 1754.65 | 1983.0 |
| 2013-10-16 01:00:00 | ES | Futures | 1754.65 | 1755.42 | 1753.1 | 1753.1 | 3771.0 |
| 2013-10-16 01:30:00 | ES | Futures | 1753.1 | 1753.87 | 1752.33 | 1753.61 | 3535.0 |
| 2013-10-16 02:00:00 | ES | Futures | 1753.61 | 1754.9 | 1753.36 | 1754.65 | 5085.0 |
| 2013-10-16 02:30:00 | ES | Futures | 1754.9 | 1755.42 | 1753.36 | 1753.87 | 8411.0 |
| 2013-10-16 03:00:00 | ES | Futures | 1753.87 | 1754.9 | 1751.04 | 1754.65 | 14694.0 |
| 2013-10-16 03:30:00 | ES | Futures | 1754.39 | 1755.42 | 1753.36 | 1753.61 | 8774.0 |
| 2013-10-16 04:00:00 | ES | Futures | 1753.36 | 1753.87 | 1752.07 | 1752.33 | 3545.0 |
| 2013-10-16 04:30:00 | ES | Futures | 1752.58 | 1754.13 | 1752.33 | 1753.36 | 6587.0 |
| 2013-10-16 05:00:00 | ES | Futures | 1753.61 | 1754.39 | 1753.1 | 1753.87 | 3165.0 |
| 2013-10-16 05:30:00 | ES | Futures | 1753.61 | 1753.87 | 1752.33 | 1753.36 | 4244.0 |
| 2013-10-16 06:00:00 | ES | Futures | 1753.1 | 1753.36 | 1751.29 | 1752.58 | 7356.0 |
| 2013-10-16 06:30:00 | ES | Futures | 1752.84 | 1752.84 | 1750.78 | 1752.33 | 5914.0 |
| 2013-10-16 07:00:00 | ES | Futures | 1752.07 | 1754.13 | 1751.81 | 1753.36 | 13719.0 |
| 2013-10-16 07:30:00 | ES | Futures | 1753.36 | 1753.87 | 1751.55 | 1752.07 | 8464.0 |
| 2013-10-16 08:00:00 | ES | Futures | 1752.33 | 1756.19 | 1752.07 | 1755.68 | 17859.0 |
| 2013-10-16 08:30:00 | ES | Futures | 1755.68 | 1758.0 | 1755.16 | 1757.23 | 22725.0 |
| 2013-10-16 09:00:00 | ES | Futures | 1757.48 | 1758.0 | 1756.19 | 1756.19 | 25893.0 |
| 2013-10-16 09:30:00 | ES | Futures | 1756.45 | 1768.06 | 1755.42 | 1766.25 | 314012.0 |
| 2013-10-16 10:00:00 | ES | Futures | 1766.25 | 1767.8 | 1762.64 | 1765.22 | 237972.0 |
| 2013-10-16 10:30:00 | ES | Futures | 1765.22 | 1769.61 | 1764.45 | 1769.35 | 115801.0 |
| 2013-10-16 11:00:00 | ES | Futures | 1769.35 | 1771.67 | 1767.03 | 1767.29 | 152942.0 |
| 2013-10-16 11:30:00 | ES | Futures | 1767.54 | 1770.38 | 1767.29 | 1769.35 | 68425.0 |
| 2013-10-16 12:00:00 | ES | Futures | 1769.35 | 1771.67 | 1768.06 | 1768.06 | 88636.0 |
| 2013-10-16 12:30:00 | ES | Futures | 1768.06 | 1769.35 | 1766.25 | 1767.54 | 84185.0 |
| 2013-10-16 13:00:00 | ES | Futures | 1767.54 | 1769.35 | 1766.0 | 1769.09 | 46796.0 |
| 2013-10-16 13:30:00 | ES | Futures | 1769.09 | 1770.38 | 1767.54 | 1767.54 | 40915.0 |
| 2013-10-16 14:00:00 | ES | Futures | 1767.8 | 1768.06 | 1764.97 | 1765.22 | 40849.0 |
| 2013-10-16 14:30:00 | ES | Futures | 1765.48 | 1767.03 | 1764.45 | 1766.0 | 48071.0 |
| 2013-10-16 15:00:00 | ES | Futures | 1766.0 | 1768.32 | 1764.19 | 1766.51 | 56247.0 |
| 2013-10-16 15:30:00 | ES | Futures | 1766.51 | 1771.41 | 1765.74 | 1770.64 | 137517.0 |
| 2013-10-16 16:00:00 | ES | Futures | 1770.64 | 1770.9 | 1767.03 | 1768.32 | 88642.0 |
| 2013-10-16 16:30:00 | ES | Futures | 1767.54 | 1767.8 | 1766.51 | 1766.77 | 11484.0 |
| 2013-10-16 17:00:00 | ES | Futures | 1766.51 | 1767.54 | 1766.51 | 1767.29 | 3052.0 |
| 2013-10-16 18:00:00 | ES | Futures | 1766.51 | 1766.77 | 1765.74 | 1766.0 | 9026.0 |
| 2013-10-16 18:30:00 | ES | Futures | 1765.74 | 1766.51 | 1765.22 | 1766.25 | 4013.0 |
| 2013-10-16 19:00:00 | ES | Futures | 1766.51 | 1769.87 | 1766.51 | 1769.61 | 6593.0 |
| 2013-10-16 19:30:00 | ES | Futures | 1769.61 | 1769.87 | 1768.06 | 1768.83 | 3091.0 |
| 2013-10-16 20:00:00 | ES | Futures | 1768.83 | 1769.35 | 1768.06 | 1769.09 | 4742.0 |
| 2013-10-16 20:30:00 | ES | Futures | 1769.09 | 1769.35 | 1768.58 | 1768.58 | 2187.0 |
| 2013-10-16 21:00:00 | ES | Futures | 1768.58 | 1769.35 | 1768.32 | 1769.09 | 2263.0 |
| 2013-10-16 21:30:00 | ES | Futures | 1769.09 | 1769.35 | 1767.8 | 1767.8 | 2022.0 |
| 2013-10-16 22:00:00 | ES | Futures | 1767.8 | 1769.09 | 1764.45 | 1766.77 | 12960.0 |
| 2013-10-16 22:30:00 | ES | Futures | 1766.77 | 1767.03 | 1766.25 | 1766.25 | 1400.0 |
| 2013-10-16 23:00:00 | ES | Futures | 1766.25 | 1767.54 | 1764.97 | 1767.54 | 3386.0 |
| 2013-10-16 23:30:00 | ES | Futures | 1767.29 | 1767.29 | 1766.77 | 1767.03 | 1197.0 |
| 2013-10-16 00:00:00 | NQ | Futures | 3779.11 | 3779.4 | 3776.2 | 3776.49 | 295.0 |
| 2013-10-16 00:30:00 | NQ | Futures | 3776.78 | 3779.11 | 3775.33 | 3778.24 | 289.0 |
| 2013-10-16 01:00:00 | NQ | Futures | 3777.95 | 3779.4 | 3774.17 | 3774.46 | 419.0 |
> showing 50 of 2,904 rows — these rows as CSV