PREVIEW / stock_30min / 2002-07-17
file: by_date/stock_30min/2002/2002-07-17.parquet size: 595 KB rows: 31,627 symbols: 1,440
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-07-17 08:00:00 | AAPL | Stock | 0.2964 | 0.2991 | 0.2911 | 0.2938 | 7050400.0 |
| 2002-07-17 08:30:00 | AAPL | Stock | 0.2945 | 0.2988 | 0.288 | 0.2902 | 14056000.0 |
| 2002-07-17 09:00:00 | AAPL | Stock | 0.29 | 0.3171 | 0.2857 | 0.2884 | 18709600.0 |
| 2002-07-17 09:30:00 | AAPL | Stock | 0.288 | 0.2889 | 0.2777 | 0.2786 | 254928800.0 |
| 2002-07-17 10:00:00 | AAPL | Stock | 0.2786 | 0.2832 | 0.2739 | 0.2777 | 180762400.0 |
| 2002-07-17 10:30:00 | AAPL | Stock | 0.2777 | 0.2793 | 0.2714 | 0.2768 | 124913600.0 |
| 2002-07-17 11:00:00 | AAPL | Stock | 0.2768 | 0.2804 | 0.2755 | 0.2759 | 75958400.0 |
| 2002-07-17 11:30:00 | AAPL | Stock | 0.2756 | 0.2777 | 0.2732 | 0.2768 | 60536000.0 |
| 2002-07-17 12:00:00 | AAPL | Stock | 0.2768 | 0.2779 | 0.2754 | 0.2766 | 35918400.0 |
| 2002-07-17 12:30:00 | AAPL | Stock | 0.2763 | 0.277 | 0.2713 | 0.2746 | 64954400.0 |
| 2002-07-17 13:00:00 | AAPL | Stock | 0.2746 | 0.2768 | 0.2734 | 0.2745 | 38808000.0 |
| 2002-07-17 13:30:00 | AAPL | Stock | 0.2745 | 0.2768 | 0.2729 | 0.2763 | 19051200.0 |
| 2002-07-17 14:00:00 | AAPL | Stock | 0.2757 | 0.2782 | 0.2752 | 0.2764 | 34412000.0 |
| 2002-07-17 14:30:00 | AAPL | Stock | 0.2764 | 0.2777 | 0.2741 | 0.275 | 44704800.0 |
| 2002-07-17 15:00:00 | AAPL | Stock | 0.275 | 0.2763 | 0.2741 | 0.2748 | 70487200.0 |
| 2002-07-17 15:30:00 | AAPL | Stock | 0.275 | 0.2804 | 0.2748 | 0.2793 | 91728000.0 |
| 2002-07-17 16:00:00 | AAPL | Stock | 0.2786 | 0.2811 | 0.2786 | 0.2811 | 12163200.0 |
| 2002-07-17 16:30:00 | AAPL | Stock | 0.2791 | 0.2818 | 0.2766 | 0.2818 | 6725600.0 |
| 2002-07-17 17:00:00 | AAPL | Stock | 0.2795 | 0.2795 | 0.2791 | 0.2791 | 789600.0 |
| 2002-07-17 17:30:00 | AAPL | Stock | 0.2791 | 0.2791 | 0.2773 | 0.2786 | 532000.0 |
| 2002-07-17 18:00:00 | AAPL | Stock | 0.2768 | 0.2768 | 0.2768 | 0.2768 | 84000.0 |
| 2002-07-17 08:00:00 | MSFT | Stock | 25.97 | 26.075 | 25.46 | 26.001 | 118600.0 |
| 2002-07-17 08:30:00 | MSFT | Stock | 26.0 | 26.2 | 26.0 | 26.19 | 184800.0 |
| 2002-07-17 09:00:00 | MSFT | Stock | 26.175 | 26.275 | 26.15 | 26.25 | 399000.0 |
| 2002-07-17 09:30:00 | MSFT | Stock | 26.26 | 26.65 | 26.223 | 26.415 | 14297400.0 |
| 2002-07-17 10:00:00 | MSFT | Stock | 26.42 | 26.565 | 26.23 | 26.35 | 6748800.0 |
| 2002-07-17 10:30:00 | MSFT | Stock | 26.3455 | 26.425 | 26.12 | 26.235 | 5449200.0 |
| 2002-07-17 11:00:00 | MSFT | Stock | 26.235 | 26.24 | 25.945 | 25.98 | 8271600.0 |
| 2002-07-17 11:30:00 | MSFT | Stock | 25.98 | 26.365 | 25.955 | 26.105 | 6976800.0 |
| 2002-07-17 12:00:00 | MSFT | Stock | 26.11 | 26.31 | 25.815 | 25.885 | 5856400.0 |
| 2002-07-17 12:30:00 | MSFT | Stock | 25.88 | 25.94 | 25.585 | 25.75 | 6782800.0 |
| 2002-07-17 13:00:00 | MSFT | Stock | 25.75 | 25.825 | 25.65 | 25.8 | 6972200.0 |
| 2002-07-17 13:30:00 | MSFT | Stock | 25.8055 | 25.995 | 25.67 | 25.87 | 4903800.0 |
| 2002-07-17 14:00:00 | MSFT | Stock | 25.87 | 25.995 | 25.76 | 25.79 | 5513800.0 |
| 2002-07-17 14:30:00 | MSFT | Stock | 25.82 | 25.905 | 25.605 | 25.725 | 4828800.0 |
| 2002-07-17 15:00:00 | MSFT | Stock | 25.725 | 26.035 | 25.59 | 26.0 | 7272800.0 |
| 2002-07-17 15:30:00 | MSFT | Stock | 26.0 | 26.145 | 25.795 | 25.993 | 8350000.0 |
| 2002-07-17 16:00:00 | MSFT | Stock | 26.005 | 26.35 | 25.955 | 26.125 | 1798000.0 |
| 2002-07-17 16:30:00 | MSFT | Stock | 26.15 | 26.195 | 26.0 | 26.14 | 767600.0 |
| 2002-07-17 17:00:00 | MSFT | Stock | 26.15 | 26.175 | 25.975 | 26.085 | 252400.0 |
| 2002-07-17 17:30:00 | MSFT | Stock | 26.05 | 26.075 | 25.98 | 25.98 | 74600.0 |
| 2002-07-17 18:00:00 | MSFT | Stock | 26.0 | 26.0 | 25.79 | 25.895 | 25800.0 |
| 2002-07-17 08:00:00 | NVDA | Stock | 0.17 | 0.1762 | 0.16 | 0.1742 | 15396000.0 |
| 2002-07-17 08:30:00 | NVDA | Stock | 0.1742 | 0.1767 | 0.1717 | 0.1742 | 14772000.0 |
| 2002-07-17 09:00:00 | NVDA | Stock | 0.1742 | 0.1767 | 0.1708 | 0.1737 | 19044000.0 |
| 2002-07-17 09:30:00 | NVDA | Stock | 0.1737 | 0.1771 | 0.1692 | 0.1702 | 352380000.0 |
| 2002-07-17 10:00:00 | NVDA | Stock | 0.1702 | 0.1725 | 0.1667 | 0.167 | 218136000.0 |
| 2002-07-17 10:30:00 | NVDA | Stock | 0.1669 | 0.1679 | 0.1637 | 0.1654 | 139656000.0 |
| 2002-07-17 11:00:00 | NVDA | Stock | 0.1654 | 0.1667 | 0.1642 | 0.1645 | 82188000.0 |
| 2002-07-17 11:30:00 | NVDA | Stock | 0.1647 | 0.1674 | 0.1643 | 0.1653 | 67200000.0 |
> showing 50 of 31,627 rows — these rows as CSV