PREVIEW / stock_1min / 2005-08-02
file: by_date/stock_1min/2005/2005-08-02.parquet size: 7.3 MB rows: 603,568 symbols: 1,680
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 |
|---|---|---|---|---|---|---|---|
| 2005-08-02 08:18:00 | AAPL | Stock | 1.525 | 1.525 | 1.525 | 1.525 | 13664.0 |
| 2005-08-02 08:27:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5286 | 1.5286 | 15120.0 |
| 2005-08-02 08:32:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5282 | 1.5282 | 5600.0 |
| 2005-08-02 08:34:00 | AAPL | Stock | 1.5282 | 1.5282 | 1.5282 | 1.5282 | 2800.0 |
| 2005-08-02 08:36:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 2800.0 |
| 2005-08-02 08:42:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 16800.0 |
| 2005-08-02 08:44:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 36400.0 |
| 2005-08-02 08:49:00 | AAPL | Stock | 1.5264 | 1.5264 | 1.5264 | 1.5264 | 2800.0 |
| 2005-08-02 08:52:00 | AAPL | Stock | 1.5261 | 1.5261 | 1.5261 | 1.5261 | 2800.0 |
| 2005-08-02 09:00:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 39200.0 |
| 2005-08-02 09:04:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 5796.0 |
| 2005-08-02 09:08:00 | AAPL | Stock | 1.5293 | 1.5304 | 1.5268 | 1.5279 | 208880.0 |
| 2005-08-02 09:09:00 | AAPL | Stock | 1.53 | 1.5304 | 1.5282 | 1.5282 | 23716.0 |
| 2005-08-02 09:10:00 | AAPL | Stock | 1.5314 | 1.5314 | 1.5304 | 1.5304 | 6720.0 |
| 2005-08-02 09:11:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5304 | 1.5304 | 13720.0 |
| 2005-08-02 09:13:00 | AAPL | Stock | 1.5304 | 1.5304 | 1.5304 | 1.5304 | 3444.0 |
| 2005-08-02 09:20:00 | AAPL | Stock | 1.5268 | 1.5268 | 1.5268 | 1.5268 | 10080.0 |
| 2005-08-02 09:25:00 | AAPL | Stock | 1.53 | 1.5336 | 1.5268 | 1.5336 | 114156.0 |
| 2005-08-02 09:26:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5336 | 1.5336 | 83356.0 |
| 2005-08-02 09:27:00 | AAPL | Stock | 1.5336 | 1.5336 | 1.5311 | 1.5336 | 94556.0 |
| 2005-08-02 09:29:00 | AAPL | Stock | 1.5286 | 1.5286 | 1.5271 | 1.5271 | 11200.0 |
| 2005-08-02 09:30:00 | AAPL | Stock | 1.5318 | 1.5318 | 1.5254 | 1.5296 | 3684352.0 |
| 2005-08-02 09:31:00 | AAPL | Stock | 1.5293 | 1.5332 | 1.5293 | 1.5318 | 641032.0 |
| 2005-08-02 09:32:00 | AAPL | Stock | 1.5318 | 1.5329 | 1.53 | 1.5329 | 765548.0 |
| 2005-08-02 09:33:00 | AAPL | Stock | 1.5329 | 1.5329 | 1.5279 | 1.5279 | 1327368.0 |
| 2005-08-02 09:34:00 | AAPL | Stock | 1.5279 | 1.5311 | 1.5275 | 1.5304 | 1569988.0 |
| 2005-08-02 09:35:00 | AAPL | Stock | 1.53 | 1.5325 | 1.5286 | 1.5289 | 646128.0 |
| 2005-08-02 09:36:00 | AAPL | Stock | 1.5289 | 1.5289 | 1.5257 | 1.5261 | 492520.0 |
| 2005-08-02 09:37:00 | AAPL | Stock | 1.5254 | 1.5257 | 1.5236 | 1.5236 | 1466808.0 |
| 2005-08-02 09:38:00 | AAPL | Stock | 1.5236 | 1.5257 | 1.5218 | 1.5243 | 1022756.0 |
| 2005-08-02 09:39:00 | AAPL | Stock | 1.5229 | 1.5268 | 1.5225 | 1.5264 | 649012.0 |
| 2005-08-02 09:40:00 | AAPL | Stock | 1.5264 | 1.5264 | 1.5239 | 1.5257 | 746844.0 |
| 2005-08-02 09:41:00 | AAPL | Stock | 1.5257 | 1.5268 | 1.5254 | 1.5254 | 666876.0 |
| 2005-08-02 09:42:00 | AAPL | Stock | 1.525 | 1.5275 | 1.5236 | 1.5271 | 657356.0 |
| 2005-08-02 09:43:00 | AAPL | Stock | 1.5275 | 1.5321 | 1.5273 | 1.53 | 1159144.0 |
| 2005-08-02 09:44:00 | AAPL | Stock | 1.53 | 1.5339 | 1.5286 | 1.5336 | 2037784.0 |
| 2005-08-02 09:45:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5332 | 1.5339 | 564900.0 |
| 2005-08-02 09:46:00 | AAPL | Stock | 1.5339 | 1.535 | 1.5336 | 1.5346 | 789908.0 |
| 2005-08-02 09:47:00 | AAPL | Stock | 1.535 | 1.5354 | 1.5336 | 1.5343 | 816900.0 |
| 2005-08-02 09:48:00 | AAPL | Stock | 1.5339 | 1.5343 | 1.5311 | 1.5325 | 451332.0 |
| 2005-08-02 09:49:00 | AAPL | Stock | 1.5329 | 1.5339 | 1.5321 | 1.5325 | 844480.0 |
| 2005-08-02 09:50:00 | AAPL | Stock | 1.5325 | 1.5332 | 1.5307 | 1.5329 | 1195348.0 |
| 2005-08-02 09:51:00 | AAPL | Stock | 1.5336 | 1.5343 | 1.5318 | 1.5336 | 307384.0 |
| 2005-08-02 09:52:00 | AAPL | Stock | 1.5343 | 1.535 | 1.5339 | 1.535 | 588224.0 |
| 2005-08-02 09:53:00 | AAPL | Stock | 1.535 | 1.5364 | 1.5346 | 1.5364 | 1034908.0 |
| 2005-08-02 09:54:00 | AAPL | Stock | 1.5368 | 1.5368 | 1.5325 | 1.5329 | 1260168.0 |
| 2005-08-02 09:55:00 | AAPL | Stock | 1.5332 | 1.5346 | 1.5329 | 1.5332 | 277900.0 |
| 2005-08-02 09:56:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5332 | 1.5339 | 30800.0 |
| 2005-08-02 09:57:00 | AAPL | Stock | 1.5339 | 1.5339 | 1.5336 | 1.5339 | 70000.0 |
| 2005-08-02 09:58:00 | AAPL | Stock | 1.5336 | 1.5339 | 1.5321 | 1.5321 | 240688.0 |
> showing 50 of 603,568 rows — these rows as CSV