PREVIEW / stock_5min / 2009-05-27
file: by_date/stock_5min/2009/2009-05-27.parquet size: 4.6 MB rows: 319,866 symbols: 3,348
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-27 05:05:00 | AAPL | Stock | 4.7236 | 4.7236 | 4.7236 | 4.7236 | 2800.0 |
| 2009-05-27 07:00:00 | AAPL | Stock | 4.7186 | 4.7186 | 4.7143 | 4.7143 | 64400.0 |
| 2009-05-27 07:05:00 | AAPL | Stock | 4.7146 | 4.7146 | 4.6804 | 4.6804 | 292600.0 |
| 2009-05-27 07:10:00 | AAPL | Stock | 4.6929 | 4.6932 | 4.6929 | 4.6932 | 16800.0 |
| 2009-05-27 07:20:00 | AAPL | Stock | 4.6896 | 4.6896 | 4.6832 | 4.6832 | 5600.0 |
| 2009-05-27 07:25:00 | AAPL | Stock | 4.6868 | 4.6875 | 4.6868 | 4.6875 | 5600.0 |
| 2009-05-27 07:30:00 | AAPL | Stock | 4.6857 | 4.6893 | 4.6857 | 4.6893 | 22400.0 |
| 2009-05-27 07:50:00 | AAPL | Stock | 4.6929 | 4.6932 | 4.6929 | 4.6932 | 56000.0 |
| 2009-05-27 07:55:00 | AAPL | Stock | 4.6968 | 4.6968 | 4.6875 | 4.6893 | 67200.0 |
| 2009-05-27 08:00:00 | AAPL | Stock | 4.6929 | 4.6964 | 4.6879 | 4.6911 | 437136.0 |
| 2009-05-27 08:05:00 | AAPL | Stock | 4.6911 | 4.6911 | 4.6861 | 4.6861 | 39900.0 |
| 2009-05-27 08:10:00 | AAPL | Stock | 4.6914 | 4.6946 | 4.6914 | 4.6921 | 197260.0 |
| 2009-05-27 08:15:00 | AAPL | Stock | 4.6882 | 4.6904 | 4.685 | 4.6857 | 180768.0 |
| 2009-05-27 08:20:00 | AAPL | Stock | 4.6857 | 4.6857 | 4.6804 | 4.6807 | 83440.0 |
| 2009-05-27 08:25:00 | AAPL | Stock | 4.6804 | 4.6871 | 4.6782 | 4.6871 | 235844.0 |
| 2009-05-27 08:30:00 | AAPL | Stock | 4.6875 | 4.6893 | 4.6868 | 4.6893 | 56000.0 |
| 2009-05-27 08:35:00 | AAPL | Stock | 4.6882 | 4.6882 | 4.6854 | 4.6875 | 65800.0 |
| 2009-05-27 08:40:00 | AAPL | Stock | 4.6893 | 4.69 | 4.6893 | 4.69 | 32984.0 |
| 2009-05-27 08:45:00 | AAPL | Stock | 4.69 | 4.6968 | 4.69 | 4.6964 | 209300.0 |
| 2009-05-27 08:50:00 | AAPL | Stock | 4.6964 | 4.7029 | 4.6943 | 4.6964 | 238224.0 |
| 2009-05-27 08:55:00 | AAPL | Stock | 4.6964 | 4.6971 | 4.6904 | 4.6904 | 226800.0 |
| 2009-05-27 09:00:00 | AAPL | Stock | 4.69 | 4.6971 | 4.6896 | 4.6971 | 116760.0 |
| 2009-05-27 09:05:00 | AAPL | Stock | 4.6964 | 4.6989 | 4.6946 | 4.695 | 159320.0 |
| 2009-05-27 09:10:00 | AAPL | Stock | 4.6946 | 4.7 | 4.6946 | 4.6993 | 144900.0 |
| 2009-05-27 09:15:00 | AAPL | Stock | 4.7 | 4.7004 | 4.6946 | 4.7004 | 91840.0 |
| 2009-05-27 09:20:00 | AAPL | Stock | 4.6989 | 4.7018 | 4.6961 | 4.6961 | 141960.0 |
| 2009-05-27 09:25:00 | AAPL | Stock | 4.6968 | 4.7054 | 4.6943 | 4.7054 | 393540.0 |
| 2009-05-27 09:30:00 | AAPL | Stock | 4.7064 | 4.7229 | 4.6754 | 4.7132 | 28903784.0 |
| 2009-05-27 09:35:00 | AAPL | Stock | 4.7136 | 4.721 | 4.6877 | 4.6978 | 14923748.0 |
| 2009-05-27 09:40:00 | AAPL | Stock | 4.6982 | 4.7236 | 4.6889 | 4.72 | 12409292.0 |
| 2009-05-27 09:45:00 | AAPL | Stock | 4.7196 | 4.74 | 4.7175 | 4.7381 | 21742196.0 |
| 2009-05-27 09:50:00 | AAPL | Stock | 4.7379 | 4.7561 | 4.7296 | 4.7346 | 22420468.0 |
| 2009-05-27 09:55:00 | AAPL | Stock | 4.7346 | 4.7429 | 4.7239 | 4.7375 | 9674140.0 |
| 2009-05-27 10:00:00 | AAPL | Stock | 4.7375 | 4.7461 | 4.7232 | 4.7268 | 13441428.0 |
| 2009-05-27 10:05:00 | AAPL | Stock | 4.7268 | 4.7454 | 4.7246 | 4.7329 | 10438736.0 |
| 2009-05-27 10:10:00 | AAPL | Stock | 4.7332 | 4.7561 | 4.7282 | 4.7532 | 12525800.0 |
| 2009-05-27 10:15:00 | AAPL | Stock | 4.7536 | 4.7589 | 4.7331 | 4.7589 | 9147852.0 |
| 2009-05-27 10:20:00 | AAPL | Stock | 4.7589 | 4.7814 | 4.7561 | 4.7786 | 16939300.0 |
| 2009-05-27 10:25:00 | AAPL | Stock | 4.7786 | 4.7932 | 4.7746 | 4.7829 | 15438808.0 |
| 2009-05-27 10:30:00 | AAPL | Stock | 4.7839 | 4.7932 | 4.7754 | 4.7814 | 9468844.0 |
| 2009-05-27 10:35:00 | AAPL | Stock | 4.7821 | 4.8054 | 4.7807 | 4.7982 | 14146524.0 |
| 2009-05-27 10:40:00 | AAPL | Stock | 4.7982 | 4.815 | 4.7946 | 4.8082 | 15838284.0 |
| 2009-05-27 10:45:00 | AAPL | Stock | 4.8077 | 4.8175 | 4.8011 | 4.8171 | 11615940.0 |
| 2009-05-27 10:50:00 | AAPL | Stock | 4.8168 | 4.8179 | 4.8018 | 4.8054 | 10004540.0 |
| 2009-05-27 10:55:00 | AAPL | Stock | 4.8054 | 4.8207 | 4.8036 | 4.8171 | 11157272.0 |
| 2009-05-27 11:00:00 | AAPL | Stock | 4.8171 | 4.8173 | 4.7932 | 4.7982 | 11218564.0 |
| 2009-05-27 11:05:00 | AAPL | Stock | 4.7985 | 4.8025 | 4.7925 | 4.7954 | 5522384.0 |
| 2009-05-27 11:10:00 | AAPL | Stock | 4.7961 | 4.8029 | 4.7915 | 4.7975 | 7092596.0 |
| 2009-05-27 11:15:00 | AAPL | Stock | 4.7968 | 4.7968 | 4.7879 | 4.7914 | 6016276.0 |
| 2009-05-27 11:20:00 | AAPL | Stock | 4.7929 | 4.7946 | 4.7864 | 4.7893 | 6097112.0 |
> showing 50 of 319,866 rows — these rows as CSV