PREVIEW / stock_5min / 2014-05-30
file: by_date/stock_5min/2014/2014-05-30.parquet size: 5.3 MB rows: 356,561 symbols: 3,560
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-30 04:20:00 | AAPL | Stock | 22.7571 | 22.7654 | 22.7571 | 22.7654 | 7840.0 |
| 2014-05-30 04:25:00 | AAPL | Stock | 22.7675 | 22.7679 | 22.7675 | 22.7679 | 5600.0 |
| 2014-05-30 04:45:00 | AAPL | Stock | 22.7682 | 22.7682 | 22.7682 | 22.7682 | 2800.0 |
| 2014-05-30 05:15:00 | AAPL | Stock | 22.7768 | 22.7768 | 22.7768 | 22.7768 | 2800.0 |
| 2014-05-30 05:25:00 | AAPL | Stock | 22.7593 | 22.7593 | 22.7546 | 22.7546 | 5600.0 |
| 2014-05-30 05:30:00 | AAPL | Stock | 22.75 | 22.75 | 22.74 | 22.74 | 25200.0 |
| 2014-05-30 05:45:00 | AAPL | Stock | 22.74 | 22.7457 | 22.74 | 22.7457 | 22400.0 |
| 2014-05-30 06:15:00 | AAPL | Stock | 22.7411 | 22.7411 | 22.7411 | 22.7411 | 5600.0 |
| 2014-05-30 06:25:00 | AAPL | Stock | 22.7607 | 22.7607 | 22.7607 | 22.7607 | 2800.0 |
| 2014-05-30 06:30:00 | AAPL | Stock | 22.7607 | 22.7643 | 22.7607 | 22.7607 | 14000.0 |
| 2014-05-30 06:35:00 | AAPL | Stock | 22.7607 | 22.8179 | 22.7607 | 22.8179 | 432124.0 |
| 2014-05-30 06:40:00 | AAPL | Stock | 22.7946 | 22.7946 | 22.7893 | 22.7893 | 39200.0 |
| 2014-05-30 06:45:00 | AAPL | Stock | 22.8161 | 22.8161 | 22.7982 | 22.7982 | 14000.0 |
| 2014-05-30 06:50:00 | AAPL | Stock | 22.8179 | 22.8196 | 22.8046 | 22.8046 | 17332.0 |
| 2014-05-30 06:55:00 | AAPL | Stock | 22.8054 | 22.8054 | 22.8054 | 22.8054 | 2800.0 |
| 2014-05-30 07:00:00 | AAPL | Stock | 22.8 | 22.825 | 22.8 | 22.825 | 82376.0 |
| 2014-05-30 07:05:00 | AAPL | Stock | 22.8336 | 22.8379 | 22.8125 | 22.8125 | 110600.0 |
| 2014-05-30 07:10:00 | AAPL | Stock | 22.8132 | 22.8179 | 22.8107 | 22.8179 | 11200.0 |
| 2014-05-30 07:15:00 | AAPL | Stock | 22.8146 | 22.8146 | 22.8043 | 22.8143 | 81480.0 |
| 2014-05-30 07:20:00 | AAPL | Stock | 22.8107 | 22.8107 | 22.7979 | 22.7979 | 78400.0 |
| 2014-05-30 07:25:00 | AAPL | Stock | 22.8 | 22.8 | 22.7768 | 22.7768 | 94920.0 |
| 2014-05-30 07:30:00 | AAPL | Stock | 22.7796 | 22.7796 | 22.7607 | 22.7711 | 49448.0 |
| 2014-05-30 07:35:00 | AAPL | Stock | 22.7711 | 22.7786 | 22.7679 | 22.7707 | 25900.0 |
| 2014-05-30 07:40:00 | AAPL | Stock | 22.7711 | 22.7711 | 22.7418 | 22.75 | 69552.0 |
| 2014-05-30 07:45:00 | AAPL | Stock | 22.7504 | 22.7504 | 22.75 | 22.75 | 16240.0 |
| 2014-05-30 07:50:00 | AAPL | Stock | 22.7432 | 22.7432 | 22.7214 | 22.7214 | 36400.0 |
| 2014-05-30 07:55:00 | AAPL | Stock | 22.7339 | 22.7432 | 22.7339 | 22.7432 | 5600.0 |
| 2014-05-30 08:00:00 | AAPL | Stock | 22.75 | 22.8214 | 22.7218 | 22.7479 | 343784.0 |
| 2014-05-30 08:05:00 | AAPL | Stock | 22.75 | 22.7786 | 22.7429 | 22.7704 | 319480.0 |
| 2014-05-30 08:10:00 | AAPL | Stock | 22.7775 | 22.7843 | 22.7775 | 22.7814 | 101864.0 |
| 2014-05-30 08:15:00 | AAPL | Stock | 22.7786 | 22.7964 | 22.7786 | 22.7857 | 75320.0 |
| 2014-05-30 08:20:00 | AAPL | Stock | 22.7886 | 22.7893 | 22.7739 | 22.775 | 222852.0 |
| 2014-05-30 08:25:00 | AAPL | Stock | 22.775 | 22.7829 | 22.775 | 22.7829 | 55636.0 |
| 2014-05-30 08:30:00 | AAPL | Stock | 22.7789 | 22.7925 | 22.7789 | 22.7857 | 78792.0 |
| 2014-05-30 08:35:00 | AAPL | Stock | 22.785 | 22.7868 | 22.77 | 22.7786 | 162484.0 |
| 2014-05-30 08:40:00 | AAPL | Stock | 22.7736 | 22.7789 | 22.7575 | 22.7664 | 152824.0 |
| 2014-05-30 08:45:00 | AAPL | Stock | 22.7679 | 22.7714 | 22.7643 | 22.7714 | 151312.0 |
| 2014-05-30 08:50:00 | AAPL | Stock | 22.7604 | 22.7604 | 22.7429 | 22.7429 | 232624.0 |
| 2014-05-30 08:55:00 | AAPL | Stock | 22.7457 | 22.7504 | 22.745 | 22.7486 | 130648.0 |
| 2014-05-30 09:00:00 | AAPL | Stock | 22.7486 | 22.7589 | 22.7486 | 22.7589 | 75880.0 |
| 2014-05-30 09:05:00 | AAPL | Stock | 22.7589 | 22.7714 | 22.7589 | 22.7679 | 253064.0 |
| 2014-05-30 09:10:00 | AAPL | Stock | 22.7679 | 22.7761 | 22.7632 | 22.7714 | 191044.0 |
| 2014-05-30 09:15:00 | AAPL | Stock | 22.7725 | 22.7736 | 22.7686 | 22.7686 | 34412.0 |
| 2014-05-30 09:20:00 | AAPL | Stock | 22.7682 | 22.7682 | 22.7589 | 22.7596 | 86324.0 |
| 2014-05-30 09:25:00 | AAPL | Stock | 22.7596 | 22.785 | 22.7589 | 22.785 | 420392.0 |
| 2014-05-30 09:30:00 | AAPL | Stock | 22.785 | 22.8154 | 22.7368 | 22.7561 | 19257196.0 |
| 2014-05-30 09:35:00 | AAPL | Stock | 22.7568 | 22.7593 | 22.6875 | 22.6957 | 13447532.0 |
| 2014-05-30 09:40:00 | AAPL | Stock | 22.6939 | 22.7536 | 22.6875 | 22.7425 | 6343820.0 |
| 2014-05-30 09:45:00 | AAPL | Stock | 22.7432 | 22.7761 | 22.7411 | 22.7737 | 5798464.0 |
| 2014-05-30 09:50:00 | AAPL | Stock | 22.7747 | 22.8118 | 22.7657 | 22.7964 | 5955852.0 |
> showing 50 of 356,561 rows — these rows as CSV