PREVIEW / stock_5min / 2010-01-05
file: by_date/stock_5min/2010/2010-01-05.parquet size: 4.8 MB rows: 327,855 symbols: 3,454
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-01-05 05:05:00 | AAPL | Stock | 7.6911 | 7.6911 | 7.6911 | 7.6911 | 5600.0 |
| 2010-01-05 05:10:00 | AAPL | Stock | 7.6782 | 7.6782 | 7.6782 | 7.6782 | 2800.0 |
| 2010-01-05 05:55:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 19600.0 |
| 2010-01-05 06:00:00 | AAPL | Stock | 7.675 | 7.6768 | 7.675 | 7.6768 | 11200.0 |
| 2010-01-05 06:05:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 5600.0 |
| 2010-01-05 06:20:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 2800.0 |
| 2010-01-05 06:25:00 | AAPL | Stock | 7.6714 | 7.6714 | 7.6714 | 7.6714 | 2800.0 |
| 2010-01-05 06:35:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 8400.0 |
| 2010-01-05 06:45:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 8400.0 |
| 2010-01-05 06:50:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 2800.0 |
| 2010-01-05 06:55:00 | AAPL | Stock | 7.675 | 7.675 | 7.675 | 7.675 | 2800.0 |
| 2010-01-05 07:00:00 | AAPL | Stock | 7.67 | 7.6768 | 7.67 | 7.6768 | 35252.0 |
| 2010-01-05 07:05:00 | AAPL | Stock | 7.6768 | 7.6768 | 7.6768 | 7.6768 | 70000.0 |
| 2010-01-05 07:10:00 | AAPL | Stock | 7.6882 | 7.6882 | 7.6804 | 7.6804 | 25200.0 |
| 2010-01-05 07:15:00 | AAPL | Stock | 7.6804 | 7.6821 | 7.6804 | 7.6821 | 77840.0 |
| 2010-01-05 07:20:00 | AAPL | Stock | 7.6832 | 7.6832 | 7.6786 | 7.6786 | 32200.0 |
| 2010-01-05 07:25:00 | AAPL | Stock | 7.6786 | 7.6786 | 7.6686 | 7.6714 | 190316.0 |
| 2010-01-05 07:40:00 | AAPL | Stock | 7.6825 | 7.6825 | 7.6714 | 7.6814 | 25200.0 |
| 2010-01-05 07:45:00 | AAPL | Stock | 7.6775 | 7.6782 | 7.6739 | 7.6782 | 11480.0 |
| 2010-01-05 07:50:00 | AAPL | Stock | 7.68 | 7.68 | 7.68 | 7.68 | 5600.0 |
| 2010-01-05 07:55:00 | AAPL | Stock | 7.6786 | 7.6804 | 7.6786 | 7.6786 | 36400.0 |
| 2010-01-05 08:00:00 | AAPL | Stock | 7.6786 | 7.6929 | 7.6786 | 7.6929 | 745276.0 |
| 2010-01-05 08:05:00 | AAPL | Stock | 7.6932 | 7.7036 | 7.6932 | 7.6982 | 1149596.0 |
| 2010-01-05 08:10:00 | AAPL | Stock | 7.6982 | 7.6996 | 7.6893 | 7.6918 | 365456.0 |
| 2010-01-05 08:15:00 | AAPL | Stock | 7.6918 | 7.6921 | 7.6821 | 7.6821 | 453964.0 |
| 2010-01-05 08:20:00 | AAPL | Stock | 7.6821 | 7.6846 | 7.6668 | 7.6714 | 657020.0 |
| 2010-01-05 08:25:00 | AAPL | Stock | 7.6711 | 7.6768 | 7.65 | 7.655 | 2128672.0 |
| 2010-01-05 08:30:00 | AAPL | Stock | 7.6568 | 7.6671 | 7.6568 | 7.66 | 486696.0 |
| 2010-01-05 08:35:00 | AAPL | Stock | 7.6618 | 7.6625 | 7.6461 | 7.6504 | 509880.0 |
| 2010-01-05 08:40:00 | AAPL | Stock | 7.6507 | 7.6536 | 7.6357 | 7.6361 | 818216.0 |
| 2010-01-05 08:45:00 | AAPL | Stock | 7.6361 | 7.6461 | 7.6354 | 7.6429 | 437920.0 |
| 2010-01-05 08:50:00 | AAPL | Stock | 7.6404 | 7.6496 | 7.6396 | 7.6446 | 488880.0 |
| 2010-01-05 08:55:00 | AAPL | Stock | 7.6443 | 7.6457 | 7.6404 | 7.645 | 382592.0 |
| 2010-01-05 09:00:00 | AAPL | Stock | 7.6443 | 7.645 | 7.6393 | 7.6429 | 305116.0 |
| 2010-01-05 09:05:00 | AAPL | Stock | 7.6404 | 7.6425 | 7.6368 | 7.6425 | 229600.0 |
| 2010-01-05 09:10:00 | AAPL | Stock | 7.6425 | 7.6479 | 7.6425 | 7.6436 | 370440.0 |
| 2010-01-05 09:15:00 | AAPL | Stock | 7.6454 | 7.6546 | 7.6443 | 7.6536 | 418348.0 |
| 2010-01-05 09:20:00 | AAPL | Stock | 7.6536 | 7.6557 | 7.6457 | 7.6486 | 232764.0 |
| 2010-01-05 09:25:00 | AAPL | Stock | 7.645 | 7.6621 | 7.6439 | 7.6621 | 958720.0 |
| 2010-01-05 09:30:00 | AAPL | Stock | 7.66 | 7.6714 | 7.6304 | 7.6493 | 28095648.0 |
| 2010-01-05 09:35:00 | AAPL | Stock | 7.6493 | 7.6514 | 7.6254 | 7.635 | 16869664.0 |
| 2010-01-05 09:40:00 | AAPL | Stock | 7.635 | 7.6393 | 7.6225 | 7.6286 | 16032940.0 |
| 2010-01-05 09:45:00 | AAPL | Stock | 7.6292 | 7.6696 | 7.6239 | 7.6693 | 20277740.0 |
| 2010-01-05 09:50:00 | AAPL | Stock | 7.6696 | 7.6964 | 7.6639 | 7.695 | 24795204.0 |
| 2010-01-05 09:55:00 | AAPL | Stock | 7.695 | 7.6996 | 7.6836 | 7.6871 | 17710448.0 |
| 2010-01-05 10:00:00 | AAPL | Stock | 7.6864 | 7.6975 | 7.6714 | 7.6965 | 14377804.0 |
| 2010-01-05 10:05:00 | AAPL | Stock | 7.6964 | 7.6968 | 7.6771 | 7.6786 | 7393848.0 |
| 2010-01-05 10:10:00 | AAPL | Stock | 7.6779 | 7.6893 | 7.6721 | 7.6843 | 10971212.0 |
| 2010-01-05 10:15:00 | AAPL | Stock | 7.6854 | 7.6964 | 7.6843 | 7.6904 | 7784644.0 |
| 2010-01-05 10:20:00 | AAPL | Stock | 7.6914 | 7.6986 | 7.6814 | 7.6875 | 9931544.0 |
> showing 50 of 327,855 rows — these rows as CSV