PREVIEW / stock_5min / 2010-01-08
file: by_date/stock_5min/2010/2010-01-08.parquet size: 4.6 MB rows: 316,174 symbols: 3,424
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-01-08 06:05:00 | AAPL | Stock | 7.5536 | 7.5536 | 7.5536 | 7.5536 | 2800.0 |
| 2010-01-08 06:35:00 | AAPL | Stock | 7.5529 | 7.5529 | 7.5429 | 7.5429 | 5600.0 |
| 2010-01-08 06:55:00 | AAPL | Stock | 7.5393 | 7.5393 | 7.5393 | 7.5393 | 2800.0 |
| 2010-01-08 07:10:00 | AAPL | Stock | 7.5536 | 7.5536 | 7.5536 | 7.5536 | 24500.0 |
| 2010-01-08 07:30:00 | AAPL | Stock | 7.5536 | 7.5536 | 7.5536 | 7.5536 | 2800.0 |
| 2010-01-08 07:35:00 | AAPL | Stock | 7.5543 | 7.5543 | 7.5529 | 7.5529 | 16800.0 |
| 2010-01-08 07:40:00 | AAPL | Stock | 7.5436 | 7.5436 | 7.5429 | 7.5429 | 22064.0 |
| 2010-01-08 07:45:00 | AAPL | Stock | 7.5429 | 7.5429 | 7.5421 | 7.5429 | 16800.0 |
| 2010-01-08 07:50:00 | AAPL | Stock | 7.5411 | 7.5411 | 7.5411 | 7.5411 | 5600.0 |
| 2010-01-08 07:55:00 | AAPL | Stock | 7.5393 | 7.5393 | 7.5357 | 7.5357 | 11536.0 |
| 2010-01-08 08:00:00 | AAPL | Stock | 7.5421 | 7.5421 | 7.5336 | 7.535 | 84112.0 |
| 2010-01-08 08:05:00 | AAPL | Stock | 7.5357 | 7.5425 | 7.5357 | 7.5425 | 31500.0 |
| 2010-01-08 08:10:00 | AAPL | Stock | 7.5382 | 7.5411 | 7.5318 | 7.5339 | 154700.0 |
| 2010-01-08 08:15:00 | AAPL | Stock | 7.5341 | 7.5341 | 7.5118 | 7.5118 | 215068.0 |
| 2010-01-08 08:20:00 | AAPL | Stock | 7.5179 | 7.5179 | 7.5057 | 7.5179 | 321748.0 |
| 2010-01-08 08:25:00 | AAPL | Stock | 7.5214 | 7.5357 | 7.5146 | 7.5357 | 193256.0 |
| 2010-01-08 08:30:00 | AAPL | Stock | 7.5357 | 7.5357 | 7.4875 | 7.5107 | 1485036.0 |
| 2010-01-08 08:35:00 | AAPL | Stock | 7.5018 | 7.5089 | 7.4804 | 7.4818 | 488992.0 |
| 2010-01-08 08:40:00 | AAPL | Stock | 7.4786 | 7.4889 | 7.4732 | 7.4889 | 363244.0 |
| 2010-01-08 08:45:00 | AAPL | Stock | 7.4814 | 7.4968 | 7.4814 | 7.4889 | 363972.0 |
| 2010-01-08 08:50:00 | AAPL | Stock | 7.4893 | 7.4957 | 7.4893 | 7.4929 | 334740.0 |
| 2010-01-08 08:55:00 | AAPL | Stock | 7.4929 | 7.4961 | 7.4925 | 7.4957 | 350532.0 |
| 2010-01-08 09:00:00 | AAPL | Stock | 7.4964 | 7.5007 | 7.4964 | 7.5 | 530404.0 |
| 2010-01-08 09:05:00 | AAPL | Stock | 7.5021 | 7.5021 | 7.4968 | 7.5007 | 407540.0 |
| 2010-01-08 09:10:00 | AAPL | Stock | 7.4979 | 7.5 | 7.4946 | 7.4964 | 184240.0 |
| 2010-01-08 09:15:00 | AAPL | Stock | 7.4964 | 7.5025 | 7.4964 | 7.4989 | 66724.0 |
| 2010-01-08 09:20:00 | AAPL | Stock | 7.4989 | 7.5014 | 7.4982 | 7.4982 | 42056.0 |
| 2010-01-08 09:25:00 | AAPL | Stock | 7.5018 | 7.5132 | 7.4979 | 7.5118 | 550312.0 |
| 2010-01-08 09:30:00 | AAPL | Stock | 7.5107 | 7.5446 | 7.5089 | 7.5325 | 17557540.0 |
| 2010-01-08 09:35:00 | AAPL | Stock | 7.5325 | 7.5329 | 7.5036 | 7.5092 | 12604004.0 |
| 2010-01-08 09:40:00 | AAPL | Stock | 7.5086 | 7.5146 | 7.4929 | 7.5036 | 13189736.0 |
| 2010-01-08 09:45:00 | AAPL | Stock | 7.5021 | 7.5096 | 7.495 | 7.5064 | 6711236.0 |
| 2010-01-08 09:50:00 | AAPL | Stock | 7.5075 | 7.5089 | 7.4714 | 7.4782 | 14092344.0 |
| 2010-01-08 09:55:00 | AAPL | Stock | 7.4782 | 7.4954 | 7.4664 | 7.4936 | 15254008.0 |
| 2010-01-08 10:00:00 | AAPL | Stock | 7.4939 | 7.5182 | 7.4924 | 7.5093 | 16091348.0 |
| 2010-01-08 10:05:00 | AAPL | Stock | 7.5096 | 7.525 | 7.5032 | 7.5136 | 9416652.0 |
| 2010-01-08 10:10:00 | AAPL | Stock | 7.5136 | 7.5375 | 7.5096 | 7.5207 | 12782532.0 |
| 2010-01-08 10:15:00 | AAPL | Stock | 7.5218 | 7.5357 | 7.5207 | 7.5296 | 6683824.0 |
| 2010-01-08 10:20:00 | AAPL | Stock | 7.5307 | 7.54 | 7.5225 | 7.5321 | 7505148.0 |
| 2010-01-08 10:25:00 | AAPL | Stock | 7.5321 | 7.5321 | 7.5146 | 7.5218 | 5558588.0 |
| 2010-01-08 10:30:00 | AAPL | Stock | 7.5225 | 7.525 | 7.5143 | 7.5174 | 4761988.0 |
| 2010-01-08 10:35:00 | AAPL | Stock | 7.5164 | 7.5232 | 7.5096 | 7.5175 | 5807956.0 |
| 2010-01-08 10:40:00 | AAPL | Stock | 7.5173 | 7.5321 | 7.5139 | 7.5189 | 5141080.0 |
| 2010-01-08 10:45:00 | AAPL | Stock | 7.5186 | 7.5241 | 7.5057 | 7.5146 | 5580792.0 |
| 2010-01-08 10:50:00 | AAPL | Stock | 7.515 | 7.52 | 7.5079 | 7.5154 | 3276224.0 |
| 2010-01-08 10:55:00 | AAPL | Stock | 7.5161 | 7.5354 | 7.5129 | 7.5304 | 6639612.0 |
| 2010-01-08 11:00:00 | AAPL | Stock | 7.5305 | 7.5311 | 7.5143 | 7.52 | 3530016.0 |
| 2010-01-08 11:05:00 | AAPL | Stock | 7.52 | 7.5336 | 7.5161 | 7.5332 | 4239116.0 |
| 2010-01-08 11:10:00 | AAPL | Stock | 7.5336 | 7.5357 | 7.5218 | 7.525 | 5636736.0 |
| 2010-01-08 11:15:00 | AAPL | Stock | 7.5243 | 7.54 | 7.5196 | 7.5336 | 4896668.0 |
> showing 50 of 316,174 rows — these rows as CSV