PREVIEW / stock_5min / 2008-01-28
file: by_date/stock_5min/2008/2008-01-28.parquet size: 4.4 MB rows: 322,034 symbols: 3,264
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-01-28 06:50:00 | AAPL | Stock | 4.5714 | 4.5714 | 4.5714 | 4.5714 | 2800.0 |
| 2008-01-28 07:10:00 | AAPL | Stock | 4.5979 | 4.6021 | 4.5964 | 4.6021 | 38752.0 |
| 2008-01-28 07:15:00 | AAPL | Stock | 4.6021 | 4.6021 | 4.6021 | 4.6021 | 2800.0 |
| 2008-01-28 07:25:00 | AAPL | Stock | 4.5896 | 4.6 | 4.5893 | 4.6 | 114968.0 |
| 2008-01-28 07:30:00 | AAPL | Stock | 4.5857 | 4.5996 | 4.5736 | 4.5736 | 53480.0 |
| 2008-01-28 07:35:00 | AAPL | Stock | 4.5929 | 4.5929 | 4.5929 | 4.5929 | 2800.0 |
| 2008-01-28 07:40:00 | AAPL | Stock | 4.5921 | 4.5921 | 4.5829 | 4.5893 | 18200.0 |
| 2008-01-28 07:45:00 | AAPL | Stock | 4.5961 | 4.6061 | 4.5961 | 4.6061 | 120036.0 |
| 2008-01-28 07:50:00 | AAPL | Stock | 4.6082 | 4.6161 | 4.6071 | 4.6161 | 137928.0 |
| 2008-01-28 07:55:00 | AAPL | Stock | 4.61 | 4.62 | 4.6071 | 4.6071 | 39760.0 |
| 2008-01-28 08:00:00 | AAPL | Stock | 4.6071 | 4.6125 | 4.575 | 4.6114 | 952784.0 |
| 2008-01-28 08:05:00 | AAPL | Stock | 4.6068 | 4.6161 | 4.5821 | 4.5821 | 688072.0 |
| 2008-01-28 08:10:00 | AAPL | Stock | 4.5893 | 4.5939 | 4.5714 | 4.585 | 953848.0 |
| 2008-01-28 08:15:00 | AAPL | Stock | 4.5839 | 4.585 | 4.575 | 4.5779 | 674128.0 |
| 2008-01-28 08:20:00 | AAPL | Stock | 4.5764 | 4.5807 | 4.5718 | 4.5725 | 474040.0 |
| 2008-01-28 08:25:00 | AAPL | Stock | 4.5725 | 4.5739 | 4.5571 | 4.5714 | 689892.0 |
| 2008-01-28 08:30:00 | AAPL | Stock | 4.5757 | 4.5857 | 4.5714 | 4.5764 | 557200.0 |
| 2008-01-28 08:35:00 | AAPL | Stock | 4.5743 | 4.5768 | 4.5496 | 4.5511 | 727720.0 |
| 2008-01-28 08:40:00 | AAPL | Stock | 4.5589 | 4.5643 | 4.5489 | 4.5643 | 651140.0 |
| 2008-01-28 08:45:00 | AAPL | Stock | 4.5643 | 4.5786 | 4.5632 | 4.5711 | 633640.0 |
| 2008-01-28 08:50:00 | AAPL | Stock | 4.5693 | 4.5714 | 4.5643 | 4.565 | 543928.0 |
| 2008-01-28 08:55:00 | AAPL | Stock | 4.565 | 4.5736 | 4.5643 | 4.5725 | 578900.0 |
| 2008-01-28 09:00:00 | AAPL | Stock | 4.5714 | 4.5736 | 4.5675 | 4.5682 | 581448.0 |
| 2008-01-28 09:05:00 | AAPL | Stock | 4.5682 | 4.5732 | 4.5654 | 4.5714 | 949984.0 |
| 2008-01-28 09:10:00 | AAPL | Stock | 4.5729 | 4.5775 | 4.5636 | 4.5643 | 726460.0 |
| 2008-01-28 09:15:00 | AAPL | Stock | 4.5643 | 4.5946 | 4.5643 | 4.5857 | 788900.0 |
| 2008-01-28 09:20:00 | AAPL | Stock | 4.5861 | 4.5861 | 4.5764 | 4.5861 | 299208.0 |
| 2008-01-28 09:25:00 | AAPL | Stock | 4.5861 | 4.5868 | 4.5639 | 4.5771 | 1064756.0 |
| 2008-01-28 09:30:00 | AAPL | Stock | 4.5771 | 4.5782 | 4.5196 | 4.5504 | 55983060.0 |
| 2008-01-28 09:35:00 | AAPL | Stock | 4.5496 | 4.5539 | 4.5161 | 4.5529 | 37989672.0 |
| 2008-01-28 09:40:00 | AAPL | Stock | 4.5532 | 4.5796 | 4.5268 | 4.5675 | 41430004.0 |
| 2008-01-28 09:45:00 | AAPL | Stock | 4.5689 | 4.6232 | 4.5464 | 4.6068 | 44380056.0 |
| 2008-01-28 09:50:00 | AAPL | Stock | 4.6071 | 4.6179 | 4.5936 | 4.6 | 28870604.0 |
| 2008-01-28 09:55:00 | AAPL | Stock | 4.6 | 4.6368 | 4.5957 | 4.628 | 25378892.0 |
| 2008-01-28 10:00:00 | AAPL | Stock | 4.6282 | 4.6286 | 4.5804 | 4.5917 | 28705264.0 |
| 2008-01-28 10:05:00 | AAPL | Stock | 4.5918 | 4.5921 | 4.5575 | 4.5611 | 27079136.0 |
| 2008-01-28 10:10:00 | AAPL | Stock | 4.5602 | 4.5804 | 4.56 | 4.5717 | 24927028.0 |
| 2008-01-28 10:15:00 | AAPL | Stock | 4.5711 | 4.5939 | 4.5707 | 4.5821 | 17855936.0 |
| 2008-01-28 10:20:00 | AAPL | Stock | 4.5821 | 4.6196 | 4.5814 | 4.6054 | 27846420.0 |
| 2008-01-28 10:25:00 | AAPL | Stock | 4.605 | 4.6386 | 4.5896 | 4.6375 | 23944844.0 |
| 2008-01-28 10:30:00 | AAPL | Stock | 4.6386 | 4.65 | 4.6204 | 4.6389 | 33307764.0 |
| 2008-01-28 10:35:00 | AAPL | Stock | 4.6393 | 4.6639 | 4.6261 | 4.6339 | 25019708.0 |
| 2008-01-28 10:40:00 | AAPL | Stock | 4.6339 | 4.6571 | 4.6311 | 4.6457 | 22878884.0 |
| 2008-01-28 10:45:00 | AAPL | Stock | 4.6457 | 4.7046 | 4.6446 | 4.6924 | 32040624.0 |
| 2008-01-28 10:50:00 | AAPL | Stock | 4.6929 | 4.7079 | 4.6821 | 4.695 | 23394560.0 |
| 2008-01-28 10:55:00 | AAPL | Stock | 4.6954 | 4.7068 | 4.6796 | 4.6807 | 17363976.0 |
| 2008-01-28 11:00:00 | AAPL | Stock | 4.6811 | 4.7571 | 4.6714 | 4.7125 | 22418620.0 |
| 2008-01-28 11:05:00 | AAPL | Stock | 4.7114 | 4.7218 | 4.6964 | 4.7046 | 26925052.0 |
| 2008-01-28 11:10:00 | AAPL | Stock | 4.7057 | 4.7214 | 4.6995 | 4.7043 | 16883244.0 |
| 2008-01-28 11:15:00 | AAPL | Stock | 4.7054 | 4.7071 | 4.6818 | 4.6839 | 17719408.0 |
> showing 50 of 322,034 rows — these rows as CSV