PREVIEW / stock_5min / 2007-12-06
file: by_date/stock_5min/2007/2007-12-06.parquet size: 4.4 MB rows: 318,874 symbols: 3,230
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-12-06 04:15:00 | AAPL | Stock | 6.6696 | 6.6696 | 6.6696 | 6.6696 | 2800.0 |
| 2007-12-06 04:20:00 | AAPL | Stock | 6.6696 | 6.6696 | 6.6696 | 6.6696 | 8400.0 |
| 2007-12-06 04:40:00 | AAPL | Stock | 6.65 | 6.65 | 6.65 | 6.65 | 2800.0 |
| 2007-12-06 04:50:00 | AAPL | Stock | 6.6661 | 6.6664 | 6.6661 | 6.6661 | 48720.0 |
| 2007-12-06 04:55:00 | AAPL | Stock | 6.6661 | 6.6661 | 6.6661 | 6.6661 | 11788.0 |
| 2007-12-06 06:10:00 | AAPL | Stock | 6.6696 | 6.6932 | 6.6696 | 6.6932 | 63952.0 |
| 2007-12-06 06:20:00 | AAPL | Stock | 6.6911 | 6.6925 | 6.6786 | 6.6786 | 33152.0 |
| 2007-12-06 06:25:00 | AAPL | Stock | 6.6857 | 6.6857 | 6.6857 | 6.6857 | 19600.0 |
| 2007-12-06 06:35:00 | AAPL | Stock | 6.6857 | 6.6857 | 6.6857 | 6.6857 | 21280.0 |
| 2007-12-06 06:40:00 | AAPL | Stock | 6.6857 | 6.6875 | 6.6786 | 6.6875 | 40152.0 |
| 2007-12-06 07:00:00 | AAPL | Stock | 6.6939 | 6.7025 | 6.6893 | 6.6964 | 196000.0 |
| 2007-12-06 07:05:00 | AAPL | Stock | 6.6964 | 6.7029 | 6.6964 | 6.6964 | 177240.0 |
| 2007-12-06 07:10:00 | AAPL | Stock | 6.7018 | 6.7018 | 6.6893 | 6.6964 | 494900.0 |
| 2007-12-06 07:15:00 | AAPL | Stock | 6.6896 | 6.6982 | 6.6786 | 6.6843 | 166600.0 |
| 2007-12-06 07:20:00 | AAPL | Stock | 6.6904 | 6.7029 | 6.6904 | 6.7029 | 107800.0 |
| 2007-12-06 07:25:00 | AAPL | Stock | 6.6993 | 6.7036 | 6.6993 | 6.7036 | 26320.0 |
| 2007-12-06 07:30:00 | AAPL | Stock | 6.7125 | 6.7268 | 6.71 | 6.7107 | 249144.0 |
| 2007-12-06 07:35:00 | AAPL | Stock | 6.7107 | 6.7179 | 6.6968 | 6.7 | 404600.0 |
| 2007-12-06 07:40:00 | AAPL | Stock | 6.7 | 6.7036 | 6.7 | 6.7 | 53480.0 |
| 2007-12-06 07:45:00 | AAPL | Stock | 6.6968 | 6.6975 | 6.6846 | 6.6846 | 301000.0 |
| 2007-12-06 07:50:00 | AAPL | Stock | 6.6829 | 6.6829 | 6.6714 | 6.6779 | 277060.0 |
| 2007-12-06 07:55:00 | AAPL | Stock | 6.6871 | 6.6929 | 6.6804 | 6.6804 | 235200.0 |
| 2007-12-06 08:00:00 | AAPL | Stock | 6.6957 | 6.6964 | 6.6786 | 6.6893 | 1250900.0 |
| 2007-12-06 08:05:00 | AAPL | Stock | 6.6904 | 6.7029 | 6.6875 | 6.6975 | 1346324.0 |
| 2007-12-06 08:10:00 | AAPL | Stock | 6.6982 | 6.7029 | 6.6793 | 6.6882 | 692412.0 |
| 2007-12-06 08:15:00 | AAPL | Stock | 6.6939 | 6.6946 | 6.6821 | 6.6854 | 372568.0 |
| 2007-12-06 08:20:00 | AAPL | Stock | 6.6829 | 6.6918 | 6.6786 | 6.6875 | 174412.0 |
| 2007-12-06 08:25:00 | AAPL | Stock | 6.6875 | 6.6875 | 6.6804 | 6.6821 | 370972.0 |
| 2007-12-06 08:30:00 | AAPL | Stock | 6.6821 | 6.685 | 6.6671 | 6.6793 | 832076.0 |
| 2007-12-06 08:35:00 | AAPL | Stock | 6.6832 | 6.6839 | 6.6739 | 6.675 | 693616.0 |
| 2007-12-06 08:40:00 | AAPL | Stock | 6.6754 | 6.6754 | 6.6504 | 6.6554 | 1101968.0 |
| 2007-12-06 08:45:00 | AAPL | Stock | 6.6554 | 6.6582 | 6.6493 | 6.6582 | 791000.0 |
| 2007-12-06 08:50:00 | AAPL | Stock | 6.6586 | 6.6729 | 6.6586 | 6.6696 | 477064.0 |
| 2007-12-06 08:55:00 | AAPL | Stock | 6.6704 | 6.6789 | 6.625 | 6.6454 | 1131564.0 |
| 2007-12-06 09:00:00 | AAPL | Stock | 6.6464 | 6.6546 | 6.6329 | 6.6536 | 929432.0 |
| 2007-12-06 09:05:00 | AAPL | Stock | 6.6529 | 6.6529 | 6.6429 | 6.6504 | 585480.0 |
| 2007-12-06 09:10:00 | AAPL | Stock | 6.6525 | 6.6607 | 6.65 | 6.6571 | 395808.0 |
| 2007-12-06 09:15:00 | AAPL | Stock | 6.6564 | 6.6571 | 6.6504 | 6.6554 | 270732.0 |
| 2007-12-06 09:20:00 | AAPL | Stock | 6.6554 | 6.6564 | 6.6539 | 6.6539 | 172620.0 |
| 2007-12-06 09:25:00 | AAPL | Stock | 6.6539 | 6.6571 | 6.65 | 6.65 | 612360.0 |
| 2007-12-06 09:30:00 | AAPL | Stock | 6.6518 | 6.7139 | 6.6471 | 6.7139 | 30025128.0 |
| 2007-12-06 09:35:00 | AAPL | Stock | 6.7136 | 6.7357 | 6.7014 | 6.7343 | 33923764.0 |
| 2007-12-06 09:40:00 | AAPL | Stock | 6.7354 | 6.7457 | 6.7175 | 6.7179 | 20337996.0 |
| 2007-12-06 09:45:00 | AAPL | Stock | 6.7186 | 6.7361 | 6.7071 | 6.7261 | 25366628.0 |
| 2007-12-06 09:50:00 | AAPL | Stock | 6.7268 | 6.7429 | 6.7196 | 6.7407 | 13923896.0 |
| 2007-12-06 09:55:00 | AAPL | Stock | 6.7396 | 6.7464 | 6.7193 | 6.7229 | 20247528.0 |
| 2007-12-06 10:00:00 | AAPL | Stock | 6.7225 | 6.7607 | 6.72 | 6.75 | 21582428.0 |
| 2007-12-06 10:05:00 | AAPL | Stock | 6.7511 | 6.7571 | 6.7436 | 6.7496 | 12884060.0 |
| 2007-12-06 10:10:00 | AAPL | Stock | 6.75 | 6.7607 | 6.7354 | 6.7393 | 16979592.0 |
| 2007-12-06 10:15:00 | AAPL | Stock | 6.7386 | 6.7464 | 6.7286 | 6.7354 | 10249456.0 |
> showing 50 of 318,874 rows — these rows as CSV