PREVIEW / stock_5min / 2013-02-13
file: by_date/stock_5min/2013/2013-02-13.parquet size: 4.9 MB rows: 324,317 symbols: 3,476
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-02-13 04:45:00 | AAPL | Stock | 16.7071 | 16.7071 | 16.7071 | 16.7071 | 5600.0 |
| 2013-02-13 06:35:00 | AAPL | Stock | 16.6793 | 16.6793 | 16.6686 | 16.6686 | 39200.0 |
| 2013-02-13 06:40:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6786 | 16.6786 | 28000.0 |
| 2013-02-13 06:45:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6786 | 16.6786 | 15820.0 |
| 2013-02-13 07:00:00 | AAPL | Stock | 16.6961 | 16.6964 | 16.6786 | 16.6964 | 16800.0 |
| 2013-02-13 07:05:00 | AAPL | Stock | 16.7071 | 16.7139 | 16.6975 | 16.6979 | 20608.0 |
| 2013-02-13 07:10:00 | AAPL | Stock | 16.7057 | 16.7321 | 16.7057 | 16.7282 | 36400.0 |
| 2013-02-13 07:15:00 | AAPL | Stock | 16.7275 | 16.7293 | 16.7275 | 16.7286 | 16800.0 |
| 2013-02-13 07:20:00 | AAPL | Stock | 16.7154 | 16.7293 | 16.7143 | 16.7143 | 49000.0 |
| 2013-02-13 07:25:00 | AAPL | Stock | 16.7079 | 16.7079 | 16.7079 | 16.7079 | 2800.0 |
| 2013-02-13 07:30:00 | AAPL | Stock | 16.7189 | 16.7282 | 16.71 | 16.7282 | 20888.0 |
| 2013-02-13 07:40:00 | AAPL | Stock | 16.7389 | 16.7429 | 16.7336 | 16.7429 | 47600.0 |
| 2013-02-13 07:45:00 | AAPL | Stock | 16.7496 | 16.7496 | 16.725 | 16.725 | 30800.0 |
| 2013-02-13 07:50:00 | AAPL | Stock | 16.725 | 16.725 | 16.7125 | 16.7125 | 29120.0 |
| 2013-02-13 07:55:00 | AAPL | Stock | 16.7104 | 16.7104 | 16.6954 | 16.6954 | 54656.0 |
| 2013-02-13 08:00:00 | AAPL | Stock | 16.6957 | 16.7436 | 16.6786 | 16.6961 | 345576.0 |
| 2013-02-13 08:05:00 | AAPL | Stock | 16.7036 | 16.7221 | 16.6964 | 16.7018 | 193760.0 |
| 2013-02-13 08:10:00 | AAPL | Stock | 16.7036 | 16.7179 | 16.6986 | 16.7179 | 320124.0 |
| 2013-02-13 08:15:00 | AAPL | Stock | 16.7171 | 16.7429 | 16.7146 | 16.7339 | 166320.0 |
| 2013-02-13 08:20:00 | AAPL | Stock | 16.7411 | 16.7482 | 16.7375 | 16.7482 | 243264.0 |
| 2013-02-13 08:25:00 | AAPL | Stock | 16.7482 | 16.7482 | 16.7307 | 16.7357 | 315252.0 |
| 2013-02-13 08:30:00 | AAPL | Stock | 16.7307 | 16.7464 | 16.7307 | 16.7446 | 136416.0 |
| 2013-02-13 08:35:00 | AAPL | Stock | 16.7454 | 16.7454 | 16.725 | 16.725 | 107660.0 |
| 2013-02-13 08:40:00 | AAPL | Stock | 16.725 | 16.7393 | 16.705 | 16.7071 | 556136.0 |
| 2013-02-13 08:45:00 | AAPL | Stock | 16.7071 | 16.7271 | 16.6861 | 16.6886 | 361368.0 |
| 2013-02-13 08:50:00 | AAPL | Stock | 16.6829 | 16.6829 | 16.6486 | 16.6625 | 450016.0 |
| 2013-02-13 08:55:00 | AAPL | Stock | 16.6625 | 16.6786 | 16.6582 | 16.6736 | 271768.0 |
| 2013-02-13 09:00:00 | AAPL | Stock | 16.6754 | 16.7054 | 16.6754 | 16.705 | 117516.0 |
| 2013-02-13 09:05:00 | AAPL | Stock | 16.705 | 16.7054 | 16.6875 | 16.6954 | 194824.0 |
| 2013-02-13 09:10:00 | AAPL | Stock | 16.6943 | 16.6954 | 16.6829 | 16.6889 | 103600.0 |
| 2013-02-13 09:15:00 | AAPL | Stock | 16.695 | 16.6954 | 16.6704 | 16.6786 | 169204.0 |
| 2013-02-13 09:20:00 | AAPL | Stock | 16.6793 | 16.6843 | 16.6729 | 16.6796 | 131824.0 |
| 2013-02-13 09:25:00 | AAPL | Stock | 16.6771 | 16.6957 | 16.6704 | 16.6707 | 584388.0 |
| 2013-02-13 09:30:00 | AAPL | Stock | 16.6861 | 16.6954 | 16.5754 | 16.6165 | 24598812.0 |
| 2013-02-13 09:35:00 | AAPL | Stock | 16.6232 | 16.6582 | 16.5675 | 16.572 | 11983608.0 |
| 2013-02-13 09:40:00 | AAPL | Stock | 16.5682 | 16.6136 | 16.5514 | 16.5893 | 13190968.0 |
| 2013-02-13 09:45:00 | AAPL | Stock | 16.5839 | 16.5893 | 16.5436 | 16.5675 | 9470300.0 |
| 2013-02-13 09:50:00 | AAPL | Stock | 16.5696 | 16.6246 | 16.5629 | 16.6004 | 8624084.0 |
| 2013-02-13 09:55:00 | AAPL | Stock | 16.6005 | 16.8529 | 16.5975 | 16.8379 | 27054076.0 |
| 2013-02-13 10:00:00 | AAPL | Stock | 16.8443 | 16.8511 | 16.7796 | 16.7957 | 16436728.0 |
| 2013-02-13 10:05:00 | AAPL | Stock | 16.7954 | 16.8386 | 16.7682 | 16.7761 | 9662240.0 |
| 2013-02-13 10:10:00 | AAPL | Stock | 16.7793 | 16.8121 | 16.7243 | 16.7485 | 8569680.0 |
| 2013-02-13 10:15:00 | AAPL | Stock | 16.7432 | 16.7764 | 16.7214 | 16.7661 | 6425048.0 |
| 2013-02-13 10:20:00 | AAPL | Stock | 16.7671 | 16.8125 | 16.7543 | 16.8093 | 5068336.0 |
| 2013-02-13 10:25:00 | AAPL | Stock | 16.805 | 16.8064 | 16.7725 | 16.7996 | 3532312.0 |
| 2013-02-13 10:30:00 | AAPL | Stock | 16.7996 | 16.8061 | 16.7446 | 16.7794 | 5560520.0 |
| 2013-02-13 10:35:00 | AAPL | Stock | 16.7806 | 16.8332 | 16.7726 | 16.8204 | 7500696.0 |
| 2013-02-13 10:40:00 | AAPL | Stock | 16.8186 | 16.8732 | 16.8129 | 16.8571 | 10404072.0 |
| 2013-02-13 10:45:00 | AAPL | Stock | 16.8529 | 16.8594 | 16.8179 | 16.8354 | 5163144.0 |
| 2013-02-13 10:50:00 | AAPL | Stock | 16.8356 | 16.8839 | 16.8339 | 16.8591 | 8611540.0 |
> showing 50 of 324,317 rows — these rows as CSV