PREVIEW / stock_1min / 2009-02-03
file: by_date/stock_1min/2009/2009-02-03.parquet size: 12.8 MB rows: 1,000,114 symbols: 2,658
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-03 07:01:00 | AAPL | Stock | 3.2679 | 3.2679 | 3.2679 | 3.2679 | 5600.0 |
| 2009-02-03 07:13:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2675 | 3.2675 | 2800.0 |
| 2009-02-03 07:30:00 | AAPL | Stock | 3.2736 | 3.2743 | 3.2736 | 3.2743 | 44800.0 |
| 2009-02-03 07:31:00 | AAPL | Stock | 3.2743 | 3.2743 | 3.2743 | 3.2743 | 5600.0 |
| 2009-02-03 07:34:00 | AAPL | Stock | 3.2779 | 3.2779 | 3.2779 | 3.2779 | 2800.0 |
| 2009-02-03 08:08:00 | AAPL | Stock | 3.2675 | 3.275 | 3.2675 | 3.275 | 29400.0 |
| 2009-02-03 08:09:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2675 | 3.2675 | 2800.0 |
| 2009-02-03 08:10:00 | AAPL | Stock | 3.2682 | 3.2682 | 3.2682 | 3.2682 | 89600.0 |
| 2009-02-03 08:17:00 | AAPL | Stock | 3.2696 | 3.2696 | 3.2696 | 3.2696 | 53676.0 |
| 2009-02-03 08:18:00 | AAPL | Stock | 3.2682 | 3.2682 | 3.2682 | 3.2682 | 14000.0 |
| 2009-02-03 08:24:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2675 | 3.2675 | 5600.0 |
| 2009-02-03 08:31:00 | AAPL | Stock | 3.2643 | 3.2643 | 3.2643 | 3.2643 | 14000.0 |
| 2009-02-03 08:35:00 | AAPL | Stock | 3.2643 | 3.2643 | 3.2643 | 3.2643 | 25760.0 |
| 2009-02-03 08:37:00 | AAPL | Stock | 3.265 | 3.265 | 3.2646 | 3.2646 | 11200.0 |
| 2009-02-03 08:38:00 | AAPL | Stock | 3.2675 | 3.2675 | 3.2675 | 3.2675 | 5600.0 |
| 2009-02-03 08:39:00 | AAPL | Stock | 3.2657 | 3.2657 | 3.2646 | 3.2646 | 11200.0 |
| 2009-02-03 08:41:00 | AAPL | Stock | 3.2664 | 3.2664 | 3.2664 | 3.2664 | 2800.0 |
| 2009-02-03 08:42:00 | AAPL | Stock | 3.265 | 3.265 | 3.265 | 3.265 | 8400.0 |
| 2009-02-03 08:43:00 | AAPL | Stock | 3.265 | 3.265 | 3.265 | 3.265 | 5600.0 |
| 2009-02-03 08:49:00 | AAPL | Stock | 3.2689 | 3.2736 | 3.2657 | 3.2736 | 16800.0 |
| 2009-02-03 08:57:00 | AAPL | Stock | 3.2732 | 3.28 | 3.2732 | 3.28 | 67900.0 |
| 2009-02-03 08:58:00 | AAPL | Stock | 3.28 | 3.2829 | 3.28 | 3.2818 | 51156.0 |
| 2009-02-03 08:59:00 | AAPL | Stock | 3.2814 | 3.2818 | 3.2814 | 3.2814 | 25284.0 |
| 2009-02-03 09:00:00 | AAPL | Stock | 3.2829 | 3.2836 | 3.2821 | 3.2836 | 16800.0 |
| 2009-02-03 09:01:00 | AAPL | Stock | 3.2814 | 3.2911 | 3.2814 | 3.2911 | 169988.0 |
| 2009-02-03 09:02:00 | AAPL | Stock | 3.2957 | 3.2957 | 3.2911 | 3.2911 | 19040.0 |
| 2009-02-03 09:04:00 | AAPL | Stock | 3.2868 | 3.2868 | 3.2868 | 3.2868 | 2800.0 |
| 2009-02-03 09:05:00 | AAPL | Stock | 3.2861 | 3.2861 | 3.2861 | 3.2861 | 2800.0 |
| 2009-02-03 09:07:00 | AAPL | Stock | 3.2904 | 3.2911 | 3.2904 | 3.2911 | 21504.0 |
| 2009-02-03 09:09:00 | AAPL | Stock | 3.2868 | 3.2868 | 3.2868 | 3.2868 | 2800.0 |
| 2009-02-03 09:10:00 | AAPL | Stock | 3.2918 | 3.2918 | 3.2918 | 3.2918 | 19544.0 |
| 2009-02-03 09:11:00 | AAPL | Stock | 3.2918 | 3.2918 | 3.2918 | 3.2918 | 8400.0 |
| 2009-02-03 09:12:00 | AAPL | Stock | 3.2943 | 3.2943 | 3.2929 | 3.2929 | 19964.0 |
| 2009-02-03 09:13:00 | AAPL | Stock | 3.2925 | 3.2925 | 3.2925 | 3.2925 | 28000.0 |
| 2009-02-03 09:14:00 | AAPL | Stock | 3.2918 | 3.2921 | 3.2914 | 3.2921 | 22400.0 |
| 2009-02-03 09:15:00 | AAPL | Stock | 3.2911 | 3.2911 | 3.2911 | 3.2911 | 26544.0 |
| 2009-02-03 09:17:00 | AAPL | Stock | 3.29 | 3.29 | 3.2896 | 3.2896 | 5600.0 |
| 2009-02-03 09:19:00 | AAPL | Stock | 3.2893 | 3.2911 | 3.2893 | 3.2911 | 28784.0 |
| 2009-02-03 09:22:00 | AAPL | Stock | 3.2904 | 3.2907 | 3.2893 | 3.2893 | 8400.0 |
| 2009-02-03 09:25:00 | AAPL | Stock | 3.2889 | 3.2889 | 3.2889 | 3.2889 | 2800.0 |
| 2009-02-03 09:26:00 | AAPL | Stock | 3.2857 | 3.2857 | 3.2857 | 3.2857 | 4480.0 |
| 2009-02-03 09:27:00 | AAPL | Stock | 3.2857 | 3.2889 | 3.2807 | 3.2807 | 283444.0 |
| 2009-02-03 09:28:00 | AAPL | Stock | 3.2821 | 3.2857 | 3.2782 | 3.2804 | 424088.0 |
| 2009-02-03 09:29:00 | AAPL | Stock | 3.2804 | 3.2832 | 3.28 | 3.2804 | 150052.0 |
| 2009-02-03 09:30:00 | AAPL | Stock | 3.2821 | 3.29 | 3.2775 | 3.2875 | 5181288.0 |
| 2009-02-03 09:31:00 | AAPL | Stock | 3.2868 | 3.2886 | 3.2804 | 3.2829 | 3455872.0 |
| 2009-02-03 09:32:00 | AAPL | Stock | 3.2836 | 3.2875 | 3.2796 | 3.2807 | 3267348.0 |
| 2009-02-03 09:33:00 | AAPL | Stock | 3.2825 | 3.2843 | 3.2721 | 3.2742 | 3222772.0 |
| 2009-02-03 09:34:00 | AAPL | Stock | 3.2743 | 3.2793 | 3.2721 | 3.2779 | 2404668.0 |
| 2009-02-03 09:35:00 | AAPL | Stock | 3.2782 | 3.2786 | 3.2725 | 3.2725 | 2139536.0 |
> showing 50 of 1,000,114 rows — these rows as CSV