PREVIEW / stock_1min / 2008-02-26
file: by_date/stock_1min/2008/2008-02-26.parquet size: 12.6 MB rows: 1,022,327 symbols: 2,660
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 |
|---|---|---|---|---|---|---|---|
| 2008-02-26 04:21:00 | AAPL | Stock | 4.2843 | 4.285 | 4.2843 | 4.285 | 14000.0 |
| 2008-02-26 04:26:00 | AAPL | Stock | 4.285 | 4.285 | 4.285 | 4.285 | 2800.0 |
| 2008-02-26 04:27:00 | AAPL | Stock | 4.2893 | 4.2893 | 4.2893 | 4.2893 | 28000.0 |
| 2008-02-26 04:52:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2946 | 4.2946 | 4340.0 |
| 2008-02-26 05:27:00 | AAPL | Stock | 4.29 | 4.2907 | 4.29 | 4.2907 | 14000.0 |
| 2008-02-26 05:28:00 | AAPL | Stock | 4.2907 | 4.2907 | 4.2907 | 4.2907 | 2800.0 |
| 2008-02-26 05:35:00 | AAPL | Stock | 4.2854 | 4.2871 | 4.2854 | 4.2871 | 22400.0 |
| 2008-02-26 05:55:00 | AAPL | Stock | 4.2879 | 4.2911 | 4.2879 | 4.2911 | 53312.0 |
| 2008-02-26 06:01:00 | AAPL | Stock | 4.2886 | 4.2886 | 4.2886 | 4.2886 | 5600.0 |
| 2008-02-26 06:13:00 | AAPL | Stock | 4.2957 | 4.2957 | 4.2925 | 4.2925 | 5600.0 |
| 2008-02-26 06:18:00 | AAPL | Stock | 4.2821 | 4.2821 | 4.2821 | 4.2821 | 28000.0 |
| 2008-02-26 06:57:00 | AAPL | Stock | 4.2857 | 4.2857 | 4.2857 | 4.2857 | 16800.0 |
| 2008-02-26 07:04:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2857 | 4.2857 | 9520.0 |
| 2008-02-26 07:05:00 | AAPL | Stock | 4.2861 | 4.2861 | 4.2861 | 4.2861 | 4200.0 |
| 2008-02-26 07:13:00 | AAPL | Stock | 4.2946 | 4.2946 | 4.2946 | 4.2946 | 16800.0 |
| 2008-02-26 07:14:00 | AAPL | Stock | 4.2964 | 4.2964 | 4.2964 | 4.2964 | 14000.0 |
| 2008-02-26 07:19:00 | AAPL | Stock | 4.3 | 4.3 | 4.3 | 4.3 | 5600.0 |
| 2008-02-26 07:20:00 | AAPL | Stock | 4.2896 | 4.2896 | 4.2896 | 4.2896 | 8400.0 |
| 2008-02-26 07:21:00 | AAPL | Stock | 4.2857 | 4.2896 | 4.2857 | 4.2857 | 26880.0 |
| 2008-02-26 07:23:00 | AAPL | Stock | 4.2929 | 4.2929 | 4.2929 | 4.2929 | 8288.0 |
| 2008-02-26 07:26:00 | AAPL | Stock | 4.2929 | 4.2964 | 4.2929 | 4.2964 | 5600.0 |
| 2008-02-26 07:28:00 | AAPL | Stock | 4.2929 | 4.2929 | 4.2929 | 4.2929 | 2800.0 |
| 2008-02-26 07:31:00 | AAPL | Stock | 4.2929 | 4.2929 | 4.2929 | 4.2929 | 12488.0 |
| 2008-02-26 07:32:00 | AAPL | Stock | 4.2914 | 4.2914 | 4.2911 | 4.2911 | 26600.0 |
| 2008-02-26 07:37:00 | AAPL | Stock | 4.2875 | 4.2879 | 4.2875 | 4.2879 | 8400.0 |
| 2008-02-26 07:39:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 142800.0 |
| 2008-02-26 07:40:00 | AAPL | Stock | 4.2921 | 4.2921 | 4.2921 | 4.2921 | 4200.0 |
| 2008-02-26 07:44:00 | AAPL | Stock | 4.2979 | 4.2979 | 4.2979 | 4.2979 | 14000.0 |
| 2008-02-26 07:45:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 12600.0 |
| 2008-02-26 07:46:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 28000.0 |
| 2008-02-26 07:48:00 | AAPL | Stock | 4.2893 | 4.2893 | 4.2893 | 4.2893 | 2800.0 |
| 2008-02-26 07:49:00 | AAPL | Stock | 4.2871 | 4.2871 | 4.2871 | 4.2871 | 11200.0 |
| 2008-02-26 07:50:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 70000.0 |
| 2008-02-26 07:51:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 2800.0 |
| 2008-02-26 07:52:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 28000.0 |
| 2008-02-26 07:54:00 | AAPL | Stock | 4.2864 | 4.2864 | 4.2864 | 4.2864 | 2800.0 |
| 2008-02-26 07:57:00 | AAPL | Stock | 4.2821 | 4.2821 | 4.2804 | 4.2804 | 19600.0 |
| 2008-02-26 07:58:00 | AAPL | Stock | 4.28 | 4.2807 | 4.28 | 4.2807 | 26600.0 |
| 2008-02-26 08:00:00 | AAPL | Stock | 4.2764 | 4.2807 | 4.2675 | 4.2796 | 80976.0 |
| 2008-02-26 08:01:00 | AAPL | Stock | 4.2768 | 4.2786 | 4.2739 | 4.2754 | 128520.0 |
| 2008-02-26 08:02:00 | AAPL | Stock | 4.2786 | 4.2786 | 4.2714 | 4.2714 | 33600.0 |
| 2008-02-26 08:03:00 | AAPL | Stock | 4.2679 | 4.2679 | 4.2668 | 4.2668 | 30968.0 |
| 2008-02-26 08:04:00 | AAPL | Stock | 4.2668 | 4.2679 | 4.2668 | 4.2679 | 21000.0 |
| 2008-02-26 08:05:00 | AAPL | Stock | 4.2618 | 4.2632 | 4.2589 | 4.2589 | 50400.0 |
| 2008-02-26 08:06:00 | AAPL | Stock | 4.2589 | 4.2629 | 4.2561 | 4.2561 | 144480.0 |
| 2008-02-26 08:07:00 | AAPL | Stock | 4.2539 | 4.2586 | 4.2539 | 4.2586 | 79212.0 |
| 2008-02-26 08:08:00 | AAPL | Stock | 4.2618 | 4.2618 | 4.2618 | 4.2618 | 2800.0 |
| 2008-02-26 08:09:00 | AAPL | Stock | 4.2611 | 4.2618 | 4.2607 | 4.2618 | 17472.0 |
| 2008-02-26 08:10:00 | AAPL | Stock | 4.2618 | 4.2625 | 4.26 | 4.26 | 52640.0 |
| 2008-02-26 08:11:00 | AAPL | Stock | 4.26 | 4.2607 | 4.2589 | 4.2589 | 22260.0 |
> showing 50 of 1,022,327 rows — these rows as CSV