PREVIEW / stock_5min / 2013-09-13
file: by_date/stock_5min/2013/2013-09-13.parquet size: 5.0 MB rows: 335,389 symbols: 3,511
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 |
|---|---|---|---|---|---|---|---|
| 2013-09-13 04:00:00 | AAPL | Stock | 16.9286 | 16.9539 | 16.9286 | 16.9464 | 9800.0 |
| 2013-09-13 04:05:00 | AAPL | Stock | 16.9286 | 16.9286 | 16.9054 | 16.9054 | 8540.0 |
| 2013-09-13 04:10:00 | AAPL | Stock | 16.9286 | 16.9286 | 16.9286 | 16.9286 | 54460.0 |
| 2013-09-13 04:35:00 | AAPL | Stock | 16.9143 | 16.9143 | 16.8961 | 16.8961 | 21000.0 |
| 2013-09-13 05:10:00 | AAPL | Stock | 16.9039 | 16.9039 | 16.9039 | 16.9039 | 2800.0 |
| 2013-09-13 05:45:00 | AAPL | Stock | 16.9043 | 16.9043 | 16.9043 | 16.9043 | 2800.0 |
| 2013-09-13 06:00:00 | AAPL | Stock | 16.8839 | 16.8839 | 16.875 | 16.875 | 19740.0 |
| 2013-09-13 06:10:00 | AAPL | Stock | 16.8207 | 16.8214 | 16.8207 | 16.8214 | 58800.0 |
| 2013-09-13 06:20:00 | AAPL | Stock | 16.8179 | 16.8179 | 16.7857 | 16.7857 | 40320.0 |
| 2013-09-13 06:30:00 | AAPL | Stock | 16.7518 | 16.7575 | 16.7518 | 16.7575 | 68040.0 |
| 2013-09-13 06:35:00 | AAPL | Stock | 16.77 | 16.7796 | 16.7536 | 16.7796 | 36400.0 |
| 2013-09-13 06:40:00 | AAPL | Stock | 16.7857 | 16.7857 | 16.7857 | 16.7857 | 14000.0 |
| 2013-09-13 06:55:00 | AAPL | Stock | 16.7846 | 16.7857 | 16.7625 | 16.765 | 132440.0 |
| 2013-09-13 07:00:00 | AAPL | Stock | 16.765 | 16.7732 | 16.7518 | 16.7639 | 153216.0 |
| 2013-09-13 07:05:00 | AAPL | Stock | 16.7857 | 16.7964 | 16.7857 | 16.7964 | 34104.0 |
| 2013-09-13 07:10:00 | AAPL | Stock | 16.7964 | 16.8036 | 16.795 | 16.8004 | 11200.0 |
| 2013-09-13 07:20:00 | AAPL | Stock | 16.8089 | 16.8214 | 16.8089 | 16.8143 | 44940.0 |
| 2013-09-13 07:25:00 | AAPL | Stock | 16.8214 | 16.8214 | 16.7714 | 16.7714 | 135800.0 |
| 2013-09-13 07:30:00 | AAPL | Stock | 16.7857 | 16.7857 | 16.7771 | 16.7771 | 32284.0 |
| 2013-09-13 07:35:00 | AAPL | Stock | 16.7861 | 16.7957 | 16.7861 | 16.7861 | 17052.0 |
| 2013-09-13 07:40:00 | AAPL | Stock | 16.7893 | 16.8014 | 16.7893 | 16.7968 | 28000.0 |
| 2013-09-13 07:45:00 | AAPL | Stock | 16.8014 | 16.8014 | 16.7786 | 16.7836 | 70000.0 |
| 2013-09-13 07:55:00 | AAPL | Stock | 16.7879 | 16.7879 | 16.7786 | 16.7786 | 76188.0 |
| 2013-09-13 08:00:00 | AAPL | Stock | 16.7786 | 16.8179 | 16.7557 | 16.8125 | 426328.0 |
| 2013-09-13 08:05:00 | AAPL | Stock | 16.8071 | 16.8171 | 16.7957 | 16.8171 | 124460.0 |
| 2013-09-13 08:10:00 | AAPL | Stock | 16.8071 | 16.8357 | 16.8071 | 16.8164 | 197400.0 |
| 2013-09-13 08:15:00 | AAPL | Stock | 16.8254 | 16.8254 | 16.8089 | 16.8089 | 112280.0 |
| 2013-09-13 08:20:00 | AAPL | Stock | 16.8175 | 16.8179 | 16.7911 | 16.7964 | 181692.0 |
| 2013-09-13 08:25:00 | AAPL | Stock | 16.7911 | 16.7982 | 16.7721 | 16.7732 | 275772.0 |
| 2013-09-13 08:30:00 | AAPL | Stock | 16.7732 | 16.8018 | 16.7721 | 16.7857 | 281568.0 |
| 2013-09-13 08:35:00 | AAPL | Stock | 16.7911 | 16.7954 | 16.7843 | 16.7854 | 75600.0 |
| 2013-09-13 08:40:00 | AAPL | Stock | 16.7857 | 16.7857 | 16.7739 | 16.7857 | 152124.0 |
| 2013-09-13 08:45:00 | AAPL | Stock | 16.7875 | 16.7946 | 16.7854 | 16.7857 | 195076.0 |
| 2013-09-13 08:50:00 | AAPL | Stock | 16.7811 | 16.7854 | 16.7761 | 16.7761 | 126840.0 |
| 2013-09-13 08:55:00 | AAPL | Stock | 16.7768 | 16.7857 | 16.775 | 16.7786 | 253120.0 |
| 2013-09-13 09:00:00 | AAPL | Stock | 16.7786 | 16.7789 | 16.7679 | 16.7714 | 229320.0 |
| 2013-09-13 09:05:00 | AAPL | Stock | 16.7714 | 16.7732 | 16.7571 | 16.7614 | 332192.0 |
| 2013-09-13 09:10:00 | AAPL | Stock | 16.7607 | 16.7607 | 16.7496 | 16.7604 | 215208.0 |
| 2013-09-13 09:15:00 | AAPL | Stock | 16.7607 | 16.7679 | 16.7604 | 16.7618 | 76804.0 |
| 2013-09-13 09:20:00 | AAPL | Stock | 16.7668 | 16.7679 | 16.7614 | 16.7614 | 222824.0 |
| 2013-09-13 09:25:00 | AAPL | Stock | 16.7614 | 16.7861 | 16.7604 | 16.7854 | 621040.0 |
| 2013-09-13 09:30:00 | AAPL | Stock | 16.7779 | 16.851 | 16.7611 | 16.7789 | 14969052.0 |
| 2013-09-13 09:35:00 | AAPL | Stock | 16.7825 | 16.7857 | 16.725 | 16.7355 | 15927324.0 |
| 2013-09-13 09:40:00 | AAPL | Stock | 16.7321 | 16.7768 | 16.7232 | 16.7404 | 8394624.0 |
| 2013-09-13 09:45:00 | AAPL | Stock | 16.7389 | 16.7821 | 16.7296 | 16.7436 | 6944280.0 |
| 2013-09-13 09:50:00 | AAPL | Stock | 16.7479 | 16.7696 | 16.74 | 16.7582 | 3813236.0 |
| 2013-09-13 09:55:00 | AAPL | Stock | 16.7596 | 16.7639 | 16.7043 | 16.7043 | 8305192.0 |
| 2013-09-13 10:00:00 | AAPL | Stock | 16.705 | 16.7232 | 16.6882 | 16.7007 | 8397928.0 |
| 2013-09-13 10:05:00 | AAPL | Stock | 16.6979 | 16.7118 | 16.6586 | 16.6729 | 11209632.0 |
| 2013-09-13 10:10:00 | AAPL | Stock | 16.6707 | 16.7275 | 16.6689 | 16.71 | 6688668.0 |
> showing 50 of 335,389 rows — these rows as CSV