PREVIEW / stock_5min / 2013-01-16
file: by_date/stock_5min/2013/2013-01-16.parquet size: 4.7 MB rows: 318,486 symbols: 3,463
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 |
|---|---|---|---|---|---|---|---|
| 2013-01-16 04:00:00 | AAPL | Stock | 17.4989 | 17.4989 | 17.4125 | 17.4339 | 19600.0 |
| 2013-01-16 04:05:00 | AAPL | Stock | 17.4321 | 17.4321 | 17.4239 | 17.4239 | 5600.0 |
| 2013-01-16 04:10:00 | AAPL | Stock | 17.4243 | 17.4243 | 17.4243 | 17.4243 | 2800.0 |
| 2013-01-16 04:30:00 | AAPL | Stock | 17.4371 | 17.4371 | 17.4371 | 17.4371 | 2800.0 |
| 2013-01-16 04:45:00 | AAPL | Stock | 17.4289 | 17.4289 | 17.4289 | 17.4289 | 2800.0 |
| 2013-01-16 05:05:00 | AAPL | Stock | 17.4336 | 17.4336 | 17.4336 | 17.4336 | 2800.0 |
| 2013-01-16 05:15:00 | AAPL | Stock | 17.4307 | 17.4339 | 17.4125 | 17.4125 | 8400.0 |
| 2013-01-16 05:20:00 | AAPL | Stock | 17.4111 | 17.4111 | 17.4111 | 17.4111 | 13020.0 |
| 2013-01-16 05:25:00 | AAPL | Stock | 17.4321 | 17.4321 | 17.4321 | 17.4321 | 2800.0 |
| 2013-01-16 05:35:00 | AAPL | Stock | 17.4214 | 17.4214 | 17.4214 | 17.4214 | 2800.0 |
| 2013-01-16 05:45:00 | AAPL | Stock | 17.4332 | 17.4332 | 17.4325 | 17.4325 | 11200.0 |
| 2013-01-16 05:55:00 | AAPL | Stock | 17.4371 | 17.4371 | 17.3932 | 17.3932 | 69944.0 |
| 2013-01-16 06:10:00 | AAPL | Stock | 17.4282 | 17.4282 | 17.4282 | 17.4282 | 2800.0 |
| 2013-01-16 06:20:00 | AAPL | Stock | 17.4604 | 17.4679 | 17.4464 | 17.4464 | 47152.0 |
| 2013-01-16 06:25:00 | AAPL | Stock | 17.4643 | 17.4646 | 17.4643 | 17.4643 | 19600.0 |
| 2013-01-16 06:30:00 | AAPL | Stock | 17.4814 | 17.4929 | 17.4814 | 17.4893 | 30800.0 |
| 2013-01-16 06:35:00 | AAPL | Stock | 17.4732 | 17.4732 | 17.4654 | 17.4654 | 9800.0 |
| 2013-01-16 06:40:00 | AAPL | Stock | 17.4643 | 17.4643 | 17.4025 | 17.4107 | 178556.0 |
| 2013-01-16 06:45:00 | AAPL | Stock | 17.4125 | 17.4204 | 17.4125 | 17.4196 | 36400.0 |
| 2013-01-16 06:50:00 | AAPL | Stock | 17.4321 | 17.4457 | 17.4196 | 17.4457 | 19600.0 |
| 2013-01-16 06:55:00 | AAPL | Stock | 17.4286 | 17.4439 | 17.4279 | 17.4439 | 64400.0 |
| 2013-01-16 07:00:00 | AAPL | Stock | 17.4432 | 17.4821 | 17.4429 | 17.4746 | 205520.0 |
| 2013-01-16 07:05:00 | AAPL | Stock | 17.475 | 17.475 | 17.4439 | 17.4468 | 102144.0 |
| 2013-01-16 07:10:00 | AAPL | Stock | 17.4754 | 17.4754 | 17.4754 | 17.4754 | 2800.0 |
| 2013-01-16 07:15:00 | AAPL | Stock | 17.4886 | 17.5396 | 17.4886 | 17.5396 | 165284.0 |
| 2013-01-16 07:20:00 | AAPL | Stock | 17.5379 | 17.5396 | 17.4286 | 17.4736 | 565628.0 |
| 2013-01-16 07:25:00 | AAPL | Stock | 17.4736 | 17.5 | 17.4686 | 17.4689 | 214200.0 |
| 2013-01-16 07:30:00 | AAPL | Stock | 17.4704 | 17.4825 | 17.4529 | 17.4821 | 187152.0 |
| 2013-01-16 07:35:00 | AAPL | Stock | 17.4821 | 17.5271 | 17.4821 | 17.5179 | 253260.0 |
| 2013-01-16 07:40:00 | AAPL | Stock | 17.5179 | 17.5796 | 17.5179 | 17.55 | 187824.0 |
| 2013-01-16 07:45:00 | AAPL | Stock | 17.55 | 17.5536 | 17.5329 | 17.5329 | 141512.0 |
| 2013-01-16 07:50:00 | AAPL | Stock | 17.5332 | 17.6321 | 17.5271 | 17.6071 | 624092.0 |
| 2013-01-16 07:55:00 | AAPL | Stock | 17.625 | 17.6375 | 17.6 | 17.6 | 464492.0 |
| 2013-01-16 08:00:00 | AAPL | Stock | 17.6043 | 17.6604 | 17.5 | 17.6111 | 1789788.0 |
| 2013-01-16 08:05:00 | AAPL | Stock | 17.625 | 17.6786 | 17.605 | 17.625 | 1047228.0 |
| 2013-01-16 08:10:00 | AAPL | Stock | 17.625 | 17.625 | 17.5979 | 17.5979 | 869708.0 |
| 2013-01-16 08:15:00 | AAPL | Stock | 17.6036 | 17.6225 | 17.5761 | 17.5839 | 984200.0 |
| 2013-01-16 08:20:00 | AAPL | Stock | 17.5836 | 17.5893 | 17.5754 | 17.5857 | 377944.0 |
| 2013-01-16 08:25:00 | AAPL | Stock | 17.5857 | 17.5893 | 17.5768 | 17.5807 | 254828.0 |
| 2013-01-16 08:30:00 | AAPL | Stock | 17.5804 | 17.5804 | 17.5457 | 17.5557 | 909608.0 |
| 2013-01-16 08:35:00 | AAPL | Stock | 17.5575 | 17.5618 | 17.5411 | 17.5421 | 339808.0 |
| 2013-01-16 08:40:00 | AAPL | Stock | 17.5479 | 17.5643 | 17.5268 | 17.5643 | 828576.0 |
| 2013-01-16 08:45:00 | AAPL | Stock | 17.5696 | 17.5893 | 17.5629 | 17.5814 | 448280.0 |
| 2013-01-16 08:50:00 | AAPL | Stock | 17.5846 | 17.6132 | 17.5804 | 17.6132 | 903252.0 |
| 2013-01-16 08:55:00 | AAPL | Stock | 17.6143 | 17.6411 | 17.6071 | 17.61 | 1049244.0 |
| 2013-01-16 09:00:00 | AAPL | Stock | 17.61 | 17.6161 | 17.5832 | 17.5832 | 601384.0 |
| 2013-01-16 09:05:00 | AAPL | Stock | 17.5861 | 17.615 | 17.5714 | 17.6125 | 611268.0 |
| 2013-01-16 09:10:00 | AAPL | Stock | 17.6096 | 17.6354 | 17.6089 | 17.6286 | 955780.0 |
| 2013-01-16 09:15:00 | AAPL | Stock | 17.6214 | 17.6607 | 17.6111 | 17.6479 | 1048348.0 |
| 2013-01-16 09:20:00 | AAPL | Stock | 17.65 | 17.6932 | 17.6475 | 17.6868 | 2323972.0 |
> showing 50 of 318,486 rows — these rows as CSV