PREVIEW / stock_1min / 2001-10-04
file: by_date/stock_1min/2001/2001-10-04.parquet size: 3.7 MB rows: 292,233 symbols: 1,096
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 |
|---|---|---|---|---|---|---|---|
| 2001-10-04 08:02:00 | AAPL | Stock | 0.2672 | 0.2672 | 0.2672 | 0.2672 | 767200.0 |
| 2001-10-04 08:04:00 | AAPL | Stock | 0.2716 | 0.2716 | 0.2716 | 0.2716 | 28000.0 |
| 2001-10-04 08:05:00 | AAPL | Stock | 0.2705 | 0.2705 | 0.2705 | 0.2705 | 56000.0 |
| 2001-10-04 08:06:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2768 | 0.2768 | 28000.0 |
| 2001-10-04 08:09:00 | AAPL | Stock | 0.2759 | 0.2768 | 0.2759 | 0.2768 | 84000.0 |
| 2001-10-04 08:11:00 | AAPL | Stock | 0.2768 | 0.2786 | 0.2768 | 0.2786 | 145600.0 |
| 2001-10-04 08:12:00 | AAPL | Stock | 0.2777 | 0.2777 | 0.2777 | 0.2777 | 28000.0 |
| 2001-10-04 08:15:00 | AAPL | Stock | 0.2768 | 0.2777 | 0.2768 | 0.2777 | 56000.0 |
| 2001-10-04 08:17:00 | AAPL | Stock | 0.2732 | 0.2732 | 0.2732 | 0.2732 | 28000.0 |
| 2001-10-04 08:24:00 | AAPL | Stock | 0.2732 | 0.2754 | 0.2732 | 0.2754 | 100800.0 |
| 2001-10-04 08:33:00 | AAPL | Stock | 0.2746 | 0.2746 | 0.2746 | 0.2746 | 11200.0 |
| 2001-10-04 08:39:00 | AAPL | Stock | 0.2746 | 0.275 | 0.2746 | 0.275 | 117600.0 |
| 2001-10-04 08:45:00 | AAPL | Stock | 0.2741 | 0.2741 | 0.2741 | 0.2741 | 56000.0 |
| 2001-10-04 08:59:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2768 | 0.2768 | 89600.0 |
| 2001-10-04 09:00:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2768 | 0.2768 | 190400.0 |
| 2001-10-04 09:04:00 | AAPL | Stock | 0.2752 | 0.2752 | 0.2752 | 0.2752 | 28000.0 |
| 2001-10-04 09:12:00 | AAPL | Stock | 0.275 | 0.275 | 0.275 | 0.275 | 28000.0 |
| 2001-10-04 09:13:00 | AAPL | Stock | 0.2752 | 0.2752 | 0.2752 | 0.2752 | 5600.0 |
| 2001-10-04 09:14:00 | AAPL | Stock | 0.2752 | 0.2752 | 0.2752 | 0.2752 | 39200.0 |
| 2001-10-04 09:17:00 | AAPL | Stock | 0.2752 | 0.2752 | 0.2752 | 0.2752 | 28000.0 |
| 2001-10-04 09:18:00 | AAPL | Stock | 0.2752 | 0.2752 | 0.275 | 0.275 | 296800.0 |
| 2001-10-04 09:19:00 | AAPL | Stock | 0.275 | 0.275 | 0.275 | 0.275 | 280000.0 |
| 2001-10-04 09:21:00 | AAPL | Stock | 0.2734 | 0.2734 | 0.2734 | 0.2734 | 39200.0 |
| 2001-10-04 09:24:00 | AAPL | Stock | 0.2739 | 0.2739 | 0.2739 | 0.2739 | 280000.0 |
| 2001-10-04 09:27:00 | AAPL | Stock | 0.2739 | 0.2741 | 0.2739 | 0.2739 | 285600.0 |
| 2001-10-04 09:28:00 | AAPL | Stock | 0.2741 | 0.2741 | 0.2741 | 0.2741 | 56000.0 |
| 2001-10-04 09:29:00 | AAPL | Stock | 0.2741 | 0.2741 | 0.2734 | 0.2739 | 201600.0 |
| 2001-10-04 09:30:00 | AAPL | Stock | 0.2741 | 0.2741 | 0.2732 | 0.2739 | 3399200.0 |
| 2001-10-04 09:31:00 | AAPL | Stock | 0.2741 | 0.2741 | 0.2727 | 0.2727 | 2682400.0 |
| 2001-10-04 09:32:00 | AAPL | Stock | 0.2729 | 0.2741 | 0.2718 | 0.2725 | 2122400.0 |
| 2001-10-04 09:33:00 | AAPL | Stock | 0.2718 | 0.2741 | 0.2718 | 0.273 | 1310400.0 |
| 2001-10-04 09:34:00 | AAPL | Stock | 0.2729 | 0.273 | 0.2716 | 0.272 | 974400.0 |
| 2001-10-04 09:35:00 | AAPL | Stock | 0.2723 | 0.2727 | 0.2705 | 0.272 | 3466400.0 |
| 2001-10-04 09:36:00 | AAPL | Stock | 0.2705 | 0.2727 | 0.2696 | 0.2727 | 649600.0 |
| 2001-10-04 09:37:00 | AAPL | Stock | 0.2721 | 0.273 | 0.2718 | 0.2725 | 2346400.0 |
| 2001-10-04 09:38:00 | AAPL | Stock | 0.2729 | 0.273 | 0.272 | 0.273 | 6025600.0 |
| 2001-10-04 09:39:00 | AAPL | Stock | 0.2725 | 0.2729 | 0.272 | 0.2725 | 576800.0 |
| 2001-10-04 09:40:00 | AAPL | Stock | 0.2727 | 0.2738 | 0.2727 | 0.2727 | 2077600.0 |
| 2001-10-04 09:41:00 | AAPL | Stock | 0.2727 | 0.273 | 0.2718 | 0.2718 | 14761600.0 |
| 2001-10-04 09:42:00 | AAPL | Stock | 0.2721 | 0.2723 | 0.2721 | 0.2721 | 716800.0 |
| 2001-10-04 09:43:00 | AAPL | Stock | 0.2718 | 0.2718 | 0.2711 | 0.2711 | 560000.0 |
| 2001-10-04 09:44:00 | AAPL | Stock | 0.2713 | 0.2713 | 0.2702 | 0.2705 | 1008000.0 |
| 2001-10-04 09:45:00 | AAPL | Stock | 0.2704 | 0.2705 | 0.2693 | 0.2695 | 817600.0 |
| 2001-10-04 09:46:00 | AAPL | Stock | 0.2693 | 0.2696 | 0.2684 | 0.2691 | 2083200.0 |
| 2001-10-04 09:47:00 | AAPL | Stock | 0.2688 | 0.2695 | 0.2678 | 0.2678 | 728000.0 |
| 2001-10-04 09:48:00 | AAPL | Stock | 0.268 | 0.27 | 0.2679 | 0.27 | 1372000.0 |
| 2001-10-04 09:49:00 | AAPL | Stock | 0.27 | 0.2711 | 0.2696 | 0.2707 | 767200.0 |
| 2001-10-04 09:50:00 | AAPL | Stock | 0.2707 | 0.2713 | 0.2705 | 0.2709 | 649600.0 |
| 2001-10-04 09:51:00 | AAPL | Stock | 0.2709 | 0.2714 | 0.2709 | 0.2709 | 716800.0 |
| 2001-10-04 09:52:00 | AAPL | Stock | 0.2714 | 0.2714 | 0.2713 | 0.2714 | 1159200.0 |
> showing 50 of 292,233 rows — these rows as CSV