PREVIEW / stock_1min / 2004-10-06
file: by_date/stock_1min/2004/2004-10-06.parquet size: 5.9 MB rows: 500,257 symbols: 1,511
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-06 08:01:00 | AAPL | Stock | 0.7023 | 0.7023 | 0.7009 | 0.7018 | 84000.0 |
| 2004-10-06 08:03:00 | AAPL | Stock | 0.7064 | 0.7064 | 0.7064 | 0.7064 | 7840.0 |
| 2004-10-06 08:05:00 | AAPL | Stock | 0.7064 | 0.7064 | 0.7064 | 0.7064 | 28000.0 |
| 2004-10-06 08:06:00 | AAPL | Stock | 0.7066 | 0.7071 | 0.7066 | 0.7071 | 11200.0 |
| 2004-10-06 08:07:00 | AAPL | Stock | 0.7071 | 0.7071 | 0.7071 | 0.7071 | 16800.0 |
| 2004-10-06 08:08:00 | AAPL | Stock | 0.7071 | 0.7071 | 0.7071 | 0.7071 | 28000.0 |
| 2004-10-06 08:29:00 | AAPL | Stock | 0.7054 | 0.7054 | 0.7054 | 0.7054 | 5600.0 |
| 2004-10-06 08:38:00 | AAPL | Stock | 0.7068 | 0.7068 | 0.7068 | 0.7068 | 12320.0 |
| 2004-10-06 08:56:00 | AAPL | Stock | 0.7066 | 0.7066 | 0.7066 | 0.7066 | 22400.0 |
| 2004-10-06 09:12:00 | AAPL | Stock | 0.7063 | 0.7063 | 0.7063 | 0.7063 | 28000.0 |
| 2004-10-06 09:25:00 | AAPL | Stock | 0.7045 | 0.7045 | 0.7045 | 0.7045 | 22400.0 |
| 2004-10-06 09:26:00 | AAPL | Stock | 0.7046 | 0.7048 | 0.7046 | 0.7048 | 33600.0 |
| 2004-10-06 09:27:00 | AAPL | Stock | 0.7052 | 0.7052 | 0.7052 | 0.7052 | 55328.0 |
| 2004-10-06 09:29:00 | AAPL | Stock | 0.7052 | 0.7054 | 0.7048 | 0.7054 | 273112.0 |
| 2004-10-06 09:30:00 | AAPL | Stock | 0.7054 | 0.7064 | 0.7048 | 0.7055 | 3628128.0 |
| 2004-10-06 09:31:00 | AAPL | Stock | 0.7057 | 0.7064 | 0.7054 | 0.7059 | 1236144.0 |
| 2004-10-06 09:32:00 | AAPL | Stock | 0.7061 | 0.7061 | 0.7048 | 0.7048 | 670656.0 |
| 2004-10-06 09:33:00 | AAPL | Stock | 0.705 | 0.7054 | 0.7048 | 0.7054 | 448000.0 |
| 2004-10-06 09:34:00 | AAPL | Stock | 0.705 | 0.7061 | 0.7048 | 0.7061 | 978600.0 |
| 2004-10-06 09:35:00 | AAPL | Stock | 0.7059 | 0.7071 | 0.7057 | 0.7071 | 1229032.0 |
| 2004-10-06 09:36:00 | AAPL | Stock | 0.707 | 0.7089 | 0.7068 | 0.7088 | 1794800.0 |
| 2004-10-06 09:37:00 | AAPL | Stock | 0.7088 | 0.7096 | 0.7075 | 0.7075 | 1525160.0 |
| 2004-10-06 09:38:00 | AAPL | Stock | 0.7075 | 0.7079 | 0.7068 | 0.7068 | 1239448.0 |
| 2004-10-06 09:39:00 | AAPL | Stock | 0.7066 | 0.7079 | 0.7066 | 0.7079 | 730352.0 |
| 2004-10-06 09:40:00 | AAPL | Stock | 0.708 | 0.7095 | 0.708 | 0.7091 | 653856.0 |
| 2004-10-06 09:41:00 | AAPL | Stock | 0.7091 | 0.7098 | 0.7079 | 0.7096 | 1401512.0 |
| 2004-10-06 09:42:00 | AAPL | Stock | 0.7096 | 0.7107 | 0.7093 | 0.71 | 1669640.0 |
| 2004-10-06 09:43:00 | AAPL | Stock | 0.7098 | 0.7107 | 0.7098 | 0.7105 | 1318968.0 |
| 2004-10-06 09:44:00 | AAPL | Stock | 0.7105 | 0.7105 | 0.71 | 0.7104 | 1253504.0 |
| 2004-10-06 09:45:00 | AAPL | Stock | 0.7104 | 0.7105 | 0.7095 | 0.7095 | 1910104.0 |
| 2004-10-06 09:46:00 | AAPL | Stock | 0.7096 | 0.7113 | 0.7095 | 0.7113 | 5360600.0 |
| 2004-10-06 09:47:00 | AAPL | Stock | 0.7111 | 0.7129 | 0.7104 | 0.7129 | 3748528.0 |
| 2004-10-06 09:48:00 | AAPL | Stock | 0.713 | 0.7139 | 0.7118 | 0.7127 | 4668272.0 |
| 2004-10-06 09:49:00 | AAPL | Stock | 0.7127 | 0.7127 | 0.7113 | 0.7113 | 1700384.0 |
| 2004-10-06 09:50:00 | AAPL | Stock | 0.712 | 0.712 | 0.7116 | 0.7116 | 819616.0 |
| 2004-10-06 09:51:00 | AAPL | Stock | 0.7118 | 0.7118 | 0.7113 | 0.7113 | 1108464.0 |
| 2004-10-06 09:52:00 | AAPL | Stock | 0.7114 | 0.7116 | 0.7107 | 0.7107 | 1702904.0 |
| 2004-10-06 09:53:00 | AAPL | Stock | 0.7105 | 0.7113 | 0.7105 | 0.7107 | 534800.0 |
| 2004-10-06 09:54:00 | AAPL | Stock | 0.7107 | 0.7116 | 0.7105 | 0.7111 | 1077888.0 |
| 2004-10-06 09:55:00 | AAPL | Stock | 0.7111 | 0.7111 | 0.7102 | 0.7105 | 747992.0 |
| 2004-10-06 09:56:00 | AAPL | Stock | 0.7105 | 0.7105 | 0.7102 | 0.7102 | 526400.0 |
| 2004-10-06 09:57:00 | AAPL | Stock | 0.7102 | 0.7104 | 0.7095 | 0.7104 | 1107120.0 |
| 2004-10-06 09:58:00 | AAPL | Stock | 0.7104 | 0.7111 | 0.7104 | 0.7104 | 764400.0 |
| 2004-10-06 09:59:00 | AAPL | Stock | 0.7104 | 0.7111 | 0.7096 | 0.7104 | 1357104.0 |
| 2004-10-06 10:00:00 | AAPL | Stock | 0.7104 | 0.7107 | 0.7102 | 0.7102 | 481600.0 |
| 2004-10-06 10:01:00 | AAPL | Stock | 0.7104 | 0.7104 | 0.71 | 0.7104 | 523096.0 |
| 2004-10-06 10:02:00 | AAPL | Stock | 0.7102 | 0.7102 | 0.7095 | 0.71 | 495936.0 |
| 2004-10-06 10:03:00 | AAPL | Stock | 0.71 | 0.7102 | 0.7096 | 0.7098 | 1120448.0 |
| 2004-10-06 10:04:00 | AAPL | Stock | 0.7096 | 0.7098 | 0.7095 | 0.7095 | 252000.0 |
| 2004-10-06 10:05:00 | AAPL | Stock | 0.7095 | 0.7096 | 0.7089 | 0.7093 | 2189824.0 |
> showing 50 of 500,257 rows — these rows as CSV