PREVIEW / stock_1min / 2009-12-29
file: by_date/stock_1min/2009/2009-12-29.parquet size: 11.5 MB rows: 863,309 symbols: 2,820
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-12-29 04:25:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 5600.0 |
| 2009-12-29 05:21:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 2800.0 |
| 2009-12-29 05:49:00 | AAPL | Stock | 7.575 | 7.575 | 7.575 | 7.575 | 2800.0 |
| 2009-12-29 05:55:00 | AAPL | Stock | 7.5714 | 7.5714 | 7.5714 | 7.5714 | 2800.0 |
| 2009-12-29 06:23:00 | AAPL | Stock | 7.5707 | 7.5707 | 7.5707 | 7.5707 | 2800.0 |
| 2009-12-29 07:00:00 | AAPL | Stock | 7.5836 | 7.5836 | 7.5836 | 7.5836 | 11200.0 |
| 2009-12-29 07:04:00 | AAPL | Stock | 7.5825 | 7.5825 | 7.5821 | 7.5821 | 5600.0 |
| 2009-12-29 07:16:00 | AAPL | Stock | 7.5814 | 7.5814 | 7.5814 | 7.5814 | 5600.0 |
| 2009-12-29 07:33:00 | AAPL | Stock | 7.5782 | 7.5821 | 7.5782 | 7.5821 | 16940.0 |
| 2009-12-29 07:38:00 | AAPL | Stock | 7.585 | 7.585 | 7.585 | 7.585 | 2800.0 |
| 2009-12-29 07:51:00 | AAPL | Stock | 7.5875 | 7.5875 | 7.5875 | 7.5875 | 14000.0 |
| 2009-12-29 07:53:00 | AAPL | Stock | 7.5993 | 7.5993 | 7.5993 | 7.5993 | 2800.0 |
| 2009-12-29 07:59:00 | AAPL | Stock | 7.5982 | 7.5982 | 7.5929 | 7.5929 | 19600.0 |
| 2009-12-29 08:00:00 | AAPL | Stock | 7.5893 | 7.6021 | 7.5893 | 7.5982 | 191604.0 |
| 2009-12-29 08:01:00 | AAPL | Stock | 7.6014 | 7.6018 | 7.5939 | 7.5939 | 85988.0 |
| 2009-12-29 08:02:00 | AAPL | Stock | 7.5939 | 7.5975 | 7.5929 | 7.5957 | 161784.0 |
| 2009-12-29 08:03:00 | AAPL | Stock | 7.5939 | 7.5982 | 7.5939 | 7.5964 | 240800.0 |
| 2009-12-29 08:04:00 | AAPL | Stock | 7.5964 | 7.5975 | 7.5946 | 7.5946 | 22400.0 |
| 2009-12-29 08:05:00 | AAPL | Stock | 7.5946 | 7.6018 | 7.5946 | 7.5964 | 77952.0 |
| 2009-12-29 08:06:00 | AAPL | Stock | 7.595 | 7.5982 | 7.595 | 7.5982 | 16800.0 |
| 2009-12-29 08:07:00 | AAPL | Stock | 7.6014 | 7.6014 | 7.595 | 7.595 | 136332.0 |
| 2009-12-29 08:08:00 | AAPL | Stock | 7.5946 | 7.6 | 7.5946 | 7.6 | 5600.0 |
| 2009-12-29 08:09:00 | AAPL | Stock | 7.5993 | 7.5996 | 7.5946 | 7.5946 | 39704.0 |
| 2009-12-29 08:10:00 | AAPL | Stock | 7.5946 | 7.5946 | 7.5911 | 7.5911 | 39480.0 |
| 2009-12-29 08:11:00 | AAPL | Stock | 7.5929 | 7.5929 | 7.5929 | 7.5929 | 5600.0 |
| 2009-12-29 08:12:00 | AAPL | Stock | 7.5954 | 7.6036 | 7.5946 | 7.5964 | 87612.0 |
| 2009-12-29 08:13:00 | AAPL | Stock | 7.6 | 7.6011 | 7.6 | 7.6011 | 9240.0 |
| 2009-12-29 08:14:00 | AAPL | Stock | 7.6 | 7.6 | 7.5982 | 7.5982 | 29120.0 |
| 2009-12-29 08:15:00 | AAPL | Stock | 7.5968 | 7.6 | 7.5964 | 7.6 | 36400.0 |
| 2009-12-29 08:16:00 | AAPL | Stock | 7.5982 | 7.5982 | 7.5968 | 7.5968 | 70588.0 |
| 2009-12-29 08:17:00 | AAPL | Stock | 7.5971 | 7.5971 | 7.5911 | 7.5914 | 49168.0 |
| 2009-12-29 08:18:00 | AAPL | Stock | 7.5929 | 7.5946 | 7.5929 | 7.5946 | 28000.0 |
| 2009-12-29 08:19:00 | AAPL | Stock | 7.5946 | 7.6036 | 7.5946 | 7.595 | 140868.0 |
| 2009-12-29 08:22:00 | AAPL | Stock | 7.6007 | 7.6007 | 7.5975 | 7.5975 | 5600.0 |
| 2009-12-29 08:23:00 | AAPL | Stock | 7.5971 | 7.5971 | 7.5929 | 7.5929 | 65800.0 |
| 2009-12-29 08:24:00 | AAPL | Stock | 7.5968 | 7.5968 | 7.5968 | 7.5968 | 3500.0 |
| 2009-12-29 08:26:00 | AAPL | Stock | 7.5936 | 7.5936 | 7.5929 | 7.5932 | 33600.0 |
| 2009-12-29 08:27:00 | AAPL | Stock | 7.5929 | 7.5946 | 7.5911 | 7.5925 | 176400.0 |
| 2009-12-29 08:28:00 | AAPL | Stock | 7.5893 | 7.5893 | 7.5812 | 7.5812 | 203000.0 |
| 2009-12-29 08:29:00 | AAPL | Stock | 7.5889 | 7.5889 | 7.5889 | 7.5889 | 2800.0 |
| 2009-12-29 08:30:00 | AAPL | Stock | 7.5857 | 7.5875 | 7.5857 | 7.5857 | 78400.0 |
| 2009-12-29 08:31:00 | AAPL | Stock | 7.5836 | 7.5893 | 7.5836 | 7.5893 | 22400.0 |
| 2009-12-29 08:32:00 | AAPL | Stock | 7.5907 | 7.5911 | 7.5907 | 7.5911 | 28000.0 |
| 2009-12-29 08:33:00 | AAPL | Stock | 7.5896 | 7.5896 | 7.5879 | 7.5879 | 69020.0 |
| 2009-12-29 08:34:00 | AAPL | Stock | 7.5893 | 7.5893 | 7.5889 | 7.5889 | 11620.0 |
| 2009-12-29 08:35:00 | AAPL | Stock | 7.5886 | 7.5893 | 7.5886 | 7.5893 | 19600.0 |
| 2009-12-29 08:36:00 | AAPL | Stock | 7.5882 | 7.5882 | 7.5839 | 7.5839 | 74340.0 |
| 2009-12-29 08:37:00 | AAPL | Stock | 7.5843 | 7.585 | 7.5839 | 7.585 | 19600.0 |
| 2009-12-29 08:38:00 | AAPL | Stock | 7.5825 | 7.5839 | 7.5804 | 7.5804 | 44464.0 |
| 2009-12-29 08:39:00 | AAPL | Stock | 7.5821 | 7.5821 | 7.5821 | 7.5821 | 2800.0 |
> showing 50 of 863,309 rows — these rows as CSV