PREVIEW / stock_5min / 2014-01-15
file: by_date/stock_5min/2014/2014-01-15.parquet size: 5.5 MB rows: 358,078 symbols: 3,518
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-15 04:00:00 | AAPL | Stock | 19.5507 | 19.8036 | 19.5507 | 19.8036 | 14000.0 |
| 2014-01-15 04:05:00 | AAPL | Stock | 19.8071 | 19.8143 | 19.8071 | 19.8143 | 13440.0 |
| 2014-01-15 04:10:00 | AAPL | Stock | 19.8143 | 19.8143 | 19.7893 | 19.7893 | 25200.0 |
| 2014-01-15 04:15:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7857 | 19.7857 | 25900.0 |
| 2014-01-15 04:25:00 | AAPL | Stock | 19.7846 | 19.7875 | 19.7846 | 19.7875 | 11508.0 |
| 2014-01-15 04:35:00 | AAPL | Stock | 19.8096 | 19.8114 | 19.8096 | 19.8114 | 5600.0 |
| 2014-01-15 04:40:00 | AAPL | Stock | 19.8093 | 19.8093 | 19.8093 | 19.8093 | 2800.0 |
| 2014-01-15 04:45:00 | AAPL | Stock | 19.8071 | 19.8093 | 19.8071 | 19.8093 | 5600.0 |
| 2014-01-15 04:50:00 | AAPL | Stock | 19.805 | 19.805 | 19.7857 | 19.7857 | 35532.0 |
| 2014-01-15 04:55:00 | AAPL | Stock | 19.7857 | 19.7857 | 19.7818 | 19.7854 | 12600.0 |
| 2014-01-15 05:05:00 | AAPL | Stock | 19.7836 | 19.7836 | 19.7775 | 19.7775 | 25872.0 |
| 2014-01-15 05:15:00 | AAPL | Stock | 19.7732 | 19.7732 | 19.7732 | 19.7732 | 2800.0 |
| 2014-01-15 05:40:00 | AAPL | Stock | 19.7657 | 19.7657 | 19.7543 | 19.7543 | 5600.0 |
| 2014-01-15 05:45:00 | AAPL | Stock | 19.7539 | 19.7539 | 19.7504 | 19.7504 | 22456.0 |
| 2014-01-15 05:50:00 | AAPL | Stock | 19.7589 | 19.7589 | 19.7579 | 19.7579 | 11200.0 |
| 2014-01-15 05:55:00 | AAPL | Stock | 19.7654 | 19.7654 | 19.7654 | 19.7654 | 3304.0 |
| 2014-01-15 06:00:00 | AAPL | Stock | 19.7836 | 19.7839 | 19.7836 | 19.7839 | 11368.0 |
| 2014-01-15 06:05:00 | AAPL | Stock | 19.7679 | 19.7679 | 19.7357 | 19.7357 | 56840.0 |
| 2014-01-15 06:10:00 | AAPL | Stock | 19.7621 | 19.7621 | 19.7589 | 19.7589 | 5600.0 |
| 2014-01-15 06:15:00 | AAPL | Stock | 19.7475 | 19.7475 | 19.7146 | 19.7246 | 29736.0 |
| 2014-01-15 06:20:00 | AAPL | Stock | 19.7143 | 19.725 | 19.7143 | 19.725 | 18312.0 |
| 2014-01-15 06:25:00 | AAPL | Stock | 19.725 | 19.735 | 19.725 | 19.7321 | 19600.0 |
| 2014-01-15 06:30:00 | AAPL | Stock | 19.7411 | 19.7411 | 19.7411 | 19.7411 | 2800.0 |
| 2014-01-15 06:35:00 | AAPL | Stock | 19.7321 | 19.7321 | 19.7268 | 19.7268 | 22400.0 |
| 2014-01-15 06:40:00 | AAPL | Stock | 19.7321 | 19.7429 | 19.7321 | 19.7429 | 12600.0 |
| 2014-01-15 06:45:00 | AAPL | Stock | 19.7429 | 19.7429 | 19.7143 | 19.7207 | 39396.0 |
| 2014-01-15 06:50:00 | AAPL | Stock | 19.7207 | 19.7207 | 19.7207 | 19.7207 | 2800.0 |
| 2014-01-15 06:55:00 | AAPL | Stock | 19.7143 | 19.7375 | 19.7143 | 19.7375 | 19320.0 |
| 2014-01-15 07:00:00 | AAPL | Stock | 19.7411 | 19.7604 | 19.7314 | 19.7604 | 79184.0 |
| 2014-01-15 07:05:00 | AAPL | Stock | 19.7854 | 19.7854 | 19.7561 | 19.7561 | 104160.0 |
| 2014-01-15 07:10:00 | AAPL | Stock | 19.7561 | 19.7696 | 19.75 | 19.75 | 98840.0 |
| 2014-01-15 07:15:00 | AAPL | Stock | 19.75 | 19.7525 | 19.7421 | 19.7525 | 35840.0 |
| 2014-01-15 07:20:00 | AAPL | Stock | 19.7643 | 19.8025 | 19.7643 | 19.8025 | 220836.0 |
| 2014-01-15 07:25:00 | AAPL | Stock | 19.7996 | 19.8071 | 19.7882 | 19.8071 | 130844.0 |
| 2014-01-15 07:30:00 | AAPL | Stock | 19.7961 | 19.8571 | 19.7918 | 19.8571 | 268100.0 |
| 2014-01-15 07:35:00 | AAPL | Stock | 19.8643 | 19.875 | 19.835 | 19.8582 | 367220.0 |
| 2014-01-15 07:40:00 | AAPL | Stock | 19.8661 | 19.8839 | 19.8589 | 19.8696 | 300524.0 |
| 2014-01-15 07:45:00 | AAPL | Stock | 19.8732 | 19.875 | 19.8286 | 19.8314 | 151424.0 |
| 2014-01-15 07:50:00 | AAPL | Stock | 19.8339 | 19.84 | 19.8214 | 19.8214 | 176624.0 |
| 2014-01-15 07:55:00 | AAPL | Stock | 19.8229 | 19.8229 | 19.8054 | 19.8218 | 113036.0 |
| 2014-01-15 08:00:00 | AAPL | Stock | 19.8214 | 19.875 | 19.7393 | 19.8125 | 890204.0 |
| 2014-01-15 08:05:00 | AAPL | Stock | 19.8136 | 19.8357 | 19.8125 | 19.8229 | 476896.0 |
| 2014-01-15 08:10:00 | AAPL | Stock | 19.8264 | 19.8264 | 19.8014 | 19.8036 | 363216.0 |
| 2014-01-15 08:15:00 | AAPL | Stock | 19.8036 | 19.8214 | 19.8036 | 19.8214 | 257992.0 |
| 2014-01-15 08:20:00 | AAPL | Stock | 19.8214 | 19.8214 | 19.7939 | 19.8036 | 250208.0 |
| 2014-01-15 08:25:00 | AAPL | Stock | 19.8039 | 19.8171 | 19.7968 | 19.8171 | 132692.0 |
| 2014-01-15 08:30:00 | AAPL | Stock | 19.8071 | 19.8157 | 19.8071 | 19.8089 | 113092.0 |
| 2014-01-15 08:35:00 | AAPL | Stock | 19.8093 | 19.8125 | 19.79 | 19.7954 | 213444.0 |
| 2014-01-15 08:40:00 | AAPL | Stock | 19.7896 | 19.7928 | 19.7711 | 19.7743 | 312004.0 |
| 2014-01-15 08:45:00 | AAPL | Stock | 19.7732 | 19.7904 | 19.7682 | 19.7796 | 369740.0 |
> showing 50 of 358,078 rows — these rows as CSV