PREVIEW / stock_1min / 2007-05-01
file: by_date/stock_1min/2007/2007-05-01.parquet size: 10.8 MB rows: 880,794 symbols: 2,195
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 |
|---|---|---|---|---|---|---|---|
| 2007-05-01 09:30:00 | AAPL | Stock | 3.5568 | 3.5693 | 3.555 | 3.5654 | 6747524.0 |
| 2007-05-01 09:31:00 | AAPL | Stock | 3.5654 | 3.5675 | 3.5568 | 3.5618 | 2692592.0 |
| 2007-05-01 09:32:00 | AAPL | Stock | 3.5618 | 3.5636 | 3.5568 | 3.5621 | 2454284.0 |
| 2007-05-01 09:33:00 | AAPL | Stock | 3.5621 | 3.57 | 3.5568 | 3.5675 | 2509836.0 |
| 2007-05-01 09:34:00 | AAPL | Stock | 3.5679 | 3.5732 | 3.5668 | 3.5732 | 2573816.0 |
| 2007-05-01 09:35:00 | AAPL | Stock | 3.5729 | 3.5764 | 3.5696 | 3.575 | 2789080.0 |
| 2007-05-01 09:36:00 | AAPL | Stock | 3.5754 | 3.5757 | 3.5682 | 3.5696 | 2067352.0 |
| 2007-05-01 09:37:00 | AAPL | Stock | 3.5693 | 3.5711 | 3.5675 | 3.5686 | 1953868.0 |
| 2007-05-01 09:38:00 | AAPL | Stock | 3.5686 | 3.5704 | 3.5671 | 3.5704 | 1849260.0 |
| 2007-05-01 09:39:00 | AAPL | Stock | 3.5697 | 3.5707 | 3.5682 | 3.5693 | 1991976.0 |
| 2007-05-01 09:40:00 | AAPL | Stock | 3.5689 | 3.5732 | 3.5671 | 3.5714 | 2705388.0 |
| 2007-05-01 09:41:00 | AAPL | Stock | 3.5721 | 3.575 | 3.5704 | 3.5743 | 1589000.0 |
| 2007-05-01 09:42:00 | AAPL | Stock | 3.5739 | 3.575 | 3.5675 | 3.5682 | 3054744.0 |
| 2007-05-01 09:43:00 | AAPL | Stock | 3.5682 | 3.5768 | 3.5682 | 3.5743 | 3192476.0 |
| 2007-05-01 09:44:00 | AAPL | Stock | 3.5743 | 3.575 | 3.5721 | 3.5743 | 1475516.0 |
| 2007-05-01 09:45:00 | AAPL | Stock | 3.5739 | 3.5779 | 3.5714 | 3.5775 | 2059232.0 |
| 2007-05-01 09:46:00 | AAPL | Stock | 3.5781 | 3.5829 | 3.5764 | 3.5829 | 3346336.0 |
| 2007-05-01 09:47:00 | AAPL | Stock | 3.5824 | 3.5839 | 3.5804 | 3.5839 | 2639000.0 |
| 2007-05-01 09:48:00 | AAPL | Stock | 3.5839 | 3.5839 | 3.5821 | 3.5839 | 1686104.0 |
| 2007-05-01 09:49:00 | AAPL | Stock | 3.5839 | 3.5839 | 3.5811 | 3.5818 | 971684.0 |
| 2007-05-01 09:50:00 | AAPL | Stock | 3.5814 | 3.5814 | 3.5796 | 3.5807 | 963004.0 |
| 2007-05-01 09:51:00 | AAPL | Stock | 3.5807 | 3.5825 | 3.5807 | 3.5821 | 863800.0 |
| 2007-05-01 09:52:00 | AAPL | Stock | 3.5818 | 3.5829 | 3.5793 | 3.5796 | 1454740.0 |
| 2007-05-01 09:53:00 | AAPL | Stock | 3.5793 | 3.5807 | 3.5736 | 3.5743 | 1287272.0 |
| 2007-05-01 09:54:00 | AAPL | Stock | 3.5743 | 3.5754 | 3.5714 | 3.5714 | 2333520.0 |
| 2007-05-01 09:55:00 | AAPL | Stock | 3.5714 | 3.5718 | 3.5682 | 3.5704 | 2066148.0 |
| 2007-05-01 09:56:00 | AAPL | Stock | 3.5707 | 3.5718 | 3.5646 | 3.5654 | 2861124.0 |
| 2007-05-01 09:57:00 | AAPL | Stock | 3.5654 | 3.5657 | 3.5554 | 3.5568 | 4387432.0 |
| 2007-05-01 09:58:00 | AAPL | Stock | 3.5575 | 3.5582 | 3.5475 | 3.5507 | 3995068.0 |
| 2007-05-01 09:59:00 | AAPL | Stock | 3.5525 | 3.5586 | 3.5514 | 3.5579 | 2960244.0 |
| 2007-05-01 10:00:00 | AAPL | Stock | 3.5579 | 3.5607 | 3.5557 | 3.5564 | 4566800.0 |
| 2007-05-01 10:01:00 | AAPL | Stock | 3.5579 | 3.5604 | 3.5514 | 3.5525 | 3826088.0 |
| 2007-05-01 10:02:00 | AAPL | Stock | 3.5525 | 3.5554 | 3.5511 | 3.5532 | 2343992.0 |
| 2007-05-01 10:03:00 | AAPL | Stock | 3.5536 | 3.5561 | 3.55 | 3.5543 | 3012464.0 |
| 2007-05-01 10:04:00 | AAPL | Stock | 3.5543 | 3.5546 | 3.5504 | 3.5507 | 2421160.0 |
| 2007-05-01 10:05:00 | AAPL | Stock | 3.5511 | 3.5511 | 3.5446 | 3.5468 | 3430924.0 |
| 2007-05-01 10:06:00 | AAPL | Stock | 3.5464 | 3.5489 | 3.5439 | 3.5446 | 2594200.0 |
| 2007-05-01 10:07:00 | AAPL | Stock | 3.5457 | 3.5482 | 3.5429 | 3.5461 | 2501576.0 |
| 2007-05-01 10:08:00 | AAPL | Stock | 3.5461 | 3.5482 | 3.5432 | 3.5461 | 1897868.0 |
| 2007-05-01 10:09:00 | AAPL | Stock | 3.5468 | 3.5471 | 3.5436 | 3.545 | 1783124.0 |
| 2007-05-01 10:10:00 | AAPL | Stock | 3.545 | 3.5507 | 3.5446 | 3.5493 | 2709868.0 |
| 2007-05-01 10:11:00 | AAPL | Stock | 3.5504 | 3.5529 | 3.5489 | 3.5514 | 2000320.0 |
| 2007-05-01 10:12:00 | AAPL | Stock | 3.5518 | 3.5521 | 3.5482 | 3.5514 | 1182272.0 |
| 2007-05-01 10:13:00 | AAPL | Stock | 3.5518 | 3.555 | 3.5471 | 3.5478 | 2196348.0 |
| 2007-05-01 10:14:00 | AAPL | Stock | 3.5475 | 3.5514 | 3.5475 | 3.5504 | 1624028.0 |
| 2007-05-01 10:15:00 | AAPL | Stock | 3.55 | 3.5554 | 3.5493 | 3.5507 | 1855336.0 |
| 2007-05-01 10:16:00 | AAPL | Stock | 3.5517 | 3.5529 | 3.5471 | 3.5493 | 1690752.0 |
| 2007-05-01 10:17:00 | AAPL | Stock | 3.5486 | 3.5514 | 3.5461 | 3.5489 | 1630776.0 |
| 2007-05-01 10:18:00 | AAPL | Stock | 3.5489 | 3.5596 | 3.5486 | 3.5564 | 3149048.0 |
| 2007-05-01 10:19:00 | AAPL | Stock | 3.5561 | 3.5568 | 3.5511 | 3.555 | 2028124.0 |
> showing 50 of 880,794 rows — these rows as CSV