PREVIEW / stock_1min / 2007-05-22
file: by_date/stock_1min/2007/2007-05-22.parquet size: 11.0 MB rows: 906,775 symbols: 2,485
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-22 09:30:00 | AAPL | Stock | 4.0175 | 4.0175 | 4.0104 | 4.0121 | 6921684.0 |
| 2007-05-22 09:31:00 | AAPL | Stock | 4.0111 | 4.0175 | 4.0104 | 4.0173 | 2733248.0 |
| 2007-05-22 09:32:00 | AAPL | Stock | 4.0175 | 4.0189 | 4.015 | 4.0175 | 3229156.0 |
| 2007-05-22 09:33:00 | AAPL | Stock | 4.0176 | 4.0179 | 4.0161 | 4.0164 | 1958656.0 |
| 2007-05-22 09:34:00 | AAPL | Stock | 4.0168 | 4.0179 | 4.0071 | 4.0086 | 3514056.0 |
| 2007-05-22 09:35:00 | AAPL | Stock | 4.0086 | 4.0136 | 4.0079 | 4.0121 | 1535828.0 |
| 2007-05-22 09:36:00 | AAPL | Stock | 4.0121 | 4.0125 | 4.0104 | 4.0123 | 878808.0 |
| 2007-05-22 09:37:00 | AAPL | Stock | 4.0125 | 4.0179 | 4.01 | 4.0175 | 2064244.0 |
| 2007-05-22 09:38:00 | AAPL | Stock | 4.0176 | 4.0179 | 4.0114 | 4.0129 | 2016196.0 |
| 2007-05-22 09:39:00 | AAPL | Stock | 4.0121 | 4.0157 | 4.0111 | 4.0157 | 1263332.0 |
| 2007-05-22 09:40:00 | AAPL | Stock | 4.0145 | 4.0179 | 4.0132 | 4.0168 | 1869812.0 |
| 2007-05-22 09:41:00 | AAPL | Stock | 4.0162 | 4.025 | 4.0136 | 4.0196 | 4129104.0 |
| 2007-05-22 09:42:00 | AAPL | Stock | 4.02 | 4.0243 | 4.0179 | 4.0218 | 3389400.0 |
| 2007-05-22 09:43:00 | AAPL | Stock | 4.0218 | 4.0225 | 4.0182 | 4.0189 | 3466036.0 |
| 2007-05-22 09:44:00 | AAPL | Stock | 4.0193 | 4.0229 | 4.0186 | 4.0196 | 1779708.0 |
| 2007-05-22 09:45:00 | AAPL | Stock | 4.0196 | 4.0225 | 4.0189 | 4.0204 | 2121056.0 |
| 2007-05-22 09:46:00 | AAPL | Stock | 4.0204 | 4.0221 | 4.0193 | 4.0204 | 2697352.0 |
| 2007-05-22 09:47:00 | AAPL | Stock | 4.0204 | 4.0214 | 4.0193 | 4.0211 | 1021440.0 |
| 2007-05-22 09:48:00 | AAPL | Stock | 4.0211 | 4.0271 | 4.0207 | 4.0254 | 2982028.0 |
| 2007-05-22 09:49:00 | AAPL | Stock | 4.0257 | 4.0314 | 4.0254 | 4.0261 | 4836048.0 |
| 2007-05-22 09:50:00 | AAPL | Stock | 4.0264 | 4.0264 | 4.0196 | 4.0225 | 2854516.0 |
| 2007-05-22 09:51:00 | AAPL | Stock | 4.0221 | 4.025 | 4.0179 | 4.0182 | 2741592.0 |
| 2007-05-22 09:52:00 | AAPL | Stock | 4.0182 | 4.0193 | 4.0143 | 4.0164 | 4065012.0 |
| 2007-05-22 09:53:00 | AAPL | Stock | 4.0175 | 4.0229 | 4.0157 | 4.0196 | 2492196.0 |
| 2007-05-22 09:54:00 | AAPL | Stock | 4.02 | 4.0232 | 4.0186 | 4.0211 | 1721580.0 |
| 2007-05-22 09:55:00 | AAPL | Stock | 4.0214 | 4.025 | 4.0214 | 4.025 | 1182412.0 |
| 2007-05-22 09:56:00 | AAPL | Stock | 4.025 | 4.025 | 4.0214 | 4.0246 | 1466640.0 |
| 2007-05-22 09:57:00 | AAPL | Stock | 4.0239 | 4.0239 | 4.0196 | 4.02 | 1873872.0 |
| 2007-05-22 09:58:00 | AAPL | Stock | 4.02 | 4.0218 | 4.0196 | 4.0214 | 777672.0 |
| 2007-05-22 09:59:00 | AAPL | Stock | 4.0214 | 4.0229 | 4.0186 | 4.02 | 1532020.0 |
| 2007-05-22 10:00:00 | AAPL | Stock | 4.02 | 4.02 | 4.0121 | 4.0164 | 4389644.0 |
| 2007-05-22 10:01:00 | AAPL | Stock | 4.0164 | 4.0189 | 4.0164 | 4.0189 | 1788416.0 |
| 2007-05-22 10:02:00 | AAPL | Stock | 4.0186 | 4.0189 | 4.0161 | 4.0179 | 1257732.0 |
| 2007-05-22 10:03:00 | AAPL | Stock | 4.0179 | 4.0189 | 4.0161 | 4.0164 | 1112356.0 |
| 2007-05-22 10:04:00 | AAPL | Stock | 4.0164 | 4.0204 | 4.0164 | 4.0168 | 1356852.0 |
| 2007-05-22 10:05:00 | AAPL | Stock | 4.0171 | 4.02 | 4.0168 | 4.02 | 1038156.0 |
| 2007-05-22 10:06:00 | AAPL | Stock | 4.02 | 4.0204 | 4.015 | 4.015 | 1995784.0 |
| 2007-05-22 10:07:00 | AAPL | Stock | 4.0154 | 4.0246 | 4.015 | 4.0214 | 2483180.0 |
| 2007-05-22 10:08:00 | AAPL | Stock | 4.0214 | 4.0232 | 4.0193 | 4.0211 | 1769824.0 |
| 2007-05-22 10:09:00 | AAPL | Stock | 4.0207 | 4.0214 | 4.0179 | 4.0214 | 1838984.0 |
| 2007-05-22 10:10:00 | AAPL | Stock | 4.0211 | 4.0214 | 4.0179 | 4.019 | 1015224.0 |
| 2007-05-22 10:11:00 | AAPL | Stock | 4.0204 | 4.0218 | 4.0196 | 4.0214 | 916132.0 |
| 2007-05-22 10:12:00 | AAPL | Stock | 4.0221 | 4.0246 | 4.0214 | 4.0236 | 1398292.0 |
| 2007-05-22 10:13:00 | AAPL | Stock | 4.0232 | 4.0264 | 4.0229 | 4.025 | 2223284.0 |
| 2007-05-22 10:14:00 | AAPL | Stock | 4.0254 | 4.0268 | 4.0214 | 4.0229 | 2029636.0 |
| 2007-05-22 10:15:00 | AAPL | Stock | 4.023 | 4.023 | 4.0143 | 4.02 | 3787952.0 |
| 2007-05-22 10:16:00 | AAPL | Stock | 4.0197 | 4.0232 | 4.0189 | 4.0193 | 2219644.0 |
| 2007-05-22 10:17:00 | AAPL | Stock | 4.0193 | 4.0218 | 4.0193 | 4.0207 | 995260.0 |
| 2007-05-22 10:18:00 | AAPL | Stock | 4.0204 | 4.0214 | 4.0193 | 4.02 | 1250200.0 |
| 2007-05-22 10:19:00 | AAPL | Stock | 4.02 | 4.0225 | 4.0164 | 4.0164 | 2987348.0 |
> showing 50 of 906,775 rows — these rows as CSV