PREVIEW / stock_5min / 2008-07-25
file: by_date/stock_5min/2008/2008-07-25.parquet size: 4.4 MB rows: 316,261 symbols: 3,322
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-07-25 06:55:00 | AAPL | Stock | 5.6757 | 5.6757 | 5.6757 | 5.6757 | 2800.0 |
| 2008-07-25 07:00:00 | AAPL | Stock | 5.7104 | 5.7104 | 5.6757 | 5.6757 | 8400.0 |
| 2008-07-25 07:10:00 | AAPL | Stock | 5.6929 | 5.7075 | 5.6929 | 5.6929 | 16800.0 |
| 2008-07-25 07:50:00 | AAPL | Stock | 5.6825 | 5.6825 | 5.6825 | 5.6825 | 5040.0 |
| 2008-07-25 08:00:00 | AAPL | Stock | 5.7 | 5.7071 | 5.6896 | 5.7071 | 149100.0 |
| 2008-07-25 08:05:00 | AAPL | Stock | 5.7061 | 5.7232 | 5.7057 | 5.7232 | 335888.0 |
| 2008-07-25 08:10:00 | AAPL | Stock | 5.7193 | 5.7193 | 5.7136 | 5.7179 | 264600.0 |
| 2008-07-25 08:15:00 | AAPL | Stock | 5.7143 | 5.7261 | 5.7143 | 5.7232 | 304528.0 |
| 2008-07-25 08:20:00 | AAPL | Stock | 5.7232 | 5.7232 | 5.7143 | 5.7186 | 271488.0 |
| 2008-07-25 08:25:00 | AAPL | Stock | 5.7196 | 5.7236 | 5.7186 | 5.7236 | 116816.0 |
| 2008-07-25 08:30:00 | AAPL | Stock | 5.7221 | 5.7375 | 5.7221 | 5.7357 | 882504.0 |
| 2008-07-25 08:35:00 | AAPL | Stock | 5.7357 | 5.7364 | 5.725 | 5.725 | 220080.0 |
| 2008-07-25 08:40:00 | AAPL | Stock | 5.7257 | 5.7286 | 5.7257 | 5.7282 | 58940.0 |
| 2008-07-25 08:45:00 | AAPL | Stock | 5.7243 | 5.7346 | 5.7214 | 5.7339 | 109844.0 |
| 2008-07-25 08:50:00 | AAPL | Stock | 5.7343 | 5.7375 | 5.7325 | 5.7357 | 194880.0 |
| 2008-07-25 08:55:00 | AAPL | Stock | 5.7357 | 5.7357 | 5.7293 | 5.73 | 39200.0 |
| 2008-07-25 09:00:00 | AAPL | Stock | 5.7304 | 5.7304 | 5.7264 | 5.7282 | 81200.0 |
| 2008-07-25 09:05:00 | AAPL | Stock | 5.7279 | 5.7321 | 5.7279 | 5.7296 | 149100.0 |
| 2008-07-25 09:10:00 | AAPL | Stock | 5.7296 | 5.73 | 5.7207 | 5.7214 | 438620.0 |
| 2008-07-25 09:15:00 | AAPL | Stock | 5.7214 | 5.7257 | 5.7214 | 5.7257 | 76384.0 |
| 2008-07-25 09:20:00 | AAPL | Stock | 5.725 | 5.7489 | 5.725 | 5.7482 | 579740.0 |
| 2008-07-25 09:25:00 | AAPL | Stock | 5.7464 | 5.7479 | 5.7232 | 5.7279 | 494788.0 |
| 2008-07-25 09:30:00 | AAPL | Stock | 5.7307 | 5.7411 | 5.7018 | 5.7071 | 20196540.0 |
| 2008-07-25 09:35:00 | AAPL | Stock | 5.7054 | 5.7414 | 5.7018 | 5.7336 | 11840472.0 |
| 2008-07-25 09:40:00 | AAPL | Stock | 5.7332 | 5.7414 | 5.6911 | 5.6986 | 14794248.0 |
| 2008-07-25 09:45:00 | AAPL | Stock | 5.6989 | 5.6989 | 5.6696 | 5.6714 | 11991672.0 |
| 2008-07-25 09:50:00 | AAPL | Stock | 5.6729 | 5.6957 | 5.6661 | 5.6904 | 14944160.0 |
| 2008-07-25 09:55:00 | AAPL | Stock | 5.6907 | 5.7379 | 5.6907 | 5.7243 | 20184836.0 |
| 2008-07-25 10:00:00 | AAPL | Stock | 5.7236 | 5.7429 | 5.7039 | 5.7121 | 17501764.0 |
| 2008-07-25 10:05:00 | AAPL | Stock | 5.7104 | 5.7286 | 5.7089 | 5.7179 | 11124792.0 |
| 2008-07-25 10:10:00 | AAPL | Stock | 5.7193 | 5.7639 | 5.7154 | 5.7629 | 17190264.0 |
| 2008-07-25 10:15:00 | AAPL | Stock | 5.7616 | 5.7646 | 5.7429 | 5.76 | 14626136.0 |
| 2008-07-25 10:20:00 | AAPL | Stock | 5.7596 | 5.7614 | 5.7346 | 5.7371 | 10906336.0 |
| 2008-07-25 10:25:00 | AAPL | Stock | 5.7371 | 5.74 | 5.7186 | 5.7193 | 10216220.0 |
| 2008-07-25 10:30:00 | AAPL | Stock | 5.7193 | 5.7332 | 5.7132 | 5.7282 | 8228696.0 |
| 2008-07-25 10:35:00 | AAPL | Stock | 5.7268 | 5.7336 | 5.7179 | 5.7264 | 6718460.0 |
| 2008-07-25 10:40:00 | AAPL | Stock | 5.7264 | 5.7404 | 5.7264 | 5.7346 | 5910268.0 |
| 2008-07-25 10:45:00 | AAPL | Stock | 5.7346 | 5.7464 | 5.7332 | 5.7386 | 8674232.0 |
| 2008-07-25 10:50:00 | AAPL | Stock | 5.7386 | 5.7439 | 5.7268 | 5.7304 | 7281960.0 |
| 2008-07-25 10:55:00 | AAPL | Stock | 5.7318 | 5.7564 | 5.7279 | 5.75 | 8600228.0 |
| 2008-07-25 11:00:00 | AAPL | Stock | 5.7501 | 5.7539 | 5.7425 | 5.7514 | 5603444.0 |
| 2008-07-25 11:05:00 | AAPL | Stock | 5.7514 | 5.7539 | 5.7429 | 5.7468 | 4949504.0 |
| 2008-07-25 11:10:00 | AAPL | Stock | 5.7468 | 5.75 | 5.7343 | 5.7454 | 6471724.0 |
| 2008-07-25 11:15:00 | AAPL | Stock | 5.7454 | 5.75 | 5.7416 | 5.7479 | 3010280.0 |
| 2008-07-25 11:20:00 | AAPL | Stock | 5.7475 | 5.7568 | 5.7393 | 5.7457 | 6767180.0 |
| 2008-07-25 11:25:00 | AAPL | Stock | 5.7464 | 5.7464 | 5.74 | 5.745 | 3262084.0 |
| 2008-07-25 11:30:00 | AAPL | Stock | 5.7454 | 5.7604 | 5.7454 | 5.7523 | 7530124.0 |
| 2008-07-25 11:35:00 | AAPL | Stock | 5.7521 | 5.7679 | 5.7518 | 5.76 | 6906984.0 |
| 2008-07-25 11:40:00 | AAPL | Stock | 5.76 | 5.7661 | 5.7546 | 5.7614 | 6411132.0 |
| 2008-07-25 11:45:00 | AAPL | Stock | 5.7611 | 5.7711 | 5.7606 | 5.7632 | 6964076.0 |
> showing 50 of 316,261 rows — these rows as CSV