PREVIEW / stock_5min / 2011-08-09
file: by_date/stock_5min/2011/2011-08-09.parquet size: 5.7 MB rows: 373,677 symbols: 3,566
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-09 04:05:00 | AAPL | Stock | 12.5914 | 12.6071 | 12.5907 | 12.5929 | 33600.0 |
| 2011-08-09 04:10:00 | AAPL | Stock | 12.5929 | 12.6104 | 12.5914 | 12.5914 | 16800.0 |
| 2011-08-09 04:15:00 | AAPL | Stock | 12.5982 | 12.6071 | 12.575 | 12.575 | 36260.0 |
| 2011-08-09 04:20:00 | AAPL | Stock | 12.5111 | 12.5211 | 12.5046 | 12.5046 | 42000.0 |
| 2011-08-09 04:25:00 | AAPL | Stock | 12.5271 | 12.5271 | 12.5271 | 12.5271 | 5600.0 |
| 2011-08-09 04:30:00 | AAPL | Stock | 12.5 | 12.5 | 12.3643 | 12.3693 | 39200.0 |
| 2011-08-09 04:35:00 | AAPL | Stock | 12.3679 | 12.4643 | 12.3679 | 12.4254 | 37520.0 |
| 2011-08-09 04:40:00 | AAPL | Stock | 12.4289 | 12.4482 | 12.4289 | 12.4482 | 25200.0 |
| 2011-08-09 04:45:00 | AAPL | Stock | 12.4482 | 12.4482 | 12.4268 | 12.4296 | 14000.0 |
| 2011-08-09 04:50:00 | AAPL | Stock | 12.4271 | 12.4411 | 12.4268 | 12.4411 | 22400.0 |
| 2011-08-09 04:55:00 | AAPL | Stock | 12.4286 | 12.4861 | 12.4286 | 12.4861 | 8400.0 |
| 2011-08-09 05:00:00 | AAPL | Stock | 12.4714 | 12.4714 | 12.3396 | 12.3396 | 60480.0 |
| 2011-08-09 05:05:00 | AAPL | Stock | 12.39 | 12.39 | 12.39 | 12.39 | 2800.0 |
| 2011-08-09 05:10:00 | AAPL | Stock | 12.4136 | 12.4161 | 12.4136 | 12.4161 | 8400.0 |
| 2011-08-09 05:15:00 | AAPL | Stock | 12.3946 | 12.3946 | 12.3946 | 12.3946 | 6720.0 |
| 2011-08-09 05:20:00 | AAPL | Stock | 12.3646 | 12.3646 | 12.3571 | 12.3571 | 28560.0 |
| 2011-08-09 05:25:00 | AAPL | Stock | 12.3482 | 12.3482 | 12.3482 | 12.3482 | 5600.0 |
| 2011-08-09 05:30:00 | AAPL | Stock | 12.3775 | 12.4096 | 12.3775 | 12.4096 | 21700.0 |
| 2011-08-09 05:35:00 | AAPL | Stock | 12.4193 | 12.4704 | 12.4193 | 12.4286 | 29400.0 |
| 2011-08-09 05:40:00 | AAPL | Stock | 12.465 | 12.465 | 12.465 | 12.465 | 6720.0 |
| 2011-08-09 05:45:00 | AAPL | Stock | 12.4471 | 12.5275 | 12.4471 | 12.5161 | 49280.0 |
| 2011-08-09 05:50:00 | AAPL | Stock | 12.5161 | 12.5161 | 12.5161 | 12.5161 | 5600.0 |
| 2011-08-09 05:55:00 | AAPL | Stock | 12.4736 | 12.5 | 12.4736 | 12.5 | 19236.0 |
| 2011-08-09 06:00:00 | AAPL | Stock | 12.5 | 12.5179 | 12.5 | 12.5179 | 25200.0 |
| 2011-08-09 06:05:00 | AAPL | Stock | 12.5179 | 12.5432 | 12.5179 | 12.5379 | 93520.0 |
| 2011-08-09 06:10:00 | AAPL | Stock | 12.5318 | 12.5532 | 12.5021 | 12.5286 | 127400.0 |
| 2011-08-09 06:20:00 | AAPL | Stock | 12.4971 | 12.4971 | 12.4971 | 12.4971 | 5320.0 |
| 2011-08-09 06:35:00 | AAPL | Stock | 12.5357 | 12.5432 | 12.5357 | 12.5432 | 49840.0 |
| 2011-08-09 06:40:00 | AAPL | Stock | 12.5179 | 12.5393 | 12.5179 | 12.5393 | 56700.0 |
| 2011-08-09 06:45:00 | AAPL | Stock | 12.5393 | 12.5821 | 12.5357 | 12.5821 | 96600.0 |
| 2011-08-09 06:50:00 | AAPL | Stock | 12.5846 | 12.6114 | 12.5846 | 12.6107 | 61320.0 |
| 2011-08-09 06:55:00 | AAPL | Stock | 12.6275 | 12.6618 | 12.6275 | 12.6429 | 191520.0 |
| 2011-08-09 07:00:00 | AAPL | Stock | 12.6496 | 12.7371 | 12.6154 | 12.7179 | 365428.0 |
| 2011-08-09 07:05:00 | AAPL | Stock | 12.7179 | 12.7243 | 12.6657 | 12.6657 | 253764.0 |
| 2011-08-09 07:10:00 | AAPL | Stock | 12.6661 | 12.7132 | 12.6611 | 12.7007 | 418600.0 |
| 2011-08-09 07:15:00 | AAPL | Stock | 12.7104 | 12.7121 | 12.6786 | 12.7121 | 360696.0 |
| 2011-08-09 07:20:00 | AAPL | Stock | 12.7121 | 12.7514 | 12.7054 | 12.7493 | 724472.0 |
| 2011-08-09 07:25:00 | AAPL | Stock | 12.7475 | 12.7593 | 12.7321 | 12.7593 | 841316.0 |
| 2011-08-09 07:30:00 | AAPL | Stock | 12.7593 | 12.8232 | 12.7539 | 12.8232 | 814016.0 |
| 2011-08-09 07:35:00 | AAPL | Stock | 12.8146 | 12.8232 | 12.7589 | 12.7843 | 393904.0 |
| 2011-08-09 07:40:00 | AAPL | Stock | 12.7768 | 12.7768 | 12.7182 | 12.75 | 221788.0 |
| 2011-08-09 07:45:00 | AAPL | Stock | 12.7393 | 12.7393 | 12.6936 | 12.7286 | 392616.0 |
| 2011-08-09 07:50:00 | AAPL | Stock | 12.7321 | 12.7796 | 12.7321 | 12.7696 | 284676.0 |
| 2011-08-09 07:55:00 | AAPL | Stock | 12.7786 | 12.7946 | 12.7686 | 12.7768 | 319900.0 |
| 2011-08-09 08:00:00 | AAPL | Stock | 12.7821 | 12.8036 | 12.7161 | 12.7286 | 710836.0 |
| 2011-08-09 08:05:00 | AAPL | Stock | 12.7214 | 12.7482 | 12.7071 | 12.7411 | 670712.0 |
| 2011-08-09 08:10:00 | AAPL | Stock | 12.7479 | 12.7925 | 12.7321 | 12.7857 | 516544.0 |
| 2011-08-09 08:15:00 | AAPL | Stock | 12.7893 | 12.7925 | 12.7718 | 12.7718 | 512400.0 |
| 2011-08-09 08:20:00 | AAPL | Stock | 12.7786 | 12.7936 | 12.7689 | 12.7861 | 639212.0 |
| 2011-08-09 08:25:00 | AAPL | Stock | 12.7825 | 12.7964 | 12.7725 | 12.7764 | 417340.0 |
> showing 50 of 373,677 rows — these rows as CSV