PREVIEW / stock_5min / 2013-09-16
file: by_date/stock_5min/2013/2013-09-16.parquet size: 5.3 MB rows: 350,389 symbols: 3,519
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-16 04:00:00 | AAPL | Stock | 16.7118 | 16.7232 | 16.7118 | 16.7232 | 24640.0 |
| 2013-09-16 04:05:00 | AAPL | Stock | 16.725 | 16.725 | 16.7075 | 16.7075 | 9016.0 |
| 2013-09-16 04:10:00 | AAPL | Stock | 16.7207 | 16.7207 | 16.7207 | 16.7207 | 2800.0 |
| 2013-09-16 04:15:00 | AAPL | Stock | 16.7154 | 16.7154 | 16.7154 | 16.7154 | 4200.0 |
| 2013-09-16 04:30:00 | AAPL | Stock | 16.7107 | 16.7157 | 16.7029 | 16.7029 | 19600.0 |
| 2013-09-16 04:35:00 | AAPL | Stock | 16.7107 | 16.7107 | 16.7107 | 16.7107 | 26040.0 |
| 2013-09-16 04:45:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 2800.0 |
| 2013-09-16 04:50:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.7143 | 16.7143 | 8400.0 |
| 2013-09-16 04:55:00 | AAPL | Stock | 16.7064 | 16.7064 | 16.7064 | 16.7064 | 2800.0 |
| 2013-09-16 05:00:00 | AAPL | Stock | 16.7064 | 16.7064 | 16.7064 | 16.7064 | 2800.0 |
| 2013-09-16 05:05:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 2800.0 |
| 2013-09-16 05:25:00 | AAPL | Stock | 16.7071 | 16.7071 | 16.7071 | 16.7071 | 2800.0 |
| 2013-09-16 05:30:00 | AAPL | Stock | 16.6986 | 16.6986 | 16.6875 | 16.6875 | 44464.0 |
| 2013-09-16 05:35:00 | AAPL | Stock | 16.6821 | 16.6821 | 16.6821 | 16.6821 | 2800.0 |
| 2013-09-16 06:10:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 2800.0 |
| 2013-09-16 06:20:00 | AAPL | Stock | 16.6957 | 16.6957 | 16.6957 | 16.6957 | 2800.0 |
| 2013-09-16 06:30:00 | AAPL | Stock | 16.6929 | 16.6929 | 16.6929 | 16.6929 | 2800.0 |
| 2013-09-16 06:40:00 | AAPL | Stock | 16.6929 | 16.7 | 16.6929 | 16.7 | 13076.0 |
| 2013-09-16 06:50:00 | AAPL | Stock | 16.7 | 16.7 | 16.7 | 16.7 | 12544.0 |
| 2013-09-16 06:55:00 | AAPL | Stock | 16.6964 | 16.7 | 16.6929 | 16.6996 | 19068.0 |
| 2013-09-16 07:00:00 | AAPL | Stock | 16.7 | 16.7179 | 16.7 | 16.7107 | 28000.0 |
| 2013-09-16 07:05:00 | AAPL | Stock | 16.7143 | 16.7143 | 16.6964 | 16.6968 | 42700.0 |
| 2013-09-16 07:10:00 | AAPL | Stock | 16.6971 | 16.6971 | 16.6793 | 16.6793 | 39648.0 |
| 2013-09-16 07:15:00 | AAPL | Stock | 16.6871 | 16.6871 | 16.6768 | 16.6793 | 77308.0 |
| 2013-09-16 07:20:00 | AAPL | Stock | 16.6786 | 16.6871 | 16.6786 | 16.6786 | 123564.0 |
| 2013-09-16 07:25:00 | AAPL | Stock | 16.6786 | 16.6857 | 16.675 | 16.6857 | 32704.0 |
| 2013-09-16 07:30:00 | AAPL | Stock | 16.6846 | 16.6846 | 16.675 | 16.6786 | 56588.0 |
| 2013-09-16 07:35:00 | AAPL | Stock | 16.6682 | 16.6682 | 16.6429 | 16.6564 | 107128.0 |
| 2013-09-16 07:40:00 | AAPL | Stock | 16.6429 | 16.6464 | 16.6339 | 16.6339 | 32900.0 |
| 2013-09-16 07:45:00 | AAPL | Stock | 16.625 | 16.6264 | 16.6146 | 16.6146 | 32060.0 |
| 2013-09-16 07:50:00 | AAPL | Stock | 16.6164 | 16.6379 | 16.6089 | 16.6379 | 57400.0 |
| 2013-09-16 07:55:00 | AAPL | Stock | 16.6382 | 16.6382 | 16.6268 | 16.6371 | 14000.0 |
| 2013-09-16 08:00:00 | AAPL | Stock | 16.6375 | 16.7214 | 16.6121 | 16.625 | 725788.0 |
| 2013-09-16 08:05:00 | AAPL | Stock | 16.6214 | 16.6214 | 16.5754 | 16.5982 | 343672.0 |
| 2013-09-16 08:10:00 | AAPL | Stock | 16.6018 | 16.6018 | 16.55 | 16.5514 | 225820.0 |
| 2013-09-16 08:15:00 | AAPL | Stock | 16.545 | 16.575 | 16.5429 | 16.575 | 240996.0 |
| 2013-09-16 08:20:00 | AAPL | Stock | 16.5771 | 16.5771 | 16.5357 | 16.5357 | 245084.0 |
| 2013-09-16 08:25:00 | AAPL | Stock | 16.5279 | 16.535 | 16.5043 | 16.5107 | 585088.0 |
| 2013-09-16 08:30:00 | AAPL | Stock | 16.5064 | 16.5321 | 16.4596 | 16.4925 | 1109528.0 |
| 2013-09-16 08:35:00 | AAPL | Stock | 16.4829 | 16.4871 | 16.4464 | 16.4664 | 945336.0 |
| 2013-09-16 08:40:00 | AAPL | Stock | 16.4754 | 16.4754 | 16.4314 | 16.4607 | 760508.0 |
| 2013-09-16 08:45:00 | AAPL | Stock | 16.4625 | 16.4982 | 16.4589 | 16.4914 | 510888.0 |
| 2013-09-16 08:50:00 | AAPL | Stock | 16.4911 | 16.5071 | 16.4832 | 16.4839 | 490476.0 |
| 2013-09-16 08:55:00 | AAPL | Stock | 16.4893 | 16.5196 | 16.4875 | 16.5068 | 358820.0 |
| 2013-09-16 09:00:00 | AAPL | Stock | 16.5136 | 16.5175 | 16.4821 | 16.485 | 295428.0 |
| 2013-09-16 09:05:00 | AAPL | Stock | 16.485 | 16.5161 | 16.4821 | 16.5132 | 329644.0 |
| 2013-09-16 09:10:00 | AAPL | Stock | 16.5164 | 16.5375 | 16.5164 | 16.5196 | 373632.0 |
| 2013-09-16 09:15:00 | AAPL | Stock | 16.5196 | 16.525 | 16.5021 | 16.5021 | 319116.0 |
| 2013-09-16 09:20:00 | AAPL | Stock | 16.5021 | 16.5061 | 16.4896 | 16.5 | 240436.0 |
| 2013-09-16 09:25:00 | AAPL | Stock | 16.5 | 16.5014 | 16.4636 | 16.4768 | 814240.0 |
> showing 50 of 350,389 rows — these rows as CSV