PREVIEW / stock_1min / 2007-08-30
file: by_date/stock_1min/2007/2007-08-30.parquet size: 10.9 MB rows: 895,317 symbols: 2,525
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-30 09:30:00 | AAPL | Stock | 4.7357 | 4.7496 | 4.7343 | 4.7491 | 10555356.0 |
| 2007-08-30 09:31:00 | AAPL | Stock | 4.75 | 4.75 | 4.7275 | 4.7275 | 5760356.0 |
| 2007-08-30 09:32:00 | AAPL | Stock | 4.7275 | 4.7486 | 4.725 | 4.7364 | 5239192.0 |
| 2007-08-30 09:33:00 | AAPL | Stock | 4.7379 | 4.7411 | 4.7336 | 4.7354 | 3315368.0 |
| 2007-08-30 09:34:00 | AAPL | Stock | 4.7346 | 4.75 | 4.7343 | 4.7486 | 5395572.0 |
| 2007-08-30 09:35:00 | AAPL | Stock | 4.7493 | 4.7546 | 4.7446 | 4.7461 | 7877436.0 |
| 2007-08-30 09:36:00 | AAPL | Stock | 4.7461 | 4.7532 | 4.7443 | 4.7507 | 3698184.0 |
| 2007-08-30 09:37:00 | AAPL | Stock | 4.7511 | 4.7586 | 4.7486 | 4.7561 | 4402692.0 |
| 2007-08-30 09:38:00 | AAPL | Stock | 4.7557 | 4.7693 | 4.7554 | 4.7689 | 6149696.0 |
| 2007-08-30 09:39:00 | AAPL | Stock | 4.7686 | 4.7832 | 4.7679 | 4.7757 | 6048952.0 |
| 2007-08-30 09:40:00 | AAPL | Stock | 4.7757 | 4.7779 | 4.7682 | 4.7761 | 5712476.0 |
| 2007-08-30 09:41:00 | AAPL | Stock | 4.7761 | 4.7882 | 4.7748 | 4.7882 | 5721856.0 |
| 2007-08-30 09:42:00 | AAPL | Stock | 4.7879 | 4.7929 | 4.7854 | 4.7875 | 7677096.0 |
| 2007-08-30 09:43:00 | AAPL | Stock | 4.7882 | 4.8054 | 4.7868 | 4.8054 | 8611148.0 |
| 2007-08-30 09:44:00 | AAPL | Stock | 4.8046 | 4.8054 | 4.7946 | 4.795 | 6774012.0 |
| 2007-08-30 09:45:00 | AAPL | Stock | 4.7954 | 4.8046 | 4.7886 | 4.8043 | 6930420.0 |
| 2007-08-30 09:46:00 | AAPL | Stock | 4.8046 | 4.8214 | 4.7996 | 4.8161 | 9231180.0 |
| 2007-08-30 09:47:00 | AAPL | Stock | 4.8161 | 4.8318 | 4.815 | 4.8318 | 13501208.0 |
| 2007-08-30 09:48:00 | AAPL | Stock | 4.8318 | 4.8543 | 4.8289 | 4.8404 | 13104868.0 |
| 2007-08-30 09:49:00 | AAPL | Stock | 4.8404 | 4.8489 | 4.8364 | 4.8389 | 7979188.0 |
| 2007-08-30 09:50:00 | AAPL | Stock | 4.8414 | 4.8571 | 4.8414 | 4.8507 | 8601768.0 |
| 2007-08-30 09:51:00 | AAPL | Stock | 4.8516 | 4.8629 | 4.8411 | 4.86 | 10437000.0 |
| 2007-08-30 09:52:00 | AAPL | Stock | 4.8611 | 4.875 | 4.8561 | 4.8696 | 10579856.0 |
| 2007-08-30 09:53:00 | AAPL | Stock | 4.8707 | 4.8825 | 4.8636 | 4.8721 | 8195180.0 |
| 2007-08-30 09:54:00 | AAPL | Stock | 4.8725 | 4.875 | 4.8643 | 4.8646 | 8785336.0 |
| 2007-08-30 09:55:00 | AAPL | Stock | 4.8646 | 4.8818 | 4.8639 | 4.8729 | 8382276.0 |
| 2007-08-30 09:56:00 | AAPL | Stock | 4.8725 | 4.8893 | 4.8707 | 4.8818 | 8939224.0 |
| 2007-08-30 09:57:00 | AAPL | Stock | 4.8826 | 4.8921 | 4.8796 | 4.8854 | 9180276.0 |
| 2007-08-30 09:58:00 | AAPL | Stock | 4.8857 | 4.8893 | 4.8814 | 4.8861 | 6302184.0 |
| 2007-08-30 09:59:00 | AAPL | Stock | 4.8871 | 4.8982 | 4.8796 | 4.8871 | 9944172.0 |
| 2007-08-30 10:00:00 | AAPL | Stock | 4.8857 | 4.8904 | 4.8714 | 4.8714 | 9058728.0 |
| 2007-08-30 10:01:00 | AAPL | Stock | 4.8717 | 4.8783 | 4.8686 | 4.8714 | 5933452.0 |
| 2007-08-30 10:02:00 | AAPL | Stock | 4.8714 | 4.8779 | 4.8621 | 4.8668 | 6192704.0 |
| 2007-08-30 10:03:00 | AAPL | Stock | 4.8647 | 4.8675 | 4.8582 | 4.8607 | 8628284.0 |
| 2007-08-30 10:04:00 | AAPL | Stock | 4.8607 | 4.8739 | 4.8571 | 4.8732 | 7335020.0 |
| 2007-08-30 10:05:00 | AAPL | Stock | 4.8739 | 4.8875 | 4.8682 | 4.8868 | 6572664.0 |
| 2007-08-30 10:06:00 | AAPL | Stock | 4.8861 | 4.9 | 4.8761 | 4.8989 | 9570008.0 |
| 2007-08-30 10:07:00 | AAPL | Stock | 4.9 | 4.9018 | 4.8918 | 4.8996 | 9330552.0 |
| 2007-08-30 10:08:00 | AAPL | Stock | 4.8996 | 4.9129 | 4.8976 | 4.9082 | 11689216.0 |
| 2007-08-30 10:09:00 | AAPL | Stock | 4.9079 | 4.9125 | 4.9039 | 4.9064 | 8569512.0 |
| 2007-08-30 10:10:00 | AAPL | Stock | 4.9064 | 4.9104 | 4.8929 | 4.8939 | 7171052.0 |
| 2007-08-30 10:11:00 | AAPL | Stock | 4.8929 | 4.8979 | 4.8882 | 4.8954 | 6199704.0 |
| 2007-08-30 10:12:00 | AAPL | Stock | 4.895 | 4.8982 | 4.8868 | 4.8893 | 4738048.0 |
| 2007-08-30 10:13:00 | AAPL | Stock | 4.8893 | 4.8896 | 4.8814 | 4.8842 | 5784464.0 |
| 2007-08-30 10:14:00 | AAPL | Stock | 4.8839 | 4.8946 | 4.8811 | 4.8936 | 3705632.0 |
| 2007-08-30 10:15:00 | AAPL | Stock | 4.8936 | 4.8993 | 4.8846 | 4.8993 | 3656548.0 |
| 2007-08-30 10:16:00 | AAPL | Stock | 4.8982 | 4.9061 | 4.8975 | 4.8989 | 4764900.0 |
| 2007-08-30 10:17:00 | AAPL | Stock | 4.8989 | 4.9011 | 4.8929 | 4.8939 | 3366552.0 |
| 2007-08-30 10:18:00 | AAPL | Stock | 4.8932 | 4.9054 | 4.8918 | 4.9039 | 3729320.0 |
| 2007-08-30 10:19:00 | AAPL | Stock | 4.9043 | 4.9157 | 4.9025 | 4.9143 | 8466360.0 |
> showing 50 of 895,317 rows — these rows as CSV