PREVIEW / stock_5min / 2005-12-29
file: by_date/stock_5min/2005/2005-12-29.parquet size: 2.8 MB rows: 208,955 symbols: 2,176
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 |
|---|---|---|---|---|---|---|---|
| 2005-12-29 07:30:00 | AAPL | Stock | 2.6275 | 2.6275 | 2.6275 | 2.6275 | 35168.0 |
| 2005-12-29 07:55:00 | AAPL | Stock | 2.6275 | 2.6275 | 2.6275 | 2.6275 | 2800.0 |
| 2005-12-29 08:00:00 | AAPL | Stock | 2.625 | 2.6275 | 2.625 | 2.6275 | 113400.0 |
| 2005-12-29 08:05:00 | AAPL | Stock | 2.6275 | 2.6275 | 2.6214 | 2.6232 | 75600.0 |
| 2005-12-29 08:10:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6214 | 2.6214 | 5600.0 |
| 2005-12-29 08:15:00 | AAPL | Stock | 2.6214 | 2.6214 | 2.6204 | 2.6204 | 47600.0 |
| 2005-12-29 08:20:00 | AAPL | Stock | 2.6196 | 2.6225 | 2.6196 | 2.6225 | 28000.0 |
| 2005-12-29 08:25:00 | AAPL | Stock | 2.6246 | 2.6246 | 2.6246 | 2.6246 | 5600.0 |
| 2005-12-29 08:30:00 | AAPL | Stock | 2.6232 | 2.6232 | 2.6232 | 2.6232 | 5600.0 |
| 2005-12-29 08:35:00 | AAPL | Stock | 2.6246 | 2.6246 | 2.6189 | 2.6196 | 89460.0 |
| 2005-12-29 08:40:00 | AAPL | Stock | 2.6196 | 2.6246 | 2.6196 | 2.6232 | 46760.0 |
| 2005-12-29 08:45:00 | AAPL | Stock | 2.6232 | 2.6243 | 2.6204 | 2.6232 | 78400.0 |
| 2005-12-29 08:50:00 | AAPL | Stock | 2.6232 | 2.6243 | 2.6232 | 2.6243 | 242200.0 |
| 2005-12-29 08:55:00 | AAPL | Stock | 2.6243 | 2.6243 | 2.6243 | 2.6243 | 61600.0 |
| 2005-12-29 09:00:00 | AAPL | Stock | 2.6243 | 2.6243 | 2.6232 | 2.6232 | 109200.0 |
| 2005-12-29 09:05:00 | AAPL | Stock | 2.6243 | 2.6243 | 2.6243 | 2.6243 | 76328.0 |
| 2005-12-29 09:10:00 | AAPL | Stock | 2.6243 | 2.6286 | 2.6243 | 2.6286 | 402248.0 |
| 2005-12-29 09:15:00 | AAPL | Stock | 2.6286 | 2.6289 | 2.6286 | 2.6289 | 33600.0 |
| 2005-12-29 09:25:00 | AAPL | Stock | 2.63 | 2.6368 | 2.63 | 2.635 | 318724.0 |
| 2005-12-29 09:30:00 | AAPL | Stock | 2.635 | 2.6364 | 2.6257 | 2.6293 | 9311876.0 |
| 2005-12-29 09:35:00 | AAPL | Stock | 2.6289 | 2.6314 | 2.6225 | 2.6229 | 8484700.0 |
| 2005-12-29 09:40:00 | AAPL | Stock | 2.6229 | 2.625 | 2.6136 | 2.6139 | 11156460.0 |
| 2005-12-29 09:45:00 | AAPL | Stock | 2.6139 | 2.6161 | 2.6082 | 2.6086 | 10466204.0 |
| 2005-12-29 09:50:00 | AAPL | Stock | 2.6086 | 2.6107 | 2.5946 | 2.6018 | 20306944.0 |
| 2005-12-29 09:55:00 | AAPL | Stock | 2.6018 | 2.6029 | 2.5861 | 2.5975 | 24985436.0 |
| 2005-12-29 10:00:00 | AAPL | Stock | 2.5975 | 2.6029 | 2.5943 | 2.5954 | 10921820.0 |
| 2005-12-29 10:05:00 | AAPL | Stock | 2.595 | 2.5989 | 2.5929 | 2.5989 | 7223076.0 |
| 2005-12-29 10:10:00 | AAPL | Stock | 2.5982 | 2.5996 | 2.595 | 2.5971 | 6442128.0 |
| 2005-12-29 10:15:00 | AAPL | Stock | 2.5971 | 2.5982 | 2.5954 | 2.5957 | 3588788.0 |
| 2005-12-29 10:20:00 | AAPL | Stock | 2.5961 | 2.5979 | 2.5914 | 2.5925 | 5256468.0 |
| 2005-12-29 10:25:00 | AAPL | Stock | 2.5925 | 2.5925 | 2.5846 | 2.5864 | 11168108.0 |
| 2005-12-29 10:30:00 | AAPL | Stock | 2.5861 | 2.5914 | 2.5861 | 2.5882 | 7403620.0 |
| 2005-12-29 10:35:00 | AAPL | Stock | 2.5882 | 2.5893 | 2.5796 | 2.5796 | 12777212.0 |
| 2005-12-29 10:40:00 | AAPL | Stock | 2.5796 | 2.5804 | 2.5664 | 2.5739 | 20504064.0 |
| 2005-12-29 10:45:00 | AAPL | Stock | 2.5739 | 2.5818 | 2.5729 | 2.5807 | 7917896.0 |
| 2005-12-29 10:50:00 | AAPL | Stock | 2.5807 | 2.5814 | 2.5754 | 2.5754 | 6388200.0 |
| 2005-12-29 10:55:00 | AAPL | Stock | 2.5757 | 2.5839 | 2.5757 | 2.5814 | 6210484.0 |
| 2005-12-29 11:00:00 | AAPL | Stock | 2.5811 | 2.5911 | 2.5793 | 2.5889 | 7948668.0 |
| 2005-12-29 11:05:00 | AAPL | Stock | 2.5886 | 2.59 | 2.5857 | 2.5889 | 4515812.0 |
| 2005-12-29 11:10:00 | AAPL | Stock | 2.5889 | 2.5896 | 2.5864 | 2.5875 | 3604356.0 |
| 2005-12-29 11:15:00 | AAPL | Stock | 2.5868 | 2.59 | 2.5864 | 2.5893 | 2291576.0 |
| 2005-12-29 11:20:00 | AAPL | Stock | 2.5893 | 2.5929 | 2.5889 | 2.5896 | 3943072.0 |
| 2005-12-29 11:25:00 | AAPL | Stock | 2.5896 | 2.5904 | 2.5868 | 2.5871 | 3404044.0 |
| 2005-12-29 11:30:00 | AAPL | Stock | 2.5868 | 2.5871 | 2.5764 | 2.5829 | 6872516.0 |
| 2005-12-29 11:35:00 | AAPL | Stock | 2.5829 | 2.585 | 2.5768 | 2.5779 | 3965052.0 |
| 2005-12-29 11:40:00 | AAPL | Stock | 2.5775 | 2.5782 | 2.5736 | 2.5779 | 5785668.0 |
| 2005-12-29 11:45:00 | AAPL | Stock | 2.5775 | 2.5839 | 2.5761 | 2.5825 | 5181428.0 |
| 2005-12-29 11:50:00 | AAPL | Stock | 2.5832 | 2.585 | 2.5807 | 2.5814 | 4578532.0 |
| 2005-12-29 11:55:00 | AAPL | Stock | 2.5814 | 2.5836 | 2.5793 | 2.5825 | 3358012.0 |
| 2005-12-29 12:00:00 | AAPL | Stock | 2.5825 | 2.5829 | 2.5779 | 2.5782 | 3011624.0 |
> showing 50 of 208,955 rows — these rows as CSV