PREVIEW / stock_5min / 2006-09-21
file: by_date/stock_5min/2006/2006-09-21.parquet size: 3.1 MB rows: 227,654 symbols: 2,354
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-09-21 07:35:00 | AAPL | Stock | 2.6911 | 2.6911 | 2.6893 | 2.6893 | 84000.0 |
| 2006-09-21 08:00:00 | AAPL | Stock | 2.6964 | 2.6979 | 2.6946 | 2.6975 | 163800.0 |
| 2006-09-21 08:05:00 | AAPL | Stock | 2.6975 | 2.7018 | 2.6975 | 2.6979 | 213640.0 |
| 2006-09-21 08:10:00 | AAPL | Stock | 2.6982 | 2.7014 | 2.6964 | 2.6964 | 266644.0 |
| 2006-09-21 08:15:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6911 | 2.6911 | 204120.0 |
| 2006-09-21 08:20:00 | AAPL | Stock | 2.6929 | 2.6932 | 2.6929 | 2.6932 | 48552.0 |
| 2006-09-21 08:25:00 | AAPL | Stock | 2.6986 | 2.6986 | 2.6971 | 2.6975 | 86296.0 |
| 2006-09-21 08:30:00 | AAPL | Stock | 2.6975 | 2.6975 | 2.6964 | 2.6964 | 93800.0 |
| 2006-09-21 08:35:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6964 | 2.6964 | 98000.0 |
| 2006-09-21 08:40:00 | AAPL | Stock | 2.6982 | 2.7 | 2.6982 | 2.6996 | 203336.0 |
| 2006-09-21 08:45:00 | AAPL | Stock | 2.6989 | 2.6996 | 2.6986 | 2.6986 | 18200.0 |
| 2006-09-21 08:50:00 | AAPL | Stock | 2.6964 | 2.6964 | 2.6964 | 2.6964 | 30100.0 |
| 2006-09-21 08:55:00 | AAPL | Stock | 2.6982 | 2.6986 | 2.6968 | 2.6986 | 55916.0 |
| 2006-09-21 09:00:00 | AAPL | Stock | 2.6982 | 2.6986 | 2.6975 | 2.6975 | 49000.0 |
| 2006-09-21 09:05:00 | AAPL | Stock | 2.6986 | 2.6986 | 2.6979 | 2.6979 | 40180.0 |
| 2006-09-21 09:10:00 | AAPL | Stock | 2.6982 | 2.7 | 2.6979 | 2.6982 | 87640.0 |
| 2006-09-21 09:15:00 | AAPL | Stock | 2.6982 | 2.6982 | 2.6982 | 2.6982 | 12880.0 |
| 2006-09-21 09:20:00 | AAPL | Stock | 2.6979 | 2.6979 | 2.6932 | 2.6932 | 317240.0 |
| 2006-09-21 09:25:00 | AAPL | Stock | 2.6932 | 2.695 | 2.6854 | 2.6854 | 798476.0 |
| 2006-09-21 09:30:00 | AAPL | Stock | 2.6875 | 2.7054 | 2.6871 | 2.7004 | 15968596.0 |
| 2006-09-21 09:35:00 | AAPL | Stock | 2.7007 | 2.7075 | 2.6961 | 2.7064 | 13273148.0 |
| 2006-09-21 09:40:00 | AAPL | Stock | 2.7061 | 2.7068 | 2.6946 | 2.6964 | 17307276.0 |
| 2006-09-21 09:45:00 | AAPL | Stock | 2.6971 | 2.7011 | 2.6839 | 2.6846 | 17674188.0 |
| 2006-09-21 09:50:00 | AAPL | Stock | 2.6843 | 2.69 | 2.6789 | 2.6893 | 15793708.0 |
| 2006-09-21 09:55:00 | AAPL | Stock | 2.6893 | 2.6946 | 2.6879 | 2.6879 | 12865244.0 |
| 2006-09-21 10:00:00 | AAPL | Stock | 2.6879 | 2.6925 | 2.6761 | 2.6821 | 17148740.0 |
| 2006-09-21 10:05:00 | AAPL | Stock | 2.6821 | 2.6854 | 2.6736 | 2.685 | 15144556.0 |
| 2006-09-21 10:10:00 | AAPL | Stock | 2.6854 | 2.6925 | 2.6821 | 2.6893 | 14170716.0 |
| 2006-09-21 10:15:00 | AAPL | Stock | 2.6893 | 2.6907 | 2.6832 | 2.6854 | 10526040.0 |
| 2006-09-21 10:20:00 | AAPL | Stock | 2.685 | 2.69 | 2.6832 | 2.6875 | 7453404.0 |
| 2006-09-21 10:25:00 | AAPL | Stock | 2.6871 | 2.6946 | 2.6861 | 2.6921 | 9644544.0 |
| 2006-09-21 10:30:00 | AAPL | Stock | 2.6921 | 2.6936 | 2.6839 | 2.6936 | 7584052.0 |
| 2006-09-21 10:35:00 | AAPL | Stock | 2.6936 | 2.6975 | 2.6911 | 2.695 | 9565500.0 |
| 2006-09-21 10:40:00 | AAPL | Stock | 2.6954 | 2.6964 | 2.6911 | 2.6932 | 5834640.0 |
| 2006-09-21 10:45:00 | AAPL | Stock | 2.6936 | 2.7071 | 2.6932 | 2.7061 | 21989604.0 |
| 2006-09-21 10:50:00 | AAPL | Stock | 2.7061 | 2.7075 | 2.7004 | 2.7017 | 9399516.0 |
| 2006-09-21 10:55:00 | AAPL | Stock | 2.7011 | 2.7068 | 2.7004 | 2.7004 | 7484064.0 |
| 2006-09-21 11:00:00 | AAPL | Stock | 2.7004 | 2.7068 | 2.6996 | 2.7039 | 8417836.0 |
| 2006-09-21 11:05:00 | AAPL | Stock | 2.7046 | 2.7125 | 2.7043 | 2.7071 | 15157660.0 |
| 2006-09-21 11:10:00 | AAPL | Stock | 2.7075 | 2.7107 | 2.705 | 2.7107 | 7313292.0 |
| 2006-09-21 11:15:00 | AAPL | Stock | 2.7107 | 2.7164 | 2.7104 | 2.7161 | 13643588.0 |
| 2006-09-21 11:20:00 | AAPL | Stock | 2.7161 | 2.7164 | 2.7071 | 2.7089 | 9640176.0 |
| 2006-09-21 11:25:00 | AAPL | Stock | 2.7089 | 2.7132 | 2.7071 | 2.7071 | 7162064.0 |
| 2006-09-21 11:30:00 | AAPL | Stock | 2.7074 | 2.7082 | 2.7018 | 2.7032 | 10500896.0 |
| 2006-09-21 11:35:00 | AAPL | Stock | 2.7032 | 2.7082 | 2.7021 | 2.7029 | 5942188.0 |
| 2006-09-21 11:40:00 | AAPL | Stock | 2.7029 | 2.7036 | 2.6982 | 2.6989 | 9850456.0 |
| 2006-09-21 11:45:00 | AAPL | Stock | 2.6989 | 2.7025 | 2.6957 | 2.7011 | 8948436.0 |
| 2006-09-21 11:50:00 | AAPL | Stock | 2.7007 | 2.7068 | 2.6996 | 2.7054 | 9726080.0 |
| 2006-09-21 11:55:00 | AAPL | Stock | 2.7057 | 2.7082 | 2.7025 | 2.7025 | 7080976.0 |
| 2006-09-21 12:00:00 | AAPL | Stock | 2.7029 | 2.7046 | 2.6889 | 2.6936 | 18141480.0 |
> showing 50 of 227,654 rows — these rows as CSV