PREVIEW / stock_5min / 2008-05-13
file: by_date/stock_5min/2008/2008-05-13.parquet size: 4.4 MB rows: 313,910 symbols: 3,301
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 |
|---|---|---|---|---|---|---|---|
| 2008-05-13 05:25:00 | AAPL | Stock | 6.6993 | 6.6993 | 6.6993 | 6.6993 | 4200.0 |
| 2008-05-13 06:55:00 | AAPL | Stock | 6.7354 | 6.7354 | 6.7354 | 6.7354 | 2800.0 |
| 2008-05-13 07:20:00 | AAPL | Stock | 6.715 | 6.715 | 6.7143 | 6.7143 | 58800.0 |
| 2008-05-13 07:25:00 | AAPL | Stock | 6.7143 | 6.7143 | 6.7089 | 6.7143 | 44800.0 |
| 2008-05-13 07:45:00 | AAPL | Stock | 6.7071 | 6.7071 | 6.7071 | 6.7071 | 10332.0 |
| 2008-05-13 07:50:00 | AAPL | Stock | 6.6964 | 6.6964 | 6.6964 | 6.6964 | 53200.0 |
| 2008-05-13 07:55:00 | AAPL | Stock | 6.7036 | 6.7036 | 6.7036 | 6.7036 | 5600.0 |
| 2008-05-13 08:00:00 | AAPL | Stock | 6.7093 | 6.7104 | 6.6989 | 6.7071 | 187796.0 |
| 2008-05-13 08:05:00 | AAPL | Stock | 6.7079 | 6.7079 | 6.7061 | 6.7071 | 66612.0 |
| 2008-05-13 08:10:00 | AAPL | Stock | 6.7071 | 6.7089 | 6.7061 | 6.7089 | 26600.0 |
| 2008-05-13 08:15:00 | AAPL | Stock | 6.7086 | 6.7161 | 6.7086 | 6.7146 | 68292.0 |
| 2008-05-13 08:20:00 | AAPL | Stock | 6.7146 | 6.7196 | 6.7107 | 6.7107 | 114828.0 |
| 2008-05-13 08:25:00 | AAPL | Stock | 6.7104 | 6.7164 | 6.7075 | 6.7164 | 81200.0 |
| 2008-05-13 08:30:00 | AAPL | Stock | 6.7143 | 6.725 | 6.7136 | 6.7236 | 568848.0 |
| 2008-05-13 08:35:00 | AAPL | Stock | 6.7229 | 6.7304 | 6.7221 | 6.7293 | 414540.0 |
| 2008-05-13 08:40:00 | AAPL | Stock | 6.7293 | 6.7332 | 6.7289 | 6.7314 | 238980.0 |
| 2008-05-13 08:45:00 | AAPL | Stock | 6.7314 | 6.7332 | 6.7296 | 6.7314 | 367668.0 |
| 2008-05-13 08:50:00 | AAPL | Stock | 6.7311 | 6.7325 | 6.7264 | 6.7314 | 216860.0 |
| 2008-05-13 08:55:00 | AAPL | Stock | 6.7321 | 6.7357 | 6.7321 | 6.7346 | 215656.0 |
| 2008-05-13 09:00:00 | AAPL | Stock | 6.7346 | 6.7432 | 6.7346 | 6.7429 | 372484.0 |
| 2008-05-13 09:05:00 | AAPL | Stock | 6.7439 | 6.7496 | 6.7429 | 6.7479 | 417900.0 |
| 2008-05-13 09:10:00 | AAPL | Stock | 6.7468 | 6.7482 | 6.74 | 6.7407 | 480872.0 |
| 2008-05-13 09:15:00 | AAPL | Stock | 6.7407 | 6.7446 | 6.7364 | 6.7436 | 191828.0 |
| 2008-05-13 09:20:00 | AAPL | Stock | 6.7436 | 6.7436 | 6.7325 | 6.7336 | 236040.0 |
| 2008-05-13 09:25:00 | AAPL | Stock | 6.7325 | 6.7371 | 6.7325 | 6.7361 | 311276.0 |
| 2008-05-13 09:30:00 | AAPL | Stock | 6.7361 | 6.7464 | 6.7221 | 6.7339 | 20390496.0 |
| 2008-05-13 09:35:00 | AAPL | Stock | 6.7336 | 6.7589 | 6.7093 | 6.7482 | 23219168.0 |
| 2008-05-13 09:40:00 | AAPL | Stock | 6.7486 | 6.755 | 6.7257 | 6.7289 | 19482316.0 |
| 2008-05-13 09:45:00 | AAPL | Stock | 6.7282 | 6.7643 | 6.7236 | 6.7479 | 24911432.0 |
| 2008-05-13 09:50:00 | AAPL | Stock | 6.7475 | 6.7611 | 6.7389 | 6.7513 | 19738796.0 |
| 2008-05-13 09:55:00 | AAPL | Stock | 6.7511 | 6.7729 | 6.7496 | 6.77 | 18810428.0 |
| 2008-05-13 10:00:00 | AAPL | Stock | 6.7704 | 6.7814 | 6.7529 | 6.7782 | 16632756.0 |
| 2008-05-13 10:05:00 | AAPL | Stock | 6.7782 | 6.7836 | 6.7693 | 6.7793 | 16450476.0 |
| 2008-05-13 10:10:00 | AAPL | Stock | 6.7786 | 6.7854 | 6.7761 | 6.7782 | 17857672.0 |
| 2008-05-13 10:15:00 | AAPL | Stock | 6.7782 | 6.7936 | 6.7754 | 6.7925 | 25994360.0 |
| 2008-05-13 10:20:00 | AAPL | Stock | 6.7921 | 6.8168 | 6.7864 | 6.8129 | 28127820.0 |
| 2008-05-13 10:25:00 | AAPL | Stock | 6.8129 | 6.8175 | 6.8021 | 6.8066 | 18175052.0 |
| 2008-05-13 10:30:00 | AAPL | Stock | 6.8061 | 6.8196 | 6.8054 | 6.8122 | 15574944.0 |
| 2008-05-13 10:35:00 | AAPL | Stock | 6.8129 | 6.8321 | 6.8057 | 6.8304 | 21041888.0 |
| 2008-05-13 10:40:00 | AAPL | Stock | 6.8304 | 6.8375 | 6.8246 | 6.8321 | 15213436.0 |
| 2008-05-13 10:45:00 | AAPL | Stock | 6.8321 | 6.8357 | 6.7964 | 6.7971 | 23123380.0 |
| 2008-05-13 10:50:00 | AAPL | Stock | 6.7968 | 6.8107 | 6.7725 | 6.7788 | 22803032.0 |
| 2008-05-13 10:55:00 | AAPL | Stock | 6.7789 | 6.7846 | 6.7696 | 6.7786 | 19780880.0 |
| 2008-05-13 11:00:00 | AAPL | Stock | 6.7796 | 6.7914 | 6.7625 | 6.7911 | 18399192.0 |
| 2008-05-13 11:05:00 | AAPL | Stock | 6.7911 | 6.7925 | 6.7782 | 6.7879 | 11402048.0 |
| 2008-05-13 11:10:00 | AAPL | Stock | 6.7875 | 6.7911 | 6.7804 | 6.7882 | 8525580.0 |
| 2008-05-13 11:15:00 | AAPL | Stock | 6.7893 | 6.7906 | 6.775 | 6.7771 | 8059212.0 |
| 2008-05-13 11:20:00 | AAPL | Stock | 6.7775 | 6.7782 | 6.7618 | 6.7768 | 13868736.0 |
| 2008-05-13 11:25:00 | AAPL | Stock | 6.7761 | 6.7839 | 6.77 | 6.7757 | 6352668.0 |
| 2008-05-13 11:30:00 | AAPL | Stock | 6.7746 | 6.7825 | 6.7714 | 6.7761 | 5518464.0 |
> showing 50 of 313,910 rows — these rows as CSV