PREVIEW / stock_5min / 2009-09-24
file: by_date/stock_5min/2009/2009-09-24.parquet size: 4.8 MB rows: 325,470 symbols: 3,394
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 |
|---|---|---|---|---|---|---|---|
| 2009-09-24 04:15:00 | AAPL | Stock | 6.6429 | 6.6429 | 6.6429 | 6.6429 | 8400.0 |
| 2009-09-24 05:25:00 | AAPL | Stock | 6.6786 | 6.6879 | 6.6786 | 6.6879 | 5600.0 |
| 2009-09-24 07:00:00 | AAPL | Stock | 6.6675 | 6.6736 | 6.6675 | 6.6696 | 40600.0 |
| 2009-09-24 07:10:00 | AAPL | Stock | 6.6732 | 6.6732 | 6.6704 | 6.6732 | 14000.0 |
| 2009-09-24 07:20:00 | AAPL | Stock | 6.6711 | 6.6711 | 6.6711 | 6.6711 | 5600.0 |
| 2009-09-24 07:35:00 | AAPL | Stock | 6.6679 | 6.6704 | 6.6679 | 6.6704 | 14000.0 |
| 2009-09-24 07:45:00 | AAPL | Stock | 6.6679 | 6.6714 | 6.6679 | 6.6714 | 5600.0 |
| 2009-09-24 07:55:00 | AAPL | Stock | 6.6764 | 6.6804 | 6.6732 | 6.6804 | 95200.0 |
| 2009-09-24 08:00:00 | AAPL | Stock | 6.6911 | 6.6964 | 6.6679 | 6.6929 | 291004.0 |
| 2009-09-24 08:05:00 | AAPL | Stock | 6.6946 | 6.6954 | 6.6889 | 6.6946 | 177800.0 |
| 2009-09-24 08:10:00 | AAPL | Stock | 6.6914 | 6.6964 | 6.6911 | 6.6911 | 534156.0 |
| 2009-09-24 08:15:00 | AAPL | Stock | 6.6911 | 6.695 | 6.6893 | 6.6918 | 408044.0 |
| 2009-09-24 08:20:00 | AAPL | Stock | 6.6893 | 6.6925 | 6.6893 | 6.6925 | 121996.0 |
| 2009-09-24 08:25:00 | AAPL | Stock | 6.6925 | 6.6925 | 6.69 | 6.69 | 42000.0 |
| 2009-09-24 08:30:00 | AAPL | Stock | 6.6893 | 6.7025 | 6.6882 | 6.6943 | 813400.0 |
| 2009-09-24 08:35:00 | AAPL | Stock | 6.6968 | 6.7018 | 6.6929 | 6.7018 | 619864.0 |
| 2009-09-24 08:40:00 | AAPL | Stock | 6.7039 | 6.7139 | 6.7039 | 6.7096 | 258832.0 |
| 2009-09-24 08:45:00 | AAPL | Stock | 6.7107 | 6.7107 | 6.6989 | 6.7029 | 312340.0 |
| 2009-09-24 08:50:00 | AAPL | Stock | 6.6996 | 6.7032 | 6.6996 | 6.7032 | 25200.0 |
| 2009-09-24 08:55:00 | AAPL | Stock | 6.7021 | 6.7043 | 6.7007 | 6.7029 | 24360.0 |
| 2009-09-24 09:00:00 | AAPL | Stock | 6.7036 | 6.7086 | 6.7032 | 6.7057 | 110432.0 |
| 2009-09-24 09:05:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.6986 | 6.7004 | 162400.0 |
| 2009-09-24 09:10:00 | AAPL | Stock | 6.6982 | 6.7143 | 6.6943 | 6.7043 | 766612.0 |
| 2009-09-24 09:15:00 | AAPL | Stock | 6.7043 | 6.7046 | 6.6929 | 6.6957 | 270200.0 |
| 2009-09-24 09:20:00 | AAPL | Stock | 6.695 | 6.695 | 6.6868 | 6.6868 | 234080.0 |
| 2009-09-24 09:25:00 | AAPL | Stock | 6.6864 | 6.6907 | 6.6836 | 6.6861 | 337624.0 |
| 2009-09-24 09:30:00 | AAPL | Stock | 6.6889 | 6.7036 | 6.672 | 6.6996 | 16938208.0 |
| 2009-09-24 09:35:00 | AAPL | Stock | 6.6996 | 6.6996 | 6.6682 | 6.6854 | 17549392.0 |
| 2009-09-24 09:40:00 | AAPL | Stock | 6.6857 | 6.6989 | 6.6786 | 6.6804 | 10652180.0 |
| 2009-09-24 09:45:00 | AAPL | Stock | 6.6793 | 6.7036 | 6.6764 | 6.7018 | 10935148.0 |
| 2009-09-24 09:50:00 | AAPL | Stock | 6.7018 | 6.7018 | 6.6429 | 6.6564 | 21792568.0 |
| 2009-09-24 09:55:00 | AAPL | Stock | 6.6564 | 6.6564 | 6.6193 | 6.6429 | 25778676.0 |
| 2009-09-24 10:00:00 | AAPL | Stock | 6.6321 | 6.6446 | 6.6118 | 6.6211 | 19169416.0 |
| 2009-09-24 10:05:00 | AAPL | Stock | 6.6207 | 6.6261 | 6.5539 | 6.5758 | 25494280.0 |
| 2009-09-24 10:10:00 | AAPL | Stock | 6.5757 | 6.605 | 6.5747 | 6.5868 | 17103268.0 |
| 2009-09-24 10:15:00 | AAPL | Stock | 6.5868 | 6.5921 | 6.575 | 6.5804 | 10086608.0 |
| 2009-09-24 10:20:00 | AAPL | Stock | 6.5811 | 6.6 | 6.5743 | 6.6 | 8071476.0 |
| 2009-09-24 10:25:00 | AAPL | Stock | 6.6 | 6.6036 | 6.5857 | 6.5939 | 6589800.0 |
| 2009-09-24 10:30:00 | AAPL | Stock | 6.5932 | 6.5953 | 6.5436 | 6.5545 | 14104636.0 |
| 2009-09-24 10:35:00 | AAPL | Stock | 6.5521 | 6.5543 | 6.5304 | 6.5452 | 15397144.0 |
| 2009-09-24 10:40:00 | AAPL | Stock | 6.5468 | 6.5536 | 6.5314 | 6.5464 | 11720660.0 |
| 2009-09-24 10:45:00 | AAPL | Stock | 6.5461 | 6.5714 | 6.5454 | 6.5671 | 9930312.0 |
| 2009-09-24 10:50:00 | AAPL | Stock | 6.5668 | 6.5775 | 6.5575 | 6.5765 | 7005096.0 |
| 2009-09-24 10:55:00 | AAPL | Stock | 6.5761 | 6.5868 | 6.5671 | 6.5786 | 7053284.0 |
| 2009-09-24 11:00:00 | AAPL | Stock | 6.5792 | 6.5839 | 6.5679 | 6.5718 | 3949876.0 |
| 2009-09-24 11:05:00 | AAPL | Stock | 6.5725 | 6.5804 | 6.5693 | 6.5796 | 2532040.0 |
| 2009-09-24 11:10:00 | AAPL | Stock | 6.5796 | 6.5993 | 6.5786 | 6.5911 | 5525492.0 |
| 2009-09-24 11:15:00 | AAPL | Stock | 6.591 | 6.595 | 6.5821 | 6.5868 | 3830316.0 |
| 2009-09-24 11:20:00 | AAPL | Stock | 6.5868 | 6.5889 | 6.5736 | 6.5775 | 3321948.0 |
| 2009-09-24 11:25:00 | AAPL | Stock | 6.5782 | 6.5879 | 6.5736 | 6.5863 | 2802576.0 |
> showing 50 of 325,470 rows — these rows as CSV