PREVIEW / stock_1min / 2014-10-24
file: by_date/stock_1min/2014/2014-10-24.parquet size: 13.7 MB rows: 1,005,324 symbols: 2,877
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-10-24 04:00:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2025 | 26.2025 | 1680.0 |
| 2014-10-24 04:11:00 | AAPL | Stock | 26.2175 | 26.2175 | 26.2175 | 26.2175 | 1200.0 |
| 2014-10-24 04:33:00 | AAPL | Stock | 26.18 | 26.18 | 26.18 | 26.18 | 800.0 |
| 2014-10-24 04:36:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2025 | 26.2025 | 400.0 |
| 2014-10-24 04:40:00 | AAPL | Stock | 26.205 | 26.205 | 26.205 | 26.205 | 400.0 |
| 2014-10-24 04:47:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 6000.0 |
| 2014-10-24 05:02:00 | AAPL | Stock | 26.1925 | 26.1925 | 26.1875 | 26.1875 | 1200.0 |
| 2014-10-24 05:10:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 800.0 |
| 2014-10-24 05:13:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 2000.0 |
| 2014-10-24 05:15:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 1200.0 |
| 2014-10-24 05:26:00 | AAPL | Stock | 26.1825 | 26.1825 | 26.1825 | 26.1825 | 400.0 |
| 2014-10-24 05:30:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 1368.0 |
| 2014-10-24 05:36:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 1792.0 |
| 2014-10-24 05:39:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 800.0 |
| 2014-10-24 05:50:00 | AAPL | Stock | 26.1775 | 26.1775 | 26.1775 | 26.1775 | 1524.0 |
| 2014-10-24 05:51:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 4000.0 |
| 2014-10-24 05:52:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 400.0 |
| 2014-10-24 05:53:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 3008.0 |
| 2014-10-24 05:55:00 | AAPL | Stock | 26.1525 | 26.1525 | 26.15 | 26.15 | 4000.0 |
| 2014-10-24 06:03:00 | AAPL | Stock | 26.17 | 26.17 | 26.17 | 26.17 | 772.0 |
| 2014-10-24 06:06:00 | AAPL | Stock | 26.175 | 26.175 | 26.175 | 26.175 | 724.0 |
| 2014-10-24 06:20:00 | AAPL | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 3936.0 |
| 2014-10-24 06:21:00 | AAPL | Stock | 26.1625 | 26.1625 | 26.1625 | 26.1625 | 1700.0 |
| 2014-10-24 06:22:00 | AAPL | Stock | 26.1625 | 26.1625 | 26.1625 | 26.1625 | 1700.0 |
| 2014-10-24 06:30:00 | AAPL | Stock | 26.15 | 26.16 | 26.15 | 26.16 | 9024.0 |
| 2014-10-24 06:33:00 | AAPL | Stock | 26.16 | 26.165 | 26.16 | 26.165 | 2504.0 |
| 2014-10-24 06:35:00 | AAPL | Stock | 26.1725 | 26.175 | 26.1725 | 26.175 | 9600.0 |
| 2014-10-24 06:38:00 | AAPL | Stock | 26.1675 | 26.1675 | 26.1675 | 26.1675 | 420.0 |
| 2014-10-24 06:40:00 | AAPL | Stock | 26.15 | 26.15 | 26.15 | 26.15 | 1796.0 |
| 2014-10-24 06:44:00 | AAPL | Stock | 26.1575 | 26.1575 | 26.1575 | 26.1575 | 400.0 |
| 2014-10-24 06:45:00 | AAPL | Stock | 26.175 | 26.18 | 26.175 | 26.18 | 1200.0 |
| 2014-10-24 06:47:00 | AAPL | Stock | 26.18 | 26.1875 | 26.18 | 26.1875 | 2800.0 |
| 2014-10-24 06:48:00 | AAPL | Stock | 26.18 | 26.18 | 26.18 | 26.18 | 800.0 |
| 2014-10-24 06:49:00 | AAPL | Stock | 26.18 | 26.18 | 26.18 | 26.18 | 3200.0 |
| 2014-10-24 07:02:00 | AAPL | Stock | 26.1925 | 26.2 | 26.1925 | 26.2 | 7980.0 |
| 2014-10-24 07:03:00 | AAPL | Stock | 26.2225 | 26.2225 | 26.2225 | 26.2225 | 2000.0 |
| 2014-10-24 07:06:00 | AAPL | Stock | 26.2125 | 26.225 | 26.2125 | 26.225 | 11600.0 |
| 2014-10-24 07:07:00 | AAPL | Stock | 26.2325 | 26.235 | 26.225 | 26.235 | 6400.0 |
| 2014-10-24 07:09:00 | AAPL | Stock | 26.2075 | 26.2125 | 26.2025 | 26.2125 | 3608.0 |
| 2014-10-24 07:10:00 | AAPL | Stock | 26.2025 | 26.2125 | 26.2 | 26.2125 | 2400.0 |
| 2014-10-24 07:17:00 | AAPL | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 800.0 |
| 2014-10-24 07:19:00 | AAPL | Stock | 26.2075 | 26.2075 | 26.2075 | 26.2075 | 400.0 |
| 2014-10-24 07:23:00 | AAPL | Stock | 26.2075 | 26.2075 | 26.2075 | 26.2075 | 1780.0 |
| 2014-10-24 07:24:00 | AAPL | Stock | 26.2 | 26.205 | 26.2 | 26.205 | 800.0 |
| 2014-10-24 07:25:00 | AAPL | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 800.0 |
| 2014-10-24 07:26:00 | AAPL | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 400.0 |
| 2014-10-24 07:27:00 | AAPL | Stock | 26.2 | 26.2 | 26.2 | 26.2 | 1960.0 |
| 2014-10-24 07:29:00 | AAPL | Stock | 26.2075 | 26.2075 | 26.2075 | 26.2075 | 6400.0 |
| 2014-10-24 07:32:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2025 | 26.2025 | 1200.0 |
| 2014-10-24 07:33:00 | AAPL | Stock | 26.2025 | 26.2025 | 26.2 | 26.2 | 4400.0 |
> showing 50 of 1,005,324 rows — these rows as CSV