PREVIEW / stock_5min / 2008-10-16
file: by_date/stock_5min/2008/2008-10-16.parquet size: 4.6 MB rows: 323,546 symbols: 3,338
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-10-16 04:10:00 | AAPL | Stock | 3.5 | 3.5 | 3.5 | 3.5 | 56000.0 |
| 2008-10-16 04:35:00 | AAPL | Stock | 3.4996 | 3.4996 | 3.4996 | 3.4996 | 14000.0 |
| 2008-10-16 04:55:00 | AAPL | Stock | 3.4996 | 3.4996 | 3.4996 | 3.4996 | 9044.0 |
| 2008-10-16 05:45:00 | AAPL | Stock | 3.4821 | 3.4821 | 3.4821 | 3.4821 | 8400.0 |
| 2008-10-16 06:15:00 | AAPL | Stock | 3.4911 | 3.4911 | 3.4911 | 3.4911 | 2800.0 |
| 2008-10-16 06:20:00 | AAPL | Stock | 3.4821 | 3.4911 | 3.4821 | 3.4911 | 8400.0 |
| 2008-10-16 06:25:00 | AAPL | Stock | 3.4961 | 3.4964 | 3.4961 | 3.4964 | 18200.0 |
| 2008-10-16 06:45:00 | AAPL | Stock | 3.5104 | 3.5104 | 3.5104 | 3.5104 | 10472.0 |
| 2008-10-16 06:55:00 | AAPL | Stock | 3.5171 | 3.5171 | 3.4696 | 3.4696 | 11200.0 |
| 2008-10-16 07:00:00 | AAPL | Stock | 3.5 | 3.5175 | 3.5 | 3.5171 | 70000.0 |
| 2008-10-16 07:05:00 | AAPL | Stock | 3.5171 | 3.5318 | 3.5171 | 3.5318 | 33600.0 |
| 2008-10-16 07:10:00 | AAPL | Stock | 3.5143 | 3.5143 | 3.5143 | 3.5143 | 28000.0 |
| 2008-10-16 07:15:00 | AAPL | Stock | 3.5214 | 3.5214 | 3.5214 | 3.5214 | 11200.0 |
| 2008-10-16 07:20:00 | AAPL | Stock | 3.5143 | 3.5179 | 3.5143 | 3.5179 | 52472.0 |
| 2008-10-16 07:25:00 | AAPL | Stock | 3.5268 | 3.5296 | 3.5268 | 3.5268 | 46200.0 |
| 2008-10-16 07:30:00 | AAPL | Stock | 3.5268 | 3.5268 | 3.5 | 3.5179 | 201684.0 |
| 2008-10-16 07:40:00 | AAPL | Stock | 3.5157 | 3.5157 | 3.5157 | 3.5157 | 2800.0 |
| 2008-10-16 07:45:00 | AAPL | Stock | 3.5089 | 3.5089 | 3.4893 | 3.4893 | 169176.0 |
| 2008-10-16 07:50:00 | AAPL | Stock | 3.4861 | 3.5071 | 3.4861 | 3.4986 | 28000.0 |
| 2008-10-16 07:55:00 | AAPL | Stock | 3.4946 | 3.5 | 3.4925 | 3.4946 | 202888.0 |
| 2008-10-16 08:00:00 | AAPL | Stock | 3.4946 | 3.5179 | 3.4696 | 3.4879 | 258552.0 |
| 2008-10-16 08:05:00 | AAPL | Stock | 3.4875 | 3.5004 | 3.4875 | 3.5 | 134008.0 |
| 2008-10-16 08:10:00 | AAPL | Stock | 3.4993 | 3.5107 | 3.4964 | 3.5107 | 297248.0 |
| 2008-10-16 08:15:00 | AAPL | Stock | 3.5139 | 3.5357 | 3.5089 | 3.5357 | 441924.0 |
| 2008-10-16 08:20:00 | AAPL | Stock | 3.5375 | 3.5536 | 3.5371 | 3.5418 | 479276.0 |
| 2008-10-16 08:25:00 | AAPL | Stock | 3.5411 | 3.5429 | 3.5307 | 3.5354 | 767900.0 |
| 2008-10-16 08:30:00 | AAPL | Stock | 3.5375 | 3.5675 | 3.5368 | 3.5643 | 994784.0 |
| 2008-10-16 08:35:00 | AAPL | Stock | 3.5668 | 3.5786 | 3.5643 | 3.5764 | 1180928.0 |
| 2008-10-16 08:40:00 | AAPL | Stock | 3.5775 | 3.5904 | 3.5661 | 3.5714 | 1286600.0 |
| 2008-10-16 08:45:00 | AAPL | Stock | 3.5707 | 3.5882 | 3.5704 | 3.5839 | 712320.0 |
| 2008-10-16 08:50:00 | AAPL | Stock | 3.5814 | 3.6014 | 3.5804 | 3.5911 | 656516.0 |
| 2008-10-16 08:55:00 | AAPL | Stock | 3.5943 | 3.5996 | 3.5821 | 3.5857 | 714672.0 |
| 2008-10-16 09:00:00 | AAPL | Stock | 3.5854 | 3.5896 | 3.5536 | 3.5664 | 1065736.0 |
| 2008-10-16 09:05:00 | AAPL | Stock | 3.5668 | 3.5968 | 3.5643 | 3.5914 | 914032.0 |
| 2008-10-16 09:10:00 | AAPL | Stock | 3.5882 | 3.5982 | 3.5846 | 3.5929 | 964460.0 |
| 2008-10-16 09:15:00 | AAPL | Stock | 3.5929 | 3.6071 | 3.5761 | 3.6 | 1781528.0 |
| 2008-10-16 09:20:00 | AAPL | Stock | 3.5993 | 3.6136 | 3.5732 | 3.5732 | 1153432.0 |
| 2008-10-16 09:25:00 | AAPL | Stock | 3.5782 | 3.5821 | 3.5536 | 3.5636 | 2483964.0 |
| 2008-10-16 09:30:00 | AAPL | Stock | 3.5632 | 3.5968 | 3.4821 | 3.5077 | 32185832.0 |
| 2008-10-16 09:35:00 | AAPL | Stock | 3.5079 | 3.5321 | 3.4739 | 3.5182 | 34723220.0 |
| 2008-10-16 09:40:00 | AAPL | Stock | 3.5207 | 3.5314 | 3.4579 | 3.4982 | 44569084.0 |
| 2008-10-16 09:45:00 | AAPL | Stock | 3.4996 | 3.5375 | 3.4868 | 3.5154 | 31425100.0 |
| 2008-10-16 09:50:00 | AAPL | Stock | 3.5161 | 3.5357 | 3.49 | 3.5021 | 27141744.0 |
| 2008-10-16 09:55:00 | AAPL | Stock | 3.5011 | 3.5014 | 3.4393 | 3.4729 | 28710724.0 |
| 2008-10-16 10:00:00 | AAPL | Stock | 3.4736 | 3.4746 | 3.4018 | 3.4086 | 39549244.0 |
| 2008-10-16 10:05:00 | AAPL | Stock | 3.4086 | 3.4382 | 3.3829 | 3.3918 | 37487492.0 |
| 2008-10-16 10:10:00 | AAPL | Stock | 3.3914 | 3.3936 | 3.31 | 3.3346 | 38936212.0 |
| 2008-10-16 10:15:00 | AAPL | Stock | 3.3343 | 3.3914 | 3.3318 | 3.3711 | 30850232.0 |
| 2008-10-16 10:20:00 | AAPL | Stock | 3.3718 | 3.4079 | 3.3679 | 3.3821 | 23933196.0 |
| 2008-10-16 10:25:00 | AAPL | Stock | 3.3829 | 3.3996 | 3.3261 | 3.3396 | 21203112.0 |
> showing 50 of 323,546 rows — these rows as CSV