PREVIEW / stock_1min / 2007-10-15
file: by_date/stock_1min/2007/2007-10-15.parquet size: 11.9 MB rows: 964,763 symbols: 2,569
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-10-15 05:47:00 | AAPL | Stock | 6.0314 | 6.0314 | 6.0314 | 6.0314 | 24080.0 |
| 2007-10-15 05:50:00 | AAPL | Stock | 6.0429 | 6.0429 | 6.0429 | 6.0429 | 14420.0 |
| 2007-10-15 05:55:00 | AAPL | Stock | 6.0386 | 6.0386 | 6.0386 | 6.0386 | 11200.0 |
| 2007-10-15 06:41:00 | AAPL | Stock | 6.0443 | 6.0443 | 6.0443 | 6.0443 | 14000.0 |
| 2007-10-15 06:42:00 | AAPL | Stock | 6.0446 | 6.0446 | 6.0443 | 6.0443 | 28000.0 |
| 2007-10-15 06:57:00 | AAPL | Stock | 6.0314 | 6.0314 | 6.0314 | 6.0314 | 14000.0 |
| 2007-10-15 06:58:00 | AAPL | Stock | 6.0339 | 6.0339 | 6.0339 | 6.0339 | 8400.0 |
| 2007-10-15 06:59:00 | AAPL | Stock | 6.0339 | 6.0339 | 6.0339 | 6.0339 | 5600.0 |
| 2007-10-15 07:01:00 | AAPL | Stock | 6.0339 | 6.0339 | 6.0339 | 6.0339 | 11200.0 |
| 2007-10-15 07:02:00 | AAPL | Stock | 6.0339 | 6.0339 | 6.0339 | 6.0339 | 22764.0 |
| 2007-10-15 07:03:00 | AAPL | Stock | 6.0246 | 6.0246 | 6.0246 | 6.0246 | 2800.0 |
| 2007-10-15 07:04:00 | AAPL | Stock | 6.0229 | 6.0229 | 6.0229 | 6.0229 | 2800.0 |
| 2007-10-15 07:09:00 | AAPL | Stock | 6.0229 | 6.0229 | 6.0229 | 6.0229 | 5600.0 |
| 2007-10-15 07:13:00 | AAPL | Stock | 6.0168 | 6.0168 | 6.0168 | 6.0168 | 14000.0 |
| 2007-10-15 07:14:00 | AAPL | Stock | 6.0168 | 6.0168 | 6.0168 | 6.0168 | 5600.0 |
| 2007-10-15 07:17:00 | AAPL | Stock | 6.025 | 6.025 | 6.025 | 6.025 | 2800.0 |
| 2007-10-15 07:21:00 | AAPL | Stock | 6.0214 | 6.0214 | 6.0214 | 6.0214 | 7000.0 |
| 2007-10-15 07:22:00 | AAPL | Stock | 6.0214 | 6.0214 | 6.0214 | 6.0214 | 14000.0 |
| 2007-10-15 07:23:00 | AAPL | Stock | 6.0214 | 6.0214 | 6.0214 | 6.0214 | 5600.0 |
| 2007-10-15 07:24:00 | AAPL | Stock | 6.0257 | 6.0339 | 6.0257 | 6.0339 | 8680.0 |
| 2007-10-15 07:26:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 2800.0 |
| 2007-10-15 07:31:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0179 | 6.0179 | 2800.0 |
| 2007-10-15 07:47:00 | AAPL | Stock | 6.0193 | 6.0193 | 6.0193 | 6.0193 | 14000.0 |
| 2007-10-15 07:49:00 | AAPL | Stock | 6.0057 | 6.0057 | 6.0057 | 6.0057 | 11200.0 |
| 2007-10-15 07:53:00 | AAPL | Stock | 6.0057 | 6.0057 | 6.0057 | 6.0057 | 5600.0 |
| 2007-10-15 07:54:00 | AAPL | Stock | 6.0054 | 6.0054 | 6.0018 | 6.0018 | 42000.0 |
| 2007-10-15 07:57:00 | AAPL | Stock | 6.0054 | 6.0054 | 6.0054 | 6.0054 | 8400.0 |
| 2007-10-15 07:58:00 | AAPL | Stock | 6.0025 | 6.0025 | 5.9889 | 5.9893 | 84000.0 |
| 2007-10-15 07:59:00 | AAPL | Stock | 5.9893 | 5.9896 | 5.9893 | 5.9896 | 14000.0 |
| 2007-10-15 08:00:00 | AAPL | Stock | 5.9896 | 6.0143 | 5.9896 | 6.0 | 169036.0 |
| 2007-10-15 08:01:00 | AAPL | Stock | 6.0 | 6.0079 | 6.0 | 6.0 | 107800.0 |
| 2007-10-15 08:02:00 | AAPL | Stock | 6.0 | 6.0018 | 6.0 | 6.0007 | 102900.0 |
| 2007-10-15 08:03:00 | AAPL | Stock | 6.0 | 6.0086 | 6.0 | 6.0086 | 62972.0 |
| 2007-10-15 08:04:00 | AAPL | Stock | 6.0089 | 6.01 | 6.0057 | 6.0071 | 42840.0 |
| 2007-10-15 08:05:00 | AAPL | Stock | 6.0107 | 6.0107 | 6.0054 | 6.0057 | 35000.0 |
| 2007-10-15 08:06:00 | AAPL | Stock | 6.0071 | 6.0071 | 6.0057 | 6.0057 | 17640.0 |
| 2007-10-15 08:07:00 | AAPL | Stock | 6.0125 | 6.0125 | 6.0089 | 6.0107 | 93240.0 |
| 2007-10-15 08:08:00 | AAPL | Stock | 6.0089 | 6.0107 | 6.0071 | 6.0071 | 84616.0 |
| 2007-10-15 08:10:00 | AAPL | Stock | 6.0107 | 6.0157 | 6.0107 | 6.0157 | 14000.0 |
| 2007-10-15 08:11:00 | AAPL | Stock | 6.0168 | 6.0179 | 6.0143 | 6.0179 | 112420.0 |
| 2007-10-15 08:12:00 | AAPL | Stock | 6.0179 | 6.0179 | 6.0164 | 6.0164 | 59584.0 |
| 2007-10-15 08:13:00 | AAPL | Stock | 6.0164 | 6.0175 | 6.0161 | 6.0175 | 90608.0 |
| 2007-10-15 08:14:00 | AAPL | Stock | 6.0146 | 6.0161 | 6.0143 | 6.0161 | 42084.0 |
| 2007-10-15 08:15:00 | AAPL | Stock | 6.0161 | 6.0161 | 6.0129 | 6.0143 | 49000.0 |
| 2007-10-15 08:16:00 | AAPL | Stock | 6.0161 | 6.0164 | 6.0143 | 6.0164 | 30800.0 |
| 2007-10-15 08:17:00 | AAPL | Stock | 6.0146 | 6.0161 | 6.0107 | 6.0107 | 137984.0 |
| 2007-10-15 08:18:00 | AAPL | Stock | 6.0139 | 6.0157 | 6.0139 | 6.0154 | 96404.0 |
| 2007-10-15 08:19:00 | AAPL | Stock | 6.0157 | 6.0157 | 6.0143 | 6.0143 | 86660.0 |
| 2007-10-15 08:20:00 | AAPL | Stock | 6.0157 | 6.0161 | 6.0132 | 6.0161 | 137200.0 |
| 2007-10-15 08:21:00 | AAPL | Stock | 6.0136 | 6.0164 | 6.0125 | 6.0161 | 88900.0 |
> showing 50 of 964,763 rows — these rows as CSV