PREVIEW / stock_5min / 2013-01-24
file: by_date/stock_5min/2013/2013-01-24.parquet size: 4.9 MB rows: 329,876 symbols: 3,498
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-01-24 04:00:00 | AAPL | Stock | 16.5714 | 16.7768 | 16.5714 | 16.7179 | 224028.0 |
| 2013-01-24 04:05:00 | AAPL | Stock | 16.7057 | 16.7143 | 16.6832 | 16.6857 | 174216.0 |
| 2013-01-24 04:10:00 | AAPL | Stock | 16.6821 | 16.7143 | 16.6821 | 16.7143 | 136052.0 |
| 2013-01-24 04:15:00 | AAPL | Stock | 16.7482 | 16.7679 | 16.7446 | 16.7679 | 174440.0 |
| 2013-01-24 04:20:00 | AAPL | Stock | 16.7679 | 16.7686 | 16.75 | 16.75 | 257600.0 |
| 2013-01-24 04:25:00 | AAPL | Stock | 16.7554 | 16.7857 | 16.7475 | 16.7857 | 102760.0 |
| 2013-01-24 04:30:00 | AAPL | Stock | 16.7857 | 16.7864 | 16.7475 | 16.7493 | 220108.0 |
| 2013-01-24 04:35:00 | AAPL | Stock | 16.7539 | 16.7539 | 16.75 | 16.75 | 47740.0 |
| 2013-01-24 04:40:00 | AAPL | Stock | 16.75 | 16.7857 | 16.7479 | 16.7779 | 96040.0 |
| 2013-01-24 04:45:00 | AAPL | Stock | 16.7854 | 16.8225 | 16.7736 | 16.8036 | 235620.0 |
| 2013-01-24 04:50:00 | AAPL | Stock | 16.8036 | 16.8182 | 16.8036 | 16.8161 | 17528.0 |
| 2013-01-24 04:55:00 | AAPL | Stock | 16.8214 | 16.8429 | 16.8214 | 16.8421 | 89600.0 |
| 2013-01-24 05:00:00 | AAPL | Stock | 16.8421 | 16.8657 | 16.8357 | 16.8429 | 164108.0 |
| 2013-01-24 05:05:00 | AAPL | Stock | 16.8429 | 16.8714 | 16.8429 | 16.8614 | 43540.0 |
| 2013-01-24 05:10:00 | AAPL | Stock | 16.8646 | 16.9068 | 16.8643 | 16.8929 | 277340.0 |
| 2013-01-24 05:15:00 | AAPL | Stock | 16.8929 | 16.9286 | 16.8929 | 16.9286 | 249760.0 |
| 2013-01-24 05:20:00 | AAPL | Stock | 16.9182 | 16.925 | 16.9179 | 16.925 | 139048.0 |
| 2013-01-24 05:25:00 | AAPL | Stock | 16.9186 | 16.9261 | 16.9175 | 16.9214 | 50400.0 |
| 2013-01-24 05:30:00 | AAPL | Stock | 16.905 | 16.905 | 16.8571 | 16.8586 | 290500.0 |
| 2013-01-24 05:35:00 | AAPL | Stock | 16.8546 | 16.8546 | 16.7857 | 16.7857 | 47600.0 |
| 2013-01-24 05:40:00 | AAPL | Stock | 16.8429 | 16.8429 | 16.7857 | 16.7857 | 59080.0 |
| 2013-01-24 05:45:00 | AAPL | Stock | 16.7679 | 16.8404 | 16.7607 | 16.8268 | 193424.0 |
| 2013-01-24 05:55:00 | AAPL | Stock | 16.8046 | 16.8393 | 16.7854 | 16.8393 | 213752.0 |
| 2013-01-24 06:00:00 | AAPL | Stock | 16.8014 | 16.8014 | 16.7554 | 16.7732 | 147980.0 |
| 2013-01-24 06:05:00 | AAPL | Stock | 16.7696 | 16.7696 | 16.7339 | 16.75 | 497700.0 |
| 2013-01-24 06:10:00 | AAPL | Stock | 16.7589 | 16.7689 | 16.7243 | 16.75 | 139384.0 |
| 2013-01-24 06:15:00 | AAPL | Stock | 16.7268 | 16.7268 | 16.7036 | 16.7143 | 78988.0 |
| 2013-01-24 06:20:00 | AAPL | Stock | 16.7146 | 16.7146 | 16.6914 | 16.6964 | 65016.0 |
| 2013-01-24 06:25:00 | AAPL | Stock | 16.6964 | 16.7 | 16.6829 | 16.7 | 67172.0 |
| 2013-01-24 06:30:00 | AAPL | Stock | 16.6911 | 16.7143 | 16.6436 | 16.7143 | 528192.0 |
| 2013-01-24 06:35:00 | AAPL | Stock | 16.7018 | 16.7018 | 16.6607 | 16.6607 | 134540.0 |
| 2013-01-24 06:40:00 | AAPL | Stock | 16.6746 | 16.6786 | 16.6429 | 16.6457 | 287980.0 |
| 2013-01-24 06:45:00 | AAPL | Stock | 16.6425 | 16.6732 | 16.6107 | 16.6443 | 177044.0 |
| 2013-01-24 06:50:00 | AAPL | Stock | 16.6429 | 16.6643 | 16.6071 | 16.6075 | 745892.0 |
| 2013-01-24 06:55:00 | AAPL | Stock | 16.6057 | 16.6229 | 16.5982 | 16.6229 | 231616.0 |
| 2013-01-24 07:00:00 | AAPL | Stock | 16.6232 | 16.7179 | 16.6075 | 16.7143 | 520548.0 |
| 2013-01-24 07:05:00 | AAPL | Stock | 16.7089 | 16.7321 | 16.645 | 16.6893 | 1752632.0 |
| 2013-01-24 07:10:00 | AAPL | Stock | 16.6804 | 16.6893 | 16.6589 | 16.6607 | 1121456.0 |
| 2013-01-24 07:15:00 | AAPL | Stock | 16.6725 | 16.6725 | 16.625 | 16.6429 | 301924.0 |
| 2013-01-24 07:20:00 | AAPL | Stock | 16.6607 | 16.7129 | 16.6446 | 16.7129 | 1016596.0 |
| 2013-01-24 07:25:00 | AAPL | Stock | 16.7032 | 16.7229 | 16.6882 | 16.7093 | 377832.0 |
| 2013-01-24 07:30:00 | AAPL | Stock | 16.6957 | 16.7121 | 16.6875 | 16.6975 | 423164.0 |
| 2013-01-24 07:35:00 | AAPL | Stock | 16.7 | 16.7229 | 16.6964 | 16.7214 | 287112.0 |
| 2013-01-24 07:40:00 | AAPL | Stock | 16.7214 | 16.7264 | 16.6964 | 16.7264 | 733376.0 |
| 2013-01-24 07:45:00 | AAPL | Stock | 16.7268 | 16.7429 | 16.7264 | 16.7354 | 707000.0 |
| 2013-01-24 07:50:00 | AAPL | Stock | 16.7354 | 16.7411 | 16.7143 | 16.7146 | 1122828.0 |
| 2013-01-24 07:55:00 | AAPL | Stock | 16.7143 | 16.7404 | 16.7143 | 16.7296 | 1053836.0 |
| 2013-01-24 08:00:00 | AAPL | Stock | 16.7321 | 16.7596 | 16.6418 | 16.6875 | 5260696.0 |
| 2013-01-24 08:05:00 | AAPL | Stock | 16.6832 | 16.6961 | 16.6543 | 16.6614 | 1632204.0 |
| 2013-01-24 08:10:00 | AAPL | Stock | 16.6714 | 16.6714 | 16.6129 | 16.6129 | 1883700.0 |
> showing 50 of 329,876 rows — these rows as CSV