PREVIEW / stock_1min / 2004-09-22
file: by_date/stock_1min/2004/2004-09-22.parquet size: 5.9 MB rows: 498,178 symbols: 1,501
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 |
|---|---|---|---|---|---|---|---|
| 2004-09-22 08:10:00 | AAPL | Stock | 0.6773 | 0.6816 | 0.6711 | 0.6711 | 50400.0 |
| 2004-09-22 08:36:00 | AAPL | Stock | 0.6796 | 0.6796 | 0.6786 | 0.6786 | 56000.0 |
| 2004-09-22 08:40:00 | AAPL | Stock | 0.6839 | 0.6839 | 0.6834 | 0.6834 | 56000.0 |
| 2004-09-22 09:06:00 | AAPL | Stock | 0.6777 | 0.6777 | 0.6777 | 0.6777 | 11200.0 |
| 2004-09-22 09:11:00 | AAPL | Stock | 0.6779 | 0.6779 | 0.6777 | 0.6777 | 56000.0 |
| 2004-09-22 09:12:00 | AAPL | Stock | 0.6779 | 0.6786 | 0.6779 | 0.6786 | 61600.0 |
| 2004-09-22 09:13:00 | AAPL | Stock | 0.6786 | 0.6786 | 0.6786 | 0.6786 | 11200.0 |
| 2004-09-22 09:14:00 | AAPL | Stock | 0.6786 | 0.6786 | 0.6786 | 0.6786 | 16800.0 |
| 2004-09-22 09:15:00 | AAPL | Stock | 0.6795 | 0.6795 | 0.6795 | 0.6795 | 39200.0 |
| 2004-09-22 09:18:00 | AAPL | Stock | 0.6795 | 0.6795 | 0.6795 | 0.6795 | 56000.0 |
| 2004-09-22 09:20:00 | AAPL | Stock | 0.6816 | 0.6818 | 0.6816 | 0.6818 | 50400.0 |
| 2004-09-22 09:29:00 | AAPL | Stock | 0.6838 | 0.6838 | 0.6805 | 0.6805 | 371392.0 |
| 2004-09-22 09:30:00 | AAPL | Stock | 0.6804 | 0.6805 | 0.6779 | 0.6786 | 4289656.0 |
| 2004-09-22 09:31:00 | AAPL | Stock | 0.6786 | 0.6805 | 0.6782 | 0.6788 | 1607928.0 |
| 2004-09-22 09:32:00 | AAPL | Stock | 0.6784 | 0.6784 | 0.6771 | 0.6779 | 2983960.0 |
| 2004-09-22 09:33:00 | AAPL | Stock | 0.678 | 0.6804 | 0.6777 | 0.6782 | 2171568.0 |
| 2004-09-22 09:34:00 | AAPL | Stock | 0.6786 | 0.6791 | 0.6774 | 0.6786 | 1581160.0 |
| 2004-09-22 09:35:00 | AAPL | Stock | 0.6786 | 0.6795 | 0.6782 | 0.6793 | 2262232.0 |
| 2004-09-22 09:36:00 | AAPL | Stock | 0.6791 | 0.6805 | 0.6786 | 0.6796 | 1678320.0 |
| 2004-09-22 09:37:00 | AAPL | Stock | 0.6796 | 0.6811 | 0.6793 | 0.6811 | 1456280.0 |
| 2004-09-22 09:38:00 | AAPL | Stock | 0.6809 | 0.6811 | 0.6793 | 0.6793 | 2289616.0 |
| 2004-09-22 09:39:00 | AAPL | Stock | 0.6793 | 0.6796 | 0.6786 | 0.6786 | 1148784.0 |
| 2004-09-22 09:40:00 | AAPL | Stock | 0.6788 | 0.6789 | 0.678 | 0.6786 | 1638896.0 |
| 2004-09-22 09:41:00 | AAPL | Stock | 0.6786 | 0.6793 | 0.6777 | 0.678 | 5142256.0 |
| 2004-09-22 09:42:00 | AAPL | Stock | 0.6779 | 0.6784 | 0.6773 | 0.6773 | 1328880.0 |
| 2004-09-22 09:43:00 | AAPL | Stock | 0.6773 | 0.6775 | 0.6763 | 0.6763 | 1183784.0 |
| 2004-09-22 09:44:00 | AAPL | Stock | 0.6763 | 0.6764 | 0.6763 | 0.6764 | 555856.0 |
| 2004-09-22 09:45:00 | AAPL | Stock | 0.6764 | 0.6764 | 0.6752 | 0.6752 | 899640.0 |
| 2004-09-22 09:46:00 | AAPL | Stock | 0.6754 | 0.6754 | 0.6743 | 0.6743 | 1308832.0 |
| 2004-09-22 09:47:00 | AAPL | Stock | 0.6743 | 0.6746 | 0.6734 | 0.6734 | 1219792.0 |
| 2004-09-22 09:48:00 | AAPL | Stock | 0.6736 | 0.675 | 0.6729 | 0.6745 | 1755656.0 |
| 2004-09-22 09:49:00 | AAPL | Stock | 0.6745 | 0.677 | 0.6745 | 0.6763 | 1325576.0 |
| 2004-09-22 09:50:00 | AAPL | Stock | 0.6764 | 0.6766 | 0.6754 | 0.6754 | 823032.0 |
| 2004-09-22 09:51:00 | AAPL | Stock | 0.6754 | 0.6761 | 0.6752 | 0.6755 | 788760.0 |
| 2004-09-22 09:52:00 | AAPL | Stock | 0.6759 | 0.6763 | 0.6754 | 0.6763 | 864696.0 |
| 2004-09-22 09:53:00 | AAPL | Stock | 0.6759 | 0.6764 | 0.6757 | 0.6763 | 1395520.0 |
| 2004-09-22 09:54:00 | AAPL | Stock | 0.6759 | 0.6763 | 0.6748 | 0.6748 | 1422568.0 |
| 2004-09-22 09:55:00 | AAPL | Stock | 0.6752 | 0.6759 | 0.675 | 0.6754 | 585984.0 |
| 2004-09-22 09:56:00 | AAPL | Stock | 0.6754 | 0.6754 | 0.6746 | 0.6746 | 616000.0 |
| 2004-09-22 09:57:00 | AAPL | Stock | 0.6746 | 0.675 | 0.6746 | 0.6748 | 512400.0 |
| 2004-09-22 09:58:00 | AAPL | Stock | 0.6746 | 0.6748 | 0.6743 | 0.6745 | 1355200.0 |
| 2004-09-22 09:59:00 | AAPL | Stock | 0.6745 | 0.6745 | 0.6741 | 0.6741 | 975688.0 |
| 2004-09-22 10:00:00 | AAPL | Stock | 0.6741 | 0.6752 | 0.6739 | 0.6739 | 1009792.0 |
| 2004-09-22 10:01:00 | AAPL | Stock | 0.6739 | 0.6743 | 0.673 | 0.6734 | 1833104.0 |
| 2004-09-22 10:02:00 | AAPL | Stock | 0.6732 | 0.6732 | 0.6718 | 0.6725 | 1917384.0 |
| 2004-09-22 10:03:00 | AAPL | Stock | 0.6725 | 0.6741 | 0.6721 | 0.6725 | 1409184.0 |
| 2004-09-22 10:04:00 | AAPL | Stock | 0.6725 | 0.6725 | 0.6714 | 0.6716 | 1576232.0 |
| 2004-09-22 10:05:00 | AAPL | Stock | 0.6716 | 0.6734 | 0.6707 | 0.6714 | 2185120.0 |
| 2004-09-22 10:06:00 | AAPL | Stock | 0.6714 | 0.6714 | 0.67 | 0.6709 | 1490440.0 |
| 2004-09-22 10:07:00 | AAPL | Stock | 0.6709 | 0.6714 | 0.6704 | 0.6711 | 2322040.0 |
> showing 50 of 498,178 rows — these rows as CSV