PREVIEW / stock_30min / 2005-04-29
file: by_date/stock_30min/2005/2005-04-29.parquet size: 900 KB rows: 47,622 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:30: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.2825 | 1.2854 | 1338568.0 |
| 2005-04-29 08:30:00 | AAPL | Stock | 1.2854 | 1.2929 | 1.2854 | 1.2861 | 1561252.0 |
| 2005-04-29 09:00:00 | AAPL | Stock | 1.2868 | 1.29 | 1.2693 | 1.29 | 2763516.0 |
| 2005-04-29 09:30:00 | AAPL | Stock | 1.2911 | 1.2939 | 1.2779 | 1.2882 | 76052900.0 |
| 2005-04-29 10:00:00 | AAPL | Stock | 1.2882 | 1.2936 | 1.2729 | 1.2796 | 72340296.0 |
| 2005-04-29 10:30:00 | AAPL | Stock | 1.2796 | 1.2814 | 1.2579 | 1.2689 | 83680604.0 |
| 2005-04-29 11:00:00 | AAPL | Stock | 1.2686 | 1.2805 | 1.2643 | 1.2704 | 43452920.0 |
| 2005-04-29 11:30:00 | AAPL | Stock | 1.2704 | 1.2743 | 1.2657 | 1.2721 | 31701460.0 |
| 2005-04-29 12:00:00 | AAPL | Stock | 1.2718 | 1.2739 | 1.2689 | 1.2693 | 15553216.0 |
| 2005-04-29 12:30:00 | AAPL | Stock | 1.2693 | 1.2789 | 1.2689 | 1.2757 | 25535104.0 |
| 2005-04-29 13:00:00 | AAPL | Stock | 1.2757 | 1.2896 | 1.2757 | 1.2825 | 61681788.0 |
| 2005-04-29 13:30:00 | AAPL | Stock | 1.2821 | 1.2832 | 1.2764 | 1.2811 | 32097800.0 |
| 2005-04-29 14:00:00 | AAPL | Stock | 1.2807 | 1.2839 | 1.2782 | 1.2829 | 24607156.0 |
| 2005-04-29 14:30:00 | AAPL | Stock | 1.2825 | 1.2914 | 1.2821 | 1.2882 | 52442740.0 |
| 2005-04-29 15:00:00 | AAPL | Stock | 1.2882 | 1.2896 | 1.2825 | 1.2879 | 42246400.0 |
| 2005-04-29 15:30:00 | AAPL | Stock | 1.2878 | 1.29 | 1.2832 | 1.2871 | 63471688.0 |
| 2005-04-29 16:00:00 | AAPL | Stock | 1.2861 | 1.2904 | 1.2857 | 1.2878 | 3468080.0 |
| 2005-04-29 16:30:00 | AAPL | Stock | 1.2879 | 1.295 | 1.2878 | 1.295 | 1835232.0 |
| 2005-04-29 17:00:00 | AAPL | Stock | 1.295 | 1.295 | 1.2879 | 1.2939 | 272216.0 |
| 2005-04-29 17:30:00 | AAPL | Stock | 1.2936 | 1.2936 | 1.2845 | 1.2936 | 251804.0 |
| 2005-04-29 18:00:00 | AAPL | Stock | 1.2918 | 1.2939 | 1.2875 | 1.2918 | 203140.0 |
| 2005-04-29 07:00:00 | MSFT | Stock | 24.99 | 25.03 | 24.98 | 25.03 | 3500.0 |
| 2005-04-29 07:30:00 | MSFT | Stock | 25.03 | 25.08 | 25.03 | 25.05 | 1600.0 |
| 2005-04-29 08:00:00 | MSFT | Stock | 24.78 | 24.94 | 24.77 | 24.86 | 342256.0 |
| 2005-04-29 08:30:00 | MSFT | Stock | 24.85 | 24.9 | 24.77 | 24.81 | 386760.0 |
| 2005-04-29 09:00:00 | MSFT | Stock | 24.81 | 24.92 | 24.46 | 24.87 | 837017.0 |
| 2005-04-29 09:30:00 | MSFT | Stock | 24.88 | 24.99 | 24.8 | 24.88 | 13671727.0 |
| 2005-04-29 10:00:00 | MSFT | Stock | 24.88 | 24.98 | 24.83 | 24.96 | 11028858.0 |
| 2005-04-29 10:30:00 | MSFT | Stock | 24.96 | 24.98 | 24.79 | 24.85 | 8445687.0 |
| 2005-04-29 11:00:00 | MSFT | Stock | 24.85 | 24.92 | 24.8 | 24.9 | 6656700.0 |
| 2005-04-29 11:30:00 | MSFT | Stock | 24.9 | 24.91 | 24.86 | 24.9 | 2919393.0 |
| 2005-04-29 12:00:00 | MSFT | Stock | 24.89 | 24.96 | 24.89 | 24.93 | 2855341.0 |
| 2005-04-29 12:30:00 | MSFT | Stock | 24.93 | 24.97 | 24.879 | 24.93 | 3280746.0 |
| 2005-04-29 13:00:00 | MSFT | Stock | 24.93 | 25.0 | 24.93 | 24.948 | 4075028.0 |
| 2005-04-29 13:30:00 | MSFT | Stock | 24.95 | 24.98 | 24.9 | 24.97 | 2379402.0 |
| 2005-04-29 14:00:00 | MSFT | Stock | 24.97 | 25.01 | 24.95 | 24.99 | 4334471.0 |
| 2005-04-29 14:30:00 | MSFT | Stock | 24.99 | 25.18 | 24.98 | 25.14 | 10841638.0 |
| 2005-04-29 15:00:00 | MSFT | Stock | 25.14 | 25.22 | 25.08 | 25.18 | 8578499.0 |
| 2005-04-29 15:30:00 | MSFT | Stock | 25.18 | 25.29 | 25.16 | 25.28 | 12150617.0 |
| 2005-04-29 16:00:00 | MSFT | Stock | 25.28 | 25.33 | 25.27 | 25.3 | 1692412.0 |
| 2005-04-29 16:30:00 | MSFT | Stock | 25.3 | 25.31 | 25.19 | 25.3 | 460786.0 |
| 2005-04-29 17:00:00 | MSFT | Stock | 25.29 | 25.3 | 25.29 | 25.3 | 6755.0 |
| 2005-04-29 17:30:00 | MSFT | Stock | 25.29 | 25.3 | 25.102 | 25.28 | 42936.0 |
| 2005-04-29 18:00:00 | MSFT | Stock | 25.28 | 25.3 | 25.27 | 25.27 | 106745.0 |
| 2005-04-29 08:30:00 | NVDA | Stock | 0.1842 | 0.1842 | 0.1817 | 0.1833 | 168000.0 |
| 2005-04-29 09:00:00 | NVDA | Stock | 0.1823 | 0.1823 | 0.1817 | 0.1818 | 226800.0 |
| 2005-04-29 09:30:00 | NVDA | Stock | 0.1826 | 0.184 | 0.1806 | 0.1812 | 32737200.0 |
| 2005-04-29 10:00:00 | NVDA | Stock | 0.1813 | 0.1822 | 0.1773 | 0.1776 | 43482000.0 |
| 2005-04-29 10:30:00 | NVDA | Stock | 0.1776 | 0.178 | 0.1743 | 0.1757 | 62462040.0 |
> showing 50 of 47,622 rows — these rows as CSV