PREVIEW / stock_1min / 2010-09-16
file: by_date/stock_1min/2010/2010-09-16.parquet size: 11.9 MB rows: 907,782 symbols: 2,806
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-09-16 04:38:00 | AAPL | Stock | 9.6536 | 9.6536 | 9.6536 | 9.6536 | 2800.0 |
| 2010-09-16 04:40:00 | AAPL | Stock | 9.6536 | 9.6536 | 9.6536 | 9.6536 | 2800.0 |
| 2010-09-16 06:30:00 | AAPL | Stock | 9.6782 | 9.6782 | 9.6782 | 9.6782 | 2800.0 |
| 2010-09-16 07:00:00 | AAPL | Stock | 9.6864 | 9.6864 | 9.6864 | 9.6864 | 2800.0 |
| 2010-09-16 07:01:00 | AAPL | Stock | 9.6786 | 9.6786 | 9.6786 | 9.6786 | 8400.0 |
| 2010-09-16 07:05:00 | AAPL | Stock | 9.6786 | 9.6786 | 9.6786 | 9.6786 | 2800.0 |
| 2010-09-16 07:06:00 | AAPL | Stock | 9.6825 | 9.6825 | 9.6825 | 9.6825 | 8400.0 |
| 2010-09-16 07:07:00 | AAPL | Stock | 9.6825 | 9.6825 | 9.6821 | 9.6821 | 5600.0 |
| 2010-09-16 07:08:00 | AAPL | Stock | 9.6825 | 9.6825 | 9.6825 | 9.6825 | 8400.0 |
| 2010-09-16 07:10:00 | AAPL | Stock | 9.6789 | 9.6854 | 9.6789 | 9.6789 | 14000.0 |
| 2010-09-16 07:12:00 | AAPL | Stock | 9.6836 | 9.6857 | 9.6836 | 9.6857 | 39200.0 |
| 2010-09-16 07:22:00 | AAPL | Stock | 9.6839 | 9.6839 | 9.6829 | 9.6829 | 11060.0 |
| 2010-09-16 07:25:00 | AAPL | Stock | 9.6821 | 9.6821 | 9.6821 | 9.6821 | 2800.0 |
| 2010-09-16 07:26:00 | AAPL | Stock | 9.6786 | 9.6786 | 9.6786 | 9.6786 | 5600.0 |
| 2010-09-16 07:29:00 | AAPL | Stock | 9.6857 | 9.6857 | 9.6857 | 9.6857 | 36400.0 |
| 2010-09-16 07:30:00 | AAPL | Stock | 9.6861 | 9.6861 | 9.6857 | 9.6857 | 32200.0 |
| 2010-09-16 07:31:00 | AAPL | Stock | 9.6857 | 9.6857 | 9.6857 | 9.6857 | 42000.0 |
| 2010-09-16 07:32:00 | AAPL | Stock | 9.6857 | 9.6857 | 9.6857 | 9.6857 | 5600.0 |
| 2010-09-16 07:33:00 | AAPL | Stock | 9.6857 | 9.6857 | 9.6857 | 9.6857 | 14000.0 |
| 2010-09-16 07:36:00 | AAPL | Stock | 9.6857 | 9.6857 | 9.6857 | 9.6857 | 11200.0 |
| 2010-09-16 07:37:00 | AAPL | Stock | 9.6821 | 9.6821 | 9.675 | 9.675 | 32900.0 |
| 2010-09-16 07:39:00 | AAPL | Stock | 9.6721 | 9.6721 | 9.6721 | 9.6721 | 11200.0 |
| 2010-09-16 07:40:00 | AAPL | Stock | 9.6718 | 9.6718 | 9.6714 | 9.6714 | 14000.0 |
| 2010-09-16 07:46:00 | AAPL | Stock | 9.6775 | 9.6779 | 9.6775 | 9.6779 | 14000.0 |
| 2010-09-16 07:50:00 | AAPL | Stock | 9.6789 | 9.6875 | 9.6789 | 9.6875 | 68124.0 |
| 2010-09-16 07:53:00 | AAPL | Stock | 9.68 | 9.68 | 9.68 | 9.68 | 2800.0 |
| 2010-09-16 08:00:00 | AAPL | Stock | 9.68 | 9.68 | 9.6743 | 9.6743 | 42700.0 |
| 2010-09-16 08:01:00 | AAPL | Stock | 9.6721 | 9.6746 | 9.6721 | 9.6736 | 20580.0 |
| 2010-09-16 08:02:00 | AAPL | Stock | 9.6732 | 9.6743 | 9.6718 | 9.6729 | 39200.0 |
| 2010-09-16 08:03:00 | AAPL | Stock | 9.6739 | 9.675 | 9.6714 | 9.675 | 81060.0 |
| 2010-09-16 08:04:00 | AAPL | Stock | 9.6743 | 9.6743 | 9.6743 | 9.6743 | 5600.0 |
| 2010-09-16 08:05:00 | AAPL | Stock | 9.6718 | 9.6718 | 9.6718 | 9.6718 | 2828.0 |
| 2010-09-16 08:06:00 | AAPL | Stock | 9.6732 | 9.6732 | 9.6714 | 9.6714 | 11788.0 |
| 2010-09-16 08:07:00 | AAPL | Stock | 9.6696 | 9.6739 | 9.6689 | 9.6736 | 163044.0 |
| 2010-09-16 08:08:00 | AAPL | Stock | 9.6732 | 9.6768 | 9.6704 | 9.6704 | 25200.0 |
| 2010-09-16 08:09:00 | AAPL | Stock | 9.6718 | 9.6743 | 9.6718 | 9.6743 | 8400.0 |
| 2010-09-16 08:10:00 | AAPL | Stock | 9.6721 | 9.6743 | 9.6714 | 9.6714 | 22400.0 |
| 2010-09-16 08:12:00 | AAPL | Stock | 9.6721 | 9.6721 | 9.6721 | 9.6721 | 2800.0 |
| 2010-09-16 08:14:00 | AAPL | Stock | 9.6732 | 9.6743 | 9.67 | 9.67 | 54600.0 |
| 2010-09-16 08:15:00 | AAPL | Stock | 9.6696 | 9.6696 | 9.6664 | 9.6682 | 15400.0 |
| 2010-09-16 08:16:00 | AAPL | Stock | 9.6679 | 9.6714 | 9.6679 | 9.6714 | 25480.0 |
| 2010-09-16 08:17:00 | AAPL | Stock | 9.6725 | 9.6732 | 9.6718 | 9.6718 | 19600.0 |
| 2010-09-16 08:18:00 | AAPL | Stock | 9.6714 | 9.6714 | 9.6682 | 9.6714 | 33096.0 |
| 2010-09-16 08:19:00 | AAPL | Stock | 9.6693 | 9.6711 | 9.6668 | 9.6682 | 96236.0 |
| 2010-09-16 08:20:00 | AAPL | Stock | 9.6682 | 9.6682 | 9.6671 | 9.6679 | 18228.0 |
| 2010-09-16 08:21:00 | AAPL | Stock | 9.6704 | 9.6707 | 9.6704 | 9.6707 | 19600.0 |
| 2010-09-16 08:22:00 | AAPL | Stock | 9.6675 | 9.6675 | 9.6675 | 9.6675 | 5600.0 |
| 2010-09-16 08:23:00 | AAPL | Stock | 9.6696 | 9.6696 | 9.6696 | 9.6696 | 14000.0 |
| 2010-09-16 08:24:00 | AAPL | Stock | 9.6696 | 9.6718 | 9.6696 | 9.6696 | 36120.0 |
| 2010-09-16 08:25:00 | AAPL | Stock | 9.6711 | 9.6732 | 9.6711 | 9.6714 | 18816.0 |
> showing 50 of 907,782 rows — these rows as CSV