PREVIEW / stock_1min / 2007-08-06
file: by_date/stock_1min/2007/2007-08-06.parquet size: 13.8 MB rows: 1,095,145 symbols: 2,542
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-06 09:30:00 | AAPL | Stock | 4.7464 | 4.7532 | 4.73 | 4.7318 | 10386572.0 |
| 2007-08-06 09:31:00 | AAPL | Stock | 4.7311 | 4.75 | 4.7232 | 4.7361 | 6028232.0 |
| 2007-08-06 09:32:00 | AAPL | Stock | 4.7364 | 4.755 | 4.7321 | 4.7536 | 4407732.0 |
| 2007-08-06 09:33:00 | AAPL | Stock | 4.75 | 4.7679 | 4.7468 | 4.7668 | 4783632.0 |
| 2007-08-06 09:34:00 | AAPL | Stock | 4.7668 | 4.7675 | 4.7518 | 4.7611 | 4117680.0 |
| 2007-08-06 09:35:00 | AAPL | Stock | 4.7596 | 4.766 | 4.7519 | 4.7545 | 3033156.0 |
| 2007-08-06 09:36:00 | AAPL | Stock | 4.7536 | 4.7639 | 4.7271 | 4.7304 | 4591384.0 |
| 2007-08-06 09:37:00 | AAPL | Stock | 4.7293 | 4.7574 | 4.7143 | 4.7246 | 4818016.0 |
| 2007-08-06 09:38:00 | AAPL | Stock | 4.7261 | 4.7364 | 4.7158 | 4.7307 | 3128832.0 |
| 2007-08-06 09:39:00 | AAPL | Stock | 4.7304 | 4.7536 | 4.7296 | 4.7361 | 5274836.0 |
| 2007-08-06 09:40:00 | AAPL | Stock | 4.7407 | 4.7429 | 4.7246 | 4.7296 | 2779140.0 |
| 2007-08-06 09:41:00 | AAPL | Stock | 4.7286 | 4.7311 | 4.7161 | 4.7221 | 4266528.0 |
| 2007-08-06 09:42:00 | AAPL | Stock | 4.7218 | 4.7268 | 4.7086 | 4.7154 | 5288080.0 |
| 2007-08-06 09:43:00 | AAPL | Stock | 4.715 | 4.7296 | 4.7107 | 4.7214 | 3835356.0 |
| 2007-08-06 09:44:00 | AAPL | Stock | 4.722 | 4.7292 | 4.7146 | 4.7154 | 3127824.0 |
| 2007-08-06 09:45:00 | AAPL | Stock | 4.7154 | 4.7157 | 4.7011 | 4.7089 | 5084940.0 |
| 2007-08-06 09:46:00 | AAPL | Stock | 4.7093 | 4.7154 | 4.6814 | 4.6882 | 5655552.0 |
| 2007-08-06 09:47:00 | AAPL | Stock | 4.6871 | 4.6871 | 4.655 | 4.6625 | 8037092.0 |
| 2007-08-06 09:48:00 | AAPL | Stock | 4.6618 | 4.6846 | 4.6607 | 4.6664 | 5436172.0 |
| 2007-08-06 09:49:00 | AAPL | Stock | 4.6664 | 4.6718 | 4.6339 | 4.6382 | 8732220.0 |
| 2007-08-06 09:50:00 | AAPL | Stock | 4.6379 | 4.6382 | 4.6079 | 4.6168 | 8266748.0 |
| 2007-08-06 09:51:00 | AAPL | Stock | 4.6161 | 4.625 | 4.5982 | 4.6161 | 7956340.0 |
| 2007-08-06 09:52:00 | AAPL | Stock | 4.6132 | 4.6464 | 4.6071 | 4.63 | 8768424.0 |
| 2007-08-06 09:53:00 | AAPL | Stock | 4.6307 | 4.645 | 4.5821 | 4.5936 | 8515220.0 |
| 2007-08-06 09:54:00 | AAPL | Stock | 4.5925 | 4.6284 | 4.5893 | 4.6243 | 8014944.0 |
| 2007-08-06 09:55:00 | AAPL | Stock | 4.6239 | 4.6679 | 4.5971 | 4.6636 | 8304828.0 |
| 2007-08-06 09:56:00 | AAPL | Stock | 4.6636 | 4.6646 | 4.6275 | 4.6454 | 5213684.0 |
| 2007-08-06 09:57:00 | AAPL | Stock | 4.6457 | 4.6682 | 4.6404 | 4.6675 | 4174828.0 |
| 2007-08-06 09:58:00 | AAPL | Stock | 4.6675 | 4.6714 | 4.6536 | 4.6679 | 4803876.0 |
| 2007-08-06 09:59:00 | AAPL | Stock | 4.6671 | 4.6746 | 4.6614 | 4.6625 | 4924444.0 |
| 2007-08-06 10:00:00 | AAPL | Stock | 4.6632 | 4.6961 | 4.6632 | 4.67 | 8182216.0 |
| 2007-08-06 10:01:00 | AAPL | Stock | 4.6679 | 4.6875 | 4.6679 | 4.6768 | 6392036.0 |
| 2007-08-06 10:02:00 | AAPL | Stock | 4.6779 | 4.6864 | 4.6746 | 4.6832 | 2920120.0 |
| 2007-08-06 10:03:00 | AAPL | Stock | 4.685 | 4.6868 | 4.6757 | 4.6757 | 3333148.0 |
| 2007-08-06 10:04:00 | AAPL | Stock | 4.6757 | 4.6832 | 4.6571 | 4.6679 | 5095328.0 |
| 2007-08-06 10:05:00 | AAPL | Stock | 4.6679 | 4.6846 | 4.6603 | 4.6629 | 3493532.0 |
| 2007-08-06 10:06:00 | AAPL | Stock | 4.6629 | 4.6814 | 4.6629 | 4.6736 | 2167620.0 |
| 2007-08-06 10:07:00 | AAPL | Stock | 4.6732 | 4.6782 | 4.6639 | 4.6732 | 2526188.0 |
| 2007-08-06 10:08:00 | AAPL | Stock | 4.6757 | 4.6757 | 4.6579 | 4.6625 | 3999352.0 |
| 2007-08-06 10:09:00 | AAPL | Stock | 4.6611 | 4.6732 | 4.6611 | 4.6675 | 2476684.0 |
| 2007-08-06 10:10:00 | AAPL | Stock | 4.6664 | 4.6665 | 4.6464 | 4.6464 | 3990616.0 |
| 2007-08-06 10:11:00 | AAPL | Stock | 4.6477 | 4.6489 | 4.6225 | 4.6275 | 5878124.0 |
| 2007-08-06 10:12:00 | AAPL | Stock | 4.6282 | 4.6429 | 4.6282 | 4.6379 | 3989188.0 |
| 2007-08-06 10:13:00 | AAPL | Stock | 4.6389 | 4.6404 | 4.6282 | 4.6371 | 3237304.0 |
| 2007-08-06 10:14:00 | AAPL | Stock | 4.6375 | 4.64 | 4.6304 | 4.6371 | 2133852.0 |
| 2007-08-06 10:15:00 | AAPL | Stock | 4.6368 | 4.6368 | 4.6286 | 4.6341 | 2107196.0 |
| 2007-08-06 10:16:00 | AAPL | Stock | 4.6339 | 4.6454 | 4.6329 | 4.6429 | 4955748.0 |
| 2007-08-06 10:17:00 | AAPL | Stock | 4.6429 | 4.6629 | 4.6425 | 4.6554 | 3994872.0 |
| 2007-08-06 10:18:00 | AAPL | Stock | 4.6568 | 4.6607 | 4.65 | 4.6504 | 2020984.0 |
| 2007-08-06 10:19:00 | AAPL | Stock | 4.65 | 4.6507 | 4.6375 | 4.6425 | 2475452.0 |
> showing 50 of 1,095,145 rows — these rows as CSV