PREVIEW / stock_5min / 2005-08-17
file: by_date/stock_5min/2005/2005-08-17.parquet size: 2.7 MB rows: 197,869 symbols: 2,069
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-08-17 08:00:00 | AAPL | Stock | 1.6593 | 1.6593 | 1.6582 | 1.6582 | 40180.0 |
| 2005-08-17 08:05:00 | AAPL | Stock | 1.6679 | 1.6707 | 1.6679 | 1.6707 | 299040.0 |
| 2005-08-17 08:10:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6679 | 1.6679 | 5600.0 |
| 2005-08-17 08:15:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6679 | 1.6679 | 30800.0 |
| 2005-08-17 08:20:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6661 | 1.6661 | 25200.0 |
| 2005-08-17 08:25:00 | AAPL | Stock | 1.6686 | 1.6686 | 1.6661 | 1.6679 | 168000.0 |
| 2005-08-17 08:30:00 | AAPL | Stock | 1.6654 | 1.6654 | 1.6611 | 1.6611 | 207200.0 |
| 2005-08-17 08:35:00 | AAPL | Stock | 1.6611 | 1.6611 | 1.6607 | 1.6611 | 128800.0 |
| 2005-08-17 08:40:00 | AAPL | Stock | 1.6607 | 1.6618 | 1.6607 | 1.6618 | 63280.0 |
| 2005-08-17 08:45:00 | AAPL | Stock | 1.6618 | 1.6618 | 1.6618 | 1.6618 | 42000.0 |
| 2005-08-17 08:50:00 | AAPL | Stock | 1.6618 | 1.6618 | 1.6607 | 1.6607 | 628320.0 |
| 2005-08-17 08:55:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.66 | 1.66 | 84000.0 |
| 2005-08-17 09:00:00 | AAPL | Stock | 1.6607 | 1.6625 | 1.6607 | 1.6607 | 131880.0 |
| 2005-08-17 09:05:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6607 | 1.6607 | 17612.0 |
| 2005-08-17 09:15:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 2800.0 |
| 2005-08-17 09:20:00 | AAPL | Stock | 1.6607 | 1.6607 | 1.6607 | 1.6607 | 8400.0 |
| 2005-08-17 09:25:00 | AAPL | Stock | 1.6611 | 1.665 | 1.6571 | 1.6571 | 448896.0 |
| 2005-08-17 09:30:00 | AAPL | Stock | 1.6571 | 1.6693 | 1.6561 | 1.6693 | 17350452.0 |
| 2005-08-17 09:35:00 | AAPL | Stock | 1.6693 | 1.6757 | 1.6686 | 1.6725 | 15500492.0 |
| 2005-08-17 09:40:00 | AAPL | Stock | 1.6729 | 1.6768 | 1.6693 | 1.675 | 13267324.0 |
| 2005-08-17 09:45:00 | AAPL | Stock | 1.6743 | 1.6811 | 1.6739 | 1.6786 | 12437908.0 |
| 2005-08-17 09:50:00 | AAPL | Stock | 1.6789 | 1.6825 | 1.6775 | 1.6793 | 15795556.0 |
| 2005-08-17 09:55:00 | AAPL | Stock | 1.6796 | 1.6843 | 1.6789 | 1.6832 | 12096112.0 |
| 2005-08-17 10:00:00 | AAPL | Stock | 1.6832 | 1.6875 | 1.6818 | 1.6854 | 16307004.0 |
| 2005-08-17 10:05:00 | AAPL | Stock | 1.6857 | 1.6857 | 1.6793 | 1.6818 | 13098204.0 |
| 2005-08-17 10:10:00 | AAPL | Stock | 1.6814 | 1.6825 | 1.6768 | 1.6771 | 12882492.0 |
| 2005-08-17 10:15:00 | AAPL | Stock | 1.6771 | 1.6854 | 1.6771 | 1.6818 | 13231540.0 |
| 2005-08-17 10:20:00 | AAPL | Stock | 1.6814 | 1.685 | 1.6807 | 1.6843 | 9564016.0 |
| 2005-08-17 10:25:00 | AAPL | Stock | 1.6839 | 1.685 | 1.6811 | 1.6843 | 6687940.0 |
| 2005-08-17 10:30:00 | AAPL | Stock | 1.6843 | 1.6843 | 1.6782 | 1.6821 | 14164780.0 |
| 2005-08-17 10:35:00 | AAPL | Stock | 1.6821 | 1.6825 | 1.68 | 1.6814 | 14266112.0 |
| 2005-08-17 10:40:00 | AAPL | Stock | 1.6814 | 1.6864 | 1.6804 | 1.6829 | 14869596.0 |
| 2005-08-17 10:45:00 | AAPL | Stock | 1.6825 | 1.6854 | 1.6814 | 1.6839 | 7538636.0 |
| 2005-08-17 10:50:00 | AAPL | Stock | 1.6839 | 1.6875 | 1.6818 | 1.6875 | 9785664.0 |
| 2005-08-17 10:55:00 | AAPL | Stock | 1.6875 | 1.6918 | 1.6839 | 1.6896 | 14869372.0 |
| 2005-08-17 11:00:00 | AAPL | Stock | 1.69 | 1.6939 | 1.69 | 1.6904 | 8907192.0 |
| 2005-08-17 11:05:00 | AAPL | Stock | 1.6904 | 1.6914 | 1.6879 | 1.6882 | 4873568.0 |
| 2005-08-17 11:10:00 | AAPL | Stock | 1.6882 | 1.6914 | 1.6879 | 1.69 | 7360976.0 |
| 2005-08-17 11:15:00 | AAPL | Stock | 1.69 | 1.6904 | 1.6875 | 1.6879 | 5529188.0 |
| 2005-08-17 11:20:00 | AAPL | Stock | 1.6879 | 1.6921 | 1.6879 | 1.6904 | 12031768.0 |
| 2005-08-17 11:25:00 | AAPL | Stock | 1.6904 | 1.6943 | 1.6889 | 1.6896 | 6519184.0 |
| 2005-08-17 11:30:00 | AAPL | Stock | 1.6893 | 1.6907 | 1.6889 | 1.6889 | 3597636.0 |
| 2005-08-17 11:35:00 | AAPL | Stock | 1.6893 | 1.6896 | 1.6843 | 1.6861 | 9086308.0 |
| 2005-08-17 11:40:00 | AAPL | Stock | 1.6857 | 1.6864 | 1.6829 | 1.6829 | 4215344.0 |
| 2005-08-17 11:45:00 | AAPL | Stock | 1.6829 | 1.6857 | 1.6829 | 1.6854 | 2852332.0 |
| 2005-08-17 11:50:00 | AAPL | Stock | 1.685 | 1.6864 | 1.6839 | 1.685 | 2927120.0 |
| 2005-08-17 11:55:00 | AAPL | Stock | 1.6854 | 1.6861 | 1.6839 | 1.6854 | 3181248.0 |
| 2005-08-17 12:00:00 | AAPL | Stock | 1.6857 | 1.6861 | 1.685 | 1.6857 | 2318456.0 |
| 2005-08-17 12:05:00 | AAPL | Stock | 1.6854 | 1.6864 | 1.685 | 1.685 | 2557296.0 |
| 2005-08-17 12:10:00 | AAPL | Stock | 1.685 | 1.6861 | 1.6839 | 1.6839 | 2671928.0 |
> showing 50 of 197,869 rows — these rows as CSV