PREVIEW / stock_5min / 2007-08-06
file: by_date/stock_5min/2007/2007-08-06.parquet size: 4.5 MB rows: 316,850 symbols: 3,108
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-06 09:30:00 | AAPL | Stock | 4.7464 | 4.7679 | 4.7232 | 4.7611 | 29723848.0 |
| 2007-08-06 09:35:00 | AAPL | Stock | 4.7596 | 4.766 | 4.7143 | 4.7361 | 20846224.0 |
| 2007-08-06 09:40:00 | AAPL | Stock | 4.7407 | 4.7429 | 4.7086 | 4.7154 | 19296928.0 |
| 2007-08-06 09:45:00 | AAPL | Stock | 4.7154 | 4.7157 | 4.6339 | 4.6382 | 32945976.0 |
| 2007-08-06 09:50:00 | AAPL | Stock | 4.6379 | 4.6464 | 4.5821 | 4.6243 | 41521676.0 |
| 2007-08-06 09:55:00 | AAPL | Stock | 4.6239 | 4.6746 | 4.5971 | 4.6625 | 27421660.0 |
| 2007-08-06 10:00:00 | AAPL | Stock | 4.6632 | 4.6961 | 4.6571 | 4.6679 | 25922848.0 |
| 2007-08-06 10:05:00 | AAPL | Stock | 4.6679 | 4.6846 | 4.6579 | 4.6675 | 14663376.0 |
| 2007-08-06 10:10:00 | AAPL | Stock | 4.6664 | 4.6665 | 4.6225 | 4.6371 | 19229084.0 |
| 2007-08-06 10:15:00 | AAPL | Stock | 4.6368 | 4.6629 | 4.6286 | 4.6425 | 15554252.0 |
| 2007-08-06 10:20:00 | AAPL | Stock | 4.641 | 4.6607 | 4.63 | 4.6446 | 11260620.0 |
| 2007-08-06 10:25:00 | AAPL | Stock | 4.6436 | 4.655 | 4.6382 | 4.6432 | 11754932.0 |
| 2007-08-06 10:30:00 | AAPL | Stock | 4.6432 | 4.655 | 4.6336 | 4.6389 | 13354628.0 |
| 2007-08-06 10:35:00 | AAPL | Stock | 4.6386 | 4.6714 | 4.6293 | 4.6536 | 14620508.0 |
| 2007-08-06 10:40:00 | AAPL | Stock | 4.6532 | 4.6639 | 4.6396 | 4.6579 | 12049324.0 |
| 2007-08-06 10:45:00 | AAPL | Stock | 4.6575 | 4.6732 | 4.6511 | 4.6671 | 10576804.0 |
| 2007-08-06 10:50:00 | AAPL | Stock | 4.6671 | 4.67 | 4.6493 | 4.6679 | 12091884.0 |
| 2007-08-06 10:55:00 | AAPL | Stock | 4.6679 | 4.7446 | 4.6575 | 4.6739 | 13524840.0 |
| 2007-08-06 11:00:00 | AAPL | Stock | 4.6744 | 4.6871 | 4.6725 | 4.675 | 10811528.0 |
| 2007-08-06 11:05:00 | AAPL | Stock | 4.675 | 4.6818 | 4.6646 | 4.6743 | 6760572.0 |
| 2007-08-06 11:10:00 | AAPL | Stock | 4.6743 | 4.675 | 4.6536 | 4.6661 | 10379404.0 |
| 2007-08-06 11:15:00 | AAPL | Stock | 4.6639 | 4.6971 | 4.66 | 4.6868 | 12226592.0 |
| 2007-08-06 11:20:00 | AAPL | Stock | 4.6868 | 4.7218 | 4.6839 | 4.7104 | 19528880.0 |
| 2007-08-06 11:25:00 | AAPL | Stock | 4.7104 | 4.7136 | 4.6979 | 4.7064 | 7993552.0 |
| 2007-08-06 11:30:00 | AAPL | Stock | 4.7068 | 4.7089 | 4.6357 | 4.6908 | 8673224.0 |
| 2007-08-06 11:35:00 | AAPL | Stock | 4.6907 | 4.6964 | 4.6696 | 4.6761 | 12398288.0 |
| 2007-08-06 11:40:00 | AAPL | Stock | 4.6768 | 4.6921 | 4.6768 | 4.6911 | 5761196.0 |
| 2007-08-06 11:45:00 | AAPL | Stock | 4.6896 | 4.7229 | 4.6896 | 4.7218 | 12021968.0 |
| 2007-08-06 11:50:00 | AAPL | Stock | 4.7221 | 4.7393 | 4.71 | 4.7127 | 13019048.0 |
| 2007-08-06 11:55:00 | AAPL | Stock | 4.7136 | 4.7189 | 4.7071 | 4.7096 | 6641068.0 |
| 2007-08-06 12:00:00 | AAPL | Stock | 4.7096 | 4.7143 | 4.6904 | 4.7014 | 9035964.0 |
| 2007-08-06 12:05:00 | AAPL | Stock | 4.7021 | 4.705 | 4.6904 | 4.7036 | 5838924.0 |
| 2007-08-06 12:10:00 | AAPL | Stock | 4.7046 | 4.7068 | 4.6946 | 4.6993 | 3929632.0 |
| 2007-08-06 12:15:00 | AAPL | Stock | 4.6993 | 4.7025 | 4.6839 | 4.6886 | 4461352.0 |
| 2007-08-06 12:20:00 | AAPL | Stock | 4.6882 | 4.6971 | 4.6843 | 4.6893 | 4799956.0 |
| 2007-08-06 12:25:00 | AAPL | Stock | 4.6889 | 4.7014 | 4.6871 | 4.7 | 5927068.0 |
| 2007-08-06 12:30:00 | AAPL | Stock | 4.7 | 4.7179 | 4.6989 | 4.7161 | 6822312.0 |
| 2007-08-06 12:35:00 | AAPL | Stock | 4.7161 | 4.7475 | 4.7143 | 4.7364 | 14614796.0 |
| 2007-08-06 12:40:00 | AAPL | Stock | 4.7371 | 4.7429 | 4.7264 | 4.7343 | 10881332.0 |
| 2007-08-06 12:45:00 | AAPL | Stock | 4.7343 | 4.7625 | 4.7339 | 4.7614 | 13418468.0 |
| 2007-08-06 12:50:00 | AAPL | Stock | 4.7614 | 4.7704 | 4.7557 | 4.7568 | 12163144.0 |
| 2007-08-06 12:55:00 | AAPL | Stock | 4.7564 | 4.7607 | 4.7507 | 4.755 | 6895000.0 |
| 2007-08-06 13:00:00 | AAPL | Stock | 4.7543 | 4.7636 | 4.7489 | 4.7629 | 6925828.0 |
| 2007-08-06 13:05:00 | AAPL | Stock | 4.7629 | 4.7646 | 4.7393 | 4.7436 | 10377752.0 |
| 2007-08-06 13:10:00 | AAPL | Stock | 4.7425 | 4.7482 | 4.7354 | 4.7454 | 7233632.0 |
| 2007-08-06 13:15:00 | AAPL | Stock | 4.7457 | 4.7504 | 4.7425 | 4.7479 | 4002488.0 |
| 2007-08-06 13:20:00 | AAPL | Stock | 4.7482 | 4.7529 | 4.7432 | 4.7518 | 2951284.0 |
| 2007-08-06 13:25:00 | AAPL | Stock | 4.7514 | 4.7557 | 4.7464 | 4.7529 | 4912124.0 |
| 2007-08-06 13:30:00 | AAPL | Stock | 4.7521 | 4.7532 | 4.7411 | 4.7479 | 4180428.0 |
| 2007-08-06 13:35:00 | AAPL | Stock | 4.7471 | 4.7582 | 4.7436 | 4.755 | 8021748.0 |
> showing 50 of 316,850 rows — these rows as CSV