PREVIEW / futures_30min / 2013-09-25
file: by_date/futures_30min/2013/2013-09-25.parquet size: 74 KB rows: 2,852
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-09-25 00:00:00 | ES | Futures | 1745.62 | 1746.13 | 1745.36 | 1745.88 | 624.0 |
| 2013-09-25 00:30:00 | ES | Futures | 1745.88 | 1746.13 | 1745.62 | 1745.88 | 465.0 |
| 2013-09-25 01:00:00 | ES | Futures | 1746.13 | 1746.13 | 1745.62 | 1745.88 | 767.0 |
| 2013-09-25 01:30:00 | ES | Futures | 1745.88 | 1746.13 | 1745.62 | 1746.13 | 1756.0 |
| 2013-09-25 02:00:00 | ES | Futures | 1745.88 | 1746.39 | 1744.84 | 1745.88 | 4886.0 |
| 2013-09-25 02:30:00 | ES | Futures | 1745.62 | 1745.88 | 1744.59 | 1744.59 | 1808.0 |
| 2013-09-25 03:00:00 | ES | Futures | 1744.84 | 1745.36 | 1742.01 | 1742.26 | 18050.0 |
| 2013-09-25 03:30:00 | ES | Futures | 1742.26 | 1743.3 | 1742.26 | 1742.26 | 7538.0 |
| 2013-09-25 04:00:00 | ES | Futures | 1742.26 | 1742.52 | 1740.97 | 1742.01 | 9238.0 |
| 2013-09-25 04:30:00 | ES | Futures | 1742.01 | 1745.36 | 1741.75 | 1745.1 | 10852.0 |
| 2013-09-25 05:00:00 | ES | Futures | 1744.84 | 1747.17 | 1744.59 | 1746.65 | 10593.0 |
| 2013-09-25 05:30:00 | ES | Futures | 1746.39 | 1747.42 | 1745.88 | 1746.13 | 8899.0 |
| 2013-09-25 06:00:00 | ES | Futures | 1746.39 | 1746.65 | 1743.81 | 1744.59 | 9437.0 |
| 2013-09-25 06:30:00 | ES | Futures | 1744.59 | 1744.59 | 1742.78 | 1743.3 | 8744.0 |
| 2013-09-25 07:00:00 | ES | Futures | 1743.3 | 1743.55 | 1742.26 | 1743.04 | 11945.0 |
| 2013-09-25 07:30:00 | ES | Futures | 1743.04 | 1744.84 | 1742.78 | 1744.84 | 12680.0 |
| 2013-09-25 08:00:00 | ES | Futures | 1744.84 | 1745.1 | 1743.55 | 1744.33 | 14077.0 |
| 2013-09-25 08:30:00 | ES | Futures | 1744.33 | 1747.42 | 1743.3 | 1746.39 | 24918.0 |
| 2013-09-25 09:00:00 | ES | Futures | 1746.39 | 1747.68 | 1745.1 | 1746.13 | 20829.0 |
| 2013-09-25 09:30:00 | ES | Futures | 1746.13 | 1746.39 | 1739.69 | 1742.52 | 194235.0 |
| 2013-09-25 10:00:00 | ES | Futures | 1742.78 | 1744.84 | 1738.14 | 1743.55 | 196420.0 |
| 2013-09-25 10:30:00 | ES | Futures | 1743.3 | 1745.62 | 1742.52 | 1743.3 | 102317.0 |
| 2013-09-25 11:00:00 | ES | Futures | 1743.55 | 1748.2 | 1741.75 | 1747.42 | 111265.0 |
| 2013-09-25 11:30:00 | ES | Futures | 1747.42 | 1748.97 | 1747.17 | 1747.94 | 61672.0 |
| 2013-09-25 12:00:00 | ES | Futures | 1748.2 | 1748.46 | 1743.04 | 1744.84 | 84818.0 |
| 2013-09-25 12:30:00 | ES | Futures | 1744.59 | 1746.13 | 1743.81 | 1745.88 | 54595.0 |
| 2013-09-25 13:00:00 | ES | Futures | 1745.88 | 1747.17 | 1744.33 | 1744.33 | 51442.0 |
| 2013-09-25 13:30:00 | ES | Futures | 1744.33 | 1744.59 | 1738.4 | 1742.01 | 154255.0 |
| 2013-09-25 14:00:00 | ES | Futures | 1742.01 | 1743.55 | 1739.69 | 1741.75 | 82246.0 |
| 2013-09-25 14:30:00 | ES | Futures | 1741.75 | 1743.3 | 1739.94 | 1741.23 | 73993.0 |
| 2013-09-25 15:00:00 | ES | Futures | 1741.49 | 1744.84 | 1740.2 | 1741.23 | 96874.0 |
| 2013-09-25 15:30:00 | ES | Futures | 1741.23 | 1742.52 | 1739.69 | 1740.46 | 104272.0 |
| 2013-09-25 16:00:00 | ES | Futures | 1740.2 | 1741.49 | 1739.17 | 1739.94 | 60344.0 |
| 2013-09-25 16:30:00 | ES | Futures | 1739.94 | 1740.97 | 1739.94 | 1739.94 | 5398.0 |
| 2013-09-25 17:00:00 | ES | Futures | 1739.94 | 1740.46 | 1739.94 | 1739.94 | 1333.0 |
| 2013-09-25 18:00:00 | ES | Futures | 1740.2 | 1742.01 | 1740.2 | 1741.75 | 1738.0 |
| 2013-09-25 18:30:00 | ES | Futures | 1741.75 | 1741.75 | 1740.72 | 1741.23 | 777.0 |
| 2013-09-25 19:00:00 | ES | Futures | 1741.23 | 1741.75 | 1740.97 | 1741.23 | 684.0 |
| 2013-09-25 19:30:00 | ES | Futures | 1741.49 | 1741.75 | 1740.72 | 1740.97 | 1148.0 |
| 2013-09-25 20:00:00 | ES | Futures | 1740.72 | 1741.75 | 1740.72 | 1740.97 | 1511.0 |
| 2013-09-25 20:30:00 | ES | Futures | 1740.97 | 1740.97 | 1740.2 | 1740.97 | 2065.0 |
| 2013-09-25 21:00:00 | ES | Futures | 1740.97 | 1741.49 | 1740.72 | 1741.49 | 1124.0 |
| 2013-09-25 21:30:00 | ES | Futures | 1741.49 | 1741.75 | 1740.46 | 1740.97 | 1558.0 |
| 2013-09-25 22:00:00 | ES | Futures | 1740.72 | 1741.75 | 1740.46 | 1741.49 | 1304.0 |
| 2013-09-25 22:30:00 | ES | Futures | 1741.49 | 1743.04 | 1741.49 | 1742.52 | 4586.0 |
| 2013-09-25 23:00:00 | ES | Futures | 1742.52 | 1742.78 | 1742.26 | 1742.52 | 1147.0 |
| 2013-09-25 23:30:00 | ES | Futures | 1742.26 | 1743.04 | 1742.26 | 1742.52 | 1381.0 |
| 2013-09-25 00:00:00 | NQ | Futures | 3735.83 | 3737.0 | 3735.83 | 3736.7 | 64.0 |
| 2013-09-25 00:30:00 | NQ | Futures | 3737.0 | 3737.58 | 3736.7 | 3737.29 | 80.0 |
| 2013-09-25 01:00:00 | NQ | Futures | 3737.29 | 3737.58 | 3736.7 | 3737.29 | 83.0 |
> showing 50 of 2,852 rows — these rows as CSV