PREVIEW / stock_5min / 2010-01-07
file: by_date/stock_5min/2010/2010-01-07.parquet size: 4.8 MB rows: 326,566 symbols: 3,444
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-07 06:55:00 | AAPL | Stock | 7.5357 | 7.5361 | 7.5357 | 7.5361 | 5600.0 |
| 2010-01-07 07:00:00 | AAPL | Stock | 7.5532 | 7.5532 | 7.5532 | 7.5532 | 4200.0 |
| 2010-01-07 07:05:00 | AAPL | Stock | 7.5429 | 7.5429 | 7.5429 | 7.5429 | 8400.0 |
| 2010-01-07 07:10:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 42000.0 |
| 2010-01-07 07:30:00 | AAPL | Stock | 7.5518 | 7.5518 | 7.5518 | 7.5518 | 16800.0 |
| 2010-01-07 07:40:00 | AAPL | Stock | 7.5489 | 7.5489 | 7.5482 | 7.5482 | 208320.0 |
| 2010-01-07 07:45:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5414 | 7.5414 | 16800.0 |
| 2010-01-07 07:50:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5482 | 7.5482 | 16800.0 |
| 2010-01-07 07:55:00 | AAPL | Stock | 7.5482 | 7.5482 | 7.5414 | 7.5414 | 11200.0 |
| 2010-01-07 08:00:00 | AAPL | Stock | 7.5496 | 7.55 | 7.5414 | 7.55 | 136948.0 |
| 2010-01-07 08:05:00 | AAPL | Stock | 7.5482 | 7.55 | 7.5446 | 7.55 | 67452.0 |
| 2010-01-07 08:10:00 | AAPL | Stock | 7.5446 | 7.5496 | 7.5446 | 7.5461 | 184800.0 |
| 2010-01-07 08:15:00 | AAPL | Stock | 7.5425 | 7.545 | 7.5354 | 7.5396 | 284060.0 |
| 2010-01-07 08:20:00 | AAPL | Stock | 7.5443 | 7.55 | 7.5443 | 7.5468 | 110264.0 |
| 2010-01-07 08:25:00 | AAPL | Stock | 7.5468 | 7.55 | 7.5468 | 7.55 | 87360.0 |
| 2010-01-07 08:30:00 | AAPL | Stock | 7.5468 | 7.5554 | 7.5464 | 7.5554 | 192808.0 |
| 2010-01-07 08:35:00 | AAPL | Stock | 7.5554 | 7.5668 | 7.5504 | 7.5657 | 318136.0 |
| 2010-01-07 08:40:00 | AAPL | Stock | 7.5657 | 7.5764 | 7.5625 | 7.5632 | 474600.0 |
| 2010-01-07 08:45:00 | AAPL | Stock | 7.5675 | 7.5718 | 7.5643 | 7.5675 | 430920.0 |
| 2010-01-07 08:50:00 | AAPL | Stock | 7.5675 | 7.5961 | 7.5675 | 7.59 | 553308.0 |
| 2010-01-07 08:55:00 | AAPL | Stock | 7.59 | 7.59 | 7.5739 | 7.5761 | 267176.0 |
| 2010-01-07 09:00:00 | AAPL | Stock | 7.5754 | 7.5754 | 7.5714 | 7.5729 | 211820.0 |
| 2010-01-07 09:05:00 | AAPL | Stock | 7.575 | 7.5846 | 7.575 | 7.5761 | 141064.0 |
| 2010-01-07 09:10:00 | AAPL | Stock | 7.5757 | 7.5771 | 7.5621 | 7.5632 | 442960.0 |
| 2010-01-07 09:15:00 | AAPL | Stock | 7.5639 | 7.5696 | 7.5639 | 7.5696 | 29848.0 |
| 2010-01-07 09:20:00 | AAPL | Stock | 7.5689 | 7.57 | 7.5661 | 7.5661 | 79380.0 |
| 2010-01-07 09:25:00 | AAPL | Stock | 7.5679 | 7.57 | 7.5607 | 7.5607 | 370524.0 |
| 2010-01-07 09:30:00 | AAPL | Stock | 7.5625 | 7.5714 | 7.5204 | 7.5271 | 21783888.0 |
| 2010-01-07 09:35:00 | AAPL | Stock | 7.5271 | 7.5454 | 7.4907 | 7.5154 | 22579732.0 |
| 2010-01-07 09:40:00 | AAPL | Stock | 7.5154 | 7.545 | 7.4836 | 7.5093 | 16308012.0 |
| 2010-01-07 09:45:00 | AAPL | Stock | 7.5089 | 7.5371 | 7.5075 | 7.5325 | 15829380.0 |
| 2010-01-07 09:50:00 | AAPL | Stock | 7.5321 | 7.5454 | 7.5229 | 7.5364 | 13968724.0 |
| 2010-01-07 09:55:00 | AAPL | Stock | 7.5364 | 7.5393 | 7.5036 | 7.5068 | 12841808.0 |
| 2010-01-07 10:00:00 | AAPL | Stock | 7.5093 | 7.5179 | 7.4961 | 7.5043 | 11669952.0 |
| 2010-01-07 10:05:00 | AAPL | Stock | 7.505 | 7.5168 | 7.4957 | 7.5143 | 9051784.0 |
| 2010-01-07 10:10:00 | AAPL | Stock | 7.5157 | 7.5229 | 7.5004 | 7.5007 | 6057464.0 |
| 2010-01-07 10:15:00 | AAPL | Stock | 7.5009 | 7.5089 | 7.4864 | 7.4911 | 11419156.0 |
| 2010-01-07 10:20:00 | AAPL | Stock | 7.49 | 7.4911 | 7.4743 | 7.4818 | 11258044.0 |
| 2010-01-07 10:25:00 | AAPL | Stock | 7.4804 | 7.5036 | 7.48 | 7.4979 | 9069368.0 |
| 2010-01-07 10:30:00 | AAPL | Stock | 7.4984 | 7.5146 | 7.4875 | 7.5132 | 8398992.0 |
| 2010-01-07 10:35:00 | AAPL | Stock | 7.5125 | 7.5143 | 7.5004 | 7.5089 | 6610352.0 |
| 2010-01-07 10:40:00 | AAPL | Stock | 7.5085 | 7.5243 | 7.5036 | 7.5214 | 4944632.0 |
| 2010-01-07 10:45:00 | AAPL | Stock | 7.5214 | 7.5518 | 7.5214 | 7.5468 | 15161244.0 |
| 2010-01-07 10:50:00 | AAPL | Stock | 7.5468 | 7.5471 | 7.5357 | 7.539 | 5389272.0 |
| 2010-01-07 10:55:00 | AAPL | Stock | 7.5404 | 7.55 | 7.5321 | 7.5379 | 5786648.0 |
| 2010-01-07 11:00:00 | AAPL | Stock | 7.5382 | 7.5464 | 7.5268 | 7.5307 | 7055804.0 |
| 2010-01-07 11:05:00 | AAPL | Stock | 7.5307 | 7.5339 | 7.5246 | 7.5289 | 4184460.0 |
| 2010-01-07 11:10:00 | AAPL | Stock | 7.5293 | 7.5371 | 7.5261 | 7.5332 | 3825752.0 |
| 2010-01-07 11:15:00 | AAPL | Stock | 7.5339 | 7.5339 | 7.5146 | 7.5231 | 4773244.0 |
| 2010-01-07 11:20:00 | AAPL | Stock | 7.5223 | 7.5282 | 7.515 | 7.5268 | 3440136.0 |
> showing 50 of 326,566 rows — these rows as CSV