PREVIEW / stock_1min / 2017-04-26
file: by_date/stock_1min/2017/2017-04-26.parquet size: 15.3 MB rows: 1,102,928 symbols: 2,523
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-26 04:01:00 | AAPL | Stock | 36.18 | 36.18 | 36.18 | 36.18 | 400.0 |
| 2017-04-26 04:16:00 | AAPL | Stock | 36.1775 | 36.18 | 36.1775 | 36.18 | 3828.0 |
| 2017-04-26 04:23:00 | AAPL | Stock | 36.185 | 36.185 | 36.185 | 36.185 | 400.0 |
| 2017-04-26 04:55:00 | AAPL | Stock | 36.185 | 36.1875 | 36.185 | 36.1875 | 5600.0 |
| 2017-04-26 04:59:00 | AAPL | Stock | 36.2 | 36.2 | 36.2 | 36.2 | 1120.0 |
| 2017-04-26 05:13:00 | AAPL | Stock | 36.1975 | 36.1975 | 36.1975 | 36.1975 | 560.0 |
| 2017-04-26 05:20:00 | AAPL | Stock | 36.1975 | 36.1975 | 36.1975 | 36.1975 | 896.0 |
| 2017-04-26 05:30:00 | AAPL | Stock | 36.1975 | 36.1975 | 36.1975 | 36.1975 | 440.0 |
| 2017-04-26 05:35:00 | AAPL | Stock | 36.1975 | 36.2 | 36.1975 | 36.2 | 3108.0 |
| 2017-04-26 05:36:00 | AAPL | Stock | 36.2125 | 36.225 | 36.2125 | 36.225 | 3688.0 |
| 2017-04-26 05:38:00 | AAPL | Stock | 36.1875 | 36.1875 | 36.1875 | 36.1875 | 3720.0 |
| 2017-04-26 05:47:00 | AAPL | Stock | 36.1975 | 36.1975 | 36.1975 | 36.1975 | 1200.0 |
| 2017-04-26 06:04:00 | AAPL | Stock | 36.1975 | 36.1975 | 36.1975 | 36.1975 | 1644.0 |
| 2017-04-26 06:09:00 | AAPL | Stock | 36.215 | 36.2175 | 36.215 | 36.215 | 6000.0 |
| 2017-04-26 06:20:00 | AAPL | Stock | 36.1975 | 36.215 | 36.1975 | 36.215 | 2048.0 |
| 2017-04-26 06:24:00 | AAPL | Stock | 36.1775 | 36.1775 | 36.175 | 36.175 | 10000.0 |
| 2017-04-26 06:33:00 | AAPL | Stock | 36.1875 | 36.1875 | 36.1875 | 36.1875 | 560.0 |
| 2017-04-26 06:35:00 | AAPL | Stock | 36.17 | 36.17 | 36.17 | 36.17 | 4000.0 |
| 2017-04-26 06:38:00 | AAPL | Stock | 36.17 | 36.17 | 36.1625 | 36.1625 | 11288.0 |
| 2017-04-26 06:48:00 | AAPL | Stock | 36.1625 | 36.1625 | 36.1625 | 36.1625 | 400.0 |
| 2017-04-26 06:59:00 | AAPL | Stock | 36.1575 | 36.1575 | 36.1575 | 36.1575 | 400.0 |
| 2017-04-26 07:00:00 | AAPL | Stock | 36.1375 | 36.1375 | 36.1375 | 36.1375 | 1200.0 |
| 2017-04-26 07:02:00 | AAPL | Stock | 36.14 | 36.14 | 36.14 | 36.14 | 4484.0 |
| 2017-04-26 07:03:00 | AAPL | Stock | 36.1375 | 36.1375 | 36.1375 | 36.1375 | 588.0 |
| 2017-04-26 07:05:00 | AAPL | Stock | 36.14 | 36.14 | 36.14 | 36.14 | 416.0 |
| 2017-04-26 07:06:00 | AAPL | Stock | 36.1375 | 36.1375 | 36.1375 | 36.1375 | 400.0 |
| 2017-04-26 07:08:00 | AAPL | Stock | 36.125 | 36.125 | 36.125 | 36.125 | 3200.0 |
| 2017-04-26 07:15:00 | AAPL | Stock | 36.1375 | 36.1375 | 36.1375 | 36.1375 | 1232.0 |
| 2017-04-26 07:16:00 | AAPL | Stock | 36.14 | 36.14 | 36.14 | 36.14 | 4000.0 |
| 2017-04-26 07:17:00 | AAPL | Stock | 36.14 | 36.14 | 36.14 | 36.14 | 4588.0 |
| 2017-04-26 07:20:00 | AAPL | Stock | 36.125 | 36.1375 | 36.125 | 36.125 | 4800.0 |
| 2017-04-26 07:22:00 | AAPL | Stock | 36.125 | 36.125 | 36.125 | 36.125 | 3632.0 |
| 2017-04-26 07:31:00 | AAPL | Stock | 36.1 | 36.1 | 36.1 | 36.1 | 800.0 |
| 2017-04-26 07:32:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1 | 36.1 | 2000.0 |
| 2017-04-26 07:33:00 | AAPL | Stock | 36.0925 | 36.0925 | 36.0925 | 36.0925 | 4000.0 |
| 2017-04-26 07:34:00 | AAPL | Stock | 36.0925 | 36.1 | 36.0925 | 36.0925 | 4800.0 |
| 2017-04-26 07:35:00 | AAPL | Stock | 36.11 | 36.125 | 36.11 | 36.125 | 7664.0 |
| 2017-04-26 07:38:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1 | 36.1 | 2260.0 |
| 2017-04-26 07:40:00 | AAPL | Stock | 36.105 | 36.105 | 36.1025 | 36.1025 | 7600.0 |
| 2017-04-26 07:41:00 | AAPL | Stock | 36.1 | 36.1025 | 36.1 | 36.1025 | 8228.0 |
| 2017-04-26 07:44:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1025 | 36.1025 | 11976.0 |
| 2017-04-26 07:45:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1025 | 36.1025 | 588.0 |
| 2017-04-26 07:46:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1025 | 36.1025 | 492.0 |
| 2017-04-26 07:47:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1025 | 36.1025 | 2800.0 |
| 2017-04-26 07:49:00 | AAPL | Stock | 36.1025 | 36.1025 | 36.1025 | 36.1025 | 8504.0 |
| 2017-04-26 07:56:00 | AAPL | Stock | 36.125 | 36.1725 | 36.125 | 36.1725 | 29628.0 |
| 2017-04-26 07:59:00 | AAPL | Stock | 36.15 | 36.15 | 36.15 | 36.15 | 800.0 |
| 2017-04-26 08:00:00 | AAPL | Stock | 36.125 | 36.1675 | 36.1 | 36.1675 | 24208.0 |
| 2017-04-26 08:01:00 | AAPL | Stock | 36.165 | 36.165 | 36.165 | 36.165 | 400.0 |
| 2017-04-26 08:02:00 | AAPL | Stock | 36.165 | 36.165 | 36.165 | 36.165 | 400.0 |
> showing 50 of 1,102,928 rows — these rows as CSV