PREVIEW / stock_1min / 2007-08-28
file: by_date/stock_1min/2007/2007-08-28.parquet size: 11.1 MB rows: 911,913 symbols: 2,538
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-28 09:30:00 | AAPL | Stock | 4.6757 | 4.6811 | 4.6643 | 4.6786 | 10080308.0 |
| 2007-08-28 09:31:00 | AAPL | Stock | 4.6804 | 4.6879 | 4.6729 | 4.6732 | 4568844.0 |
| 2007-08-28 09:32:00 | AAPL | Stock | 4.6732 | 4.6746 | 4.6514 | 4.6546 | 6898220.0 |
| 2007-08-28 09:33:00 | AAPL | Stock | 4.6546 | 4.6668 | 4.6536 | 4.6664 | 3881388.0 |
| 2007-08-28 09:34:00 | AAPL | Stock | 4.6664 | 4.6804 | 4.6629 | 4.6793 | 4509064.0 |
| 2007-08-28 09:35:00 | AAPL | Stock | 4.6793 | 4.6886 | 4.675 | 4.6764 | 5490884.0 |
| 2007-08-28 09:36:00 | AAPL | Stock | 4.6768 | 4.6868 | 4.6736 | 4.6861 | 4247040.0 |
| 2007-08-28 09:37:00 | AAPL | Stock | 4.6864 | 4.6911 | 4.6825 | 4.6825 | 3454164.0 |
| 2007-08-28 09:38:00 | AAPL | Stock | 4.6825 | 4.6832 | 4.675 | 4.68 | 2632924.0 |
| 2007-08-28 09:39:00 | AAPL | Stock | 4.6818 | 4.6943 | 4.68 | 4.6865 | 4069380.0 |
| 2007-08-28 09:40:00 | AAPL | Stock | 4.6861 | 4.6875 | 4.6704 | 4.6754 | 3416812.0 |
| 2007-08-28 09:41:00 | AAPL | Stock | 4.6746 | 4.6811 | 4.672 | 4.6811 | 2088352.0 |
| 2007-08-28 09:42:00 | AAPL | Stock | 4.6814 | 4.6864 | 4.6739 | 4.6843 | 3179736.0 |
| 2007-08-28 09:43:00 | AAPL | Stock | 4.6843 | 4.6904 | 4.6789 | 4.6869 | 3602060.0 |
| 2007-08-28 09:44:00 | AAPL | Stock | 4.6854 | 4.6964 | 4.6814 | 4.6889 | 4347672.0 |
| 2007-08-28 09:45:00 | AAPL | Stock | 4.6889 | 4.6989 | 4.6879 | 4.6989 | 2440200.0 |
| 2007-08-28 09:46:00 | AAPL | Stock | 4.6986 | 4.7 | 4.6904 | 4.6914 | 3267208.0 |
| 2007-08-28 09:47:00 | AAPL | Stock | 4.6918 | 4.6918 | 4.6846 | 4.685 | 2833572.0 |
| 2007-08-28 09:48:00 | AAPL | Stock | 4.6843 | 4.7039 | 4.6839 | 4.7 | 3324636.0 |
| 2007-08-28 09:49:00 | AAPL | Stock | 4.7011 | 4.705 | 4.6964 | 4.6982 | 2196824.0 |
| 2007-08-28 09:50:00 | AAPL | Stock | 4.6982 | 4.7046 | 4.6954 | 4.6984 | 2608480.0 |
| 2007-08-28 09:51:00 | AAPL | Stock | 4.7 | 4.7071 | 4.6954 | 4.7008 | 3120656.0 |
| 2007-08-28 09:52:00 | AAPL | Stock | 4.7046 | 4.7086 | 4.6989 | 4.6989 | 2627856.0 |
| 2007-08-28 09:53:00 | AAPL | Stock | 4.7 | 4.7021 | 4.69 | 4.695 | 2783284.0 |
| 2007-08-28 09:54:00 | AAPL | Stock | 4.6946 | 4.7054 | 4.6932 | 4.7054 | 3491908.0 |
| 2007-08-28 09:55:00 | AAPL | Stock | 4.705 | 4.7054 | 4.6982 | 4.6996 | 1279824.0 |
| 2007-08-28 09:56:00 | AAPL | Stock | 4.6989 | 4.7039 | 4.6968 | 4.7014 | 1660792.0 |
| 2007-08-28 09:57:00 | AAPL | Stock | 4.7014 | 4.7018 | 4.6939 | 4.6989 | 2884308.0 |
| 2007-08-28 09:58:00 | AAPL | Stock | 4.6989 | 4.6996 | 4.6882 | 4.6957 | 2188844.0 |
| 2007-08-28 09:59:00 | AAPL | Stock | 4.6943 | 4.6996 | 4.6911 | 4.6979 | 2450700.0 |
| 2007-08-28 10:00:00 | AAPL | Stock | 4.6957 | 4.7054 | 4.6957 | 4.7036 | 3270204.0 |
| 2007-08-28 10:01:00 | AAPL | Stock | 4.7029 | 4.7257 | 4.7004 | 4.72 | 10517668.0 |
| 2007-08-28 10:02:00 | AAPL | Stock | 4.7196 | 4.725 | 4.7114 | 4.7221 | 5698868.0 |
| 2007-08-28 10:03:00 | AAPL | Stock | 4.7218 | 4.7257 | 4.7107 | 4.7143 | 4247516.0 |
| 2007-08-28 10:04:00 | AAPL | Stock | 4.715 | 4.7179 | 4.7071 | 4.7168 | 2939132.0 |
| 2007-08-28 10:05:00 | AAPL | Stock | 4.7164 | 4.7196 | 4.7111 | 4.7139 | 2873724.0 |
| 2007-08-28 10:06:00 | AAPL | Stock | 4.7142 | 4.7142 | 4.7054 | 4.7125 | 3551800.0 |
| 2007-08-28 10:07:00 | AAPL | Stock | 4.7125 | 4.7232 | 4.7096 | 4.7168 | 3937052.0 |
| 2007-08-28 10:08:00 | AAPL | Stock | 4.7175 | 4.7289 | 4.7171 | 4.7253 | 4686248.0 |
| 2007-08-28 10:09:00 | AAPL | Stock | 4.7261 | 4.7271 | 4.7168 | 4.72 | 3698968.0 |
| 2007-08-28 10:10:00 | AAPL | Stock | 4.72 | 4.7268 | 4.7193 | 4.7218 | 3147620.0 |
| 2007-08-28 10:11:00 | AAPL | Stock | 4.7225 | 4.725 | 4.7161 | 4.7174 | 2853676.0 |
| 2007-08-28 10:12:00 | AAPL | Stock | 4.7175 | 4.7204 | 4.7121 | 4.7179 | 4556104.0 |
| 2007-08-28 10:13:00 | AAPL | Stock | 4.7186 | 4.7211 | 4.7143 | 4.7204 | 2559312.0 |
| 2007-08-28 10:14:00 | AAPL | Stock | 4.7204 | 4.7207 | 4.7132 | 4.7157 | 3006080.0 |
| 2007-08-28 10:15:00 | AAPL | Stock | 4.7149 | 4.7175 | 4.7069 | 4.7118 | 3589292.0 |
| 2007-08-28 10:16:00 | AAPL | Stock | 4.7114 | 4.7143 | 4.7061 | 4.7101 | 2395932.0 |
| 2007-08-28 10:17:00 | AAPL | Stock | 4.7071 | 4.7107 | 4.7064 | 4.7064 | 1622964.0 |
| 2007-08-28 10:18:00 | AAPL | Stock | 4.7064 | 4.7098 | 4.7004 | 4.7041 | 2737700.0 |
| 2007-08-28 10:19:00 | AAPL | Stock | 4.7057 | 4.7079 | 4.6982 | 4.7057 | 2994740.0 |
> showing 50 of 911,913 rows — these rows as CSV