PREVIEW / stock_5min / 2010-03-17
file: by_date/stock_5min/2010/2010-03-17.parquet size: 4.8 MB rows: 328,221 symbols: 3,473
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-17 04:55:00 | AAPL | Stock | 8.0221 | 8.025 | 8.0221 | 8.025 | 16800.0 |
| 2010-03-17 05:05:00 | AAPL | Stock | 8.0214 | 8.0214 | 8.0211 | 8.0211 | 39200.0 |
| 2010-03-17 05:10:00 | AAPL | Stock | 8.0243 | 8.0339 | 8.0243 | 8.0339 | 28000.0 |
| 2010-03-17 07:05:00 | AAPL | Stock | 8.0357 | 8.0357 | 8.0357 | 8.0357 | 8400.0 |
| 2010-03-17 07:10:00 | AAPL | Stock | 8.0389 | 8.0389 | 8.0357 | 8.0357 | 6384.0 |
| 2010-03-17 07:15:00 | AAPL | Stock | 8.0357 | 8.0357 | 8.0357 | 8.0357 | 4200.0 |
| 2010-03-17 07:25:00 | AAPL | Stock | 8.0389 | 8.0389 | 8.0389 | 8.0389 | 2800.0 |
| 2010-03-17 07:35:00 | AAPL | Stock | 8.0357 | 8.0357 | 8.0357 | 8.0357 | 5600.0 |
| 2010-03-17 07:55:00 | AAPL | Stock | 8.0304 | 8.0354 | 8.0304 | 8.0321 | 13020.0 |
| 2010-03-17 08:00:00 | AAPL | Stock | 8.0329 | 8.0329 | 8.0161 | 8.0196 | 178080.0 |
| 2010-03-17 08:05:00 | AAPL | Stock | 8.0211 | 8.0211 | 8.0161 | 8.0211 | 128100.0 |
| 2010-03-17 08:10:00 | AAPL | Stock | 8.0196 | 8.0357 | 8.0143 | 8.0143 | 208992.0 |
| 2010-03-17 08:15:00 | AAPL | Stock | 8.0207 | 8.0268 | 8.0207 | 8.0268 | 95200.0 |
| 2010-03-17 08:20:00 | AAPL | Stock | 8.0264 | 8.0264 | 8.0211 | 8.0246 | 80080.0 |
| 2010-03-17 08:25:00 | AAPL | Stock | 8.0232 | 8.0264 | 8.0232 | 8.0264 | 15400.0 |
| 2010-03-17 08:30:00 | AAPL | Stock | 8.0261 | 8.0261 | 8.0232 | 8.0232 | 5600.0 |
| 2010-03-17 08:35:00 | AAPL | Stock | 8.0232 | 8.0304 | 8.0232 | 8.0289 | 104496.0 |
| 2010-03-17 08:40:00 | AAPL | Stock | 8.0286 | 8.0286 | 8.025 | 8.0254 | 128604.0 |
| 2010-03-17 08:45:00 | AAPL | Stock | 8.0268 | 8.0286 | 8.0232 | 8.0232 | 220500.0 |
| 2010-03-17 08:50:00 | AAPL | Stock | 8.025 | 8.0282 | 8.025 | 8.0282 | 8400.0 |
| 2010-03-17 08:55:00 | AAPL | Stock | 8.0282 | 8.0304 | 8.0271 | 8.0289 | 59612.0 |
| 2010-03-17 09:00:00 | AAPL | Stock | 8.0321 | 8.0321 | 8.0289 | 8.0289 | 108220.0 |
| 2010-03-17 09:05:00 | AAPL | Stock | 8.0289 | 8.0386 | 8.0289 | 8.035 | 255976.0 |
| 2010-03-17 09:10:00 | AAPL | Stock | 8.035 | 8.0357 | 8.0318 | 8.0354 | 173880.0 |
| 2010-03-17 09:15:00 | AAPL | Stock | 8.0346 | 8.0375 | 8.0318 | 8.0375 | 83636.0 |
| 2010-03-17 09:20:00 | AAPL | Stock | 8.0375 | 8.0425 | 8.0368 | 8.0389 | 165172.0 |
| 2010-03-17 09:25:00 | AAPL | Stock | 8.0379 | 8.0407 | 8.0218 | 8.0311 | 345632.0 |
| 2010-03-17 09:30:00 | AAPL | Stock | 8.0339 | 8.0496 | 8.0243 | 8.0461 | 16093448.0 |
| 2010-03-17 09:35:00 | AAPL | Stock | 8.0461 | 8.0571 | 8.04 | 8.0568 | 9790200.0 |
| 2010-03-17 09:40:00 | AAPL | Stock | 8.0567 | 8.0804 | 8.0561 | 8.0768 | 14416920.0 |
| 2010-03-17 09:45:00 | AAPL | Stock | 8.0768 | 8.0875 | 8.0721 | 8.0846 | 10618440.0 |
| 2010-03-17 09:50:00 | AAPL | Stock | 8.0839 | 8.0857 | 8.0625 | 8.07 | 10177356.0 |
| 2010-03-17 09:55:00 | AAPL | Stock | 8.0707 | 8.0839 | 8.0689 | 8.0768 | 7676144.0 |
| 2010-03-17 10:00:00 | AAPL | Stock | 8.0775 | 8.0814 | 8.0661 | 8.0686 | 6546932.0 |
| 2010-03-17 10:05:00 | AAPL | Stock | 8.0686 | 8.0746 | 8.0679 | 8.0714 | 4799984.0 |
| 2010-03-17 10:10:00 | AAPL | Stock | 8.0711 | 8.0714 | 8.0604 | 8.0639 | 6256740.0 |
| 2010-03-17 10:15:00 | AAPL | Stock | 8.0636 | 8.0746 | 8.0625 | 8.0729 | 4194456.0 |
| 2010-03-17 10:20:00 | AAPL | Stock | 8.0736 | 8.0832 | 8.0736 | 8.0771 | 9202984.0 |
| 2010-03-17 10:25:00 | AAPL | Stock | 8.0775 | 8.0779 | 8.0679 | 8.0693 | 4242896.0 |
| 2010-03-17 10:30:00 | AAPL | Stock | 8.0693 | 8.0739 | 8.0596 | 8.0668 | 6527164.0 |
| 2010-03-17 10:35:00 | AAPL | Stock | 8.0668 | 8.0718 | 8.0654 | 8.0704 | 3043096.0 |
| 2010-03-17 10:40:00 | AAPL | Stock | 8.0696 | 8.075 | 8.0689 | 8.0729 | 3339140.0 |
| 2010-03-17 10:45:00 | AAPL | Stock | 8.0729 | 8.0729 | 8.0661 | 8.0696 | 3069276.0 |
| 2010-03-17 10:50:00 | AAPL | Stock | 8.0704 | 8.0707 | 8.065 | 8.0689 | 1984556.0 |
| 2010-03-17 10:55:00 | AAPL | Stock | 8.0689 | 8.0732 | 8.0657 | 8.0725 | 2828112.0 |
| 2010-03-17 11:00:00 | AAPL | Stock | 8.0725 | 8.0729 | 8.0657 | 8.0669 | 2756740.0 |
| 2010-03-17 11:05:00 | AAPL | Stock | 8.0668 | 8.0668 | 8.0607 | 8.0646 | 3978548.0 |
| 2010-03-17 11:10:00 | AAPL | Stock | 8.065 | 8.0704 | 8.0618 | 8.0675 | 2044840.0 |
| 2010-03-17 11:15:00 | AAPL | Stock | 8.0675 | 8.0693 | 8.0639 | 8.0675 | 2869636.0 |
| 2010-03-17 11:20:00 | AAPL | Stock | 8.0685 | 8.075 | 8.0679 | 8.0696 | 6005272.0 |
> showing 50 of 328,221 rows — these rows as CSV