PREVIEW / stock_5min / 2014-03-18
file: by_date/stock_5min/2014/2014-03-18.parquet size: 5.5 MB rows: 367,375 symbols: 3,560
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-03-18 04:25:00 | AAPL | Stock | 18.8054 | 18.8054 | 18.8032 | 18.8032 | 5600.0 |
| 2014-03-18 04:30:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7857 | 18.7857 | 2800.0 |
| 2014-03-18 05:30:00 | AAPL | Stock | 18.765 | 18.765 | 18.7332 | 18.7332 | 8400.0 |
| 2014-03-18 05:35:00 | AAPL | Stock | 18.7293 | 18.7293 | 18.7293 | 18.7293 | 2800.0 |
| 2014-03-18 05:55:00 | AAPL | Stock | 18.7671 | 18.7671 | 18.7671 | 18.7671 | 2800.0 |
| 2014-03-18 06:05:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7714 | 18.7714 | 2800.0 |
| 2014-03-18 06:35:00 | AAPL | Stock | 18.7732 | 18.7732 | 18.7732 | 18.7732 | 11452.0 |
| 2014-03-18 07:35:00 | AAPL | Stock | 18.8143 | 18.8143 | 18.8143 | 18.8143 | 2800.0 |
| 2014-03-18 07:40:00 | AAPL | Stock | 18.825 | 18.85 | 18.8214 | 18.85 | 22400.0 |
| 2014-03-18 07:45:00 | AAPL | Stock | 18.8607 | 18.8607 | 18.8607 | 18.8607 | 8400.0 |
| 2014-03-18 07:50:00 | AAPL | Stock | 18.8696 | 18.8929 | 18.8696 | 18.8821 | 47208.0 |
| 2014-03-18 07:55:00 | AAPL | Stock | 18.8807 | 18.8821 | 18.8396 | 18.8396 | 76720.0 |
| 2014-03-18 08:00:00 | AAPL | Stock | 18.8454 | 18.8675 | 18.7593 | 18.8236 | 116704.0 |
| 2014-03-18 08:05:00 | AAPL | Stock | 18.8393 | 18.8564 | 18.8339 | 18.8339 | 19712.0 |
| 2014-03-18 08:10:00 | AAPL | Stock | 18.8432 | 18.8557 | 18.8393 | 18.8407 | 22400.0 |
| 2014-03-18 08:15:00 | AAPL | Stock | 18.8461 | 18.8464 | 18.84 | 18.8464 | 8400.0 |
| 2014-03-18 08:20:00 | AAPL | Stock | 18.8393 | 18.8425 | 18.8393 | 18.8425 | 5600.0 |
| 2014-03-18 08:25:00 | AAPL | Stock | 18.8332 | 18.84 | 18.8236 | 18.84 | 50008.0 |
| 2014-03-18 08:30:00 | AAPL | Stock | 18.8393 | 18.8929 | 18.8371 | 18.855 | 242060.0 |
| 2014-03-18 08:35:00 | AAPL | Stock | 18.8567 | 18.8567 | 18.8396 | 18.8396 | 68600.0 |
| 2014-03-18 08:40:00 | AAPL | Stock | 18.8464 | 18.8486 | 18.8443 | 18.8486 | 16772.0 |
| 2014-03-18 08:45:00 | AAPL | Stock | 18.8486 | 18.8571 | 18.8486 | 18.8536 | 136472.0 |
| 2014-03-18 08:50:00 | AAPL | Stock | 18.8518 | 18.8786 | 18.8518 | 18.8682 | 144256.0 |
| 2014-03-18 08:55:00 | AAPL | Stock | 18.8686 | 18.875 | 18.8593 | 18.8593 | 262388.0 |
| 2014-03-18 09:00:00 | AAPL | Stock | 18.8593 | 18.8593 | 18.8446 | 18.8446 | 96404.0 |
| 2014-03-18 09:05:00 | AAPL | Stock | 18.8461 | 18.8461 | 18.8446 | 18.8446 | 14000.0 |
| 2014-03-18 09:10:00 | AAPL | Stock | 18.8121 | 18.8482 | 18.8121 | 18.845 | 3171252.0 |
| 2014-03-18 09:15:00 | AAPL | Stock | 18.8443 | 18.8443 | 18.8125 | 18.8125 | 44800.0 |
| 2014-03-18 09:20:00 | AAPL | Stock | 18.82 | 18.82 | 18.8096 | 18.8096 | 49420.0 |
| 2014-03-18 09:25:00 | AAPL | Stock | 18.8096 | 18.8096 | 18.7696 | 18.7779 | 245364.0 |
| 2014-03-18 09:30:00 | AAPL | Stock | 18.7832 | 18.8414 | 18.7571 | 18.8093 | 9346204.0 |
| 2014-03-18 09:35:00 | AAPL | Stock | 18.809 | 18.8571 | 18.7857 | 18.84 | 3997868.0 |
| 2014-03-18 09:40:00 | AAPL | Stock | 18.8393 | 18.8436 | 18.7929 | 18.7982 | 2750804.0 |
| 2014-03-18 09:45:00 | AAPL | Stock | 18.7993 | 18.8347 | 18.7761 | 18.8214 | 2939132.0 |
| 2014-03-18 09:50:00 | AAPL | Stock | 18.8214 | 18.9071 | 18.805 | 18.8846 | 4721892.0 |
| 2014-03-18 09:55:00 | AAPL | Stock | 18.8878 | 18.8878 | 18.8611 | 18.8752 | 2791460.0 |
| 2014-03-18 10:00:00 | AAPL | Stock | 18.8754 | 18.8975 | 18.8629 | 18.8675 | 2784404.0 |
| 2014-03-18 10:05:00 | AAPL | Stock | 18.8679 | 18.8754 | 18.8579 | 18.8754 | 1112132.0 |
| 2014-03-18 10:10:00 | AAPL | Stock | 18.8779 | 18.8779 | 18.8582 | 18.8693 | 1446508.0 |
| 2014-03-18 10:15:00 | AAPL | Stock | 18.8716 | 18.8768 | 18.8604 | 18.875 | 1772120.0 |
| 2014-03-18 10:20:00 | AAPL | Stock | 18.8754 | 18.8879 | 18.8611 | 18.8879 | 2158436.0 |
| 2014-03-18 10:25:00 | AAPL | Stock | 18.8879 | 18.8996 | 18.88 | 18.8861 | 2138416.0 |
| 2014-03-18 10:30:00 | AAPL | Stock | 18.8815 | 18.8979 | 18.8815 | 18.8879 | 1186332.0 |
| 2014-03-18 10:35:00 | AAPL | Stock | 18.8871 | 18.8929 | 18.8764 | 18.8879 | 1454460.0 |
| 2014-03-18 10:40:00 | AAPL | Stock | 18.8907 | 18.9032 | 18.8821 | 18.9007 | 1727796.0 |
| 2014-03-18 10:45:00 | AAPL | Stock | 18.9025 | 18.9032 | 18.8864 | 18.8936 | 1417024.0 |
| 2014-03-18 10:50:00 | AAPL | Stock | 18.8943 | 18.9021 | 18.8864 | 18.8943 | 1375164.0 |
| 2014-03-18 10:55:00 | AAPL | Stock | 18.8925 | 18.8952 | 18.8482 | 18.8576 | 2993060.0 |
| 2014-03-18 11:00:00 | AAPL | Stock | 18.8598 | 18.8843 | 18.8546 | 18.8807 | 1133832.0 |
| 2014-03-18 11:05:00 | AAPL | Stock | 18.8771 | 18.8911 | 18.8768 | 18.8829 | 968772.0 |
> showing 50 of 367,375 rows — these rows as CSV