PREVIEW / stock_1min / 2008-10-17
file: by_date/stock_1min/2008/2008-10-17.parquet size: 13.3 MB rows: 1,053,217 symbols: 2,707
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-10-17 05:30:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6268 | 3.6268 | 28000.0 |
| 2008-10-17 05:36:00 | AAPL | Stock | 3.6268 | 3.6268 | 3.6268 | 3.6268 | 12600.0 |
| 2008-10-17 07:00:00 | AAPL | Stock | 3.6175 | 3.6175 | 3.6175 | 3.6175 | 5600.0 |
| 2008-10-17 07:12:00 | AAPL | Stock | 3.6436 | 3.6436 | 3.6429 | 3.6429 | 39200.0 |
| 2008-10-17 07:14:00 | AAPL | Stock | 3.65 | 3.65 | 3.65 | 3.65 | 5600.0 |
| 2008-10-17 07:16:00 | AAPL | Stock | 3.6414 | 3.6414 | 3.6339 | 3.6339 | 39200.0 |
| 2008-10-17 07:18:00 | AAPL | Stock | 3.6429 | 3.6429 | 3.6429 | 3.6429 | 8400.0 |
| 2008-10-17 07:25:00 | AAPL | Stock | 3.6486 | 3.6675 | 3.6464 | 3.6675 | 86800.0 |
| 2008-10-17 07:30:00 | AAPL | Stock | 3.6668 | 3.6668 | 3.6668 | 3.6668 | 5600.0 |
| 2008-10-17 07:32:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 4200.0 |
| 2008-10-17 07:34:00 | AAPL | Stock | 3.6668 | 3.6668 | 3.6668 | 3.6668 | 5600.0 |
| 2008-10-17 07:36:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 2800.0 |
| 2008-10-17 07:40:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.665 | 3.665 | 5600.0 |
| 2008-10-17 07:41:00 | AAPL | Stock | 3.6618 | 3.6618 | 3.6607 | 3.6607 | 8400.0 |
| 2008-10-17 07:43:00 | AAPL | Stock | 3.6607 | 3.6607 | 3.6607 | 3.6607 | 8400.0 |
| 2008-10-17 07:44:00 | AAPL | Stock | 3.6604 | 3.6604 | 3.6604 | 3.6604 | 5572.0 |
| 2008-10-17 07:47:00 | AAPL | Stock | 3.6464 | 3.6464 | 3.6464 | 3.6464 | 2800.0 |
| 2008-10-17 07:49:00 | AAPL | Stock | 3.6471 | 3.6471 | 3.6464 | 3.6464 | 44800.0 |
| 2008-10-17 07:55:00 | AAPL | Stock | 3.6593 | 3.6614 | 3.6593 | 3.6614 | 23800.0 |
| 2008-10-17 07:56:00 | AAPL | Stock | 3.6743 | 3.6789 | 3.6743 | 3.6786 | 88200.0 |
| 2008-10-17 07:57:00 | AAPL | Stock | 3.6786 | 3.6786 | 3.6786 | 3.6786 | 16800.0 |
| 2008-10-17 07:58:00 | AAPL | Stock | 3.6721 | 3.6721 | 3.6721 | 3.6721 | 2800.0 |
| 2008-10-17 08:00:00 | AAPL | Stock | 3.6879 | 3.7032 | 3.6786 | 3.6864 | 320740.0 |
| 2008-10-17 08:01:00 | AAPL | Stock | 3.6868 | 3.6918 | 3.6786 | 3.6871 | 86996.0 |
| 2008-10-17 08:02:00 | AAPL | Stock | 3.6839 | 3.6839 | 3.6746 | 3.6746 | 49028.0 |
| 2008-10-17 08:03:00 | AAPL | Stock | 3.6679 | 3.6911 | 3.6679 | 3.6857 | 105000.0 |
| 2008-10-17 08:04:00 | AAPL | Stock | 3.6907 | 3.6996 | 3.6907 | 3.6964 | 140980.0 |
| 2008-10-17 08:05:00 | AAPL | Stock | 3.6964 | 3.7143 | 3.6864 | 3.7143 | 236124.0 |
| 2008-10-17 08:06:00 | AAPL | Stock | 3.7143 | 3.7268 | 3.7143 | 3.725 | 150920.0 |
| 2008-10-17 08:07:00 | AAPL | Stock | 3.725 | 3.7268 | 3.7196 | 3.7196 | 99540.0 |
| 2008-10-17 08:08:00 | AAPL | Stock | 3.7182 | 3.72 | 3.7146 | 3.7146 | 77840.0 |
| 2008-10-17 08:09:00 | AAPL | Stock | 3.7157 | 3.7157 | 3.7157 | 3.7157 | 11200.0 |
| 2008-10-17 08:10:00 | AAPL | Stock | 3.7011 | 3.7021 | 3.6964 | 3.6968 | 78288.0 |
| 2008-10-17 08:11:00 | AAPL | Stock | 3.6968 | 3.6996 | 3.6925 | 3.6929 | 18732.0 |
| 2008-10-17 08:12:00 | AAPL | Stock | 3.69 | 3.69 | 3.6786 | 3.6807 | 107800.0 |
| 2008-10-17 08:13:00 | AAPL | Stock | 3.675 | 3.68 | 3.675 | 3.6786 | 72800.0 |
| 2008-10-17 08:14:00 | AAPL | Stock | 3.6775 | 3.6775 | 3.6689 | 3.6768 | 84028.0 |
| 2008-10-17 08:15:00 | AAPL | Stock | 3.6768 | 3.6768 | 3.6746 | 3.6746 | 23492.0 |
| 2008-10-17 08:16:00 | AAPL | Stock | 3.6768 | 3.6789 | 3.6768 | 3.6789 | 166404.0 |
| 2008-10-17 08:17:00 | AAPL | Stock | 3.6868 | 3.6875 | 3.6714 | 3.6714 | 133700.0 |
| 2008-10-17 08:18:00 | AAPL | Stock | 3.6714 | 3.6761 | 3.6714 | 3.6761 | 8400.0 |
| 2008-10-17 08:19:00 | AAPL | Stock | 3.6718 | 3.6775 | 3.6718 | 3.675 | 22400.0 |
| 2008-10-17 08:20:00 | AAPL | Stock | 3.675 | 3.675 | 3.6696 | 3.6696 | 53900.0 |
| 2008-10-17 08:21:00 | AAPL | Stock | 3.6664 | 3.6664 | 3.6629 | 3.6629 | 30436.0 |
| 2008-10-17 08:22:00 | AAPL | Stock | 3.6679 | 3.6679 | 3.6529 | 3.6529 | 152600.0 |
| 2008-10-17 08:23:00 | AAPL | Stock | 3.6579 | 3.6604 | 3.6386 | 3.6536 | 98532.0 |
| 2008-10-17 08:24:00 | AAPL | Stock | 3.6514 | 3.6518 | 3.6393 | 3.6443 | 166292.0 |
| 2008-10-17 08:25:00 | AAPL | Stock | 3.6443 | 3.6571 | 3.6443 | 3.6518 | 83160.0 |
| 2008-10-17 08:26:00 | AAPL | Stock | 3.6568 | 3.6629 | 3.6568 | 3.6629 | 11200.0 |
| 2008-10-17 08:27:00 | AAPL | Stock | 3.6571 | 3.6596 | 3.6554 | 3.6554 | 12600.0 |
> showing 50 of 1,053,217 rows — these rows as CSV