PREVIEW / stock_1min / 2013-05-22
file: by_date/stock_1min/2013/2013-05-22.parquet size: 14.3 MB rows: 1,029,362 symbols: 2,851
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-05-22 04:15:00 | AAPL | Stock | 15.7246 | 15.7246 | 15.7246 | 15.7246 | 5600.0 |
| 2013-05-22 04:29:00 | AAPL | Stock | 15.7246 | 15.7246 | 15.7246 | 15.7246 | 2800.0 |
| 2013-05-22 05:05:00 | AAPL | Stock | 15.725 | 15.725 | 15.725 | 15.725 | 2800.0 |
| 2013-05-22 05:41:00 | AAPL | Stock | 15.7818 | 15.7818 | 15.7818 | 15.7818 | 2800.0 |
| 2013-05-22 05:52:00 | AAPL | Stock | 15.7271 | 15.7271 | 15.7271 | 15.7271 | 2800.0 |
| 2013-05-22 07:09:00 | AAPL | Stock | 15.7729 | 15.7768 | 15.7729 | 15.7768 | 11200.0 |
| 2013-05-22 07:12:00 | AAPL | Stock | 15.785 | 15.785 | 15.7786 | 15.7786 | 8400.0 |
| 2013-05-22 07:16:00 | AAPL | Stock | 15.7857 | 15.79 | 15.7857 | 15.79 | 16800.0 |
| 2013-05-22 07:17:00 | AAPL | Stock | 15.7893 | 15.79 | 15.7793 | 15.7793 | 58800.0 |
| 2013-05-22 07:19:00 | AAPL | Stock | 15.7843 | 15.7846 | 15.7843 | 15.7846 | 8400.0 |
| 2013-05-22 07:20:00 | AAPL | Stock | 15.7789 | 15.7789 | 15.7768 | 15.7768 | 28924.0 |
| 2013-05-22 07:21:00 | AAPL | Stock | 15.7775 | 15.7775 | 15.7775 | 15.7775 | 2800.0 |
| 2013-05-22 07:22:00 | AAPL | Stock | 15.7768 | 15.7768 | 15.7768 | 15.7768 | 2800.0 |
| 2013-05-22 07:25:00 | AAPL | Stock | 15.7768 | 15.7768 | 15.7768 | 15.7768 | 2800.0 |
| 2013-05-22 07:28:00 | AAPL | Stock | 15.7771 | 15.7771 | 15.7771 | 15.7771 | 4676.0 |
| 2013-05-22 07:30:00 | AAPL | Stock | 15.7768 | 15.7768 | 15.7768 | 15.7768 | 2800.0 |
| 2013-05-22 07:40:00 | AAPL | Stock | 15.7714 | 15.7714 | 15.7714 | 15.7714 | 2800.0 |
| 2013-05-22 07:48:00 | AAPL | Stock | 15.7621 | 15.7629 | 15.7621 | 15.7629 | 5600.0 |
| 2013-05-22 07:49:00 | AAPL | Stock | 15.7625 | 15.7643 | 15.7625 | 15.7643 | 14000.0 |
| 2013-05-22 07:53:00 | AAPL | Stock | 15.7593 | 15.7593 | 15.7593 | 15.7593 | 2800.0 |
| 2013-05-22 07:54:00 | AAPL | Stock | 15.7636 | 15.7746 | 15.7636 | 15.7746 | 42000.0 |
| 2013-05-22 07:56:00 | AAPL | Stock | 15.7714 | 15.7818 | 15.7714 | 15.7818 | 20440.0 |
| 2013-05-22 07:57:00 | AAPL | Stock | 15.7854 | 15.7857 | 15.7854 | 15.7857 | 28280.0 |
| 2013-05-22 07:58:00 | AAPL | Stock | 15.7854 | 15.7857 | 15.785 | 15.7857 | 19600.0 |
| 2013-05-22 07:59:00 | AAPL | Stock | 15.7946 | 15.7946 | 15.7789 | 15.7946 | 19600.0 |
| 2013-05-22 08:00:00 | AAPL | Stock | 15.785 | 15.795 | 15.7679 | 15.785 | 146104.0 |
| 2013-05-22 08:01:00 | AAPL | Stock | 15.7911 | 15.8068 | 15.7854 | 15.8068 | 82600.0 |
| 2013-05-22 08:02:00 | AAPL | Stock | 15.8093 | 15.8536 | 15.8093 | 15.8439 | 99652.0 |
| 2013-05-22 08:03:00 | AAPL | Stock | 15.8343 | 15.8486 | 15.8321 | 15.8393 | 22120.0 |
| 2013-05-22 08:04:00 | AAPL | Stock | 15.8482 | 15.8729 | 15.8425 | 15.8571 | 98476.0 |
| 2013-05-22 08:05:00 | AAPL | Stock | 15.6536 | 15.8571 | 15.6536 | 15.8532 | 57288.0 |
| 2013-05-22 08:06:00 | AAPL | Stock | 15.8482 | 15.8571 | 15.8482 | 15.8571 | 107744.0 |
| 2013-05-22 08:07:00 | AAPL | Stock | 15.8571 | 15.8814 | 15.8482 | 15.8725 | 130088.0 |
| 2013-05-22 08:08:00 | AAPL | Stock | 15.8696 | 15.8714 | 15.8411 | 15.8411 | 75600.0 |
| 2013-05-22 08:09:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8571 | 15.8571 | 15400.0 |
| 2013-05-22 08:10:00 | AAPL | Stock | 15.8568 | 15.8679 | 15.8568 | 15.8671 | 93968.0 |
| 2013-05-22 08:11:00 | AAPL | Stock | 15.8575 | 15.8607 | 15.8571 | 15.8593 | 25200.0 |
| 2013-05-22 08:12:00 | AAPL | Stock | 15.8614 | 15.8661 | 15.8571 | 15.8636 | 40740.0 |
| 2013-05-22 08:13:00 | AAPL | Stock | 15.8571 | 15.8607 | 15.8468 | 15.8468 | 95200.0 |
| 2013-05-22 08:14:00 | AAPL | Stock | 15.8539 | 15.8929 | 15.8539 | 15.875 | 281288.0 |
| 2013-05-22 08:15:00 | AAPL | Stock | 15.8746 | 15.8754 | 15.8657 | 15.8661 | 50400.0 |
| 2013-05-22 08:16:00 | AAPL | Stock | 15.8625 | 15.8679 | 15.8618 | 15.8679 | 8400.0 |
| 2013-05-22 08:17:00 | AAPL | Stock | 15.8607 | 15.8679 | 15.8607 | 15.8625 | 106932.0 |
| 2013-05-22 08:18:00 | AAPL | Stock | 15.8611 | 15.8611 | 15.8571 | 15.8607 | 78960.0 |
| 2013-05-22 08:19:00 | AAPL | Stock | 15.8571 | 15.8664 | 15.8571 | 15.8664 | 111608.0 |
| 2013-05-22 08:20:00 | AAPL | Stock | 15.8668 | 15.8732 | 15.8614 | 15.8614 | 53200.0 |
| 2013-05-22 08:21:00 | AAPL | Stock | 15.8686 | 15.8729 | 15.8686 | 15.8729 | 26796.0 |
| 2013-05-22 08:22:00 | AAPL | Stock | 15.8714 | 15.8714 | 15.8679 | 15.8686 | 45500.0 |
| 2013-05-22 08:23:00 | AAPL | Stock | 15.8664 | 15.8664 | 15.8482 | 15.8571 | 102480.0 |
| 2013-05-22 08:24:00 | AAPL | Stock | 15.8571 | 15.8571 | 15.8561 | 15.8568 | 8960.0 |
> showing 50 of 1,029,362 rows — these rows as CSV