PREVIEW / stock_1min / 2007-07-31
file: by_date/stock_1min/2007/2007-07-31.parquet size: 12.4 MB rows: 1,001,589 symbols: 2,528
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-07-31 09:30:00 | AAPL | Stock | 5.1061 | 5.1118 | 5.0982 | 5.1 | 11401012.0 |
| 2007-07-31 09:31:00 | AAPL | Stock | 5.1 | 5.1101 | 5.0921 | 5.095 | 5665240.0 |
| 2007-07-31 09:32:00 | AAPL | Stock | 5.0961 | 5.1096 | 5.0893 | 5.0943 | 5152336.0 |
| 2007-07-31 09:33:00 | AAPL | Stock | 5.0964 | 5.1129 | 5.0896 | 5.1093 | 6463996.0 |
| 2007-07-31 09:34:00 | AAPL | Stock | 5.1093 | 5.1096 | 5.0961 | 5.1004 | 4861892.0 |
| 2007-07-31 09:35:00 | AAPL | Stock | 5.0984 | 5.1168 | 5.0984 | 5.1057 | 6949488.0 |
| 2007-07-31 09:36:00 | AAPL | Stock | 5.1079 | 5.1139 | 5.1054 | 5.1111 | 3209808.0 |
| 2007-07-31 09:37:00 | AAPL | Stock | 5.1107 | 5.1243 | 5.1107 | 5.1214 | 4746924.0 |
| 2007-07-31 09:38:00 | AAPL | Stock | 5.1214 | 5.1232 | 5.1125 | 5.1161 | 4112108.0 |
| 2007-07-31 09:39:00 | AAPL | Stock | 5.1175 | 5.1196 | 5.1071 | 5.1114 | 3641848.0 |
| 2007-07-31 09:40:00 | AAPL | Stock | 5.1111 | 5.1129 | 5.0929 | 5.0961 | 5171292.0 |
| 2007-07-31 09:41:00 | AAPL | Stock | 5.0957 | 5.1036 | 5.0814 | 5.0932 | 7751436.0 |
| 2007-07-31 09:42:00 | AAPL | Stock | 5.0936 | 5.0936 | 5.0714 | 5.0741 | 8835316.0 |
| 2007-07-31 09:43:00 | AAPL | Stock | 5.0725 | 5.0893 | 5.0725 | 5.0886 | 4029704.0 |
| 2007-07-31 09:44:00 | AAPL | Stock | 5.0879 | 5.0929 | 5.08 | 5.08 | 4074000.0 |
| 2007-07-31 09:45:00 | AAPL | Stock | 5.08 | 5.0879 | 5.075 | 5.0768 | 4210080.0 |
| 2007-07-31 09:46:00 | AAPL | Stock | 5.0761 | 5.08 | 5.0732 | 5.0796 | 3356192.0 |
| 2007-07-31 09:47:00 | AAPL | Stock | 5.08 | 5.0907 | 5.0786 | 5.0907 | 3648456.0 |
| 2007-07-31 09:48:00 | AAPL | Stock | 5.0907 | 5.0911 | 5.0839 | 5.0896 | 2907996.0 |
| 2007-07-31 09:49:00 | AAPL | Stock | 5.0896 | 5.0896 | 5.08 | 5.0807 | 2605596.0 |
| 2007-07-31 09:50:00 | AAPL | Stock | 5.0807 | 5.0843 | 5.0786 | 5.0804 | 2363816.0 |
| 2007-07-31 09:51:00 | AAPL | Stock | 5.0796 | 5.085 | 5.0789 | 5.0846 | 3389092.0 |
| 2007-07-31 09:52:00 | AAPL | Stock | 5.0854 | 5.0893 | 5.0843 | 5.0864 | 3243100.0 |
| 2007-07-31 09:53:00 | AAPL | Stock | 5.0861 | 5.0868 | 5.0775 | 5.0857 | 5333328.0 |
| 2007-07-31 09:54:00 | AAPL | Stock | 5.0846 | 5.0921 | 5.0786 | 5.0896 | 3768660.0 |
| 2007-07-31 09:55:00 | AAPL | Stock | 5.09 | 5.1054 | 5.0861 | 5.0993 | 7513100.0 |
| 2007-07-31 09:56:00 | AAPL | Stock | 5.0989 | 5.105 | 5.0849 | 5.095 | 4043200.0 |
| 2007-07-31 09:57:00 | AAPL | Stock | 5.095 | 5.105 | 5.0946 | 5.105 | 3198328.0 |
| 2007-07-31 09:58:00 | AAPL | Stock | 5.1039 | 5.105 | 5.0964 | 5.0986 | 2146564.0 |
| 2007-07-31 09:59:00 | AAPL | Stock | 5.0989 | 5.1011 | 5.0964 | 5.1011 | 2001748.0 |
| 2007-07-31 10:00:00 | AAPL | Stock | 5.1011 | 5.1075 | 5.1011 | 5.105 | 4236204.0 |
| 2007-07-31 10:01:00 | AAPL | Stock | 5.105 | 5.1107 | 5.1036 | 5.1054 | 3692388.0 |
| 2007-07-31 10:02:00 | AAPL | Stock | 5.105 | 5.1179 | 5.105 | 5.1139 | 4548488.0 |
| 2007-07-31 10:03:00 | AAPL | Stock | 5.1143 | 5.1179 | 5.1036 | 5.1039 | 4342184.0 |
| 2007-07-31 10:04:00 | AAPL | Stock | 5.1039 | 5.1054 | 5.0982 | 5.0989 | 2761388.0 |
| 2007-07-31 10:05:00 | AAPL | Stock | 5.0993 | 5.1036 | 5.0946 | 5.0968 | 3280508.0 |
| 2007-07-31 10:06:00 | AAPL | Stock | 5.0971 | 5.0986 | 5.0914 | 5.0925 | 2724148.0 |
| 2007-07-31 10:07:00 | AAPL | Stock | 5.0929 | 5.0964 | 5.0893 | 5.0893 | 2857036.0 |
| 2007-07-31 10:08:00 | AAPL | Stock | 5.0893 | 5.0911 | 5.0861 | 5.0911 | 2673104.0 |
| 2007-07-31 10:09:00 | AAPL | Stock | 5.0907 | 5.0968 | 5.0896 | 5.0943 | 2013564.0 |
| 2007-07-31 10:10:00 | AAPL | Stock | 5.0921 | 5.0969 | 5.0918 | 5.0929 | 2715804.0 |
| 2007-07-31 10:11:00 | AAPL | Stock | 5.0925 | 5.095 | 5.0864 | 5.0896 | 4063556.0 |
| 2007-07-31 10:12:00 | AAPL | Stock | 5.0896 | 5.09 | 5.0786 | 5.08 | 3378564.0 |
| 2007-07-31 10:13:00 | AAPL | Stock | 5.0804 | 5.0857 | 5.0786 | 5.0836 | 3647392.0 |
| 2007-07-31 10:14:00 | AAPL | Stock | 5.0825 | 5.0836 | 5.0714 | 5.075 | 6969536.0 |
| 2007-07-31 10:15:00 | AAPL | Stock | 5.0744 | 5.0754 | 5.0679 | 5.0704 | 8103816.0 |
| 2007-07-31 10:16:00 | AAPL | Stock | 5.0707 | 5.08 | 5.0661 | 5.0771 | 5635672.0 |
| 2007-07-31 10:17:00 | AAPL | Stock | 5.0768 | 5.0789 | 5.0714 | 5.0746 | 3813488.0 |
| 2007-07-31 10:18:00 | AAPL | Stock | 5.0744 | 5.0786 | 5.0696 | 5.0721 | 8158360.0 |
| 2007-07-31 10:19:00 | AAPL | Stock | 5.0721 | 5.0746 | 5.0589 | 5.0607 | 6846028.0 |
> showing 50 of 1,001,589 rows — these rows as CSV