PREVIEW / stock_5min / 2012-05-18
file: by_date/stock_5min/2012/2012-05-18.parquet size: 5.0 MB rows: 337,276 symbols: 3,514
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-05-18 04:00:00 | AAPL | Stock | 18.9404 | 18.9404 | 18.885 | 18.885 | 5600.0 |
| 2012-05-18 04:05:00 | AAPL | Stock | 18.85 | 18.8571 | 18.85 | 18.8571 | 16968.0 |
| 2012-05-18 04:20:00 | AAPL | Stock | 18.8571 | 18.8571 | 18.8571 | 18.8571 | 2800.0 |
| 2012-05-18 04:25:00 | AAPL | Stock | 18.8875 | 18.8875 | 18.8875 | 18.8875 | 8400.0 |
| 2012-05-18 04:35:00 | AAPL | Stock | 18.8857 | 18.8857 | 18.8857 | 18.8857 | 68152.0 |
| 2012-05-18 04:50:00 | AAPL | Stock | 18.8618 | 18.8618 | 18.8618 | 18.8618 | 2800.0 |
| 2012-05-18 05:00:00 | AAPL | Stock | 18.8632 | 18.8679 | 18.8571 | 18.8664 | 39732.0 |
| 2012-05-18 05:05:00 | AAPL | Stock | 18.8643 | 18.8643 | 18.8571 | 18.8571 | 25200.0 |
| 2012-05-18 05:35:00 | AAPL | Stock | 18.8571 | 18.8746 | 18.8571 | 18.8746 | 39200.0 |
| 2012-05-18 05:40:00 | AAPL | Stock | 18.875 | 18.875 | 18.8696 | 18.8696 | 8400.0 |
| 2012-05-18 05:45:00 | AAPL | Stock | 18.875 | 18.8929 | 18.875 | 18.8929 | 36400.0 |
| 2012-05-18 05:50:00 | AAPL | Stock | 18.9 | 18.9136 | 18.9 | 18.9136 | 12712.0 |
| 2012-05-18 05:55:00 | AAPL | Stock | 18.9136 | 18.9429 | 18.9136 | 18.9321 | 77728.0 |
| 2012-05-18 06:00:00 | AAPL | Stock | 18.9321 | 18.9643 | 18.9321 | 18.9643 | 18900.0 |
| 2012-05-18 06:05:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2012-05-18 06:10:00 | AAPL | Stock | 18.9339 | 18.9339 | 18.9339 | 18.9339 | 11200.0 |
| 2012-05-18 06:15:00 | AAPL | Stock | 18.9339 | 18.9564 | 18.9339 | 18.9564 | 21000.0 |
| 2012-05-18 06:25:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 22400.0 |
| 2012-05-18 06:30:00 | AAPL | Stock | 18.9754 | 18.9757 | 18.9754 | 18.9757 | 8400.0 |
| 2012-05-18 06:40:00 | AAPL | Stock | 18.9643 | 18.9643 | 18.9643 | 18.9643 | 2800.0 |
| 2012-05-18 06:45:00 | AAPL | Stock | 18.9775 | 18.9821 | 18.9714 | 18.9714 | 32508.0 |
| 2012-05-18 06:55:00 | AAPL | Stock | 18.9821 | 18.9821 | 18.9821 | 18.9821 | 67200.0 |
| 2012-05-18 07:00:00 | AAPL | Stock | 19.0 | 19.0286 | 18.9929 | 19.0286 | 54880.0 |
| 2012-05-18 07:05:00 | AAPL | Stock | 19.0429 | 19.0518 | 19.0357 | 19.045 | 165060.0 |
| 2012-05-18 07:10:00 | AAPL | Stock | 19.0196 | 19.0518 | 19.0179 | 19.0518 | 48104.0 |
| 2012-05-18 07:15:00 | AAPL | Stock | 19.05 | 19.05 | 19.0071 | 19.0071 | 68880.0 |
| 2012-05-18 07:20:00 | AAPL | Stock | 19.0036 | 19.0443 | 19.0036 | 19.0357 | 138544.0 |
| 2012-05-18 07:25:00 | AAPL | Stock | 19.0357 | 19.0357 | 19.025 | 19.025 | 128296.0 |
| 2012-05-18 07:30:00 | AAPL | Stock | 19.0179 | 19.0243 | 19.0125 | 19.0125 | 35336.0 |
| 2012-05-18 07:35:00 | AAPL | Stock | 19.0171 | 19.0229 | 19.0089 | 19.0225 | 44800.0 |
| 2012-05-18 07:40:00 | AAPL | Stock | 19.0261 | 19.0718 | 19.0261 | 19.0682 | 320124.0 |
| 2012-05-18 07:45:00 | AAPL | Stock | 19.0818 | 19.0821 | 19.0554 | 19.0554 | 119028.0 |
| 2012-05-18 07:50:00 | AAPL | Stock | 19.0496 | 19.0604 | 19.0357 | 19.0357 | 133252.0 |
| 2012-05-18 07:55:00 | AAPL | Stock | 19.0357 | 19.0536 | 19.0357 | 19.0536 | 69692.0 |
| 2012-05-18 08:00:00 | AAPL | Stock | 19.0396 | 19.1036 | 19.0021 | 19.0893 | 525476.0 |
| 2012-05-18 08:05:00 | AAPL | Stock | 19.0893 | 19.1029 | 19.0643 | 19.0714 | 359436.0 |
| 2012-05-18 08:10:00 | AAPL | Stock | 19.0661 | 19.0921 | 19.0625 | 19.0821 | 384356.0 |
| 2012-05-18 08:15:00 | AAPL | Stock | 19.0814 | 19.0871 | 19.0636 | 19.0679 | 295988.0 |
| 2012-05-18 08:20:00 | AAPL | Stock | 19.0639 | 19.0714 | 19.0436 | 19.0714 | 253008.0 |
| 2012-05-18 08:25:00 | AAPL | Stock | 19.0682 | 19.1036 | 19.0625 | 19.0857 | 311836.0 |
| 2012-05-18 08:30:00 | AAPL | Stock | 19.0893 | 19.0896 | 19.0768 | 19.0768 | 103740.0 |
| 2012-05-18 08:35:00 | AAPL | Stock | 19.0804 | 19.0804 | 19.0579 | 19.0643 | 225848.0 |
| 2012-05-18 08:40:00 | AAPL | Stock | 19.0611 | 19.0786 | 19.0582 | 19.0732 | 297976.0 |
| 2012-05-18 08:45:00 | AAPL | Stock | 19.0714 | 19.0714 | 19.0607 | 19.0607 | 267092.0 |
| 2012-05-18 08:50:00 | AAPL | Stock | 19.0575 | 19.0579 | 19.0279 | 19.0279 | 331856.0 |
| 2012-05-18 08:55:00 | AAPL | Stock | 19.0279 | 19.0354 | 19.0146 | 19.0286 | 176988.0 |
| 2012-05-18 09:00:00 | AAPL | Stock | 19.0321 | 19.0332 | 19.0139 | 19.0246 | 142688.0 |
| 2012-05-18 09:05:00 | AAPL | Stock | 19.0193 | 19.03 | 19.0086 | 19.03 | 485772.0 |
| 2012-05-18 09:10:00 | AAPL | Stock | 19.0257 | 19.0339 | 19.0071 | 19.0179 | 286216.0 |
| 2012-05-18 09:15:00 | AAPL | Stock | 19.0175 | 19.0264 | 19.0143 | 19.02 | 133252.0 |
> showing 50 of 337,276 rows — these rows as CSV