PREVIEW / stock_5min / 2008-09-25
file: by_date/stock_5min/2008/2008-09-25.parquet size: 4.4 MB rows: 320,109 symbols: 3,343
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-09-25 05:50:00 | AAPL | Stock | 4.6425 | 4.6425 | 4.6425 | 4.6425 | 28000.0 |
| 2008-09-25 06:30:00 | AAPL | Stock | 4.6429 | 4.6429 | 4.6429 | 4.6429 | 2800.0 |
| 2008-09-25 06:50:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 11200.0 |
| 2008-09-25 07:00:00 | AAPL | Stock | 4.6082 | 4.6082 | 4.6082 | 4.6082 | 2800.0 |
| 2008-09-25 07:10:00 | AAPL | Stock | 4.6339 | 4.6339 | 4.6107 | 4.625 | 16800.0 |
| 2008-09-25 07:15:00 | AAPL | Stock | 4.6207 | 4.6207 | 4.6207 | 4.6207 | 2800.0 |
| 2008-09-25 07:20:00 | AAPL | Stock | 4.6107 | 4.6107 | 4.6107 | 4.6107 | 30996.0 |
| 2008-09-25 07:25:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6064 | 4.6064 | 105224.0 |
| 2008-09-25 07:30:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5893 | 4.5893 | 2800.0 |
| 2008-09-25 07:35:00 | AAPL | Stock | 4.5893 | 4.5893 | 4.5714 | 4.5754 | 117740.0 |
| 2008-09-25 07:40:00 | AAPL | Stock | 4.5736 | 4.5739 | 4.5714 | 4.5732 | 129304.0 |
| 2008-09-25 07:45:00 | AAPL | Stock | 4.5732 | 4.5732 | 4.5679 | 4.5679 | 36960.0 |
| 2008-09-25 07:50:00 | AAPL | Stock | 4.5664 | 4.5664 | 4.5489 | 4.5489 | 92260.0 |
| 2008-09-25 07:55:00 | AAPL | Stock | 4.5661 | 4.5661 | 4.5564 | 4.5661 | 61600.0 |
| 2008-09-25 08:00:00 | AAPL | Stock | 4.5711 | 4.6046 | 4.5696 | 4.6018 | 448644.0 |
| 2008-09-25 08:05:00 | AAPL | Stock | 4.5861 | 4.6036 | 4.5861 | 4.6 | 158900.0 |
| 2008-09-25 08:10:00 | AAPL | Stock | 4.5989 | 4.6125 | 4.5936 | 4.6125 | 317240.0 |
| 2008-09-25 08:15:00 | AAPL | Stock | 4.6143 | 4.6296 | 4.6143 | 4.6179 | 884156.0 |
| 2008-09-25 08:20:00 | AAPL | Stock | 4.6179 | 4.6332 | 4.6161 | 4.6268 | 672896.0 |
| 2008-09-25 08:25:00 | AAPL | Stock | 4.6286 | 4.6318 | 4.6179 | 4.625 | 926100.0 |
| 2008-09-25 08:30:00 | AAPL | Stock | 4.6275 | 4.6304 | 4.6 | 4.6157 | 1015056.0 |
| 2008-09-25 08:35:00 | AAPL | Stock | 4.6164 | 4.6296 | 4.6143 | 4.6254 | 537180.0 |
| 2008-09-25 08:40:00 | AAPL | Stock | 4.6261 | 4.6329 | 4.6254 | 4.6254 | 404880.0 |
| 2008-09-25 08:45:00 | AAPL | Stock | 4.6254 | 4.6254 | 4.6186 | 4.6239 | 361340.0 |
| 2008-09-25 08:50:00 | AAPL | Stock | 4.625 | 4.625 | 4.6204 | 4.6221 | 223720.0 |
| 2008-09-25 08:55:00 | AAPL | Stock | 4.6232 | 4.6232 | 4.6186 | 4.6229 | 389900.0 |
| 2008-09-25 09:00:00 | AAPL | Stock | 4.6246 | 4.6289 | 4.6214 | 4.6261 | 230300.0 |
| 2008-09-25 09:05:00 | AAPL | Stock | 4.6268 | 4.6271 | 4.6204 | 4.6204 | 194628.0 |
| 2008-09-25 09:10:00 | AAPL | Stock | 4.6196 | 4.62 | 4.6014 | 4.6021 | 728840.0 |
| 2008-09-25 09:15:00 | AAPL | Stock | 4.6029 | 4.6275 | 4.6029 | 4.6232 | 915376.0 |
| 2008-09-25 09:20:00 | AAPL | Stock | 4.6204 | 4.6232 | 4.6146 | 4.6211 | 213500.0 |
| 2008-09-25 09:25:00 | AAPL | Stock | 4.6204 | 4.6407 | 4.6179 | 4.6364 | 455504.0 |
| 2008-09-25 09:30:00 | AAPL | Stock | 4.6364 | 4.6489 | 4.59 | 4.6071 | 23251900.0 |
| 2008-09-25 09:35:00 | AAPL | Stock | 4.6064 | 4.6439 | 4.6057 | 4.6289 | 21031556.0 |
| 2008-09-25 09:40:00 | AAPL | Stock | 4.6289 | 4.6564 | 4.6289 | 4.6415 | 19143152.0 |
| 2008-09-25 09:45:00 | AAPL | Stock | 4.6414 | 4.6661 | 4.6311 | 4.6411 | 19688228.0 |
| 2008-09-25 09:50:00 | AAPL | Stock | 4.6411 | 4.6543 | 4.625 | 4.625 | 16637012.0 |
| 2008-09-25 09:55:00 | AAPL | Stock | 4.625 | 4.635 | 4.6125 | 4.6268 | 19803056.0 |
| 2008-09-25 10:00:00 | AAPL | Stock | 4.625 | 4.6493 | 4.6125 | 4.6311 | 14634452.0 |
| 2008-09-25 10:05:00 | AAPL | Stock | 4.6325 | 4.6925 | 4.6271 | 4.6661 | 21203224.0 |
| 2008-09-25 10:10:00 | AAPL | Stock | 4.6661 | 4.6714 | 4.6518 | 4.6675 | 18307016.0 |
| 2008-09-25 10:15:00 | AAPL | Stock | 4.6679 | 4.6886 | 4.6607 | 4.6643 | 20530496.0 |
| 2008-09-25 10:20:00 | AAPL | Stock | 4.6643 | 4.671 | 4.6536 | 4.6657 | 14671804.0 |
| 2008-09-25 10:25:00 | AAPL | Stock | 4.665 | 4.6832 | 4.6636 | 4.6779 | 13487936.0 |
| 2008-09-25 10:30:00 | AAPL | Stock | 4.6779 | 4.7011 | 4.6761 | 4.6929 | 21110208.0 |
| 2008-09-25 10:35:00 | AAPL | Stock | 4.6925 | 4.6989 | 4.6714 | 4.6907 | 17482948.0 |
| 2008-09-25 10:40:00 | AAPL | Stock | 4.69 | 4.7068 | 4.6861 | 4.6993 | 14676844.0 |
| 2008-09-25 10:45:00 | AAPL | Stock | 4.6996 | 4.7107 | 4.6896 | 4.6968 | 12757472.0 |
| 2008-09-25 10:50:00 | AAPL | Stock | 4.6971 | 4.7039 | 4.6796 | 4.6864 | 9844688.0 |
| 2008-09-25 10:55:00 | AAPL | Stock | 4.6864 | 4.689 | 4.6754 | 4.6886 | 8032080.0 |
> showing 50 of 320,109 rows — these rows as CSV