PREVIEW / futures_1hour / 2013-10-11
file: by_date/futures_1hour/2013/2013-10-11.parquet size: 41 KB rows: 1,243
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-11 00:00:00 | ES | Futures | 1740.46 | 1740.46 | 1739.17 | 1739.17 | 3158.0 |
| 2013-10-11 01:00:00 | ES | Futures | 1739.43 | 1740.97 | 1738.91 | 1740.72 | 5500.0 |
| 2013-10-11 02:00:00 | ES | Futures | 1740.46 | 1740.72 | 1738.65 | 1740.2 | 7078.0 |
| 2013-10-11 03:00:00 | ES | Futures | 1740.2 | 1740.2 | 1736.85 | 1737.88 | 17810.0 |
| 2013-10-11 04:00:00 | ES | Futures | 1737.88 | 1741.49 | 1737.88 | 1741.23 | 17167.0 |
| 2013-10-11 05:00:00 | ES | Futures | 1740.97 | 1741.75 | 1739.69 | 1740.46 | 12519.0 |
| 2013-10-11 06:00:00 | ES | Futures | 1740.46 | 1740.97 | 1738.14 | 1739.94 | 16220.0 |
| 2013-10-11 07:00:00 | ES | Futures | 1739.94 | 1741.23 | 1738.91 | 1739.43 | 18675.0 |
| 2013-10-11 08:00:00 | ES | Futures | 1739.17 | 1739.69 | 1736.33 | 1737.36 | 35631.0 |
| 2013-10-11 09:00:00 | ES | Futures | 1737.36 | 1744.07 | 1735.3 | 1744.07 | 179782.0 |
| 2013-10-11 10:00:00 | ES | Futures | 1744.07 | 1745.36 | 1739.17 | 1742.01 | 248384.0 |
| 2013-10-11 11:00:00 | ES | Futures | 1742.01 | 1748.46 | 1740.97 | 1747.94 | 194490.0 |
| 2013-10-11 12:00:00 | ES | Futures | 1747.94 | 1751.81 | 1747.68 | 1750.78 | 170606.0 |
| 2013-10-11 13:00:00 | ES | Futures | 1750.78 | 1752.33 | 1748.2 | 1750.0 | 133437.0 |
| 2013-10-11 14:00:00 | ES | Futures | 1750.0 | 1751.29 | 1748.97 | 1749.75 | 68960.0 |
| 2013-10-11 15:00:00 | ES | Futures | 1749.49 | 1752.07 | 1746.65 | 1751.55 | 208381.0 |
| 2013-10-11 16:00:00 | ES | Futures | 1751.55 | 1754.13 | 1751.04 | 1753.61 | 107997.0 |
| 2013-10-11 17:00:00 | ES | Futures | 1753.87 | 1754.39 | 1753.61 | 1754.13 | 2952.0 |
| 2013-10-11 00:00:00 | NQ | Futures | 3716.66 | 3716.66 | 3714.05 | 3714.34 | 458.0 |
| 2013-10-11 01:00:00 | NQ | Futures | 3713.76 | 3716.37 | 3712.02 | 3716.37 | 1026.0 |
| 2013-10-11 02:00:00 | NQ | Futures | 3715.79 | 3715.79 | 3711.44 | 3715.5 | 1135.0 |
| 2013-10-11 03:00:00 | NQ | Futures | 3715.21 | 3715.21 | 3709.11 | 3711.44 | 3354.0 |
| 2013-10-11 04:00:00 | NQ | Futures | 3711.15 | 3719.57 | 3710.28 | 3718.99 | 2343.0 |
| 2013-10-11 05:00:00 | NQ | Futures | 3718.7 | 3719.86 | 3715.5 | 3717.54 | 1275.0 |
| 2013-10-11 06:00:00 | NQ | Futures | 3717.54 | 3718.12 | 3711.73 | 3714.34 | 1543.0 |
| 2013-10-11 07:00:00 | NQ | Futures | 3714.63 | 3716.08 | 3711.73 | 3712.31 | 2174.0 |
| 2013-10-11 08:00:00 | NQ | Futures | 3712.31 | 3712.89 | 3708.24 | 3712.02 | 4511.0 |
| 2013-10-11 09:00:00 | NQ | Futures | 3711.73 | 3732.64 | 3708.53 | 3731.48 | 33130.0 |
| 2013-10-11 10:00:00 | NQ | Futures | 3731.48 | 3735.54 | 3721.6 | 3728.86 | 37163.0 |
| 2013-10-11 11:00:00 | NQ | Futures | 3728.86 | 3745.13 | 3724.8 | 3744.55 | 30265.0 |
| 2013-10-11 12:00:00 | NQ | Futures | 3744.26 | 3750.94 | 3743.38 | 3748.61 | 22047.0 |
| 2013-10-11 13:00:00 | NQ | Futures | 3748.61 | 3752.39 | 3743.38 | 3747.74 | 22747.0 |
| 2013-10-11 14:00:00 | NQ | Futures | 3748.03 | 3751.81 | 3744.84 | 3746.58 | 12300.0 |
| 2013-10-11 15:00:00 | NQ | Futures | 3746.29 | 3749.19 | 3740.48 | 3748.61 | 31265.0 |
| 2013-10-11 16:00:00 | NQ | Futures | 3748.61 | 3751.81 | 3747.74 | 3750.94 | 7667.0 |
| 2013-10-11 17:00:00 | NQ | Futures | 3750.94 | 3752.97 | 3750.65 | 3752.97 | 217.0 |
| 2013-10-11 00:00:00 | YM | Futures | 15376.9 | 15381.0 | 15365.7 | 15366.7 | 740.0 |
| 2013-10-11 01:00:00 | YM | Futures | 15367.7 | 15374.9 | 15362.6 | 15373.9 | 1047.0 |
| 2013-10-11 02:00:00 | YM | Futures | 15372.8 | 15375.9 | 15358.5 | 15374.9 | 1189.0 |
| 2013-10-11 03:00:00 | YM | Futures | 15373.9 | 15376.9 | 15349.3 | 15357.5 | 2798.0 |
| 2013-10-11 04:00:00 | YM | Futures | 15356.5 | 15384.1 | 15355.5 | 15382.0 | 1876.0 |
| 2013-10-11 05:00:00 | YM | Futures | 15381.0 | 15387.1 | 15371.8 | 15379.0 | 1175.0 |
| 2013-10-11 06:00:00 | YM | Futures | 15379.0 | 15381.0 | 15360.6 | 15371.8 | 1702.0 |
| 2013-10-11 07:00:00 | YM | Futures | 15371.8 | 15380.0 | 15365.7 | 15368.7 | 1587.0 |
| 2013-10-11 08:00:00 | YM | Futures | 15368.7 | 15369.8 | 15345.3 | 15352.4 | 3379.0 |
| 2013-10-11 09:00:00 | YM | Futures | 15353.4 | 15423.9 | 15345.3 | 15421.9 | 19487.0 |
| 2013-10-11 10:00:00 | YM | Futures | 15423.9 | 15433.1 | 15370.8 | 15396.3 | 23001.0 |
| 2013-10-11 11:00:00 | YM | Futures | 15395.3 | 15452.5 | 15389.2 | 15449.4 | 17120.0 |
| 2013-10-11 12:00:00 | YM | Futures | 15449.4 | 15478.0 | 15446.4 | 15473.9 | 14560.0 |
| 2013-10-11 13:00:00 | YM | Futures | 15473.9 | 15489.3 | 15462.7 | 15473.9 | 12934.0 |
> showing 50 of 1,243 rows — these rows as CSV