PREVIEW / futures_30min / 2013-10-10
file: by_date/futures_30min/2013/2013-10-10.parquet size: 80 KB rows: 2,931
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-10 00:00:00 | ES | Futures | 1707.96 | 1708.47 | 1706.92 | 1708.21 | 3537.0 |
| 2013-10-10 00:30:00 | ES | Futures | 1708.21 | 1709.76 | 1707.96 | 1709.5 | 4275.0 |
| 2013-10-10 01:00:00 | ES | Futures | 1709.76 | 1709.76 | 1708.73 | 1708.99 | 2638.0 |
| 2013-10-10 01:30:00 | ES | Futures | 1709.25 | 1709.5 | 1708.47 | 1709.25 | 2710.0 |
| 2013-10-10 02:00:00 | ES | Futures | 1709.25 | 1710.28 | 1708.73 | 1709.25 | 6290.0 |
| 2013-10-10 02:30:00 | ES | Futures | 1709.25 | 1710.54 | 1709.25 | 1709.5 | 2893.0 |
| 2013-10-10 03:00:00 | ES | Futures | 1709.5 | 1710.54 | 1707.18 | 1710.28 | 16093.0 |
| 2013-10-10 03:30:00 | ES | Futures | 1710.54 | 1714.15 | 1710.02 | 1712.86 | 27174.0 |
| 2013-10-10 04:00:00 | ES | Futures | 1712.6 | 1716.21 | 1712.34 | 1714.66 | 20387.0 |
| 2013-10-10 04:30:00 | ES | Futures | 1714.66 | 1715.18 | 1713.89 | 1714.4 | 5247.0 |
| 2013-10-10 05:00:00 | ES | Futures | 1714.4 | 1715.95 | 1714.15 | 1714.92 | 6854.0 |
| 2013-10-10 05:30:00 | ES | Futures | 1714.66 | 1716.73 | 1714.66 | 1715.44 | 10026.0 |
| 2013-10-10 06:00:00 | ES | Futures | 1715.69 | 1717.76 | 1715.69 | 1716.21 | 13953.0 |
| 2013-10-10 06:30:00 | ES | Futures | 1716.47 | 1718.79 | 1716.21 | 1718.02 | 20391.0 |
| 2013-10-10 07:00:00 | ES | Futures | 1718.02 | 1719.31 | 1716.73 | 1718.27 | 27072.0 |
| 2013-10-10 07:30:00 | ES | Futures | 1718.53 | 1718.53 | 1716.21 | 1716.47 | 16233.0 |
| 2013-10-10 08:00:00 | ES | Futures | 1716.47 | 1718.02 | 1714.66 | 1715.44 | 22597.0 |
| 2013-10-10 08:30:00 | ES | Futures | 1715.44 | 1718.79 | 1713.89 | 1718.79 | 53123.0 |
| 2013-10-10 09:00:00 | ES | Futures | 1718.79 | 1721.37 | 1718.53 | 1720.85 | 61552.0 |
| 2013-10-10 09:30:00 | ES | Futures | 1720.6 | 1727.3 | 1720.34 | 1726.27 | 294248.0 |
| 2013-10-10 10:00:00 | ES | Futures | 1726.53 | 1728.08 | 1724.47 | 1726.53 | 140046.0 |
| 2013-10-10 10:30:00 | ES | Futures | 1726.79 | 1730.14 | 1725.5 | 1727.04 | 181243.0 |
| 2013-10-10 11:00:00 | ES | Futures | 1727.3 | 1728.08 | 1723.95 | 1727.56 | 174738.0 |
| 2013-10-10 11:30:00 | ES | Futures | 1727.82 | 1733.75 | 1726.27 | 1732.46 | 192941.0 |
| 2013-10-10 12:00:00 | ES | Futures | 1732.46 | 1733.24 | 1731.43 | 1732.2 | 71837.0 |
| 2013-10-10 12:30:00 | ES | Futures | 1732.2 | 1733.75 | 1732.2 | 1732.46 | 50207.0 |
| 2013-10-10 13:00:00 | ES | Futures | 1732.72 | 1732.72 | 1730.4 | 1731.17 | 66615.0 |
| 2013-10-10 13:30:00 | ES | Futures | 1730.91 | 1733.49 | 1730.4 | 1732.72 | 58567.0 |
| 2013-10-10 14:00:00 | ES | Futures | 1732.72 | 1732.98 | 1729.62 | 1730.91 | 70272.0 |
| 2013-10-10 14:30:00 | ES | Futures | 1730.91 | 1732.46 | 1730.14 | 1732.46 | 49661.0 |
| 2013-10-10 15:00:00 | ES | Futures | 1732.46 | 1741.49 | 1732.2 | 1739.43 | 217214.0 |
| 2013-10-10 15:30:00 | ES | Futures | 1739.43 | 1740.72 | 1736.85 | 1740.46 | 200008.0 |
| 2013-10-10 16:00:00 | ES | Futures | 1740.2 | 1741.23 | 1737.36 | 1738.91 | 126016.0 |
| 2013-10-10 16:30:00 | ES | Futures | 1738.65 | 1738.65 | 1735.3 | 1736.07 | 21750.0 |
| 2013-10-10 17:00:00 | ES | Futures | 1736.07 | 1736.85 | 1735.3 | 1736.59 | 3137.0 |
| 2013-10-10 18:00:00 | ES | Futures | 1736.59 | 1737.62 | 1726.27 | 1729.88 | 41740.0 |
| 2013-10-10 18:30:00 | ES | Futures | 1730.14 | 1736.33 | 1729.88 | 1734.27 | 19786.0 |
| 2013-10-10 19:00:00 | ES | Futures | 1734.53 | 1736.59 | 1733.49 | 1736.07 | 5190.0 |
| 2013-10-10 19:30:00 | ES | Futures | 1735.82 | 1737.62 | 1734.01 | 1735.56 | 5698.0 |
| 2013-10-10 20:00:00 | ES | Futures | 1735.56 | 1739.43 | 1734.78 | 1738.14 | 9652.0 |
| 2013-10-10 20:30:00 | ES | Futures | 1738.4 | 1738.91 | 1736.07 | 1737.36 | 4524.0 |
| 2013-10-10 21:00:00 | ES | Futures | 1737.36 | 1738.91 | 1736.33 | 1738.65 | 2620.0 |
| 2013-10-10 21:30:00 | ES | Futures | 1738.91 | 1741.23 | 1738.14 | 1740.97 | 6834.0 |
| 2013-10-10 22:00:00 | ES | Futures | 1740.97 | 1740.97 | 1739.94 | 1740.72 | 4158.0 |
| 2013-10-10 22:30:00 | ES | Futures | 1740.72 | 1740.97 | 1740.46 | 1740.72 | 1545.0 |
| 2013-10-10 23:00:00 | ES | Futures | 1740.72 | 1742.78 | 1740.46 | 1740.97 | 4654.0 |
| 2013-10-10 23:30:00 | ES | Futures | 1740.97 | 1742.01 | 1740.2 | 1740.72 | 1319.0 |
| 2013-10-10 00:00:00 | NQ | Futures | 3650.45 | 3650.74 | 3648.99 | 3650.74 | 483.0 |
| 2013-10-10 00:30:00 | NQ | Futures | 3650.74 | 3653.35 | 3650.45 | 3653.06 | 467.0 |
| 2013-10-10 01:00:00 | NQ | Futures | 3653.06 | 3653.64 | 3651.9 | 3651.9 | 243.0 |
> showing 50 of 2,931 rows — these rows as CSV