PREVIEW / stock_1min / 2010-08-12
file: by_date/stock_1min/2010/2010-08-12.parquet size: 12.7 MB rows: 979,602 symbols: 2,811
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-12 05:18:00 | AAPL | Stock | 8.8161 | 8.8214 | 8.8161 | 8.8214 | 28000.0 |
| 2010-08-12 05:19:00 | AAPL | Stock | 8.8357 | 8.8357 | 8.8193 | 8.8211 | 42000.0 |
| 2010-08-12 06:05:00 | AAPL | Stock | 8.8375 | 8.8375 | 8.8143 | 8.8143 | 5600.0 |
| 2010-08-12 06:13:00 | AAPL | Stock | 8.8393 | 8.8393 | 8.8393 | 8.8393 | 5600.0 |
| 2010-08-12 06:14:00 | AAPL | Stock | 8.8393 | 8.8393 | 8.8393 | 8.8393 | 2800.0 |
| 2010-08-12 06:24:00 | AAPL | Stock | 8.8179 | 8.8179 | 8.8179 | 8.8179 | 3640.0 |
| 2010-08-12 06:30:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 2884.0 |
| 2010-08-12 06:37:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 3640.0 |
| 2010-08-12 06:41:00 | AAPL | Stock | 8.8411 | 8.8411 | 8.8411 | 8.8411 | 8344.0 |
| 2010-08-12 06:48:00 | AAPL | Stock | 8.8464 | 8.8464 | 8.8464 | 8.8464 | 3500.0 |
| 2010-08-12 06:50:00 | AAPL | Stock | 8.8571 | 8.8571 | 8.8571 | 8.8571 | 25200.0 |
| 2010-08-12 06:53:00 | AAPL | Stock | 8.8521 | 8.8521 | 8.8521 | 8.8521 | 8512.0 |
| 2010-08-12 06:55:00 | AAPL | Stock | 8.8879 | 8.8879 | 8.8879 | 8.8879 | 5600.0 |
| 2010-08-12 06:56:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 2800.0 |
| 2010-08-12 06:57:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8714 | 8.8714 | 3780.0 |
| 2010-08-12 06:59:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8732 | 8.8732 | 2800.0 |
| 2010-08-12 07:02:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.8714 | 8.8714 | 25032.0 |
| 2010-08-12 07:09:00 | AAPL | Stock | 8.8721 | 8.8768 | 8.8721 | 8.8768 | 27188.0 |
| 2010-08-12 07:14:00 | AAPL | Stock | 8.8843 | 8.8843 | 8.8843 | 8.8843 | 5600.0 |
| 2010-08-12 07:18:00 | AAPL | Stock | 8.8875 | 8.8875 | 8.8875 | 8.8875 | 8400.0 |
| 2010-08-12 07:19:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 27300.0 |
| 2010-08-12 07:20:00 | AAPL | Stock | 8.8929 | 8.8929 | 8.8929 | 8.8929 | 14000.0 |
| 2010-08-12 07:25:00 | AAPL | Stock | 8.8893 | 8.8893 | 8.8893 | 8.8893 | 2800.0 |
| 2010-08-12 07:27:00 | AAPL | Stock | 8.8807 | 8.8807 | 8.8804 | 8.8804 | 11200.0 |
| 2010-08-12 07:28:00 | AAPL | Stock | 8.8857 | 8.8875 | 8.8732 | 8.8732 | 8400.0 |
| 2010-08-12 07:31:00 | AAPL | Stock | 8.8732 | 8.8732 | 8.865 | 8.865 | 17556.0 |
| 2010-08-12 07:32:00 | AAPL | Stock | 8.8814 | 8.8814 | 8.8814 | 8.8814 | 2800.0 |
| 2010-08-12 07:44:00 | AAPL | Stock | 8.8679 | 8.8679 | 8.8679 | 8.8679 | 16800.0 |
| 2010-08-12 07:45:00 | AAPL | Stock | 8.875 | 8.875 | 8.875 | 8.875 | 2800.0 |
| 2010-08-12 07:55:00 | AAPL | Stock | 8.8575 | 8.8575 | 8.8575 | 8.8575 | 2800.0 |
| 2010-08-12 07:56:00 | AAPL | Stock | 8.8571 | 8.8643 | 8.8571 | 8.8643 | 7336.0 |
| 2010-08-12 07:57:00 | AAPL | Stock | 8.8643 | 8.8643 | 8.8643 | 8.8643 | 2800.0 |
| 2010-08-12 08:00:00 | AAPL | Stock | 8.8661 | 8.875 | 8.8571 | 8.875 | 110544.0 |
| 2010-08-12 08:01:00 | AAPL | Stock | 8.8696 | 8.8743 | 8.8614 | 8.8614 | 37240.0 |
| 2010-08-12 08:03:00 | AAPL | Stock | 8.8704 | 8.8746 | 8.8704 | 8.8746 | 28000.0 |
| 2010-08-12 08:04:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8696 | 8.8696 | 28000.0 |
| 2010-08-12 08:05:00 | AAPL | Stock | 8.8714 | 8.8714 | 8.8693 | 8.8693 | 5600.0 |
| 2010-08-12 08:06:00 | AAPL | Stock | 8.8746 | 8.8775 | 8.8746 | 8.8775 | 24136.0 |
| 2010-08-12 08:07:00 | AAPL | Stock | 8.8739 | 8.875 | 8.8729 | 8.875 | 23016.0 |
| 2010-08-12 08:08:00 | AAPL | Stock | 8.8746 | 8.8746 | 8.8743 | 8.8743 | 11200.0 |
| 2010-08-12 08:09:00 | AAPL | Stock | 8.8786 | 8.8929 | 8.8764 | 8.8764 | 196392.0 |
| 2010-08-12 08:10:00 | AAPL | Stock | 8.8782 | 8.8843 | 8.875 | 8.8843 | 96768.0 |
| 2010-08-12 08:11:00 | AAPL | Stock | 8.8804 | 8.8836 | 8.8804 | 8.8825 | 19600.0 |
| 2010-08-12 08:12:00 | AAPL | Stock | 8.8836 | 8.8836 | 8.88 | 8.88 | 29400.0 |
| 2010-08-12 08:13:00 | AAPL | Stock | 8.8871 | 8.8871 | 8.8789 | 8.8789 | 60200.0 |
| 2010-08-12 08:14:00 | AAPL | Stock | 8.8818 | 8.8836 | 8.88 | 8.88 | 127120.0 |
| 2010-08-12 08:15:00 | AAPL | Stock | 8.8821 | 8.8825 | 8.8786 | 8.8793 | 48692.0 |
| 2010-08-12 08:16:00 | AAPL | Stock | 8.8818 | 8.8868 | 8.8818 | 8.8846 | 37800.0 |
| 2010-08-12 08:17:00 | AAPL | Stock | 8.8846 | 8.8846 | 8.8743 | 8.875 | 147308.0 |
| 2010-08-12 08:18:00 | AAPL | Stock | 8.8786 | 8.8786 | 8.8779 | 8.8786 | 60760.0 |
> showing 50 of 979,602 rows — these rows as CSV