PREVIEW / stock_1min / 2011-02-09
file: by_date/stock_1min/2011/2011-02-09.parquet size: 13.1 MB rows: 975,838 symbols: 2,865
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:06:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 5600.0 |
| 2011-02-09 06:48:00 | AAPL | Stock | 12.6771 | 12.6771 | 12.6771 | 12.6771 | 4200.0 |
| 2011-02-09 06:49:00 | AAPL | Stock | 12.6793 | 12.6793 | 12.6793 | 12.6793 | 2800.0 |
| 2011-02-09 06:52:00 | AAPL | Stock | 12.6793 | 12.6793 | 12.6782 | 12.6782 | 29120.0 |
| 2011-02-09 06:59:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 28000.0 |
| 2011-02-09 07:07:00 | AAPL | Stock | 12.6782 | 12.6782 | 12.6782 | 12.6782 | 2800.0 |
| 2011-02-09 07:09:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6786 | 12.6786 | 3920.0 |
| 2011-02-09 07:15:00 | AAPL | Stock | 12.6561 | 12.6561 | 12.6561 | 12.6561 | 2800.0 |
| 2011-02-09 07:18:00 | AAPL | Stock | 12.6646 | 12.6646 | 12.6629 | 12.6629 | 19600.0 |
| 2011-02-09 07:19:00 | AAPL | Stock | 12.6661 | 12.6661 | 12.6661 | 12.6661 | 11200.0 |
| 2011-02-09 07:20:00 | AAPL | Stock | 12.6661 | 12.6661 | 12.6661 | 12.6661 | 8400.0 |
| 2011-02-09 07:21:00 | AAPL | Stock | 12.6657 | 12.6661 | 12.6657 | 12.6661 | 16800.0 |
| 2011-02-09 07:22:00 | AAPL | Stock | 12.6661 | 12.6661 | 12.6661 | 12.6661 | 12600.0 |
| 2011-02-09 07:23:00 | AAPL | Stock | 12.6643 | 12.6643 | 12.6643 | 12.6643 | 3780.0 |
| 2011-02-09 07:26:00 | AAPL | Stock | 12.6686 | 12.6696 | 12.6686 | 12.6696 | 25200.0 |
| 2011-02-09 07:27:00 | AAPL | Stock | 12.675 | 12.6821 | 12.6732 | 12.6821 | 22400.0 |
| 2011-02-09 07:28:00 | AAPL | Stock | 12.6857 | 12.6939 | 12.6857 | 12.6918 | 44800.0 |
| 2011-02-09 07:29:00 | AAPL | Stock | 12.6918 | 12.6964 | 12.6918 | 12.6921 | 28000.0 |
| 2011-02-09 07:30:00 | AAPL | Stock | 12.6957 | 12.6961 | 12.6957 | 12.6961 | 16800.0 |
| 2011-02-09 07:31:00 | AAPL | Stock | 12.6964 | 12.6964 | 12.6907 | 12.6907 | 7000.0 |
| 2011-02-09 07:36: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 | 19600.0 |
| 2011-02-09 07:41:00 | AAPL | Stock | 12.6821 | 12.6821 | 12.6821 | 12.6821 | 4816.0 |
| 2011-02-09 07:47:00 | AAPL | Stock | 12.6796 | 12.6796 | 12.6786 | 12.6786 | 29960.0 |
| 2011-02-09 07:51:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.675 | 12.675 | 5600.0 |
| 2011-02-09 07:54:00 | AAPL | Stock | 12.6739 | 12.6739 | 12.6661 | 12.6686 | 18536.0 |
| 2011-02-09 07:56:00 | AAPL | Stock | 12.6661 | 12.6661 | 12.6625 | 12.6625 | 18312.0 |
| 2011-02-09 07:58:00 | AAPL | Stock | 12.6696 | 12.6696 | 12.6696 | 12.6696 | 11200.0 |
| 2011-02-09 07:59:00 | AAPL | Stock | 12.6696 | 12.6739 | 12.6679 | 12.6679 | 11200.0 |
| 2011-02-09 08:00:00 | AAPL | Stock | 12.6718 | 12.6729 | 12.6686 | 12.6686 | 31948.0 |
| 2011-02-09 08:01:00 | AAPL | Stock | 12.6729 | 12.6786 | 12.67 | 12.6746 | 107660.0 |
| 2011-02-09 08:02:00 | AAPL | Stock | 12.6771 | 12.6771 | 12.6764 | 12.6764 | 9800.0 |
| 2011-02-09 08:03:00 | AAPL | Stock | 12.6746 | 12.6768 | 12.6729 | 12.6768 | 40712.0 |
| 2011-02-09 08:04:00 | AAPL | Stock | 12.6764 | 12.6764 | 12.6732 | 12.6732 | 35700.0 |
| 2011-02-09 08:05:00 | AAPL | Stock | 12.6743 | 12.6743 | 12.6736 | 12.6736 | 11200.0 |
| 2011-02-09 08:06:00 | AAPL | Stock | 12.6764 | 12.6779 | 12.6764 | 12.6779 | 38640.0 |
| 2011-02-09 08:07:00 | AAPL | Stock | 12.6779 | 12.6804 | 12.6779 | 12.6793 | 37800.0 |
| 2011-02-09 08:08:00 | AAPL | Stock | 12.6811 | 12.6861 | 12.6811 | 12.6857 | 139300.0 |
| 2011-02-09 08:09:00 | AAPL | Stock | 12.6857 | 12.6861 | 12.6857 | 12.6857 | 14000.0 |
| 2011-02-09 08:10:00 | AAPL | Stock | 12.6861 | 12.6893 | 12.6839 | 12.6893 | 49280.0 |
| 2011-02-09 08:11:00 | AAPL | Stock | 12.6893 | 12.6932 | 12.6879 | 12.6914 | 77840.0 |
| 2011-02-09 08:12:00 | AAPL | Stock | 12.6918 | 12.6918 | 12.6918 | 12.6918 | 5600.0 |
| 2011-02-09 08:13:00 | AAPL | Stock | 12.6889 | 12.6911 | 12.6804 | 12.6804 | 101500.0 |
| 2011-02-09 08:14:00 | AAPL | Stock | 12.6868 | 12.6893 | 12.6868 | 12.6893 | 11200.0 |
| 2011-02-09 08:15:00 | AAPL | Stock | 12.6889 | 12.6893 | 12.6857 | 12.6857 | 16800.0 |
| 2011-02-09 08:16:00 | AAPL | Stock | 12.6857 | 12.6911 | 12.6857 | 12.6911 | 25480.0 |
| 2011-02-09 08:17:00 | AAPL | Stock | 12.6911 | 12.6911 | 12.6857 | 12.6857 | 38920.0 |
| 2011-02-09 08:18:00 | AAPL | Stock | 12.6854 | 12.6854 | 12.6764 | 12.6764 | 173600.0 |
| 2011-02-09 08:19:00 | AAPL | Stock | 12.6786 | 12.6786 | 12.6696 | 12.6696 | 77672.0 |
> showing 50 of 975,838 rows — these rows as CSV