PREVIEW / stock_1min / 2008-01-31
file: by_date/stock_1min/2008/2008-01-31.parquet size: 13.4 MB rows: 1,064,659 symbols: 2,672
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 |
|---|---|---|---|---|---|---|---|
| 2008-01-31 05:07:00 | AAPL | Stock | 4.6489 | 4.6489 | 4.6489 | 4.6489 | 3248.0 |
| 2008-01-31 07:29:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 8400.0 |
| 2008-01-31 07:34:00 | AAPL | Stock | 4.6857 | 4.6857 | 4.6786 | 4.6786 | 5600.0 |
| 2008-01-31 07:36:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 2800.0 |
| 2008-01-31 07:37:00 | AAPL | Stock | 4.6786 | 4.6786 | 4.6786 | 4.6786 | 5600.0 |
| 2008-01-31 07:40:00 | AAPL | Stock | 4.6786 | 4.6946 | 4.6786 | 4.6946 | 11200.0 |
| 2008-01-31 07:53:00 | AAPL | Stock | 4.6904 | 4.6904 | 4.6904 | 4.6904 | 2800.0 |
| 2008-01-31 08:00:00 | AAPL | Stock | 4.685 | 4.7054 | 4.675 | 4.6782 | 161784.0 |
| 2008-01-31 08:01:00 | AAPL | Stock | 4.6761 | 4.6761 | 4.6754 | 4.6754 | 5600.0 |
| 2008-01-31 08:03:00 | AAPL | Stock | 4.6771 | 4.6771 | 4.6771 | 4.6771 | 2800.0 |
| 2008-01-31 08:04:00 | AAPL | Stock | 4.6786 | 4.6821 | 4.6757 | 4.6821 | 61992.0 |
| 2008-01-31 08:05:00 | AAPL | Stock | 4.6807 | 4.6807 | 4.6793 | 4.6793 | 11200.0 |
| 2008-01-31 08:06:00 | AAPL | Stock | 4.6836 | 4.6857 | 4.6793 | 4.6857 | 54320.0 |
| 2008-01-31 08:07:00 | AAPL | Stock | 4.6864 | 4.6875 | 4.6786 | 4.6868 | 73556.0 |
| 2008-01-31 08:08:00 | AAPL | Stock | 4.6918 | 4.6918 | 4.6854 | 4.6875 | 41692.0 |
| 2008-01-31 08:11:00 | AAPL | Stock | 4.6868 | 4.6868 | 4.6868 | 4.6868 | 2800.0 |
| 2008-01-31 08:12:00 | AAPL | Stock | 4.6896 | 4.6911 | 4.6875 | 4.6875 | 28000.0 |
| 2008-01-31 08:14:00 | AAPL | Stock | 4.6907 | 4.6907 | 4.6893 | 4.6904 | 11200.0 |
| 2008-01-31 08:15:00 | AAPL | Stock | 4.6893 | 4.7054 | 4.6893 | 4.7054 | 41636.0 |
| 2008-01-31 08:16:00 | AAPL | Stock | 4.7054 | 4.7143 | 4.7046 | 4.7143 | 71960.0 |
| 2008-01-31 08:17:00 | AAPL | Stock | 4.7139 | 4.7143 | 4.71 | 4.71 | 31808.0 |
| 2008-01-31 08:18:00 | AAPL | Stock | 4.7079 | 4.7093 | 4.7071 | 4.7093 | 44800.0 |
| 2008-01-31 08:19:00 | AAPL | Stock | 4.7071 | 4.7071 | 4.7071 | 4.7071 | 7000.0 |
| 2008-01-31 08:20:00 | AAPL | Stock | 4.7071 | 4.7071 | 4.7 | 4.7 | 14420.0 |
| 2008-01-31 08:21:00 | AAPL | Stock | 4.7036 | 4.7036 | 4.7 | 4.7 | 14000.0 |
| 2008-01-31 08:22:00 | AAPL | Stock | 4.7 | 4.7 | 4.7 | 4.7 | 28000.0 |
| 2008-01-31 08:25:00 | AAPL | Stock | 4.7018 | 4.7089 | 4.7018 | 4.7089 | 19600.0 |
| 2008-01-31 08:26:00 | AAPL | Stock | 4.7071 | 4.7086 | 4.7071 | 4.7071 | 8400.0 |
| 2008-01-31 08:27:00 | AAPL | Stock | 4.7039 | 4.7039 | 4.7014 | 4.7036 | 27216.0 |
| 2008-01-31 08:28:00 | AAPL | Stock | 4.6968 | 4.6989 | 4.6964 | 4.6982 | 22400.0 |
| 2008-01-31 08:29:00 | AAPL | Stock | 4.695 | 4.7 | 4.6946 | 4.7 | 74620.0 |
| 2008-01-31 08:30:00 | AAPL | Stock | 4.6982 | 4.6982 | 4.6818 | 4.6868 | 233912.0 |
| 2008-01-31 08:31:00 | AAPL | Stock | 4.6929 | 4.6929 | 4.6857 | 4.6864 | 105840.0 |
| 2008-01-31 08:32:00 | AAPL | Stock | 4.6829 | 4.6832 | 4.6746 | 4.6754 | 110292.0 |
| 2008-01-31 08:33:00 | AAPL | Stock | 4.6786 | 4.6789 | 4.675 | 4.675 | 73192.0 |
| 2008-01-31 08:34:00 | AAPL | Stock | 4.675 | 4.675 | 4.6661 | 4.6661 | 112672.0 |
| 2008-01-31 08:35:00 | AAPL | Stock | 4.6714 | 4.6718 | 4.6636 | 4.6679 | 150640.0 |
| 2008-01-31 08:36:00 | AAPL | Stock | 4.6661 | 4.6661 | 4.6557 | 4.6557 | 97244.0 |
| 2008-01-31 08:37:00 | AAPL | Stock | 4.6554 | 4.6568 | 4.6504 | 4.6532 | 115556.0 |
| 2008-01-31 08:38:00 | AAPL | Stock | 4.6532 | 4.6607 | 4.6518 | 4.6575 | 102676.0 |
| 2008-01-31 08:39:00 | AAPL | Stock | 4.6579 | 4.6607 | 4.65 | 4.6607 | 173180.0 |
| 2008-01-31 08:40:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.66 | 4.6607 | 160916.0 |
| 2008-01-31 08:41:00 | AAPL | Stock | 4.6611 | 4.6661 | 4.6607 | 4.6607 | 112840.0 |
| 2008-01-31 08:42:00 | AAPL | Stock | 4.6607 | 4.6607 | 4.6607 | 4.6607 | 89600.0 |
| 2008-01-31 08:43:00 | AAPL | Stock | 4.6643 | 4.6643 | 4.6586 | 4.6625 | 78400.0 |
| 2008-01-31 08:44:00 | AAPL | Stock | 4.6625 | 4.6625 | 4.6611 | 4.6611 | 5600.0 |
| 2008-01-31 08:45:00 | AAPL | Stock | 4.6632 | 4.6704 | 4.6632 | 4.6646 | 90300.0 |
| 2008-01-31 08:46:00 | AAPL | Stock | 4.6646 | 4.6646 | 4.6621 | 4.6625 | 178500.0 |
| 2008-01-31 08:47:00 | AAPL | Stock | 4.6625 | 4.6625 | 4.6625 | 4.6625 | 8400.0 |
| 2008-01-31 08:48:00 | AAPL | Stock | 4.6607 | 4.6618 | 4.6582 | 4.6582 | 137200.0 |
> showing 50 of 1,064,659 rows — these rows as CSV