PREVIEW / stock_5min / 2006-09-26
file: by_date/stock_5min/2006/2006-09-26.parquet size: 3.2 MB rows: 230,289 symbols: 2,380
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 |
|---|---|---|---|---|---|---|---|
| 2006-09-26 04:45:00 | AAPL | Stock | 2.7057 | 2.7057 | 2.7057 | 2.7057 | 5600.0 |
| 2006-09-26 06:40:00 | AAPL | Stock | 2.7 | 2.7 | 2.7 | 2.7 | 2800.0 |
| 2006-09-26 07:30:00 | AAPL | Stock | 2.7057 | 2.7057 | 2.7057 | 2.7057 | 2800.0 |
| 2006-09-26 07:35:00 | AAPL | Stock | 2.7107 | 2.7196 | 2.7107 | 2.7196 | 205632.0 |
| 2006-09-26 07:40:00 | AAPL | Stock | 2.7196 | 2.7196 | 2.7196 | 2.7196 | 92400.0 |
| 2006-09-26 08:00:00 | AAPL | Stock | 2.7179 | 2.7193 | 2.7054 | 2.7179 | 1881180.0 |
| 2006-09-26 08:05:00 | AAPL | Stock | 2.7154 | 2.7214 | 2.715 | 2.7214 | 610596.0 |
| 2006-09-26 08:10:00 | AAPL | Stock | 2.7214 | 2.725 | 2.7193 | 2.7214 | 665672.0 |
| 2006-09-26 08:15:00 | AAPL | Stock | 2.7232 | 2.725 | 2.7196 | 2.72 | 302400.0 |
| 2006-09-26 08:20:00 | AAPL | Stock | 2.7211 | 2.7279 | 2.7211 | 2.725 | 528752.0 |
| 2006-09-26 08:25:00 | AAPL | Stock | 2.725 | 2.7271 | 2.725 | 2.7271 | 696780.0 |
| 2006-09-26 08:30:00 | AAPL | Stock | 2.7268 | 2.7271 | 2.7261 | 2.7261 | 287672.0 |
| 2006-09-26 08:35:00 | AAPL | Stock | 2.7261 | 2.7264 | 2.7261 | 2.7261 | 107576.0 |
| 2006-09-26 08:40:00 | AAPL | Stock | 2.7257 | 2.7264 | 2.725 | 2.7261 | 668500.0 |
| 2006-09-26 08:45:00 | AAPL | Stock | 2.7264 | 2.7271 | 2.7261 | 2.7264 | 378000.0 |
| 2006-09-26 08:50:00 | AAPL | Stock | 2.7261 | 2.7268 | 2.725 | 2.725 | 441700.0 |
| 2006-09-26 08:55:00 | AAPL | Stock | 2.725 | 2.7254 | 2.7221 | 2.7232 | 301476.0 |
| 2006-09-26 09:00:00 | AAPL | Stock | 2.7232 | 2.7232 | 2.7196 | 2.7232 | 447160.0 |
| 2006-09-26 09:05:00 | AAPL | Stock | 2.7232 | 2.7261 | 2.7232 | 2.7254 | 250600.0 |
| 2006-09-26 09:10:00 | AAPL | Stock | 2.725 | 2.7264 | 2.7243 | 2.725 | 234920.0 |
| 2006-09-26 09:15:00 | AAPL | Stock | 2.7232 | 2.725 | 2.7214 | 2.7232 | 183848.0 |
| 2006-09-26 09:20:00 | AAPL | Stock | 2.7218 | 2.7232 | 2.7182 | 2.7225 | 553840.0 |
| 2006-09-26 09:25:00 | AAPL | Stock | 2.7204 | 2.7214 | 2.7161 | 2.7204 | 558152.0 |
| 2006-09-26 09:30:00 | AAPL | Stock | 2.7207 | 2.7318 | 2.7179 | 2.7268 | 31267180.0 |
| 2006-09-26 09:35:00 | AAPL | Stock | 2.7268 | 2.7354 | 2.7214 | 2.7289 | 28747628.0 |
| 2006-09-26 09:40:00 | AAPL | Stock | 2.7289 | 2.7357 | 2.7261 | 2.7343 | 21485380.0 |
| 2006-09-26 09:45:00 | AAPL | Stock | 2.7346 | 2.7389 | 2.7286 | 2.735 | 20407100.0 |
| 2006-09-26 09:50:00 | AAPL | Stock | 2.7346 | 2.7379 | 2.7304 | 2.7307 | 17599064.0 |
| 2006-09-26 09:55:00 | AAPL | Stock | 2.7307 | 2.7321 | 2.725 | 2.7296 | 13178956.0 |
| 2006-09-26 10:00:00 | AAPL | Stock | 2.73 | 2.7418 | 2.73 | 2.7386 | 27155044.0 |
| 2006-09-26 10:05:00 | AAPL | Stock | 2.7389 | 2.7532 | 2.7379 | 2.7514 | 32834844.0 |
| 2006-09-26 10:10:00 | AAPL | Stock | 2.7514 | 2.76 | 2.7479 | 2.7561 | 31366300.0 |
| 2006-09-26 10:15:00 | AAPL | Stock | 2.7561 | 2.7593 | 2.7479 | 2.7496 | 22532832.0 |
| 2006-09-26 10:20:00 | AAPL | Stock | 2.75 | 2.7521 | 2.7464 | 2.75 | 21071960.0 |
| 2006-09-26 10:25:00 | AAPL | Stock | 2.75 | 2.7579 | 2.75 | 2.7511 | 15422540.0 |
| 2006-09-26 10:30:00 | AAPL | Stock | 2.7511 | 2.7536 | 2.7464 | 2.7514 | 12378604.0 |
| 2006-09-26 10:35:00 | AAPL | Stock | 2.7511 | 2.7529 | 2.7425 | 2.7461 | 15023484.0 |
| 2006-09-26 10:40:00 | AAPL | Stock | 2.7461 | 2.7521 | 2.7432 | 2.75 | 11009964.0 |
| 2006-09-26 10:45:00 | AAPL | Stock | 2.75 | 2.7504 | 2.7432 | 2.7435 | 9965564.0 |
| 2006-09-26 10:50:00 | AAPL | Stock | 2.7432 | 2.7439 | 2.7396 | 2.7432 | 13774628.0 |
| 2006-09-26 10:55:00 | AAPL | Stock | 2.7429 | 2.7486 | 2.7243 | 2.7464 | 8472884.0 |
| 2006-09-26 11:00:00 | AAPL | Stock | 2.7464 | 2.7554 | 2.7429 | 2.7536 | 11567724.0 |
| 2006-09-26 11:05:00 | AAPL | Stock | 2.7536 | 2.7568 | 2.7504 | 2.7521 | 11582844.0 |
| 2006-09-26 11:10:00 | AAPL | Stock | 2.7525 | 2.7529 | 2.7446 | 2.7482 | 9642192.0 |
| 2006-09-26 11:15:00 | AAPL | Stock | 2.7489 | 2.7536 | 2.7457 | 2.7482 | 8999564.0 |
| 2006-09-26 11:20:00 | AAPL | Stock | 2.7486 | 2.7529 | 2.7457 | 2.7521 | 7684992.0 |
| 2006-09-26 11:25:00 | AAPL | Stock | 2.7518 | 2.7543 | 2.7475 | 2.7536 | 13048672.0 |
| 2006-09-26 11:30:00 | AAPL | Stock | 2.7536 | 2.7589 | 2.7529 | 2.7571 | 14774480.0 |
| 2006-09-26 11:35:00 | AAPL | Stock | 2.7568 | 2.765 | 2.7554 | 2.76 | 18689300.0 |
| 2006-09-26 11:40:00 | AAPL | Stock | 2.7604 | 2.7643 | 2.7543 | 2.7586 | 12576900.0 |
> showing 50 of 230,289 rows — these rows as CSV