PREVIEW / stock_1min / 2009-09-02
file: by_date/stock_1min/2009/2009-09-02.parquet size: 12.4 MB rows: 958,620 symbols: 2,732
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-02 04:36:00 | AAPL | Stock | 5.8393 | 5.8393 | 5.8214 | 5.8214 | 8400.0 |
| 2009-09-02 04:38:00 | AAPL | Stock | 5.8214 | 5.8214 | 5.8214 | 5.8214 | 19600.0 |
| 2009-09-02 05:43:00 | AAPL | Stock | 5.8482 | 5.8482 | 5.8482 | 5.8482 | 2800.0 |
| 2009-09-02 06:38:00 | AAPL | Stock | 5.8682 | 5.8682 | 5.8682 | 5.8682 | 2800.0 |
| 2009-09-02 06:39:00 | AAPL | Stock | 5.8675 | 5.8675 | 5.8675 | 5.8675 | 16800.0 |
| 2009-09-02 06:54:00 | AAPL | Stock | 5.8754 | 5.8754 | 5.875 | 5.875 | 27944.0 |
| 2009-09-02 07:02:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 2800.0 |
| 2009-09-02 07:03:00 | AAPL | Stock | 5.8786 | 5.8786 | 5.8786 | 5.8786 | 8400.0 |
| 2009-09-02 07:04:00 | AAPL | Stock | 5.8786 | 5.8786 | 5.8786 | 5.8786 | 2800.0 |
| 2009-09-02 07:05:00 | AAPL | Stock | 5.8757 | 5.8757 | 5.8757 | 5.8757 | 10192.0 |
| 2009-09-02 07:21:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 15372.0 |
| 2009-09-02 07:23:00 | AAPL | Stock | 5.8821 | 5.8839 | 5.8821 | 5.8839 | 5600.0 |
| 2009-09-02 07:24:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 8400.0 |
| 2009-09-02 07:28:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 3836.0 |
| 2009-09-02 07:36:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 2800.0 |
| 2009-09-02 07:46:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 5600.0 |
| 2009-09-02 07:48:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 2800.0 |
| 2009-09-02 07:49:00 | AAPL | Stock | 5.8875 | 5.8875 | 5.8875 | 5.8875 | 2800.0 |
| 2009-09-02 07:50:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 14000.0 |
| 2009-09-02 08:00:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8911 | 5.8911 | 16436.0 |
| 2009-09-02 08:03:00 | AAPL | Stock | 5.8946 | 5.8964 | 5.8946 | 5.8964 | 8400.0 |
| 2009-09-02 08:04:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8932 | 5.8932 | 13160.0 |
| 2009-09-02 08:05:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8929 | 5.8929 | 11200.0 |
| 2009-09-02 08:07:00 | AAPL | Stock | 5.8932 | 5.8932 | 5.8932 | 5.8932 | 5040.0 |
| 2009-09-02 08:08:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8925 | 5.8925 | 8400.0 |
| 2009-09-02 08:09:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8893 | 5.8893 | 49700.0 |
| 2009-09-02 08:10:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8896 | 5.8896 | 26096.0 |
| 2009-09-02 08:13:00 | AAPL | Stock | 5.8925 | 5.8925 | 5.8925 | 5.8925 | 48804.0 |
| 2009-09-02 08:14:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8929 | 5.8929 | 12012.0 |
| 2009-09-02 08:15:00 | AAPL | Stock | 5.8925 | 5.8925 | 5.8893 | 5.8893 | 53200.0 |
| 2009-09-02 08:16:00 | AAPL | Stock | 5.8886 | 5.8886 | 5.8857 | 5.8857 | 8400.0 |
| 2009-09-02 08:17:00 | AAPL | Stock | 5.8886 | 5.8886 | 5.8857 | 5.8886 | 15148.0 |
| 2009-09-02 08:18:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8893 | 5.8893 | 8148.0 |
| 2009-09-02 08:19:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 2800.0 |
| 2009-09-02 08:23:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8893 | 5.8893 | 33768.0 |
| 2009-09-02 08:24:00 | AAPL | Stock | 5.8896 | 5.8896 | 5.8896 | 5.8896 | 2800.0 |
| 2009-09-02 08:25:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8893 | 5.8893 | 5600.0 |
| 2009-09-02 08:26:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8893 | 5.8893 | 5600.0 |
| 2009-09-02 08:27:00 | AAPL | Stock | 5.8843 | 5.8857 | 5.8843 | 5.8857 | 11200.0 |
| 2009-09-02 08:28:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 3360.0 |
| 2009-09-02 08:29:00 | AAPL | Stock | 5.8907 | 5.8907 | 5.8907 | 5.8907 | 2800.0 |
| 2009-09-02 08:30:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8839 | 5.8839 | 30996.0 |
| 2009-09-02 08:32:00 | AAPL | Stock | 5.8861 | 5.8861 | 5.8861 | 5.8861 | 2800.0 |
| 2009-09-02 08:33:00 | AAPL | Stock | 5.8896 | 5.8896 | 5.8896 | 5.8896 | 12880.0 |
| 2009-09-02 08:34:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8925 | 5.8929 | 25592.0 |
| 2009-09-02 08:35:00 | AAPL | Stock | 5.8936 | 5.8936 | 5.8936 | 5.8936 | 2800.0 |
| 2009-09-02 08:36:00 | AAPL | Stock | 5.8939 | 5.8939 | 5.8939 | 5.8939 | 2800.0 |
| 2009-09-02 08:37:00 | AAPL | Stock | 5.8968 | 5.8968 | 5.8968 | 5.8968 | 2800.0 |
| 2009-09-02 08:38:00 | AAPL | Stock | 5.8971 | 5.9 | 5.8971 | 5.9 | 9100.0 |
| 2009-09-02 08:39:00 | AAPL | Stock | 5.8996 | 5.8996 | 5.8996 | 5.8996 | 11200.0 |
> showing 50 of 958,620 rows — these rows as CSV