PREVIEW / stock_1min / 2008-04-30
file: by_date/stock_1min/2008/2008-04-30.parquet size: 12.2 MB rows: 975,549 symbols: 2,683
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-04-30 04:18:00 | AAPL | Stock | 6.2318 | 6.2318 | 6.2318 | 6.2318 | 2800.0 |
| 2008-04-30 06:55:00 | AAPL | Stock | 6.2336 | 6.2336 | 6.2336 | 6.2336 | 2800.0 |
| 2008-04-30 07:37:00 | AAPL | Stock | 6.2668 | 6.2668 | 6.2668 | 6.2668 | 2800.0 |
| 2008-04-30 07:39:00 | AAPL | Stock | 6.2657 | 6.2657 | 6.2657 | 6.2657 | 2800.0 |
| 2008-04-30 07:43:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.25 | 6.25 | 46200.0 |
| 2008-04-30 07:44:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 39200.0 |
| 2008-04-30 07:45:00 | AAPL | Stock | 6.25 | 6.25 | 6.25 | 6.25 | 78400.0 |
| 2008-04-30 08:00:00 | AAPL | Stock | 6.2529 | 6.2571 | 6.2446 | 6.25 | 103964.0 |
| 2008-04-30 08:01:00 | AAPL | Stock | 6.2536 | 6.2536 | 6.2504 | 6.2504 | 28392.0 |
| 2008-04-30 08:02:00 | AAPL | Stock | 6.2539 | 6.2571 | 6.2536 | 6.2571 | 33600.0 |
| 2008-04-30 08:03:00 | AAPL | Stock | 6.2571 | 6.2589 | 6.2571 | 6.2589 | 44800.0 |
| 2008-04-30 08:04:00 | AAPL | Stock | 6.2636 | 6.2679 | 6.2589 | 6.2589 | 292180.0 |
| 2008-04-30 08:05:00 | AAPL | Stock | 6.2639 | 6.2661 | 6.2639 | 6.265 | 46200.0 |
| 2008-04-30 08:06:00 | AAPL | Stock | 6.2646 | 6.2707 | 6.2643 | 6.2671 | 140700.0 |
| 2008-04-30 08:07:00 | AAPL | Stock | 6.2643 | 6.2654 | 6.2643 | 6.2654 | 197540.0 |
| 2008-04-30 08:08:00 | AAPL | Stock | 6.2671 | 6.2736 | 6.2657 | 6.2686 | 210728.0 |
| 2008-04-30 08:09:00 | AAPL | Stock | 6.2739 | 6.2768 | 6.2714 | 6.2768 | 67928.0 |
| 2008-04-30 08:10:00 | AAPL | Stock | 6.275 | 6.275 | 6.2739 | 6.275 | 23940.0 |
| 2008-04-30 08:11:00 | AAPL | Stock | 6.2768 | 6.2821 | 6.2739 | 6.2739 | 139356.0 |
| 2008-04-30 08:12:00 | AAPL | Stock | 6.2761 | 6.2786 | 6.275 | 6.2771 | 39200.0 |
| 2008-04-30 08:13:00 | AAPL | Stock | 6.2782 | 6.2821 | 6.2775 | 6.2821 | 226800.0 |
| 2008-04-30 08:14:00 | AAPL | Stock | 6.2818 | 6.2821 | 6.2786 | 6.2793 | 39900.0 |
| 2008-04-30 08:15:00 | AAPL | Stock | 6.2782 | 6.2875 | 6.2739 | 6.2857 | 372176.0 |
| 2008-04-30 08:16:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2804 | 6.2857 | 153972.0 |
| 2008-04-30 08:17:00 | AAPL | Stock | 6.2857 | 6.2857 | 6.2839 | 6.2857 | 147476.0 |
| 2008-04-30 08:18:00 | AAPL | Stock | 6.2861 | 6.2861 | 6.2818 | 6.2821 | 99400.0 |
| 2008-04-30 08:19:00 | AAPL | Stock | 6.2821 | 6.2821 | 6.2821 | 6.2821 | 5600.0 |
| 2008-04-30 08:20:00 | AAPL | Stock | 6.2843 | 6.2889 | 6.2839 | 6.2889 | 138516.0 |
| 2008-04-30 08:21:00 | AAPL | Stock | 6.2868 | 6.2868 | 6.2843 | 6.2843 | 50400.0 |
| 2008-04-30 08:22:00 | AAPL | Stock | 6.2821 | 6.2843 | 6.2814 | 6.2814 | 82180.0 |
| 2008-04-30 08:23:00 | AAPL | Stock | 6.2821 | 6.2821 | 6.2786 | 6.2786 | 65800.0 |
| 2008-04-30 08:24:00 | AAPL | Stock | 6.2771 | 6.2786 | 6.2768 | 6.2771 | 31080.0 |
| 2008-04-30 08:25:00 | AAPL | Stock | 6.2796 | 6.2832 | 6.2796 | 6.2804 | 11480.0 |
| 2008-04-30 08:26:00 | AAPL | Stock | 6.2789 | 6.2857 | 6.2771 | 6.2839 | 166600.0 |
| 2008-04-30 08:27:00 | AAPL | Stock | 6.2825 | 6.2825 | 6.2821 | 6.2821 | 8400.0 |
| 2008-04-30 08:28:00 | AAPL | Stock | 6.2814 | 6.2814 | 6.28 | 6.28 | 25200.0 |
| 2008-04-30 08:29:00 | AAPL | Stock | 6.2825 | 6.2825 | 6.2804 | 6.2821 | 16800.0 |
| 2008-04-30 08:30:00 | AAPL | Stock | 6.2843 | 6.2993 | 6.2825 | 6.2993 | 547008.0 |
| 2008-04-30 08:31:00 | AAPL | Stock | 6.2986 | 6.3036 | 6.2946 | 6.2964 | 367024.0 |
| 2008-04-30 08:32:00 | AAPL | Stock | 6.2954 | 6.2957 | 6.2911 | 6.2939 | 143192.0 |
| 2008-04-30 08:33:00 | AAPL | Stock | 6.2925 | 6.2982 | 6.2911 | 6.2982 | 270648.0 |
| 2008-04-30 08:34:00 | AAPL | Stock | 6.295 | 6.2964 | 6.295 | 6.295 | 28000.0 |
| 2008-04-30 08:35:00 | AAPL | Stock | 6.2946 | 6.295 | 6.2868 | 6.2868 | 184576.0 |
| 2008-04-30 08:36:00 | AAPL | Stock | 6.2861 | 6.2907 | 6.2861 | 6.2896 | 47600.0 |
| 2008-04-30 08:37:00 | AAPL | Stock | 6.2882 | 6.2886 | 6.2864 | 6.2871 | 81200.0 |
| 2008-04-30 08:38:00 | AAPL | Stock | 6.2864 | 6.2889 | 6.2543 | 6.285 | 257712.0 |
| 2008-04-30 08:39:00 | AAPL | Stock | 6.285 | 6.2854 | 6.2829 | 6.2839 | 39200.0 |
| 2008-04-30 08:40:00 | AAPL | Stock | 6.2839 | 6.2857 | 6.2839 | 6.2857 | 104076.0 |
| 2008-04-30 08:41:00 | AAPL | Stock | 6.2854 | 6.2854 | 6.2818 | 6.2832 | 196560.0 |
| 2008-04-30 08:42:00 | AAPL | Stock | 6.2821 | 6.2857 | 6.2804 | 6.2857 | 121240.0 |
> showing 50 of 975,549 rows — these rows as CSV