PREVIEW / stock_1min / 2007-05-29
file: by_date/stock_1min/2007/2007-05-29.parquet size: 10.8 MB rows: 894,447 symbols: 2,483
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-29 09:30:00 | AAPL | Stock | 4.0875 | 4.0954 | 4.0839 | 4.0864 | 9963184.0 |
| 2007-05-29 09:31:00 | AAPL | Stock | 4.0854 | 4.0936 | 4.0793 | 4.0825 | 2216452.0 |
| 2007-05-29 09:32:00 | AAPL | Stock | 4.0829 | 4.0846 | 4.0786 | 4.0805 | 2500204.0 |
| 2007-05-29 09:33:00 | AAPL | Stock | 4.0807 | 4.0904 | 4.0786 | 4.09 | 1965040.0 |
| 2007-05-29 09:34:00 | AAPL | Stock | 4.0904 | 4.1021 | 4.09 | 4.0986 | 5491416.0 |
| 2007-05-29 09:35:00 | AAPL | Stock | 4.0982 | 4.0996 | 4.085 | 4.0854 | 3781848.0 |
| 2007-05-29 09:36:00 | AAPL | Stock | 4.0857 | 4.0968 | 4.0857 | 4.0961 | 2293172.0 |
| 2007-05-29 09:37:00 | AAPL | Stock | 4.0954 | 4.0963 | 4.0814 | 4.0842 | 3370948.0 |
| 2007-05-29 09:38:00 | AAPL | Stock | 4.0836 | 4.0846 | 4.0804 | 4.0827 | 3310888.0 |
| 2007-05-29 09:39:00 | AAPL | Stock | 4.0825 | 4.0846 | 4.0757 | 4.0839 | 5123888.0 |
| 2007-05-29 09:40:00 | AAPL | Stock | 4.0836 | 4.0836 | 4.0739 | 4.0775 | 3495576.0 |
| 2007-05-29 09:41:00 | AAPL | Stock | 4.0775 | 4.0796 | 4.0754 | 4.0757 | 2317616.0 |
| 2007-05-29 09:42:00 | AAPL | Stock | 4.0757 | 4.0768 | 4.0714 | 4.0714 | 3261496.0 |
| 2007-05-29 09:43:00 | AAPL | Stock | 4.0714 | 4.0725 | 4.0675 | 4.0693 | 4093964.0 |
| 2007-05-29 09:44:00 | AAPL | Stock | 4.0704 | 4.0707 | 4.0607 | 4.0643 | 6153560.0 |
| 2007-05-29 09:45:00 | AAPL | Stock | 4.0639 | 4.0646 | 4.0589 | 4.0596 | 2718632.0 |
| 2007-05-29 09:46:00 | AAPL | Stock | 4.06 | 4.0736 | 4.06 | 4.0728 | 3509660.0 |
| 2007-05-29 09:47:00 | AAPL | Stock | 4.0729 | 4.0732 | 4.0686 | 4.0732 | 1830164.0 |
| 2007-05-29 09:48:00 | AAPL | Stock | 4.0732 | 4.08 | 4.07 | 4.0786 | 1827924.0 |
| 2007-05-29 09:49:00 | AAPL | Stock | 4.0779 | 4.085 | 4.0771 | 4.0821 | 2793700.0 |
| 2007-05-29 09:50:00 | AAPL | Stock | 4.0818 | 4.0818 | 4.0757 | 4.0775 | 3114972.0 |
| 2007-05-29 09:51:00 | AAPL | Stock | 4.0769 | 4.0779 | 4.0718 | 4.0721 | 2515240.0 |
| 2007-05-29 09:52:00 | AAPL | Stock | 4.0718 | 4.0746 | 4.0679 | 4.0689 | 2817388.0 |
| 2007-05-29 09:53:00 | AAPL | Stock | 4.0689 | 4.0704 | 4.065 | 4.0675 | 2090172.0 |
| 2007-05-29 09:54:00 | AAPL | Stock | 4.0679 | 4.0714 | 4.065 | 4.0668 | 1971004.0 |
| 2007-05-29 09:55:00 | AAPL | Stock | 4.0668 | 4.0696 | 4.0657 | 4.0685 | 842660.0 |
| 2007-05-29 09:56:00 | AAPL | Stock | 4.0679 | 4.0736 | 4.0679 | 4.0714 | 2226476.0 |
| 2007-05-29 09:57:00 | AAPL | Stock | 4.0714 | 4.0757 | 4.0704 | 4.0732 | 2440704.0 |
| 2007-05-29 09:58:00 | AAPL | Stock | 4.0732 | 4.0736 | 4.0596 | 4.0596 | 2850708.0 |
| 2007-05-29 09:59:00 | AAPL | Stock | 4.06 | 4.0664 | 4.0561 | 4.063 | 4774028.0 |
| 2007-05-29 10:00:00 | AAPL | Stock | 4.065 | 4.0711 | 4.0632 | 4.0686 | 3224928.0 |
| 2007-05-29 10:01:00 | AAPL | Stock | 4.0679 | 4.0691 | 4.0579 | 4.065 | 3739596.0 |
| 2007-05-29 10:02:00 | AAPL | Stock | 4.065 | 4.0654 | 4.0589 | 4.0593 | 2590084.0 |
| 2007-05-29 10:03:00 | AAPL | Stock | 4.0593 | 4.0639 | 4.0579 | 4.0614 | 2609628.0 |
| 2007-05-29 10:04:00 | AAPL | Stock | 4.0618 | 4.0657 | 4.0614 | 4.0646 | 1543528.0 |
| 2007-05-29 10:05:00 | AAPL | Stock | 4.0639 | 4.0707 | 4.0639 | 4.0704 | 2306136.0 |
| 2007-05-29 10:06:00 | AAPL | Stock | 4.07 | 4.0743 | 4.0682 | 4.07 | 2798320.0 |
| 2007-05-29 10:07:00 | AAPL | Stock | 4.0682 | 4.0711 | 4.0661 | 4.0707 | 2048060.0 |
| 2007-05-29 10:08:00 | AAPL | Stock | 4.0689 | 4.0779 | 4.0682 | 4.0714 | 3919188.0 |
| 2007-05-29 10:09:00 | AAPL | Stock | 4.0718 | 4.0775 | 4.0704 | 4.0764 | 3259900.0 |
| 2007-05-29 10:10:00 | AAPL | Stock | 4.0768 | 4.0768 | 4.0729 | 4.0761 | 2255596.0 |
| 2007-05-29 10:11:00 | AAPL | Stock | 4.0761 | 4.0761 | 4.0704 | 4.0729 | 2055228.0 |
| 2007-05-29 10:12:00 | AAPL | Stock | 4.0725 | 4.0761 | 4.0707 | 4.0732 | 2124864.0 |
| 2007-05-29 10:13:00 | AAPL | Stock | 4.0732 | 4.0754 | 4.0729 | 4.0736 | 973644.0 |
| 2007-05-29 10:14:00 | AAPL | Stock | 4.0736 | 4.075 | 4.0707 | 4.0743 | 1126132.0 |
| 2007-05-29 10:15:00 | AAPL | Stock | 4.0746 | 4.0746 | 4.0668 | 4.0679 | 2389520.0 |
| 2007-05-29 10:16:00 | AAPL | Stock | 4.0679 | 4.0693 | 4.0668 | 4.0675 | 807548.0 |
| 2007-05-29 10:17:00 | AAPL | Stock | 4.0675 | 4.0682 | 4.0625 | 4.0632 | 2094848.0 |
| 2007-05-29 10:18:00 | AAPL | Stock | 4.0632 | 4.065 | 4.0593 | 4.0621 | 2669604.0 |
| 2007-05-29 10:19:00 | AAPL | Stock | 4.0621 | 4.0671 | 4.0614 | 4.065 | 1089340.0 |
> showing 50 of 894,447 rows — these rows as CSV