PREVIEW / stock_5min / 2007-04-12
file: by_date/stock_5min/2007/2007-04-12.parquet size: 3.6 MB rows: 256,560 symbols: 2,573
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 |
|---|---|---|---|---|---|---|---|
| 2007-04-12 04:15:00 | AAPL | Stock | 3.3104 | 3.3104 | 3.3068 | 3.3068 | 7000.0 |
| 2007-04-12 07:25:00 | AAPL | Stock | 3.3043 | 3.3043 | 3.3043 | 3.3043 | 8400.0 |
| 2007-04-12 07:55:00 | AAPL | Stock | 3.3018 | 3.3018 | 3.3018 | 3.3018 | 5600.0 |
| 2007-04-12 08:00:00 | AAPL | Stock | 3.3014 | 3.3032 | 3.2961 | 3.3004 | 60956.0 |
| 2007-04-12 08:05:00 | AAPL | Stock | 3.3 | 3.3018 | 3.2982 | 3.3 | 90328.0 |
| 2007-04-12 08:10:00 | AAPL | Stock | 3.2968 | 3.2968 | 3.2893 | 3.2893 | 262164.0 |
| 2007-04-12 08:15:00 | AAPL | Stock | 3.2929 | 3.2964 | 3.2914 | 3.2914 | 85736.0 |
| 2007-04-12 08:20:00 | AAPL | Stock | 3.2918 | 3.2929 | 3.2893 | 3.2893 | 65492.0 |
| 2007-04-12 08:25:00 | AAPL | Stock | 3.2911 | 3.2911 | 3.2893 | 3.2911 | 46116.0 |
| 2007-04-12 08:30:00 | AAPL | Stock | 3.29 | 3.29 | 3.2889 | 3.2889 | 78344.0 |
| 2007-04-12 08:35:00 | AAPL | Stock | 3.2886 | 3.2889 | 3.2868 | 3.2882 | 122108.0 |
| 2007-04-12 08:40:00 | AAPL | Stock | 3.2893 | 3.2904 | 3.2871 | 3.2882 | 145068.0 |
| 2007-04-12 08:45:00 | AAPL | Stock | 3.2868 | 3.2882 | 3.2868 | 3.2882 | 37968.0 |
| 2007-04-12 08:50:00 | AAPL | Stock | 3.2879 | 3.2911 | 3.2875 | 3.2911 | 81200.0 |
| 2007-04-12 08:55:00 | AAPL | Stock | 3.2925 | 3.2929 | 3.2918 | 3.2929 | 222152.0 |
| 2007-04-12 09:00:00 | AAPL | Stock | 3.2929 | 3.2946 | 3.2914 | 3.2929 | 154868.0 |
| 2007-04-12 09:05:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.29 | 3.29 | 111300.0 |
| 2007-04-12 09:10:00 | AAPL | Stock | 3.2914 | 3.2961 | 3.2904 | 3.2961 | 113540.0 |
| 2007-04-12 09:15:00 | AAPL | Stock | 3.2964 | 3.2975 | 3.2961 | 3.2964 | 65800.0 |
| 2007-04-12 09:20:00 | AAPL | Stock | 3.2946 | 3.2946 | 3.2936 | 3.2936 | 57680.0 |
| 2007-04-12 09:25:00 | AAPL | Stock | 3.2918 | 3.295 | 3.2868 | 3.2879 | 402304.0 |
| 2007-04-12 09:30:00 | AAPL | Stock | 3.2871 | 3.2882 | 3.2739 | 3.2743 | 22436736.0 |
| 2007-04-12 09:35:00 | AAPL | Stock | 3.2746 | 3.2789 | 3.2607 | 3.2607 | 22737792.0 |
| 2007-04-12 09:40:00 | AAPL | Stock | 3.2604 | 3.2643 | 3.2504 | 3.2514 | 24431624.0 |
| 2007-04-12 09:45:00 | AAPL | Stock | 3.2507 | 3.2596 | 3.24 | 3.2543 | 26878208.0 |
| 2007-04-12 09:50:00 | AAPL | Stock | 3.2557 | 3.2575 | 3.2514 | 3.2546 | 13439832.0 |
| 2007-04-12 09:55:00 | AAPL | Stock | 3.2546 | 3.2607 | 3.2511 | 3.2575 | 15104656.0 |
| 2007-04-12 10:00:00 | AAPL | Stock | 3.2571 | 3.2675 | 3.2561 | 3.2666 | 14018676.0 |
| 2007-04-12 10:05:00 | AAPL | Stock | 3.2664 | 3.2693 | 3.2614 | 3.265 | 14802816.0 |
| 2007-04-12 10:10:00 | AAPL | Stock | 3.265 | 3.2654 | 3.2568 | 3.2582 | 10251472.0 |
| 2007-04-12 10:15:00 | AAPL | Stock | 3.2582 | 3.2586 | 3.2532 | 3.2571 | 7699160.0 |
| 2007-04-12 10:20:00 | AAPL | Stock | 3.2575 | 3.2636 | 3.2543 | 3.2632 | 10462648.0 |
| 2007-04-12 10:25:00 | AAPL | Stock | 3.2632 | 3.2721 | 3.2632 | 3.2711 | 16180444.0 |
| 2007-04-12 10:30:00 | AAPL | Stock | 3.27 | 3.2704 | 3.2661 | 3.2668 | 9824696.0 |
| 2007-04-12 10:35:00 | AAPL | Stock | 3.2668 | 3.2721 | 3.2664 | 3.2679 | 7768096.0 |
| 2007-04-12 10:40:00 | AAPL | Stock | 3.2679 | 3.27 | 3.2661 | 3.2675 | 6401360.0 |
| 2007-04-12 10:45:00 | AAPL | Stock | 3.2675 | 3.2775 | 3.2675 | 3.2721 | 11064060.0 |
| 2007-04-12 10:50:00 | AAPL | Stock | 3.2718 | 3.2764 | 3.2696 | 3.2754 | 10473064.0 |
| 2007-04-12 10:55:00 | AAPL | Stock | 3.2754 | 3.2811 | 3.2746 | 3.2793 | 11711532.0 |
| 2007-04-12 11:00:00 | AAPL | Stock | 3.2793 | 3.29 | 3.2768 | 3.2871 | 13501292.0 |
| 2007-04-12 11:05:00 | AAPL | Stock | 3.2857 | 3.2925 | 3.2857 | 3.2907 | 11815692.0 |
| 2007-04-12 11:10:00 | AAPL | Stock | 3.2907 | 3.2968 | 3.29 | 3.2917 | 11600988.0 |
| 2007-04-12 11:15:00 | AAPL | Stock | 3.2914 | 3.2932 | 3.285 | 3.285 | 13249964.0 |
| 2007-04-12 11:20:00 | AAPL | Stock | 3.285 | 3.2886 | 3.2825 | 3.2854 | 10644760.0 |
| 2007-04-12 11:25:00 | AAPL | Stock | 3.2854 | 3.2882 | 3.2832 | 3.2871 | 5929280.0 |
| 2007-04-12 11:30:00 | AAPL | Stock | 3.2871 | 3.2875 | 3.2825 | 3.2839 | 5176052.0 |
| 2007-04-12 11:35:00 | AAPL | Stock | 3.2829 | 3.2836 | 3.2786 | 3.2796 | 6648880.0 |
| 2007-04-12 11:40:00 | AAPL | Stock | 3.2796 | 3.28 | 3.2711 | 3.2764 | 9830828.0 |
| 2007-04-12 11:45:00 | AAPL | Stock | 3.2757 | 3.2771 | 3.2732 | 3.2757 | 4020436.0 |
| 2007-04-12 11:50:00 | AAPL | Stock | 3.2757 | 3.2811 | 3.2757 | 3.2793 | 6784820.0 |
> showing 50 of 256,560 rows — these rows as CSV