PREVIEW / stock_5min / 2014-01-30
file: by_date/stock_5min/2014/2014-01-30.parquet size: 5.5 MB rows: 362,158 symbols: 3,526
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-30 04:00:00 | AAPL | Stock | 17.8232 | 17.8232 | 17.8232 | 17.8232 | 5600.0 |
| 2014-01-30 04:20:00 | AAPL | Stock | 17.8289 | 17.8289 | 17.8289 | 17.8289 | 2800.0 |
| 2014-01-30 04:40:00 | AAPL | Stock | 17.8346 | 17.8346 | 17.8214 | 17.8214 | 16072.0 |
| 2014-01-30 04:45:00 | AAPL | Stock | 17.8196 | 17.8196 | 17.8196 | 17.8196 | 5600.0 |
| 2014-01-30 04:55:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7857 | 17.7857 | 8400.0 |
| 2014-01-30 05:00:00 | AAPL | Stock | 17.7893 | 17.7893 | 17.7893 | 17.7893 | 2800.0 |
| 2014-01-30 05:05:00 | AAPL | Stock | 17.7864 | 17.7864 | 17.7864 | 17.7864 | 2800.0 |
| 2014-01-30 05:10:00 | AAPL | Stock | 17.7857 | 17.7857 | 17.7857 | 17.7857 | 14672.0 |
| 2014-01-30 05:25:00 | AAPL | Stock | 17.7764 | 17.7993 | 17.7764 | 17.7886 | 33208.0 |
| 2014-01-30 05:30:00 | AAPL | Stock | 17.7989 | 17.8257 | 17.7989 | 17.8257 | 30940.0 |
| 2014-01-30 05:35:00 | AAPL | Stock | 17.8282 | 17.8282 | 17.8282 | 17.8282 | 7476.0 |
| 2014-01-30 06:10:00 | AAPL | Stock | 17.8164 | 17.8164 | 17.8164 | 17.8164 | 7000.0 |
| 2014-01-30 06:15:00 | AAPL | Stock | 17.8036 | 17.83 | 17.8036 | 17.83 | 14000.0 |
| 2014-01-30 06:20:00 | AAPL | Stock | 17.8343 | 17.835 | 17.8343 | 17.835 | 9352.0 |
| 2014-01-30 06:25:00 | AAPL | Stock | 17.8493 | 17.8496 | 17.8214 | 17.8214 | 8960.0 |
| 2014-01-30 06:30:00 | AAPL | Stock | 17.8543 | 17.8543 | 17.8543 | 17.8543 | 5600.0 |
| 2014-01-30 06:40:00 | AAPL | Stock | 17.8714 | 17.8714 | 17.8714 | 17.8714 | 5600.0 |
| 2014-01-30 06:50:00 | AAPL | Stock | 17.8571 | 17.8607 | 17.8571 | 17.8607 | 17696.0 |
| 2014-01-30 06:55:00 | AAPL | Stock | 17.8839 | 17.8839 | 17.8839 | 17.8839 | 2800.0 |
| 2014-01-30 07:00:00 | AAPL | Stock | 17.8857 | 17.8857 | 17.8857 | 17.8857 | 2800.0 |
| 2014-01-30 07:05:00 | AAPL | Stock | 17.8911 | 17.8932 | 17.8911 | 17.8932 | 15400.0 |
| 2014-01-30 07:10:00 | AAPL | Stock | 17.9 | 17.9096 | 17.9 | 17.9054 | 24080.0 |
| 2014-01-30 07:15:00 | AAPL | Stock | 17.9096 | 17.9125 | 17.9036 | 17.9036 | 24836.0 |
| 2014-01-30 07:20:00 | AAPL | Stock | 17.9082 | 17.9121 | 17.8929 | 17.8929 | 77700.0 |
| 2014-01-30 07:25:00 | AAPL | Stock | 17.9107 | 17.9229 | 17.8929 | 17.8929 | 107940.0 |
| 2014-01-30 07:35:00 | AAPL | Stock | 17.8968 | 17.91 | 17.8968 | 17.9089 | 71260.0 |
| 2014-01-30 07:40:00 | AAPL | Stock | 17.8929 | 17.8939 | 17.8929 | 17.8939 | 11200.0 |
| 2014-01-30 07:45:00 | AAPL | Stock | 17.9071 | 17.9071 | 17.8857 | 17.8929 | 28000.0 |
| 2014-01-30 07:50:00 | AAPL | Stock | 17.8857 | 17.8857 | 17.8625 | 17.8857 | 27160.0 |
| 2014-01-30 07:55:00 | AAPL | Stock | 17.875 | 17.8818 | 17.875 | 17.8818 | 28000.0 |
| 2014-01-30 08:00:00 | AAPL | Stock | 17.9096 | 17.9096 | 17.875 | 17.875 | 192584.0 |
| 2014-01-30 08:05:00 | AAPL | Stock | 17.875 | 17.8893 | 17.8579 | 17.8711 | 365092.0 |
| 2014-01-30 08:10:00 | AAPL | Stock | 17.8714 | 17.8714 | 17.7893 | 17.8171 | 360080.0 |
| 2014-01-30 08:15:00 | AAPL | Stock | 17.8171 | 17.8236 | 17.7893 | 17.8214 | 494424.0 |
| 2014-01-30 08:20:00 | AAPL | Stock | 17.8214 | 17.8393 | 17.8075 | 17.8075 | 113400.0 |
| 2014-01-30 08:25:00 | AAPL | Stock | 17.8061 | 17.8125 | 17.7946 | 17.8036 | 275044.0 |
| 2014-01-30 08:30:00 | AAPL | Stock | 17.7954 | 17.8264 | 17.7918 | 17.8221 | 306544.0 |
| 2014-01-30 08:35:00 | AAPL | Stock | 17.8271 | 17.8393 | 17.8218 | 17.8339 | 219940.0 |
| 2014-01-30 08:40:00 | AAPL | Stock | 17.8357 | 17.8489 | 17.8311 | 17.8314 | 163660.0 |
| 2014-01-30 08:45:00 | AAPL | Stock | 17.8346 | 17.8464 | 17.8239 | 17.8429 | 260064.0 |
| 2014-01-30 08:50:00 | AAPL | Stock | 17.8425 | 17.8643 | 17.8393 | 17.8393 | 453880.0 |
| 2014-01-30 08:55:00 | AAPL | Stock | 17.8346 | 17.8479 | 17.8321 | 17.8479 | 143808.0 |
| 2014-01-30 09:00:00 | AAPL | Stock | 17.8439 | 17.8479 | 17.8318 | 17.8461 | 368032.0 |
| 2014-01-30 09:05:00 | AAPL | Stock | 17.8429 | 17.8714 | 17.8429 | 17.8711 | 433048.0 |
| 2014-01-30 09:10:00 | AAPL | Stock | 17.8746 | 17.925 | 17.8746 | 17.925 | 358288.0 |
| 2014-01-30 09:15:00 | AAPL | Stock | 17.9282 | 17.9464 | 17.9143 | 17.9207 | 763420.0 |
| 2014-01-30 09:20:00 | AAPL | Stock | 17.9282 | 17.9643 | 17.9214 | 17.9632 | 373520.0 |
| 2014-01-30 09:25:00 | AAPL | Stock | 17.96 | 17.9786 | 17.9325 | 17.9325 | 334880.0 |
| 2014-01-30 09:30:00 | AAPL | Stock | 17.9479 | 17.9854 | 17.9107 | 17.9689 | 21378532.0 |
| 2014-01-30 09:35:00 | AAPL | Stock | 17.9705 | 18.05 | 17.9411 | 18.0418 | 19147912.0 |
> showing 50 of 362,158 rows — these rows as CSV