PREVIEW / stock_1min / 2014-12-24
file: by_date/stock_1min/2014/2014-12-24.parquet size: 8.2 MB rows: 578,701 symbols: 2,825
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-24 06:20:00 | AAPL | Stock | 28.135 | 28.135 | 28.135 | 28.135 | 400.0 |
| 2014-12-24 07:09:00 | AAPL | Stock | 28.125 | 28.125 | 28.125 | 28.125 | 800.0 |
| 2014-12-24 07:38:00 | AAPL | Stock | 28.15 | 28.15 | 28.15 | 28.15 | 5988.0 |
| 2014-12-24 07:44:00 | AAPL | Stock | 28.165 | 28.165 | 28.165 | 28.165 | 1600.0 |
| 2014-12-24 07:53:00 | AAPL | Stock | 28.165 | 28.1975 | 28.165 | 28.1975 | 7600.0 |
| 2014-12-24 07:54:00 | AAPL | Stock | 28.205 | 28.2125 | 28.205 | 28.2125 | 11344.0 |
| 2014-12-24 07:55:00 | AAPL | Stock | 28.2125 | 28.2175 | 28.2125 | 28.2175 | 3600.0 |
| 2014-12-24 07:58:00 | AAPL | Stock | 28.21 | 28.21 | 28.21 | 28.21 | 400.0 |
| 2014-12-24 07:59:00 | AAPL | Stock | 28.19 | 28.19 | 28.19 | 28.19 | 1200.0 |
| 2014-12-24 08:00:00 | AAPL | Stock | 28.1875 | 28.205 | 28.125 | 28.19 | 31400.0 |
| 2014-12-24 08:01:00 | AAPL | Stock | 28.19 | 28.1975 | 28.19 | 28.1975 | 3200.0 |
| 2014-12-24 08:02:00 | AAPL | Stock | 28.19 | 28.19 | 28.1875 | 28.19 | 4800.0 |
| 2014-12-24 08:03:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 11200.0 |
| 2014-12-24 08:04:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1825 | 28.1825 | 11588.0 |
| 2014-12-24 08:07:00 | AAPL | Stock | 28.175 | 28.1975 | 28.175 | 28.1975 | 12312.0 |
| 2014-12-24 08:08:00 | AAPL | Stock | 28.1975 | 28.1975 | 28.1975 | 28.1975 | 400.0 |
| 2014-12-24 08:09:00 | AAPL | Stock | 28.1975 | 28.1975 | 28.19 | 28.19 | 3600.0 |
| 2014-12-24 08:10:00 | AAPL | Stock | 28.19 | 28.205 | 28.19 | 28.205 | 14800.0 |
| 2014-12-24 08:11:00 | AAPL | Stock | 28.2 | 28.21 | 28.2 | 28.21 | 8400.0 |
| 2014-12-24 08:12:00 | AAPL | Stock | 28.21 | 28.21 | 28.1975 | 28.2 | 25188.0 |
| 2014-12-24 08:15:00 | AAPL | Stock | 28.195 | 28.2 | 28.195 | 28.2 | 5040.0 |
| 2014-12-24 08:19:00 | AAPL | Stock | 28.2075 | 28.2075 | 28.2075 | 28.2075 | 1200.0 |
| 2014-12-24 08:20:00 | AAPL | Stock | 28.21 | 28.21 | 28.21 | 28.21 | 800.0 |
| 2014-12-24 08:24:00 | AAPL | Stock | 28.2 | 28.2 | 28.2 | 28.2 | 400.0 |
| 2014-12-24 08:25:00 | AAPL | Stock | 28.2 | 28.2 | 28.1975 | 28.1975 | 20048.0 |
| 2014-12-24 08:27:00 | AAPL | Stock | 28.1975 | 28.1975 | 28.1975 | 28.1975 | 2000.0 |
| 2014-12-24 08:28:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 3880.0 |
| 2014-12-24 08:31:00 | AAPL | Stock | 28.195 | 28.195 | 28.195 | 28.195 | 8000.0 |
| 2014-12-24 08:33:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 1148.0 |
| 2014-12-24 08:34:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 2000.0 |
| 2014-12-24 08:35:00 | AAPL | Stock | 28.1975 | 28.1975 | 28.19 | 28.1925 | 5000.0 |
| 2014-12-24 08:36:00 | AAPL | Stock | 28.1925 | 28.1925 | 28.1925 | 28.1925 | 1200.0 |
| 2014-12-24 08:38:00 | AAPL | Stock | 28.19 | 28.19 | 28.19 | 28.19 | 3800.0 |
| 2014-12-24 08:39:00 | AAPL | Stock | 28.19 | 28.19 | 28.1875 | 28.1875 | 3800.0 |
| 2014-12-24 08:40:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.1875 | 28.1875 | 2000.0 |
| 2014-12-24 08:45:00 | AAPL | Stock | 28.19 | 28.19 | 28.1875 | 28.19 | 9064.0 |
| 2014-12-24 08:46:00 | AAPL | Stock | 28.1925 | 28.1925 | 28.1925 | 28.1925 | 6352.0 |
| 2014-12-24 08:51:00 | AAPL | Stock | 28.185 | 28.185 | 28.1825 | 28.1825 | 3200.0 |
| 2014-12-24 08:52:00 | AAPL | Stock | 28.1775 | 28.1775 | 28.1775 | 28.1775 | 7960.0 |
| 2014-12-24 08:53:00 | AAPL | Stock | 28.175 | 28.175 | 28.175 | 28.175 | 7972.0 |
| 2014-12-24 08:54:00 | AAPL | Stock | 28.165 | 28.175 | 28.165 | 28.175 | 4392.0 |
| 2014-12-24 08:55:00 | AAPL | Stock | 28.1775 | 28.19 | 28.1775 | 28.19 | 13200.0 |
| 2014-12-24 08:56:00 | AAPL | Stock | 28.1875 | 28.1875 | 28.175 | 28.175 | 4400.0 |
| 2014-12-24 08:57:00 | AAPL | Stock | 28.1675 | 28.1675 | 28.165 | 28.1675 | 4800.0 |
| 2014-12-24 08:58:00 | AAPL | Stock | 28.17 | 28.1875 | 28.17 | 28.1875 | 8600.0 |
| 2014-12-24 09:00:00 | AAPL | Stock | 28.1775 | 28.1775 | 28.1775 | 28.1775 | 4000.0 |
| 2014-12-24 09:01:00 | AAPL | Stock | 28.165 | 28.165 | 28.1425 | 28.1425 | 11968.0 |
| 2014-12-24 09:02:00 | AAPL | Stock | 28.1575 | 28.1575 | 28.1575 | 28.1575 | 2000.0 |
| 2014-12-24 09:03:00 | AAPL | Stock | 28.155 | 28.155 | 28.155 | 28.155 | 2692.0 |
| 2014-12-24 09:04:00 | AAPL | Stock | 28.16 | 28.16 | 28.16 | 28.16 | 3280.0 |
> showing 50 of 578,701 rows — these rows as CSV