PREVIEW / stock_1min / 2012-08-16
file: by_date/stock_1min/2012/2012-08-16.parquet size: 12.2 MB rows: 900,764 symbols: 2,770
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-08-16 04:02:00 | AAPL | Stock | 22.5539 | 22.5539 | 22.5539 | 22.5539 | 5600.0 |
| 2012-08-16 04:06:00 | AAPL | Stock | 22.5536 | 22.5536 | 22.5536 | 22.5536 | 2800.0 |
| 2012-08-16 04:11:00 | AAPL | Stock | 22.5429 | 22.5429 | 22.5429 | 22.5429 | 4984.0 |
| 2012-08-16 04:14:00 | AAPL | Stock | 22.5429 | 22.5429 | 22.5429 | 22.5429 | 2800.0 |
| 2012-08-16 04:15:00 | AAPL | Stock | 22.5464 | 22.5464 | 22.5464 | 22.5464 | 3416.0 |
| 2012-08-16 04:20:00 | AAPL | Stock | 22.5361 | 22.5361 | 22.5361 | 22.5361 | 2800.0 |
| 2012-08-16 04:22:00 | AAPL | Stock | 22.5361 | 22.5361 | 22.5361 | 22.5361 | 2800.0 |
| 2012-08-16 06:51:00 | AAPL | Stock | 22.5871 | 22.5889 | 22.5871 | 22.5889 | 5600.0 |
| 2012-08-16 07:02:00 | AAPL | Stock | 22.58 | 22.5839 | 22.58 | 22.58 | 11900.0 |
| 2012-08-16 07:03:00 | AAPL | Stock | 22.5854 | 22.5971 | 22.5854 | 22.5971 | 28000.0 |
| 2012-08-16 07:06:00 | AAPL | Stock | 22.5957 | 22.6 | 22.5707 | 22.5714 | 65800.0 |
| 2012-08-16 07:18:00 | AAPL | Stock | 22.5614 | 22.5614 | 22.5611 | 22.5611 | 28000.0 |
| 2012-08-16 07:19:00 | AAPL | Stock | 22.5707 | 22.5707 | 22.5707 | 22.5707 | 4956.0 |
| 2012-08-16 07:20:00 | AAPL | Stock | 22.5707 | 22.5707 | 22.5707 | 22.5707 | 6244.0 |
| 2012-08-16 07:23:00 | AAPL | Stock | 22.58 | 22.5821 | 22.58 | 22.5821 | 10080.0 |
| 2012-08-16 07:32:00 | AAPL | Stock | 22.5889 | 22.5889 | 22.5889 | 22.5889 | 2800.0 |
| 2012-08-16 07:43:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5893 | 22.5893 | 11200.0 |
| 2012-08-16 07:47:00 | AAPL | Stock | 22.5946 | 22.5946 | 22.5893 | 22.5893 | 23100.0 |
| 2012-08-16 07:48:00 | AAPL | Stock | 22.5996 | 22.6 | 22.5996 | 22.6 | 36400.0 |
| 2012-08-16 07:50:00 | AAPL | Stock | 22.6036 | 22.605 | 22.6036 | 22.605 | 11144.0 |
| 2012-08-16 07:55:00 | AAPL | Stock | 22.6011 | 22.6011 | 22.6011 | 22.6011 | 2800.0 |
| 2012-08-16 07:58:00 | AAPL | Stock | 22.6007 | 22.6007 | 22.6007 | 22.6007 | 2800.0 |
| 2012-08-16 08:00:00 | AAPL | Stock | 22.5907 | 22.6014 | 22.5907 | 22.5964 | 32228.0 |
| 2012-08-16 08:01:00 | AAPL | Stock | 22.6014 | 22.6071 | 22.6014 | 22.6071 | 41608.0 |
| 2012-08-16 08:02:00 | AAPL | Stock | 22.6054 | 22.6068 | 22.5964 | 22.5964 | 58800.0 |
| 2012-08-16 08:03:00 | AAPL | Stock | 22.5964 | 22.5964 | 22.5904 | 22.5904 | 34888.0 |
| 2012-08-16 08:04:00 | AAPL | Stock | 22.5911 | 22.5961 | 22.5775 | 22.5786 | 169456.0 |
| 2012-08-16 08:05:00 | AAPL | Stock | 22.5875 | 22.5875 | 22.5875 | 22.5875 | 5320.0 |
| 2012-08-16 08:06:00 | AAPL | Stock | 22.5854 | 22.5861 | 22.5854 | 22.5861 | 30940.0 |
| 2012-08-16 08:07:00 | AAPL | Stock | 22.5875 | 22.5875 | 22.5875 | 22.5875 | 2800.0 |
| 2012-08-16 08:08:00 | AAPL | Stock | 22.5929 | 22.5929 | 22.5929 | 22.5929 | 2800.0 |
| 2012-08-16 08:09:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5875 | 22.5875 | 14000.0 |
| 2012-08-16 08:10:00 | AAPL | Stock | 22.5854 | 22.5893 | 22.5854 | 22.5861 | 16940.0 |
| 2012-08-16 08:11:00 | AAPL | Stock | 22.5893 | 22.5893 | 22.5893 | 22.5893 | 28000.0 |
| 2012-08-16 08:12:00 | AAPL | Stock | 22.5875 | 22.5875 | 22.5807 | 22.5807 | 5600.0 |
| 2012-08-16 08:13:00 | AAPL | Stock | 22.5786 | 22.5786 | 22.5786 | 22.5786 | 2800.0 |
| 2012-08-16 08:14:00 | AAPL | Stock | 22.575 | 22.575 | 22.575 | 22.575 | 2800.0 |
| 2012-08-16 08:15:00 | AAPL | Stock | 22.5804 | 22.5804 | 22.5804 | 22.5804 | 5600.0 |
| 2012-08-16 08:16:00 | AAPL | Stock | 22.5743 | 22.5743 | 22.5743 | 22.5743 | 5600.0 |
| 2012-08-16 08:20:00 | AAPL | Stock | 22.5843 | 22.5843 | 22.5839 | 22.5839 | 5600.0 |
| 2012-08-16 08:23:00 | AAPL | Stock | 22.5768 | 22.5768 | 22.5768 | 22.5768 | 2800.0 |
| 2012-08-16 08:27:00 | AAPL | Stock | 22.5814 | 22.5814 | 22.5814 | 22.5814 | 2800.0 |
| 2012-08-16 08:29:00 | AAPL | Stock | 22.5821 | 22.5821 | 22.5821 | 22.5821 | 2800.0 |
| 2012-08-16 08:30:00 | AAPL | Stock | 22.5832 | 22.5836 | 22.5821 | 22.5832 | 47600.0 |
| 2012-08-16 08:31:00 | AAPL | Stock | 22.5821 | 22.5911 | 22.5821 | 22.5893 | 67200.0 |
| 2012-08-16 08:32:00 | AAPL | Stock | 22.5839 | 22.5839 | 22.5821 | 22.5821 | 8400.0 |
| 2012-08-16 08:34:00 | AAPL | Stock | 22.5843 | 22.5854 | 22.5843 | 22.5854 | 5600.0 |
| 2012-08-16 08:35:00 | AAPL | Stock | 22.5886 | 22.5893 | 22.5886 | 22.5886 | 30800.0 |
| 2012-08-16 08:36:00 | AAPL | Stock | 22.5857 | 22.6064 | 22.5857 | 22.5893 | 74844.0 |
| 2012-08-16 08:38:00 | AAPL | Stock | 22.5886 | 22.5886 | 22.5886 | 22.5886 | 2800.0 |
> showing 50 of 900,764 rows — these rows as CSV