PREVIEW / stock_5min / 2012-10-24
file: by_date/stock_5min/2012/2012-10-24.parquet size: 4.6 MB rows: 309,534 symbols: 3,462
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 |
|---|---|---|---|---|---|---|---|
| 2012-10-24 04:40:00 | AAPL | Stock | 21.9732 | 21.9732 | 21.9732 | 21.9732 | 2800.0 |
| 2012-10-24 04:45:00 | AAPL | Stock | 22.0536 | 22.0536 | 22.04 | 22.04 | 8400.0 |
| 2012-10-24 06:00:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 06:05:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 06:10:00 | AAPL | Stock | 22.0286 | 22.0286 | 22.0286 | 22.0286 | 2800.0 |
| 2012-10-24 06:25:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 8400.0 |
| 2012-10-24 06:30:00 | AAPL | Stock | 22.0357 | 22.0379 | 22.0357 | 22.0379 | 8400.0 |
| 2012-10-24 07:00:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 9436.0 |
| 2012-10-24 07:05:00 | AAPL | Stock | 22.0643 | 22.0857 | 22.0643 | 22.0857 | 23296.0 |
| 2012-10-24 07:10:00 | AAPL | Stock | 22.0575 | 22.0718 | 22.0468 | 22.0711 | 77588.0 |
| 2012-10-24 07:20:00 | AAPL | Stock | 22.0364 | 22.0446 | 22.0357 | 22.0357 | 27496.0 |
| 2012-10-24 07:25:00 | AAPL | Stock | 22.0357 | 22.0357 | 22.0357 | 22.0357 | 2800.0 |
| 2012-10-24 07:30:00 | AAPL | Stock | 22.0375 | 22.0586 | 21.9686 | 21.9818 | 233828.0 |
| 2012-10-24 07:35:00 | AAPL | Stock | 21.9696 | 22.0064 | 21.9507 | 21.9957 | 139020.0 |
| 2012-10-24 07:40:00 | AAPL | Stock | 21.9825 | 21.9825 | 21.9557 | 21.9589 | 97328.0 |
| 2012-10-24 07:45:00 | AAPL | Stock | 21.9554 | 21.9739 | 21.9464 | 21.9739 | 27552.0 |
| 2012-10-24 07:50:00 | AAPL | Stock | 21.975 | 22.0082 | 21.9729 | 22.0082 | 69048.0 |
| 2012-10-24 07:55:00 | AAPL | Stock | 22.0086 | 22.0189 | 22.0086 | 22.0189 | 72716.0 |
| 2012-10-24 08:00:00 | AAPL | Stock | 22.0189 | 22.0786 | 21.9536 | 22.0671 | 487452.0 |
| 2012-10-24 08:05:00 | AAPL | Stock | 22.0711 | 22.0714 | 22.0375 | 22.0714 | 352660.0 |
| 2012-10-24 08:10:00 | AAPL | Stock | 22.0714 | 22.0864 | 22.0661 | 22.0714 | 203728.0 |
| 2012-10-24 08:15:00 | AAPL | Stock | 22.0768 | 22.0918 | 22.0757 | 22.0811 | 171808.0 |
| 2012-10-24 08:20:00 | AAPL | Stock | 22.0889 | 22.0911 | 22.0518 | 22.0714 | 133644.0 |
| 2012-10-24 08:25:00 | AAPL | Stock | 22.0739 | 22.0982 | 22.0557 | 22.0964 | 203252.0 |
| 2012-10-24 08:30:00 | AAPL | Stock | 22.0982 | 22.0982 | 22.0243 | 22.0804 | 78456.0 |
| 2012-10-24 08:35:00 | AAPL | Stock | 22.0736 | 22.0821 | 22.0625 | 22.0625 | 293804.0 |
| 2012-10-24 08:40:00 | AAPL | Stock | 22.0571 | 22.0618 | 22.0379 | 22.0468 | 249340.0 |
| 2012-10-24 08:45:00 | AAPL | Stock | 22.0529 | 22.0689 | 22.0482 | 22.0625 | 139020.0 |
| 2012-10-24 08:50:00 | AAPL | Stock | 22.065 | 22.0718 | 22.0636 | 22.0682 | 75600.0 |
| 2012-10-24 08:55:00 | AAPL | Stock | 22.0714 | 22.0804 | 22.0539 | 22.0539 | 300300.0 |
| 2012-10-24 09:00:00 | AAPL | Stock | 22.0575 | 22.0711 | 22.0536 | 22.0711 | 148624.0 |
| 2012-10-24 09:05:00 | AAPL | Stock | 22.0696 | 22.0793 | 22.0696 | 22.0793 | 112672.0 |
| 2012-10-24 09:10:00 | AAPL | Stock | 22.0743 | 22.095 | 22.0743 | 22.095 | 126140.0 |
| 2012-10-24 09:15:00 | AAPL | Stock | 22.095 | 22.0961 | 22.085 | 22.0893 | 141792.0 |
| 2012-10-24 09:20:00 | AAPL | Stock | 22.0907 | 22.0979 | 22.0893 | 22.0946 | 213360.0 |
| 2012-10-24 09:25:00 | AAPL | Stock | 22.0975 | 22.2143 | 22.09 | 22.1886 | 2044784.0 |
| 2012-10-24 09:30:00 | AAPL | Stock | 22.1964 | 22.3214 | 22.1436 | 22.2853 | 41259344.0 |
| 2012-10-24 09:35:00 | AAPL | Stock | 22.2814 | 22.3768 | 22.2418 | 22.3025 | 17906644.0 |
| 2012-10-24 09:40:00 | AAPL | Stock | 22.3029 | 22.3489 | 22.2429 | 22.26 | 11729060.0 |
| 2012-10-24 09:45:00 | AAPL | Stock | 22.26 | 22.2721 | 22.1882 | 22.2281 | 10139976.0 |
| 2012-10-24 09:50:00 | AAPL | Stock | 22.2236 | 22.2611 | 22.2104 | 22.2118 | 6748392.0 |
| 2012-10-24 09:55:00 | AAPL | Stock | 22.2136 | 22.3382 | 22.2093 | 22.3157 | 9923704.0 |
| 2012-10-24 10:00:00 | AAPL | Stock | 22.3096 | 22.3207 | 22.2061 | 22.2368 | 7214424.0 |
| 2012-10-24 10:05:00 | AAPL | Stock | 22.2325 | 22.2636 | 22.1929 | 22.2132 | 6031928.0 |
| 2012-10-24 10:10:00 | AAPL | Stock | 22.2131 | 22.2321 | 22.1518 | 22.1725 | 9425920.0 |
| 2012-10-24 10:15:00 | AAPL | Stock | 22.172 | 22.1925 | 22.1014 | 22.1039 | 11164608.0 |
| 2012-10-24 10:20:00 | AAPL | Stock | 22.1007 | 22.1396 | 22.0289 | 22.0554 | 12351472.0 |
| 2012-10-24 10:25:00 | AAPL | Stock | 22.0532 | 22.0993 | 22.0295 | 22.0443 | 7836080.0 |
| 2012-10-24 10:30:00 | AAPL | Stock | 22.0432 | 22.0593 | 21.9893 | 22.0286 | 10675476.0 |
| 2012-10-24 10:35:00 | AAPL | Stock | 22.0225 | 22.0561 | 21.9975 | 22.0161 | 8443820.0 |
> showing 50 of 309,534 rows — these rows as CSV