PREVIEW / stock_1min / 2007-09-19
file: by_date/stock_1min/2007/2007-09-19.parquet size: 12.2 MB rows: 996,371 symbols: 2,559
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-19 09:30:00 | AAPL | Stock | 5.1071 | 5.1121 | 5.0961 | 5.1046 | 14481684.0 |
| 2007-09-19 09:31:00 | AAPL | Stock | 5.1046 | 5.1096 | 5.0957 | 5.0961 | 9525824.0 |
| 2007-09-19 09:32:00 | AAPL | Stock | 5.0961 | 5.0968 | 5.0736 | 5.0764 | 8124928.0 |
| 2007-09-19 09:33:00 | AAPL | Stock | 5.0764 | 5.0861 | 5.0714 | 5.0807 | 9439864.0 |
| 2007-09-19 09:34:00 | AAPL | Stock | 5.0811 | 5.0918 | 5.0714 | 5.0875 | 6394304.0 |
| 2007-09-19 09:35:00 | AAPL | Stock | 5.0871 | 5.0914 | 5.0807 | 5.0859 | 5753440.0 |
| 2007-09-19 09:36:00 | AAPL | Stock | 5.0871 | 5.0889 | 5.0807 | 5.0832 | 4732980.0 |
| 2007-09-19 09:37:00 | AAPL | Stock | 5.0832 | 5.0854 | 5.0786 | 5.0793 | 4401880.0 |
| 2007-09-19 09:38:00 | AAPL | Stock | 5.0796 | 5.0807 | 5.0786 | 5.0804 | 3536484.0 |
| 2007-09-19 09:39:00 | AAPL | Stock | 5.0804 | 5.0804 | 5.0746 | 5.0779 | 3569076.0 |
| 2007-09-19 09:40:00 | AAPL | Stock | 5.0775 | 5.0804 | 5.0754 | 5.0804 | 3587332.0 |
| 2007-09-19 09:41:00 | AAPL | Stock | 5.0804 | 5.0893 | 5.0793 | 5.0893 | 4965772.0 |
| 2007-09-19 09:42:00 | AAPL | Stock | 5.0889 | 5.0907 | 5.0858 | 5.0892 | 4097100.0 |
| 2007-09-19 09:43:00 | AAPL | Stock | 5.0882 | 5.0896 | 5.0843 | 5.0893 | 2980208.0 |
| 2007-09-19 09:44:00 | AAPL | Stock | 5.0893 | 5.0925 | 5.0875 | 5.0893 | 4369204.0 |
| 2007-09-19 09:45:00 | AAPL | Stock | 5.0889 | 5.0964 | 5.0882 | 5.0925 | 3431792.0 |
| 2007-09-19 09:46:00 | AAPL | Stock | 5.0921 | 5.0968 | 5.0904 | 5.0911 | 4311496.0 |
| 2007-09-19 09:47:00 | AAPL | Stock | 5.0911 | 5.0968 | 5.0893 | 5.0925 | 3561264.0 |
| 2007-09-19 09:48:00 | AAPL | Stock | 5.0925 | 5.0982 | 5.0914 | 5.0982 | 3391920.0 |
| 2007-09-19 09:49:00 | AAPL | Stock | 5.0979 | 5.0982 | 5.0946 | 5.0957 | 2995888.0 |
| 2007-09-19 09:50:00 | AAPL | Stock | 5.0957 | 5.0989 | 5.095 | 5.0979 | 3154284.0 |
| 2007-09-19 09:51:00 | AAPL | Stock | 5.0975 | 5.105 | 5.0975 | 5.1025 | 4219852.0 |
| 2007-09-19 09:52:00 | AAPL | Stock | 5.1025 | 5.1129 | 5.1025 | 5.1086 | 6050100.0 |
| 2007-09-19 09:53:00 | AAPL | Stock | 5.1086 | 5.11 | 5.0996 | 5.1046 | 2716336.0 |
| 2007-09-19 09:54:00 | AAPL | Stock | 5.1046 | 5.1079 | 5.1 | 5.1 | 3607520.0 |
| 2007-09-19 09:55:00 | AAPL | Stock | 5.1 | 5.1 | 5.085 | 5.085 | 4821348.0 |
| 2007-09-19 09:56:00 | AAPL | Stock | 5.0846 | 5.09 | 5.0793 | 5.0886 | 5088160.0 |
| 2007-09-19 09:57:00 | AAPL | Stock | 5.0882 | 5.0932 | 5.0846 | 5.0861 | 2946636.0 |
| 2007-09-19 09:58:00 | AAPL | Stock | 5.0854 | 5.0875 | 5.0836 | 5.0854 | 1874012.0 |
| 2007-09-19 09:59:00 | AAPL | Stock | 5.0843 | 5.0868 | 5.0804 | 5.0821 | 2028320.0 |
| 2007-09-19 10:00:00 | AAPL | Stock | 5.0814 | 5.0889 | 5.0814 | 5.0821 | 1272208.0 |
| 2007-09-19 10:01:00 | AAPL | Stock | 5.0825 | 5.085 | 5.0807 | 5.0843 | 1351896.0 |
| 2007-09-19 10:02:00 | AAPL | Stock | 5.0836 | 5.0893 | 5.0832 | 5.0868 | 1666672.0 |
| 2007-09-19 10:03:00 | AAPL | Stock | 5.0861 | 5.0893 | 5.0839 | 5.0866 | 1551480.0 |
| 2007-09-19 10:04:00 | AAPL | Stock | 5.0857 | 5.0882 | 5.0839 | 5.085 | 1123864.0 |
| 2007-09-19 10:05:00 | AAPL | Stock | 5.0854 | 5.0879 | 5.0843 | 5.0857 | 1289820.0 |
| 2007-09-19 10:06:00 | AAPL | Stock | 5.0861 | 5.0861 | 5.0804 | 5.0814 | 2141804.0 |
| 2007-09-19 10:07:00 | AAPL | Stock | 5.0818 | 5.0818 | 5.0754 | 5.0786 | 4457348.0 |
| 2007-09-19 10:08:00 | AAPL | Stock | 5.0785 | 5.0804 | 5.0736 | 5.0742 | 3165232.0 |
| 2007-09-19 10:09:00 | AAPL | Stock | 5.0736 | 5.08 | 5.0736 | 5.0793 | 2712388.0 |
| 2007-09-19 10:10:00 | AAPL | Stock | 5.0793 | 5.0807 | 5.0696 | 5.07 | 8711780.0 |
| 2007-09-19 10:11:00 | AAPL | Stock | 5.07 | 5.0736 | 5.0682 | 5.0689 | 4675132.0 |
| 2007-09-19 10:12:00 | AAPL | Stock | 5.0689 | 5.0697 | 5.0625 | 5.0668 | 4670036.0 |
| 2007-09-19 10:13:00 | AAPL | Stock | 5.0664 | 5.0739 | 5.0661 | 5.0725 | 3536372.0 |
| 2007-09-19 10:14:00 | AAPL | Stock | 5.0725 | 5.0746 | 5.0661 | 5.0693 | 2832648.0 |
| 2007-09-19 10:15:00 | AAPL | Stock | 5.0686 | 5.0736 | 5.0686 | 5.0714 | 2123044.0 |
| 2007-09-19 10:16:00 | AAPL | Stock | 5.0714 | 5.0779 | 5.0714 | 5.0764 | 2439024.0 |
| 2007-09-19 10:17:00 | AAPL | Stock | 5.0764 | 5.0811 | 5.0761 | 5.0792 | 3119732.0 |
| 2007-09-19 10:18:00 | AAPL | Stock | 5.0784 | 5.0793 | 5.0739 | 5.0754 | 1804544.0 |
| 2007-09-19 10:19:00 | AAPL | Stock | 5.0754 | 5.0775 | 5.0732 | 5.0761 | 1590008.0 |
> showing 50 of 996,371 rows — these rows as CSV