PREVIEW / stock_5min / 2005-06-14
file: by_date/stock_5min/2005/2005-06-14.parquet size: 2.7 MB rows: 197,344 symbols: 1,993
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-06-14 08:20:00 | AAPL | Stock | 1.2825 | 1.2839 | 1.2825 | 1.2839 | 64400.0 |
| 2005-06-14 08:25:00 | AAPL | Stock | 1.2843 | 1.2846 | 1.2843 | 1.2846 | 19628.0 |
| 2005-06-14 08:30:00 | AAPL | Stock | 1.285 | 1.2889 | 1.285 | 1.2868 | 25172.0 |
| 2005-06-14 08:35:00 | AAPL | Stock | 1.2889 | 1.2889 | 1.2889 | 1.2889 | 34160.0 |
| 2005-06-14 08:40:00 | AAPL | Stock | 1.2893 | 1.2893 | 1.2893 | 1.2893 | 28000.0 |
| 2005-06-14 08:45:00 | AAPL | Stock | 1.2893 | 1.2929 | 1.2893 | 1.2929 | 131600.0 |
| 2005-06-14 08:50:00 | AAPL | Stock | 1.2932 | 1.2936 | 1.2918 | 1.2918 | 100800.0 |
| 2005-06-14 08:55:00 | AAPL | Stock | 1.2929 | 1.2929 | 1.29 | 1.29 | 42000.0 |
| 2005-06-14 09:00:00 | AAPL | Stock | 1.29 | 1.2911 | 1.29 | 1.2911 | 28000.0 |
| 2005-06-14 09:05:00 | AAPL | Stock | 1.2907 | 1.2907 | 1.2907 | 1.2907 | 2800.0 |
| 2005-06-14 09:10:00 | AAPL | Stock | 1.2911 | 1.2911 | 1.2896 | 1.2896 | 99680.0 |
| 2005-06-14 09:15:00 | AAPL | Stock | 1.2904 | 1.2904 | 1.2904 | 1.2904 | 14000.0 |
| 2005-06-14 09:20:00 | AAPL | Stock | 1.2893 | 1.2893 | 1.2871 | 1.2871 | 170520.0 |
| 2005-06-14 09:25:00 | AAPL | Stock | 1.2868 | 1.2868 | 1.2857 | 1.2861 | 233352.0 |
| 2005-06-14 09:30:00 | AAPL | Stock | 1.2829 | 1.2911 | 1.2804 | 1.2882 | 16890160.0 |
| 2005-06-14 09:35:00 | AAPL | Stock | 1.2879 | 1.2889 | 1.2786 | 1.2793 | 11548180.0 |
| 2005-06-14 09:40:00 | AAPL | Stock | 1.2789 | 1.2861 | 1.2789 | 1.2861 | 11566576.0 |
| 2005-06-14 09:45:00 | AAPL | Stock | 1.2861 | 1.2893 | 1.2814 | 1.2814 | 10049816.0 |
| 2005-06-14 09:50:00 | AAPL | Stock | 1.2814 | 1.285 | 1.2775 | 1.2821 | 13901384.0 |
| 2005-06-14 09:55:00 | AAPL | Stock | 1.2818 | 1.2846 | 1.2782 | 1.2843 | 6777484.0 |
| 2005-06-14 10:00:00 | AAPL | Stock | 1.2846 | 1.2846 | 1.2789 | 1.2821 | 4370576.0 |
| 2005-06-14 10:05:00 | AAPL | Stock | 1.2821 | 1.2893 | 1.2814 | 1.2868 | 12718440.0 |
| 2005-06-14 10:10:00 | AAPL | Stock | 1.2868 | 1.2868 | 1.2839 | 1.285 | 5083876.0 |
| 2005-06-14 10:15:00 | AAPL | Stock | 1.2846 | 1.2854 | 1.2829 | 1.2832 | 1673308.0 |
| 2005-06-14 10:20:00 | AAPL | Stock | 1.2832 | 1.2832 | 1.2786 | 1.2796 | 6886852.0 |
| 2005-06-14 10:25:00 | AAPL | Stock | 1.28 | 1.2811 | 1.2768 | 1.2804 | 6084932.0 |
| 2005-06-14 10:30:00 | AAPL | Stock | 1.2804 | 1.2811 | 1.2768 | 1.2786 | 3871224.0 |
| 2005-06-14 10:35:00 | AAPL | Stock | 1.2786 | 1.2811 | 1.2782 | 1.2807 | 4221476.0 |
| 2005-06-14 10:40:00 | AAPL | Stock | 1.2804 | 1.2854 | 1.2796 | 1.2836 | 6332760.0 |
| 2005-06-14 10:45:00 | AAPL | Stock | 1.2836 | 1.2839 | 1.2814 | 1.2825 | 2402344.0 |
| 2005-06-14 10:50:00 | AAPL | Stock | 1.2829 | 1.2843 | 1.2818 | 1.2832 | 2157540.0 |
| 2005-06-14 10:55:00 | AAPL | Stock | 1.2832 | 1.2843 | 1.2796 | 1.2825 | 1807008.0 |
| 2005-06-14 11:00:00 | AAPL | Stock | 1.2825 | 1.2843 | 1.2818 | 1.2832 | 1519168.0 |
| 2005-06-14 11:05:00 | AAPL | Stock | 1.2832 | 1.2861 | 1.2825 | 1.2857 | 2325820.0 |
| 2005-06-14 11:10:00 | AAPL | Stock | 1.2857 | 1.2875 | 1.2854 | 1.2864 | 4656764.0 |
| 2005-06-14 11:15:00 | AAPL | Stock | 1.2868 | 1.2871 | 1.2843 | 1.2847 | 2137660.0 |
| 2005-06-14 11:20:00 | AAPL | Stock | 1.285 | 1.285 | 1.2818 | 1.2821 | 2381232.0 |
| 2005-06-14 11:25:00 | AAPL | Stock | 1.2818 | 1.2832 | 1.2818 | 1.2821 | 2772840.0 |
| 2005-06-14 11:30:00 | AAPL | Stock | 1.2818 | 1.2821 | 1.2814 | 1.2821 | 1229256.0 |
| 2005-06-14 11:35:00 | AAPL | Stock | 1.2821 | 1.2843 | 1.2807 | 1.2814 | 3992688.0 |
| 2005-06-14 11:40:00 | AAPL | Stock | 1.2814 | 1.2825 | 1.2811 | 1.2818 | 3578680.0 |
| 2005-06-14 11:45:00 | AAPL | Stock | 1.2818 | 1.2836 | 1.2817 | 1.2836 | 1667092.0 |
| 2005-06-14 11:50:00 | AAPL | Stock | 1.2836 | 1.2839 | 1.2825 | 1.2829 | 1667064.0 |
| 2005-06-14 11:55:00 | AAPL | Stock | 1.2832 | 1.2839 | 1.2829 | 1.2839 | 920248.0 |
| 2005-06-14 12:00:00 | AAPL | Stock | 1.2836 | 1.2846 | 1.2836 | 1.2846 | 1787212.0 |
| 2005-06-14 12:05:00 | AAPL | Stock | 1.2846 | 1.2846 | 1.2818 | 1.2825 | 2048592.0 |
| 2005-06-14 12:10:00 | AAPL | Stock | 1.2821 | 1.2836 | 1.2818 | 1.2832 | 1015252.0 |
| 2005-06-14 12:15:00 | AAPL | Stock | 1.2836 | 1.2854 | 1.2832 | 1.2854 | 1773296.0 |
| 2005-06-14 12:20:00 | AAPL | Stock | 1.2854 | 1.2854 | 1.2825 | 1.2836 | 2493904.0 |
| 2005-06-14 12:25:00 | AAPL | Stock | 1.2836 | 1.2836 | 1.2825 | 1.2829 | 1681428.0 |
> showing 50 of 197,344 rows — these rows as CSV