PREVIEW / stock_1min / 2008-03-26
file: by_date/stock_1min/2008/2008-03-26.parquet size: 12.1 MB rows: 993,871 symbols: 2,681
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 |
|---|---|---|---|---|---|---|---|
| 2008-03-26 05:26:00 | AAPL | Stock | 5.02 | 5.02 | 5.02 | 5.02 | 2800.0 |
| 2008-03-26 05:44:00 | AAPL | Stock | 5.0357 | 5.0357 | 5.0357 | 5.0357 | 2800.0 |
| 2008-03-26 06:35:00 | AAPL | Stock | 5.0493 | 5.0493 | 5.0493 | 5.0493 | 2800.0 |
| 2008-03-26 07:01:00 | AAPL | Stock | 5.0407 | 5.0407 | 5.0407 | 5.0407 | 13720.0 |
| 2008-03-26 07:02:00 | AAPL | Stock | 5.0407 | 5.0464 | 5.0268 | 5.0268 | 53480.0 |
| 2008-03-26 07:05:00 | AAPL | Stock | 5.0268 | 5.0268 | 5.0268 | 5.0268 | 28000.0 |
| 2008-03-26 07:25:00 | AAPL | Stock | 5.0114 | 5.0114 | 5.0114 | 5.0114 | 2800.0 |
| 2008-03-26 07:28:00 | AAPL | Stock | 5.0114 | 5.0114 | 5.0114 | 5.0114 | 2800.0 |
| 2008-03-26 07:37:00 | AAPL | Stock | 5.0207 | 5.0207 | 5.0207 | 5.0207 | 23800.0 |
| 2008-03-26 07:38:00 | AAPL | Stock | 5.0211 | 5.0211 | 5.0211 | 5.0211 | 16800.0 |
| 2008-03-26 07:51:00 | AAPL | Stock | 5.0093 | 5.0093 | 5.0093 | 5.0093 | 2800.0 |
| 2008-03-26 07:57:00 | AAPL | Stock | 5.0146 | 5.0168 | 5.0146 | 5.0168 | 28000.0 |
| 2008-03-26 07:58:00 | AAPL | Stock | 5.0168 | 5.0171 | 5.0168 | 5.0168 | 8400.0 |
| 2008-03-26 07:59:00 | AAPL | Stock | 5.0168 | 5.0168 | 5.0146 | 5.0146 | 32200.0 |
| 2008-03-26 08:00:00 | AAPL | Stock | 5.0146 | 5.0196 | 5.005 | 5.0179 | 130060.0 |
| 2008-03-26 08:01:00 | AAPL | Stock | 5.0179 | 5.0179 | 5.0179 | 5.0179 | 4200.0 |
| 2008-03-26 08:02:00 | AAPL | Stock | 5.0175 | 5.0268 | 5.0171 | 5.025 | 113736.0 |
| 2008-03-26 08:03:00 | AAPL | Stock | 5.025 | 5.025 | 5.0207 | 5.0207 | 86016.0 |
| 2008-03-26 08:05:00 | AAPL | Stock | 5.0236 | 5.0236 | 5.0211 | 5.0211 | 8400.0 |
| 2008-03-26 08:06:00 | AAPL | Stock | 5.0221 | 5.0221 | 5.0221 | 5.0221 | 5600.0 |
| 2008-03-26 08:07:00 | AAPL | Stock | 5.0243 | 5.0243 | 5.0214 | 5.0214 | 35056.0 |
| 2008-03-26 08:08:00 | AAPL | Stock | 5.0186 | 5.0186 | 5.0179 | 5.0179 | 13272.0 |
| 2008-03-26 08:09:00 | AAPL | Stock | 5.0182 | 5.0214 | 5.0179 | 5.0214 | 22428.0 |
| 2008-03-26 08:10:00 | AAPL | Stock | 5.0214 | 5.0214 | 5.0214 | 5.0214 | 14000.0 |
| 2008-03-26 08:11:00 | AAPL | Stock | 5.0189 | 5.0196 | 5.0179 | 5.0179 | 58912.0 |
| 2008-03-26 08:12:00 | AAPL | Stock | 5.0186 | 5.035 | 5.0186 | 5.035 | 7286440.0 |
| 2008-03-26 08:13:00 | AAPL | Stock | 5.0211 | 5.0214 | 5.0211 | 5.0214 | 19600.0 |
| 2008-03-26 08:14:00 | AAPL | Stock | 5.0214 | 5.0214 | 5.0214 | 5.0214 | 8400.0 |
| 2008-03-26 08:15:00 | AAPL | Stock | 5.0214 | 5.0236 | 5.0214 | 5.0236 | 23800.0 |
| 2008-03-26 08:16:00 | AAPL | Stock | 5.0243 | 5.0268 | 5.0236 | 5.0268 | 42000.0 |
| 2008-03-26 08:17:00 | AAPL | Stock | 5.025 | 5.0271 | 5.025 | 5.0271 | 73892.0 |
| 2008-03-26 08:18:00 | AAPL | Stock | 5.0271 | 5.0271 | 5.0268 | 5.0268 | 33600.0 |
| 2008-03-26 08:19:00 | AAPL | Stock | 5.0271 | 5.0271 | 5.0268 | 5.0268 | 69272.0 |
| 2008-03-26 08:20:00 | AAPL | Stock | 5.0268 | 5.0268 | 5.0268 | 5.0268 | 3108.0 |
| 2008-03-26 08:21:00 | AAPL | Stock | 5.025 | 5.0264 | 5.0214 | 5.0214 | 28000.0 |
| 2008-03-26 08:22:00 | AAPL | Stock | 5.0214 | 5.0229 | 5.0214 | 5.0229 | 30800.0 |
| 2008-03-26 08:23:00 | AAPL | Stock | 5.0221 | 5.0221 | 5.0179 | 5.0179 | 95200.0 |
| 2008-03-26 08:24:00 | AAPL | Stock | 5.0168 | 5.0268 | 5.015 | 5.0179 | 283360.0 |
| 2008-03-26 08:26:00 | AAPL | Stock | 5.0225 | 5.0232 | 5.0225 | 5.0232 | 8400.0 |
| 2008-03-26 08:27:00 | AAPL | Stock | 5.0196 | 5.0196 | 5.0179 | 5.0186 | 38164.0 |
| 2008-03-26 08:28:00 | AAPL | Stock | 5.0186 | 5.0186 | 5.0179 | 5.0186 | 23520.0 |
| 2008-03-26 08:29:00 | AAPL | Stock | 5.0179 | 5.0179 | 5.0179 | 5.0179 | 8400.0 |
| 2008-03-26 08:30:00 | AAPL | Stock | 5.0136 | 5.0136 | 5.0011 | 5.0061 | 96684.0 |
| 2008-03-26 08:31:00 | AAPL | Stock | 5.0111 | 5.0121 | 5.0 | 5.0007 | 218960.0 |
| 2008-03-26 08:32:00 | AAPL | Stock | 5.0004 | 5.0036 | 5.0004 | 5.0036 | 151900.0 |
| 2008-03-26 08:33:00 | AAPL | Stock | 5.0064 | 5.0089 | 5.0064 | 5.0071 | 78120.0 |
| 2008-03-26 08:34:00 | AAPL | Stock | 5.0043 | 5.0043 | 5.0025 | 5.0025 | 53760.0 |
| 2008-03-26 08:35:00 | AAPL | Stock | 5.0029 | 5.0029 | 5.0021 | 5.0021 | 9800.0 |
| 2008-03-26 08:36:00 | AAPL | Stock | 5.0004 | 5.0004 | 5.0004 | 5.0004 | 2800.0 |
| 2008-03-26 08:38:00 | AAPL | Stock | 5.0011 | 5.0039 | 5.0 | 5.0007 | 55860.0 |
> showing 50 of 993,871 rows — these rows as CSV