PREVIEW / stock_1min / 2007-07-25
file: by_date/stock_1min/2007/2007-07-25.parquet size: 12.5 MB rows: 1,012,392 symbols: 2,533
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-07-25 09:30:00 | AAPL | Stock | 4.9054 | 4.9084 | 4.8839 | 4.8929 | 9623712.0 |
| 2007-07-25 09:31:00 | AAPL | Stock | 4.8929 | 4.9064 | 4.8871 | 4.8908 | 7740320.0 |
| 2007-07-25 09:32:00 | AAPL | Stock | 4.8911 | 4.8921 | 4.8696 | 4.8696 | 7441644.0 |
| 2007-07-25 09:33:00 | AAPL | Stock | 4.8689 | 4.8921 | 4.8679 | 4.8871 | 6891584.0 |
| 2007-07-25 09:34:00 | AAPL | Stock | 4.8871 | 4.8932 | 4.8679 | 4.8907 | 7218652.0 |
| 2007-07-25 09:35:00 | AAPL | Stock | 4.8907 | 4.8929 | 4.875 | 4.875 | 5196408.0 |
| 2007-07-25 09:36:00 | AAPL | Stock | 4.875 | 4.8786 | 4.8618 | 4.8629 | 7578928.0 |
| 2007-07-25 09:37:00 | AAPL | Stock | 4.8621 | 4.87 | 4.8593 | 4.8654 | 6949544.0 |
| 2007-07-25 09:38:00 | AAPL | Stock | 4.8657 | 4.8761 | 4.8639 | 4.8725 | 4730320.0 |
| 2007-07-25 09:39:00 | AAPL | Stock | 4.8725 | 4.8814 | 4.8675 | 4.8711 | 4409636.0 |
| 2007-07-25 09:40:00 | AAPL | Stock | 4.8707 | 4.8714 | 4.85 | 4.8568 | 6782160.0 |
| 2007-07-25 09:41:00 | AAPL | Stock | 4.8561 | 4.8711 | 4.855 | 4.8693 | 5222756.0 |
| 2007-07-25 09:42:00 | AAPL | Stock | 4.87 | 4.8729 | 4.8521 | 4.8539 | 4370548.0 |
| 2007-07-25 09:43:00 | AAPL | Stock | 4.8536 | 4.8542 | 4.8254 | 4.8275 | 9104704.0 |
| 2007-07-25 09:44:00 | AAPL | Stock | 4.8286 | 4.8436 | 4.8254 | 4.8357 | 5855164.0 |
| 2007-07-25 09:45:00 | AAPL | Stock | 4.8354 | 4.8386 | 4.8271 | 4.8311 | 4806536.0 |
| 2007-07-25 09:46:00 | AAPL | Stock | 4.8296 | 4.8565 | 4.8214 | 4.8561 | 9921492.0 |
| 2007-07-25 09:47:00 | AAPL | Stock | 4.8564 | 4.8571 | 4.8286 | 4.8521 | 6333376.0 |
| 2007-07-25 09:48:00 | AAPL | Stock | 4.8521 | 4.8789 | 4.8514 | 4.8775 | 7463512.0 |
| 2007-07-25 09:49:00 | AAPL | Stock | 4.8775 | 4.8929 | 4.8711 | 4.8929 | 10765244.0 |
| 2007-07-25 09:50:00 | AAPL | Stock | 4.8929 | 4.8993 | 4.885 | 4.8871 | 8116668.0 |
| 2007-07-25 09:51:00 | AAPL | Stock | 4.8871 | 4.8882 | 4.8786 | 4.882 | 5610528.0 |
| 2007-07-25 09:52:00 | AAPL | Stock | 4.8814 | 4.905 | 4.8811 | 4.8971 | 7372400.0 |
| 2007-07-25 09:53:00 | AAPL | Stock | 4.8982 | 4.905 | 4.8871 | 4.8871 | 5529272.0 |
| 2007-07-25 09:54:00 | AAPL | Stock | 4.8871 | 4.8929 | 4.8832 | 4.8861 | 3774848.0 |
| 2007-07-25 09:55:00 | AAPL | Stock | 4.8868 | 4.8871 | 4.8807 | 4.8846 | 3132164.0 |
| 2007-07-25 09:56:00 | AAPL | Stock | 4.8834 | 4.8846 | 4.8764 | 4.8786 | 3755976.0 |
| 2007-07-25 09:57:00 | AAPL | Stock | 4.8775 | 4.8786 | 4.8721 | 4.8779 | 3667972.0 |
| 2007-07-25 09:58:00 | AAPL | Stock | 4.8782 | 4.8786 | 4.8661 | 4.8661 | 3037468.0 |
| 2007-07-25 09:59:00 | AAPL | Stock | 4.8675 | 4.875 | 4.8661 | 4.8746 | 3298652.0 |
| 2007-07-25 10:00:00 | AAPL | Stock | 4.8746 | 4.875 | 4.8686 | 4.8712 | 3410568.0 |
| 2007-07-25 10:01:00 | AAPL | Stock | 4.8707 | 4.8889 | 4.8704 | 4.8871 | 4821012.0 |
| 2007-07-25 10:02:00 | AAPL | Stock | 4.8871 | 4.8889 | 4.8721 | 4.8725 | 3817324.0 |
| 2007-07-25 10:03:00 | AAPL | Stock | 4.8718 | 4.8839 | 4.8711 | 4.8746 | 3526740.0 |
| 2007-07-25 10:04:00 | AAPL | Stock | 4.8743 | 4.8754 | 4.8696 | 4.8707 | 3967908.0 |
| 2007-07-25 10:05:00 | AAPL | Stock | 4.8707 | 4.8714 | 4.8621 | 4.8636 | 7146272.0 |
| 2007-07-25 10:06:00 | AAPL | Stock | 4.8636 | 4.8843 | 4.8632 | 4.8807 | 4421032.0 |
| 2007-07-25 10:07:00 | AAPL | Stock | 4.8836 | 4.8914 | 4.8779 | 4.885 | 3590132.0 |
| 2007-07-25 10:08:00 | AAPL | Stock | 4.8839 | 4.8911 | 4.8839 | 4.8864 | 3055752.0 |
| 2007-07-25 10:09:00 | AAPL | Stock | 4.8882 | 4.8882 | 4.8786 | 4.8796 | 2347604.0 |
| 2007-07-25 10:10:00 | AAPL | Stock | 4.8793 | 4.8821 | 4.8725 | 4.8729 | 2212952.0 |
| 2007-07-25 10:11:00 | AAPL | Stock | 4.8743 | 4.8761 | 4.8731 | 4.875 | 2066372.0 |
| 2007-07-25 10:12:00 | AAPL | Stock | 4.875 | 4.88 | 4.8746 | 4.8786 | 2168236.0 |
| 2007-07-25 10:13:00 | AAPL | Stock | 4.8789 | 4.8821 | 4.8761 | 4.8761 | 1805104.0 |
| 2007-07-25 10:14:00 | AAPL | Stock | 4.875 | 4.8796 | 4.87 | 4.8729 | 3327352.0 |
| 2007-07-25 10:15:00 | AAPL | Stock | 4.8724 | 4.8821 | 4.8718 | 4.8775 | 3583328.0 |
| 2007-07-25 10:16:00 | AAPL | Stock | 4.8782 | 4.9054 | 4.875 | 4.9054 | 8757896.0 |
| 2007-07-25 10:17:00 | AAPL | Stock | 4.9046 | 4.9064 | 4.8875 | 4.8904 | 5306588.0 |
| 2007-07-25 10:18:00 | AAPL | Stock | 4.8907 | 4.9068 | 4.8818 | 4.9039 | 5005672.0 |
| 2007-07-25 10:19:00 | AAPL | Stock | 4.9018 | 4.9182 | 4.9014 | 4.9161 | 7112084.0 |
> showing 50 of 1,012,392 rows — these rows as CSV