PREVIEW / stock_1min / 2010-07-20
file: by_date/stock_1min/2010/2010-07-20.parquet size: 12.3 MB rows: 932,734 symbols: 2,808
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-07-20 05:01:00 | AAPL | Stock | 8.735 | 8.735 | 8.735 | 8.735 | 2800.0 |
| 2010-07-20 05:47:00 | AAPL | Stock | 8.7357 | 8.7357 | 8.7357 | 8.7357 | 2800.0 |
| 2010-07-20 05:52:00 | AAPL | Stock | 8.7039 | 8.7039 | 8.7036 | 8.7036 | 14000.0 |
| 2010-07-20 05:53:00 | AAPL | Stock | 8.7 | 8.7 | 8.7 | 8.7 | 13580.0 |
| 2010-07-20 05:56:00 | AAPL | Stock | 8.7 | 8.7 | 8.7 | 8.7 | 2800.0 |
| 2010-07-20 05:57:00 | AAPL | Stock | 8.7 | 8.7 | 8.6993 | 8.6993 | 9940.0 |
| 2010-07-20 05:58:00 | AAPL | Stock | 8.6868 | 8.6868 | 8.6868 | 8.6868 | 2800.0 |
| 2010-07-20 05:59:00 | AAPL | Stock | 8.6964 | 8.6964 | 8.6964 | 8.6964 | 5600.0 |
| 2010-07-20 06:13:00 | AAPL | Stock | 8.6868 | 8.6868 | 8.6868 | 8.6868 | 2800.0 |
| 2010-07-20 06:15:00 | AAPL | Stock | 8.6825 | 8.6825 | 8.6825 | 8.6825 | 6608.0 |
| 2010-07-20 06:19:00 | AAPL | Stock | 8.6825 | 8.6825 | 8.6825 | 8.6825 | 7392.0 |
| 2010-07-20 06:21:00 | AAPL | Stock | 8.6821 | 8.6821 | 8.6821 | 8.6821 | 2800.0 |
| 2010-07-20 06:25:00 | AAPL | Stock | 8.6821 | 8.6821 | 8.6821 | 8.6821 | 5600.0 |
| 2010-07-20 06:27:00 | AAPL | Stock | 8.6786 | 8.6786 | 8.6714 | 8.6714 | 5600.0 |
| 2010-07-20 06:28:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 8400.0 |
| 2010-07-20 06:29:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 2800.0 |
| 2010-07-20 06:36:00 | AAPL | Stock | 8.6607 | 8.6607 | 8.6607 | 8.6607 | 2800.0 |
| 2010-07-20 06:44:00 | AAPL | Stock | 8.6707 | 8.6711 | 8.6707 | 8.6711 | 20748.0 |
| 2010-07-20 06:48:00 | AAPL | Stock | 8.6643 | 8.6643 | 8.6643 | 8.6643 | 2800.0 |
| 2010-07-20 06:49:00 | AAPL | Stock | 8.6711 | 8.6711 | 8.6711 | 8.6711 | 2800.0 |
| 2010-07-20 06:54:00 | AAPL | Stock | 8.6711 | 8.6711 | 8.6711 | 8.6711 | 2800.0 |
| 2010-07-20 07:01:00 | AAPL | Stock | 8.6575 | 8.6575 | 8.6571 | 8.6571 | 14000.0 |
| 2010-07-20 07:11:00 | AAPL | Stock | 8.6643 | 8.6714 | 8.6643 | 8.6714 | 30800.0 |
| 2010-07-20 07:13:00 | AAPL | Stock | 8.6921 | 8.6921 | 8.6921 | 8.6921 | 2800.0 |
| 2010-07-20 07:15:00 | AAPL | Stock | 8.6857 | 8.6857 | 8.6857 | 8.6857 | 2800.0 |
| 2010-07-20 07:16:00 | AAPL | Stock | 8.6821 | 8.6911 | 8.6821 | 8.6911 | 12600.0 |
| 2010-07-20 07:17:00 | AAPL | Stock | 8.6918 | 8.6918 | 8.6911 | 8.6911 | 5600.0 |
| 2010-07-20 07:19:00 | AAPL | Stock | 8.6946 | 8.6946 | 8.6946 | 8.6946 | 2800.0 |
| 2010-07-20 07:21:00 | AAPL | Stock | 8.6875 | 8.6875 | 8.6857 | 8.6857 | 9800.0 |
| 2010-07-20 07:22:00 | AAPL | Stock | 8.6857 | 8.6857 | 8.6789 | 8.6789 | 26320.0 |
| 2010-07-20 07:26:00 | AAPL | Stock | 8.6789 | 8.6789 | 8.6789 | 8.6789 | 8400.0 |
| 2010-07-20 07:38:00 | AAPL | Stock | 8.6807 | 8.6807 | 8.6807 | 8.6807 | 8400.0 |
| 2010-07-20 07:45:00 | AAPL | Stock | 8.6896 | 8.6896 | 8.6857 | 8.6857 | 14000.0 |
| 2010-07-20 07:46:00 | AAPL | Stock | 8.6857 | 8.7 | 8.6807 | 8.7 | 25200.0 |
| 2010-07-20 07:48:00 | AAPL | Stock | 8.6811 | 8.6879 | 8.6807 | 8.6879 | 36400.0 |
| 2010-07-20 07:50:00 | AAPL | Stock | 8.6918 | 8.6918 | 8.6918 | 8.6918 | 2800.0 |
| 2010-07-20 07:51:00 | AAPL | Stock | 8.6829 | 8.6857 | 8.6825 | 8.6843 | 28000.0 |
| 2010-07-20 07:54:00 | AAPL | Stock | 8.6821 | 8.6821 | 8.6821 | 8.6821 | 2800.0 |
| 2010-07-20 07:55:00 | AAPL | Stock | 8.6864 | 8.6864 | 8.6864 | 8.6864 | 2800.0 |
| 2010-07-20 07:57:00 | AAPL | Stock | 8.6821 | 8.6857 | 8.6821 | 8.6854 | 16800.0 |
| 2010-07-20 07:58:00 | AAPL | Stock | 8.6875 | 8.6946 | 8.6875 | 8.6946 | 22400.0 |
| 2010-07-20 07:59:00 | AAPL | Stock | 8.6957 | 8.6957 | 8.6957 | 8.6957 | 14000.0 |
| 2010-07-20 08:00:00 | AAPL | Stock | 8.6964 | 8.7125 | 8.6946 | 8.7125 | 104636.0 |
| 2010-07-20 08:01:00 | AAPL | Stock | 8.7121 | 8.7121 | 8.6989 | 8.6989 | 33628.0 |
| 2010-07-20 08:02:00 | AAPL | Stock | 8.6982 | 8.7125 | 8.6964 | 8.7107 | 104104.0 |
| 2010-07-20 08:03:00 | AAPL | Stock | 8.6989 | 8.6989 | 8.6986 | 8.6986 | 11200.0 |
| 2010-07-20 08:04:00 | AAPL | Stock | 8.6989 | 8.7004 | 8.6946 | 8.6964 | 127232.0 |
| 2010-07-20 08:05:00 | AAPL | Stock | 8.6964 | 8.6975 | 8.6807 | 8.6868 | 190820.0 |
| 2010-07-20 08:06:00 | AAPL | Stock | 8.7014 | 8.7089 | 8.6921 | 8.6986 | 48720.0 |
| 2010-07-20 08:07:00 | AAPL | Stock | 8.6793 | 8.6964 | 8.6793 | 8.6804 | 81620.0 |
> showing 50 of 932,734 rows — these rows as CSV