PREVIEW / stock_1min / 2007-10-16
file: by_date/stock_1min/2007/2007-10-16.parquet size: 11.6 MB rows: 941,117 symbols: 2,576
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-16 05:56:00 | AAPL | Stock | 5.9007 | 5.9007 | 5.9007 | 5.9007 | 5600.0 |
| 2007-10-16 06:36:00 | AAPL | Stock | 5.9357 | 5.9357 | 5.9357 | 5.9357 | 2800.0 |
| 2007-10-16 06:37:00 | AAPL | Stock | 5.9357 | 5.9357 | 5.9357 | 5.9357 | 2800.0 |
| 2007-10-16 06:46:00 | AAPL | Stock | 5.8882 | 5.8882 | 5.8882 | 5.8882 | 2800.0 |
| 2007-10-16 06:55:00 | AAPL | Stock | 5.9143 | 5.9143 | 5.9143 | 5.9143 | 2800.0 |
| 2007-10-16 06:57:00 | AAPL | Stock | 5.8886 | 5.8886 | 5.8886 | 5.8886 | 2800.0 |
| 2007-10-16 07:00:00 | AAPL | Stock | 5.8925 | 5.8925 | 5.8843 | 5.8843 | 16800.0 |
| 2007-10-16 07:01:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8925 | 5.8929 | 35000.0 |
| 2007-10-16 07:02:00 | AAPL | Stock | 5.8811 | 5.8811 | 5.8732 | 5.8732 | 47600.0 |
| 2007-10-16 07:03:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 26600.0 |
| 2007-10-16 07:09:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 25200.0 |
| 2007-10-16 07:11:00 | AAPL | Stock | 5.8925 | 5.8925 | 5.8925 | 5.8925 | 2800.0 |
| 2007-10-16 07:17:00 | AAPL | Stock | 5.8882 | 5.8882 | 5.8879 | 5.8879 | 5600.0 |
| 2007-10-16 07:19:00 | AAPL | Stock | 5.8821 | 5.8821 | 5.8821 | 5.8821 | 2800.0 |
| 2007-10-16 07:24:00 | AAPL | Stock | 5.875 | 5.875 | 5.875 | 5.875 | 14000.0 |
| 2007-10-16 07:26:00 | AAPL | Stock | 5.8925 | 5.8929 | 5.8925 | 5.8929 | 16800.0 |
| 2007-10-16 07:27:00 | AAPL | Stock | 5.8918 | 5.8918 | 5.8911 | 5.8911 | 5600.0 |
| 2007-10-16 07:29:00 | AAPL | Stock | 5.8907 | 5.8907 | 5.8907 | 5.8907 | 44660.0 |
| 2007-10-16 07:30:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8929 | 5.8929 | 14000.0 |
| 2007-10-16 07:33:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8889 | 5.8889 | 28000.0 |
| 2007-10-16 07:34:00 | AAPL | Stock | 5.8889 | 5.8929 | 5.8889 | 5.8929 | 11200.0 |
| 2007-10-16 07:35:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8893 | 5.8893 | 54600.0 |
| 2007-10-16 07:38:00 | AAPL | Stock | 5.8893 | 5.8893 | 5.8893 | 5.8893 | 6104.0 |
| 2007-10-16 07:41:00 | AAPL | Stock | 5.8893 | 5.8929 | 5.8893 | 5.8929 | 28000.0 |
| 2007-10-16 07:42:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 14000.0 |
| 2007-10-16 07:43:00 | AAPL | Stock | 5.8911 | 5.8911 | 5.8911 | 5.8911 | 14000.0 |
| 2007-10-16 07:47:00 | AAPL | Stock | 5.8857 | 5.8857 | 5.8857 | 5.8857 | 28000.0 |
| 2007-10-16 07:51:00 | AAPL | Stock | 5.8911 | 5.8929 | 5.8911 | 5.8929 | 28000.0 |
| 2007-10-16 07:52:00 | AAPL | Stock | 5.8929 | 5.9018 | 5.8929 | 5.9018 | 15736.0 |
| 2007-10-16 07:54:00 | AAPL | Stock | 5.9 | 5.9018 | 5.8968 | 5.8968 | 22400.0 |
| 2007-10-16 07:55:00 | AAPL | Stock | 5.9036 | 5.9036 | 5.9036 | 5.9036 | 14000.0 |
| 2007-10-16 07:56:00 | AAPL | Stock | 5.9054 | 5.9096 | 5.9054 | 5.9096 | 16800.0 |
| 2007-10-16 07:57:00 | AAPL | Stock | 5.9061 | 5.9061 | 5.9061 | 5.9061 | 2800.0 |
| 2007-10-16 08:00:00 | AAPL | Stock | 5.9096 | 5.9246 | 5.8893 | 5.9243 | 415016.0 |
| 2007-10-16 08:01:00 | AAPL | Stock | 5.9214 | 5.9214 | 5.9118 | 5.9143 | 79100.0 |
| 2007-10-16 08:02:00 | AAPL | Stock | 5.9125 | 5.9143 | 5.9057 | 5.9143 | 39536.0 |
| 2007-10-16 08:03:00 | AAPL | Stock | 5.9143 | 5.9179 | 5.9079 | 5.91 | 248052.0 |
| 2007-10-16 08:04:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9046 | 5.9071 | 52640.0 |
| 2007-10-16 08:05:00 | AAPL | Stock | 5.91 | 5.9107 | 5.9071 | 5.9107 | 64400.0 |
| 2007-10-16 08:06:00 | AAPL | Stock | 5.9071 | 5.9071 | 5.9018 | 5.9018 | 56952.0 |
| 2007-10-16 08:07:00 | AAPL | Stock | 5.9018 | 5.9018 | 5.9018 | 5.9018 | 29400.0 |
| 2007-10-16 08:08:00 | AAPL | Stock | 5.9018 | 5.9018 | 5.8925 | 5.8929 | 294952.0 |
| 2007-10-16 08:09:00 | AAPL | Stock | 5.8929 | 5.8929 | 5.8886 | 5.8893 | 231868.0 |
| 2007-10-16 08:10:00 | AAPL | Stock | 5.8921 | 5.8929 | 5.8911 | 5.8929 | 107856.0 |
| 2007-10-16 08:11:00 | AAPL | Stock | 5.8929 | 5.8968 | 5.8893 | 5.8964 | 39396.0 |
| 2007-10-16 08:12:00 | AAPL | Stock | 5.9032 | 5.9032 | 5.8964 | 5.8964 | 56644.0 |
| 2007-10-16 08:13:00 | AAPL | Stock | 5.8979 | 5.8996 | 5.8925 | 5.8925 | 64988.0 |
| 2007-10-16 08:14:00 | AAPL | Stock | 5.8921 | 5.8929 | 5.8921 | 5.8929 | 68376.0 |
| 2007-10-16 08:15:00 | AAPL | Stock | 5.8964 | 5.8964 | 5.8946 | 5.8961 | 36400.0 |
| 2007-10-16 08:16:00 | AAPL | Stock | 5.8946 | 5.8946 | 5.8857 | 5.89 | 112280.0 |
> showing 50 of 941,117 rows — these rows as CSV