PREVIEW / stock_1min / 2010-02-10
file: by_date/stock_1min/2010/2010-02-10.parquet size: 12.1 MB rows: 926,684 symbols: 2,769
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 |
|---|---|---|---|---|---|---|---|
| 2010-02-10 05:09:00 | AAPL | Stock | 7.0161 | 7.0161 | 7.0161 | 7.0161 | 4004.0 |
| 2010-02-10 05:40:00 | AAPL | Stock | 7.0318 | 7.0318 | 7.0318 | 7.0318 | 2800.0 |
| 2010-02-10 05:48:00 | AAPL | Stock | 7.0318 | 7.0318 | 7.0318 | 7.0318 | 11200.0 |
| 2010-02-10 05:58:00 | AAPL | Stock | 7.0339 | 7.0339 | 7.0339 | 7.0339 | 3584.0 |
| 2010-02-10 06:49:00 | AAPL | Stock | 7.0393 | 7.0393 | 7.0393 | 7.0393 | 28000.0 |
| 2010-02-10 07:02:00 | AAPL | Stock | 7.02 | 7.02 | 7.02 | 7.02 | 2800.0 |
| 2010-02-10 07:17:00 | AAPL | Stock | 7.0179 | 7.0179 | 7.0179 | 7.0179 | 5600.0 |
| 2010-02-10 07:33:00 | AAPL | Stock | 7.0421 | 7.0421 | 7.0421 | 7.0421 | 22512.0 |
| 2010-02-10 07:34:00 | AAPL | Stock | 7.0421 | 7.0421 | 7.0304 | 7.0304 | 15848.0 |
| 2010-02-10 07:38:00 | AAPL | Stock | 7.0361 | 7.0418 | 7.0361 | 7.0418 | 5600.0 |
| 2010-02-10 07:39:00 | AAPL | Stock | 7.0418 | 7.0429 | 7.0418 | 7.0429 | 5600.0 |
| 2010-02-10 07:40:00 | AAPL | Stock | 7.0443 | 7.0446 | 7.0443 | 7.0446 | 16800.0 |
| 2010-02-10 07:43:00 | AAPL | Stock | 7.0446 | 7.0514 | 7.0446 | 7.0514 | 14000.0 |
| 2010-02-10 07:46:00 | AAPL | Stock | 7.0514 | 7.0514 | 7.0514 | 7.0514 | 2800.0 |
| 2010-02-10 07:49:00 | AAPL | Stock | 7.0432 | 7.0432 | 7.0429 | 7.0429 | 14000.0 |
| 2010-02-10 07:53:00 | AAPL | Stock | 7.0386 | 7.0446 | 7.0386 | 7.0446 | 6552.0 |
| 2010-02-10 07:55:00 | AAPL | Stock | 7.04 | 7.04 | 7.04 | 7.04 | 14000.0 |
| 2010-02-10 07:56:00 | AAPL | Stock | 7.04 | 7.04 | 7.0357 | 7.0357 | 59304.0 |
| 2010-02-10 07:57:00 | AAPL | Stock | 7.0357 | 7.0357 | 7.0339 | 7.0339 | 11200.0 |
| 2010-02-10 08:00:00 | AAPL | Stock | 7.0271 | 7.0271 | 7.0182 | 7.025 | 44352.0 |
| 2010-02-10 08:01:00 | AAPL | Stock | 7.0214 | 7.0214 | 7.0214 | 7.0214 | 2800.0 |
| 2010-02-10 08:02:00 | AAPL | Stock | 7.0214 | 7.0243 | 7.0211 | 7.0243 | 21392.0 |
| 2010-02-10 08:03:00 | AAPL | Stock | 7.0232 | 7.0236 | 7.0218 | 7.0218 | 29680.0 |
| 2010-02-10 08:04:00 | AAPL | Stock | 7.0225 | 7.025 | 7.0221 | 7.025 | 57316.0 |
| 2010-02-10 08:06:00 | AAPL | Stock | 7.0221 | 7.025 | 7.0125 | 7.0175 | 280280.0 |
| 2010-02-10 08:07:00 | AAPL | Stock | 7.0143 | 7.0179 | 7.0129 | 7.0139 | 62412.0 |
| 2010-02-10 08:08:00 | AAPL | Stock | 7.0139 | 7.0179 | 7.0139 | 7.0179 | 8148.0 |
| 2010-02-10 08:09:00 | AAPL | Stock | 7.0179 | 7.0186 | 7.0175 | 7.0179 | 30520.0 |
| 2010-02-10 08:10:00 | AAPL | Stock | 7.0175 | 7.0175 | 7.0132 | 7.0132 | 33600.0 |
| 2010-02-10 08:11:00 | AAPL | Stock | 7.0132 | 7.0132 | 7.0096 | 7.0104 | 61600.0 |
| 2010-02-10 08:12:00 | AAPL | Stock | 7.0114 | 7.0114 | 7.0114 | 7.0114 | 5600.0 |
| 2010-02-10 08:13:00 | AAPL | Stock | 7.0125 | 7.0125 | 7.0111 | 7.0111 | 34160.0 |
| 2010-02-10 08:14:00 | AAPL | Stock | 7.0111 | 7.0111 | 7.0018 | 7.0043 | 37800.0 |
| 2010-02-10 08:15:00 | AAPL | Stock | 7.0018 | 7.0018 | 6.9968 | 7.0 | 120400.0 |
| 2010-02-10 08:16:00 | AAPL | Stock | 7.0032 | 7.005 | 7.0 | 7.0 | 31500.0 |
| 2010-02-10 08:17:00 | AAPL | Stock | 7.005 | 7.005 | 7.0018 | 7.0018 | 30240.0 |
| 2010-02-10 08:18:00 | AAPL | Stock | 7.0082 | 7.0086 | 7.0082 | 7.0086 | 17360.0 |
| 2010-02-10 08:19:00 | AAPL | Stock | 7.0068 | 7.0068 | 7.0018 | 7.0018 | 21700.0 |
| 2010-02-10 08:20:00 | AAPL | Stock | 7.0018 | 7.0018 | 7.0018 | 7.0018 | 11200.0 |
| 2010-02-10 08:21:00 | AAPL | Stock | 7.0007 | 7.0039 | 7.0007 | 7.0029 | 11200.0 |
| 2010-02-10 08:22:00 | AAPL | Stock | 7.0029 | 7.0043 | 7.0029 | 7.0043 | 23604.0 |
| 2010-02-10 08:23:00 | AAPL | Stock | 7.0046 | 7.0068 | 7.0046 | 7.0068 | 5600.0 |
| 2010-02-10 08:24:00 | AAPL | Stock | 7.0075 | 7.0075 | 7.0075 | 7.0075 | 2800.0 |
| 2010-02-10 08:25:00 | AAPL | Stock | 7.0104 | 7.0111 | 7.0104 | 7.0111 | 5600.0 |
| 2010-02-10 08:27:00 | AAPL | Stock | 7.0111 | 7.0161 | 7.0111 | 7.0161 | 81704.0 |
| 2010-02-10 08:28:00 | AAPL | Stock | 7.0161 | 7.0164 | 7.0139 | 7.0139 | 87080.0 |
| 2010-02-10 08:30:00 | AAPL | Stock | 7.0164 | 7.0193 | 7.0111 | 7.0111 | 51156.0 |
| 2010-02-10 08:31:00 | AAPL | Stock | 7.0114 | 7.0114 | 7.0107 | 7.0107 | 9800.0 |
| 2010-02-10 08:32:00 | AAPL | Stock | 7.0079 | 7.0104 | 7.0068 | 7.0082 | 39172.0 |
| 2010-02-10 08:33:00 | AAPL | Stock | 7.0079 | 7.01 | 7.0079 | 7.01 | 5600.0 |
> showing 50 of 926,684 rows — these rows as CSV