PREVIEW / stock_5min / 2013-09-19
file: by_date/stock_5min/2013/2013-09-19.parquet size: 5.2 MB rows: 344,654 symbols: 3,525
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-09-19 04:00:00 | AAPL | Stock | 16.7543 | 16.7543 | 16.7543 | 16.7543 | 2800.0 |
| 2013-09-19 04:05:00 | AAPL | Stock | 16.6964 | 16.7136 | 16.6889 | 16.6889 | 28000.0 |
| 2013-09-19 04:10:00 | AAPL | Stock | 16.6707 | 16.6929 | 16.6625 | 16.6625 | 29792.0 |
| 2013-09-19 04:25:00 | AAPL | Stock | 16.705 | 16.7104 | 16.705 | 16.7104 | 12068.0 |
| 2013-09-19 04:30:00 | AAPL | Stock | 16.6946 | 16.6946 | 16.6639 | 16.6639 | 40600.0 |
| 2013-09-19 04:35:00 | AAPL | Stock | 16.6975 | 16.7054 | 16.6975 | 16.7054 | 54992.0 |
| 2013-09-19 04:40:00 | AAPL | Stock | 16.7014 | 16.7054 | 16.7014 | 16.7014 | 33600.0 |
| 2013-09-19 04:55:00 | AAPL | Stock | 16.6786 | 16.6886 | 16.6786 | 16.6793 | 8736.0 |
| 2013-09-19 05:00:00 | AAPL | Stock | 16.6964 | 16.6971 | 16.6964 | 16.6971 | 5600.0 |
| 2013-09-19 05:10:00 | AAPL | Stock | 16.7129 | 16.7143 | 16.7129 | 16.7143 | 42000.0 |
| 2013-09-19 05:50:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.7286 | 16.7286 | 2800.0 |
| 2013-09-19 06:00:00 | AAPL | Stock | 16.7286 | 16.7286 | 16.7143 | 16.7143 | 5600.0 |
| 2013-09-19 06:15:00 | AAPL | Stock | 16.6804 | 16.6804 | 16.6804 | 16.6804 | 2800.0 |
| 2013-09-19 06:30:00 | AAPL | Stock | 16.6961 | 16.6964 | 16.6961 | 16.6964 | 44576.0 |
| 2013-09-19 06:35:00 | AAPL | Stock | 16.7 | 16.7 | 16.695 | 16.6957 | 11200.0 |
| 2013-09-19 06:50:00 | AAPL | Stock | 16.7054 | 16.7054 | 16.7054 | 16.7054 | 27944.0 |
| 2013-09-19 06:55:00 | AAPL | Stock | 16.7071 | 16.7071 | 16.7071 | 16.7071 | 14000.0 |
| 2013-09-19 07:00:00 | AAPL | Stock | 16.7107 | 16.7143 | 16.7054 | 16.7143 | 92876.0 |
| 2013-09-19 07:05:00 | AAPL | Stock | 16.7289 | 16.75 | 16.7289 | 16.75 | 53900.0 |
| 2013-09-19 07:10:00 | AAPL | Stock | 16.7489 | 16.7529 | 16.7489 | 16.7529 | 72800.0 |
| 2013-09-19 07:15:00 | AAPL | Stock | 16.7489 | 16.7489 | 16.7479 | 16.7479 | 5600.0 |
| 2013-09-19 07:20:00 | AAPL | Stock | 16.7475 | 16.7475 | 16.7346 | 16.7346 | 67844.0 |
| 2013-09-19 07:25:00 | AAPL | Stock | 16.7393 | 16.7621 | 16.7393 | 16.7621 | 192304.0 |
| 2013-09-19 07:30:00 | AAPL | Stock | 16.7536 | 16.7536 | 16.7486 | 16.7518 | 22400.0 |
| 2013-09-19 07:35:00 | AAPL | Stock | 16.7468 | 16.7468 | 16.7389 | 16.7457 | 36400.0 |
| 2013-09-19 07:40:00 | AAPL | Stock | 16.7364 | 16.7443 | 16.7325 | 16.7429 | 20160.0 |
| 2013-09-19 07:45:00 | AAPL | Stock | 16.7429 | 16.75 | 16.7429 | 16.7468 | 143752.0 |
| 2013-09-19 07:50:00 | AAPL | Stock | 16.7464 | 16.75 | 16.7386 | 16.75 | 52556.0 |
| 2013-09-19 07:55:00 | AAPL | Stock | 16.7429 | 16.75 | 16.7429 | 16.75 | 99596.0 |
| 2013-09-19 08:00:00 | AAPL | Stock | 16.75 | 16.7857 | 16.7143 | 16.7857 | 723268.0 |
| 2013-09-19 08:05:00 | AAPL | Stock | 16.75 | 16.8125 | 16.75 | 16.8036 | 537796.0 |
| 2013-09-19 08:10:00 | AAPL | Stock | 16.8118 | 16.8246 | 16.8 | 16.8036 | 382200.0 |
| 2013-09-19 08:15:00 | AAPL | Stock | 16.7975 | 16.8143 | 16.7907 | 16.7914 | 292404.0 |
| 2013-09-19 08:20:00 | AAPL | Stock | 16.7925 | 16.8 | 16.7868 | 16.8 | 218428.0 |
| 2013-09-19 08:25:00 | AAPL | Stock | 16.8 | 16.8018 | 16.7804 | 16.7807 | 346276.0 |
| 2013-09-19 08:30:00 | AAPL | Stock | 16.7804 | 16.7929 | 16.7721 | 16.7929 | 334544.0 |
| 2013-09-19 08:35:00 | AAPL | Stock | 16.7875 | 16.8039 | 16.7771 | 16.8039 | 336140.0 |
| 2013-09-19 08:40:00 | AAPL | Stock | 16.8089 | 16.8143 | 16.7943 | 16.7971 | 374668.0 |
| 2013-09-19 08:45:00 | AAPL | Stock | 16.7936 | 16.8054 | 16.79 | 16.8018 | 382312.0 |
| 2013-09-19 08:50:00 | AAPL | Stock | 16.7946 | 16.8036 | 16.7946 | 16.8014 | 159236.0 |
| 2013-09-19 08:55:00 | AAPL | Stock | 16.7982 | 16.8036 | 16.7946 | 16.8 | 180068.0 |
| 2013-09-19 09:00:00 | AAPL | Stock | 16.7993 | 16.8089 | 16.7921 | 16.8064 | 351372.0 |
| 2013-09-19 09:05:00 | AAPL | Stock | 16.7996 | 16.815 | 16.7971 | 16.8104 | 213136.0 |
| 2013-09-19 09:10:00 | AAPL | Stock | 16.8129 | 16.8214 | 16.8129 | 16.8214 | 462784.0 |
| 2013-09-19 09:15:00 | AAPL | Stock | 16.8214 | 16.83 | 16.8143 | 16.8143 | 257236.0 |
| 2013-09-19 09:20:00 | AAPL | Stock | 16.8139 | 16.8196 | 16.7982 | 16.8129 | 202636.0 |
| 2013-09-19 09:25:00 | AAPL | Stock | 16.8129 | 16.8214 | 16.7936 | 16.8214 | 400148.0 |
| 2013-09-19 09:30:00 | AAPL | Stock | 16.8107 | 16.8771 | 16.7589 | 16.8704 | 29850716.0 |
| 2013-09-19 09:35:00 | AAPL | Stock | 16.8704 | 16.9064 | 16.8561 | 16.8586 | 19446280.0 |
| 2013-09-19 09:40:00 | AAPL | Stock | 16.86 | 16.875 | 16.8121 | 16.8439 | 12206796.0 |
> showing 50 of 344,654 rows — these rows as CSV