PREVIEW / stock_5min / 2010-10-12
file: by_date/stock_5min/2010/2010-10-12.parquet size: 4.6 MB rows: 316,020 symbols: 3,480
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-12 04:00:00 | AAPL | Stock | 10.5393 | 10.5393 | 10.5393 | 10.5393 | 2800.0 |
| 2010-10-12 04:05:00 | AAPL | Stock | 10.5271 | 10.5271 | 10.5271 | 10.5271 | 2800.0 |
| 2010-10-12 04:10:00 | AAPL | Stock | 10.4821 | 10.4821 | 10.4821 | 10.4821 | 2800.0 |
| 2010-10-12 05:05:00 | AAPL | Stock | 10.4286 | 10.4286 | 10.4286 | 10.4286 | 11200.0 |
| 2010-10-12 05:15:00 | AAPL | Stock | 10.4418 | 10.4464 | 10.4418 | 10.4464 | 25200.0 |
| 2010-10-12 05:25:00 | AAPL | Stock | 10.4464 | 10.4464 | 10.4461 | 10.4461 | 11200.0 |
| 2010-10-12 05:30:00 | AAPL | Stock | 10.4818 | 10.4818 | 10.4818 | 10.4818 | 2800.0 |
| 2010-10-12 05:45:00 | AAPL | Stock | 10.4661 | 10.4661 | 10.4661 | 10.4661 | 3192.0 |
| 2010-10-12 05:50:00 | AAPL | Stock | 10.4689 | 10.4689 | 10.4689 | 10.4689 | 8960.0 |
| 2010-10-12 07:00:00 | AAPL | Stock | 10.4961 | 10.4964 | 10.4646 | 10.4786 | 71120.0 |
| 2010-10-12 07:05:00 | AAPL | Stock | 10.4882 | 10.4882 | 10.4879 | 10.4879 | 11200.0 |
| 2010-10-12 07:10:00 | AAPL | Stock | 10.4761 | 10.4761 | 10.475 | 10.475 | 19600.0 |
| 2010-10-12 07:20:00 | AAPL | Stock | 10.4836 | 10.4882 | 10.4836 | 10.4839 | 17080.0 |
| 2010-10-12 07:25:00 | AAPL | Stock | 10.4982 | 10.4982 | 10.4911 | 10.4911 | 29400.0 |
| 2010-10-12 07:30:00 | AAPL | Stock | 10.4911 | 10.4911 | 10.4893 | 10.4893 | 14000.0 |
| 2010-10-12 07:35:00 | AAPL | Stock | 10.4982 | 10.5 | 10.4982 | 10.5 | 21000.0 |
| 2010-10-12 07:40:00 | AAPL | Stock | 10.4982 | 10.525 | 10.4982 | 10.525 | 75628.0 |
| 2010-10-12 07:45:00 | AAPL | Stock | 10.5304 | 10.5371 | 10.5232 | 10.5268 | 141540.0 |
| 2010-10-12 07:50:00 | AAPL | Stock | 10.5268 | 10.5354 | 10.5268 | 10.5289 | 92176.0 |
| 2010-10-12 07:55:00 | AAPL | Stock | 10.5304 | 10.5357 | 10.5304 | 10.5357 | 22680.0 |
| 2010-10-12 08:00:00 | AAPL | Stock | 10.5375 | 10.5611 | 10.5357 | 10.5411 | 520268.0 |
| 2010-10-12 08:05:00 | AAPL | Stock | 10.5429 | 10.5457 | 10.5361 | 10.5361 | 292600.0 |
| 2010-10-12 08:10:00 | AAPL | Stock | 10.5375 | 10.5411 | 10.5268 | 10.5304 | 613144.0 |
| 2010-10-12 08:15:00 | AAPL | Stock | 10.5357 | 10.5357 | 10.5257 | 10.5286 | 278600.0 |
| 2010-10-12 08:20:00 | AAPL | Stock | 10.5257 | 10.5404 | 10.5229 | 10.5357 | 265664.0 |
| 2010-10-12 08:25:00 | AAPL | Stock | 10.5357 | 10.5382 | 10.525 | 10.5304 | 187880.0 |
| 2010-10-12 08:30:00 | AAPL | Stock | 10.5307 | 10.55 | 10.5282 | 10.5496 | 169708.0 |
| 2010-10-12 08:35:00 | AAPL | Stock | 10.5461 | 10.5529 | 10.5446 | 10.5482 | 229600.0 |
| 2010-10-12 08:40:00 | AAPL | Stock | 10.5471 | 10.5711 | 10.5464 | 10.5621 | 530040.0 |
| 2010-10-12 08:45:00 | AAPL | Stock | 10.5611 | 10.5779 | 10.5611 | 10.5714 | 320768.0 |
| 2010-10-12 08:50:00 | AAPL | Stock | 10.575 | 10.5757 | 10.5689 | 10.5714 | 124516.0 |
| 2010-10-12 08:55:00 | AAPL | Stock | 10.5739 | 10.5786 | 10.5739 | 10.5743 | 112392.0 |
| 2010-10-12 09:00:00 | AAPL | Stock | 10.5721 | 10.5729 | 10.5643 | 10.565 | 192024.0 |
| 2010-10-12 09:05:00 | AAPL | Stock | 10.5661 | 10.5696 | 10.5632 | 10.5661 | 279804.0 |
| 2010-10-12 09:10:00 | AAPL | Stock | 10.5661 | 10.5714 | 10.5629 | 10.5664 | 165200.0 |
| 2010-10-12 09:15:00 | AAPL | Stock | 10.5704 | 10.5746 | 10.5696 | 10.5746 | 318416.0 |
| 2010-10-12 09:20:00 | AAPL | Stock | 10.5736 | 10.5786 | 10.5618 | 10.5625 | 369516.0 |
| 2010-10-12 09:25:00 | AAPL | Stock | 10.5625 | 10.5625 | 10.5486 | 10.5504 | 341600.0 |
| 2010-10-12 09:30:00 | AAPL | Stock | 10.5504 | 10.5804 | 10.5286 | 10.5643 | 17182144.0 |
| 2010-10-12 09:35:00 | AAPL | Stock | 10.5639 | 10.5961 | 10.5571 | 10.5786 | 17346392.0 |
| 2010-10-12 09:40:00 | AAPL | Stock | 10.5782 | 10.5789 | 10.5571 | 10.5593 | 11143104.0 |
| 2010-10-12 09:45:00 | AAPL | Stock | 10.5589 | 10.561 | 10.4743 | 10.4818 | 25050620.0 |
| 2010-10-12 09:50:00 | AAPL | Stock | 10.4814 | 10.4957 | 10.4461 | 10.4786 | 24977540.0 |
| 2010-10-12 09:55:00 | AAPL | Stock | 10.4768 | 10.4975 | 10.4707 | 10.485 | 10426724.0 |
| 2010-10-12 10:00:00 | AAPL | Stock | 10.485 | 10.5196 | 10.4821 | 10.5132 | 13660556.0 |
| 2010-10-12 10:05:00 | AAPL | Stock | 10.5121 | 10.5304 | 10.5043 | 10.5057 | 7396956.0 |
| 2010-10-12 10:10:00 | AAPL | Stock | 10.5046 | 10.5418 | 10.5036 | 10.5404 | 7295904.0 |
| 2010-10-12 10:15:00 | AAPL | Stock | 10.5375 | 10.5607 | 10.5346 | 10.5564 | 16014544.0 |
| 2010-10-12 10:20:00 | AAPL | Stock | 10.5554 | 10.5625 | 10.5475 | 10.5479 | 7581588.0 |
| 2010-10-12 10:25:00 | AAPL | Stock | 10.5493 | 10.56 | 10.5457 | 10.5482 | 4928392.0 |
> showing 50 of 316,020 rows — these rows as CSV