PREVIEW / stock_1min / 2006-02-09
file: by_date/stock_1min/2006/2006-02-09.parquet size: 8.1 MB rows: 651,504 symbols: 1,799
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 |
|---|---|---|---|---|---|---|---|
| 2006-02-09 04:16:00 | AAPL | Stock | 2.4661 | 2.4661 | 2.4661 | 2.4661 | 2800.0 |
| 2006-02-09 05:00:00 | AAPL | Stock | 2.4811 | 2.4811 | 2.4811 | 2.4811 | 5600.0 |
| 2006-02-09 07:26:00 | AAPL | Stock | 2.475 | 2.475 | 2.475 | 2.475 | 2800.0 |
| 2006-02-09 07:27:00 | AAPL | Stock | 2.4786 | 2.4786 | 2.4754 | 2.4754 | 11200.0 |
| 2006-02-09 07:30:00 | AAPL | Stock | 2.4768 | 2.4768 | 2.4768 | 2.4768 | 2800.0 |
| 2006-02-09 07:31:00 | AAPL | Stock | 2.4893 | 2.4893 | 2.4893 | 2.4893 | 14000.0 |
| 2006-02-09 07:39:00 | AAPL | Stock | 2.4779 | 2.4782 | 2.4775 | 2.4782 | 42000.0 |
| 2006-02-09 07:40:00 | AAPL | Stock | 2.4775 | 2.4775 | 2.4775 | 2.4775 | 5600.0 |
| 2006-02-09 07:42:00 | AAPL | Stock | 2.4775 | 2.4775 | 2.4775 | 2.4775 | 36400.0 |
| 2006-02-09 07:52:00 | AAPL | Stock | 2.4789 | 2.4789 | 2.4789 | 2.4789 | 8400.0 |
| 2006-02-09 07:53:00 | AAPL | Stock | 2.4789 | 2.4789 | 2.4789 | 2.4789 | 14000.0 |
| 2006-02-09 08:00:00 | AAPL | Stock | 2.4768 | 2.4768 | 2.4768 | 2.4768 | 84000.0 |
| 2006-02-09 08:01:00 | AAPL | Stock | 2.4768 | 2.4782 | 2.4721 | 2.4768 | 341376.0 |
| 2006-02-09 08:02:00 | AAPL | Stock | 2.4768 | 2.4768 | 2.4768 | 2.4768 | 7980.0 |
| 2006-02-09 08:03:00 | AAPL | Stock | 2.4764 | 2.4768 | 2.475 | 2.4764 | 58800.0 |
| 2006-02-09 08:04:00 | AAPL | Stock | 2.4768 | 2.4768 | 2.4768 | 2.4768 | 8400.0 |
| 2006-02-09 08:06:00 | AAPL | Stock | 2.4764 | 2.4764 | 2.4764 | 2.4764 | 8680.0 |
| 2006-02-09 08:08:00 | AAPL | Stock | 2.4739 | 2.4739 | 2.4714 | 2.4721 | 39200.0 |
| 2006-02-09 08:09:00 | AAPL | Stock | 2.475 | 2.475 | 2.4718 | 2.4718 | 61600.0 |
| 2006-02-09 08:10:00 | AAPL | Stock | 2.4714 | 2.4714 | 2.4714 | 2.4714 | 25340.0 |
| 2006-02-09 08:11:00 | AAPL | Stock | 2.4714 | 2.4714 | 2.4704 | 2.4704 | 37380.0 |
| 2006-02-09 08:12:00 | AAPL | Stock | 2.4704 | 2.4704 | 2.4704 | 2.4704 | 63280.0 |
| 2006-02-09 08:14:00 | AAPL | Stock | 2.4696 | 2.4696 | 2.465 | 2.465 | 92400.0 |
| 2006-02-09 08:15:00 | AAPL | Stock | 2.4679 | 2.4679 | 2.4679 | 2.4679 | 2800.0 |
| 2006-02-09 08:16:00 | AAPL | Stock | 2.4671 | 2.4671 | 2.4671 | 2.4671 | 8400.0 |
| 2006-02-09 08:17:00 | AAPL | Stock | 2.4671 | 2.4671 | 2.4668 | 2.4668 | 22400.0 |
| 2006-02-09 08:18:00 | AAPL | Stock | 2.4671 | 2.4671 | 2.4643 | 2.4646 | 152740.0 |
| 2006-02-09 08:19:00 | AAPL | Stock | 2.4643 | 2.4657 | 2.4607 | 2.4643 | 166600.0 |
| 2006-02-09 08:21:00 | AAPL | Stock | 2.4593 | 2.4611 | 2.4593 | 2.4611 | 56000.0 |
| 2006-02-09 08:22:00 | AAPL | Stock | 2.4625 | 2.4625 | 2.46 | 2.46 | 8400.0 |
| 2006-02-09 08:23:00 | AAPL | Stock | 2.4625 | 2.4625 | 2.4625 | 2.4625 | 14000.0 |
| 2006-02-09 08:24:00 | AAPL | Stock | 2.4611 | 2.4636 | 2.4607 | 2.4636 | 45780.0 |
| 2006-02-09 08:25:00 | AAPL | Stock | 2.4611 | 2.4611 | 2.4607 | 2.4607 | 33600.0 |
| 2006-02-09 08:26:00 | AAPL | Stock | 2.4589 | 2.4589 | 2.4589 | 2.4589 | 14000.0 |
| 2006-02-09 08:27:00 | AAPL | Stock | 2.4589 | 2.4589 | 2.4571 | 2.4571 | 32200.0 |
| 2006-02-09 08:28:00 | AAPL | Stock | 2.4589 | 2.4589 | 2.455 | 2.455 | 36400.0 |
| 2006-02-09 08:29:00 | AAPL | Stock | 2.4554 | 2.4554 | 2.4536 | 2.4554 | 30800.0 |
| 2006-02-09 08:30:00 | AAPL | Stock | 2.4571 | 2.4571 | 2.4571 | 2.4571 | 26600.0 |
| 2006-02-09 08:31:00 | AAPL | Stock | 2.4571 | 2.4589 | 2.4571 | 2.4589 | 11200.0 |
| 2006-02-09 08:32:00 | AAPL | Stock | 2.4607 | 2.4607 | 2.4589 | 2.4589 | 11200.0 |
| 2006-02-09 08:33:00 | AAPL | Stock | 2.4636 | 2.4636 | 2.4607 | 2.4632 | 28000.0 |
| 2006-02-09 08:34:00 | AAPL | Stock | 2.4632 | 2.4632 | 2.4632 | 2.4632 | 4032.0 |
| 2006-02-09 08:35:00 | AAPL | Stock | 2.4639 | 2.4643 | 2.4639 | 2.4643 | 92540.0 |
| 2006-02-09 08:36:00 | AAPL | Stock | 2.4646 | 2.4646 | 2.4646 | 2.4646 | 5600.0 |
| 2006-02-09 08:37:00 | AAPL | Stock | 2.465 | 2.465 | 2.4643 | 2.465 | 15400.0 |
| 2006-02-09 08:38:00 | AAPL | Stock | 2.465 | 2.4679 | 2.4643 | 2.4646 | 28000.0 |
| 2006-02-09 08:39:00 | AAPL | Stock | 2.4657 | 2.4679 | 2.4657 | 2.4661 | 63000.0 |
| 2006-02-09 08:40:00 | AAPL | Stock | 2.4661 | 2.4679 | 2.4661 | 2.4679 | 56000.0 |
| 2006-02-09 08:41:00 | AAPL | Stock | 2.4679 | 2.4679 | 2.4664 | 2.4664 | 25536.0 |
| 2006-02-09 08:42:00 | AAPL | Stock | 2.4661 | 2.4661 | 2.4661 | 2.4661 | 2800.0 |
> showing 50 of 651,504 rows — these rows as CSV