PREVIEW / stock_5min / 2008-02-05
file: by_date/stock_5min/2008/2008-02-05.parquet size: 4.4 MB rows: 320,152 symbols: 3,235
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-05 05:10:00 | AAPL | Stock | 4.71 | 4.71 | 4.71 | 4.71 | 2800.0 |
| 2008-02-05 05:50:00 | AAPL | Stock | 4.7107 | 4.7107 | 4.7107 | 4.7107 | 8400.0 |
| 2008-02-05 05:55:00 | AAPL | Stock | 4.7036 | 4.7036 | 4.7036 | 4.7036 | 2800.0 |
| 2008-02-05 06:00:00 | AAPL | Stock | 4.7168 | 4.7168 | 4.6957 | 4.6957 | 5600.0 |
| 2008-02-05 06:25:00 | AAPL | Stock | 4.7107 | 4.7168 | 4.7107 | 4.7168 | 60900.0 |
| 2008-02-05 06:30:00 | AAPL | Stock | 4.7132 | 4.7132 | 4.7132 | 4.7132 | 5600.0 |
| 2008-02-05 07:00:00 | AAPL | Stock | 4.6532 | 4.6961 | 4.6532 | 4.6957 | 15232.0 |
| 2008-02-05 07:05:00 | AAPL | Stock | 4.7125 | 4.7125 | 4.6957 | 4.6957 | 9184.0 |
| 2008-02-05 07:10:00 | AAPL | Stock | 4.6957 | 4.7179 | 4.6957 | 4.7179 | 35588.0 |
| 2008-02-05 07:15:00 | AAPL | Stock | 4.6964 | 4.6964 | 4.6964 | 4.6964 | 11200.0 |
| 2008-02-05 07:20:00 | AAPL | Stock | 4.7175 | 4.7175 | 4.7175 | 4.7175 | 7028.0 |
| 2008-02-05 07:25:00 | AAPL | Stock | 4.7136 | 4.7143 | 4.7136 | 4.7143 | 28000.0 |
| 2008-02-05 07:35:00 | AAPL | Stock | 4.6929 | 4.6929 | 4.6893 | 4.6893 | 19600.0 |
| 2008-02-05 07:40:00 | AAPL | Stock | 4.6914 | 4.6914 | 4.6896 | 4.6914 | 38388.0 |
| 2008-02-05 07:50:00 | AAPL | Stock | 4.6904 | 4.6904 | 4.6857 | 4.6857 | 36148.0 |
| 2008-02-05 08:00:00 | AAPL | Stock | 4.6839 | 4.7018 | 4.6836 | 4.6911 | 750736.0 |
| 2008-02-05 08:05:00 | AAPL | Stock | 4.6911 | 4.7018 | 4.6911 | 4.7018 | 54124.0 |
| 2008-02-05 08:10:00 | AAPL | Stock | 4.6993 | 4.7018 | 4.6957 | 4.7018 | 47600.0 |
| 2008-02-05 08:15:00 | AAPL | Stock | 4.7018 | 4.7054 | 4.6964 | 4.7046 | 67144.0 |
| 2008-02-05 08:20:00 | AAPL | Stock | 4.705 | 4.7143 | 4.705 | 4.7143 | 158144.0 |
| 2008-02-05 08:25:00 | AAPL | Stock | 4.7143 | 4.7218 | 4.7143 | 4.7218 | 181916.0 |
| 2008-02-05 08:30:00 | AAPL | Stock | 4.7246 | 4.7743 | 4.7214 | 4.7536 | 3555524.0 |
| 2008-02-05 08:35:00 | AAPL | Stock | 4.7514 | 4.7514 | 4.7232 | 4.7321 | 841764.0 |
| 2008-02-05 08:40:00 | AAPL | Stock | 4.7321 | 4.7393 | 4.7114 | 4.7114 | 1769964.0 |
| 2008-02-05 08:45:00 | AAPL | Stock | 4.7114 | 4.7146 | 4.7036 | 4.7054 | 870688.0 |
| 2008-02-05 08:50:00 | AAPL | Stock | 4.705 | 4.7232 | 4.7014 | 4.7214 | 685972.0 |
| 2008-02-05 08:55:00 | AAPL | Stock | 4.7229 | 4.7232 | 4.6625 | 4.6732 | 3514560.0 |
| 2008-02-05 09:00:00 | AAPL | Stock | 4.6732 | 4.6829 | 4.6704 | 4.675 | 597044.0 |
| 2008-02-05 09:05:00 | AAPL | Stock | 4.6743 | 4.675 | 4.6679 | 4.67 | 774312.0 |
| 2008-02-05 09:10:00 | AAPL | Stock | 4.6714 | 4.6732 | 4.6486 | 4.6536 | 1538488.0 |
| 2008-02-05 09:15:00 | AAPL | Stock | 4.6518 | 4.6629 | 4.6493 | 4.6536 | 293300.0 |
| 2008-02-05 09:20:00 | AAPL | Stock | 4.6536 | 4.6607 | 4.6536 | 4.6607 | 246764.0 |
| 2008-02-05 09:25:00 | AAPL | Stock | 4.6607 | 4.6639 | 4.6564 | 4.6582 | 1296764.0 |
| 2008-02-05 09:30:00 | AAPL | Stock | 4.6582 | 4.6893 | 4.6557 | 4.6757 | 29529668.0 |
| 2008-02-05 09:35:00 | AAPL | Stock | 4.6768 | 4.7114 | 4.6696 | 4.7036 | 34102992.0 |
| 2008-02-05 09:40:00 | AAPL | Stock | 4.7039 | 4.7282 | 4.6911 | 4.6954 | 31186176.0 |
| 2008-02-05 09:45:00 | AAPL | Stock | 4.695 | 4.7179 | 4.6911 | 4.7107 | 27864172.0 |
| 2008-02-05 09:50:00 | AAPL | Stock | 4.7107 | 4.7411 | 4.7054 | 4.7375 | 27568968.0 |
| 2008-02-05 09:55:00 | AAPL | Stock | 4.7371 | 4.7571 | 4.7268 | 4.7479 | 24916276.0 |
| 2008-02-05 10:00:00 | AAPL | Stock | 4.7475 | 4.7679 | 4.7364 | 4.7643 | 22984276.0 |
| 2008-02-05 10:05:00 | AAPL | Stock | 4.7643 | 4.7679 | 4.7425 | 4.7589 | 21107688.0 |
| 2008-02-05 10:10:00 | AAPL | Stock | 4.7586 | 4.7689 | 4.7479 | 4.75 | 19087488.0 |
| 2008-02-05 10:15:00 | AAPL | Stock | 4.7504 | 4.7664 | 4.7411 | 4.7536 | 19152504.0 |
| 2008-02-05 10:20:00 | AAPL | Stock | 4.7546 | 4.7643 | 4.7143 | 4.7351 | 16644684.0 |
| 2008-02-05 10:25:00 | AAPL | Stock | 4.7351 | 4.7857 | 4.7321 | 4.7636 | 16837352.0 |
| 2008-02-05 10:30:00 | AAPL | Stock | 4.7636 | 4.7675 | 4.7346 | 4.74 | 17576132.0 |
| 2008-02-05 10:35:00 | AAPL | Stock | 4.7404 | 4.7461 | 4.7114 | 4.7157 | 21270396.0 |
| 2008-02-05 10:40:00 | AAPL | Stock | 4.7157 | 4.7232 | 4.705 | 4.7089 | 15743224.0 |
| 2008-02-05 10:45:00 | AAPL | Stock | 4.7089 | 4.7154 | 4.6957 | 4.6989 | 13562388.0 |
| 2008-02-05 10:50:00 | AAPL | Stock | 4.6993 | 4.7132 | 4.6986 | 4.71 | 10201184.0 |
> showing 50 of 320,152 rows — these rows as CSV