PREVIEW / stock_1min / 2007-10-24
file: by_date/stock_1min/2007/2007-10-24.parquet size: 12.4 MB rows: 998,689 symbols: 2,586
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 |
|---|---|---|---|---|---|---|---|
| 2007-10-24 05:13:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 14000.0 |
| 2007-10-24 05:44:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 2800.0 |
| 2007-10-24 05:50:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 11200.0 |
| 2007-10-24 05:51:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 5600.0 |
| 2007-10-24 05:52:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5954 | 6.5954 | 16800.0 |
| 2007-10-24 05:54:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 5600.0 |
| 2007-10-24 06:04:00 | AAPL | Stock | 6.5982 | 6.5982 | 6.5982 | 6.5982 | 10640.0 |
| 2007-10-24 06:11:00 | AAPL | Stock | 6.5961 | 6.5982 | 6.5961 | 6.5982 | 58800.0 |
| 2007-10-24 06:12:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 15064.0 |
| 2007-10-24 06:23:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 7560.0 |
| 2007-10-24 06:28:00 | AAPL | Stock | 6.5964 | 6.5964 | 6.5964 | 6.5964 | 2800.0 |
| 2007-10-24 06:33:00 | AAPL | Stock | 6.5825 | 6.5825 | 6.5825 | 6.5825 | 5600.0 |
| 2007-10-24 06:46:00 | AAPL | Stock | 6.5961 | 6.5961 | 6.5961 | 6.5961 | 14000.0 |
| 2007-10-24 06:47:00 | AAPL | Stock | 6.5961 | 6.5964 | 6.5961 | 6.5964 | 47376.0 |
| 2007-10-24 06:50:00 | AAPL | Stock | 6.5854 | 6.5854 | 6.5854 | 6.5854 | 8400.0 |
| 2007-10-24 07:04:00 | AAPL | Stock | 6.6018 | 6.6018 | 6.6018 | 6.6018 | 5600.0 |
| 2007-10-24 07:05:00 | AAPL | Stock | 6.6004 | 6.6004 | 6.5857 | 6.5857 | 5600.0 |
| 2007-10-24 07:06:00 | AAPL | Stock | 6.5843 | 6.5843 | 6.5786 | 6.5786 | 29400.0 |
| 2007-10-24 07:07:00 | AAPL | Stock | 6.5807 | 6.5807 | 6.5807 | 6.5807 | 10836.0 |
| 2007-10-24 07:09:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5807 | 6.5807 | 18564.0 |
| 2007-10-24 07:10:00 | AAPL | Stock | 6.5786 | 6.5786 | 6.5786 | 6.5786 | 4620.0 |
| 2007-10-24 07:11:00 | AAPL | Stock | 6.5757 | 6.5757 | 6.5757 | 6.5757 | 5600.0 |
| 2007-10-24 07:13:00 | AAPL | Stock | 6.5771 | 6.5771 | 6.5771 | 6.5771 | 22400.0 |
| 2007-10-24 07:17:00 | AAPL | Stock | 6.5743 | 6.5743 | 6.5743 | 6.5743 | 2800.0 |
| 2007-10-24 07:18:00 | AAPL | Stock | 6.5771 | 6.5771 | 6.5771 | 6.5771 | 4200.0 |
| 2007-10-24 07:20:00 | AAPL | Stock | 6.5746 | 6.5746 | 6.5739 | 6.5739 | 48580.0 |
| 2007-10-24 07:26:00 | AAPL | Stock | 6.5729 | 6.5729 | 6.5721 | 6.5721 | 16800.0 |
| 2007-10-24 07:28:00 | AAPL | Stock | 6.5768 | 6.5768 | 6.5768 | 6.5768 | 7616.0 |
| 2007-10-24 07:30:00 | AAPL | Stock | 6.5807 | 6.5807 | 6.5807 | 6.5807 | 2800.0 |
| 2007-10-24 07:31:00 | AAPL | Stock | 6.5807 | 6.5821 | 6.5807 | 6.5821 | 21476.0 |
| 2007-10-24 07:38:00 | AAPL | Stock | 6.5768 | 6.5821 | 6.5768 | 6.5821 | 37184.0 |
| 2007-10-24 07:41:00 | AAPL | Stock | 6.5721 | 6.5721 | 6.5721 | 6.5721 | 5600.0 |
| 2007-10-24 07:44:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 11200.0 |
| 2007-10-24 07:47:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 11956.0 |
| 2007-10-24 07:50:00 | AAPL | Stock | 6.5821 | 6.5857 | 6.5821 | 6.5857 | 19600.0 |
| 2007-10-24 07:51:00 | AAPL | Stock | 6.5893 | 6.5907 | 6.5893 | 6.5907 | 66360.0 |
| 2007-10-24 07:53:00 | AAPL | Stock | 6.5875 | 6.5875 | 6.5875 | 6.5875 | 14000.0 |
| 2007-10-24 07:54:00 | AAPL | Stock | 6.5846 | 6.5846 | 6.5821 | 6.5821 | 16800.0 |
| 2007-10-24 07:58:00 | AAPL | Stock | 6.5857 | 6.5857 | 6.5857 | 6.5857 | 2800.0 |
| 2007-10-24 08:00:00 | AAPL | Stock | 6.5893 | 6.5893 | 6.5714 | 6.5889 | 265860.0 |
| 2007-10-24 08:01:00 | AAPL | Stock | 6.5889 | 6.5893 | 6.5864 | 6.5864 | 12096.0 |
| 2007-10-24 08:02:00 | AAPL | Stock | 6.5843 | 6.5843 | 6.5811 | 6.5811 | 102760.0 |
| 2007-10-24 08:03:00 | AAPL | Stock | 6.5821 | 6.5832 | 6.58 | 6.5821 | 31612.0 |
| 2007-10-24 08:04:00 | AAPL | Stock | 6.5821 | 6.5839 | 6.58 | 6.5839 | 91532.0 |
| 2007-10-24 08:05:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5768 | 6.5768 | 34440.0 |
| 2007-10-24 08:06:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5786 | 6.5786 | 14840.0 |
| 2007-10-24 08:07:00 | AAPL | Stock | 6.5814 | 6.5839 | 6.5814 | 6.5821 | 38024.0 |
| 2007-10-24 08:08:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5821 | 6.5821 | 16800.0 |
| 2007-10-24 08:09:00 | AAPL | Stock | 6.5821 | 6.5821 | 6.5764 | 6.5764 | 25200.0 |
| 2007-10-24 08:10:00 | AAPL | Stock | 6.5764 | 6.5804 | 6.5764 | 6.5804 | 21700.0 |
> showing 50 of 998,689 rows — these rows as CSV