PREVIEW / stock_1min / 2010-08-20
file: by_date/stock_1min/2010/2010-08-20.parquet size: 12.0 MB rows: 922,082 symbols: 2,809
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-08-20 06:11:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 2800.0 |
| 2010-08-20 06:14:00 | AAPL | Stock | 8.8879 | 8.8879 | 8.8879 | 8.8879 | 2800.0 |
| 2010-08-20 06:18:00 | AAPL | Stock | 8.8814 | 8.8814 | 8.8814 | 8.8814 | 2800.0 |
| 2010-08-20 06:30:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8571 | 8.8571 | 2800.0 |
| 2010-08-20 07:04:00 | AAPL | Stock | 8.8418 | 8.8418 | 8.8418 | 8.8418 | 2800.0 |
| 2010-08-20 07:13:00 | AAPL | Stock | 8.8696 | 8.8696 | 8.8696 | 8.8696 | 2800.0 |
| 2010-08-20 07:17:00 | AAPL | Stock | 8.87 | 8.87 | 8.87 | 8.87 | 8400.0 |
| 2010-08-20 07:31:00 | AAPL | Stock | 8.8604 | 8.8604 | 8.8604 | 8.8604 | 2800.0 |
| 2010-08-20 07:32:00 | AAPL | Stock | 8.8696 | 8.875 | 8.8696 | 8.875 | 11340.0 |
| 2010-08-20 07:36:00 | AAPL | Stock | 8.8768 | 8.8768 | 8.8768 | 8.8768 | 4200.0 |
| 2010-08-20 07:48:00 | AAPL | Stock | 8.8746 | 8.8746 | 8.8746 | 8.8746 | 2940.0 |
| 2010-08-20 07:50:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 4480.0 |
| 2010-08-20 07:51:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 2800.0 |
| 2010-08-20 07:52:00 | AAPL | Stock | 8.8768 | 8.8768 | 8.8768 | 8.8768 | 2800.0 |
| 2010-08-20 07:53:00 | AAPL | Stock | 8.8768 | 8.8768 | 8.8768 | 8.8768 | 9380.0 |
| 2010-08-20 08:00:00 | AAPL | Stock | 8.8768 | 8.8839 | 8.875 | 8.875 | 94752.0 |
| 2010-08-20 08:04:00 | AAPL | Stock | 8.8761 | 8.8764 | 8.8757 | 8.8757 | 26600.0 |
| 2010-08-20 08:05:00 | AAPL | Stock | 8.8814 | 8.8857 | 8.8804 | 8.8857 | 28644.0 |
| 2010-08-20 08:06:00 | AAPL | Stock | 8.8857 | 8.8857 | 8.8857 | 8.8857 | 8400.0 |
| 2010-08-20 08:09:00 | AAPL | Stock | 8.8857 | 8.8857 | 8.8857 | 8.8857 | 2800.0 |
| 2010-08-20 08:12:00 | AAPL | Stock | 8.8857 | 8.8857 | 8.8857 | 8.8857 | 27664.0 |
| 2010-08-20 08:13:00 | AAPL | Stock | 8.8857 | 8.8857 | 8.8839 | 8.8839 | 41160.0 |
| 2010-08-20 08:14:00 | AAPL | Stock | 8.8875 | 8.8875 | 8.8857 | 8.8857 | 16800.0 |
| 2010-08-20 08:15:00 | AAPL | Stock | 8.8843 | 8.8843 | 8.8839 | 8.8839 | 12796.0 |
| 2010-08-20 08:18:00 | AAPL | Stock | 8.8857 | 8.8857 | 8.8854 | 8.8854 | 8400.0 |
| 2010-08-20 08:19:00 | AAPL | Stock | 8.8854 | 8.8857 | 8.8854 | 8.8857 | 11200.0 |
| 2010-08-20 08:21:00 | AAPL | Stock | 8.8868 | 8.8868 | 8.8868 | 8.8868 | 14000.0 |
| 2010-08-20 08:22:00 | AAPL | Stock | 8.8875 | 8.8889 | 8.8868 | 8.8889 | 34888.0 |
| 2010-08-20 08:23:00 | AAPL | Stock | 8.8893 | 8.8893 | 8.8846 | 8.8846 | 100604.0 |
| 2010-08-20 08:24:00 | AAPL | Stock | 8.8843 | 8.8843 | 8.8804 | 8.8807 | 11200.0 |
| 2010-08-20 08:25:00 | AAPL | Stock | 8.8821 | 8.8821 | 8.8821 | 8.8821 | 2800.0 |
| 2010-08-20 08:31:00 | AAPL | Stock | 8.8789 | 8.8789 | 8.8789 | 8.8789 | 2800.0 |
| 2010-08-20 08:32:00 | AAPL | Stock | 8.8786 | 8.88 | 8.8782 | 8.88 | 11200.0 |
| 2010-08-20 08:33:00 | AAPL | Stock | 8.8786 | 8.8804 | 8.8754 | 8.8754 | 29680.0 |
| 2010-08-20 08:37:00 | AAPL | Stock | 8.8757 | 8.8757 | 8.8757 | 8.8757 | 2800.0 |
| 2010-08-20 08:38:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 2800.0 |
| 2010-08-20 08:39:00 | AAPL | Stock | 8.8725 | 8.8732 | 8.8725 | 8.8732 | 8400.0 |
| 2010-08-20 08:40:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 16800.0 |
| 2010-08-20 08:41:00 | AAPL | Stock | 8.8739 | 8.8746 | 8.8739 | 8.8746 | 5600.0 |
| 2010-08-20 08:42:00 | AAPL | Stock | 8.8704 | 8.8704 | 8.8704 | 8.8704 | 7168.0 |
| 2010-08-20 08:43:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 2800.0 |
| 2010-08-20 08:45:00 | AAPL | Stock | 8.875 | 8.875 | 8.8714 | 8.8732 | 43400.0 |
| 2010-08-20 08:46:00 | AAPL | Stock | 8.8707 | 8.875 | 8.8707 | 8.875 | 43568.0 |
| 2010-08-20 08:47:00 | AAPL | Stock | 8.8739 | 8.8739 | 8.8718 | 8.8718 | 11200.0 |
| 2010-08-20 08:49:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 10584.0 |
| 2010-08-20 08:50:00 | AAPL | Stock | 8.8732 | 8.875 | 8.8732 | 8.875 | 19600.0 |
| 2010-08-20 08:51:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 5600.0 |
| 2010-08-20 08:52:00 | AAPL | Stock | 8.875 | 8.8818 | 8.875 | 8.8818 | 11536.0 |
| 2010-08-20 08:53:00 | AAPL | Stock | 8.8825 | 8.8886 | 8.8825 | 8.8871 | 92400.0 |
| 2010-08-20 08:55:00 | AAPL | Stock | 8.8857 | 8.8893 | 8.8857 | 8.8893 | 5600.0 |
> showing 50 of 922,082 rows — these rows as CSV