PREVIEW / stock_5min / 2007-10-23
file: by_date/stock_5min/2007/2007-10-23.parquet size: 4.2 MB rows: 307,074 symbols: 3,153
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-10-23 04:15:00 | AAPL | Stock | 6.6436 | 6.6436 | 6.6432 | 6.6432 | 76748.0 |
| 2007-10-23 04:30:00 | AAPL | Stock | 6.6432 | 6.6486 | 6.6432 | 6.6486 | 85652.0 |
| 2007-10-23 04:35:00 | AAPL | Stock | 6.6336 | 6.6336 | 6.6336 | 6.6336 | 2800.0 |
| 2007-10-23 04:40:00 | AAPL | Stock | 6.6336 | 6.6336 | 6.6336 | 6.6336 | 11200.0 |
| 2007-10-23 04:55:00 | AAPL | Stock | 6.6257 | 6.6257 | 6.6257 | 6.6257 | 5600.0 |
| 2007-10-23 06:05:00 | AAPL | Stock | 6.6393 | 6.6468 | 6.6393 | 6.6468 | 47600.0 |
| 2007-10-23 06:10:00 | AAPL | Stock | 6.6507 | 6.6507 | 6.6436 | 6.6436 | 16800.0 |
| 2007-10-23 06:15:00 | AAPL | Stock | 6.6436 | 6.6436 | 6.6436 | 6.6436 | 5600.0 |
| 2007-10-23 06:25:00 | AAPL | Stock | 6.6511 | 6.6579 | 6.6511 | 6.6579 | 21980.0 |
| 2007-10-23 06:30:00 | AAPL | Stock | 6.6607 | 6.6607 | 6.6607 | 6.6607 | 8400.0 |
| 2007-10-23 06:35:00 | AAPL | Stock | 6.6607 | 6.6636 | 6.6607 | 6.6636 | 38192.0 |
| 2007-10-23 06:40:00 | AAPL | Stock | 6.6511 | 6.6521 | 6.6507 | 6.6521 | 24052.0 |
| 2007-10-23 06:55:00 | AAPL | Stock | 6.6661 | 6.6925 | 6.6661 | 6.6925 | 162400.0 |
| 2007-10-23 07:00:00 | AAPL | Stock | 6.6857 | 6.71 | 6.6786 | 6.71 | 497168.0 |
| 2007-10-23 07:05:00 | AAPL | Stock | 6.71 | 6.71 | 6.6911 | 6.6911 | 174720.0 |
| 2007-10-23 07:10:00 | AAPL | Stock | 6.6943 | 6.6943 | 6.6636 | 6.6821 | 289576.0 |
| 2007-10-23 07:15:00 | AAPL | Stock | 6.6786 | 6.7125 | 6.6786 | 6.7107 | 302092.0 |
| 2007-10-23 07:20:00 | AAPL | Stock | 6.7036 | 6.7275 | 6.6914 | 6.71 | 875308.0 |
| 2007-10-23 07:25:00 | AAPL | Stock | 6.7161 | 6.7161 | 6.6843 | 6.6875 | 772716.0 |
| 2007-10-23 07:30:00 | AAPL | Stock | 6.6907 | 6.6961 | 6.6754 | 6.6839 | 708960.0 |
| 2007-10-23 07:35:00 | AAPL | Stock | 6.6843 | 6.705 | 6.6814 | 6.7021 | 1048712.0 |
| 2007-10-23 07:40:00 | AAPL | Stock | 6.7021 | 6.7118 | 6.7021 | 6.7089 | 904988.0 |
| 2007-10-23 07:45:00 | AAPL | Stock | 6.7089 | 6.7107 | 6.6846 | 6.705 | 660408.0 |
| 2007-10-23 07:50:00 | AAPL | Stock | 6.6914 | 6.7143 | 6.6879 | 6.7143 | 915208.0 |
| 2007-10-23 07:55:00 | AAPL | Stock | 6.7125 | 6.7136 | 6.6971 | 6.7125 | 534828.0 |
| 2007-10-23 08:00:00 | AAPL | Stock | 6.7071 | 6.7393 | 6.6821 | 6.7161 | 7356328.0 |
| 2007-10-23 08:05:00 | AAPL | Stock | 6.7143 | 6.7282 | 6.7143 | 6.7218 | 2686404.0 |
| 2007-10-23 08:10:00 | AAPL | Stock | 6.7214 | 6.7229 | 6.6789 | 6.6811 | 3027640.0 |
| 2007-10-23 08:15:00 | AAPL | Stock | 6.6811 | 6.695 | 6.6768 | 6.6875 | 2714152.0 |
| 2007-10-23 08:20:00 | AAPL | Stock | 6.6875 | 6.6961 | 6.6786 | 6.6786 | 2064944.0 |
| 2007-10-23 08:25:00 | AAPL | Stock | 6.6793 | 6.6946 | 6.6721 | 6.6946 | 1909628.0 |
| 2007-10-23 08:30:00 | AAPL | Stock | 6.6946 | 6.7121 | 6.6875 | 6.7018 | 3989804.0 |
| 2007-10-23 08:35:00 | AAPL | Stock | 6.7004 | 6.71 | 6.6971 | 6.6982 | 1899744.0 |
| 2007-10-23 08:40:00 | AAPL | Stock | 6.6996 | 7.0575 | 6.6843 | 6.6925 | 2261504.0 |
| 2007-10-23 08:45:00 | AAPL | Stock | 6.6925 | 6.6964 | 6.6839 | 6.6946 | 1874180.0 |
| 2007-10-23 08:50:00 | AAPL | Stock | 6.6921 | 6.7107 | 6.6893 | 6.7104 | 3812312.0 |
| 2007-10-23 08:55:00 | AAPL | Stock | 6.7096 | 6.7125 | 6.7018 | 6.7061 | 1732220.0 |
| 2007-10-23 09:00:00 | AAPL | Stock | 6.705 | 6.7389 | 6.705 | 6.7314 | 5281164.0 |
| 2007-10-23 09:05:00 | AAPL | Stock | 6.7321 | 6.755 | 6.7143 | 6.7507 | 5934572.0 |
| 2007-10-23 09:10:00 | AAPL | Stock | 6.7504 | 6.7746 | 6.7471 | 6.7721 | 5795412.0 |
| 2007-10-23 09:15:00 | AAPL | Stock | 6.7721 | 6.7768 | 6.7564 | 6.7707 | 3845772.0 |
| 2007-10-23 09:20:00 | AAPL | Stock | 6.7704 | 6.7768 | 6.7504 | 6.7504 | 4646208.0 |
| 2007-10-23 09:25:00 | AAPL | Stock | 6.7507 | 6.7629 | 6.7211 | 6.7321 | 9072644.0 |
| 2007-10-23 09:30:00 | AAPL | Stock | 6.7332 | 6.7357 | 6.612 | 6.6204 | 131529524.0 |
| 2007-10-23 09:35:00 | AAPL | Stock | 6.6221 | 6.6346 | 6.5271 | 6.6043 | 133421960.0 |
| 2007-10-23 09:40:00 | AAPL | Stock | 6.6043 | 6.64 | 6.5936 | 6.6382 | 78904588.0 |
| 2007-10-23 09:45:00 | AAPL | Stock | 6.6386 | 6.6586 | 6.5618 | 6.6343 | 65674364.0 |
| 2007-10-23 09:50:00 | AAPL | Stock | 6.635 | 6.6554 | 6.6254 | 6.6546 | 46129916.0 |
| 2007-10-23 09:55:00 | AAPL | Stock | 6.6532 | 6.6579 | 6.605 | 6.6357 | 43342208.0 |
| 2007-10-23 10:00:00 | AAPL | Stock | 6.6368 | 6.6493 | 6.6286 | 6.6321 | 32300884.0 |
> showing 50 of 307,074 rows — these rows as CSV