PREVIEW / stock_1min / 2007-08-29
file: by_date/stock_1min/2007/2007-08-29.parquet size: 11.1 MB rows: 906,729 symbols: 2,539
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-29 09:30:00 | AAPL | Stock | 4.6368 | 4.6411 | 4.6264 | 4.6396 | 9376108.0 |
| 2007-08-29 09:31:00 | AAPL | Stock | 4.64 | 4.6511 | 4.6277 | 4.6496 | 12457340.0 |
| 2007-08-29 09:32:00 | AAPL | Stock | 4.6496 | 4.6561 | 4.6393 | 4.6425 | 9849616.0 |
| 2007-08-29 09:33:00 | AAPL | Stock | 4.6421 | 4.6539 | 4.6371 | 4.65 | 7146720.0 |
| 2007-08-29 09:34:00 | AAPL | Stock | 4.6501 | 4.6629 | 4.6475 | 4.6629 | 9162608.0 |
| 2007-08-29 09:35:00 | AAPL | Stock | 4.6618 | 4.6732 | 4.6482 | 4.6682 | 14204540.0 |
| 2007-08-29 09:36:00 | AAPL | Stock | 4.6682 | 4.6746 | 4.6671 | 4.67 | 9482312.0 |
| 2007-08-29 09:37:00 | AAPL | Stock | 4.6696 | 4.6814 | 4.6696 | 4.6789 | 12050248.0 |
| 2007-08-29 09:38:00 | AAPL | Stock | 4.6789 | 4.695 | 4.6786 | 4.6886 | 11093236.0 |
| 2007-08-29 09:39:00 | AAPL | Stock | 4.6886 | 4.6932 | 4.6796 | 4.6832 | 7849044.0 |
| 2007-08-29 09:40:00 | AAPL | Stock | 4.6839 | 4.6846 | 4.675 | 4.6793 | 7761600.0 |
| 2007-08-29 09:41:00 | AAPL | Stock | 4.6804 | 4.6864 | 4.6768 | 4.6836 | 6153672.0 |
| 2007-08-29 09:42:00 | AAPL | Stock | 4.6846 | 4.6893 | 4.6814 | 4.6851 | 5186356.0 |
| 2007-08-29 09:43:00 | AAPL | Stock | 4.685 | 4.6852 | 4.6679 | 4.6725 | 7689360.0 |
| 2007-08-29 09:44:00 | AAPL | Stock | 4.6714 | 4.6729 | 4.6643 | 4.6671 | 5079424.0 |
| 2007-08-29 09:45:00 | AAPL | Stock | 4.6671 | 4.6732 | 4.6657 | 4.6682 | 3888640.0 |
| 2007-08-29 09:46:00 | AAPL | Stock | 4.6682 | 4.6693 | 4.6611 | 4.6646 | 4514944.0 |
| 2007-08-29 09:47:00 | AAPL | Stock | 4.6646 | 4.6786 | 4.6632 | 4.67 | 3956484.0 |
| 2007-08-29 09:48:00 | AAPL | Stock | 4.67 | 4.6761 | 4.6686 | 4.6718 | 2452604.0 |
| 2007-08-29 09:49:00 | AAPL | Stock | 4.6715 | 4.6829 | 4.6714 | 4.6757 | 4535328.0 |
| 2007-08-29 09:50:00 | AAPL | Stock | 4.6757 | 4.6847 | 4.675 | 4.6786 | 4581304.0 |
| 2007-08-29 09:51:00 | AAPL | Stock | 4.6786 | 4.6829 | 4.6732 | 4.6779 | 3661252.0 |
| 2007-08-29 09:52:00 | AAPL | Stock | 4.6779 | 4.6857 | 4.6771 | 4.6828 | 2650088.0 |
| 2007-08-29 09:53:00 | AAPL | Stock | 4.6821 | 4.6825 | 4.6734 | 4.6779 | 3400040.0 |
| 2007-08-29 09:54:00 | AAPL | Stock | 4.6779 | 4.6789 | 4.6668 | 4.6711 | 3404352.0 |
| 2007-08-29 09:55:00 | AAPL | Stock | 4.6707 | 4.6711 | 4.6571 | 4.6607 | 4741744.0 |
| 2007-08-29 09:56:00 | AAPL | Stock | 4.6582 | 4.6729 | 4.6582 | 4.6696 | 4044488.0 |
| 2007-08-29 09:57:00 | AAPL | Stock | 4.6696 | 4.6768 | 4.6682 | 4.6754 | 2814476.0 |
| 2007-08-29 09:58:00 | AAPL | Stock | 4.675 | 4.6768 | 4.6696 | 4.67 | 2687328.0 |
| 2007-08-29 09:59:00 | AAPL | Stock | 4.67 | 4.6739 | 4.6668 | 4.6729 | 3486532.0 |
| 2007-08-29 10:00:00 | AAPL | Stock | 4.6732 | 4.6764 | 4.6643 | 4.6707 | 4683252.0 |
| 2007-08-29 10:01:00 | AAPL | Stock | 4.6711 | 4.6721 | 4.6664 | 4.6721 | 2411500.0 |
| 2007-08-29 10:02:00 | AAPL | Stock | 4.6714 | 4.6739 | 4.6661 | 4.6686 | 2100112.0 |
| 2007-08-29 10:03:00 | AAPL | Stock | 4.6682 | 4.675 | 4.6682 | 4.6683 | 2342620.0 |
| 2007-08-29 10:04:00 | AAPL | Stock | 4.6693 | 4.6743 | 4.6636 | 4.6704 | 3955084.0 |
| 2007-08-29 10:05:00 | AAPL | Stock | 4.6704 | 4.6786 | 4.6696 | 4.6761 | 3849804.0 |
| 2007-08-29 10:06:00 | AAPL | Stock | 4.6766 | 4.6875 | 4.6739 | 4.6871 | 6995016.0 |
| 2007-08-29 10:07:00 | AAPL | Stock | 4.6875 | 4.6921 | 4.6868 | 4.6904 | 6766480.0 |
| 2007-08-29 10:08:00 | AAPL | Stock | 4.69 | 4.7036 | 4.6871 | 4.7021 | 10620204.0 |
| 2007-08-29 10:09:00 | AAPL | Stock | 4.7021 | 4.7021 | 4.6925 | 4.6939 | 4165392.0 |
| 2007-08-29 10:10:00 | AAPL | Stock | 4.6936 | 4.7089 | 4.6925 | 4.7086 | 7718928.0 |
| 2007-08-29 10:11:00 | AAPL | Stock | 4.7086 | 4.7093 | 4.7029 | 4.7036 | 4542552.0 |
| 2007-08-29 10:12:00 | AAPL | Stock | 4.7036 | 4.7054 | 4.6971 | 4.6984 | 4058572.0 |
| 2007-08-29 10:13:00 | AAPL | Stock | 4.6982 | 4.7014 | 4.6979 | 4.6979 | 1875664.0 |
| 2007-08-29 10:14:00 | AAPL | Stock | 4.6979 | 4.7011 | 4.6675 | 4.6922 | 4585168.0 |
| 2007-08-29 10:15:00 | AAPL | Stock | 4.6914 | 4.6964 | 4.6882 | 4.6946 | 4513824.0 |
| 2007-08-29 10:16:00 | AAPL | Stock | 4.695 | 4.6996 | 4.6893 | 4.6896 | 3505488.0 |
| 2007-08-29 10:17:00 | AAPL | Stock | 4.6896 | 4.6921 | 4.6879 | 4.6903 | 2710372.0 |
| 2007-08-29 10:18:00 | AAPL | Stock | 4.6893 | 4.6893 | 4.6789 | 4.6796 | 4084864.0 |
| 2007-08-29 10:19:00 | AAPL | Stock | 4.6796 | 4.6875 | 4.6789 | 4.6854 | 4034968.0 |
> showing 50 of 906,729 rows — these rows as CSV