PREVIEW / stock_1min / 2002-08-16
file: by_date/stock_1min/2002/2002-08-16.parquet size: 4.0 MB rows: 320,036 symbols: 1,192
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 |
|---|---|---|---|---|---|---|---|
| 2002-08-16 08:02:00 | AAPL | Stock | 0.2788 | 0.2788 | 0.2788 | 0.2788 | 5600.0 |
| 2002-08-16 08:04:00 | AAPL | Stock | 0.2796 | 0.2796 | 0.2796 | 0.2796 | 11200.0 |
| 2002-08-16 09:23:00 | AAPL | Stock | 0.2759 | 0.2764 | 0.2759 | 0.2759 | 442400.0 |
| 2002-08-16 09:24:00 | AAPL | Stock | 0.2759 | 0.2759 | 0.2759 | 0.2759 | 72800.0 |
| 2002-08-16 09:25:00 | AAPL | Stock | 0.2773 | 0.2773 | 0.2773 | 0.2773 | 28000.0 |
| 2002-08-16 09:26:00 | AAPL | Stock | 0.2773 | 0.2775 | 0.2773 | 0.2775 | 84000.0 |
| 2002-08-16 09:27:00 | AAPL | Stock | 0.2765 | 0.2765 | 0.2759 | 0.2759 | 252000.0 |
| 2002-08-16 09:29:00 | AAPL | Stock | 0.2759 | 0.2759 | 0.2759 | 0.2759 | 604800.0 |
| 2002-08-16 09:30:00 | AAPL | Stock | 0.2759 | 0.2773 | 0.2755 | 0.2763 | 1422400.0 |
| 2002-08-16 09:31:00 | AAPL | Stock | 0.2759 | 0.2773 | 0.2729 | 0.2732 | 4809000.0 |
| 2002-08-16 09:32:00 | AAPL | Stock | 0.2739 | 0.2759 | 0.2732 | 0.2736 | 632800.0 |
| 2002-08-16 09:33:00 | AAPL | Stock | 0.2741 | 0.2746 | 0.2734 | 0.2741 | 336000.0 |
| 2002-08-16 09:34:00 | AAPL | Stock | 0.2743 | 0.2763 | 0.2734 | 0.2757 | 1612800.0 |
| 2002-08-16 09:35:00 | AAPL | Stock | 0.2759 | 0.2761 | 0.2736 | 0.2736 | 649376.0 |
| 2002-08-16 09:36:00 | AAPL | Stock | 0.2746 | 0.275 | 0.2746 | 0.275 | 442400.0 |
| 2002-08-16 09:37:00 | AAPL | Stock | 0.275 | 0.275 | 0.2738 | 0.275 | 660800.0 |
| 2002-08-16 09:38:00 | AAPL | Stock | 0.2752 | 0.2754 | 0.2743 | 0.2745 | 520800.0 |
| 2002-08-16 09:39:00 | AAPL | Stock | 0.2745 | 0.275 | 0.2743 | 0.275 | 277200.0 |
| 2002-08-16 09:40:00 | AAPL | Stock | 0.275 | 0.2759 | 0.2745 | 0.2759 | 638400.0 |
| 2002-08-16 09:41:00 | AAPL | Stock | 0.2755 | 0.2757 | 0.2745 | 0.2746 | 577136.0 |
| 2002-08-16 09:42:00 | AAPL | Stock | 0.2755 | 0.2755 | 0.2755 | 0.2755 | 22400.0 |
| 2002-08-16 09:43:00 | AAPL | Stock | 0.2755 | 0.2755 | 0.2755 | 0.2755 | 78568.0 |
| 2002-08-16 09:44:00 | AAPL | Stock | 0.2757 | 0.2759 | 0.2757 | 0.2757 | 417256.0 |
| 2002-08-16 09:45:00 | AAPL | Stock | 0.2759 | 0.2763 | 0.2754 | 0.2757 | 1035440.0 |
| 2002-08-16 09:46:00 | AAPL | Stock | 0.2752 | 0.2754 | 0.2739 | 0.2739 | 1086400.0 |
| 2002-08-16 09:47:00 | AAPL | Stock | 0.2743 | 0.2748 | 0.2735 | 0.2748 | 1389024.0 |
| 2002-08-16 09:48:00 | AAPL | Stock | 0.2748 | 0.2777 | 0.2736 | 0.2775 | 1861384.0 |
| 2002-08-16 09:49:00 | AAPL | Stock | 0.2771 | 0.2777 | 0.2761 | 0.2777 | 587720.0 |
| 2002-08-16 09:50:00 | AAPL | Stock | 0.2773 | 0.2782 | 0.2773 | 0.278 | 588000.0 |
| 2002-08-16 09:51:00 | AAPL | Stock | 0.2782 | 0.2784 | 0.2775 | 0.2782 | 548800.0 |
| 2002-08-16 09:52:00 | AAPL | Stock | 0.2782 | 0.2782 | 0.2777 | 0.278 | 196000.0 |
| 2002-08-16 09:53:00 | AAPL | Stock | 0.2777 | 0.2786 | 0.2777 | 0.2784 | 274400.0 |
| 2002-08-16 09:54:00 | AAPL | Stock | 0.2784 | 0.2786 | 0.2779 | 0.278 | 560000.0 |
| 2002-08-16 09:55:00 | AAPL | Stock | 0.2779 | 0.2782 | 0.2779 | 0.2779 | 291200.0 |
| 2002-08-16 09:56:00 | AAPL | Stock | 0.278 | 0.2782 | 0.2777 | 0.2782 | 341600.0 |
| 2002-08-16 09:57:00 | AAPL | Stock | 0.278 | 0.278 | 0.2775 | 0.2775 | 632800.0 |
| 2002-08-16 09:58:00 | AAPL | Stock | 0.2773 | 0.2773 | 0.277 | 0.2773 | 683200.0 |
| 2002-08-16 09:59:00 | AAPL | Stock | 0.277 | 0.2773 | 0.2768 | 0.2768 | 1092000.0 |
| 2002-08-16 10:00:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2766 | 0.2766 | 621600.0 |
| 2002-08-16 10:01:00 | AAPL | Stock | 0.2766 | 0.2771 | 0.2766 | 0.2768 | 1349600.0 |
| 2002-08-16 10:02:00 | AAPL | Stock | 0.2768 | 0.2775 | 0.2766 | 0.2773 | 772800.0 |
| 2002-08-16 10:03:00 | AAPL | Stock | 0.277 | 0.2773 | 0.2766 | 0.2768 | 660800.0 |
| 2002-08-16 10:04:00 | AAPL | Stock | 0.2773 | 0.2779 | 0.2773 | 0.2777 | 442400.0 |
| 2002-08-16 10:05:00 | AAPL | Stock | 0.2771 | 0.2773 | 0.2771 | 0.2773 | 44800.0 |
| 2002-08-16 10:06:00 | AAPL | Stock | 0.277 | 0.2773 | 0.2766 | 0.2773 | 184800.0 |
| 2002-08-16 10:07:00 | AAPL | Stock | 0.2775 | 0.2777 | 0.2773 | 0.2777 | 294504.0 |
| 2002-08-16 10:08:00 | AAPL | Stock | 0.2777 | 0.2779 | 0.2771 | 0.2771 | 523096.0 |
| 2002-08-16 10:09:00 | AAPL | Stock | 0.2775 | 0.2775 | 0.2771 | 0.2773 | 364000.0 |
| 2002-08-16 10:10:00 | AAPL | Stock | 0.2777 | 0.2788 | 0.2777 | 0.2788 | 452032.0 |
| 2002-08-16 10:11:00 | AAPL | Stock | 0.2788 | 0.2793 | 0.2788 | 0.2791 | 336000.0 |
> showing 50 of 320,036 rows — these rows as CSV