PREVIEW / stock_1min / 2014-04-21
file: by_date/stock_1min/2014/2014-04-21.parquet size: 13.6 MB rows: 1,002,941 symbols: 2,892
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-04-21 07:14:00 | AAPL | Stock | 18.8021 | 18.8029 | 18.7946 | 18.7946 | 25200.0 |
| 2014-04-21 07:25:00 | AAPL | Stock | 18.8025 | 18.8025 | 18.8025 | 18.8025 | 28000.0 |
| 2014-04-21 07:26:00 | AAPL | Stock | 18.8025 | 18.8025 | 18.8025 | 18.8025 | 5600.0 |
| 2014-04-21 07:27:00 | AAPL | Stock | 18.8171 | 18.8171 | 18.8143 | 18.8143 | 5600.0 |
| 2014-04-21 07:29:00 | AAPL | Stock | 18.8143 | 18.8143 | 18.8143 | 18.8143 | 5600.0 |
| 2014-04-21 07:35:00 | AAPL | Stock | 18.7946 | 18.7946 | 18.7946 | 18.7946 | 11200.0 |
| 2014-04-21 07:36:00 | AAPL | Stock | 18.7907 | 18.7907 | 18.7857 | 18.7857 | 15400.0 |
| 2014-04-21 07:37:00 | AAPL | Stock | 18.7857 | 18.7857 | 18.7857 | 18.7857 | 5992.0 |
| 2014-04-21 07:45:00 | AAPL | Stock | 18.7979 | 18.7993 | 18.7979 | 18.7993 | 7336.0 |
| 2014-04-21 07:50:00 | AAPL | Stock | 18.8 | 18.8036 | 18.8 | 18.8036 | 25200.0 |
| 2014-04-21 07:52:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 2800.0 |
| 2014-04-21 07:56:00 | AAPL | Stock | 18.8036 | 18.8036 | 18.8036 | 18.8036 | 2800.0 |
| 2014-04-21 08:00:00 | AAPL | Stock | 18.8025 | 18.8025 | 18.7857 | 18.7857 | 29120.0 |
| 2014-04-21 08:01:00 | AAPL | Stock | 18.7871 | 18.7871 | 18.7857 | 18.7864 | 19600.0 |
| 2014-04-21 08:02:00 | AAPL | Stock | 18.7864 | 18.7864 | 18.7864 | 18.7864 | 8400.0 |
| 2014-04-21 08:06:00 | AAPL | Stock | 18.7821 | 18.7893 | 18.7821 | 18.7893 | 16800.0 |
| 2014-04-21 08:08:00 | AAPL | Stock | 18.7889 | 18.7893 | 18.7879 | 18.7879 | 25200.0 |
| 2014-04-21 08:09:00 | AAPL | Stock | 18.7882 | 18.7893 | 18.7882 | 18.7886 | 17836.0 |
| 2014-04-21 08:11:00 | AAPL | Stock | 18.7786 | 18.7832 | 18.7646 | 18.7646 | 50400.0 |
| 2014-04-21 08:12:00 | AAPL | Stock | 18.7754 | 18.7768 | 18.775 | 18.7754 | 61600.0 |
| 2014-04-21 08:13:00 | AAPL | Stock | 18.7654 | 18.7696 | 18.7646 | 18.7696 | 33096.0 |
| 2014-04-21 08:17:00 | AAPL | Stock | 18.7768 | 18.7768 | 18.7768 | 18.7768 | 4676.0 |
| 2014-04-21 08:22:00 | AAPL | Stock | 18.7682 | 18.7689 | 18.7646 | 18.7682 | 11704.0 |
| 2014-04-21 08:23:00 | AAPL | Stock | 18.7682 | 18.7682 | 18.7643 | 18.7661 | 31192.0 |
| 2014-04-21 08:27:00 | AAPL | Stock | 18.7693 | 18.77 | 18.7693 | 18.77 | 13412.0 |
| 2014-04-21 08:28:00 | AAPL | Stock | 18.7689 | 18.7746 | 18.7679 | 18.7746 | 44800.0 |
| 2014-04-21 08:30:00 | AAPL | Stock | 18.7682 | 18.7696 | 18.7682 | 18.7696 | 9520.0 |
| 2014-04-21 08:32:00 | AAPL | Stock | 18.7643 | 18.7696 | 18.7625 | 18.7696 | 38640.0 |
| 2014-04-21 08:34:00 | AAPL | Stock | 18.7682 | 18.7704 | 18.7679 | 18.7704 | 11200.0 |
| 2014-04-21 08:36:00 | AAPL | Stock | 18.7704 | 18.7704 | 18.7704 | 18.7704 | 2800.0 |
| 2014-04-21 08:37:00 | AAPL | Stock | 18.7696 | 18.7696 | 18.7696 | 18.7696 | 2800.0 |
| 2014-04-21 08:38:00 | AAPL | Stock | 18.7696 | 18.7696 | 18.7696 | 18.7696 | 4088.0 |
| 2014-04-21 08:39:00 | AAPL | Stock | 18.7714 | 18.7714 | 18.7714 | 18.7714 | 14000.0 |
| 2014-04-21 08:50:00 | AAPL | Stock | 18.7711 | 18.7711 | 18.7679 | 18.7679 | 25200.0 |
| 2014-04-21 08:51:00 | AAPL | Stock | 18.7746 | 18.7746 | 18.7746 | 18.7746 | 2800.0 |
| 2014-04-21 08:52:00 | AAPL | Stock | 18.7654 | 18.7654 | 18.7646 | 18.7646 | 8400.0 |
| 2014-04-21 08:53:00 | AAPL | Stock | 18.7625 | 18.7625 | 18.7625 | 18.7625 | 2800.0 |
| 2014-04-21 08:57:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 5600.0 |
| 2014-04-21 08:58:00 | AAPL | Stock | 18.7632 | 18.7632 | 18.7607 | 18.7607 | 9184.0 |
| 2014-04-21 08:59:00 | AAPL | Stock | 18.7625 | 18.7625 | 18.7625 | 18.7625 | 2800.0 |
| 2014-04-21 09:01:00 | AAPL | Stock | 18.7679 | 18.7679 | 18.7679 | 18.7679 | 10416.0 |
| 2014-04-21 09:02:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7589 | 18.7589 | 8820.0 |
| 2014-04-21 09:04:00 | AAPL | Stock | 18.7661 | 18.7661 | 18.7636 | 18.7643 | 84000.0 |
| 2014-04-21 09:05:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7643 | 18.7643 | 2800.0 |
| 2014-04-21 09:08:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7643 | 18.7643 | 36680.0 |
| 2014-04-21 09:09:00 | AAPL | Stock | 18.7643 | 18.7643 | 18.7625 | 18.7625 | 25760.0 |
| 2014-04-21 09:10:00 | AAPL | Stock | 18.7607 | 18.7607 | 18.7607 | 18.7607 | 5600.0 |
| 2014-04-21 09:12:00 | AAPL | Stock | 18.7604 | 18.7604 | 18.7589 | 18.7589 | 172480.0 |
| 2014-04-21 09:14:00 | AAPL | Stock | 18.7589 | 18.7589 | 18.7589 | 18.7589 | 28000.0 |
| 2014-04-21 09:15:00 | AAPL | Stock | 18.7618 | 18.7643 | 18.7618 | 18.7643 | 64400.0 |
> showing 50 of 1,002,941 rows — these rows as CSV