PREVIEW / stock_1min / 2010-12-17
file: by_date/stock_1min/2010/2010-12-17.parquet size: 13.7 MB rows: 1,024,054 symbols: 2,872
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-12-17 06:19:00 | AAPL | Stock | 11.4736 | 11.4736 | 11.4736 | 11.4736 | 2800.0 |
| 2010-12-17 06:47:00 | AAPL | Stock | 11.4736 | 11.4736 | 11.4736 | 11.4736 | 2800.0 |
| 2010-12-17 07:01:00 | AAPL | Stock | 11.4725 | 11.4725 | 11.4725 | 11.4725 | 2800.0 |
| 2010-12-17 07:13:00 | AAPL | Stock | 11.4768 | 11.4768 | 11.4768 | 11.4768 | 5600.0 |
| 2010-12-17 07:14:00 | AAPL | Stock | 11.4786 | 11.4786 | 11.4786 | 11.4786 | 14000.0 |
| 2010-12-17 07:15:00 | AAPL | Stock | 11.4732 | 11.4732 | 11.4732 | 11.4732 | 8400.0 |
| 2010-12-17 07:26:00 | AAPL | Stock | 11.4679 | 11.4679 | 11.4679 | 11.4679 | 4648.0 |
| 2010-12-17 07:47:00 | AAPL | Stock | 11.4775 | 11.4775 | 11.4775 | 11.4775 | 2800.0 |
| 2010-12-17 07:50:00 | AAPL | Stock | 11.4786 | 11.4786 | 11.4786 | 11.4786 | 14000.0 |
| 2010-12-17 07:51:00 | AAPL | Stock | 11.4804 | 11.4804 | 11.4804 | 11.4804 | 2800.0 |
| 2010-12-17 07:52:00 | AAPL | Stock | 11.4925 | 11.4925 | 11.4925 | 11.4925 | 2800.0 |
| 2010-12-17 07:53:00 | AAPL | Stock | 11.4929 | 11.5 | 11.4929 | 11.5 | 19600.0 |
| 2010-12-17 07:55:00 | AAPL | Stock | 11.5071 | 11.5071 | 11.5 | 11.5 | 39200.0 |
| 2010-12-17 07:59:00 | AAPL | Stock | 11.4893 | 11.4893 | 11.4893 | 11.4893 | 2800.0 |
| 2010-12-17 08:00:00 | AAPL | Stock | 11.4821 | 11.4904 | 11.4804 | 11.4857 | 90524.0 |
| 2010-12-17 08:01:00 | AAPL | Stock | 11.4907 | 11.4982 | 11.4875 | 11.4882 | 130788.0 |
| 2010-12-17 08:03:00 | AAPL | Stock | 11.4968 | 11.4968 | 11.4911 | 11.4911 | 58800.0 |
| 2010-12-17 08:04:00 | AAPL | Stock | 11.4939 | 11.4964 | 11.4896 | 11.4896 | 32116.0 |
| 2010-12-17 08:05:00 | AAPL | Stock | 11.4911 | 11.4925 | 11.4893 | 11.4925 | 22400.0 |
| 2010-12-17 08:06:00 | AAPL | Stock | 11.4911 | 11.4911 | 11.4875 | 11.4875 | 33600.0 |
| 2010-12-17 08:07:00 | AAPL | Stock | 11.4875 | 11.4875 | 11.4875 | 11.4875 | 2800.0 |
| 2010-12-17 08:10:00 | AAPL | Stock | 11.4857 | 11.4893 | 11.4857 | 11.4893 | 10080.0 |
| 2010-12-17 08:11:00 | AAPL | Stock | 11.4893 | 11.4893 | 11.4893 | 11.4893 | 8400.0 |
| 2010-12-17 08:12:00 | AAPL | Stock | 11.4864 | 11.4864 | 11.4846 | 11.4846 | 23800.0 |
| 2010-12-17 08:13:00 | AAPL | Stock | 11.4907 | 11.4911 | 11.4875 | 11.4875 | 42980.0 |
| 2010-12-17 08:14:00 | AAPL | Stock | 11.4875 | 11.4982 | 11.4875 | 11.4982 | 71120.0 |
| 2010-12-17 08:15:00 | AAPL | Stock | 11.4979 | 11.4982 | 11.4936 | 11.4982 | 42000.0 |
| 2010-12-17 08:17:00 | AAPL | Stock | 11.4982 | 11.4982 | 11.4982 | 11.4982 | 2800.0 |
| 2010-12-17 08:18:00 | AAPL | Stock | 11.495 | 11.495 | 11.4943 | 11.4943 | 5600.0 |
| 2010-12-17 08:19:00 | AAPL | Stock | 11.4964 | 11.4964 | 11.4964 | 11.4964 | 2800.0 |
| 2010-12-17 08:20:00 | AAPL | Stock | 11.4964 | 11.4982 | 11.4964 | 11.4982 | 41272.0 |
| 2010-12-17 08:21:00 | AAPL | Stock | 11.4989 | 11.4993 | 11.4989 | 11.4989 | 151200.0 |
| 2010-12-17 08:22:00 | AAPL | Stock | 11.4986 | 11.5089 | 11.4986 | 11.5064 | 64400.0 |
| 2010-12-17 08:23:00 | AAPL | Stock | 11.5064 | 11.51 | 11.5046 | 11.51 | 46704.0 |
| 2010-12-17 08:24:00 | AAPL | Stock | 11.5054 | 11.5054 | 11.5054 | 11.5054 | 2800.0 |
| 2010-12-17 08:26:00 | AAPL | Stock | 11.5054 | 11.5054 | 11.5054 | 11.5054 | 5600.0 |
| 2010-12-17 08:27:00 | AAPL | Stock | 11.5054 | 11.5054 | 11.5046 | 11.5046 | 5600.0 |
| 2010-12-17 08:29:00 | AAPL | Stock | 11.5025 | 11.5025 | 11.4989 | 11.4989 | 310240.0 |
| 2010-12-17 08:30:00 | AAPL | Stock | 11.4946 | 11.4946 | 11.4929 | 11.4929 | 66416.0 |
| 2010-12-17 08:31:00 | AAPL | Stock | 11.4946 | 11.4946 | 11.4929 | 11.4929 | 39760.0 |
| 2010-12-17 08:32:00 | AAPL | Stock | 11.4989 | 11.4989 | 11.4929 | 11.4929 | 5600.0 |
| 2010-12-17 08:33:00 | AAPL | Stock | 11.4911 | 11.4911 | 11.4911 | 11.4911 | 22400.0 |
| 2010-12-17 08:34:00 | AAPL | Stock | 11.4929 | 11.4932 | 11.4929 | 11.4932 | 29400.0 |
| 2010-12-17 08:36:00 | AAPL | Stock | 11.4946 | 11.4946 | 11.4893 | 11.4893 | 86660.0 |
| 2010-12-17 08:37:00 | AAPL | Stock | 11.4943 | 11.4968 | 11.4943 | 11.4968 | 47600.0 |
| 2010-12-17 08:38:00 | AAPL | Stock | 11.4968 | 11.4968 | 11.4968 | 11.4968 | 2800.0 |
| 2010-12-17 08:41:00 | AAPL | Stock | 11.4964 | 11.4964 | 11.4964 | 11.4964 | 2800.0 |
| 2010-12-17 08:43:00 | AAPL | Stock | 11.4914 | 11.4968 | 11.4914 | 11.4968 | 5600.0 |
| 2010-12-17 08:46:00 | AAPL | Stock | 11.4989 | 11.4989 | 11.4989 | 11.4989 | 2800.0 |
| 2010-12-17 08:50:00 | AAPL | Stock | 11.4996 | 11.5 | 11.4939 | 11.4939 | 14000.0 |
> showing 50 of 1,024,054 rows — these rows as CSV