PREVIEW / stock_5min / 2013-02-15
file: by_date/stock_5min/2013/2013-02-15.parquet size: 4.9 MB rows: 329,749 symbols: 3,461
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-15 06:15:00 | AAPL | Stock | 16.7268 | 16.7268 | 16.7268 | 16.7268 | 2800.0 |
| 2013-02-15 06:40:00 | AAPL | Stock | 16.6825 | 16.6825 | 16.6825 | 16.6825 | 2800.0 |
| 2013-02-15 06:50:00 | AAPL | Stock | 16.6786 | 16.6786 | 16.6786 | 16.6786 | 11200.0 |
| 2013-02-15 07:10:00 | AAPL | Stock | 16.6821 | 16.6821 | 16.6786 | 16.6786 | 13160.0 |
| 2013-02-15 07:20:00 | AAPL | Stock | 16.6964 | 16.6964 | 16.6964 | 16.6964 | 2800.0 |
| 2013-02-15 07:25:00 | AAPL | Stock | 16.6914 | 16.6914 | 16.6914 | 16.6914 | 7700.0 |
| 2013-02-15 07:30:00 | AAPL | Stock | 16.6929 | 16.6929 | 16.6929 | 16.6929 | 2800.0 |
| 2013-02-15 07:35:00 | AAPL | Stock | 16.6929 | 16.6929 | 16.6929 | 16.6929 | 2800.0 |
| 2013-02-15 07:55:00 | AAPL | Stock | 16.6911 | 16.6936 | 16.6875 | 16.6875 | 29400.0 |
| 2013-02-15 08:00:00 | AAPL | Stock | 16.7104 | 16.7104 | 16.6836 | 16.6861 | 125020.0 |
| 2013-02-15 08:05:00 | AAPL | Stock | 16.6946 | 16.7143 | 16.6946 | 16.7096 | 33740.0 |
| 2013-02-15 08:10:00 | AAPL | Stock | 16.7271 | 16.7407 | 16.7146 | 16.7407 | 64400.0 |
| 2013-02-15 08:15:00 | AAPL | Stock | 16.7454 | 16.75 | 16.7321 | 16.7429 | 162064.0 |
| 2013-02-15 08:20:00 | AAPL | Stock | 16.7343 | 16.7414 | 16.7243 | 16.7343 | 157864.0 |
| 2013-02-15 08:25:00 | AAPL | Stock | 16.7393 | 16.7414 | 16.7304 | 16.7304 | 93268.0 |
| 2013-02-15 08:30:00 | AAPL | Stock | 16.7371 | 16.745 | 16.7264 | 16.7264 | 171332.0 |
| 2013-02-15 08:35:00 | AAPL | Stock | 16.7264 | 16.7264 | 16.7161 | 16.7179 | 176456.0 |
| 2013-02-15 08:40:00 | AAPL | Stock | 16.7232 | 16.7296 | 16.7232 | 16.7254 | 53480.0 |
| 2013-02-15 08:45:00 | AAPL | Stock | 16.7279 | 16.7382 | 16.7236 | 16.7236 | 78260.0 |
| 2013-02-15 08:50:00 | AAPL | Stock | 16.725 | 16.7286 | 16.7193 | 16.7279 | 63616.0 |
| 2013-02-15 08:55:00 | AAPL | Stock | 16.7314 | 16.7357 | 16.7207 | 16.7207 | 131936.0 |
| 2013-02-15 09:00:00 | AAPL | Stock | 16.7279 | 16.7279 | 16.7179 | 16.7179 | 160160.0 |
| 2013-02-15 09:05:00 | AAPL | Stock | 16.7161 | 16.725 | 16.7154 | 16.7171 | 82236.0 |
| 2013-02-15 09:10:00 | AAPL | Stock | 16.7157 | 16.7279 | 16.7157 | 16.7279 | 14000.0 |
| 2013-02-15 09:15:00 | AAPL | Stock | 16.7232 | 16.7357 | 16.7232 | 16.7357 | 81620.0 |
| 2013-02-15 09:20:00 | AAPL | Stock | 16.7357 | 16.7664 | 16.7357 | 16.7596 | 371980.0 |
| 2013-02-15 09:25:00 | AAPL | Stock | 16.7571 | 16.7589 | 16.7329 | 16.75 | 361872.0 |
| 2013-02-15 09:30:00 | AAPL | Stock | 16.7561 | 16.7571 | 16.7011 | 16.7136 | 30886464.0 |
| 2013-02-15 09:35:00 | AAPL | Stock | 16.7118 | 16.7143 | 16.6854 | 16.6986 | 6482756.0 |
| 2013-02-15 09:40:00 | AAPL | Stock | 16.6971 | 16.7386 | 16.6854 | 16.7096 | 7255640.0 |
| 2013-02-15 09:45:00 | AAPL | Stock | 16.7075 | 16.7225 | 16.655 | 16.6771 | 9707124.0 |
| 2013-02-15 09:50:00 | AAPL | Stock | 16.6696 | 16.6911 | 16.6536 | 16.6864 | 4704840.0 |
| 2013-02-15 09:55:00 | AAPL | Stock | 16.6886 | 16.7443 | 16.6804 | 16.7346 | 8549324.0 |
| 2013-02-15 10:00:00 | AAPL | Stock | 16.7293 | 16.7914 | 16.7293 | 16.7482 | 13426196.0 |
| 2013-02-15 10:05:00 | AAPL | Stock | 16.7489 | 16.7707 | 16.7107 | 16.7425 | 7064876.0 |
| 2013-02-15 10:10:00 | AAPL | Stock | 16.74 | 16.7425 | 16.7004 | 16.7164 | 4132520.0 |
| 2013-02-15 10:15:00 | AAPL | Stock | 16.7157 | 16.7264 | 16.7021 | 16.7221 | 2973264.0 |
| 2013-02-15 10:20:00 | AAPL | Stock | 16.7221 | 16.7293 | 16.6964 | 16.7149 | 3735872.0 |
| 2013-02-15 10:25:00 | AAPL | Stock | 16.7179 | 16.7321 | 16.7089 | 16.7139 | 3203480.0 |
| 2013-02-15 10:30:00 | AAPL | Stock | 16.7136 | 16.7189 | 16.6829 | 16.7014 | 3696028.0 |
| 2013-02-15 10:35:00 | AAPL | Stock | 16.7007 | 16.7096 | 16.6886 | 16.6904 | 2279144.0 |
| 2013-02-15 10:40:00 | AAPL | Stock | 16.6929 | 16.7239 | 16.6804 | 16.7043 | 3045084.0 |
| 2013-02-15 10:45:00 | AAPL | Stock | 16.7014 | 16.7064 | 16.6718 | 16.6754 | 4121404.0 |
| 2013-02-15 10:50:00 | AAPL | Stock | 16.6782 | 16.6893 | 16.6729 | 16.6889 | 1884092.0 |
| 2013-02-15 10:55:00 | AAPL | Stock | 16.6864 | 16.6975 | 16.675 | 16.6929 | 1829800.0 |
| 2013-02-15 11:00:00 | AAPL | Stock | 16.6957 | 16.6982 | 16.6793 | 16.6861 | 1626352.0 |
| 2013-02-15 11:05:00 | AAPL | Stock | 16.6821 | 16.6911 | 16.6768 | 16.6768 | 1694700.0 |
| 2013-02-15 11:10:00 | AAPL | Stock | 16.6768 | 16.6907 | 16.6707 | 16.675 | 2117108.0 |
| 2013-02-15 11:15:00 | AAPL | Stock | 16.6732 | 16.6768 | 16.6575 | 16.6575 | 2946664.0 |
| 2013-02-15 11:20:00 | AAPL | Stock | 16.6575 | 16.6846 | 16.6486 | 16.6807 | 3459568.0 |
> showing 50 of 329,749 rows — these rows as CSV