PREVIEW / stock_1min / 2007-05-09
file: by_date/stock_1min/2007/2007-05-09.parquet size: 10.5 MB rows: 867,895 symbols: 2,243
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-05-09 09:30:00 | AAPL | Stock | 3.7468 | 3.7571 | 3.7461 | 3.7543 | 8203160.0 |
| 2007-05-09 09:31:00 | AAPL | Stock | 3.7557 | 3.7575 | 3.7518 | 3.7543 | 4635932.0 |
| 2007-05-09 09:32:00 | AAPL | Stock | 3.7539 | 3.7657 | 3.7482 | 3.7579 | 5111736.0 |
| 2007-05-09 09:33:00 | AAPL | Stock | 3.7582 | 3.7614 | 3.7507 | 3.7554 | 5075168.0 |
| 2007-05-09 09:34:00 | AAPL | Stock | 3.7575 | 3.7589 | 3.7536 | 3.755 | 2618252.0 |
| 2007-05-09 09:35:00 | AAPL | Stock | 3.7543 | 3.755 | 3.7471 | 3.7479 | 3782100.0 |
| 2007-05-09 09:36:00 | AAPL | Stock | 3.7471 | 3.7536 | 3.7464 | 3.7489 | 3331216.0 |
| 2007-05-09 09:37:00 | AAPL | Stock | 3.7482 | 3.7496 | 3.7464 | 3.7493 | 2499756.0 |
| 2007-05-09 09:38:00 | AAPL | Stock | 3.75 | 3.7518 | 3.7475 | 3.7493 | 1740060.0 |
| 2007-05-09 09:39:00 | AAPL | Stock | 3.7493 | 3.7525 | 3.7486 | 3.7489 | 1519364.0 |
| 2007-05-09 09:40:00 | AAPL | Stock | 3.7486 | 3.7536 | 3.7471 | 3.7525 | 2979648.0 |
| 2007-05-09 09:41:00 | AAPL | Stock | 3.7532 | 3.7582 | 3.7518 | 3.7582 | 2466968.0 |
| 2007-05-09 09:42:00 | AAPL | Stock | 3.7582 | 3.7657 | 3.7564 | 3.7646 | 3605812.0 |
| 2007-05-09 09:43:00 | AAPL | Stock | 3.7646 | 3.7721 | 3.7629 | 3.7629 | 7241948.0 |
| 2007-05-09 09:44:00 | AAPL | Stock | 3.7636 | 3.7661 | 3.7471 | 3.7604 | 5604816.0 |
| 2007-05-09 09:45:00 | AAPL | Stock | 3.7604 | 3.7657 | 3.7596 | 3.7657 | 2264332.0 |
| 2007-05-09 09:46:00 | AAPL | Stock | 3.7657 | 3.7714 | 3.765 | 3.7686 | 3716664.0 |
| 2007-05-09 09:47:00 | AAPL | Stock | 3.7693 | 3.7754 | 3.7657 | 3.7729 | 3149132.0 |
| 2007-05-09 09:48:00 | AAPL | Stock | 3.7729 | 3.7739 | 3.7686 | 3.7696 | 2609012.0 |
| 2007-05-09 09:49:00 | AAPL | Stock | 3.7696 | 3.7704 | 3.7636 | 3.7668 | 3173688.0 |
| 2007-05-09 09:50:00 | AAPL | Stock | 3.7668 | 3.7729 | 3.7664 | 3.7714 | 2803528.0 |
| 2007-05-09 09:51:00 | AAPL | Stock | 3.7714 | 3.7739 | 3.7686 | 3.7686 | 2007628.0 |
| 2007-05-09 09:52:00 | AAPL | Stock | 3.7682 | 3.7696 | 3.765 | 3.7693 | 2526356.0 |
| 2007-05-09 09:53:00 | AAPL | Stock | 3.7689 | 3.7704 | 3.7679 | 3.7696 | 1171828.0 |
| 2007-05-09 09:54:00 | AAPL | Stock | 3.7693 | 3.7736 | 3.7671 | 3.7675 | 2711996.0 |
| 2007-05-09 09:55:00 | AAPL | Stock | 3.7689 | 3.7725 | 3.7682 | 3.7714 | 1536976.0 |
| 2007-05-09 09:56:00 | AAPL | Stock | 3.7711 | 3.7775 | 3.7707 | 3.7771 | 4318860.0 |
| 2007-05-09 09:57:00 | AAPL | Stock | 3.7768 | 3.7779 | 3.7728 | 3.7746 | 2117612.0 |
| 2007-05-09 09:58:00 | AAPL | Stock | 3.7746 | 3.775 | 3.7714 | 3.7739 | 1614312.0 |
| 2007-05-09 09:59:00 | AAPL | Stock | 3.7732 | 3.7736 | 3.7711 | 3.7714 | 1954988.0 |
| 2007-05-09 10:00:00 | AAPL | Stock | 3.7714 | 3.775 | 3.7696 | 3.775 | 1859368.0 |
| 2007-05-09 10:01:00 | AAPL | Stock | 3.775 | 3.7807 | 3.7739 | 3.7789 | 3044804.0 |
| 2007-05-09 10:02:00 | AAPL | Stock | 3.7779 | 3.7839 | 3.7771 | 3.7829 | 3440976.0 |
| 2007-05-09 10:03:00 | AAPL | Stock | 3.7825 | 3.7854 | 3.78 | 3.7854 | 2715692.0 |
| 2007-05-09 10:04:00 | AAPL | Stock | 3.7854 | 3.7943 | 3.7843 | 3.7911 | 7961100.0 |
| 2007-05-09 10:05:00 | AAPL | Stock | 3.7911 | 3.7911 | 3.7832 | 3.7879 | 4455892.0 |
| 2007-05-09 10:06:00 | AAPL | Stock | 3.7875 | 3.7918 | 3.785 | 3.7896 | 2829960.0 |
| 2007-05-09 10:07:00 | AAPL | Stock | 3.7896 | 3.7907 | 3.7861 | 3.7861 | 1436876.0 |
| 2007-05-09 10:08:00 | AAPL | Stock | 3.7857 | 3.7911 | 3.7857 | 3.7904 | 2023504.0 |
| 2007-05-09 10:09:00 | AAPL | Stock | 3.7904 | 3.7921 | 3.7886 | 3.7889 | 2103360.0 |
| 2007-05-09 10:10:00 | AAPL | Stock | 3.7889 | 3.7889 | 3.7839 | 3.7861 | 3611804.0 |
| 2007-05-09 10:11:00 | AAPL | Stock | 3.7857 | 3.7879 | 3.7839 | 3.7846 | 2543268.0 |
| 2007-05-09 10:12:00 | AAPL | Stock | 3.7843 | 3.7854 | 3.7804 | 3.7804 | 3724616.0 |
| 2007-05-09 10:13:00 | AAPL | Stock | 3.7811 | 3.7836 | 3.7796 | 3.7829 | 1869476.0 |
| 2007-05-09 10:14:00 | AAPL | Stock | 3.7825 | 3.785 | 3.7807 | 3.7836 | 2146508.0 |
| 2007-05-09 10:15:00 | AAPL | Stock | 3.7836 | 3.785 | 3.7818 | 3.7832 | 744660.0 |
| 2007-05-09 10:16:00 | AAPL | Stock | 3.7832 | 3.7918 | 3.7829 | 3.7885 | 4051600.0 |
| 2007-05-09 10:17:00 | AAPL | Stock | 3.7882 | 3.7893 | 3.7857 | 3.7868 | 1703772.0 |
| 2007-05-09 10:18:00 | AAPL | Stock | 3.7864 | 3.7868 | 3.7832 | 3.7832 | 1454572.0 |
| 2007-05-09 10:19:00 | AAPL | Stock | 3.7832 | 3.7871 | 3.7832 | 3.7861 | 1493044.0 |
> showing 50 of 867,895 rows — these rows as CSV