PREVIEW / futures_1hour / 2013-10-15
file: by_date/futures_1hour/2013/2013-10-15.parquet size: 50 KB rows: 1,559
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.06 | 1755.0 |
| 2013-10-15 01:00:00 | ES | Futures | 1760.32 | 1760.58 | 1758.52 | 1758.52 | 4347.0 |
| 2013-10-15 02:00:00 | ES | Futures | 1758.52 | 1761.1 | 1758.52 | 1759.55 | 4952.0 |
| 2013-10-15 03:00:00 | ES | Futures | 1759.29 | 1760.06 | 1757.23 | 1757.48 | 16672.0 |
| 2013-10-15 04:00:00 | ES | Futures | 1757.74 | 1760.06 | 1757.48 | 1759.55 | 9115.0 |
| 2013-10-15 05:00:00 | ES | Futures | 1759.55 | 1762.64 | 1759.29 | 1761.1 | 15640.0 |
| 2013-10-15 06:00:00 | ES | Futures | 1761.1 | 1761.35 | 1759.81 | 1761.35 | 10958.0 |
| 2013-10-15 07:00:00 | ES | Futures | 1761.35 | 1761.61 | 1755.94 | 1755.94 | 30592.0 |
| 2013-10-15 08:00:00 | ES | Futures | 1755.94 | 1757.48 | 1754.39 | 1756.97 | 46223.0 |
| 2013-10-15 09:00:00 | ES | Futures | 1756.97 | 1758.52 | 1748.97 | 1754.65 | 327913.0 |
| 2013-10-15 10:00:00 | ES | Futures | 1754.65 | 1758.52 | 1752.58 | 1753.36 | 245825.0 |
| 2013-10-15 11:00:00 | ES | Futures | 1753.61 | 1760.84 | 1751.04 | 1756.45 | 265799.0 |
| 2013-10-15 12:00:00 | ES | Futures | 1756.45 | 1756.71 | 1753.1 | 1754.9 | 89974.0 |
| 2013-10-15 13:00:00 | ES | Futures | 1754.9 | 1755.94 | 1752.07 | 1754.39 | 77735.0 |
| 2013-10-15 14:00:00 | ES | Futures | 1754.39 | 1755.94 | 1743.3 | 1748.97 | 311609.0 |
| 2013-10-15 15:00:00 | ES | Futures | 1748.97 | 1753.36 | 1745.36 | 1745.62 | 268227.0 |
| 2013-10-15 16:00:00 | ES | Futures | 1745.62 | 1751.55 | 1745.1 | 1748.46 | 108087.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 | 1752.84 | 1745.36 | 1745.62 | 15730.0 |
| 2013-10-15 19:00:00 | ES | Futures | 1745.62 | 1758.52 | 1745.1 | 1758.0 | 24379.0 |
| 2013-10-15 20:00:00 | ES | Futures | 1758.0 | 1760.84 | 1755.16 | 1757.74 | 23786.0 |
| 2013-10-15 21:00:00 | ES | Futures | 1757.74 | 1758.52 | 1754.39 | 1755.68 | 9545.0 |
| 2013-10-15 22:00:00 | ES | Futures | 1755.68 | 1756.45 | 1752.58 | 1754.13 | 12863.0 |
| 2013-10-15 23:00:00 | ES | Futures | 1754.39 | 1757.48 | 1754.39 | 1754.9 | 6132.0 |
| 2013-10-15 00:00:00 | NQ | Futures | 3780.56 | 3781.43 | 3779.69 | 3779.98 | 473.0 |
| 2013-10-15 01:00:00 | NQ | Futures | 3779.98 | 3780.85 | 3775.04 | 3775.91 | 816.0 |
| 2013-10-15 02:00:00 | NQ | Futures | 3776.2 | 3782.3 | 3775.33 | 3779.11 | 1077.0 |
| 2013-10-15 03:00:00 | NQ | Futures | 3778.82 | 3781.43 | 3774.46 | 3774.46 | 3708.0 |
| 2013-10-15 04:00:00 | NQ | Futures | 3774.75 | 3779.69 | 3774.75 | 3778.82 | 2281.0 |
| 2013-10-15 05:00:00 | NQ | Futures | 3778.82 | 3785.21 | 3777.95 | 3782.3 | 2359.0 |
| 2013-10-15 06:00:00 | NQ | Futures | 3782.01 | 3783.46 | 3779.4 | 3782.88 | 1790.0 |
| 2013-10-15 07:00:00 | NQ | Futures | 3782.88 | 3784.34 | 3773.88 | 3773.88 | 3088.0 |
| 2013-10-15 08:00:00 | NQ | Futures | 3774.17 | 3779.11 | 3772.72 | 3778.82 | 4584.0 |
| 2013-10-15 09:00:00 | NQ | Futures | 3778.82 | 3781.72 | 3764.01 | 3779.11 | 60430.0 |
| 2013-10-15 10:00:00 | NQ | Futures | 3779.4 | 3784.34 | 3772.14 | 3774.17 | 38936.0 |
| 2013-10-15 11:00:00 | NQ | Futures | 3773.88 | 3791.31 | 3770.98 | 3780.56 | 46655.0 |
| 2013-10-15 12:00:00 | NQ | Futures | 3780.85 | 3782.01 | 3770.39 | 3776.78 | 20201.0 |
| 2013-10-15 13:00:00 | NQ | Futures | 3776.78 | 3781.43 | 3771.56 | 3779.11 | 18831.0 |
| 2013-10-15 14:00:00 | NQ | Futures | 3778.82 | 3783.17 | 3757.03 | 3766.91 | 55945.0 |
| 2013-10-15 15:00:00 | NQ | Futures | 3766.91 | 3776.2 | 3759.36 | 3762.26 | 48400.0 |
| 2013-10-15 16:00:00 | NQ | Futures | 3762.26 | 3776.2 | 3760.81 | 3768.07 | 13526.0 |
| 2013-10-15 17:00:00 | NQ | Futures | 3768.07 | 3768.94 | 3765.75 | 3766.33 | 204.0 |
| 2013-10-15 18:00:00 | NQ | Futures | 3764.59 | 3774.17 | 3757.91 | 3757.91 | 2074.0 |
| 2013-10-15 19:00:00 | NQ | Futures | 3757.91 | 3784.92 | 3757.91 | 3782.88 | 3706.0 |
| 2013-10-15 20:00:00 | NQ | Futures | 3782.01 | 3788.98 | 3776.78 | 3781.14 | 3176.0 |
| 2013-10-15 21:00:00 | NQ | Futures | 3781.72 | 3784.05 | 3774.46 | 3777.66 | 1810.0 |
| 2013-10-15 22:00:00 | NQ | Futures | 3777.37 | 3781.14 | 3772.43 | 3775.62 | 2657.0 |
| 2013-10-15 23:00:00 | NQ | Futures | 3775.91 | 3782.88 | 3775.91 | 3778.82 | 1033.0 |
| 2013-10-15 00:00:00 | YM | Futures | 15559.7 | 15564.8 | 15558.7 | 15560.7 | 292.0 |
| 2013-10-15 01:00:00 | YM | Futures | 15559.7 | 15561.8 | 15544.4 | 15545.4 | 933.0 |
> showing 50 of 1,559 rows — these rows as CSV