PREVIEW / stock_5min / 2006-01-31
file: by_date/stock_5min/2006/2006-01-31.parquet size: 3.1 MB rows: 222,155 symbols: 2,193
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-01-31 06:30:00 | AAPL | Stock | 2.6875 | 2.6893 | 2.6875 | 2.6893 | 25200.0 |
| 2006-01-31 07:20:00 | AAPL | Stock | 2.6961 | 2.6961 | 2.6961 | 2.6961 | 2800.0 |
| 2006-01-31 07:40:00 | AAPL | Stock | 2.6946 | 2.6946 | 2.6946 | 2.6946 | 47600.0 |
| 2006-01-31 07:50:00 | AAPL | Stock | 2.6793 | 2.7011 | 2.6789 | 2.6871 | 98000.0 |
| 2006-01-31 08:00:00 | AAPL | Stock | 2.6925 | 2.6964 | 2.6825 | 2.6964 | 620004.0 |
| 2006-01-31 08:05:00 | AAPL | Stock | 2.6964 | 2.7 | 2.6929 | 2.6964 | 270704.0 |
| 2006-01-31 08:10:00 | AAPL | Stock | 2.6961 | 2.7004 | 2.6932 | 2.6964 | 212072.0 |
| 2006-01-31 08:15:00 | AAPL | Stock | 2.6964 | 2.6979 | 2.6932 | 2.6964 | 263760.0 |
| 2006-01-31 08:20:00 | AAPL | Stock | 2.6964 | 2.7004 | 2.6964 | 2.7 | 161000.0 |
| 2006-01-31 08:25:00 | AAPL | Stock | 2.7018 | 2.7071 | 2.7 | 2.7068 | 266868.0 |
| 2006-01-31 08:30:00 | AAPL | Stock | 2.7068 | 2.7139 | 2.7036 | 2.7036 | 543060.0 |
| 2006-01-31 08:35:00 | AAPL | Stock | 2.7036 | 2.7036 | 2.6946 | 2.6946 | 391048.0 |
| 2006-01-31 08:40:00 | AAPL | Stock | 2.6964 | 2.7032 | 2.6964 | 2.7032 | 231952.0 |
| 2006-01-31 08:45:00 | AAPL | Stock | 2.7029 | 2.7029 | 2.6968 | 2.7 | 89600.0 |
| 2006-01-31 08:50:00 | AAPL | Stock | 2.7 | 2.7 | 2.6968 | 2.6982 | 68320.0 |
| 2006-01-31 08:55:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6921 | 2.6946 | 426692.0 |
| 2006-01-31 09:00:00 | AAPL | Stock | 2.6929 | 2.7 | 2.6914 | 2.695 | 154420.0 |
| 2006-01-31 09:05:00 | AAPL | Stock | 2.6964 | 2.6982 | 2.6964 | 2.6971 | 80136.0 |
| 2006-01-31 09:10:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6975 | 2.6979 | 122360.0 |
| 2006-01-31 09:15:00 | AAPL | Stock | 2.6971 | 2.6993 | 2.6964 | 2.6982 | 226800.0 |
| 2006-01-31 09:20:00 | AAPL | Stock | 2.6968 | 2.6971 | 2.6946 | 2.6946 | 105980.0 |
| 2006-01-31 09:25:00 | AAPL | Stock | 2.6946 | 2.6971 | 2.6875 | 2.6964 | 878472.0 |
| 2006-01-31 09:30:00 | AAPL | Stock | 2.6964 | 2.6986 | 2.6821 | 2.6868 | 33195708.0 |
| 2006-01-31 09:35:00 | AAPL | Stock | 2.6864 | 2.6985 | 2.6554 | 2.6679 | 35542332.0 |
| 2006-01-31 09:40:00 | AAPL | Stock | 2.6679 | 2.6711 | 2.6475 | 2.6611 | 26020456.0 |
| 2006-01-31 09:45:00 | AAPL | Stock | 2.6607 | 2.6711 | 2.6518 | 2.6629 | 20983900.0 |
| 2006-01-31 09:50:00 | AAPL | Stock | 2.6629 | 2.675 | 2.6621 | 2.6664 | 14730996.0 |
| 2006-01-31 09:55:00 | AAPL | Stock | 2.6664 | 2.6725 | 2.6579 | 2.6625 | 15277668.0 |
| 2006-01-31 10:00:00 | AAPL | Stock | 2.6625 | 2.6714 | 2.6454 | 2.6546 | 22969744.0 |
| 2006-01-31 10:05:00 | AAPL | Stock | 2.655 | 2.6557 | 2.6414 | 2.6425 | 22561476.0 |
| 2006-01-31 10:10:00 | AAPL | Stock | 2.6421 | 2.6518 | 2.6361 | 2.6514 | 14847056.0 |
| 2006-01-31 10:15:00 | AAPL | Stock | 2.6514 | 2.6568 | 2.6393 | 2.6568 | 12539520.0 |
| 2006-01-31 10:20:00 | AAPL | Stock | 2.6567 | 2.6589 | 2.6468 | 2.6471 | 10309236.0 |
| 2006-01-31 10:25:00 | AAPL | Stock | 2.6475 | 2.6507 | 2.6404 | 2.6436 | 10824436.0 |
| 2006-01-31 10:30:00 | AAPL | Stock | 2.6436 | 2.6561 | 2.6339 | 2.6511 | 20350260.0 |
| 2006-01-31 10:35:00 | AAPL | Stock | 2.6514 | 2.6704 | 2.65 | 2.6693 | 14997920.0 |
| 2006-01-31 10:40:00 | AAPL | Stock | 2.6696 | 2.6786 | 2.6643 | 2.6718 | 19231744.0 |
| 2006-01-31 10:45:00 | AAPL | Stock | 2.6721 | 2.6768 | 2.6661 | 2.6732 | 11862088.0 |
| 2006-01-31 10:50:00 | AAPL | Stock | 2.6725 | 2.6914 | 2.6714 | 2.6911 | 25727660.0 |
| 2006-01-31 10:55:00 | AAPL | Stock | 2.6907 | 2.7018 | 2.6871 | 2.6979 | 23601872.0 |
| 2006-01-31 11:00:00 | AAPL | Stock | 2.6986 | 2.6993 | 2.685 | 2.685 | 20406904.0 |
| 2006-01-31 11:05:00 | AAPL | Stock | 2.6854 | 2.6921 | 2.6796 | 2.6918 | 13338388.0 |
| 2006-01-31 11:10:00 | AAPL | Stock | 2.6921 | 2.6996 | 2.6786 | 2.6929 | 12845672.0 |
| 2006-01-31 11:15:00 | AAPL | Stock | 2.6929 | 2.6957 | 2.6854 | 2.6886 | 5994940.0 |
| 2006-01-31 11:20:00 | AAPL | Stock | 2.6889 | 2.6989 | 2.6868 | 2.6879 | 8545516.0 |
| 2006-01-31 11:25:00 | AAPL | Stock | 2.6875 | 2.6925 | 2.6857 | 2.6882 | 7938420.0 |
| 2006-01-31 11:30:00 | AAPL | Stock | 2.6886 | 2.69 | 2.6843 | 2.6846 | 4864440.0 |
| 2006-01-31 11:35:00 | AAPL | Stock | 2.6846 | 2.6911 | 2.6836 | 2.6904 | 5392884.0 |
| 2006-01-31 11:40:00 | AAPL | Stock | 2.6907 | 2.6907 | 2.6854 | 2.6864 | 3529344.0 |
| 2006-01-31 11:45:00 | AAPL | Stock | 2.6864 | 2.6936 | 2.6825 | 2.6932 | 7758436.0 |
> showing 50 of 222,155 rows — these rows as CSV