PREVIEW / stock_5min / 2013-10-31
file: by_date/stock_5min/2013/2013-10-31.parquet size: 5.3 MB rows: 348,627 symbols: 3,543
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-10-31 04:50:00 | AAPL | Stock | 18.6907 | 18.6907 | 18.6907 | 18.6907 | 2800.0 |
| 2013-10-31 05:35:00 | AAPL | Stock | 18.6939 | 18.6939 | 18.6939 | 18.6939 | 2800.0 |
| 2013-10-31 06:00:00 | AAPL | Stock | 18.7446 | 18.7464 | 18.7446 | 18.7464 | 25200.0 |
| 2013-10-31 07:00:00 | AAPL | Stock | 18.7239 | 18.7375 | 18.7239 | 18.7375 | 22400.0 |
| 2013-10-31 07:05:00 | AAPL | Stock | 18.7446 | 18.7639 | 18.7446 | 18.7639 | 33600.0 |
| 2013-10-31 07:10:00 | AAPL | Stock | 18.7854 | 18.7857 | 18.7854 | 18.7854 | 75012.0 |
| 2013-10-31 07:15:00 | AAPL | Stock | 18.7854 | 18.7893 | 18.7854 | 18.7857 | 72800.0 |
| 2013-10-31 07:20:00 | AAPL | Stock | 18.7696 | 18.7696 | 18.75 | 18.75 | 11200.0 |
| 2013-10-31 07:25:00 | AAPL | Stock | 18.75 | 18.7536 | 18.75 | 18.7536 | 16800.0 |
| 2013-10-31 07:30:00 | AAPL | Stock | 18.7536 | 18.7536 | 18.7536 | 18.7536 | 2800.0 |
| 2013-10-31 07:35:00 | AAPL | Stock | 18.75 | 18.7536 | 18.75 | 18.7536 | 22400.0 |
| 2013-10-31 07:50:00 | AAPL | Stock | 18.7539 | 18.7539 | 18.75 | 18.7514 | 8400.0 |
| 2013-10-31 07:55:00 | AAPL | Stock | 18.7564 | 18.7629 | 18.7554 | 18.7629 | 36400.0 |
| 2013-10-31 08:00:00 | AAPL | Stock | 18.7589 | 18.7857 | 18.7239 | 18.7357 | 103124.0 |
| 2013-10-31 08:05:00 | AAPL | Stock | 18.7475 | 18.7475 | 18.7232 | 18.7411 | 67200.0 |
| 2013-10-31 08:10:00 | AAPL | Stock | 18.7393 | 18.7429 | 18.7393 | 18.7429 | 14000.0 |
| 2013-10-31 08:15:00 | AAPL | Stock | 18.7461 | 18.7571 | 18.7461 | 18.7571 | 16576.0 |
| 2013-10-31 08:20:00 | AAPL | Stock | 18.7707 | 18.7786 | 18.7679 | 18.7679 | 118104.0 |
| 2013-10-31 08:25:00 | AAPL | Stock | 18.7729 | 18.7846 | 18.7679 | 18.7836 | 83860.0 |
| 2013-10-31 08:30:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7646 | 18.7679 | 22400.0 |
| 2013-10-31 08:35:00 | AAPL | Stock | 18.7571 | 18.7679 | 18.75 | 18.7646 | 287840.0 |
| 2013-10-31 08:40:00 | AAPL | Stock | 18.7679 | 18.7693 | 18.7518 | 18.7693 | 115556.0 |
| 2013-10-31 08:45:00 | AAPL | Stock | 18.7764 | 18.7821 | 18.7714 | 18.7768 | 77028.0 |
| 2013-10-31 08:50:00 | AAPL | Stock | 18.7714 | 18.7746 | 18.7714 | 18.7746 | 9800.0 |
| 2013-10-31 08:55:00 | AAPL | Stock | 18.775 | 18.775 | 18.7429 | 18.7668 | 250292.0 |
| 2013-10-31 09:00:00 | AAPL | Stock | 18.7554 | 18.7607 | 18.75 | 18.7539 | 83132.0 |
| 2013-10-31 09:05:00 | AAPL | Stock | 18.7539 | 18.7671 | 18.7539 | 18.7643 | 64652.0 |
| 2013-10-31 09:10:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7607 | 18.7675 | 138264.0 |
| 2013-10-31 09:15:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7593 | 18.7654 | 112784.0 |
| 2013-10-31 09:20:00 | AAPL | Stock | 18.7575 | 18.7679 | 18.7504 | 18.7611 | 217560.0 |
| 2013-10-31 09:25:00 | AAPL | Stock | 18.7611 | 18.7671 | 18.7454 | 18.7504 | 471380.0 |
| 2013-10-31 09:30:00 | AAPL | Stock | 18.75 | 18.7693 | 18.6168 | 18.6304 | 12509140.0 |
| 2013-10-31 09:35:00 | AAPL | Stock | 18.6407 | 18.7143 | 18.6257 | 18.6993 | 8879780.0 |
| 2013-10-31 09:40:00 | AAPL | Stock | 18.7004 | 18.7214 | 18.6475 | 18.7168 | 6304172.0 |
| 2013-10-31 09:45:00 | AAPL | Stock | 18.7168 | 18.7371 | 18.6361 | 18.6368 | 5739412.0 |
| 2013-10-31 09:50:00 | AAPL | Stock | 18.6429 | 18.6689 | 18.6279 | 18.6307 | 4140052.0 |
| 2013-10-31 09:55:00 | AAPL | Stock | 18.6307 | 18.6464 | 18.6179 | 18.6229 | 5117028.0 |
| 2013-10-31 10:00:00 | AAPL | Stock | 18.6211 | 18.6632 | 18.6207 | 18.66 | 3788932.0 |
| 2013-10-31 10:05:00 | AAPL | Stock | 18.6632 | 18.6761 | 18.6293 | 18.6669 | 3866688.0 |
| 2013-10-31 10:10:00 | AAPL | Stock | 18.6686 | 18.7029 | 18.6529 | 18.6975 | 4837196.0 |
| 2013-10-31 10:15:00 | AAPL | Stock | 18.7029 | 18.7046 | 18.6625 | 18.6664 | 3297336.0 |
| 2013-10-31 10:20:00 | AAPL | Stock | 18.6639 | 18.6782 | 18.6554 | 18.6721 | 2912588.0 |
| 2013-10-31 10:25:00 | AAPL | Stock | 18.6682 | 18.6761 | 18.6286 | 18.6382 | 4352880.0 |
| 2013-10-31 10:30:00 | AAPL | Stock | 18.6368 | 18.6714 | 18.6321 | 18.6586 | 3024280.0 |
| 2013-10-31 10:35:00 | AAPL | Stock | 18.6586 | 18.6768 | 18.6561 | 18.6593 | 3998596.0 |
| 2013-10-31 10:40:00 | AAPL | Stock | 18.6639 | 18.6846 | 18.6573 | 18.6757 | 2353092.0 |
| 2013-10-31 10:45:00 | AAPL | Stock | 18.6775 | 18.6914 | 18.6704 | 18.6832 | 3446044.0 |
| 2013-10-31 10:50:00 | AAPL | Stock | 18.6832 | 18.7461 | 18.6786 | 18.7343 | 4595948.0 |
| 2013-10-31 10:55:00 | AAPL | Stock | 18.7343 | 18.7425 | 18.7089 | 18.7261 | 2911300.0 |
| 2013-10-31 11:00:00 | AAPL | Stock | 18.7225 | 18.7768 | 18.72 | 18.7675 | 5091100.0 |
> showing 50 of 348,627 rows — these rows as CSV