PREVIEW / stock_5min / 2010-08-24
file: by_date/stock_5min/2010/2010-08-24.parquet size: 4.8 MB rows: 329,169 symbols: 3,474
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-24 04:00:00 | AAPL | Stock | 8.75 | 8.75 | 8.75 | 8.75 | 11200.0 |
| 2010-08-24 07:05:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7232 | 8.7232 | 16800.0 |
| 2010-08-24 07:10:00 | AAPL | Stock | 8.7232 | 8.7232 | 8.7054 | 8.7143 | 35448.0 |
| 2010-08-24 07:15:00 | AAPL | Stock | 8.7143 | 8.7143 | 8.7071 | 8.7107 | 25200.0 |
| 2010-08-24 07:20:00 | AAPL | Stock | 8.7107 | 8.7143 | 8.7107 | 8.7107 | 35924.0 |
| 2010-08-24 07:25:00 | AAPL | Stock | 8.7057 | 8.7071 | 8.6964 | 8.6975 | 68516.0 |
| 2010-08-24 07:30:00 | AAPL | Stock | 8.6975 | 8.7089 | 8.6929 | 8.7089 | 119056.0 |
| 2010-08-24 07:45:00 | AAPL | Stock | 8.6929 | 8.6964 | 8.6929 | 8.6929 | 23296.0 |
| 2010-08-24 07:50:00 | AAPL | Stock | 8.6946 | 8.6946 | 8.6946 | 8.6946 | 2800.0 |
| 2010-08-24 07:55:00 | AAPL | Stock | 8.6964 | 8.6964 | 8.6946 | 8.6957 | 43540.0 |
| 2010-08-24 08:00:00 | AAPL | Stock | 8.7036 | 8.7446 | 8.6946 | 8.6982 | 487956.0 |
| 2010-08-24 08:05:00 | AAPL | Stock | 8.6982 | 8.7032 | 8.6929 | 8.6946 | 254436.0 |
| 2010-08-24 08:10:00 | AAPL | Stock | 8.6993 | 8.7 | 8.6696 | 8.6696 | 388836.0 |
| 2010-08-24 08:15:00 | AAPL | Stock | 8.6696 | 8.6775 | 8.6607 | 8.6679 | 435820.0 |
| 2010-08-24 08:20:00 | AAPL | Stock | 8.6643 | 8.6711 | 8.6607 | 8.6711 | 85260.0 |
| 2010-08-24 08:25:00 | AAPL | Stock | 8.6714 | 8.675 | 8.6643 | 8.6679 | 168000.0 |
| 2010-08-24 08:30:00 | AAPL | Stock | 8.6746 | 8.6796 | 8.6679 | 8.6707 | 269136.0 |
| 2010-08-24 08:35:00 | AAPL | Stock | 8.6732 | 8.6786 | 8.6707 | 8.6721 | 161700.0 |
| 2010-08-24 08:40:00 | AAPL | Stock | 8.67 | 8.675 | 8.67 | 8.675 | 86016.0 |
| 2010-08-24 08:45:00 | AAPL | Stock | 8.6768 | 8.6775 | 8.67 | 8.6704 | 164192.0 |
| 2010-08-24 08:50:00 | AAPL | Stock | 8.6714 | 8.6732 | 8.6429 | 8.6586 | 603568.0 |
| 2010-08-24 08:55:00 | AAPL | Stock | 8.6525 | 8.6604 | 8.6418 | 8.6536 | 272132.0 |
| 2010-08-24 09:00:00 | AAPL | Stock | 8.6486 | 8.6496 | 8.6443 | 8.6443 | 344624.0 |
| 2010-08-24 09:05:00 | AAPL | Stock | 8.6454 | 8.6496 | 8.6361 | 8.6496 | 481768.0 |
| 2010-08-24 09:10:00 | AAPL | Stock | 8.6464 | 8.6571 | 8.6429 | 8.6507 | 282464.0 |
| 2010-08-24 09:15:00 | AAPL | Stock | 8.6529 | 8.6529 | 8.6432 | 8.6475 | 269360.0 |
| 2010-08-24 09:20:00 | AAPL | Stock | 8.6475 | 8.6575 | 8.6471 | 8.65 | 143892.0 |
| 2010-08-24 09:25:00 | AAPL | Stock | 8.6507 | 8.6818 | 8.6482 | 8.675 | 407680.0 |
| 2010-08-24 09:30:00 | AAPL | Stock | 8.6668 | 8.6786 | 8.6361 | 8.6407 | 29699908.0 |
| 2010-08-24 09:35:00 | AAPL | Stock | 8.6403 | 8.6482 | 8.6082 | 8.6136 | 19864712.0 |
| 2010-08-24 09:40:00 | AAPL | Stock | 8.6143 | 8.6371 | 8.5857 | 8.6175 | 25480224.0 |
| 2010-08-24 09:45:00 | AAPL | Stock | 8.6175 | 8.6354 | 8.6 | 8.6196 | 12405400.0 |
| 2010-08-24 09:50:00 | AAPL | Stock | 8.6196 | 8.6214 | 8.5768 | 8.5771 | 12038544.0 |
| 2010-08-24 09:55:00 | AAPL | Stock | 8.5771 | 8.6064 | 8.5754 | 8.5875 | 14097048.0 |
| 2010-08-24 10:00:00 | AAPL | Stock | 8.5871 | 8.5875 | 8.5232 | 8.5529 | 41280540.0 |
| 2010-08-24 10:05:00 | AAPL | Stock | 8.5539 | 8.5643 | 8.5414 | 8.5551 | 12341476.0 |
| 2010-08-24 10:10:00 | AAPL | Stock | 8.5539 | 8.5786 | 8.5536 | 8.5678 | 13794704.0 |
| 2010-08-24 10:15:00 | AAPL | Stock | 8.5679 | 8.6089 | 8.5664 | 8.6021 | 20386632.0 |
| 2010-08-24 10:20:00 | AAPL | Stock | 8.6014 | 8.6189 | 8.5893 | 8.5921 | 13210400.0 |
| 2010-08-24 10:25:00 | AAPL | Stock | 8.5911 | 8.6118 | 8.5846 | 8.5875 | 9618336.0 |
| 2010-08-24 10:30:00 | AAPL | Stock | 8.5857 | 8.5914 | 8.5696 | 8.5714 | 7871360.0 |
| 2010-08-24 10:35:00 | AAPL | Stock | 8.5714 | 8.5845 | 8.5643 | 8.58 | 6999888.0 |
| 2010-08-24 10:40:00 | AAPL | Stock | 8.58 | 8.6057 | 8.5782 | 8.6019 | 6122200.0 |
| 2010-08-24 10:45:00 | AAPL | Stock | 8.6037 | 8.6286 | 8.6004 | 8.6254 | 9573788.0 |
| 2010-08-24 10:50:00 | AAPL | Stock | 8.6257 | 8.6343 | 8.6196 | 8.6268 | 8049608.0 |
| 2010-08-24 10:55:00 | AAPL | Stock | 8.6271 | 8.6411 | 8.625 | 8.6386 | 6482112.0 |
| 2010-08-24 11:00:00 | AAPL | Stock | 8.6386 | 8.6771 | 8.6375 | 8.66 | 13248592.0 |
| 2010-08-24 11:05:00 | AAPL | Stock | 8.66 | 8.6661 | 8.645 | 8.6468 | 7723968.0 |
| 2010-08-24 11:10:00 | AAPL | Stock | 8.6453 | 8.6471 | 8.6289 | 8.634 | 6959008.0 |
| 2010-08-24 11:15:00 | AAPL | Stock | 8.6339 | 8.6454 | 8.6286 | 8.6439 | 4430104.0 |
> showing 50 of 329,169 rows — these rows as CSV