PREVIEW / stock_5min / 2011-02-08
file: by_date/stock_5min/2011/2011-02-08.parquet size: 4.9 MB rows: 329,596 symbols: 3,535
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-08 05:45:00 | AAPL | Stock | 12.5661 | 12.5661 | 12.5661 | 12.5661 | 2800.0 |
| 2011-02-08 06:10:00 | AAPL | Stock | 12.5771 | 12.5771 | 12.5771 | 12.5771 | 2800.0 |
| 2011-02-08 06:30:00 | AAPL | Stock | 12.5782 | 12.5857 | 12.5493 | 12.5857 | 14000.0 |
| 2011-02-08 07:00:00 | AAPL | Stock | 12.5671 | 12.5671 | 12.5521 | 12.5521 | 16800.0 |
| 2011-02-08 07:05:00 | AAPL | Stock | 12.5714 | 12.5875 | 12.5714 | 12.5857 | 27160.0 |
| 2011-02-08 07:10:00 | AAPL | Stock | 12.5843 | 12.5871 | 12.5839 | 12.5871 | 24500.0 |
| 2011-02-08 07:15:00 | AAPL | Stock | 12.5893 | 12.5893 | 12.5839 | 12.5839 | 5600.0 |
| 2011-02-08 07:25:00 | AAPL | Stock | 12.5771 | 12.5775 | 12.5607 | 12.5607 | 120288.0 |
| 2011-02-08 07:30:00 | AAPL | Stock | 12.5643 | 12.5643 | 12.5557 | 12.5557 | 74200.0 |
| 2011-02-08 07:35:00 | AAPL | Stock | 12.5625 | 12.5625 | 12.5625 | 12.5625 | 11200.0 |
| 2011-02-08 07:40:00 | AAPL | Stock | 12.55 | 12.55 | 12.55 | 12.55 | 13300.0 |
| 2011-02-08 07:50:00 | AAPL | Stock | 12.5643 | 12.5679 | 12.5643 | 12.5679 | 29400.0 |
| 2011-02-08 07:55:00 | AAPL | Stock | 12.5804 | 12.5804 | 12.5804 | 12.5804 | 8400.0 |
| 2011-02-08 08:00:00 | AAPL | Stock | 12.5804 | 12.5871 | 12.5771 | 12.5871 | 457268.0 |
| 2011-02-08 08:05:00 | AAPL | Stock | 12.5886 | 12.6029 | 12.5882 | 12.6025 | 482580.0 |
| 2011-02-08 08:10:00 | AAPL | Stock | 12.6021 | 12.6139 | 12.5964 | 12.6068 | 723296.0 |
| 2011-02-08 08:15:00 | AAPL | Stock | 12.6068 | 12.6068 | 12.5914 | 12.5914 | 323624.0 |
| 2011-02-08 08:20:00 | AAPL | Stock | 12.5921 | 12.5964 | 12.5921 | 12.5943 | 55664.0 |
| 2011-02-08 08:25:00 | AAPL | Stock | 12.5932 | 12.5964 | 12.5886 | 12.5911 | 253344.0 |
| 2011-02-08 08:30:00 | AAPL | Stock | 12.5925 | 12.5964 | 12.5914 | 12.5914 | 156996.0 |
| 2011-02-08 08:35:00 | AAPL | Stock | 12.5875 | 12.5929 | 12.5857 | 12.5929 | 63140.0 |
| 2011-02-08 08:40:00 | AAPL | Stock | 12.5943 | 12.5989 | 12.5914 | 12.5946 | 132216.0 |
| 2011-02-08 08:45:00 | AAPL | Stock | 12.5989 | 12.5989 | 12.5971 | 12.5979 | 29400.0 |
| 2011-02-08 08:50:00 | AAPL | Stock | 12.5986 | 12.5989 | 12.5893 | 12.5961 | 194096.0 |
| 2011-02-08 08:55:00 | AAPL | Stock | 12.5971 | 12.5975 | 12.5929 | 12.5929 | 59276.0 |
| 2011-02-08 09:00:00 | AAPL | Stock | 12.5921 | 12.5921 | 12.5914 | 12.5914 | 122360.0 |
| 2011-02-08 09:05:00 | AAPL | Stock | 12.5918 | 12.6032 | 12.5918 | 12.6018 | 338464.0 |
| 2011-02-08 09:10:00 | AAPL | Stock | 12.6039 | 12.6107 | 12.6004 | 12.6079 | 687008.0 |
| 2011-02-08 09:15:00 | AAPL | Stock | 12.6064 | 12.6064 | 12.5986 | 12.5993 | 91840.0 |
| 2011-02-08 09:20:00 | AAPL | Stock | 12.6 | 12.6064 | 12.5943 | 12.5964 | 244104.0 |
| 2011-02-08 09:25:00 | AAPL | Stock | 12.5982 | 12.6264 | 12.5982 | 12.6264 | 953512.0 |
| 2011-02-08 09:30:00 | AAPL | Stock | 12.625 | 12.65 | 12.6032 | 12.6461 | 23341752.0 |
| 2011-02-08 09:35:00 | AAPL | Stock | 12.6468 | 12.6614 | 12.6329 | 12.6396 | 15077328.0 |
| 2011-02-08 09:40:00 | AAPL | Stock | 12.6393 | 12.6404 | 12.5909 | 12.5971 | 11412996.0 |
| 2011-02-08 09:45:00 | AAPL | Stock | 12.5975 | 12.6282 | 12.5768 | 12.6246 | 14262136.0 |
| 2011-02-08 09:50:00 | AAPL | Stock | 12.6239 | 12.6529 | 12.6164 | 12.6429 | 10856916.0 |
| 2011-02-08 09:55:00 | AAPL | Stock | 12.6418 | 12.6546 | 12.6389 | 12.6465 | 8967280.0 |
| 2011-02-08 10:00:00 | AAPL | Stock | 12.6461 | 12.665 | 12.6429 | 12.6532 | 11421508.0 |
| 2011-02-08 10:05:00 | AAPL | Stock | 12.6536 | 12.6582 | 12.6307 | 12.6546 | 7572180.0 |
| 2011-02-08 10:10:00 | AAPL | Stock | 12.6543 | 12.6571 | 12.6407 | 12.6525 | 4863152.0 |
| 2011-02-08 10:15:00 | AAPL | Stock | 12.6511 | 12.6629 | 12.6464 | 12.6557 | 6115900.0 |
| 2011-02-08 10:20:00 | AAPL | Stock | 12.6551 | 12.6714 | 12.65 | 12.6703 | 7911596.0 |
| 2011-02-08 10:25:00 | AAPL | Stock | 12.6704 | 12.6764 | 12.6664 | 12.6679 | 8754424.0 |
| 2011-02-08 10:30:00 | AAPL | Stock | 12.6693 | 12.6743 | 12.6661 | 12.6723 | 3517808.0 |
| 2011-02-08 10:35:00 | AAPL | Stock | 12.673 | 12.6775 | 12.6671 | 12.6675 | 5658184.0 |
| 2011-02-08 10:40:00 | AAPL | Stock | 12.6675 | 12.6696 | 12.6618 | 12.6686 | 6079640.0 |
| 2011-02-08 10:45:00 | AAPL | Stock | 12.6689 | 12.6779 | 12.6679 | 12.6764 | 5286512.0 |
| 2011-02-08 10:50:00 | AAPL | Stock | 12.6764 | 12.6814 | 12.6736 | 12.6782 | 8245916.0 |
| 2011-02-08 10:55:00 | AAPL | Stock | 12.6779 | 12.6829 | 12.6725 | 12.6739 | 6385204.0 |
| 2011-02-08 11:00:00 | AAPL | Stock | 12.6736 | 12.6796 | 12.6621 | 12.6732 | 7774620.0 |
> showing 50 of 329,596 rows — these rows as CSV