PREVIEW / stock_1min / 2005-09-21
file: by_date/stock_1min/2005/2005-09-21.parquet size: 7.5 MB rows: 617,849 symbols: 1,694
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 |
|---|---|---|---|---|---|---|---|
| 2005-09-21 08:05:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 25200.0 |
| 2005-09-21 08:06:00 | AAPL | Stock | 1.9004 | 1.9004 | 1.9 | 1.9 | 64400.0 |
| 2005-09-21 08:08:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 56000.0 |
| 2005-09-21 08:11:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 14000.0 |
| 2005-09-21 08:17:00 | AAPL | Stock | 1.9 | 1.9 | 1.8996 | 1.8996 | 8400.0 |
| 2005-09-21 08:19:00 | AAPL | Stock | 1.8996 | 1.9 | 1.8996 | 1.9 | 109200.0 |
| 2005-09-21 08:20:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 5600.0 |
| 2005-09-21 08:24:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 19600.0 |
| 2005-09-21 08:26:00 | AAPL | Stock | 1.9 | 1.9 | 1.9 | 1.9 | 2800.0 |
| 2005-09-21 08:27:00 | AAPL | Stock | 1.8975 | 1.8975 | 1.8975 | 1.8975 | 26600.0 |
| 2005-09-21 08:29:00 | AAPL | Stock | 1.8964 | 1.8964 | 1.8929 | 1.8929 | 140000.0 |
| 2005-09-21 08:30:00 | AAPL | Stock | 1.8975 | 1.8975 | 1.8918 | 1.8929 | 74144.0 |
| 2005-09-21 08:32:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 8400.0 |
| 2005-09-21 08:33:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 44800.0 |
| 2005-09-21 08:34:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 28000.0 |
| 2005-09-21 08:35:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 14000.0 |
| 2005-09-21 08:36:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 28000.0 |
| 2005-09-21 08:37:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 14000.0 |
| 2005-09-21 08:39:00 | AAPL | Stock | 1.8932 | 1.8932 | 1.8929 | 1.8929 | 5600.0 |
| 2005-09-21 08:40:00 | AAPL | Stock | 1.8932 | 1.8932 | 1.8932 | 1.8932 | 2800.0 |
| 2005-09-21 08:42:00 | AAPL | Stock | 1.8946 | 1.8946 | 1.8946 | 1.8946 | 2800.0 |
| 2005-09-21 08:43:00 | AAPL | Stock | 1.8929 | 1.8936 | 1.8929 | 1.8936 | 11200.0 |
| 2005-09-21 08:47:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 2800.0 |
| 2005-09-21 08:48:00 | AAPL | Stock | 1.8929 | 1.8929 | 1.8929 | 1.8929 | 2800.0 |
| 2005-09-21 08:54:00 | AAPL | Stock | 1.8871 | 1.8871 | 1.8871 | 1.8871 | 2800.0 |
| 2005-09-21 08:57:00 | AAPL | Stock | 1.8893 | 1.8911 | 1.8893 | 1.8911 | 9800.0 |
| 2005-09-21 08:58:00 | AAPL | Stock | 1.8911 | 1.8911 | 1.8911 | 1.8911 | 5600.0 |
| 2005-09-21 09:02:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 2800.0 |
| 2005-09-21 09:03:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 2800.0 |
| 2005-09-21 09:05:00 | AAPL | Stock | 1.8879 | 1.8882 | 1.8879 | 1.8882 | 28000.0 |
| 2005-09-21 09:06:00 | AAPL | Stock | 1.8879 | 1.8879 | 1.8879 | 1.8879 | 11200.0 |
| 2005-09-21 09:08:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 5600.0 |
| 2005-09-21 09:09:00 | AAPL | Stock | 1.8904 | 1.8904 | 1.8893 | 1.8893 | 58800.0 |
| 2005-09-21 09:10:00 | AAPL | Stock | 1.8893 | 1.8904 | 1.8893 | 1.8904 | 33600.0 |
| 2005-09-21 09:14:00 | AAPL | Stock | 1.89 | 1.89 | 1.89 | 1.89 | 5600.0 |
| 2005-09-21 09:15:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 31920.0 |
| 2005-09-21 09:18:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 4032.0 |
| 2005-09-21 09:21:00 | AAPL | Stock | 1.8911 | 1.8911 | 1.8911 | 1.8911 | 2800.0 |
| 2005-09-21 09:22:00 | AAPL | Stock | 1.89 | 1.89 | 1.89 | 1.89 | 39200.0 |
| 2005-09-21 09:24:00 | AAPL | Stock | 1.8911 | 1.8911 | 1.8911 | 1.8911 | 2800.0 |
| 2005-09-21 09:25:00 | AAPL | Stock | 1.8943 | 1.8943 | 1.8893 | 1.8893 | 101248.0 |
| 2005-09-21 09:26:00 | AAPL | Stock | 1.8893 | 1.8893 | 1.8893 | 1.8893 | 8400.0 |
| 2005-09-21 09:28:00 | AAPL | Stock | 1.8918 | 1.8918 | 1.8918 | 1.8918 | 5600.0 |
| 2005-09-21 09:29:00 | AAPL | Stock | 1.8921 | 1.8929 | 1.8914 | 1.8925 | 100184.0 |
| 2005-09-21 09:30:00 | AAPL | Stock | 1.8914 | 1.8946 | 1.8839 | 1.8843 | 6970684.0 |
| 2005-09-21 09:31:00 | AAPL | Stock | 1.8843 | 1.89 | 1.8829 | 1.8839 | 3380412.0 |
| 2005-09-21 09:32:00 | AAPL | Stock | 1.8836 | 1.885 | 1.8829 | 1.8836 | 1456476.0 |
| 2005-09-21 09:33:00 | AAPL | Stock | 1.8839 | 1.8843 | 1.8786 | 1.88 | 4692520.0 |
| 2005-09-21 09:34:00 | AAPL | Stock | 1.88 | 1.8825 | 1.8768 | 1.8775 | 2980628.0 |
| 2005-09-21 09:35:00 | AAPL | Stock | 1.8768 | 1.8796 | 1.8711 | 1.875 | 6620068.0 |
> showing 50 of 617,849 rows — these rows as CSV