PREVIEW / stock_5min / 2006-09-29
file: by_date/stock_5min/2006/2006-09-29.parquet size: 3.1 MB rows: 227,490 symbols: 2,387
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-29 07:30:00 | AAPL | Stock | 2.7607 | 2.7607 | 2.7607 | 2.7607 | 2800.0 |
| 2006-09-29 07:40:00 | AAPL | Stock | 2.7604 | 2.7611 | 2.7604 | 2.7611 | 16800.0 |
| 2006-09-29 07:50:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.7621 | 2.7621 | 8400.0 |
| 2006-09-29 07:55:00 | AAPL | Stock | 2.7632 | 2.7632 | 2.7632 | 2.7632 | 5600.0 |
| 2006-09-29 08:00:00 | AAPL | Stock | 2.7625 | 2.7661 | 2.7607 | 2.7607 | 227780.0 |
| 2006-09-29 08:05:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.76 | 2.7607 | 68600.0 |
| 2006-09-29 08:10:00 | AAPL | Stock | 2.7607 | 2.7671 | 2.7607 | 2.7671 | 277200.0 |
| 2006-09-29 08:15:00 | AAPL | Stock | 2.7661 | 2.7679 | 2.7661 | 2.7668 | 217476.0 |
| 2006-09-29 08:20:00 | AAPL | Stock | 2.7671 | 2.7679 | 2.7671 | 2.7671 | 119392.0 |
| 2006-09-29 08:25:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7639 | 2.7643 | 66920.0 |
| 2006-09-29 08:30:00 | AAPL | Stock | 2.7621 | 2.7668 | 2.7618 | 2.7661 | 374640.0 |
| 2006-09-29 08:35:00 | AAPL | Stock | 2.7661 | 2.7661 | 2.7607 | 2.7607 | 14980.0 |
| 2006-09-29 08:40:00 | AAPL | Stock | 2.7643 | 2.7643 | 2.7625 | 2.7625 | 64120.0 |
| 2006-09-29 08:45:00 | AAPL | Stock | 2.7643 | 2.7661 | 2.7625 | 2.7643 | 207620.0 |
| 2006-09-29 08:50:00 | AAPL | Stock | 2.7646 | 2.7679 | 2.7643 | 2.7643 | 105140.0 |
| 2006-09-29 08:55:00 | AAPL | Stock | 2.7632 | 2.7639 | 2.7632 | 2.7639 | 78400.0 |
| 2006-09-29 09:00:00 | AAPL | Stock | 2.7643 | 2.7664 | 2.7639 | 2.7664 | 33600.0 |
| 2006-09-29 09:05:00 | AAPL | Stock | 2.7654 | 2.7654 | 2.7654 | 2.7654 | 8400.0 |
| 2006-09-29 09:10:00 | AAPL | Stock | 2.765 | 2.7654 | 2.7632 | 2.7643 | 195160.0 |
| 2006-09-29 09:15:00 | AAPL | Stock | 2.7636 | 2.7636 | 2.7636 | 2.7636 | 5600.0 |
| 2006-09-29 09:20:00 | AAPL | Stock | 2.7636 | 2.7636 | 2.7625 | 2.7625 | 64400.0 |
| 2006-09-29 09:25:00 | AAPL | Stock | 2.7625 | 2.7625 | 2.7532 | 2.7539 | 390012.0 |
| 2006-09-29 09:30:00 | AAPL | Stock | 2.7539 | 2.7686 | 2.7536 | 2.7604 | 18737544.0 |
| 2006-09-29 09:35:00 | AAPL | Stock | 2.76 | 2.7618 | 2.7539 | 2.7568 | 14526988.0 |
| 2006-09-29 09:40:00 | AAPL | Stock | 2.7564 | 2.7564 | 2.7404 | 2.7407 | 17778236.0 |
| 2006-09-29 09:45:00 | AAPL | Stock | 2.7407 | 2.745 | 2.7393 | 2.7425 | 11756444.0 |
| 2006-09-29 09:50:00 | AAPL | Stock | 2.7429 | 2.7471 | 2.7386 | 2.7407 | 11115804.0 |
| 2006-09-29 09:55:00 | AAPL | Stock | 2.7404 | 2.7521 | 2.7404 | 2.7486 | 10714172.0 |
| 2006-09-29 10:00:00 | AAPL | Stock | 2.7493 | 2.7568 | 2.7454 | 2.7539 | 15179892.0 |
| 2006-09-29 10:05:00 | AAPL | Stock | 2.7539 | 2.7589 | 2.7514 | 2.7521 | 12678120.0 |
| 2006-09-29 10:10:00 | AAPL | Stock | 2.7518 | 2.7575 | 2.7507 | 2.7561 | 6687632.0 |
| 2006-09-29 10:15:00 | AAPL | Stock | 2.7564 | 2.7582 | 2.7521 | 2.7554 | 3986220.0 |
| 2006-09-29 10:20:00 | AAPL | Stock | 2.755 | 2.7575 | 2.7521 | 2.7532 | 5309864.0 |
| 2006-09-29 10:25:00 | AAPL | Stock | 2.7532 | 2.7564 | 2.7507 | 2.7525 | 4051600.0 |
| 2006-09-29 10:30:00 | AAPL | Stock | 2.7525 | 2.755 | 2.75 | 2.7518 | 7108892.0 |
| 2006-09-29 10:35:00 | AAPL | Stock | 2.7514 | 2.7543 | 2.75 | 2.7504 | 7609560.0 |
| 2006-09-29 10:40:00 | AAPL | Stock | 2.7504 | 2.7532 | 2.7489 | 2.7521 | 8361780.0 |
| 2006-09-29 10:45:00 | AAPL | Stock | 2.7521 | 2.755 | 2.7518 | 2.7525 | 7852236.0 |
| 2006-09-29 10:50:00 | AAPL | Stock | 2.7529 | 2.7536 | 2.75 | 2.7525 | 7326060.0 |
| 2006-09-29 10:55:00 | AAPL | Stock | 2.7522 | 2.7536 | 2.7504 | 2.7525 | 4083968.0 |
| 2006-09-29 11:00:00 | AAPL | Stock | 2.7518 | 2.7539 | 2.7507 | 2.7511 | 3524584.0 |
| 2006-09-29 11:05:00 | AAPL | Stock | 2.751 | 2.7546 | 2.7504 | 2.7543 | 5397084.0 |
| 2006-09-29 11:10:00 | AAPL | Stock | 2.7543 | 2.755 | 2.7511 | 2.7532 | 4158392.0 |
| 2006-09-29 11:15:00 | AAPL | Stock | 2.7529 | 2.7539 | 2.7511 | 2.7514 | 4302396.0 |
| 2006-09-29 11:20:00 | AAPL | Stock | 2.7517 | 2.7518 | 2.7489 | 2.7493 | 5428332.0 |
| 2006-09-29 11:25:00 | AAPL | Stock | 2.7493 | 2.7496 | 2.7461 | 2.7482 | 4631004.0 |
| 2006-09-29 11:30:00 | AAPL | Stock | 2.7479 | 2.7507 | 2.7475 | 2.7475 | 4396112.0 |
| 2006-09-29 11:35:00 | AAPL | Stock | 2.7479 | 2.7525 | 2.7471 | 2.7521 | 3775324.0 |
| 2006-09-29 11:40:00 | AAPL | Stock | 2.7525 | 2.7529 | 2.7504 | 2.7507 | 1930292.0 |
| 2006-09-29 11:45:00 | AAPL | Stock | 2.7507 | 2.7546 | 2.7504 | 2.7539 | 5216148.0 |
> showing 50 of 227,490 rows — these rows as CSV