PREVIEW / stock_5min / 2008-05-21
file: by_date/stock_5min/2008/2008-05-21.parquet size: 4.5 MB rows: 319,030 symbols: 3,309
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-21 05:30:00 | AAPL | Stock | 6.64 | 6.64 | 6.64 | 6.64 | 2800.0 |
| 2008-05-21 06:10:00 | AAPL | Stock | 6.6393 | 6.6393 | 6.6393 | 6.6393 | 2800.0 |
| 2008-05-21 07:30:00 | AAPL | Stock | 6.6182 | 6.6182 | 6.5929 | 6.6071 | 71120.0 |
| 2008-05-21 07:45:00 | AAPL | Stock | 6.6079 | 6.6079 | 6.6079 | 6.6079 | 8400.0 |
| 2008-05-21 07:50:00 | AAPL | Stock | 6.6071 | 6.6071 | 6.6068 | 6.6068 | 11200.0 |
| 2008-05-21 07:55:00 | AAPL | Stock | 6.5964 | 6.6071 | 6.5964 | 6.6071 | 8400.0 |
| 2008-05-21 08:00:00 | AAPL | Stock | 6.6193 | 6.6246 | 6.6071 | 6.6146 | 175140.0 |
| 2008-05-21 08:05:00 | AAPL | Stock | 6.6146 | 6.6214 | 6.6071 | 6.6207 | 299964.0 |
| 2008-05-21 08:10:00 | AAPL | Stock | 6.6204 | 6.6204 | 6.6104 | 6.6171 | 58324.0 |
| 2008-05-21 08:15:00 | AAPL | Stock | 6.6171 | 6.6196 | 6.6171 | 6.6196 | 40600.0 |
| 2008-05-21 08:20:00 | AAPL | Stock | 6.6196 | 6.6304 | 6.6179 | 6.63 | 184100.0 |
| 2008-05-21 08:25:00 | AAPL | Stock | 6.6318 | 6.6318 | 6.6264 | 6.6304 | 130480.0 |
| 2008-05-21 08:30:00 | AAPL | Stock | 6.6304 | 6.6318 | 6.6207 | 6.6268 | 192472.0 |
| 2008-05-21 08:35:00 | AAPL | Stock | 6.6268 | 6.6268 | 6.6246 | 6.6268 | 14560.0 |
| 2008-05-21 08:40:00 | AAPL | Stock | 6.6268 | 6.6268 | 6.6179 | 6.6214 | 256200.0 |
| 2008-05-21 08:45:00 | AAPL | Stock | 6.6214 | 6.6214 | 6.6171 | 6.6196 | 182000.0 |
| 2008-05-21 08:50:00 | AAPL | Stock | 6.6186 | 6.62 | 6.6179 | 6.62 | 42000.0 |
| 2008-05-21 08:55:00 | AAPL | Stock | 6.6214 | 6.6239 | 6.6196 | 6.6239 | 122388.0 |
| 2008-05-21 09:00:00 | AAPL | Stock | 6.6236 | 6.6271 | 6.6236 | 6.6271 | 84028.0 |
| 2008-05-21 09:05:00 | AAPL | Stock | 6.6268 | 6.6268 | 6.6214 | 6.6268 | 560700.0 |
| 2008-05-21 09:10:00 | AAPL | Stock | 6.6264 | 6.6279 | 6.6264 | 6.6279 | 87220.0 |
| 2008-05-21 09:15:00 | AAPL | Stock | 6.6268 | 6.6268 | 6.6225 | 6.6229 | 155344.0 |
| 2008-05-21 09:20:00 | AAPL | Stock | 6.6246 | 6.6271 | 6.6239 | 6.6271 | 50400.0 |
| 2008-05-21 09:25:00 | AAPL | Stock | 6.6304 | 6.6321 | 6.6271 | 6.6296 | 122472.0 |
| 2008-05-21 09:30:00 | AAPL | Stock | 6.6311 | 6.66 | 6.6264 | 6.6521 | 19484388.0 |
| 2008-05-21 09:35:00 | AAPL | Stock | 6.6521 | 6.6886 | 6.6371 | 6.6882 | 20316408.0 |
| 2008-05-21 09:40:00 | AAPL | Stock | 6.6882 | 6.6989 | 6.6739 | 6.6836 | 18214924.0 |
| 2008-05-21 09:45:00 | AAPL | Stock | 6.6839 | 6.7057 | 6.6821 | 6.6857 | 14369600.0 |
| 2008-05-21 09:50:00 | AAPL | Stock | 6.6861 | 6.7125 | 6.6832 | 6.6918 | 16239748.0 |
| 2008-05-21 09:55:00 | AAPL | Stock | 6.6921 | 6.7036 | 6.6789 | 6.6854 | 12590956.0 |
| 2008-05-21 10:00:00 | AAPL | Stock | 6.6861 | 6.7061 | 6.6796 | 6.7054 | 12001836.0 |
| 2008-05-21 10:05:00 | AAPL | Stock | 6.7057 | 6.7107 | 6.6514 | 6.6514 | 18494700.0 |
| 2008-05-21 10:10:00 | AAPL | Stock | 6.6514 | 6.6775 | 6.6504 | 6.6714 | 12939024.0 |
| 2008-05-21 10:15:00 | AAPL | Stock | 6.6714 | 6.6743 | 6.6415 | 6.6575 | 14059024.0 |
| 2008-05-21 10:20:00 | AAPL | Stock | 6.6579 | 6.66 | 6.6268 | 6.6389 | 13834940.0 |
| 2008-05-21 10:25:00 | AAPL | Stock | 6.6396 | 6.6525 | 6.6189 | 6.625 | 16212588.0 |
| 2008-05-21 10:30:00 | AAPL | Stock | 6.6257 | 6.6261 | 6.5786 | 6.5986 | 23744840.0 |
| 2008-05-21 10:35:00 | AAPL | Stock | 6.5988 | 6.6032 | 6.5821 | 6.5971 | 12208980.0 |
| 2008-05-21 10:40:00 | AAPL | Stock | 6.5964 | 6.6154 | 6.5896 | 6.6114 | 13289640.0 |
| 2008-05-21 10:45:00 | AAPL | Stock | 6.6111 | 6.6154 | 6.5939 | 6.5964 | 6499304.0 |
| 2008-05-21 10:50:00 | AAPL | Stock | 6.5961 | 6.5961 | 6.5714 | 6.5875 | 11430916.0 |
| 2008-05-21 10:55:00 | AAPL | Stock | 6.5875 | 6.6029 | 6.5814 | 6.5918 | 7321048.0 |
| 2008-05-21 11:00:00 | AAPL | Stock | 6.5914 | 6.6025 | 6.5821 | 6.5911 | 7143808.0 |
| 2008-05-21 11:05:00 | AAPL | Stock | 6.5911 | 6.5957 | 6.5754 | 6.5821 | 9153368.0 |
| 2008-05-21 11:10:00 | AAPL | Stock | 6.5821 | 6.585 | 6.5661 | 6.5839 | 13510840.0 |
| 2008-05-21 11:15:00 | AAPL | Stock | 6.5843 | 6.5989 | 6.5811 | 6.5911 | 10507252.0 |
| 2008-05-21 11:20:00 | AAPL | Stock | 6.5911 | 6.5975 | 6.5843 | 6.5939 | 6069952.0 |
| 2008-05-21 11:25:00 | AAPL | Stock | 6.5921 | 6.6107 | 6.5911 | 6.6011 | 9098012.0 |
| 2008-05-21 11:30:00 | AAPL | Stock | 6.6018 | 6.6036 | 6.5804 | 6.585 | 7275604.0 |
| 2008-05-21 11:35:00 | AAPL | Stock | 6.585 | 6.5864 | 6.5664 | 6.5682 | 9374288.0 |
> showing 50 of 319,030 rows — these rows as CSV