PREVIEW / stock_1min / 2005-12-16
file: by_date/stock_1min/2005/2005-12-16.parquet size: 7.6 MB rows: 618,663 symbols: 1,764
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-12-16 05:33:00 | AAPL | Stock | 2.575 | 2.575 | 2.575 | 2.575 | 10500.0 |
| 2005-12-16 08:00:00 | AAPL | Stock | 2.5929 | 2.5929 | 2.5793 | 2.5921 | 14980.0 |
| 2005-12-16 08:08:00 | AAPL | Stock | 2.5807 | 2.5832 | 2.5804 | 2.5832 | 44240.0 |
| 2005-12-16 08:09:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5832 | 2.5832 | 2800.0 |
| 2005-12-16 08:11:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5832 | 2.5832 | 32760.0 |
| 2005-12-16 08:12:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5807 | 2.5807 | 42000.0 |
| 2005-12-16 08:13:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5832 | 2.5832 | 2800.0 |
| 2005-12-16 08:17:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 2800.0 |
| 2005-12-16 08:20:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5832 | 2.5832 | 14000.0 |
| 2005-12-16 08:21:00 | AAPL | Stock | 2.5832 | 2.5832 | 2.5832 | 2.5832 | 2800.0 |
| 2005-12-16 08:24:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 5600.0 |
| 2005-12-16 08:27:00 | AAPL | Stock | 2.5846 | 2.5846 | 2.5846 | 2.5846 | 2800.0 |
| 2005-12-16 08:28:00 | AAPL | Stock | 2.5836 | 2.5836 | 2.5836 | 2.5836 | 14000.0 |
| 2005-12-16 08:29:00 | AAPL | Stock | 2.5846 | 2.5846 | 2.5846 | 2.5846 | 10472.0 |
| 2005-12-16 08:32:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5875 | 2.5875 | 3780.0 |
| 2005-12-16 08:35:00 | AAPL | Stock | 2.5871 | 2.5875 | 2.5871 | 2.5875 | 24220.0 |
| 2005-12-16 08:37:00 | AAPL | Stock | 2.5864 | 2.5864 | 2.5864 | 2.5864 | 2800.0 |
| 2005-12-16 08:41:00 | AAPL | Stock | 2.5861 | 2.5861 | 2.5861 | 2.5861 | 2800.0 |
| 2005-12-16 08:42:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 16800.0 |
| 2005-12-16 08:43:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 2800.0 |
| 2005-12-16 08:47:00 | AAPL | Stock | 2.5843 | 2.5843 | 2.5843 | 2.5843 | 92400.0 |
| 2005-12-16 08:50:00 | AAPL | Stock | 2.5854 | 2.5854 | 2.5854 | 2.5854 | 19600.0 |
| 2005-12-16 08:51:00 | AAPL | Stock | 2.5857 | 2.5875 | 2.5857 | 2.5875 | 28000.0 |
| 2005-12-16 08:53:00 | AAPL | Stock | 2.5857 | 2.5857 | 2.5857 | 2.5857 | 47600.0 |
| 2005-12-16 08:54:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5875 | 2.5875 | 19600.0 |
| 2005-12-16 08:56:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5875 | 2.5875 | 16800.0 |
| 2005-12-16 09:01:00 | AAPL | Stock | 2.5875 | 2.5875 | 2.5875 | 2.5875 | 2800.0 |
| 2005-12-16 09:03:00 | AAPL | Stock | 2.5875 | 2.5879 | 2.5875 | 2.5879 | 25200.0 |
| 2005-12-16 09:04:00 | AAPL | Stock | 2.5882 | 2.5893 | 2.5882 | 2.5889 | 89600.0 |
| 2005-12-16 09:05:00 | AAPL | Stock | 2.5886 | 2.5893 | 2.5886 | 2.5893 | 39004.0 |
| 2005-12-16 09:06:00 | AAPL | Stock | 2.5904 | 2.5904 | 2.5904 | 2.5904 | 2800.0 |
| 2005-12-16 09:07:00 | AAPL | Stock | 2.5911 | 2.5914 | 2.5911 | 2.5911 | 99260.0 |
| 2005-12-16 09:08:00 | AAPL | Stock | 2.5907 | 2.5911 | 2.5907 | 2.5911 | 61600.0 |
| 2005-12-16 09:09:00 | AAPL | Stock | 2.5914 | 2.5914 | 2.5907 | 2.5914 | 86800.0 |
| 2005-12-16 09:10:00 | AAPL | Stock | 2.5914 | 2.5914 | 2.5914 | 2.5914 | 5600.0 |
| 2005-12-16 09:11:00 | AAPL | Stock | 2.5918 | 2.5921 | 2.5918 | 2.5918 | 64400.0 |
| 2005-12-16 09:12:00 | AAPL | Stock | 2.5921 | 2.5925 | 2.5921 | 2.5921 | 22400.0 |
| 2005-12-16 09:13:00 | AAPL | Stock | 2.5921 | 2.5929 | 2.5921 | 2.5929 | 85120.0 |
| 2005-12-16 09:14:00 | AAPL | Stock | 2.5932 | 2.5964 | 2.5929 | 2.5964 | 858200.0 |
| 2005-12-16 09:15:00 | AAPL | Stock | 2.5964 | 2.5982 | 2.5957 | 2.5982 | 143360.0 |
| 2005-12-16 09:16:00 | AAPL | Stock | 2.5979 | 2.5979 | 2.5954 | 2.5964 | 215040.0 |
| 2005-12-16 09:18:00 | AAPL | Stock | 2.5961 | 2.5961 | 2.595 | 2.595 | 14000.0 |
| 2005-12-16 09:20:00 | AAPL | Stock | 2.595 | 2.595 | 2.595 | 2.595 | 6524.0 |
| 2005-12-16 09:22:00 | AAPL | Stock | 2.5939 | 2.5939 | 2.5939 | 2.5939 | 5600.0 |
| 2005-12-16 09:23:00 | AAPL | Stock | 2.5939 | 2.5943 | 2.5929 | 2.5929 | 83440.0 |
| 2005-12-16 09:24:00 | AAPL | Stock | 2.5929 | 2.5929 | 2.5918 | 2.5918 | 67200.0 |
| 2005-12-16 09:25:00 | AAPL | Stock | 2.5914 | 2.5914 | 2.5746 | 2.5746 | 1616692.0 |
| 2005-12-16 09:26:00 | AAPL | Stock | 2.5761 | 2.5836 | 2.5739 | 2.5821 | 734048.0 |
| 2005-12-16 09:27:00 | AAPL | Stock | 2.5804 | 2.5818 | 2.5768 | 2.5782 | 248024.0 |
| 2005-12-16 09:28:00 | AAPL | Stock | 2.5786 | 2.5786 | 2.5768 | 2.5768 | 539084.0 |
> showing 50 of 618,663 rows — these rows as CSV