PREVIEW / stock_1min / 2010-10-19
file: by_date/stock_1min/2010/2010-10-19.parquet size: 13.1 MB rows: 979,989 symbols: 2,841
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 |
|---|---|---|---|---|---|---|---|
| 2010-10-19 04:00:00 | AAPL | Stock | 10.7486 | 10.7679 | 10.7214 | 10.7679 | 23800.0 |
| 2010-10-19 04:02:00 | AAPL | Stock | 10.7743 | 10.7743 | 10.7743 | 10.7743 | 2800.0 |
| 2010-10-19 04:04:00 | AAPL | Stock | 10.7789 | 10.7789 | 10.7789 | 10.7789 | 2800.0 |
| 2010-10-19 04:06:00 | AAPL | Stock | 10.7929 | 10.7929 | 10.7929 | 10.7929 | 2800.0 |
| 2010-10-19 04:07:00 | AAPL | Stock | 10.7929 | 10.7929 | 10.7929 | 10.7929 | 22400.0 |
| 2010-10-19 04:08:00 | AAPL | Stock | 10.8186 | 10.8186 | 10.8186 | 10.8186 | 14000.0 |
| 2010-10-19 04:14:00 | AAPL | Stock | 10.8139 | 10.8139 | 10.8139 | 10.8139 | 2800.0 |
| 2010-10-19 04:18:00 | AAPL | Stock | 10.8107 | 10.8107 | 10.8107 | 10.8107 | 2800.0 |
| 2010-10-19 04:25:00 | AAPL | Stock | 10.7893 | 10.7893 | 10.7757 | 10.7757 | 61600.0 |
| 2010-10-19 04:38:00 | AAPL | Stock | 10.7629 | 10.7629 | 10.7629 | 10.7629 | 25200.0 |
| 2010-10-19 04:40:00 | AAPL | Stock | 10.7618 | 10.7618 | 10.7607 | 10.7618 | 11200.0 |
| 2010-10-19 05:00:00 | AAPL | Stock | 10.7957 | 10.7957 | 10.7957 | 10.7957 | 5600.0 |
| 2010-10-19 05:02:00 | AAPL | Stock | 10.7957 | 10.7957 | 10.7957 | 10.7957 | 16800.0 |
| 2010-10-19 05:05:00 | AAPL | Stock | 10.7954 | 10.7954 | 10.7954 | 10.7954 | 2800.0 |
| 2010-10-19 05:06:00 | AAPL | Stock | 10.7857 | 10.7857 | 10.7857 | 10.7857 | 2800.0 |
| 2010-10-19 05:17:00 | AAPL | Stock | 10.7786 | 10.7786 | 10.7786 | 10.7786 | 27132.0 |
| 2010-10-19 05:18:00 | AAPL | Stock | 10.7821 | 10.7821 | 10.7821 | 10.7821 | 15484.0 |
| 2010-10-19 05:25:00 | AAPL | Stock | 10.7854 | 10.7854 | 10.7854 | 10.7854 | 2800.0 |
| 2010-10-19 05:28:00 | AAPL | Stock | 10.81 | 10.81 | 10.81 | 10.81 | 11200.0 |
| 2010-10-19 05:31:00 | AAPL | Stock | 10.7964 | 10.81 | 10.7964 | 10.81 | 14000.0 |
| 2010-10-19 05:36:00 | AAPL | Stock | 10.8071 | 10.8071 | 10.8071 | 10.8071 | 2800.0 |
| 2010-10-19 05:45:00 | AAPL | Stock | 10.8 | 10.8 | 10.8 | 10.8 | 50400.0 |
| 2010-10-19 05:51:00 | AAPL | Stock | 10.8 | 10.8 | 10.8 | 10.8 | 2800.0 |
| 2010-10-19 05:56:00 | AAPL | Stock | 10.7925 | 10.7925 | 10.7925 | 10.7925 | 2800.0 |
| 2010-10-19 05:59:00 | AAPL | Stock | 10.8032 | 10.8032 | 10.8032 | 10.8032 | 2800.0 |
| 2010-10-19 06:06:00 | AAPL | Stock | 10.7918 | 10.7918 | 10.7918 | 10.7918 | 7000.0 |
| 2010-10-19 06:08:00 | AAPL | Stock | 10.7918 | 10.7918 | 10.7893 | 10.7893 | 11200.0 |
| 2010-10-19 06:11:00 | AAPL | Stock | 10.7893 | 10.7893 | 10.7893 | 10.7893 | 2800.0 |
| 2010-10-19 06:12:00 | AAPL | Stock | 10.7857 | 10.7857 | 10.7857 | 10.7857 | 16800.0 |
| 2010-10-19 06:24:00 | AAPL | Stock | 10.7768 | 10.7768 | 10.7768 | 10.7768 | 28000.0 |
| 2010-10-19 06:27:00 | AAPL | Stock | 10.7746 | 10.7746 | 10.7746 | 10.7746 | 5600.0 |
| 2010-10-19 06:31:00 | AAPL | Stock | 10.7782 | 10.7782 | 10.7782 | 10.7782 | 2800.0 |
| 2010-10-19 06:36:00 | AAPL | Stock | 10.785 | 10.7854 | 10.7718 | 10.7764 | 89488.0 |
| 2010-10-19 06:37:00 | AAPL | Stock | 10.7943 | 10.7943 | 10.7943 | 10.7943 | 8400.0 |
| 2010-10-19 06:38:00 | AAPL | Stock | 10.7943 | 10.7943 | 10.7943 | 10.7943 | 2800.0 |
| 2010-10-19 06:48:00 | AAPL | Stock | 10.7768 | 10.7768 | 10.7768 | 10.7768 | 23520.0 |
| 2010-10-19 06:50:00 | AAPL | Stock | 10.7918 | 10.7918 | 10.7918 | 10.7918 | 2800.0 |
| 2010-10-19 06:51:00 | AAPL | Stock | 10.7936 | 10.7936 | 10.7936 | 10.7936 | 22400.0 |
| 2010-10-19 06:54:00 | AAPL | Stock | 10.7925 | 10.7925 | 10.7925 | 10.7925 | 14728.0 |
| 2010-10-19 06:56:00 | AAPL | Stock | 10.7939 | 10.7939 | 10.7939 | 10.7939 | 2800.0 |
| 2010-10-19 06:57:00 | AAPL | Stock | 10.7939 | 10.7939 | 10.7939 | 10.7939 | 5600.0 |
| 2010-10-19 07:00:00 | AAPL | Stock | 10.7807 | 10.7807 | 10.7764 | 10.7764 | 85820.0 |
| 2010-10-19 07:01:00 | AAPL | Stock | 10.7764 | 10.7768 | 10.7575 | 10.7764 | 67424.0 |
| 2010-10-19 07:02:00 | AAPL | Stock | 10.7589 | 10.7939 | 10.7504 | 10.7925 | 59640.0 |
| 2010-10-19 07:03:00 | AAPL | Stock | 10.7504 | 10.7504 | 10.7418 | 10.7418 | 34076.0 |
| 2010-10-19 07:04:00 | AAPL | Stock | 10.7446 | 10.7446 | 10.7307 | 10.7307 | 7532.0 |
| 2010-10-19 07:05:00 | AAPL | Stock | 10.7307 | 10.7321 | 10.7143 | 10.715 | 157668.0 |
| 2010-10-19 07:06:00 | AAPL | Stock | 10.7143 | 10.7257 | 10.7 | 10.7136 | 120120.0 |
| 2010-10-19 07:07:00 | AAPL | Stock | 10.7479 | 10.7479 | 10.7143 | 10.7143 | 14000.0 |
| 2010-10-19 07:09:00 | AAPL | Stock | 10.7443 | 10.7446 | 10.7286 | 10.7289 | 14000.0 |
> showing 50 of 979,989 rows — these rows as CSV