PREVIEW / stock_1min / 2009-10-01
file: by_date/stock_1min/2009/2009-10-01.parquet size: 13.4 MB rows: 1,006,891 symbols: 2,744
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 |
|---|---|---|---|---|---|---|---|
| 2009-10-01 07:22:00 | AAPL | Stock | 6.59 | 6.59 | 6.59 | 6.59 | 6860.0 |
| 2009-10-01 07:27:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 2800.0 |
| 2009-10-01 07:45:00 | AAPL | Stock | 6.6004 | 6.6004 | 6.6004 | 6.6004 | 2800.0 |
| 2009-10-01 07:46:00 | AAPL | Stock | 6.6 | 6.6 | 6.6 | 6.6 | 11200.0 |
| 2009-10-01 07:48:00 | AAPL | Stock | 6.6043 | 6.6043 | 6.6043 | 6.6043 | 5600.0 |
| 2009-10-01 07:51:00 | AAPL | Stock | 6.6025 | 6.6029 | 6.6025 | 6.6029 | 26040.0 |
| 2009-10-01 07:56:00 | AAPL | Stock | 6.6025 | 6.6025 | 6.6025 | 6.6025 | 5600.0 |
| 2009-10-01 08:00:00 | AAPL | Stock | 6.6204 | 6.6204 | 6.6182 | 6.6186 | 33600.0 |
| 2009-10-01 08:01:00 | AAPL | Stock | 6.6107 | 6.6107 | 6.6039 | 6.6071 | 18620.0 |
| 2009-10-01 08:02:00 | AAPL | Stock | 6.6157 | 6.6175 | 6.6157 | 6.6175 | 8400.0 |
| 2009-10-01 08:03:00 | AAPL | Stock | 6.6171 | 6.6171 | 6.6171 | 6.6171 | 16800.0 |
| 2009-10-01 08:04:00 | AAPL | Stock | 6.6082 | 6.6082 | 6.6071 | 6.6071 | 12880.0 |
| 2009-10-01 08:06:00 | AAPL | Stock | 6.6075 | 6.6075 | 6.6075 | 6.6075 | 2800.0 |
| 2009-10-01 08:08:00 | AAPL | Stock | 6.6143 | 6.6143 | 6.6089 | 6.6089 | 5600.0 |
| 2009-10-01 08:09:00 | AAPL | Stock | 6.6107 | 6.6107 | 6.6107 | 6.6107 | 5600.0 |
| 2009-10-01 08:13:00 | AAPL | Stock | 6.6143 | 6.6143 | 6.6143 | 6.6143 | 4340.0 |
| 2009-10-01 08:16:00 | AAPL | Stock | 6.6082 | 6.6082 | 6.6075 | 6.6075 | 11200.0 |
| 2009-10-01 08:18:00 | AAPL | Stock | 6.6082 | 6.6082 | 6.6071 | 6.6071 | 44940.0 |
| 2009-10-01 08:19:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6057 | 6.6057 | 36400.0 |
| 2009-10-01 08:20:00 | AAPL | Stock | 6.6057 | 6.6071 | 6.605 | 6.6071 | 54880.0 |
| 2009-10-01 08:22:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6071 | 6.6071 | 7280.0 |
| 2009-10-01 08:23:00 | AAPL | Stock | 6.6129 | 6.6129 | 6.6129 | 6.6129 | 2800.0 |
| 2009-10-01 08:25:00 | AAPL | Stock | 6.6139 | 6.6139 | 6.6139 | 6.6139 | 2800.0 |
| 2009-10-01 08:26:00 | AAPL | Stock | 6.6129 | 6.615 | 6.6129 | 6.6143 | 48440.0 |
| 2009-10-01 08:27:00 | AAPL | Stock | 6.6168 | 6.6268 | 6.6157 | 6.6268 | 78400.0 |
| 2009-10-01 08:28:00 | AAPL | Stock | 6.625 | 6.6429 | 6.625 | 6.6429 | 128660.0 |
| 2009-10-01 08:29:00 | AAPL | Stock | 6.6382 | 6.6386 | 6.6379 | 6.6386 | 36400.0 |
| 2009-10-01 08:30:00 | AAPL | Stock | 6.6339 | 6.6382 | 6.6214 | 6.6321 | 112980.0 |
| 2009-10-01 08:31:00 | AAPL | Stock | 6.6236 | 6.6311 | 6.6236 | 6.6282 | 25200.0 |
| 2009-10-01 08:32:00 | AAPL | Stock | 6.625 | 6.625 | 6.6071 | 6.6071 | 159096.0 |
| 2009-10-01 08:33:00 | AAPL | Stock | 6.6071 | 6.6107 | 6.6039 | 6.6093 | 47600.0 |
| 2009-10-01 08:34:00 | AAPL | Stock | 6.6136 | 6.6136 | 6.6036 | 6.6036 | 42000.0 |
| 2009-10-01 08:35:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6054 | 6.6071 | 52584.0 |
| 2009-10-01 08:36:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6036 | 6.6036 | 49280.0 |
| 2009-10-01 08:37:00 | AAPL | Stock | 6.6036 | 6.6057 | 6.5982 | 6.5982 | 130060.0 |
| 2009-10-01 08:38:00 | AAPL | Stock | 6.6011 | 6.6068 | 6.5982 | 6.6036 | 51100.0 |
| 2009-10-01 08:39:00 | AAPL | Stock | 6.6014 | 6.6014 | 6.6 | 6.6 | 14000.0 |
| 2009-10-01 08:40:00 | AAPL | Stock | 6.6043 | 6.6071 | 6.6036 | 6.6071 | 73780.0 |
| 2009-10-01 08:41:00 | AAPL | Stock | 6.6007 | 6.6061 | 6.6007 | 6.6061 | 12236.0 |
| 2009-10-01 08:42:00 | AAPL | Stock | 6.6057 | 6.6064 | 6.6054 | 6.6061 | 36400.0 |
| 2009-10-01 08:43:00 | AAPL | Stock | 6.6054 | 6.6054 | 6.6054 | 6.6054 | 2800.0 |
| 2009-10-01 08:44:00 | AAPL | Stock | 6.6054 | 6.6071 | 6.6054 | 6.6071 | 38780.0 |
| 2009-10-01 08:45:00 | AAPL | Stock | 6.6111 | 6.6111 | 6.6071 | 6.6071 | 25200.0 |
| 2009-10-01 08:46:00 | AAPL | Stock | 6.6107 | 6.6107 | 6.6107 | 6.6107 | 5600.0 |
| 2009-10-01 08:47:00 | AAPL | Stock | 6.6136 | 6.6136 | 6.6107 | 6.6107 | 19600.0 |
| 2009-10-01 08:48:00 | AAPL | Stock | 6.6107 | 6.6107 | 6.6071 | 6.6104 | 33684.0 |
| 2009-10-01 08:49:00 | AAPL | Stock | 6.61 | 6.6121 | 6.61 | 6.6121 | 61516.0 |
| 2009-10-01 08:50:00 | AAPL | Stock | 6.6118 | 6.6125 | 6.6118 | 6.6125 | 5600.0 |
| 2009-10-01 08:52:00 | AAPL | Stock | 6.6114 | 6.6118 | 6.6114 | 6.6118 | 8400.0 |
| 2009-10-01 08:53:00 | AAPL | Stock | 6.6089 | 6.6089 | 6.6089 | 6.6089 | 5600.0 |
> showing 50 of 1,006,891 rows — these rows as CSV