PREVIEW / stock_5min / 2002-11-08
file: by_date/stock_5min/2002/2002-11-08.parquet size: 1.9 MB rows: 127,736 symbols: 1,470
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 |
|---|---|---|---|---|---|---|---|
| 2002-11-08 08:35:00 | AAPL | Stock | 0.2886 | 0.2886 | 0.2886 | 0.2886 | 50400.0 |
| 2002-11-08 09:00:00 | AAPL | Stock | 0.2861 | 0.2861 | 0.2861 | 0.2861 | 44800.0 |
| 2002-11-08 09:10:00 | AAPL | Stock | 0.2861 | 0.2861 | 0.2861 | 0.2861 | 56000.0 |
| 2002-11-08 09:25:00 | AAPL | Stock | 0.2884 | 0.2884 | 0.2857 | 0.2861 | 162400.0 |
| 2002-11-08 09:30:00 | AAPL | Stock | 0.2861 | 0.2864 | 0.285 | 0.285 | 4240712.0 |
| 2002-11-08 09:35:00 | AAPL | Stock | 0.2859 | 0.2875 | 0.285 | 0.2868 | 4088392.0 |
| 2002-11-08 09:40:00 | AAPL | Stock | 0.2866 | 0.2873 | 0.2859 | 0.2863 | 2236304.0 |
| 2002-11-08 09:45:00 | AAPL | Stock | 0.2864 | 0.2882 | 0.2857 | 0.2877 | 5429200.0 |
| 2002-11-08 09:50:00 | AAPL | Stock | 0.2873 | 0.2877 | 0.2866 | 0.2875 | 2458848.0 |
| 2002-11-08 09:55:00 | AAPL | Stock | 0.2875 | 0.2893 | 0.2866 | 0.2893 | 3740800.0 |
| 2002-11-08 10:00:00 | AAPL | Stock | 0.2893 | 0.2893 | 0.2871 | 0.2884 | 3623200.0 |
| 2002-11-08 10:05:00 | AAPL | Stock | 0.2884 | 0.2884 | 0.2873 | 0.2877 | 2957976.0 |
| 2002-11-08 10:10:00 | AAPL | Stock | 0.2879 | 0.2879 | 0.2863 | 0.2864 | 2840040.0 |
| 2002-11-08 10:15:00 | AAPL | Stock | 0.2875 | 0.2877 | 0.2859 | 0.2866 | 3981600.0 |
| 2002-11-08 10:20:00 | AAPL | Stock | 0.2863 | 0.287 | 0.2859 | 0.2859 | 2587200.0 |
| 2002-11-08 10:25:00 | AAPL | Stock | 0.2857 | 0.2866 | 0.2857 | 0.2861 | 1719760.0 |
| 2002-11-08 10:30:00 | AAPL | Stock | 0.2857 | 0.2866 | 0.2855 | 0.2859 | 3456096.0 |
| 2002-11-08 10:35:00 | AAPL | Stock | 0.2861 | 0.2863 | 0.2855 | 0.2859 | 2716000.0 |
| 2002-11-08 10:40:00 | AAPL | Stock | 0.2861 | 0.2868 | 0.2859 | 0.2864 | 1564584.0 |
| 2002-11-08 10:45:00 | AAPL | Stock | 0.2866 | 0.2868 | 0.2857 | 0.2857 | 1943200.0 |
| 2002-11-08 10:50:00 | AAPL | Stock | 0.2857 | 0.2859 | 0.2843 | 0.2854 | 2910544.0 |
| 2002-11-08 10:55:00 | AAPL | Stock | 0.2852 | 0.2855 | 0.2845 | 0.2852 | 1220800.0 |
| 2002-11-08 11:00:00 | AAPL | Stock | 0.2852 | 0.2855 | 0.2846 | 0.2846 | 1820000.0 |
| 2002-11-08 11:05:00 | AAPL | Stock | 0.2846 | 0.2846 | 0.282 | 0.282 | 2201248.0 |
| 2002-11-08 11:10:00 | AAPL | Stock | 0.282 | 0.2821 | 0.2786 | 0.2796 | 5158832.0 |
| 2002-11-08 11:15:00 | AAPL | Stock | 0.2796 | 0.2808 | 0.2796 | 0.2805 | 1690920.0 |
| 2002-11-08 11:20:00 | AAPL | Stock | 0.2807 | 0.2809 | 0.2798 | 0.2804 | 1730400.0 |
| 2002-11-08 11:25:00 | AAPL | Stock | 0.2804 | 0.2804 | 0.2793 | 0.2798 | 1646344.0 |
| 2002-11-08 11:30:00 | AAPL | Stock | 0.2795 | 0.2798 | 0.2789 | 0.2798 | 2145808.0 |
| 2002-11-08 11:35:00 | AAPL | Stock | 0.28 | 0.2807 | 0.2795 | 0.2802 | 1808800.0 |
| 2002-11-08 11:40:00 | AAPL | Stock | 0.2804 | 0.2811 | 0.2795 | 0.2811 | 828800.0 |
| 2002-11-08 11:45:00 | AAPL | Stock | 0.2811 | 0.282 | 0.2805 | 0.2807 | 1450400.0 |
| 2002-11-08 11:50:00 | AAPL | Stock | 0.2804 | 0.2807 | 0.2795 | 0.2802 | 1708504.0 |
| 2002-11-08 11:55:00 | AAPL | Stock | 0.2802 | 0.2804 | 0.2791 | 0.28 | 1618400.0 |
| 2002-11-08 12:00:00 | AAPL | Stock | 0.28 | 0.2804 | 0.2795 | 0.2795 | 4082400.0 |
| 2002-11-08 12:05:00 | AAPL | Stock | 0.2795 | 0.2798 | 0.2795 | 0.2796 | 789600.0 |
| 2002-11-08 12:10:00 | AAPL | Stock | 0.2796 | 0.2804 | 0.2795 | 0.2804 | 1244152.0 |
| 2002-11-08 12:15:00 | AAPL | Stock | 0.2802 | 0.2804 | 0.2802 | 0.2802 | 414400.0 |
| 2002-11-08 12:20:00 | AAPL | Stock | 0.2802 | 0.2804 | 0.2796 | 0.2804 | 1444800.0 |
| 2002-11-08 12:25:00 | AAPL | Stock | 0.2802 | 0.2803 | 0.2795 | 0.28 | 436800.0 |
| 2002-11-08 12:30:00 | AAPL | Stock | 0.2795 | 0.2804 | 0.2795 | 0.28 | 862400.0 |
| 2002-11-08 12:35:00 | AAPL | Stock | 0.2798 | 0.28 | 0.2797 | 0.2798 | 520800.0 |
| 2002-11-08 12:40:00 | AAPL | Stock | 0.2799 | 0.2799 | 0.2779 | 0.2782 | 3131520.0 |
| 2002-11-08 12:45:00 | AAPL | Stock | 0.2782 | 0.2782 | 0.2777 | 0.2779 | 701512.0 |
| 2002-11-08 12:50:00 | AAPL | Stock | 0.2779 | 0.2782 | 0.2779 | 0.2779 | 1248800.0 |
| 2002-11-08 12:55:00 | AAPL | Stock | 0.2782 | 0.2796 | 0.2782 | 0.2796 | 520800.0 |
| 2002-11-08 13:00:00 | AAPL | Stock | 0.2796 | 0.2804 | 0.2796 | 0.28 | 677600.0 |
| 2002-11-08 13:05:00 | AAPL | Stock | 0.2796 | 0.2798 | 0.2795 | 0.2798 | 593600.0 |
| 2002-11-08 13:10:00 | AAPL | Stock | 0.2798 | 0.2804 | 0.2798 | 0.28 | 1702400.0 |
| 2002-11-08 13:15:00 | AAPL | Stock | 0.28 | 0.2802 | 0.2798 | 0.2798 | 513520.0 |
> showing 50 of 127,736 rows — these rows as CSV