PREVIEW / stock_1min / 2007-08-24
file: by_date/stock_1min/2007/2007-08-24.parquet size: 11.0 MB rows: 903,824 symbols: 2,539
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 |
|---|---|---|---|---|---|---|---|
| 2007-08-24 09:30:00 | AAPL | Stock | 4.6618 | 4.68 | 4.6536 | 4.675 | 9975140.0 |
| 2007-08-24 09:31:00 | AAPL | Stock | 4.6754 | 4.6839 | 4.6661 | 4.6671 | 3828188.0 |
| 2007-08-24 09:32:00 | AAPL | Stock | 4.6661 | 4.6686 | 4.6546 | 4.6575 | 3049200.0 |
| 2007-08-24 09:33:00 | AAPL | Stock | 4.6582 | 4.6618 | 4.6468 | 4.6568 | 3482304.0 |
| 2007-08-24 09:34:00 | AAPL | Stock | 4.6579 | 4.6636 | 4.6514 | 4.6604 | 2417576.0 |
| 2007-08-24 09:35:00 | AAPL | Stock | 4.6611 | 4.6621 | 4.6521 | 4.6575 | 1451940.0 |
| 2007-08-24 09:36:00 | AAPL | Stock | 4.6568 | 4.6607 | 4.6525 | 4.6582 | 1627920.0 |
| 2007-08-24 09:37:00 | AAPL | Stock | 4.6593 | 4.6661 | 4.6574 | 4.6589 | 2098628.0 |
| 2007-08-24 09:38:00 | AAPL | Stock | 4.6589 | 4.6618 | 4.6543 | 4.6589 | 1204980.0 |
| 2007-08-24 09:39:00 | AAPL | Stock | 4.6586 | 4.6587 | 4.6361 | 4.645 | 5673080.0 |
| 2007-08-24 09:40:00 | AAPL | Stock | 4.6454 | 4.6532 | 4.6411 | 4.6529 | 2514904.0 |
| 2007-08-24 09:41:00 | AAPL | Stock | 4.6532 | 4.6618 | 4.6511 | 4.6557 | 2610832.0 |
| 2007-08-24 09:42:00 | AAPL | Stock | 4.6546 | 4.6607 | 4.6546 | 4.658 | 1177512.0 |
| 2007-08-24 09:43:00 | AAPL | Stock | 4.6582 | 4.6582 | 4.6504 | 4.6561 | 1874796.0 |
| 2007-08-24 09:44:00 | AAPL | Stock | 4.6554 | 4.6571 | 4.6518 | 4.6532 | 1203944.0 |
| 2007-08-24 09:45:00 | AAPL | Stock | 4.6525 | 4.6604 | 4.6482 | 4.6581 | 1508416.0 |
| 2007-08-24 09:46:00 | AAPL | Stock | 4.6604 | 4.6696 | 4.6546 | 4.6696 | 2465344.0 |
| 2007-08-24 09:47:00 | AAPL | Stock | 4.6677 | 4.6743 | 4.6639 | 4.6668 | 2720284.0 |
| 2007-08-24 09:48:00 | AAPL | Stock | 4.6668 | 4.675 | 4.6643 | 4.6714 | 2622340.0 |
| 2007-08-24 09:49:00 | AAPL | Stock | 4.6714 | 4.6746 | 4.6661 | 4.6675 | 2448488.0 |
| 2007-08-24 09:50:00 | AAPL | Stock | 4.6679 | 4.6725 | 4.6671 | 4.6704 | 1064868.0 |
| 2007-08-24 09:51:00 | AAPL | Stock | 4.6704 | 4.6764 | 4.6686 | 4.6745 | 1683052.0 |
| 2007-08-24 09:52:00 | AAPL | Stock | 4.6764 | 4.6875 | 4.6747 | 4.6875 | 4499348.0 |
| 2007-08-24 09:53:00 | AAPL | Stock | 4.6875 | 4.6989 | 4.6864 | 4.6939 | 5766012.0 |
| 2007-08-24 09:54:00 | AAPL | Stock | 4.6936 | 4.6957 | 4.6836 | 4.6871 | 4786404.0 |
| 2007-08-24 09:55:00 | AAPL | Stock | 4.6868 | 4.6921 | 4.6793 | 4.6914 | 2368156.0 |
| 2007-08-24 09:56:00 | AAPL | Stock | 4.6911 | 4.6954 | 4.6846 | 4.6871 | 2575300.0 |
| 2007-08-24 09:57:00 | AAPL | Stock | 4.6868 | 4.6918 | 4.6829 | 4.6904 | 2234904.0 |
| 2007-08-24 09:58:00 | AAPL | Stock | 4.69 | 4.6914 | 4.6839 | 4.6861 | 1665468.0 |
| 2007-08-24 09:59:00 | AAPL | Stock | 4.6864 | 4.6914 | 4.6864 | 4.6893 | 1739024.0 |
| 2007-08-24 10:00:00 | AAPL | Stock | 4.6893 | 4.7054 | 4.6893 | 4.7036 | 4897620.0 |
| 2007-08-24 10:01:00 | AAPL | Stock | 4.7046 | 4.7143 | 4.7004 | 4.7143 | 5653480.0 |
| 2007-08-24 10:02:00 | AAPL | Stock | 4.7143 | 4.7143 | 4.7082 | 4.7096 | 7158312.0 |
| 2007-08-24 10:03:00 | AAPL | Stock | 4.7089 | 4.7143 | 4.6957 | 4.6968 | 5755484.0 |
| 2007-08-24 10:04:00 | AAPL | Stock | 4.6958 | 4.7089 | 4.6957 | 4.7071 | 3917144.0 |
| 2007-08-24 10:05:00 | AAPL | Stock | 4.7075 | 4.7089 | 4.7 | 4.7039 | 2948652.0 |
| 2007-08-24 10:06:00 | AAPL | Stock | 4.7032 | 4.7143 | 4.7025 | 4.7143 | 3836840.0 |
| 2007-08-24 10:07:00 | AAPL | Stock | 4.7143 | 4.7282 | 4.7136 | 4.7257 | 8753640.0 |
| 2007-08-24 10:08:00 | AAPL | Stock | 4.7264 | 4.7379 | 4.7214 | 4.7311 | 6594868.0 |
| 2007-08-24 10:09:00 | AAPL | Stock | 4.7311 | 4.7346 | 4.7236 | 4.73 | 4962244.0 |
| 2007-08-24 10:10:00 | AAPL | Stock | 4.7296 | 4.7332 | 4.7254 | 4.7318 | 3749844.0 |
| 2007-08-24 10:11:00 | AAPL | Stock | 4.7329 | 4.7429 | 4.7325 | 4.7357 | 5484780.0 |
| 2007-08-24 10:12:00 | AAPL | Stock | 4.7361 | 4.7393 | 4.7307 | 4.7325 | 4566632.0 |
| 2007-08-24 10:13:00 | AAPL | Stock | 4.7332 | 4.7379 | 4.7289 | 4.7289 | 3244836.0 |
| 2007-08-24 10:14:00 | AAPL | Stock | 4.7296 | 4.7304 | 4.7236 | 4.7254 | 3475612.0 |
| 2007-08-24 10:15:00 | AAPL | Stock | 4.7257 | 4.7264 | 4.72 | 4.7232 | 3523548.0 |
| 2007-08-24 10:16:00 | AAPL | Stock | 4.7232 | 4.7275 | 4.7204 | 4.7246 | 2356620.0 |
| 2007-08-24 10:17:00 | AAPL | Stock | 4.725 | 4.7371 | 4.7239 | 4.7337 | 3171504.0 |
| 2007-08-24 10:18:00 | AAPL | Stock | 4.7346 | 4.7436 | 4.7336 | 4.7379 | 4437384.0 |
| 2007-08-24 10:19:00 | AAPL | Stock | 4.7386 | 4.7429 | 4.7375 | 4.7404 | 3739624.0 |
> showing 50 of 903,824 rows — these rows as CSV