PREVIEW / stock_5min / 2005-09-06
file: by_date/stock_5min/2005/2005-09-06.parquet size: 2.8 MB rows: 204,465 symbols: 2,067
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-09-06 08:00:00 | AAPL | Stock | 1.6561 | 1.6561 | 1.6561 | 1.6561 | 14000.0 |
| 2005-09-06 08:10:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6625 | 1.6625 | 5600.0 |
| 2005-09-06 08:15:00 | AAPL | Stock | 1.6625 | 1.6686 | 1.6625 | 1.6675 | 578620.0 |
| 2005-09-06 08:20:00 | AAPL | Stock | 1.6657 | 1.6682 | 1.6657 | 1.6671 | 201880.0 |
| 2005-09-06 08:25:00 | AAPL | Stock | 1.6661 | 1.6679 | 1.6661 | 1.6679 | 103600.0 |
| 2005-09-06 08:30:00 | AAPL | Stock | 1.6679 | 1.6679 | 1.6639 | 1.6664 | 33600.0 |
| 2005-09-06 08:35:00 | AAPL | Stock | 1.6675 | 1.6675 | 1.6646 | 1.6661 | 65520.0 |
| 2005-09-06 08:45:00 | AAPL | Stock | 1.6661 | 1.6679 | 1.6643 | 1.6675 | 89600.0 |
| 2005-09-06 08:50:00 | AAPL | Stock | 1.6646 | 1.6646 | 1.6507 | 1.6507 | 175280.0 |
| 2005-09-06 08:55:00 | AAPL | Stock | 1.6654 | 1.6654 | 1.6625 | 1.6625 | 45920.0 |
| 2005-09-06 09:00:00 | AAPL | Stock | 1.6507 | 1.6661 | 1.6507 | 1.6661 | 204400.0 |
| 2005-09-06 09:05:00 | AAPL | Stock | 1.6625 | 1.6625 | 1.6621 | 1.6625 | 35280.0 |
| 2005-09-06 09:10:00 | AAPL | Stock | 1.6632 | 1.665 | 1.6632 | 1.6643 | 78400.0 |
| 2005-09-06 09:15:00 | AAPL | Stock | 1.665 | 1.665 | 1.6643 | 1.665 | 25200.0 |
| 2005-09-06 09:20:00 | AAPL | Stock | 1.665 | 1.665 | 1.6639 | 1.665 | 19320.0 |
| 2005-09-06 09:25:00 | AAPL | Stock | 1.665 | 1.6675 | 1.665 | 1.6675 | 295400.0 |
| 2005-09-06 09:30:00 | AAPL | Stock | 1.6679 | 1.6696 | 1.6639 | 1.665 | 12160848.0 |
| 2005-09-06 09:35:00 | AAPL | Stock | 1.665 | 1.67 | 1.6629 | 1.6643 | 8802556.0 |
| 2005-09-06 09:40:00 | AAPL | Stock | 1.6643 | 1.6661 | 1.6625 | 1.6639 | 4313792.0 |
| 2005-09-06 09:45:00 | AAPL | Stock | 1.6636 | 1.6682 | 1.6636 | 1.6679 | 4845288.0 |
| 2005-09-06 09:50:00 | AAPL | Stock | 1.6679 | 1.6689 | 1.6671 | 1.6686 | 5163592.0 |
| 2005-09-06 09:55:00 | AAPL | Stock | 1.6686 | 1.6725 | 1.6682 | 1.6707 | 8142232.0 |
| 2005-09-06 10:00:00 | AAPL | Stock | 1.6704 | 1.6754 | 1.67 | 1.6754 | 7645260.0 |
| 2005-09-06 10:05:00 | AAPL | Stock | 1.675 | 1.6811 | 1.675 | 1.6789 | 12806248.0 |
| 2005-09-06 10:10:00 | AAPL | Stock | 1.6789 | 1.6804 | 1.6768 | 1.6793 | 4230464.0 |
| 2005-09-06 10:15:00 | AAPL | Stock | 1.6796 | 1.6804 | 1.6768 | 1.6793 | 4572288.0 |
| 2005-09-06 10:20:00 | AAPL | Stock | 1.6796 | 1.6832 | 1.6789 | 1.6821 | 8849568.0 |
| 2005-09-06 10:25:00 | AAPL | Stock | 1.6825 | 1.7064 | 1.6818 | 1.7054 | 33640040.0 |
| 2005-09-06 10:30:00 | AAPL | Stock | 1.7054 | 1.7179 | 1.7025 | 1.7154 | 37808988.0 |
| 2005-09-06 10:35:00 | AAPL | Stock | 1.715 | 1.7175 | 1.7082 | 1.7139 | 20342196.0 |
| 2005-09-06 10:40:00 | AAPL | Stock | 1.7143 | 1.7268 | 1.7096 | 1.7161 | 14787864.0 |
| 2005-09-06 10:45:00 | AAPL | Stock | 1.7161 | 1.7189 | 1.7057 | 1.7093 | 18894876.0 |
| 2005-09-06 10:50:00 | AAPL | Stock | 1.7096 | 1.7157 | 1.7086 | 1.7132 | 10123148.0 |
| 2005-09-06 10:55:00 | AAPL | Stock | 1.7132 | 1.7146 | 1.7125 | 1.7139 | 6202308.0 |
| 2005-09-06 11:00:00 | AAPL | Stock | 1.7139 | 1.7168 | 1.7121 | 1.7164 | 10921428.0 |
| 2005-09-06 11:05:00 | AAPL | Stock | 1.7168 | 1.7221 | 1.7154 | 1.7185 | 19925752.0 |
| 2005-09-06 11:10:00 | AAPL | Stock | 1.7182 | 1.7225 | 1.7139 | 1.7146 | 11833724.0 |
| 2005-09-06 11:15:00 | AAPL | Stock | 1.715 | 1.7211 | 1.7139 | 1.7204 | 9973348.0 |
| 2005-09-06 11:20:00 | AAPL | Stock | 1.7204 | 1.7204 | 1.7154 | 1.7171 | 5848416.0 |
| 2005-09-06 11:25:00 | AAPL | Stock | 1.7171 | 1.7229 | 1.7171 | 1.7221 | 8047368.0 |
| 2005-09-06 11:30:00 | AAPL | Stock | 1.7225 | 1.7289 | 1.7196 | 1.7282 | 16592492.0 |
| 2005-09-06 11:35:00 | AAPL | Stock | 1.7282 | 1.7357 | 1.722 | 1.7343 | 30806160.0 |
| 2005-09-06 11:40:00 | AAPL | Stock | 1.7343 | 1.7357 | 1.7307 | 1.7336 | 20405532.0 |
| 2005-09-06 11:45:00 | AAPL | Stock | 1.7336 | 1.7361 | 1.7296 | 1.7339 | 15183420.0 |
| 2005-09-06 11:50:00 | AAPL | Stock | 1.7339 | 1.7386 | 1.7311 | 1.7375 | 17926580.0 |
| 2005-09-06 11:55:00 | AAPL | Stock | 1.7375 | 1.7396 | 1.7364 | 1.7379 | 13562724.0 |
| 2005-09-06 12:00:00 | AAPL | Stock | 1.7379 | 1.7379 | 1.7329 | 1.7354 | 12909736.0 |
| 2005-09-06 12:05:00 | AAPL | Stock | 1.7357 | 1.7382 | 1.7329 | 1.7379 | 7282492.0 |
| 2005-09-06 12:10:00 | AAPL | Stock | 1.7379 | 1.7411 | 1.7361 | 1.74 | 9116520.0 |
| 2005-09-06 12:15:00 | AAPL | Stock | 1.74 | 1.7414 | 1.7371 | 1.7396 | 9625028.0 |
> showing 50 of 204,465 rows — these rows as CSV