PREVIEW / stock_5min / 2012-03-12
file: by_date/stock_5min/2012/2012-03-12.parquet size: 4.7 MB rows: 321,106 symbols: 3,512
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 |
|---|---|---|---|---|---|---|---|
| 2012-03-12 05:05:00 | AAPL | Stock | 19.4643 | 19.4643 | 19.4643 | 19.4643 | 9800.0 |
| 2012-03-12 05:10:00 | AAPL | Stock | 19.4579 | 19.4643 | 19.4579 | 19.4643 | 8400.0 |
| 2012-03-12 05:25:00 | AAPL | Stock | 19.4418 | 19.4418 | 19.4414 | 19.4414 | 27608.0 |
| 2012-03-12 05:45:00 | AAPL | Stock | 19.4568 | 19.4568 | 19.4564 | 19.4564 | 5600.0 |
| 2012-03-12 05:50:00 | AAPL | Stock | 19.4564 | 19.4564 | 19.4564 | 19.4564 | 2800.0 |
| 2012-03-12 06:05:00 | AAPL | Stock | 19.4557 | 19.4557 | 19.4557 | 19.4557 | 30800.0 |
| 2012-03-12 06:10:00 | AAPL | Stock | 19.4557 | 19.4557 | 19.4536 | 19.4536 | 5600.0 |
| 2012-03-12 06:20:00 | AAPL | Stock | 19.4546 | 19.4546 | 19.4546 | 19.4546 | 2800.0 |
| 2012-03-12 07:00:00 | AAPL | Stock | 19.4607 | 19.4679 | 19.4607 | 19.4643 | 32592.0 |
| 2012-03-12 07:05:00 | AAPL | Stock | 19.4643 | 19.4732 | 19.4643 | 19.4679 | 152460.0 |
| 2012-03-12 07:10:00 | AAPL | Stock | 19.4732 | 19.4786 | 19.4714 | 19.4786 | 38668.0 |
| 2012-03-12 07:15:00 | AAPL | Stock | 19.4814 | 19.4929 | 19.4786 | 19.4929 | 84560.0 |
| 2012-03-12 07:20:00 | AAPL | Stock | 19.4886 | 19.4993 | 19.4821 | 19.4821 | 40600.0 |
| 2012-03-12 07:25:00 | AAPL | Stock | 19.4818 | 19.4821 | 19.4818 | 19.4821 | 71260.0 |
| 2012-03-12 07:30:00 | AAPL | Stock | 19.4821 | 19.4821 | 19.4821 | 19.4821 | 2800.0 |
| 2012-03-12 07:35:00 | AAPL | Stock | 19.4818 | 19.4821 | 19.4714 | 19.4714 | 36400.0 |
| 2012-03-12 07:40:00 | AAPL | Stock | 19.475 | 19.475 | 19.475 | 19.475 | 7560.0 |
| 2012-03-12 07:45:00 | AAPL | Stock | 19.4721 | 19.4721 | 19.4714 | 19.4721 | 21868.0 |
| 2012-03-12 07:50:00 | AAPL | Stock | 19.4721 | 19.4732 | 19.4668 | 19.4668 | 85120.0 |
| 2012-03-12 07:55:00 | AAPL | Stock | 19.4668 | 19.4793 | 19.4643 | 19.4793 | 232120.0 |
| 2012-03-12 08:00:00 | AAPL | Stock | 19.4793 | 19.5321 | 19.4761 | 19.525 | 779884.0 |
| 2012-03-12 08:05:00 | AAPL | Stock | 19.5321 | 19.5868 | 19.5254 | 19.5714 | 994308.0 |
| 2012-03-12 08:10:00 | AAPL | Stock | 19.5821 | 19.5893 | 19.5621 | 19.5889 | 715568.0 |
| 2012-03-12 08:15:00 | AAPL | Stock | 19.5893 | 19.6093 | 19.5861 | 19.6071 | 796516.0 |
| 2012-03-12 08:20:00 | AAPL | Stock | 19.6071 | 19.6107 | 19.5943 | 19.6 | 467180.0 |
| 2012-03-12 08:25:00 | AAPL | Stock | 19.5893 | 19.5893 | 19.5529 | 19.5714 | 673876.0 |
| 2012-03-12 08:30:00 | AAPL | Stock | 19.5711 | 19.5768 | 19.5661 | 19.5714 | 476364.0 |
| 2012-03-12 08:35:00 | AAPL | Stock | 19.5714 | 19.5743 | 19.5611 | 19.5696 | 457128.0 |
| 2012-03-12 08:40:00 | AAPL | Stock | 19.5689 | 19.5714 | 19.5575 | 19.5611 | 373632.0 |
| 2012-03-12 08:45:00 | AAPL | Stock | 19.5575 | 19.5718 | 19.5575 | 19.5707 | 302820.0 |
| 2012-03-12 08:50:00 | AAPL | Stock | 19.57 | 19.5711 | 19.5661 | 19.5711 | 239820.0 |
| 2012-03-12 08:55:00 | AAPL | Stock | 19.5707 | 19.5846 | 19.5696 | 19.5832 | 665784.0 |
| 2012-03-12 09:00:00 | AAPL | Stock | 19.5843 | 19.5893 | 19.5821 | 19.5875 | 524104.0 |
| 2012-03-12 09:05:00 | AAPL | Stock | 19.5871 | 19.6168 | 19.5836 | 19.6064 | 1097908.0 |
| 2012-03-12 09:10:00 | AAPL | Stock | 19.6071 | 19.6107 | 19.5946 | 19.6054 | 776132.0 |
| 2012-03-12 09:15:00 | AAPL | Stock | 19.6039 | 19.6154 | 19.6014 | 19.6107 | 271656.0 |
| 2012-03-12 09:20:00 | AAPL | Stock | 19.6107 | 19.6136 | 19.6064 | 19.6089 | 205800.0 |
| 2012-03-12 09:25:00 | AAPL | Stock | 19.6075 | 19.6246 | 19.6011 | 19.6068 | 1329216.0 |
| 2012-03-12 09:30:00 | AAPL | Stock | 19.6068 | 19.6214 | 19.5796 | 19.61 | 17169432.0 |
| 2012-03-12 09:35:00 | AAPL | Stock | 19.6082 | 19.6339 | 19.5957 | 19.6311 | 11970224.0 |
| 2012-03-12 09:40:00 | AAPL | Stock | 19.63 | 19.69 | 19.6279 | 19.6807 | 23774940.0 |
| 2012-03-12 09:45:00 | AAPL | Stock | 19.6861 | 19.6936 | 19.6304 | 19.6461 | 14978404.0 |
| 2012-03-12 09:50:00 | AAPL | Stock | 19.6436 | 19.6482 | 19.6143 | 19.6307 | 9628500.0 |
| 2012-03-12 09:55:00 | AAPL | Stock | 19.6311 | 19.6475 | 19.6029 | 19.6104 | 6588372.0 |
| 2012-03-12 10:00:00 | AAPL | Stock | 19.6111 | 19.6221 | 19.5357 | 19.5514 | 14236264.0 |
| 2012-03-12 10:05:00 | AAPL | Stock | 19.5461 | 19.6036 | 19.5432 | 19.6011 | 9096332.0 |
| 2012-03-12 10:10:00 | AAPL | Stock | 19.6021 | 19.6225 | 19.5957 | 19.6214 | 7774816.0 |
| 2012-03-12 10:15:00 | AAPL | Stock | 19.6206 | 19.6446 | 19.6139 | 19.63 | 8743280.0 |
| 2012-03-12 10:20:00 | AAPL | Stock | 19.6282 | 19.6332 | 19.5743 | 19.5964 | 9201024.0 |
| 2012-03-12 10:25:00 | AAPL | Stock | 19.5982 | 19.6228 | 19.5923 | 19.6114 | 4518332.0 |
> showing 50 of 321,106 rows — these rows as CSV