PREVIEW / stock_5min / 2010-10-11
file: by_date/stock_5min/2010/2010-10-11.parquet size: 4.4 MB rows: 307,781 symbols: 3,465
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-11 04:15:00 | AAPL | Stock | 10.4929 | 10.4929 | 10.4929 | 10.4929 | 2800.0 |
| 2010-10-11 06:45:00 | AAPL | Stock | 10.5107 | 10.5107 | 10.5107 | 10.5107 | 2800.0 |
| 2010-10-11 06:50:00 | AAPL | Stock | 10.5111 | 10.5111 | 10.5111 | 10.5111 | 2800.0 |
| 2010-10-11 07:00:00 | AAPL | Stock | 10.5346 | 10.5346 | 10.5346 | 10.5346 | 2800.0 |
| 2010-10-11 07:05:00 | AAPL | Stock | 10.5154 | 10.5154 | 10.5154 | 10.5154 | 2800.0 |
| 2010-10-11 07:20:00 | AAPL | Stock | 10.52 | 10.52 | 10.5196 | 10.5196 | 8400.0 |
| 2010-10-11 07:25:00 | AAPL | Stock | 10.5218 | 10.5325 | 10.5218 | 10.5325 | 11200.0 |
| 2010-10-11 07:30:00 | AAPL | Stock | 10.5307 | 10.5357 | 10.5296 | 10.5357 | 42000.0 |
| 2010-10-11 07:40:00 | AAPL | Stock | 10.5375 | 10.5375 | 10.5375 | 10.5375 | 2800.0 |
| 2010-10-11 07:45:00 | AAPL | Stock | 10.5357 | 10.5393 | 10.5357 | 10.5361 | 30464.0 |
| 2010-10-11 07:50:00 | AAPL | Stock | 10.5357 | 10.5446 | 10.5357 | 10.5429 | 78736.0 |
| 2010-10-11 07:55:00 | AAPL | Stock | 10.5414 | 10.5414 | 10.5364 | 10.5364 | 45080.0 |
| 2010-10-11 08:00:00 | AAPL | Stock | 10.5357 | 10.5393 | 10.5225 | 10.5357 | 703444.0 |
| 2010-10-11 08:05:00 | AAPL | Stock | 10.5354 | 10.5357 | 10.5321 | 10.5357 | 261520.0 |
| 2010-10-11 08:10:00 | AAPL | Stock | 10.5357 | 10.5364 | 10.5325 | 10.5343 | 190820.0 |
| 2010-10-11 08:15:00 | AAPL | Stock | 10.5354 | 10.5429 | 10.5354 | 10.5357 | 117992.0 |
| 2010-10-11 08:20:00 | AAPL | Stock | 10.5396 | 10.5439 | 10.5357 | 10.5439 | 303324.0 |
| 2010-10-11 08:25:00 | AAPL | Stock | 10.5414 | 10.5439 | 10.5357 | 10.5393 | 118944.0 |
| 2010-10-11 08:30:00 | AAPL | Stock | 10.5396 | 10.5396 | 10.5307 | 10.5307 | 430444.0 |
| 2010-10-11 08:35:00 | AAPL | Stock | 10.5307 | 10.5336 | 10.5268 | 10.5336 | 140728.0 |
| 2010-10-11 08:40:00 | AAPL | Stock | 10.5311 | 10.5339 | 10.5268 | 10.5339 | 386596.0 |
| 2010-10-11 08:45:00 | AAPL | Stock | 10.5343 | 10.5357 | 10.5307 | 10.5343 | 180768.0 |
| 2010-10-11 08:50:00 | AAPL | Stock | 10.5354 | 10.5393 | 10.5325 | 10.5389 | 373324.0 |
| 2010-10-11 08:55:00 | AAPL | Stock | 10.5389 | 10.5389 | 10.5339 | 10.5357 | 174188.0 |
| 2010-10-11 09:00:00 | AAPL | Stock | 10.5361 | 10.5375 | 10.5293 | 10.5293 | 146580.0 |
| 2010-10-11 09:05:00 | AAPL | Stock | 10.5289 | 10.5321 | 10.5286 | 10.5304 | 208348.0 |
| 2010-10-11 09:10:00 | AAPL | Stock | 10.5304 | 10.535 | 10.53 | 10.5304 | 119504.0 |
| 2010-10-11 09:15:00 | AAPL | Stock | 10.5296 | 10.5296 | 10.5268 | 10.5296 | 112336.0 |
| 2010-10-11 09:20:00 | AAPL | Stock | 10.5286 | 10.5293 | 10.5229 | 10.5239 | 366268.0 |
| 2010-10-11 09:25:00 | AAPL | Stock | 10.5229 | 10.53 | 10.5179 | 10.5275 | 342832.0 |
| 2010-10-11 09:30:00 | AAPL | Stock | 10.5268 | 10.5804 | 10.5264 | 10.5611 | 28710080.0 |
| 2010-10-11 09:35:00 | AAPL | Stock | 10.5625 | 10.5961 | 10.5564 | 10.5825 | 15256388.0 |
| 2010-10-11 09:40:00 | AAPL | Stock | 10.5839 | 10.5925 | 10.5679 | 10.5739 | 11387628.0 |
| 2010-10-11 09:45:00 | AAPL | Stock | 10.575 | 10.5782 | 10.5454 | 10.5493 | 11159176.0 |
| 2010-10-11 09:50:00 | AAPL | Stock | 10.5518 | 10.5675 | 10.5357 | 10.5655 | 10356976.0 |
| 2010-10-11 09:55:00 | AAPL | Stock | 10.5661 | 10.5764 | 10.5589 | 10.5764 | 9293676.0 |
| 2010-10-11 10:00:00 | AAPL | Stock | 10.5754 | 10.5918 | 10.5729 | 10.5786 | 11389140.0 |
| 2010-10-11 10:05:00 | AAPL | Stock | 10.5786 | 10.5964 | 10.5761 | 10.5839 | 9260244.0 |
| 2010-10-11 10:10:00 | AAPL | Stock | 10.5839 | 10.5843 | 10.5679 | 10.5739 | 7917252.0 |
| 2010-10-11 10:15:00 | AAPL | Stock | 10.5739 | 10.5882 | 10.5714 | 10.5839 | 6865992.0 |
| 2010-10-11 10:20:00 | AAPL | Stock | 10.5839 | 10.6025 | 10.5825 | 10.6011 | 10816092.0 |
| 2010-10-11 10:25:00 | AAPL | Stock | 10.6023 | 10.6114 | 10.5957 | 10.6036 | 13998292.0 |
| 2010-10-11 10:30:00 | AAPL | Stock | 10.6036 | 10.6071 | 10.58 | 10.5859 | 8116752.0 |
| 2010-10-11 10:35:00 | AAPL | Stock | 10.5857 | 10.5911 | 10.5821 | 10.5889 | 4099928.0 |
| 2010-10-11 10:40:00 | AAPL | Stock | 10.5889 | 10.5975 | 10.5846 | 10.5868 | 4679808.0 |
| 2010-10-11 10:45:00 | AAPL | Stock | 10.5861 | 10.5861 | 10.5604 | 10.5631 | 10029852.0 |
| 2010-10-11 10:50:00 | AAPL | Stock | 10.5625 | 10.5704 | 10.5571 | 10.5624 | 5256160.0 |
| 2010-10-11 10:55:00 | AAPL | Stock | 10.5625 | 10.5768 | 10.5607 | 10.573 | 4924052.0 |
| 2010-10-11 11:00:00 | AAPL | Stock | 10.5721 | 10.5821 | 10.5668 | 10.5757 | 3408804.0 |
| 2010-10-11 11:05:00 | AAPL | Stock | 10.5757 | 10.5775 | 10.5661 | 10.5746 | 3098928.0 |
> showing 50 of 307,781 rows — these rows as CSV