PREVIEW / stock_1min / 2009-07-20
file: by_date/stock_1min/2009/2009-07-20.parquet size: 12.3 MB rows: 934,623 symbols: 2,727
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-20 05:09:00 | AAPL | Stock | 5.4536 | 5.4536 | 5.4536 | 5.4536 | 7700.0 |
| 2009-07-20 07:00:00 | AAPL | Stock | 5.4536 | 5.4536 | 5.4536 | 5.4536 | 5180.0 |
| 2009-07-20 07:11:00 | AAPL | Stock | 5.4729 | 5.4768 | 5.4729 | 5.4768 | 22400.0 |
| 2009-07-20 07:12:00 | AAPL | Stock | 5.4768 | 5.4768 | 5.4768 | 5.4768 | 32200.0 |
| 2009-07-20 07:16:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4643 | 5.4643 | 16800.0 |
| 2009-07-20 07:17:00 | AAPL | Stock | 5.4575 | 5.4643 | 5.4571 | 5.4643 | 22400.0 |
| 2009-07-20 07:18:00 | AAPL | Stock | 5.4571 | 5.4571 | 5.4571 | 5.4571 | 2800.0 |
| 2009-07-20 07:19:00 | AAPL | Stock | 5.4575 | 5.4575 | 5.4575 | 5.4575 | 2800.0 |
| 2009-07-20 07:30:00 | AAPL | Stock | 5.4589 | 5.4589 | 5.4589 | 5.4589 | 5600.0 |
| 2009-07-20 07:31:00 | AAPL | Stock | 5.4589 | 5.4589 | 5.4571 | 5.4571 | 22400.0 |
| 2009-07-20 07:32:00 | AAPL | Stock | 5.4571 | 5.4571 | 5.4571 | 5.4571 | 2800.0 |
| 2009-07-20 07:34:00 | AAPL | Stock | 5.4589 | 5.4589 | 5.4589 | 5.4589 | 8400.0 |
| 2009-07-20 07:36:00 | AAPL | Stock | 5.46 | 5.46 | 5.46 | 5.46 | 6412.0 |
| 2009-07-20 07:37:00 | AAPL | Stock | 5.46 | 5.46 | 5.46 | 5.46 | 4788.0 |
| 2009-07-20 07:41:00 | AAPL | Stock | 5.4586 | 5.4586 | 5.4582 | 5.4582 | 26796.0 |
| 2009-07-20 07:42:00 | AAPL | Stock | 5.4643 | 5.4643 | 5.4643 | 5.4643 | 34020.0 |
| 2009-07-20 07:45:00 | AAPL | Stock | 5.4764 | 5.4975 | 5.4714 | 5.4821 | 203588.0 |
| 2009-07-20 07:46:00 | AAPL | Stock | 5.4779 | 5.4821 | 5.4779 | 5.48 | 173124.0 |
| 2009-07-20 07:49:00 | AAPL | Stock | 5.4886 | 5.4886 | 5.4886 | 5.4886 | 42000.0 |
| 2009-07-20 07:50:00 | AAPL | Stock | 5.4911 | 5.4911 | 5.4911 | 5.4911 | 14000.0 |
| 2009-07-20 07:52:00 | AAPL | Stock | 5.4857 | 5.4911 | 5.4846 | 5.4911 | 36400.0 |
| 2009-07-20 07:54:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4893 | 5.4893 | 56000.0 |
| 2009-07-20 07:55:00 | AAPL | Stock | 5.4918 | 5.4957 | 5.4918 | 5.4957 | 33432.0 |
| 2009-07-20 07:56:00 | AAPL | Stock | 5.4996 | 5.5011 | 5.4996 | 5.5011 | 69776.0 |
| 2009-07-20 07:57:00 | AAPL | Stock | 5.4946 | 5.4946 | 5.4946 | 5.4946 | 5600.0 |
| 2009-07-20 07:58:00 | AAPL | Stock | 5.4929 | 5.5029 | 5.4929 | 5.5018 | 49000.0 |
| 2009-07-20 08:00:00 | AAPL | Stock | 5.4893 | 5.5007 | 5.4807 | 5.49 | 680064.0 |
| 2009-07-20 08:01:00 | AAPL | Stock | 5.4875 | 5.4875 | 5.48 | 5.4868 | 118720.0 |
| 2009-07-20 08:02:00 | AAPL | Stock | 5.485 | 5.4857 | 5.4821 | 5.4821 | 37800.0 |
| 2009-07-20 08:03:00 | AAPL | Stock | 5.4807 | 5.4846 | 5.4804 | 5.4846 | 45556.0 |
| 2009-07-20 08:04:00 | AAPL | Stock | 5.485 | 5.4875 | 5.4839 | 5.4875 | 96740.0 |
| 2009-07-20 08:05:00 | AAPL | Stock | 5.4875 | 5.4875 | 5.4839 | 5.4839 | 50400.0 |
| 2009-07-20 08:06:00 | AAPL | Stock | 5.4846 | 5.4879 | 5.4846 | 5.4879 | 20860.0 |
| 2009-07-20 08:07:00 | AAPL | Stock | 5.4882 | 5.4893 | 5.4882 | 5.4893 | 65940.0 |
| 2009-07-20 08:08:00 | AAPL | Stock | 5.4875 | 5.4893 | 5.4875 | 5.4893 | 37240.0 |
| 2009-07-20 08:09:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4857 | 5.4893 | 103600.0 |
| 2009-07-20 08:10:00 | AAPL | Stock | 5.4893 | 5.4911 | 5.4886 | 5.4904 | 103740.0 |
| 2009-07-20 08:11:00 | AAPL | Stock | 5.49 | 5.4911 | 5.4896 | 5.4904 | 95676.0 |
| 2009-07-20 08:12:00 | AAPL | Stock | 5.4911 | 5.4929 | 5.4907 | 5.4911 | 128800.0 |
| 2009-07-20 08:13:00 | AAPL | Stock | 5.4911 | 5.4929 | 5.4911 | 5.4914 | 64232.0 |
| 2009-07-20 08:14:00 | AAPL | Stock | 5.4918 | 5.4946 | 5.4889 | 5.4893 | 73248.0 |
| 2009-07-20 08:15:00 | AAPL | Stock | 5.4889 | 5.4889 | 5.4882 | 5.4889 | 68600.0 |
| 2009-07-20 08:17:00 | AAPL | Stock | 5.4864 | 5.4893 | 5.4861 | 5.4893 | 65240.0 |
| 2009-07-20 08:18:00 | AAPL | Stock | 5.4893 | 5.4893 | 5.4875 | 5.4875 | 23520.0 |
| 2009-07-20 08:19:00 | AAPL | Stock | 5.4889 | 5.4896 | 5.4889 | 5.4896 | 37436.0 |
| 2009-07-20 08:20:00 | AAPL | Stock | 5.4896 | 5.4896 | 5.4896 | 5.4896 | 22764.0 |
| 2009-07-20 08:21:00 | AAPL | Stock | 5.4879 | 5.4896 | 5.4868 | 5.4889 | 36400.0 |
| 2009-07-20 08:22:00 | AAPL | Stock | 5.4889 | 5.4889 | 5.4889 | 5.4889 | 2800.0 |
| 2009-07-20 08:23:00 | AAPL | Stock | 5.49 | 5.49 | 5.4861 | 5.4861 | 33600.0 |
| 2009-07-20 08:24:00 | AAPL | Stock | 5.4861 | 5.4861 | 5.485 | 5.485 | 30184.0 |
> showing 50 of 934,623 rows — these rows as CSV