PREVIEW / stock_1min / 2005-01-25
file: by_date/stock_1min/2005/2005-01-25.parquet size: 6.5 MB rows: 539,966 symbols: 1,571
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 |
|---|---|---|---|---|---|---|---|
| 2005-01-25 08:01:00 | AAPL | Stock | 1.2707 | 1.2707 | 1.2707 | 1.2707 | 22400.0 |
| 2005-01-25 08:05:00 | AAPL | Stock | 1.2711 | 1.2711 | 1.2705 | 1.2705 | 84000.0 |
| 2005-01-25 08:07:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 8176.0 |
| 2005-01-25 08:10:00 | AAPL | Stock | 1.2705 | 1.2705 | 1.2705 | 1.2705 | 11200.0 |
| 2005-01-25 08:11:00 | AAPL | Stock | 1.2705 | 1.2705 | 1.2705 | 1.2705 | 22624.0 |
| 2005-01-25 08:12:00 | AAPL | Stock | 1.2705 | 1.2705 | 1.2696 | 1.2696 | 25200.0 |
| 2005-01-25 08:13:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2696 | 1.2696 | 61600.0 |
| 2005-01-25 08:14:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2696 | 1.2696 | 67312.0 |
| 2005-01-25 08:15:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2696 | 1.2696 | 33600.0 |
| 2005-01-25 08:17:00 | AAPL | Stock | 1.2696 | 1.2696 | 1.2696 | 1.2696 | 44688.0 |
| 2005-01-25 08:20:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 14000.0 |
| 2005-01-25 08:21:00 | AAPL | Stock | 1.2723 | 1.2732 | 1.2723 | 1.2729 | 224000.0 |
| 2005-01-25 08:22:00 | AAPL | Stock | 1.2723 | 1.2732 | 1.2723 | 1.2732 | 11200.0 |
| 2005-01-25 08:23:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2723 | 1.2723 | 84000.0 |
| 2005-01-25 08:30:00 | AAPL | Stock | 1.2725 | 1.2725 | 1.2725 | 1.2725 | 22400.0 |
| 2005-01-25 08:31:00 | AAPL | Stock | 1.2734 | 1.2746 | 1.2734 | 1.2746 | 33600.0 |
| 2005-01-25 08:32:00 | AAPL | Stock | 1.2746 | 1.275 | 1.2746 | 1.2746 | 246176.0 |
| 2005-01-25 08:33:00 | AAPL | Stock | 1.2746 | 1.275 | 1.2746 | 1.275 | 33600.0 |
| 2005-01-25 08:34:00 | AAPL | Stock | 1.2759 | 1.2759 | 1.275 | 1.275 | 50400.0 |
| 2005-01-25 08:35:00 | AAPL | Stock | 1.2759 | 1.2766 | 1.2759 | 1.2759 | 113680.0 |
| 2005-01-25 08:36:00 | AAPL | Stock | 1.2759 | 1.2766 | 1.2759 | 1.2766 | 132720.0 |
| 2005-01-25 08:37:00 | AAPL | Stock | 1.2779 | 1.2779 | 1.2757 | 1.2757 | 22400.0 |
| 2005-01-25 08:39:00 | AAPL | Stock | 1.275 | 1.275 | 1.275 | 1.275 | 67200.0 |
| 2005-01-25 08:44:00 | AAPL | Stock | 1.2732 | 1.2732 | 1.2732 | 1.2732 | 11200.0 |
| 2005-01-25 08:45:00 | AAPL | Stock | 1.2734 | 1.2734 | 1.2734 | 1.2734 | 44800.0 |
| 2005-01-25 08:48:00 | AAPL | Stock | 1.2736 | 1.2736 | 1.2714 | 1.2714 | 112000.0 |
| 2005-01-25 08:49:00 | AAPL | Stock | 1.2716 | 1.2716 | 1.2716 | 1.2716 | 5600.0 |
| 2005-01-25 08:55:00 | AAPL | Stock | 1.272 | 1.272 | 1.272 | 1.272 | 11200.0 |
| 2005-01-25 09:03:00 | AAPL | Stock | 1.2723 | 1.2727 | 1.2723 | 1.2727 | 44800.0 |
| 2005-01-25 09:10:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2714 | 1.2714 | 84000.0 |
| 2005-01-25 09:11:00 | AAPL | Stock | 1.2705 | 1.2707 | 1.2705 | 1.2705 | 218400.0 |
| 2005-01-25 09:13:00 | AAPL | Stock | 1.2707 | 1.2727 | 1.2707 | 1.2727 | 72800.0 |
| 2005-01-25 09:14:00 | AAPL | Stock | 1.2718 | 1.2718 | 1.2718 | 1.2718 | 28000.0 |
| 2005-01-25 09:15:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 33600.0 |
| 2005-01-25 09:21:00 | AAPL | Stock | 1.2714 | 1.2714 | 1.2714 | 1.2714 | 22400.0 |
| 2005-01-25 09:23:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 28000.0 |
| 2005-01-25 09:24:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2709 | 1.2709 | 131600.0 |
| 2005-01-25 09:25:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 56000.0 |
| 2005-01-25 09:26:00 | AAPL | Stock | 1.2723 | 1.2723 | 1.2723 | 1.2723 | 11200.0 |
| 2005-01-25 09:27:00 | AAPL | Stock | 1.2723 | 1.2732 | 1.2723 | 1.2732 | 151200.0 |
| 2005-01-25 09:28:00 | AAPL | Stock | 1.2732 | 1.2759 | 1.2732 | 1.2759 | 879648.0 |
| 2005-01-25 09:29:00 | AAPL | Stock | 1.275 | 1.2768 | 1.2738 | 1.2755 | 685216.0 |
| 2005-01-25 09:30:00 | AAPL | Stock | 1.2752 | 1.2764 | 1.2739 | 1.2754 | 7907200.0 |
| 2005-01-25 09:31:00 | AAPL | Stock | 1.2755 | 1.2757 | 1.2738 | 1.2752 | 2205224.0 |
| 2005-01-25 09:32:00 | AAPL | Stock | 1.2753 | 1.2761 | 1.2741 | 1.2754 | 3262448.0 |
| 2005-01-25 09:33:00 | AAPL | Stock | 1.2754 | 1.2755 | 1.2725 | 1.2738 | 3572184.0 |
| 2005-01-25 09:34:00 | AAPL | Stock | 1.2739 | 1.2754 | 1.2734 | 1.2736 | 4676448.0 |
| 2005-01-25 09:35:00 | AAPL | Stock | 1.2739 | 1.2741 | 1.2714 | 1.2714 | 3847760.0 |
| 2005-01-25 09:36:00 | AAPL | Stock | 1.2716 | 1.2736 | 1.2713 | 1.2727 | 6521200.0 |
| 2005-01-25 09:37:00 | AAPL | Stock | 1.273 | 1.2736 | 1.2725 | 1.273 | 2863672.0 |
> showing 50 of 539,966 rows — these rows as CSV