PREVIEW / stock_1min / 2017-04-24
file: by_date/stock_1min/2017/2017-04-24.parquet size: 14.8 MB rows: 1,076,052 symbols: 2,523
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 |
|---|---|---|---|---|---|---|---|
| 2017-04-24 04:00:00 | AAPL | Stock | 36.0025 | 36.0025 | 36.0 | 36.0 | 2840.0 |
| 2017-04-24 04:08:00 | AAPL | Stock | 36.025 | 36.05 | 36.025 | 36.05 | 1676.0 |
| 2017-04-24 04:33:00 | AAPL | Stock | 36.025 | 36.025 | 36.025 | 36.025 | 2640.0 |
| 2017-04-24 04:37:00 | AAPL | Stock | 36.025 | 36.025 | 36.025 | 36.025 | 652.0 |
| 2017-04-24 04:39:00 | AAPL | Stock | 36.0125 | 36.0125 | 36.0125 | 36.0125 | 1120.0 |
| 2017-04-24 04:53:00 | AAPL | Stock | 35.9925 | 35.9925 | 35.9925 | 35.9925 | 496.0 |
| 2017-04-24 04:58:00 | AAPL | Stock | 35.9925 | 35.9925 | 35.9925 | 35.9925 | 480.0 |
| 2017-04-24 04:59:00 | AAPL | Stock | 35.9925 | 35.9925 | 35.9925 | 35.9925 | 1568.0 |
| 2017-04-24 05:00:00 | AAPL | Stock | 35.9925 | 35.9925 | 35.9925 | 35.9925 | 400.0 |
| 2017-04-24 05:15:00 | AAPL | Stock | 36.0025 | 36.0025 | 36.0025 | 36.0025 | 400.0 |
| 2017-04-24 05:21:00 | AAPL | Stock | 36.0125 | 36.0125 | 36.0125 | 36.0125 | 400.0 |
| 2017-04-24 05:24:00 | AAPL | Stock | 36.0125 | 36.0125 | 36.0125 | 36.0125 | 1516.0 |
| 2017-04-24 05:54:00 | AAPL | Stock | 35.98 | 35.98 | 35.9725 | 35.9725 | 4332.0 |
| 2017-04-24 06:06:00 | AAPL | Stock | 35.9625 | 35.9725 | 35.9625 | 35.9725 | 3600.0 |
| 2017-04-24 06:11:00 | AAPL | Stock | 35.985 | 35.985 | 35.985 | 35.985 | 1996.0 |
| 2017-04-24 06:13:00 | AAPL | Stock | 35.985 | 35.9875 | 35.985 | 35.9875 | 1576.0 |
| 2017-04-24 06:21:00 | AAPL | Stock | 35.97 | 35.97 | 35.965 | 35.965 | 3356.0 |
| 2017-04-24 06:30:00 | AAPL | Stock | 35.9875 | 35.9925 | 35.9875 | 35.9925 | 1600.0 |
| 2017-04-24 06:33:00 | AAPL | Stock | 35.9875 | 35.9925 | 35.9875 | 35.9925 | 4000.0 |
| 2017-04-24 06:50:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 400.0 |
| 2017-04-24 06:51:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 1200.0 |
| 2017-04-24 06:52:00 | AAPL | Stock | 35.95 | 35.95 | 35.95 | 35.95 | 820.0 |
| 2017-04-24 06:59:00 | AAPL | Stock | 35.9875 | 35.9875 | 35.9875 | 35.9875 | 400.0 |
| 2017-04-24 07:03:00 | AAPL | Stock | 35.975 | 35.975 | 35.975 | 35.975 | 400.0 |
| 2017-04-24 07:04:00 | AAPL | Stock | 35.975 | 35.975 | 35.975 | 35.975 | 3580.0 |
| 2017-04-24 07:05:00 | AAPL | Stock | 35.9625 | 35.975 | 35.9625 | 35.975 | 1200.0 |
| 2017-04-24 07:06:00 | AAPL | Stock | 35.9375 | 35.95 | 35.9375 | 35.95 | 1200.0 |
| 2017-04-24 07:07:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 7652.0 |
| 2017-04-24 07:08:00 | AAPL | Stock | 35.9025 | 35.9025 | 35.9025 | 35.9025 | 400.0 |
| 2017-04-24 07:18:00 | AAPL | Stock | 35.905 | 35.905 | 35.905 | 35.905 | 800.0 |
| 2017-04-24 07:19:00 | AAPL | Stock | 35.905 | 35.905 | 35.9 | 35.9 | 12008.0 |
| 2017-04-24 07:20:00 | AAPL | Stock | 35.92 | 35.9225 | 35.92 | 35.9225 | 3904.0 |
| 2017-04-24 07:21:00 | AAPL | Stock | 35.9225 | 35.9225 | 35.9225 | 35.9225 | 8000.0 |
| 2017-04-24 07:22:00 | AAPL | Stock | 35.92 | 35.92 | 35.92 | 35.92 | 400.0 |
| 2017-04-24 07:29:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.9125 | 35.9125 | 3600.0 |
| 2017-04-24 07:30:00 | AAPL | Stock | 35.92 | 35.92 | 35.905 | 35.905 | 3560.0 |
| 2017-04-24 07:33:00 | AAPL | Stock | 35.9075 | 35.9075 | 35.9075 | 35.9075 | 1200.0 |
| 2017-04-24 07:34:00 | AAPL | Stock | 35.9025 | 35.9025 | 35.9025 | 35.9025 | 400.0 |
| 2017-04-24 07:37:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 3600.0 |
| 2017-04-24 07:39:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 5400.0 |
| 2017-04-24 07:41:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.9025 | 35.9025 | 10800.0 |
| 2017-04-24 07:45:00 | AAPL | Stock | 35.92 | 35.92 | 35.92 | 35.92 | 400.0 |
| 2017-04-24 07:52:00 | AAPL | Stock | 35.925 | 35.925 | 35.925 | 35.925 | 800.0 |
| 2017-04-24 07:56:00 | AAPL | Stock | 35.935 | 35.935 | 35.935 | 35.935 | 400.0 |
| 2017-04-24 07:58:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.91 | 35.91 | 1200.0 |
| 2017-04-24 07:59:00 | AAPL | Stock | 35.925 | 35.925 | 35.9075 | 35.91 | 9600.0 |
| 2017-04-24 08:00:00 | AAPL | Stock | 35.905 | 35.965 | 35.9025 | 35.9125 | 24356.0 |
| 2017-04-24 08:02:00 | AAPL | Stock | 35.9125 | 35.9125 | 35.9125 | 35.9125 | 464.0 |
| 2017-04-24 08:03:00 | AAPL | Stock | 35.905 | 35.9125 | 35.905 | 35.905 | 13000.0 |
| 2017-04-24 08:04:00 | AAPL | Stock | 35.905 | 35.905 | 35.9 | 35.905 | 5856.0 |
> showing 50 of 1,076,052 rows — these rows as CSV