PREVIEW / stock_5min / 2014-01-31
file: by_date/stock_5min/2014/2014-01-31.parquet size: 5.6 MB rows: 365,949 symbols: 3,534
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-01-31 04:35:00 | AAPL | Stock | 17.7821 | 17.7821 | 17.7821 | 17.7821 | 5600.0 |
| 2014-01-31 04:40:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 5600.0 |
| 2014-01-31 04:45:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 19768.0 |
| 2014-01-31 04:50:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 19600.0 |
| 2014-01-31 05:00:00 | AAPL | Stock | 17.7786 | 17.7786 | 17.7561 | 17.7561 | 11340.0 |
| 2014-01-31 05:05:00 | AAPL | Stock | 17.7561 | 17.7561 | 17.7561 | 17.7561 | 5460.0 |
| 2014-01-31 05:15:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 2800.0 |
| 2014-01-31 05:25:00 | AAPL | Stock | 17.7061 | 17.7061 | 17.7 | 17.7 | 5600.0 |
| 2014-01-31 05:30:00 | AAPL | Stock | 17.7 | 17.7039 | 17.7 | 17.7039 | 8400.0 |
| 2014-01-31 05:35:00 | AAPL | Stock | 17.7261 | 17.7261 | 17.7261 | 17.7261 | 2800.0 |
| 2014-01-31 05:45:00 | AAPL | Stock | 17.7543 | 17.7543 | 17.7543 | 17.7543 | 2800.0 |
| 2014-01-31 05:55:00 | AAPL | Stock | 17.7329 | 17.7329 | 17.6875 | 17.6875 | 16660.0 |
| 2014-01-31 06:05:00 | AAPL | Stock | 17.7529 | 17.7543 | 17.7529 | 17.7543 | 5600.0 |
| 2014-01-31 06:15:00 | AAPL | Stock | 17.7571 | 17.7679 | 17.7571 | 17.7679 | 25200.0 |
| 2014-01-31 06:30:00 | AAPL | Stock | 17.7571 | 17.7571 | 17.75 | 17.75 | 11200.0 |
| 2014-01-31 06:35:00 | AAPL | Stock | 17.7411 | 17.7446 | 17.7146 | 17.7146 | 77140.0 |
| 2014-01-31 06:40:00 | AAPL | Stock | 17.7057 | 17.7057 | 17.6875 | 17.6875 | 56000.0 |
| 2014-01-31 06:45:00 | AAPL | Stock | 17.7036 | 17.7036 | 17.6982 | 17.6982 | 12292.0 |
| 2014-01-31 06:50:00 | AAPL | Stock | 17.6996 | 17.7182 | 17.6996 | 17.7146 | 16828.0 |
| 2014-01-31 06:55:00 | AAPL | Stock | 17.6989 | 17.6989 | 17.6989 | 17.6989 | 2800.0 |
| 2014-01-31 07:00:00 | AAPL | Stock | 17.7268 | 17.7268 | 17.7268 | 17.7268 | 2800.0 |
| 2014-01-31 07:05:00 | AAPL | Stock | 17.7218 | 17.7218 | 17.7218 | 17.7218 | 5600.0 |
| 2014-01-31 07:10:00 | AAPL | Stock | 17.7154 | 17.7154 | 17.7039 | 17.7039 | 48888.0 |
| 2014-01-31 07:15:00 | AAPL | Stock | 17.7104 | 17.7143 | 17.7104 | 17.7143 | 14700.0 |
| 2014-01-31 07:20:00 | AAPL | Stock | 17.7143 | 17.7232 | 17.7143 | 17.7232 | 18508.0 |
| 2014-01-31 07:25:00 | AAPL | Stock | 17.7482 | 17.7714 | 17.7482 | 17.7714 | 45080.0 |
| 2014-01-31 07:30:00 | AAPL | Stock | 17.7607 | 17.7643 | 17.7543 | 17.7643 | 26348.0 |
| 2014-01-31 07:35:00 | AAPL | Stock | 17.7589 | 17.7589 | 17.7143 | 17.7146 | 180936.0 |
| 2014-01-31 07:40:00 | AAPL | Stock | 17.7143 | 17.7232 | 17.7054 | 17.7232 | 66332.0 |
| 2014-01-31 07:45:00 | AAPL | Stock | 17.7057 | 17.7357 | 17.7057 | 17.7168 | 23408.0 |
| 2014-01-31 07:50:00 | AAPL | Stock | 17.725 | 17.7286 | 17.715 | 17.715 | 26320.0 |
| 2014-01-31 07:55:00 | AAPL | Stock | 17.7143 | 17.7143 | 17.7143 | 17.7143 | 10332.0 |
| 2014-01-31 08:00:00 | AAPL | Stock | 17.75 | 17.75 | 17.705 | 17.7232 | 236852.0 |
| 2014-01-31 08:05:00 | AAPL | Stock | 17.7232 | 17.7232 | 17.7 | 17.7032 | 147812.0 |
| 2014-01-31 08:10:00 | AAPL | Stock | 17.7032 | 17.7136 | 17.6964 | 17.7032 | 229880.0 |
| 2014-01-31 08:15:00 | AAPL | Stock | 17.7032 | 17.7114 | 17.6875 | 17.7 | 428652.0 |
| 2014-01-31 08:20:00 | AAPL | Stock | 17.7 | 17.7089 | 17.7 | 17.7025 | 120232.0 |
| 2014-01-31 08:25:00 | AAPL | Stock | 17.705 | 17.7121 | 17.6875 | 17.6943 | 230972.0 |
| 2014-01-31 08:30:00 | AAPL | Stock | 17.6961 | 17.7164 | 17.6875 | 17.7164 | 159432.0 |
| 2014-01-31 08:35:00 | AAPL | Stock | 17.7171 | 17.7171 | 17.6981 | 17.7136 | 161728.0 |
| 2014-01-31 08:40:00 | AAPL | Stock | 17.7111 | 17.7143 | 17.7021 | 17.7143 | 153860.0 |
| 2014-01-31 08:45:00 | AAPL | Stock | 17.7225 | 17.7225 | 17.7143 | 17.7143 | 24360.0 |
| 2014-01-31 08:50:00 | AAPL | Stock | 17.7061 | 17.7139 | 17.6982 | 17.7125 | 122556.0 |
| 2014-01-31 08:55:00 | AAPL | Stock | 17.7107 | 17.7214 | 17.7079 | 17.7214 | 150024.0 |
| 2014-01-31 09:00:00 | AAPL | Stock | 17.7271 | 17.7361 | 17.7268 | 17.7268 | 28000.0 |
| 2014-01-31 09:05:00 | AAPL | Stock | 17.7321 | 17.7321 | 17.7232 | 17.7289 | 64260.0 |
| 2014-01-31 09:10:00 | AAPL | Stock | 17.7321 | 17.7407 | 17.7196 | 17.7196 | 131292.0 |
| 2014-01-31 09:15:00 | AAPL | Stock | 17.7268 | 17.7329 | 17.7257 | 17.7329 | 78848.0 |
| 2014-01-31 09:20:00 | AAPL | Stock | 17.7357 | 17.7407 | 17.7329 | 17.7407 | 136724.0 |
| 2014-01-31 09:25:00 | AAPL | Stock | 17.7411 | 17.7654 | 17.6786 | 17.6786 | 963592.0 |
> showing 50 of 365,949 rows — these rows as CSV