PREVIEW / futures_30min / 2013-08-12
file: by_date/futures_30min/2013/2013-08-12.parquet size: 76 KB rows: 2,785
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-12 00:00:00 | ES | Futures | 1742.0 | 1742.77 | 1742.0 | 1742.51 | 517.0 |
| 2013-08-12 00:30:00 | ES | Futures | 1742.26 | 1742.51 | 1741.74 | 1742.26 | 543.0 |
| 2013-08-12 01:00:00 | ES | Futures | 1742.0 | 1742.77 | 1741.74 | 1742.26 | 1045.0 |
| 2013-08-12 01:30:00 | ES | Futures | 1742.26 | 1743.29 | 1742.26 | 1743.29 | 1384.0 |
| 2013-08-12 02:00:00 | ES | Futures | 1743.29 | 1744.32 | 1742.26 | 1743.03 | 7699.0 |
| 2013-08-12 02:30:00 | ES | Futures | 1742.77 | 1743.03 | 1741.74 | 1741.74 | 2928.0 |
| 2013-08-12 03:00:00 | ES | Futures | 1741.48 | 1742.51 | 1738.12 | 1738.64 | 19461.0 |
| 2013-08-12 03:30:00 | ES | Futures | 1738.38 | 1739.93 | 1738.12 | 1739.41 | 9991.0 |
| 2013-08-12 04:00:00 | ES | Futures | 1739.15 | 1739.41 | 1734.5 | 1735.79 | 18274.0 |
| 2013-08-12 04:30:00 | ES | Futures | 1735.79 | 1736.31 | 1735.02 | 1735.53 | 9945.0 |
| 2013-08-12 05:00:00 | ES | Futures | 1735.53 | 1735.53 | 1732.17 | 1732.69 | 20313.0 |
| 2013-08-12 05:30:00 | ES | Futures | 1732.69 | 1734.24 | 1732.17 | 1733.72 | 6179.0 |
| 2013-08-12 06:00:00 | ES | Futures | 1733.98 | 1734.76 | 1733.72 | 1734.5 | 5319.0 |
| 2013-08-12 06:30:00 | ES | Futures | 1734.5 | 1735.02 | 1734.24 | 1735.02 | 7724.0 |
| 2013-08-12 07:00:00 | ES | Futures | 1735.02 | 1736.83 | 1734.5 | 1736.57 | 11686.0 |
| 2013-08-12 07:30:00 | ES | Futures | 1736.31 | 1736.83 | 1735.53 | 1735.53 | 7029.0 |
| 2013-08-12 08:00:00 | ES | Futures | 1735.79 | 1736.57 | 1735.02 | 1735.53 | 10240.0 |
| 2013-08-12 08:30:00 | ES | Futures | 1735.53 | 1738.12 | 1735.02 | 1737.34 | 18528.0 |
| 2013-08-12 09:00:00 | ES | Futures | 1737.6 | 1738.12 | 1735.79 | 1736.83 | 18843.0 |
| 2013-08-12 09:30:00 | ES | Futures | 1736.83 | 1743.03 | 1735.79 | 1741.22 | 188525.0 |
| 2013-08-12 10:00:00 | ES | Futures | 1741.22 | 1744.32 | 1741.22 | 1742.0 | 146052.0 |
| 2013-08-12 10:30:00 | ES | Futures | 1742.0 | 1745.36 | 1741.48 | 1744.84 | 106035.0 |
| 2013-08-12 11:00:00 | ES | Futures | 1744.84 | 1745.62 | 1743.03 | 1744.84 | 78838.0 |
| 2013-08-12 11:30:00 | ES | Futures | 1744.84 | 1745.62 | 1742.77 | 1743.81 | 53621.0 |
| 2013-08-12 12:00:00 | ES | Futures | 1743.81 | 1743.81 | 1741.74 | 1741.74 | 31772.0 |
| 2013-08-12 12:30:00 | ES | Futures | 1741.74 | 1743.29 | 1740.45 | 1743.03 | 53274.0 |
| 2013-08-12 13:00:00 | ES | Futures | 1743.29 | 1743.81 | 1740.45 | 1742.0 | 43674.0 |
| 2013-08-12 13:30:00 | ES | Futures | 1742.0 | 1743.55 | 1739.93 | 1740.7 | 50111.0 |
| 2013-08-12 14:00:00 | ES | Futures | 1740.7 | 1742.0 | 1740.19 | 1740.96 | 41307.0 |
| 2013-08-12 14:30:00 | ES | Futures | 1741.22 | 1742.51 | 1740.19 | 1742.26 | 47826.0 |
| 2013-08-12 15:00:00 | ES | Futures | 1742.51 | 1744.06 | 1741.22 | 1743.03 | 48574.0 |
| 2013-08-12 15:30:00 | ES | Futures | 1743.03 | 1745.1 | 1742.77 | 1743.55 | 84253.0 |
| 2013-08-12 16:00:00 | ES | Futures | 1743.55 | 1744.84 | 1743.29 | 1744.58 | 53073.0 |
| 2013-08-12 16:30:00 | ES | Futures | 1744.58 | 1745.62 | 1744.58 | 1745.62 | 7742.0 |
| 2013-08-12 17:00:00 | ES | Futures | 1745.36 | 1745.87 | 1745.36 | 1745.62 | 2285.0 |
| 2013-08-12 18:00:00 | ES | Futures | 1745.36 | 1745.87 | 1744.84 | 1745.1 | 3235.0 |
| 2013-08-12 18:30:00 | ES | Futures | 1745.36 | 1745.36 | 1745.1 | 1745.1 | 742.0 |
| 2013-08-12 19:00:00 | ES | Futures | 1745.1 | 1745.36 | 1744.84 | 1745.1 | 555.0 |
| 2013-08-12 19:30:00 | ES | Futures | 1745.1 | 1745.36 | 1744.06 | 1744.58 | 2383.0 |
| 2013-08-12 20:00:00 | ES | Futures | 1744.32 | 1745.1 | 1744.06 | 1744.84 | 1828.0 |
| 2013-08-12 20:30:00 | ES | Futures | 1744.84 | 1745.1 | 1744.58 | 1744.84 | 1156.0 |
| 2013-08-12 21:00:00 | ES | Futures | 1744.84 | 1745.36 | 1744.84 | 1745.1 | 1101.0 |
| 2013-08-12 21:30:00 | ES | Futures | 1744.84 | 1745.1 | 1744.32 | 1744.58 | 1408.0 |
| 2013-08-12 22:00:00 | ES | Futures | 1744.84 | 1744.84 | 1744.32 | 1744.58 | 858.0 |
| 2013-08-12 22:30:00 | ES | Futures | 1744.58 | 1744.84 | 1744.58 | 1744.58 | 376.0 |
| 2013-08-12 23:00:00 | ES | Futures | 1744.58 | 1745.62 | 1744.32 | 1745.36 | 1219.0 |
| 2013-08-12 23:30:00 | ES | Futures | 1745.62 | 1746.65 | 1745.62 | 1745.87 | 3461.0 |
| 2013-08-12 00:00:00 | NQ | Futures | 3640.67 | 3640.97 | 3640.09 | 3640.67 | 126.0 |
| 2013-08-12 00:30:00 | NQ | Futures | 3640.38 | 3640.67 | 3640.09 | 3640.38 | 138.0 |
| 2013-08-12 01:00:00 | NQ | Futures | 3640.38 | 3641.55 | 3640.09 | 3641.26 | 215.0 |
> showing 50 of 2,785 rows — these rows as CSV