PREVIEW / stock_1min / 2007-09-06
file: by_date/stock_1min/2007/2007-09-06.parquet size: 10.9 MB rows: 896,702 symbols: 2,535
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-09-06 09:30:00 | AAPL | Stock | 4.8414 | 4.8471 | 4.8214 | 4.8293 | 28694092.0 |
| 2007-09-06 09:31:00 | AAPL | Stock | 4.8296 | 4.8668 | 4.8214 | 4.86 | 14866264.0 |
| 2007-09-06 09:32:00 | AAPL | Stock | 4.86 | 4.8707 | 4.8339 | 4.8514 | 13580168.0 |
| 2007-09-06 09:33:00 | AAPL | Stock | 4.8486 | 4.8507 | 4.8125 | 4.8282 | 14943376.0 |
| 2007-09-06 09:34:00 | AAPL | Stock | 4.8282 | 4.8361 | 4.8189 | 4.8268 | 9516304.0 |
| 2007-09-06 09:35:00 | AAPL | Stock | 4.8275 | 4.8304 | 4.8057 | 4.81 | 12860428.0 |
| 2007-09-06 09:36:00 | AAPL | Stock | 4.81 | 4.8375 | 4.8082 | 4.832 | 9813468.0 |
| 2007-09-06 09:37:00 | AAPL | Stock | 4.8318 | 4.8479 | 4.825 | 4.8429 | 9689596.0 |
| 2007-09-06 09:38:00 | AAPL | Stock | 4.8429 | 4.8507 | 4.8357 | 4.8367 | 8462860.0 |
| 2007-09-06 09:39:00 | AAPL | Stock | 4.8361 | 4.8404 | 4.8218 | 4.8271 | 8310764.0 |
| 2007-09-06 09:40:00 | AAPL | Stock | 4.8268 | 4.8486 | 4.8018 | 4.8039 | 12145196.0 |
| 2007-09-06 09:41:00 | AAPL | Stock | 4.8039 | 4.8161 | 4.7893 | 4.7979 | 13624324.0 |
| 2007-09-06 09:42:00 | AAPL | Stock | 4.7979 | 4.8018 | 4.7814 | 4.8 | 13601588.0 |
| 2007-09-06 09:43:00 | AAPL | Stock | 4.8 | 4.8107 | 4.7911 | 4.8054 | 12319412.0 |
| 2007-09-06 09:44:00 | AAPL | Stock | 4.805 | 4.8125 | 4.7875 | 4.7875 | 8530200.0 |
| 2007-09-06 09:45:00 | AAPL | Stock | 4.7875 | 4.7986 | 4.7821 | 4.7889 | 8967952.0 |
| 2007-09-06 09:46:00 | AAPL | Stock | 4.7858 | 4.7886 | 4.77 | 4.7711 | 9947784.0 |
| 2007-09-06 09:47:00 | AAPL | Stock | 4.7711 | 4.7846 | 4.7707 | 4.7789 | 7417340.0 |
| 2007-09-06 09:48:00 | AAPL | Stock | 4.7796 | 4.7936 | 4.7743 | 4.7789 | 9884028.0 |
| 2007-09-06 09:49:00 | AAPL | Stock | 4.7768 | 4.7836 | 4.7643 | 4.7796 | 8760780.0 |
| 2007-09-06 09:50:00 | AAPL | Stock | 4.7796 | 4.7904 | 4.7689 | 4.7893 | 7227024.0 |
| 2007-09-06 09:51:00 | AAPL | Stock | 4.7893 | 4.7911 | 4.775 | 4.78 | 7792288.0 |
| 2007-09-06 09:52:00 | AAPL | Stock | 4.7807 | 4.7832 | 4.7611 | 4.77 | 6351100.0 |
| 2007-09-06 09:53:00 | AAPL | Stock | 4.77 | 4.7889 | 4.7664 | 4.7832 | 7744856.0 |
| 2007-09-06 09:54:00 | AAPL | Stock | 4.7809 | 4.7921 | 4.7768 | 4.7861 | 7445788.0 |
| 2007-09-06 09:55:00 | AAPL | Stock | 4.7861 | 4.7961 | 4.7714 | 4.7796 | 5645948.0 |
| 2007-09-06 09:56:00 | AAPL | Stock | 4.7782 | 4.7886 | 4.7682 | 4.7687 | 7882000.0 |
| 2007-09-06 09:57:00 | AAPL | Stock | 4.7689 | 4.7846 | 4.7539 | 4.7689 | 13752788.0 |
| 2007-09-06 09:58:00 | AAPL | Stock | 4.7686 | 4.7725 | 4.7604 | 4.7643 | 6265280.0 |
| 2007-09-06 09:59:00 | AAPL | Stock | 4.7643 | 4.7714 | 4.75 | 4.7561 | 11447800.0 |
| 2007-09-06 10:00:00 | AAPL | Stock | 4.7568 | 4.7679 | 4.7446 | 4.7532 | 10149272.0 |
| 2007-09-06 10:01:00 | AAPL | Stock | 4.7529 | 4.7618 | 4.7396 | 4.7461 | 10347092.0 |
| 2007-09-06 10:02:00 | AAPL | Stock | 4.7464 | 4.7595 | 4.7443 | 4.7561 | 9430932.0 |
| 2007-09-06 10:03:00 | AAPL | Stock | 4.7557 | 4.7611 | 4.7457 | 4.7589 | 8932728.0 |
| 2007-09-06 10:04:00 | AAPL | Stock | 4.7593 | 4.7593 | 4.7414 | 4.7486 | 7364168.0 |
| 2007-09-06 10:05:00 | AAPL | Stock | 4.7486 | 4.7679 | 4.7468 | 4.765 | 9425612.0 |
| 2007-09-06 10:06:00 | AAPL | Stock | 4.7642 | 4.77 | 4.7586 | 4.7654 | 5909708.0 |
| 2007-09-06 10:07:00 | AAPL | Stock | 4.7657 | 4.7657 | 4.7486 | 4.7561 | 6512856.0 |
| 2007-09-06 10:08:00 | AAPL | Stock | 4.7568 | 4.775 | 4.755 | 4.775 | 5915504.0 |
| 2007-09-06 10:09:00 | AAPL | Stock | 4.7746 | 4.7757 | 4.7614 | 4.7714 | 4949840.0 |
| 2007-09-06 10:10:00 | AAPL | Stock | 4.7707 | 4.7779 | 4.7639 | 4.7775 | 6073984.0 |
| 2007-09-06 10:11:00 | AAPL | Stock | 4.7771 | 4.7796 | 4.7679 | 4.7711 | 6168708.0 |
| 2007-09-06 10:12:00 | AAPL | Stock | 4.7714 | 4.7836 | 4.7696 | 4.7775 | 5972204.0 |
| 2007-09-06 10:13:00 | AAPL | Stock | 4.7775 | 4.7785 | 4.7618 | 4.7661 | 5789868.0 |
| 2007-09-06 10:14:00 | AAPL | Stock | 4.765 | 4.7736 | 4.7596 | 4.77 | 4522028.0 |
| 2007-09-06 10:15:00 | AAPL | Stock | 4.77 | 4.7714 | 4.7511 | 4.7511 | 4536056.0 |
| 2007-09-06 10:16:00 | AAPL | Stock | 4.7518 | 4.7621 | 4.75 | 4.7618 | 5524148.0 |
| 2007-09-06 10:17:00 | AAPL | Stock | 4.7614 | 4.7614 | 4.7507 | 4.7525 | 4944744.0 |
| 2007-09-06 10:18:00 | AAPL | Stock | 4.7525 | 4.7561 | 4.7468 | 4.7543 | 5549572.0 |
| 2007-09-06 10:19:00 | AAPL | Stock | 4.7554 | 4.7679 | 4.7539 | 4.7636 | 5346012.0 |
> showing 50 of 896,702 rows — these rows as CSV