PREVIEW / stock_5min / 2008-02-29
file: by_date/stock_5min/2008/2008-02-29.parquet size: 4.4 MB rows: 320,432 symbols: 3,266
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-02-29 05:20:00 | AAPL | Stock | 4.625 | 4.625 | 4.625 | 4.625 | 6580.0 |
| 2008-02-29 05:55:00 | AAPL | Stock | 4.6071 | 4.6071 | 4.6071 | 4.6071 | 5600.0 |
| 2008-02-29 06:45:00 | AAPL | Stock | 4.5932 | 4.5932 | 4.5932 | 4.5932 | 28000.0 |
| 2008-02-29 07:00:00 | AAPL | Stock | 4.5932 | 4.5939 | 4.5818 | 4.5925 | 89600.0 |
| 2008-02-29 07:05:00 | AAPL | Stock | 4.5929 | 4.5982 | 4.5929 | 4.5946 | 33600.0 |
| 2008-02-29 07:10:00 | AAPL | Stock | 4.6 | 4.6043 | 4.6 | 4.6043 | 28000.0 |
| 2008-02-29 07:15:00 | AAPL | Stock | 4.6039 | 4.6039 | 4.6036 | 4.6036 | 22400.0 |
| 2008-02-29 07:20:00 | AAPL | Stock | 4.6 | 4.6 | 4.6 | 4.6 | 56000.0 |
| 2008-02-29 07:30:00 | AAPL | Stock | 4.6043 | 4.6043 | 4.6 | 4.6 | 49532.0 |
| 2008-02-29 07:35:00 | AAPL | Stock | 4.5964 | 4.6 | 4.5946 | 4.5946 | 48496.0 |
| 2008-02-29 07:40:00 | AAPL | Stock | 4.5911 | 4.5929 | 4.5893 | 4.5929 | 16800.0 |
| 2008-02-29 07:45:00 | AAPL | Stock | 4.5918 | 4.5918 | 4.5839 | 4.5839 | 51492.0 |
| 2008-02-29 07:50:00 | AAPL | Stock | 4.5839 | 4.5893 | 4.5821 | 4.5893 | 27664.0 |
| 2008-02-29 07:55:00 | AAPL | Stock | 4.5904 | 4.5964 | 4.5904 | 4.5964 | 76188.0 |
| 2008-02-29 08:00:00 | AAPL | Stock | 4.5921 | 4.6 | 4.5893 | 4.5964 | 475440.0 |
| 2008-02-29 08:05:00 | AAPL | Stock | 4.5964 | 4.6071 | 4.5932 | 4.5943 | 464128.0 |
| 2008-02-29 08:10:00 | AAPL | Stock | 4.5939 | 4.5946 | 4.5821 | 4.5875 | 834428.0 |
| 2008-02-29 08:15:00 | AAPL | Stock | 4.5875 | 4.6007 | 4.5864 | 4.6007 | 241108.0 |
| 2008-02-29 08:20:00 | AAPL | Stock | 4.6007 | 4.6018 | 4.5893 | 4.5893 | 311668.0 |
| 2008-02-29 08:25:00 | AAPL | Stock | 4.5893 | 4.5964 | 4.5839 | 4.5964 | 473172.0 |
| 2008-02-29 08:30:00 | AAPL | Stock | 4.5975 | 4.6046 | 4.5964 | 4.6018 | 324576.0 |
| 2008-02-29 08:35:00 | AAPL | Stock | 4.6036 | 4.6121 | 4.5989 | 4.6075 | 693560.0 |
| 2008-02-29 08:40:00 | AAPL | Stock | 4.6075 | 4.6136 | 4.6068 | 4.6093 | 585844.0 |
| 2008-02-29 08:45:00 | AAPL | Stock | 4.61 | 4.6118 | 4.6032 | 4.6032 | 259980.0 |
| 2008-02-29 08:50:00 | AAPL | Stock | 4.6032 | 4.6071 | 4.6 | 4.605 | 152516.0 |
| 2008-02-29 08:55:00 | AAPL | Stock | 4.6054 | 4.6071 | 4.6036 | 4.6071 | 153720.0 |
| 2008-02-29 09:00:00 | AAPL | Stock | 4.6071 | 4.6082 | 4.5982 | 4.5989 | 645988.0 |
| 2008-02-29 09:05:00 | AAPL | Stock | 4.6018 | 4.6018 | 4.5943 | 4.5996 | 383236.0 |
| 2008-02-29 09:10:00 | AAPL | Stock | 4.5993 | 4.6025 | 4.5964 | 4.5964 | 195524.0 |
| 2008-02-29 09:15:00 | AAPL | Stock | 4.5964 | 4.6 | 4.5964 | 4.5996 | 88508.0 |
| 2008-02-29 09:20:00 | AAPL | Stock | 4.5975 | 4.6396 | 4.5975 | 4.5989 | 128072.0 |
| 2008-02-29 09:25:00 | AAPL | Stock | 4.5979 | 4.6157 | 4.5921 | 4.6146 | 1320732.0 |
| 2008-02-29 09:30:00 | AAPL | Stock | 4.6157 | 4.6432 | 4.6036 | 4.6289 | 34232408.0 |
| 2008-02-29 09:35:00 | AAPL | Stock | 4.6286 | 4.6504 | 4.6275 | 4.6389 | 27912416.0 |
| 2008-02-29 09:40:00 | AAPL | Stock | 4.6389 | 4.6394 | 4.5943 | 4.6011 | 32843496.0 |
| 2008-02-29 09:45:00 | AAPL | Stock | 4.6 | 4.6104 | 4.5875 | 4.61 | 26777632.0 |
| 2008-02-29 09:50:00 | AAPL | Stock | 4.6097 | 4.6282 | 4.6032 | 4.6214 | 20779360.0 |
| 2008-02-29 09:55:00 | AAPL | Stock | 4.6218 | 4.6325 | 4.6107 | 4.6275 | 19910772.0 |
| 2008-02-29 10:00:00 | AAPL | Stock | 4.6277 | 4.6286 | 4.6 | 4.6011 | 19458432.0 |
| 2008-02-29 10:05:00 | AAPL | Stock | 4.6011 | 4.6064 | 4.5775 | 4.5846 | 24485608.0 |
| 2008-02-29 10:10:00 | AAPL | Stock | 4.5846 | 4.585 | 4.5518 | 4.5575 | 40921916.0 |
| 2008-02-29 10:15:00 | AAPL | Stock | 4.5568 | 4.5629 | 4.55 | 4.5604 | 28931756.0 |
| 2008-02-29 10:20:00 | AAPL | Stock | 4.5604 | 4.5671 | 4.5282 | 4.5475 | 39590124.0 |
| 2008-02-29 10:25:00 | AAPL | Stock | 4.5482 | 4.5557 | 4.3171 | 4.5429 | 24128132.0 |
| 2008-02-29 10:30:00 | AAPL | Stock | 4.5432 | 4.5475 | 4.5271 | 4.5389 | 28939708.0 |
| 2008-02-29 10:35:00 | AAPL | Stock | 4.5386 | 4.5443 | 4.5321 | 4.5361 | 14793576.0 |
| 2008-02-29 10:40:00 | AAPL | Stock | 4.5364 | 4.5471 | 4.53 | 4.5311 | 19517036.0 |
| 2008-02-29 10:45:00 | AAPL | Stock | 4.5311 | 4.5518 | 4.5268 | 4.5454 | 20775580.0 |
| 2008-02-29 10:50:00 | AAPL | Stock | 4.5461 | 4.5554 | 4.5371 | 4.5543 | 13599432.0 |
| 2008-02-29 10:55:00 | AAPL | Stock | 4.5543 | 4.5545 | 4.5418 | 4.5479 | 15319080.0 |
> showing 50 of 320,432 rows — these rows as CSV