PREVIEW / stock_1min / 2008-01-30
file: by_date/stock_1min/2008/2008-01-30.parquet size: 12.6 MB rows: 1,019,699 symbols: 2,665
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-30 04:37:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 4200.0 |
| 2008-01-30 05:03:00 | AAPL | Stock | 4.6761 | 4.6761 | 4.6761 | 4.6761 | 2800.0 |
| 2008-01-30 05:04:00 | AAPL | Stock | 4.6761 | 4.6761 | 4.6761 | 4.6761 | 2800.0 |
| 2008-01-30 06:42:00 | AAPL | Stock | 4.6886 | 4.6886 | 4.6886 | 4.6886 | 2800.0 |
| 2008-01-30 06:48:00 | AAPL | Stock | 4.6893 | 4.6964 | 4.6893 | 4.6964 | 21784.0 |
| 2008-01-30 06:49:00 | AAPL | Stock | 4.6964 | 4.6964 | 4.6964 | 4.6964 | 5600.0 |
| 2008-01-30 06:59:00 | AAPL | Stock | 4.6896 | 4.6896 | 4.6786 | 4.6786 | 13216.0 |
| 2008-01-30 07:10:00 | AAPL | Stock | 4.6821 | 4.6821 | 4.6821 | 4.6821 | 5600.0 |
| 2008-01-30 07:21:00 | AAPL | Stock | 4.6714 | 4.6714 | 4.6714 | 4.6714 | 5600.0 |
| 2008-01-30 07:27:00 | AAPL | Stock | 4.6704 | 4.6704 | 4.6696 | 4.6696 | 11200.0 |
| 2008-01-30 07:28:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6696 | 4.6696 | 2800.0 |
| 2008-01-30 07:29:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6696 | 4.6696 | 2800.0 |
| 2008-01-30 07:31:00 | AAPL | Stock | 4.6696 | 4.6696 | 4.6696 | 4.6696 | 2800.0 |
| 2008-01-30 07:33:00 | AAPL | Stock | 4.6696 | 4.6714 | 4.6696 | 4.6714 | 8400.0 |
| 2008-01-30 07:45:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 5012.0 |
| 2008-01-30 07:58:00 | AAPL | Stock | 4.6854 | 4.6893 | 4.6786 | 4.6786 | 61628.0 |
| 2008-01-30 07:59:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 16828.0 |
| 2008-01-30 08:00:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.675 | 4.6786 | 131684.0 |
| 2008-01-30 08:01:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 8400.0 |
| 2008-01-30 08:02:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.675 | 4.6786 | 35000.0 |
| 2008-01-30 08:03:00 | AAPL | Stock | 4.6818 | 4.6821 | 4.6818 | 4.6821 | 15120.0 |
| 2008-01-30 08:04:00 | AAPL | Stock | 4.6829 | 4.6854 | 4.6829 | 4.6854 | 11200.0 |
| 2008-01-30 08:05:00 | AAPL | Stock | 4.6821 | 4.6875 | 4.6804 | 4.6875 | 70280.0 |
| 2008-01-30 08:06:00 | AAPL | Stock | 4.6889 | 4.6946 | 4.6889 | 4.6946 | 43400.0 |
| 2008-01-30 08:07:00 | AAPL | Stock | 4.6839 | 4.6843 | 4.6786 | 4.6786 | 152152.0 |
| 2008-01-30 08:09:00 | AAPL | Stock | 4.6825 | 4.6825 | 4.6825 | 4.6825 | 14000.0 |
| 2008-01-30 08:10:00 | AAPL | Stock | 4.6829 | 4.6846 | 4.6829 | 4.6846 | 8400.0 |
| 2008-01-30 08:11:00 | AAPL | Stock | 4.6846 | 4.6846 | 4.6846 | 4.6846 | 2800.0 |
| 2008-01-30 08:12:00 | AAPL | Stock | 4.685 | 4.6857 | 4.685 | 4.6857 | 27580.0 |
| 2008-01-30 08:13:00 | AAPL | Stock | 4.6857 | 4.6857 | 4.6857 | 4.6857 | 4620.0 |
| 2008-01-30 08:14:00 | AAPL | Stock | 4.6821 | 4.6821 | 4.6821 | 4.6821 | 16800.0 |
| 2008-01-30 08:15:00 | AAPL | Stock | 4.6857 | 4.6961 | 4.6857 | 4.6943 | 106400.0 |
| 2008-01-30 08:16:00 | AAPL | Stock | 4.6868 | 4.6868 | 4.6864 | 4.6864 | 5600.0 |
| 2008-01-30 08:17:00 | AAPL | Stock | 4.6825 | 4.6825 | 4.6779 | 4.6786 | 114044.0 |
| 2008-01-30 08:18:00 | AAPL | Stock | 4.6821 | 4.6857 | 4.6821 | 4.6857 | 19600.0 |
| 2008-01-30 08:19:00 | AAPL | Stock | 4.6882 | 4.6893 | 4.6882 | 4.6882 | 14952.0 |
| 2008-01-30 08:20:00 | AAPL | Stock | 4.6879 | 4.6979 | 4.6879 | 4.6979 | 42700.0 |
| 2008-01-30 08:21:00 | AAPL | Stock | 4.6914 | 4.6979 | 4.6911 | 4.6946 | 104300.0 |
| 2008-01-30 08:22:00 | AAPL | Stock | 4.6957 | 4.6957 | 4.6925 | 4.6929 | 56000.0 |
| 2008-01-30 08:23:00 | AAPL | Stock | 4.6893 | 4.6893 | 4.6846 | 4.6846 | 33600.0 |
| 2008-01-30 08:24:00 | AAPL | Stock | 4.6875 | 4.6886 | 4.6875 | 4.6886 | 14000.0 |
| 2008-01-30 08:25:00 | AAPL | Stock | 4.6886 | 4.6893 | 4.6886 | 4.6893 | 88620.0 |
| 2008-01-30 08:26:00 | AAPL | Stock | 4.6893 | 4.6896 | 4.6893 | 4.6896 | 47600.0 |
| 2008-01-30 08:27:00 | AAPL | Stock | 4.6964 | 4.6964 | 4.6964 | 4.6964 | 27440.0 |
| 2008-01-30 08:28:00 | AAPL | Stock | 4.6954 | 4.7 | 4.6954 | 4.6986 | 31080.0 |
| 2008-01-30 08:29:00 | AAPL | Stock | 4.7 | 4.7014 | 4.6982 | 4.6982 | 80360.0 |
| 2008-01-30 08:30:00 | AAPL | Stock | 4.6964 | 4.6982 | 4.6832 | 4.6868 | 250320.0 |
| 2008-01-30 08:31:00 | AAPL | Stock | 4.6896 | 4.6896 | 4.685 | 4.685 | 19600.0 |
| 2008-01-30 08:32:00 | AAPL | Stock | 4.6843 | 4.6843 | 4.6821 | 4.6825 | 76300.0 |
| 2008-01-30 08:33:00 | AAPL | Stock | 4.685 | 4.6864 | 4.685 | 4.6864 | 32200.0 |
> showing 50 of 1,019,699 rows — these rows as CSV