PREVIEW / stock_5min / 2011-04-21
file: by_date/stock_5min/2011/2011-04-21.parquet size: 4.7 MB rows: 322,015 symbols: 3,533
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 |
|---|---|---|---|---|---|---|---|
| 2011-04-21 04:00:00 | AAPL | Stock | 12.6964 | 12.7436 | 12.6964 | 12.7296 | 11200.0 |
| 2011-04-21 04:05:00 | AAPL | Stock | 12.7561 | 12.7561 | 12.7214 | 12.7214 | 46200.0 |
| 2011-04-21 04:15:00 | AAPL | Stock | 12.7257 | 12.7257 | 12.7257 | 12.7257 | 2800.0 |
| 2011-04-21 04:20:00 | AAPL | Stock | 12.7254 | 12.7254 | 12.7239 | 12.7239 | 5600.0 |
| 2011-04-21 04:25:00 | AAPL | Stock | 12.7025 | 12.7296 | 12.7025 | 12.7296 | 8400.0 |
| 2011-04-21 04:30:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 2800.0 |
| 2011-04-21 04:35:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7143 | 12.7143 | 5600.0 |
| 2011-04-21 04:40:00 | AAPL | Stock | 12.7293 | 12.7293 | 12.7143 | 12.725 | 14000.0 |
| 2011-04-21 04:45:00 | AAPL | Stock | 12.725 | 12.725 | 12.725 | 12.725 | 9520.0 |
| 2011-04-21 04:50:00 | AAPL | Stock | 12.7282 | 12.7282 | 12.7282 | 12.7282 | 2800.0 |
| 2011-04-21 04:55:00 | AAPL | Stock | 12.7282 | 12.7282 | 12.7282 | 12.7282 | 8400.0 |
| 2011-04-21 05:00:00 | AAPL | Stock | 12.7268 | 12.7268 | 12.7268 | 12.7268 | 14000.0 |
| 2011-04-21 05:05:00 | AAPL | Stock | 12.7268 | 12.7268 | 12.7268 | 12.7268 | 2800.0 |
| 2011-04-21 05:10:00 | AAPL | Stock | 12.7296 | 12.73 | 12.7296 | 12.73 | 8400.0 |
| 2011-04-21 05:15:00 | AAPL | Stock | 12.7179 | 12.73 | 12.7179 | 12.73 | 5600.0 |
| 2011-04-21 05:20:00 | AAPL | Stock | 12.7157 | 12.7321 | 12.715 | 12.7321 | 25200.0 |
| 2011-04-21 05:25:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7321 | 12.7321 | 14000.0 |
| 2011-04-21 05:30:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7321 | 12.7321 | 2800.0 |
| 2011-04-21 05:35:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7321 | 12.7321 | 11200.0 |
| 2011-04-21 05:40:00 | AAPL | Stock | 12.74 | 12.74 | 12.74 | 12.74 | 12600.0 |
| 2011-04-21 05:45:00 | AAPL | Stock | 12.7329 | 12.7329 | 12.7236 | 12.7325 | 11200.0 |
| 2011-04-21 05:50:00 | AAPL | Stock | 12.7236 | 12.7321 | 12.7236 | 12.7321 | 11200.0 |
| 2011-04-21 05:55:00 | AAPL | Stock | 12.7321 | 12.7329 | 12.7321 | 12.7329 | 11200.0 |
| 2011-04-21 06:00:00 | AAPL | Stock | 12.7236 | 12.7236 | 12.7236 | 12.7236 | 2800.0 |
| 2011-04-21 06:10:00 | AAPL | Stock | 12.7321 | 12.7321 | 12.7318 | 12.7318 | 5600.0 |
| 2011-04-21 06:15:00 | AAPL | Stock | 12.73 | 12.73 | 12.73 | 12.73 | 11200.0 |
| 2011-04-21 06:20:00 | AAPL | Stock | 12.73 | 12.7329 | 12.7296 | 12.73 | 143500.0 |
| 2011-04-21 06:25:00 | AAPL | Stock | 12.7293 | 12.7293 | 12.715 | 12.7268 | 40600.0 |
| 2011-04-21 06:30:00 | AAPL | Stock | 12.7268 | 12.7268 | 12.7179 | 12.7179 | 30800.0 |
| 2011-04-21 06:35:00 | AAPL | Stock | 12.7146 | 12.7146 | 12.7146 | 12.7146 | 2800.0 |
| 2011-04-21 06:40:00 | AAPL | Stock | 12.7111 | 12.7111 | 12.7107 | 12.7107 | 5600.0 |
| 2011-04-21 06:45:00 | AAPL | Stock | 12.7143 | 12.7143 | 12.7071 | 12.7071 | 86100.0 |
| 2011-04-21 06:50:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.7139 | 12.7139 | 13300.0 |
| 2011-04-21 06:55:00 | AAPL | Stock | 12.7079 | 12.7079 | 12.7 | 12.7 | 7000.0 |
| 2011-04-21 07:00:00 | AAPL | Stock | 12.7139 | 12.7139 | 12.6904 | 12.7068 | 202720.0 |
| 2011-04-21 07:05:00 | AAPL | Stock | 12.7 | 12.7329 | 12.7 | 12.7286 | 192836.0 |
| 2011-04-21 07:10:00 | AAPL | Stock | 12.7329 | 12.7329 | 12.7232 | 12.7286 | 21840.0 |
| 2011-04-21 07:15:00 | AAPL | Stock | 12.7196 | 12.7207 | 12.7143 | 12.7143 | 81732.0 |
| 2011-04-21 07:20:00 | AAPL | Stock | 12.7146 | 12.7536 | 12.7143 | 12.75 | 653772.0 |
| 2011-04-21 07:25:00 | AAPL | Stock | 12.7571 | 12.8154 | 12.7536 | 12.7854 | 848008.0 |
| 2011-04-21 07:30:00 | AAPL | Stock | 12.7854 | 12.8014 | 12.7629 | 12.7857 | 702352.0 |
| 2011-04-21 07:35:00 | AAPL | Stock | 12.7864 | 12.81 | 12.7857 | 12.81 | 419524.0 |
| 2011-04-21 07:40:00 | AAPL | Stock | 12.8036 | 12.8286 | 12.8036 | 12.8286 | 630868.0 |
| 2011-04-21 07:45:00 | AAPL | Stock | 12.8214 | 12.8393 | 12.8214 | 12.8393 | 304248.0 |
| 2011-04-21 07:50:00 | AAPL | Stock | 12.8386 | 12.8418 | 12.8129 | 12.8329 | 705040.0 |
| 2011-04-21 07:55:00 | AAPL | Stock | 12.8321 | 12.8893 | 12.8321 | 12.8846 | 1154860.0 |
| 2011-04-21 08:00:00 | AAPL | Stock | 12.8768 | 12.8875 | 12.8118 | 12.8464 | 3030160.0 |
| 2011-04-21 08:05:00 | AAPL | Stock | 12.85 | 12.8536 | 12.8207 | 12.8318 | 930244.0 |
| 2011-04-21 08:10:00 | AAPL | Stock | 12.8293 | 12.8318 | 12.7918 | 12.7986 | 1655752.0 |
| 2011-04-21 08:15:00 | AAPL | Stock | 12.7968 | 12.8054 | 12.7732 | 12.7818 | 924056.0 |
> showing 50 of 322,015 rows — these rows as CSV