PREVIEW / stock_5min / 2007-09-07
file: by_date/stock_5min/2007/2007-09-07.parquet size: 4.0 MB rows: 296,313 symbols: 3,114
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-09-07 09:30:00 | AAPL | Stock | 4.7146 | 4.7182 | 4.6611 | 4.6714 | 72409932.0 |
| 2007-09-07 09:35:00 | AAPL | Stock | 4.6711 | 4.6911 | 4.6546 | 4.6732 | 42447720.0 |
| 2007-09-07 09:40:00 | AAPL | Stock | 4.6732 | 4.6929 | 4.6675 | 4.6893 | 31974432.0 |
| 2007-09-07 09:45:00 | AAPL | Stock | 4.6893 | 4.69 | 4.6679 | 4.6804 | 29711416.0 |
| 2007-09-07 09:50:00 | AAPL | Stock | 4.679 | 4.6979 | 4.6779 | 4.6921 | 32960844.0 |
| 2007-09-07 09:55:00 | AAPL | Stock | 4.6925 | 4.6925 | 4.6757 | 4.68 | 21605276.0 |
| 2007-09-07 10:00:00 | AAPL | Stock | 4.6814 | 4.6993 | 4.6723 | 4.6889 | 26156676.0 |
| 2007-09-07 10:05:00 | AAPL | Stock | 4.6896 | 4.7014 | 4.6804 | 4.6821 | 22814652.0 |
| 2007-09-07 10:10:00 | AAPL | Stock | 4.6811 | 4.6882 | 4.6768 | 4.6811 | 20181952.0 |
| 2007-09-07 10:15:00 | AAPL | Stock | 4.6814 | 4.6946 | 4.6764 | 4.6896 | 21311052.0 |
| 2007-09-07 10:20:00 | AAPL | Stock | 4.689 | 4.6943 | 4.6821 | 4.6835 | 14460516.0 |
| 2007-09-07 10:25:00 | AAPL | Stock | 4.6836 | 4.6925 | 4.6779 | 4.6886 | 15908480.0 |
| 2007-09-07 10:30:00 | AAPL | Stock | 4.6882 | 4.6889 | 4.6654 | 4.6696 | 24737524.0 |
| 2007-09-07 10:35:00 | AAPL | Stock | 4.67 | 4.6829 | 4.6686 | 4.6725 | 15382108.0 |
| 2007-09-07 10:40:00 | AAPL | Stock | 4.6718 | 4.6839 | 4.6696 | 4.6779 | 15741292.0 |
| 2007-09-07 10:45:00 | AAPL | Stock | 4.6779 | 4.6814 | 4.6589 | 4.6611 | 17522484.0 |
| 2007-09-07 10:50:00 | AAPL | Stock | 4.6611 | 4.6682 | 4.6454 | 4.6493 | 25147948.0 |
| 2007-09-07 10:55:00 | AAPL | Stock | 4.6493 | 4.655 | 4.6429 | 4.6518 | 31016720.0 |
| 2007-09-07 11:00:00 | AAPL | Stock | 4.6529 | 4.6643 | 4.6511 | 4.6636 | 16949800.0 |
| 2007-09-07 11:05:00 | AAPL | Stock | 4.6643 | 4.6754 | 4.6575 | 4.6732 | 16071188.0 |
| 2007-09-07 11:10:00 | AAPL | Stock | 4.6732 | 4.6736 | 4.65 | 4.6589 | 19106976.0 |
| 2007-09-07 11:15:00 | AAPL | Stock | 4.6579 | 4.67 | 4.6564 | 4.6646 | 14657552.0 |
| 2007-09-07 11:20:00 | AAPL | Stock | 4.6646 | 4.6736 | 4.6589 | 4.6622 | 13123040.0 |
| 2007-09-07 11:25:00 | AAPL | Stock | 4.6621 | 4.6671 | 4.6546 | 4.6556 | 13230280.0 |
| 2007-09-07 11:30:00 | AAPL | Stock | 4.6571 | 4.665 | 4.6518 | 4.6643 | 13024816.0 |
| 2007-09-07 11:35:00 | AAPL | Stock | 4.6643 | 4.6811 | 4.6636 | 4.6764 | 18608240.0 |
| 2007-09-07 11:40:00 | AAPL | Stock | 4.6764 | 4.6864 | 4.6761 | 4.6861 | 16824976.0 |
| 2007-09-07 11:45:00 | AAPL | Stock | 4.6861 | 4.6893 | 4.6757 | 4.6857 | 19547892.0 |
| 2007-09-07 11:50:00 | AAPL | Stock | 4.6857 | 4.6979 | 4.6832 | 4.6914 | 16815792.0 |
| 2007-09-07 11:55:00 | AAPL | Stock | 4.6914 | 4.7118 | 4.6904 | 4.7082 | 19571776.0 |
| 2007-09-07 12:00:00 | AAPL | Stock | 4.7082 | 4.7111 | 4.6964 | 4.6982 | 13032320.0 |
| 2007-09-07 12:05:00 | AAPL | Stock | 4.6986 | 4.7054 | 4.6982 | 4.7046 | 9761220.0 |
| 2007-09-07 12:10:00 | AAPL | Stock | 4.7043 | 4.7082 | 4.6943 | 4.6964 | 12212928.0 |
| 2007-09-07 12:15:00 | AAPL | Stock | 4.6964 | 4.7018 | 4.69 | 4.6921 | 8752212.0 |
| 2007-09-07 12:20:00 | AAPL | Stock | 4.6921 | 4.7054 | 4.6896 | 4.7021 | 7145432.0 |
| 2007-09-07 12:25:00 | AAPL | Stock | 4.7029 | 4.7229 | 4.7014 | 4.7214 | 15041628.0 |
| 2007-09-07 12:30:00 | AAPL | Stock | 4.7214 | 4.725 | 4.7104 | 4.7136 | 12690692.0 |
| 2007-09-07 12:35:00 | AAPL | Stock | 4.7143 | 4.7168 | 4.698 | 4.7046 | 11583376.0 |
| 2007-09-07 12:40:00 | AAPL | Stock | 4.7046 | 4.7093 | 4.6993 | 4.7016 | 8334704.0 |
| 2007-09-07 12:45:00 | AAPL | Stock | 4.7021 | 4.7021 | 4.6882 | 4.6918 | 10456768.0 |
| 2007-09-07 12:50:00 | AAPL | Stock | 4.6914 | 4.6975 | 4.6882 | 4.6918 | 7097356.0 |
| 2007-09-07 12:55:00 | AAPL | Stock | 4.6918 | 4.7029 | 4.6886 | 4.7007 | 6479788.0 |
| 2007-09-07 13:00:00 | AAPL | Stock | 4.7011 | 4.7089 | 4.6995 | 4.7064 | 7948220.0 |
| 2007-09-07 13:05:00 | AAPL | Stock | 4.7057 | 4.7182 | 4.7018 | 4.7179 | 12029136.0 |
| 2007-09-07 13:10:00 | AAPL | Stock | 4.7179 | 4.7204 | 4.7061 | 4.7079 | 8948464.0 |
| 2007-09-07 13:15:00 | AAPL | Stock | 4.7082 | 4.7118 | 4.7018 | 4.7114 | 6947080.0 |
| 2007-09-07 13:20:00 | AAPL | Stock | 4.7114 | 4.7174 | 4.7046 | 4.7064 | 7945336.0 |
| 2007-09-07 13:25:00 | AAPL | Stock | 4.7057 | 4.7157 | 4.7043 | 4.7089 | 6479508.0 |
| 2007-09-07 13:30:00 | AAPL | Stock | 4.7088 | 4.7179 | 4.7068 | 4.7121 | 6621636.0 |
| 2007-09-07 13:35:00 | AAPL | Stock | 4.7118 | 4.7132 | 4.6964 | 4.6989 | 8680000.0 |
> showing 50 of 296,313 rows — these rows as CSV