PREVIEW / stock_5min / 2007-08-09
file: by_date/stock_5min/2007/2007-08-09.parquet size: 4.5 MB rows: 316,494 symbols: 3,088
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-08-09 09:30:00 | AAPL | Stock | 4.6825 | 4.6964 | 4.6643 | 4.6725 | 35795312.0 |
| 2007-08-09 09:35:00 | AAPL | Stock | 4.6732 | 4.7071 | 4.6732 | 4.6882 | 19763660.0 |
| 2007-08-09 09:40:00 | AAPL | Stock | 4.6875 | 4.7129 | 4.6821 | 4.7089 | 20915300.0 |
| 2007-08-09 09:45:00 | AAPL | Stock | 4.7129 | 4.7204 | 4.7007 | 4.7139 | 18703580.0 |
| 2007-08-09 09:50:00 | AAPL | Stock | 4.7143 | 4.7282 | 4.7057 | 4.72 | 10127908.0 |
| 2007-08-09 09:55:00 | AAPL | Stock | 4.72 | 4.7214 | 4.71 | 4.7171 | 10551184.0 |
| 2007-08-09 10:00:00 | AAPL | Stock | 4.7175 | 4.73 | 4.6911 | 4.7061 | 14800744.0 |
| 2007-08-09 10:05:00 | AAPL | Stock | 4.7057 | 4.7136 | 4.6964 | 4.7039 | 10939684.0 |
| 2007-08-09 10:10:00 | AAPL | Stock | 4.7025 | 4.7157 | 4.7025 | 4.7129 | 7152236.0 |
| 2007-08-09 10:15:00 | AAPL | Stock | 4.7143 | 4.7286 | 4.7114 | 4.7171 | 16555812.0 |
| 2007-08-09 10:20:00 | AAPL | Stock | 4.7171 | 4.7171 | 4.7054 | 4.7118 | 9496620.0 |
| 2007-08-09 10:25:00 | AAPL | Stock | 4.7118 | 4.7264 | 4.7104 | 4.7193 | 9420684.0 |
| 2007-08-09 10:30:00 | AAPL | Stock | 4.7193 | 4.75 | 4.715 | 4.7479 | 15626156.0 |
| 2007-08-09 10:35:00 | AAPL | Stock | 4.7479 | 4.75 | 4.7054 | 4.7157 | 15322804.0 |
| 2007-08-09 10:40:00 | AAPL | Stock | 4.7146 | 4.7204 | 4.7036 | 4.7036 | 9484020.0 |
| 2007-08-09 10:45:00 | AAPL | Stock | 4.7036 | 4.71 | 4.6936 | 4.7036 | 11111744.0 |
| 2007-08-09 10:50:00 | AAPL | Stock | 4.7036 | 4.7089 | 4.6932 | 4.7082 | 6945820.0 |
| 2007-08-09 10:55:00 | AAPL | Stock | 4.7075 | 4.7093 | 4.6986 | 4.7068 | 5387508.0 |
| 2007-08-09 11:00:00 | AAPL | Stock | 4.7068 | 4.7104 | 4.7 | 4.7046 | 7340004.0 |
| 2007-08-09 11:05:00 | AAPL | Stock | 4.705 | 4.7125 | 4.7 | 4.7032 | 8380176.0 |
| 2007-08-09 11:10:00 | AAPL | Stock | 4.7029 | 4.7093 | 4.6986 | 4.7025 | 6389936.0 |
| 2007-08-09 11:15:00 | AAPL | Stock | 4.7029 | 4.7032 | 4.6861 | 4.6882 | 11450684.0 |
| 2007-08-09 11:20:00 | AAPL | Stock | 4.6882 | 4.6939 | 4.675 | 4.6775 | 11125072.0 |
| 2007-08-09 11:25:00 | AAPL | Stock | 4.6771 | 4.6936 | 4.6771 | 4.6907 | 8142316.0 |
| 2007-08-09 11:30:00 | AAPL | Stock | 4.6904 | 4.6989 | 4.6875 | 4.6921 | 6828388.0 |
| 2007-08-09 11:35:00 | AAPL | Stock | 4.6925 | 4.6939 | 4.6793 | 4.6796 | 7321944.0 |
| 2007-08-09 11:40:00 | AAPL | Stock | 4.68 | 4.685 | 4.6746 | 4.6764 | 9612596.0 |
| 2007-08-09 11:45:00 | AAPL | Stock | 4.6761 | 4.6779 | 4.6557 | 4.6671 | 15913380.0 |
| 2007-08-09 11:50:00 | AAPL | Stock | 4.6671 | 4.6746 | 4.6579 | 4.6707 | 8102108.0 |
| 2007-08-09 11:55:00 | AAPL | Stock | 4.6707 | 4.6707 | 4.6561 | 4.6664 | 7991312.0 |
| 2007-08-09 12:00:00 | AAPL | Stock | 4.6664 | 4.6764 | 4.6596 | 4.6618 | 8577072.0 |
| 2007-08-09 12:05:00 | AAPL | Stock | 4.6629 | 4.6661 | 4.6493 | 4.6614 | 10314640.0 |
| 2007-08-09 12:10:00 | AAPL | Stock | 4.6614 | 4.6757 | 4.6571 | 4.6736 | 7851396.0 |
| 2007-08-09 12:15:00 | AAPL | Stock | 4.6747 | 4.6786 | 4.6643 | 4.6693 | 7457296.0 |
| 2007-08-09 12:20:00 | AAPL | Stock | 4.6693 | 4.6746 | 4.6625 | 4.6714 | 4488148.0 |
| 2007-08-09 12:25:00 | AAPL | Stock | 4.6718 | 4.6821 | 4.6711 | 4.6782 | 10078516.0 |
| 2007-08-09 12:30:00 | AAPL | Stock | 4.6782 | 4.6782 | 4.6625 | 4.6671 | 6322988.0 |
| 2007-08-09 12:35:00 | AAPL | Stock | 4.6661 | 4.6675 | 4.6554 | 4.6579 | 6278076.0 |
| 2007-08-09 12:40:00 | AAPL | Stock | 4.6586 | 4.6618 | 4.6493 | 4.6521 | 7661976.0 |
| 2007-08-09 12:45:00 | AAPL | Stock | 4.6518 | 4.6621 | 4.6461 | 4.6507 | 7945560.0 |
| 2007-08-09 12:50:00 | AAPL | Stock | 4.6514 | 4.6571 | 4.6432 | 4.6446 | 7434812.0 |
| 2007-08-09 12:55:00 | AAPL | Stock | 4.6446 | 4.6586 | 4.6446 | 4.6514 | 8047088.0 |
| 2007-08-09 13:00:00 | AAPL | Stock | 4.6507 | 4.6586 | 4.6357 | 4.6393 | 10608976.0 |
| 2007-08-09 13:05:00 | AAPL | Stock | 4.6382 | 4.655 | 4.635 | 4.6525 | 11232172.0 |
| 2007-08-09 13:10:00 | AAPL | Stock | 4.6532 | 4.6575 | 4.6429 | 4.6471 | 5272764.0 |
| 2007-08-09 13:15:00 | AAPL | Stock | 4.6471 | 4.6536 | 4.6368 | 4.6457 | 11461240.0 |
| 2007-08-09 13:20:00 | AAPL | Stock | 4.6446 | 4.6518 | 4.6382 | 4.6496 | 6565552.0 |
| 2007-08-09 13:25:00 | AAPL | Stock | 4.6486 | 4.6601 | 4.6464 | 4.6568 | 6884640.0 |
| 2007-08-09 13:30:00 | AAPL | Stock | 4.6571 | 4.6714 | 4.6536 | 4.6696 | 10129392.0 |
| 2007-08-09 13:35:00 | AAPL | Stock | 4.6697 | 4.6757 | 4.6611 | 4.6675 | 6155184.0 |
> showing 50 of 316,494 rows — these rows as CSV