PREVIEW / stock_5min / 2005-04-29
file: by_date/stock_5min/2005/2005-04-29.parquet size: 2.8 MB rows: 200,712 symbols: 1,970
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 |
|---|---|---|---|---|---|---|---|
| 2005-04-29 07:55:00 | AAPL | Stock | 1.2843 | 1.2857 | 1.2843 | 1.2843 | 82600.0 |
| 2005-04-29 08:00:00 | AAPL | Stock | 1.2843 | 1.2893 | 1.2836 | 1.2868 | 672840.0 |
| 2005-04-29 08:05:00 | AAPL | Stock | 1.2861 | 1.2864 | 1.2839 | 1.2857 | 180964.0 |
| 2005-04-29 08:10:00 | AAPL | Stock | 1.2857 | 1.2857 | 1.285 | 1.2854 | 175000.0 |
| 2005-04-29 08:15:00 | AAPL | Stock | 1.285 | 1.2861 | 1.285 | 1.285 | 122304.0 |
| 2005-04-29 08:20:00 | AAPL | Stock | 1.285 | 1.2854 | 1.2839 | 1.2839 | 40460.0 |
| 2005-04-29 08:25:00 | AAPL | Stock | 1.2839 | 1.2854 | 1.2825 | 1.2854 | 147000.0 |
| 2005-04-29 08:30:00 | AAPL | Stock | 1.2854 | 1.2907 | 1.2854 | 1.2886 | 626836.0 |
| 2005-04-29 08:35:00 | AAPL | Stock | 1.2904 | 1.2911 | 1.2893 | 1.2904 | 438032.0 |
| 2005-04-29 08:40:00 | AAPL | Stock | 1.2911 | 1.2929 | 1.2893 | 1.2893 | 248864.0 |
| 2005-04-29 08:45:00 | AAPL | Stock | 1.2879 | 1.2911 | 1.2879 | 1.2879 | 114800.0 |
| 2005-04-29 08:50:00 | AAPL | Stock | 1.2879 | 1.2879 | 1.2857 | 1.2857 | 81200.0 |
| 2005-04-29 08:55:00 | AAPL | Stock | 1.2861 | 1.2861 | 1.2857 | 1.2861 | 51520.0 |
| 2005-04-29 09:00:00 | AAPL | Stock | 1.2868 | 1.2879 | 1.2868 | 1.2879 | 259560.0 |
| 2005-04-29 09:05:00 | AAPL | Stock | 1.2864 | 1.2879 | 1.2864 | 1.2875 | 193200.0 |
| 2005-04-29 09:10:00 | AAPL | Stock | 1.2879 | 1.2886 | 1.2864 | 1.2868 | 207480.0 |
| 2005-04-29 09:15:00 | AAPL | Stock | 1.2882 | 1.2886 | 1.2857 | 1.2857 | 221200.0 |
| 2005-04-29 09:20:00 | AAPL | Stock | 1.2861 | 1.2864 | 1.2861 | 1.2861 | 173600.0 |
| 2005-04-29 09:25:00 | AAPL | Stock | 1.2861 | 1.29 | 1.2693 | 1.29 | 1708476.0 |
| 2005-04-29 09:30:00 | AAPL | Stock | 1.2911 | 1.2939 | 1.2839 | 1.2843 | 28602196.0 |
| 2005-04-29 09:35:00 | AAPL | Stock | 1.2839 | 1.2893 | 1.2811 | 1.2846 | 12849648.0 |
| 2005-04-29 09:40:00 | AAPL | Stock | 1.2846 | 1.2857 | 1.2811 | 1.2821 | 8088780.0 |
| 2005-04-29 09:45:00 | AAPL | Stock | 1.2821 | 1.285 | 1.2789 | 1.2811 | 7889644.0 |
| 2005-04-29 09:50:00 | AAPL | Stock | 1.2811 | 1.2832 | 1.2779 | 1.2804 | 7508704.0 |
| 2005-04-29 09:55:00 | AAPL | Stock | 1.2804 | 1.2886 | 1.2804 | 1.2882 | 11113928.0 |
| 2005-04-29 10:00:00 | AAPL | Stock | 1.2882 | 1.2936 | 1.2814 | 1.2815 | 18262552.0 |
| 2005-04-29 10:05:00 | AAPL | Stock | 1.2814 | 1.2836 | 1.2729 | 1.2807 | 17497536.0 |
| 2005-04-29 10:10:00 | AAPL | Stock | 1.2807 | 1.2836 | 1.2779 | 1.2825 | 12948992.0 |
| 2005-04-29 10:15:00 | AAPL | Stock | 1.2825 | 1.2839 | 1.2807 | 1.2814 | 6893012.0 |
| 2005-04-29 10:20:00 | AAPL | Stock | 1.2814 | 1.2843 | 1.2782 | 1.2782 | 6776924.0 |
| 2005-04-29 10:25:00 | AAPL | Stock | 1.2782 | 1.2821 | 1.2754 | 1.2796 | 9961280.0 |
| 2005-04-29 10:30:00 | AAPL | Stock | 1.2796 | 1.2814 | 1.2768 | 1.2793 | 7632520.0 |
| 2005-04-29 10:35:00 | AAPL | Stock | 1.2782 | 1.2793 | 1.2729 | 1.2757 | 17551184.0 |
| 2005-04-29 10:40:00 | AAPL | Stock | 1.2761 | 1.2768 | 1.2671 | 1.2675 | 16010624.0 |
| 2005-04-29 10:45:00 | AAPL | Stock | 1.2675 | 1.2686 | 1.2579 | 1.2611 | 22177680.0 |
| 2005-04-29 10:50:00 | AAPL | Stock | 1.2618 | 1.2664 | 1.2607 | 1.2639 | 10935932.0 |
| 2005-04-29 10:55:00 | AAPL | Stock | 1.2643 | 1.2696 | 1.2639 | 1.2689 | 9372664.0 |
| 2005-04-29 11:00:00 | AAPL | Stock | 1.2686 | 1.2805 | 1.2661 | 1.2686 | 7644252.0 |
| 2005-04-29 11:05:00 | AAPL | Stock | 1.2686 | 1.2757 | 1.2671 | 1.2732 | 9251312.0 |
| 2005-04-29 11:10:00 | AAPL | Stock | 1.2729 | 1.2732 | 1.2664 | 1.2675 | 7817348.0 |
| 2005-04-29 11:15:00 | AAPL | Stock | 1.2679 | 1.2707 | 1.2668 | 1.2686 | 5971168.0 |
| 2005-04-29 11:20:00 | AAPL | Stock | 1.2686 | 1.2689 | 1.2643 | 1.2661 | 6924148.0 |
| 2005-04-29 11:25:00 | AAPL | Stock | 1.2661 | 1.2704 | 1.265 | 1.2704 | 5844692.0 |
| 2005-04-29 11:30:00 | AAPL | Stock | 1.2704 | 1.2714 | 1.2671 | 1.2704 | 7693056.0 |
| 2005-04-29 11:35:00 | AAPL | Stock | 1.27 | 1.2743 | 1.27 | 1.2732 | 5071668.0 |
| 2005-04-29 11:40:00 | AAPL | Stock | 1.2732 | 1.2743 | 1.2657 | 1.2675 | 5757528.0 |
| 2005-04-29 11:45:00 | AAPL | Stock | 1.2675 | 1.2714 | 1.2671 | 1.2707 | 3847872.0 |
| 2005-04-29 11:50:00 | AAPL | Stock | 1.2711 | 1.2732 | 1.2689 | 1.2714 | 4485152.0 |
| 2005-04-29 11:55:00 | AAPL | Stock | 1.2711 | 1.2743 | 1.2693 | 1.2721 | 4846184.0 |
| 2005-04-29 12:00:00 | AAPL | Stock | 1.2718 | 1.2739 | 1.2696 | 1.2725 | 3476200.0 |
> showing 50 of 200,712 rows — these rows as CSV