PREVIEW / stock_5min / 2011-02-09
file: by_date/stock_5min/2011/2011-02-09.parquet size: 4.9 MB rows: 329,505 symbols: 3,540
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 |
|---|---|---|---|---|---|---|---|
| 2011-02-09 04:05:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 9800.0 |
| 2011-02-09 05:05:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 5600.0 |
| 2011-02-09 06:45:00 | AAPL | Stock | 12.6771 | 12.6793 | 12.6771 | 12.6793 | 7000.0 |
| 2011-02-09 06:50:00 | AAPL | Stock | 12.6793 | 12.6793 | 12.6782 | 12.6782 | 29120.0 |
| 2011-02-09 06:55:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 28000.0 |
| 2011-02-09 07:05:00 | AAPL | Stock | 12.6782 | 12.6786 | 12.6782 | 12.6786 | 6720.0 |
| 2011-02-09 07:15:00 | AAPL | Stock | 12.6561 | 12.6661 | 12.6561 | 12.6661 | 33600.0 |
| 2011-02-09 07:20:00 | AAPL | Stock | 12.6661 | 12.6661 | 12.6643 | 12.6643 | 41580.0 |
| 2011-02-09 07:25:00 | AAPL | Stock | 12.6686 | 12.6964 | 12.6686 | 12.6921 | 120400.0 |
| 2011-02-09 07:30:00 | AAPL | Stock | 12.6957 | 12.6964 | 12.6907 | 12.6907 | 23800.0 |
| 2011-02-09 07:35:00 | AAPL | Stock | 12.6893 | 12.6893 | 12.6893 | 12.6893 | 2800.0 |
| 2011-02-09 07:40:00 | AAPL | Stock | 12.6821 | 12.6821 | 12.6821 | 12.6821 | 24416.0 |
| 2011-02-09 07:45:00 | AAPL | Stock | 12.6796 | 12.6796 | 12.6786 | 12.6786 | 29960.0 |
| 2011-02-09 07:50:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6661 | 12.6686 | 24136.0 |
| 2011-02-09 07:55:00 | AAPL | Stock | 12.6661 | 12.6739 | 12.6625 | 12.6679 | 40712.0 |
| 2011-02-09 08:00:00 | AAPL | Stock | 12.6718 | 12.6786 | 12.6686 | 12.6732 | 225820.0 |
| 2011-02-09 08:05:00 | AAPL | Stock | 12.6743 | 12.6861 | 12.6736 | 12.6857 | 240940.0 |
| 2011-02-09 08:10:00 | AAPL | Stock | 12.6861 | 12.6932 | 12.6804 | 12.6893 | 245420.0 |
| 2011-02-09 08:15:00 | AAPL | Stock | 12.6889 | 12.6911 | 12.6696 | 12.6696 | 332472.0 |
| 2011-02-09 08:20:00 | AAPL | Stock | 12.6739 | 12.675 | 12.6714 | 12.6714 | 320460.0 |
| 2011-02-09 08:25:00 | AAPL | Stock | 12.6704 | 12.6771 | 12.6679 | 12.6771 | 172116.0 |
| 2011-02-09 08:30:00 | AAPL | Stock | 12.68 | 12.6829 | 12.6736 | 12.6829 | 63000.0 |
| 2011-02-09 08:35:00 | AAPL | Stock | 12.6811 | 12.6825 | 12.6768 | 12.6825 | 255696.0 |
| 2011-02-09 08:40:00 | AAPL | Stock | 12.6839 | 12.6854 | 12.6786 | 12.6793 | 146832.0 |
| 2011-02-09 08:45:00 | AAPL | Stock | 12.68 | 12.6804 | 12.6775 | 12.6789 | 14000.0 |
| 2011-02-09 08:50:00 | AAPL | Stock | 12.6821 | 12.6893 | 12.6821 | 12.6839 | 89880.0 |
| 2011-02-09 08:55:00 | AAPL | Stock | 12.6839 | 12.6871 | 12.6839 | 12.685 | 19600.0 |
| 2011-02-09 09:00:00 | AAPL | Stock | 12.6875 | 12.6879 | 12.6839 | 12.6839 | 75684.0 |
| 2011-02-09 09:05:00 | AAPL | Stock | 12.6825 | 12.6825 | 12.6807 | 12.6807 | 75600.0 |
| 2011-02-09 09:10:00 | AAPL | Stock | 12.6807 | 12.6807 | 12.6779 | 12.6782 | 323624.0 |
| 2011-02-09 09:15:00 | AAPL | Stock | 12.6786 | 12.6829 | 12.6786 | 12.6789 | 58800.0 |
| 2011-02-09 09:20:00 | AAPL | Stock | 12.6814 | 12.6821 | 12.6804 | 12.6804 | 78400.0 |
| 2011-02-09 09:25:00 | AAPL | Stock | 12.6807 | 12.69 | 12.6754 | 12.6857 | 480060.0 |
| 2011-02-09 09:30:00 | AAPL | Stock | 12.6843 | 12.7064 | 12.6739 | 12.7043 | 10869404.0 |
| 2011-02-09 09:35:00 | AAPL | Stock | 12.705 | 12.7275 | 12.7043 | 12.7236 | 15094044.0 |
| 2011-02-09 09:40:00 | AAPL | Stock | 12.7246 | 12.7396 | 12.7132 | 12.7351 | 10402000.0 |
| 2011-02-09 09:45:00 | AAPL | Stock | 12.7354 | 12.7357 | 12.7118 | 12.7179 | 11168808.0 |
| 2011-02-09 09:50:00 | AAPL | Stock | 12.7182 | 12.7211 | 12.7054 | 12.7168 | 6536684.0 |
| 2011-02-09 09:55:00 | AAPL | Stock | 12.7168 | 12.7379 | 12.7143 | 12.7364 | 9076004.0 |
| 2011-02-09 10:00:00 | AAPL | Stock | 12.7364 | 12.7436 | 12.7307 | 12.7353 | 9054892.0 |
| 2011-02-09 10:05:00 | AAPL | Stock | 12.7343 | 12.7596 | 12.7343 | 12.7589 | 11347308.0 |
| 2011-02-09 10:10:00 | AAPL | Stock | 12.7589 | 12.7596 | 12.7429 | 12.7454 | 11188436.0 |
| 2011-02-09 10:15:00 | AAPL | Stock | 12.7454 | 12.7557 | 12.7439 | 12.7521 | 6767236.0 |
| 2011-02-09 10:20:00 | AAPL | Stock | 12.7533 | 12.7586 | 12.7521 | 12.7564 | 4365060.0 |
| 2011-02-09 10:25:00 | AAPL | Stock | 12.7564 | 12.7621 | 12.7529 | 12.7554 | 5399604.0 |
| 2011-02-09 10:30:00 | AAPL | Stock | 12.7554 | 12.7593 | 12.7475 | 12.7593 | 6024396.0 |
| 2011-02-09 10:35:00 | AAPL | Stock | 12.7591 | 12.7668 | 12.7539 | 12.7668 | 6347404.0 |
| 2011-02-09 10:40:00 | AAPL | Stock | 12.7661 | 12.7762 | 12.7629 | 12.7707 | 8102948.0 |
| 2011-02-09 10:45:00 | AAPL | Stock | 12.7714 | 12.7961 | 12.7704 | 12.7961 | 8825740.0 |
| 2011-02-09 10:50:00 | AAPL | Stock | 12.7961 | 12.8036 | 12.7907 | 12.8025 | 10204460.0 |
> showing 50 of 329,505 rows — these rows as CSV