PREVIEW / stock_5min / 2010-08-30
file: by_date/stock_5min/2010/2010-08-30.parquet size: 4.5 MB rows: 313,580 symbols: 3,459
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 |
|---|---|---|---|---|---|---|---|
| 2010-08-30 06:55:00 | AAPL | Stock | 8.65 | 8.65 | 8.65 | 8.65 | 14000.0 |
| 2010-08-30 07:05:00 | AAPL | Stock | 8.6375 | 8.6375 | 8.6357 | 8.6357 | 19600.0 |
| 2010-08-30 07:10:00 | AAPL | Stock | 8.6286 | 8.6329 | 8.6271 | 8.6329 | 41832.0 |
| 2010-08-30 07:20:00 | AAPL | Stock | 8.6407 | 8.6407 | 8.6393 | 8.6393 | 5600.0 |
| 2010-08-30 07:25:00 | AAPL | Stock | 8.6254 | 8.6254 | 8.6254 | 8.6254 | 2800.0 |
| 2010-08-30 07:30:00 | AAPL | Stock | 8.6357 | 8.6393 | 8.6332 | 8.6393 | 28000.0 |
| 2010-08-30 07:35:00 | AAPL | Stock | 8.6489 | 8.6489 | 8.6489 | 8.6489 | 28000.0 |
| 2010-08-30 07:40:00 | AAPL | Stock | 8.6393 | 8.6393 | 8.6393 | 8.6393 | 28000.0 |
| 2010-08-30 08:00:00 | AAPL | Stock | 8.6329 | 8.6389 | 8.6257 | 8.6318 | 117096.0 |
| 2010-08-30 08:05:00 | AAPL | Stock | 8.63 | 8.6357 | 8.6286 | 8.6357 | 158396.0 |
| 2010-08-30 08:10:00 | AAPL | Stock | 8.6321 | 8.635 | 8.625 | 8.6257 | 155708.0 |
| 2010-08-30 08:15:00 | AAPL | Stock | 8.625 | 8.6261 | 8.625 | 8.6257 | 43316.0 |
| 2010-08-30 08:20:00 | AAPL | Stock | 8.625 | 8.625 | 8.6246 | 8.6246 | 19600.0 |
| 2010-08-30 08:25:00 | AAPL | Stock | 8.625 | 8.6336 | 8.615 | 8.625 | 126000.0 |
| 2010-08-30 08:30:00 | AAPL | Stock | 8.6246 | 8.6396 | 8.6246 | 8.6357 | 165424.0 |
| 2010-08-30 08:35:00 | AAPL | Stock | 8.6336 | 8.6389 | 8.6336 | 8.6375 | 137368.0 |
| 2010-08-30 08:40:00 | AAPL | Stock | 8.6375 | 8.6389 | 8.62 | 8.6304 | 133980.0 |
| 2010-08-30 08:45:00 | AAPL | Stock | 8.63 | 8.6379 | 8.63 | 8.6357 | 91000.0 |
| 2010-08-30 08:50:00 | AAPL | Stock | 8.6261 | 8.6318 | 8.6107 | 8.6207 | 362600.0 |
| 2010-08-30 08:55:00 | AAPL | Stock | 8.6157 | 8.6286 | 8.6157 | 8.6225 | 120400.0 |
| 2010-08-30 09:00:00 | AAPL | Stock | 8.6225 | 8.6257 | 8.6118 | 8.6136 | 152600.0 |
| 2010-08-30 09:05:00 | AAPL | Stock | 8.6196 | 8.6196 | 8.6146 | 8.6146 | 36400.0 |
| 2010-08-30 09:10:00 | AAPL | Stock | 8.6179 | 8.6196 | 8.6143 | 8.6182 | 70000.0 |
| 2010-08-30 09:20:00 | AAPL | Stock | 8.6186 | 8.6186 | 8.6143 | 8.6182 | 46620.0 |
| 2010-08-30 09:25:00 | AAPL | Stock | 8.6129 | 8.6129 | 8.5914 | 8.5989 | 236404.0 |
| 2010-08-30 09:30:00 | AAPL | Stock | 8.5986 | 8.6732 | 8.5957 | 8.6698 | 12681200.0 |
| 2010-08-30 09:35:00 | AAPL | Stock | 8.6679 | 8.725 | 8.6661 | 8.7221 | 17783136.0 |
| 2010-08-30 09:40:00 | AAPL | Stock | 8.7186 | 8.75 | 8.7168 | 8.7458 | 16646532.0 |
| 2010-08-30 09:45:00 | AAPL | Stock | 8.7457 | 8.7579 | 8.7332 | 8.7561 | 13107780.0 |
| 2010-08-30 09:50:00 | AAPL | Stock | 8.7564 | 8.7607 | 8.7329 | 8.7396 | 10595172.0 |
| 2010-08-30 09:55:00 | AAPL | Stock | 8.7382 | 8.7718 | 8.7382 | 8.7625 | 10283896.0 |
| 2010-08-30 10:00:00 | AAPL | Stock | 8.7625 | 8.7714 | 8.7461 | 8.7671 | 7707420.0 |
| 2010-08-30 10:05:00 | AAPL | Stock | 8.7654 | 8.7768 | 8.75 | 8.7582 | 9705752.0 |
| 2010-08-30 10:10:00 | AAPL | Stock | 8.7586 | 8.7607 | 8.7475 | 8.7589 | 4797800.0 |
| 2010-08-30 10:15:00 | AAPL | Stock | 8.7595 | 8.7595 | 8.7354 | 8.7429 | 6698384.0 |
| 2010-08-30 10:20:00 | AAPL | Stock | 8.7429 | 8.7496 | 8.7304 | 8.7411 | 7535976.0 |
| 2010-08-30 10:25:00 | AAPL | Stock | 8.7411 | 8.7479 | 8.7286 | 8.7464 | 5398092.0 |
| 2010-08-30 10:30:00 | AAPL | Stock | 8.7456 | 8.7456 | 8.7279 | 8.7368 | 4554704.0 |
| 2010-08-30 10:35:00 | AAPL | Stock | 8.7375 | 8.7461 | 8.7346 | 8.74 | 2984352.0 |
| 2010-08-30 10:40:00 | AAPL | Stock | 8.7393 | 8.7461 | 8.7346 | 8.7429 | 4334540.0 |
| 2010-08-30 10:45:00 | AAPL | Stock | 8.7446 | 8.75 | 8.7336 | 8.7482 | 3896340.0 |
| 2010-08-30 10:50:00 | AAPL | Stock | 8.7489 | 8.7646 | 8.7486 | 8.7646 | 5842340.0 |
| 2010-08-30 10:55:00 | AAPL | Stock | 8.7611 | 8.7671 | 8.7536 | 8.7582 | 4077892.0 |
| 2010-08-30 11:00:00 | AAPL | Stock | 8.7581 | 8.7604 | 8.7407 | 8.7439 | 4006548.0 |
| 2010-08-30 11:05:00 | AAPL | Stock | 8.7432 | 8.7607 | 8.7429 | 8.7582 | 3038700.0 |
| 2010-08-30 11:10:00 | AAPL | Stock | 8.7579 | 8.7589 | 8.7411 | 8.7434 | 2509892.0 |
| 2010-08-30 11:15:00 | AAPL | Stock | 8.7426 | 8.7479 | 8.7382 | 8.7439 | 2024288.0 |
| 2010-08-30 11:20:00 | AAPL | Stock | 8.7454 | 8.7461 | 8.7286 | 8.7354 | 3039260.0 |
| 2010-08-30 11:25:00 | AAPL | Stock | 8.735 | 8.7446 | 8.735 | 8.7422 | 1992004.0 |
| 2010-08-30 11:30:00 | AAPL | Stock | 8.7429 | 8.7446 | 8.7321 | 8.7339 | 1740256.0 |
> showing 50 of 313,580 rows — these rows as CSV