PREVIEW / stock_5min / 2008-03-12
file: by_date/stock_5min/2008/2008-03-12.parquet size: 4.4 MB rows: 319,471 symbols: 3,268
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-03-12 05:50:00 | AAPL | Stock | 4.5593 | 4.5593 | 4.5593 | 4.5593 | 8400.0 |
| 2008-03-12 06:30:00 | AAPL | Stock | 4.5739 | 4.5739 | 4.5739 | 4.5739 | 8400.0 |
| 2008-03-12 06:35:00 | AAPL | Stock | 4.5775 | 4.5775 | 4.5775 | 4.5775 | 5600.0 |
| 2008-03-12 06:50:00 | AAPL | Stock | 4.5689 | 4.5689 | 4.5689 | 4.5689 | 8400.0 |
| 2008-03-12 07:05:00 | AAPL | Stock | 4.5593 | 4.5593 | 4.5593 | 4.5593 | 2800.0 |
| 2008-03-12 07:25:00 | AAPL | Stock | 4.5618 | 4.5618 | 4.5618 | 4.5618 | 12880.0 |
| 2008-03-12 07:30:00 | AAPL | Stock | 4.5614 | 4.5614 | 4.5586 | 4.5586 | 38696.0 |
| 2008-03-12 07:35:00 | AAPL | Stock | 4.5607 | 4.5625 | 4.5589 | 4.5589 | 29288.0 |
| 2008-03-12 07:40:00 | AAPL | Stock | 4.5557 | 4.5571 | 4.5475 | 4.5571 | 68600.0 |
| 2008-03-12 07:45:00 | AAPL | Stock | 4.56 | 4.56 | 4.5496 | 4.5496 | 31500.0 |
| 2008-03-12 07:50:00 | AAPL | Stock | 4.5482 | 4.5486 | 4.54 | 4.5429 | 79464.0 |
| 2008-03-12 07:55:00 | AAPL | Stock | 4.5464 | 4.55 | 4.5464 | 4.5496 | 98280.0 |
| 2008-03-12 08:00:00 | AAPL | Stock | 4.5464 | 4.5482 | 4.5196 | 4.5232 | 656012.0 |
| 2008-03-12 08:05:00 | AAPL | Stock | 4.5232 | 4.5232 | 4.5125 | 4.5161 | 613088.0 |
| 2008-03-12 08:10:00 | AAPL | Stock | 4.5161 | 4.5179 | 4.5125 | 4.5139 | 242788.0 |
| 2008-03-12 08:15:00 | AAPL | Stock | 4.5129 | 4.525 | 4.5129 | 4.5221 | 228256.0 |
| 2008-03-12 08:20:00 | AAPL | Stock | 4.5229 | 4.5246 | 4.5193 | 4.5246 | 219436.0 |
| 2008-03-12 08:25:00 | AAPL | Stock | 4.525 | 4.5318 | 4.5246 | 4.5286 | 346164.0 |
| 2008-03-12 08:30:00 | AAPL | Stock | 4.5307 | 4.5318 | 4.5286 | 4.5286 | 69580.0 |
| 2008-03-12 08:35:00 | AAPL | Stock | 4.5271 | 4.5271 | 4.5221 | 4.5243 | 133140.0 |
| 2008-03-12 08:40:00 | AAPL | Stock | 4.525 | 4.5254 | 4.5168 | 4.5179 | 182140.0 |
| 2008-03-12 08:45:00 | AAPL | Stock | 4.5179 | 4.5214 | 4.5143 | 4.5214 | 167384.0 |
| 2008-03-12 08:50:00 | AAPL | Stock | 4.5211 | 4.5214 | 4.5179 | 4.5211 | 108920.0 |
| 2008-03-12 08:55:00 | AAPL | Stock | 4.5211 | 4.5225 | 4.5189 | 4.5218 | 119532.0 |
| 2008-03-12 09:00:00 | AAPL | Stock | 4.5214 | 4.5268 | 4.5214 | 4.5246 | 164024.0 |
| 2008-03-12 09:05:00 | AAPL | Stock | 4.5246 | 4.5264 | 4.5229 | 4.5236 | 156072.0 |
| 2008-03-12 09:10:00 | AAPL | Stock | 4.5232 | 4.5286 | 4.5232 | 4.5268 | 131068.0 |
| 2008-03-12 09:15:00 | AAPL | Stock | 4.5286 | 4.5396 | 4.5239 | 4.5396 | 777224.0 |
| 2008-03-12 09:20:00 | AAPL | Stock | 4.5396 | 4.5454 | 4.5357 | 4.5382 | 406000.0 |
| 2008-03-12 09:25:00 | AAPL | Stock | 4.5386 | 4.5446 | 4.5357 | 4.5382 | 812140.0 |
| 2008-03-12 09:30:00 | AAPL | Stock | 4.5379 | 4.5496 | 4.5129 | 4.5354 | 31929408.0 |
| 2008-03-12 09:35:00 | AAPL | Stock | 4.535 | 4.545 | 4.5054 | 4.5111 | 23676548.0 |
| 2008-03-12 09:40:00 | AAPL | Stock | 4.5107 | 4.5193 | 4.49 | 4.4986 | 18389084.0 |
| 2008-03-12 09:45:00 | AAPL | Stock | 4.4989 | 4.5175 | 4.4954 | 4.5111 | 18121460.0 |
| 2008-03-12 09:50:00 | AAPL | Stock | 4.5114 | 4.5132 | 4.4879 | 4.5064 | 16916928.0 |
| 2008-03-12 09:55:00 | AAPL | Stock | 4.5057 | 4.51 | 4.4929 | 4.4993 | 18128124.0 |
| 2008-03-12 10:00:00 | AAPL | Stock | 4.4982 | 4.5086 | 4.4821 | 4.4832 | 16241120.0 |
| 2008-03-12 10:05:00 | AAPL | Stock | 4.4825 | 4.4861 | 4.475 | 4.4821 | 16251312.0 |
| 2008-03-12 10:10:00 | AAPL | Stock | 4.4821 | 4.505 | 4.4818 | 4.5025 | 13875288.0 |
| 2008-03-12 10:15:00 | AAPL | Stock | 4.5029 | 4.5111 | 4.4975 | 4.5107 | 15215536.0 |
| 2008-03-12 10:20:00 | AAPL | Stock | 4.5107 | 4.5154 | 4.4968 | 4.4968 | 13815872.0 |
| 2008-03-12 10:25:00 | AAPL | Stock | 4.4975 | 4.5014 | 4.4861 | 4.4993 | 9694972.0 |
| 2008-03-12 10:30:00 | AAPL | Stock | 4.4993 | 4.5093 | 4.4971 | 4.5068 | 11635652.0 |
| 2008-03-12 10:35:00 | AAPL | Stock | 4.5064 | 4.5229 | 4.5039 | 4.5229 | 16000516.0 |
| 2008-03-12 10:40:00 | AAPL | Stock | 4.5221 | 4.5479 | 4.5157 | 4.5411 | 26798128.0 |
| 2008-03-12 10:45:00 | AAPL | Stock | 4.54 | 4.5718 | 4.5375 | 4.5618 | 39081420.0 |
| 2008-03-12 10:50:00 | AAPL | Stock | 4.5621 | 4.5782 | 4.5604 | 4.5614 | 23381288.0 |
| 2008-03-12 10:55:00 | AAPL | Stock | 4.5618 | 4.5636 | 4.5443 | 4.5625 | 18265072.0 |
| 2008-03-12 11:00:00 | AAPL | Stock | 4.5629 | 4.5775 | 4.5596 | 4.5725 | 19747308.0 |
| 2008-03-12 11:05:00 | AAPL | Stock | 4.5725 | 4.5732 | 4.5589 | 4.5625 | 12535824.0 |
> showing 50 of 319,471 rows — these rows as CSV