PREVIEW / stock_5min / 2013-04-26
file: by_date/stock_5min/2013/2013-04-26.parquet size: 4.9 MB rows: 327,577 symbols: 3,454
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-04-26 04:00:00 | AAPL | Stock | 14.5996 | 14.5996 | 14.5996 | 14.5996 | 11200.0 |
| 2013-04-26 04:40:00 | AAPL | Stock | 14.57 | 14.57 | 14.57 | 14.57 | 5600.0 |
| 2013-04-26 06:00:00 | AAPL | Stock | 14.5386 | 14.5386 | 14.5386 | 14.5386 | 5600.0 |
| 2013-04-26 06:50:00 | AAPL | Stock | 14.5357 | 14.5357 | 14.5357 | 14.5357 | 25200.0 |
| 2013-04-26 07:00:00 | AAPL | Stock | 14.5296 | 14.5336 | 14.5296 | 14.5336 | 5600.0 |
| 2013-04-26 07:05:00 | AAPL | Stock | 14.5429 | 14.5446 | 14.5429 | 14.5446 | 43764.0 |
| 2013-04-26 07:10:00 | AAPL | Stock | 14.5536 | 14.5536 | 14.5411 | 14.5414 | 75180.0 |
| 2013-04-26 07:15:00 | AAPL | Stock | 14.5411 | 14.5432 | 14.5357 | 14.5432 | 40600.0 |
| 2013-04-26 07:20:00 | AAPL | Stock | 14.5443 | 14.5443 | 14.5443 | 14.5443 | 2800.0 |
| 2013-04-26 07:25:00 | AAPL | Stock | 14.5529 | 14.5536 | 14.5529 | 14.5536 | 33600.0 |
| 2013-04-26 07:45:00 | AAPL | Stock | 14.5539 | 14.5714 | 14.5539 | 14.5571 | 50400.0 |
| 2013-04-26 07:55:00 | AAPL | Stock | 14.5554 | 14.5554 | 14.5496 | 14.5504 | 30800.0 |
| 2013-04-26 08:00:00 | AAPL | Stock | 14.5621 | 14.5693 | 14.5411 | 14.5475 | 91168.0 |
| 2013-04-26 08:05:00 | AAPL | Stock | 14.585 | 14.585 | 14.5218 | 14.5318 | 1080660.0 |
| 2013-04-26 08:10:00 | AAPL | Stock | 14.5329 | 14.5604 | 14.5286 | 14.5514 | 102228.0 |
| 2013-04-26 08:15:00 | AAPL | Stock | 14.5632 | 14.5668 | 14.5568 | 14.5668 | 8400.0 |
| 2013-04-26 08:20:00 | AAPL | Stock | 14.5661 | 14.5725 | 14.5625 | 14.5661 | 97440.0 |
| 2013-04-26 08:25:00 | AAPL | Stock | 14.5661 | 14.5693 | 14.5596 | 14.5693 | 46396.0 |
| 2013-04-26 08:30:00 | AAPL | Stock | 14.5604 | 14.5643 | 14.5368 | 14.5607 | 342888.0 |
| 2013-04-26 08:35:00 | AAPL | Stock | 14.5607 | 14.5732 | 14.56 | 14.5732 | 144452.0 |
| 2013-04-26 08:40:00 | AAPL | Stock | 14.5729 | 14.6071 | 14.5729 | 14.6071 | 187656.0 |
| 2013-04-26 08:45:00 | AAPL | Stock | 14.5982 | 14.6307 | 14.5979 | 14.6307 | 94388.0 |
| 2013-04-26 08:50:00 | AAPL | Stock | 14.6343 | 14.685 | 14.6339 | 14.6789 | 389844.0 |
| 2013-04-26 08:55:00 | AAPL | Stock | 14.6789 | 14.6957 | 14.6564 | 14.6607 | 264992.0 |
| 2013-04-26 09:00:00 | AAPL | Stock | 14.6679 | 14.6679 | 14.6254 | 14.6393 | 206080.0 |
| 2013-04-26 09:05:00 | AAPL | Stock | 14.6286 | 14.6561 | 14.6286 | 14.6561 | 148120.0 |
| 2013-04-26 09:10:00 | AAPL | Stock | 14.6296 | 14.6357 | 14.625 | 14.625 | 123480.0 |
| 2013-04-26 09:15:00 | AAPL | Stock | 14.6214 | 14.6286 | 14.6143 | 14.625 | 33096.0 |
| 2013-04-26 09:20:00 | AAPL | Stock | 14.6339 | 14.6339 | 14.6107 | 14.6107 | 30800.0 |
| 2013-04-26 09:25:00 | AAPL | Stock | 14.6143 | 14.6396 | 14.6071 | 14.6375 | 563108.0 |
| 2013-04-26 09:30:00 | AAPL | Stock | 14.6364 | 14.6786 | 14.5804 | 14.6043 | 17714620.0 |
| 2013-04-26 09:35:00 | AAPL | Stock | 14.6021 | 14.6357 | 14.5811 | 14.6018 | 9906764.0 |
| 2013-04-26 09:40:00 | AAPL | Stock | 14.6014 | 14.6557 | 14.5971 | 14.6514 | 10036936.0 |
| 2013-04-26 09:45:00 | AAPL | Stock | 14.6461 | 14.7364 | 14.6357 | 14.7125 | 18497724.0 |
| 2013-04-26 09:50:00 | AAPL | Stock | 14.7093 | 14.7671 | 14.7079 | 14.7339 | 17296356.0 |
| 2013-04-26 09:55:00 | AAPL | Stock | 14.7389 | 14.7939 | 14.7336 | 14.7929 | 12108488.0 |
| 2013-04-26 10:00:00 | AAPL | Stock | 14.7929 | 14.8175 | 14.7507 | 14.7554 | 11305056.0 |
| 2013-04-26 10:05:00 | AAPL | Stock | 14.7529 | 14.7755 | 14.7393 | 14.7629 | 6786332.0 |
| 2013-04-26 10:10:00 | AAPL | Stock | 14.763 | 14.7732 | 14.7057 | 14.7439 | 10524920.0 |
| 2013-04-26 10:15:00 | AAPL | Stock | 14.7436 | 14.7582 | 14.7089 | 14.7457 | 6526324.0 |
| 2013-04-26 10:20:00 | AAPL | Stock | 14.7457 | 14.7657 | 14.7379 | 14.7587 | 5463192.0 |
| 2013-04-26 10:25:00 | AAPL | Stock | 14.7588 | 14.7746 | 14.7382 | 14.7711 | 5636540.0 |
| 2013-04-26 10:30:00 | AAPL | Stock | 14.7721 | 14.7746 | 14.7411 | 14.7482 | 4308752.0 |
| 2013-04-26 10:35:00 | AAPL | Stock | 14.7507 | 14.7889 | 14.7432 | 14.7775 | 8053360.0 |
| 2013-04-26 10:40:00 | AAPL | Stock | 14.78 | 14.7904 | 14.7464 | 14.7711 | 5208868.0 |
| 2013-04-26 10:45:00 | AAPL | Stock | 14.7696 | 14.7929 | 14.7693 | 14.7901 | 5647936.0 |
| 2013-04-26 10:50:00 | AAPL | Stock | 14.7889 | 14.7914 | 14.7571 | 14.765 | 4299232.0 |
| 2013-04-26 10:55:00 | AAPL | Stock | 14.765 | 14.7971 | 14.7575 | 14.7843 | 7565628.0 |
| 2013-04-26 11:00:00 | AAPL | Stock | 14.7855 | 14.8236 | 14.7808 | 14.8223 | 10919440.0 |
| 2013-04-26 11:05:00 | AAPL | Stock | 14.8218 | 14.8304 | 14.7982 | 14.8121 | 6408976.0 |
> showing 50 of 327,577 rows — these rows as CSV