PREVIEW / futures_30min / 2013-10-03
file: by_date/futures_30min/2013/2013-10-03.parquet size: 76 KB rows: 2,864
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-03 00:00:00 | ES | Futures | 1734.27 | 1734.78 | 1734.01 | 1734.27 | 842.0 |
| 2013-10-03 00:30:00 | ES | Futures | 1734.27 | 1734.78 | 1733.75 | 1734.78 | 589.0 |
| 2013-10-03 01:00:00 | ES | Futures | 1734.53 | 1735.3 | 1733.75 | 1734.01 | 1423.0 |
| 2013-10-03 01:30:00 | ES | Futures | 1734.01 | 1735.3 | 1733.75 | 1735.3 | 1590.0 |
| 2013-10-03 02:00:00 | ES | Futures | 1735.04 | 1735.3 | 1731.95 | 1732.72 | 3829.0 |
| 2013-10-03 02:30:00 | ES | Futures | 1732.72 | 1734.01 | 1732.46 | 1734.01 | 1569.0 |
| 2013-10-03 03:00:00 | ES | Futures | 1733.75 | 1735.56 | 1732.98 | 1733.75 | 8613.0 |
| 2013-10-03 03:30:00 | ES | Futures | 1733.75 | 1734.27 | 1732.46 | 1733.75 | 4885.0 |
| 2013-10-03 04:00:00 | ES | Futures | 1733.75 | 1734.01 | 1732.98 | 1732.98 | 5151.0 |
| 2013-10-03 04:30:00 | ES | Futures | 1732.98 | 1733.75 | 1731.69 | 1733.24 | 4480.0 |
| 2013-10-03 05:00:00 | ES | Futures | 1733.24 | 1734.53 | 1732.98 | 1734.01 | 4650.0 |
| 2013-10-03 05:30:00 | ES | Futures | 1734.01 | 1734.01 | 1730.66 | 1730.91 | 7087.0 |
| 2013-10-03 06:00:00 | ES | Futures | 1730.91 | 1731.43 | 1730.66 | 1731.43 | 3541.0 |
| 2013-10-03 06:30:00 | ES | Futures | 1731.17 | 1732.46 | 1730.91 | 1732.2 | 6244.0 |
| 2013-10-03 07:00:00 | ES | Futures | 1731.95 | 1733.49 | 1731.43 | 1732.98 | 5606.0 |
| 2013-10-03 07:30:00 | ES | Futures | 1732.98 | 1734.53 | 1732.46 | 1733.75 | 11518.0 |
| 2013-10-03 08:00:00 | ES | Futures | 1733.75 | 1734.27 | 1732.72 | 1733.75 | 8310.0 |
| 2013-10-03 08:30:00 | ES | Futures | 1733.75 | 1737.62 | 1733.49 | 1736.85 | 35340.0 |
| 2013-10-03 09:00:00 | ES | Futures | 1737.11 | 1737.88 | 1736.33 | 1736.85 | 30528.0 |
| 2013-10-03 09:30:00 | ES | Futures | 1736.59 | 1738.4 | 1730.91 | 1731.95 | 185386.0 |
| 2013-10-03 10:00:00 | ES | Futures | 1731.95 | 1732.2 | 1724.72 | 1727.04 | 197578.0 |
| 2013-10-03 10:30:00 | ES | Futures | 1726.79 | 1727.3 | 1723.43 | 1726.01 | 151486.0 |
| 2013-10-03 11:00:00 | ES | Futures | 1726.01 | 1727.56 | 1722.92 | 1723.43 | 123725.0 |
| 2013-10-03 11:30:00 | ES | Futures | 1723.18 | 1725.24 | 1716.73 | 1717.76 | 217033.0 |
| 2013-10-03 12:00:00 | ES | Futures | 1717.76 | 1720.08 | 1716.21 | 1719.82 | 134566.0 |
| 2013-10-03 12:30:00 | ES | Futures | 1719.82 | 1724.72 | 1718.53 | 1723.95 | 178815.0 |
| 2013-10-03 13:00:00 | ES | Futures | 1724.21 | 1729.37 | 1722.66 | 1729.11 | 154462.0 |
| 2013-10-03 13:30:00 | ES | Futures | 1729.37 | 1730.91 | 1727.04 | 1730.4 | 131181.0 |
| 2013-10-03 14:00:00 | ES | Futures | 1730.14 | 1730.4 | 1721.37 | 1727.82 | 161275.0 |
| 2013-10-03 14:30:00 | ES | Futures | 1727.56 | 1729.62 | 1724.72 | 1727.04 | 102502.0 |
| 2013-10-03 15:00:00 | ES | Futures | 1727.04 | 1728.85 | 1725.76 | 1728.59 | 67381.0 |
| 2013-10-03 15:30:00 | ES | Futures | 1728.59 | 1729.11 | 1723.69 | 1724.98 | 148815.0 |
| 2013-10-03 16:00:00 | ES | Futures | 1724.98 | 1725.24 | 1721.89 | 1722.14 | 95185.0 |
| 2013-10-03 16:30:00 | ES | Futures | 1721.37 | 1721.89 | 1720.6 | 1720.85 | 8519.0 |
| 2013-10-03 17:00:00 | ES | Futures | 1720.85 | 1721.11 | 1720.6 | 1720.6 | 2470.0 |
| 2013-10-03 18:00:00 | ES | Futures | 1721.11 | 1723.95 | 1721.11 | 1722.66 | 3941.0 |
| 2013-10-03 18:30:00 | ES | Futures | 1722.66 | 1722.92 | 1722.14 | 1722.92 | 616.0 |
| 2013-10-03 19:00:00 | ES | Futures | 1722.92 | 1723.18 | 1722.66 | 1723.18 | 355.0 |
| 2013-10-03 19:30:00 | ES | Futures | 1722.92 | 1723.43 | 1722.4 | 1723.18 | 1177.0 |
| 2013-10-03 20:00:00 | ES | Futures | 1722.92 | 1723.43 | 1722.66 | 1722.66 | 1590.0 |
| 2013-10-03 20:30:00 | ES | Futures | 1722.92 | 1722.92 | 1720.6 | 1721.63 | 3379.0 |
| 2013-10-03 21:00:00 | ES | Futures | 1721.63 | 1722.66 | 1720.85 | 1721.63 | 3871.0 |
| 2013-10-03 21:30:00 | ES | Futures | 1721.89 | 1723.43 | 1720.6 | 1723.18 | 3290.0 |
| 2013-10-03 22:00:00 | ES | Futures | 1722.92 | 1724.47 | 1722.92 | 1723.69 | 3344.0 |
| 2013-10-03 22:30:00 | ES | Futures | 1723.95 | 1725.24 | 1723.43 | 1724.47 | 3659.0 |
| 2013-10-03 23:00:00 | ES | Futures | 1724.47 | 1725.24 | 1722.92 | 1722.92 | 1432.0 |
| 2013-10-03 23:30:00 | ES | Futures | 1723.18 | 1724.72 | 1722.92 | 1724.21 | 2618.0 |
| 2013-10-03 00:00:00 | NQ | Futures | 3759.65 | 3760.52 | 3758.78 | 3759.36 | 112.0 |
| 2013-10-03 00:30:00 | NQ | Futures | 3759.36 | 3760.52 | 3758.2 | 3760.52 | 126.0 |
| 2013-10-03 01:00:00 | NQ | Futures | 3760.23 | 3761.1 | 3758.2 | 3758.78 | 251.0 |
> showing 50 of 2,864 rows — these rows as CSV