PREVIEW / stock_30min / 2003-07-17
file: by_date/stock_30min/2003/2003-07-17.parquet size: 693 KB rows: 37,237 symbols: 1,584
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 |
|---|---|---|---|---|---|---|---|
| 2003-07-17 08:00:00 | AAPL | Stock | 0.3552 | 0.3594 | 0.3552 | 0.3552 | 72240.0 |
| 2003-07-17 08:30:00 | AAPL | Stock | 0.3554 | 0.3571 | 0.3554 | 0.357 | 182280.0 |
| 2003-07-17 09:00:00 | AAPL | Stock | 0.357 | 0.3602 | 0.357 | 0.36 | 2318400.0 |
| 2003-07-17 09:30:00 | AAPL | Stock | 0.3605 | 0.3723 | 0.3596 | 0.3698 | 137290440.0 |
| 2003-07-17 10:00:00 | AAPL | Stock | 0.3698 | 0.3707 | 0.3625 | 0.3659 | 75981304.0 |
| 2003-07-17 10:30:00 | AAPL | Stock | 0.3657 | 0.3679 | 0.3643 | 0.3679 | 43875552.0 |
| 2003-07-17 11:00:00 | AAPL | Stock | 0.3677 | 0.3704 | 0.3675 | 0.3686 | 44308992.0 |
| 2003-07-17 11:30:00 | AAPL | Stock | 0.3688 | 0.3696 | 0.3661 | 0.3668 | 31409168.0 |
| 2003-07-17 12:00:00 | AAPL | Stock | 0.367 | 0.3684 | 0.3654 | 0.3669 | 20032936.0 |
| 2003-07-17 12:30:00 | AAPL | Stock | 0.3667 | 0.3668 | 0.3635 | 0.3646 | 33372136.0 |
| 2003-07-17 13:00:00 | AAPL | Stock | 0.3645 | 0.3705 | 0.3645 | 0.3689 | 36561616.0 |
| 2003-07-17 13:30:00 | AAPL | Stock | 0.3688 | 0.3689 | 0.3666 | 0.3682 | 18489240.0 |
| 2003-07-17 14:00:00 | AAPL | Stock | 0.368 | 0.3686 | 0.3668 | 0.368 | 27144768.0 |
| 2003-07-17 14:30:00 | AAPL | Stock | 0.368 | 0.3693 | 0.3659 | 0.3666 | 65816240.0 |
| 2003-07-17 15:00:00 | AAPL | Stock | 0.3664 | 0.3696 | 0.3657 | 0.3693 | 36993656.0 |
| 2003-07-17 15:30:00 | AAPL | Stock | 0.3688 | 0.3741 | 0.3682 | 0.3734 | 84189280.0 |
| 2003-07-17 16:00:00 | AAPL | Stock | 0.3734 | 0.3738 | 0.3669 | 0.3736 | 15932000.0 |
| 2003-07-17 16:30:00 | AAPL | Stock | 0.3552 | 0.375 | 0.3552 | 0.3746 | 1089536.0 |
| 2003-07-17 17:00:00 | AAPL | Stock | 0.3746 | 0.375 | 0.3746 | 0.375 | 114744.0 |
| 2003-07-17 17:30:00 | AAPL | Stock | 0.375 | 0.3752 | 0.3714 | 0.3725 | 453600.0 |
| 2003-07-17 18:00:00 | AAPL | Stock | 0.3747 | 0.3747 | 0.3718 | 0.3718 | 55720.0 |
| 2003-07-17 08:00:00 | MSFT | Stock | 27.01 | 27.15 | 26.93 | 27.13 | 133664.0 |
| 2003-07-17 08:30:00 | MSFT | Stock | 27.139 | 27.24 | 27.0 | 27.13 | 121596.0 |
| 2003-07-17 09:00:00 | MSFT | Stock | 27.15 | 27.189 | 27.12 | 27.13 | 763763.0 |
| 2003-07-17 09:30:00 | MSFT | Stock | 27.14 | 27.27 | 27.08 | 27.22 | 6332186.0 |
| 2003-07-17 10:00:00 | MSFT | Stock | 27.22 | 27.23 | 26.98 | 27.07 | 5612666.0 |
| 2003-07-17 10:30:00 | MSFT | Stock | 27.07 | 27.07 | 26.81 | 26.87 | 5036009.0 |
| 2003-07-17 11:00:00 | MSFT | Stock | 26.861 | 26.97 | 26.82 | 26.928 | 2678769.0 |
| 2003-07-17 11:30:00 | MSFT | Stock | 26.93 | 26.98 | 26.88 | 26.931 | 1644196.0 |
| 2003-07-17 12:00:00 | MSFT | Stock | 26.93 | 27.02 | 26.84 | 26.889 | 2769540.0 |
| 2003-07-17 12:30:00 | MSFT | Stock | 26.89 | 26.9 | 26.65 | 26.68 | 4154011.0 |
| 2003-07-17 13:00:00 | MSFT | Stock | 26.68 | 26.807 | 26.66 | 26.77 | 2349711.0 |
| 2003-07-17 13:30:00 | MSFT | Stock | 26.77 | 26.78 | 26.66 | 26.72 | 2613146.0 |
| 2003-07-17 14:00:00 | MSFT | Stock | 26.7251 | 26.81 | 26.65 | 26.79 | 3816427.0 |
| 2003-07-17 14:30:00 | MSFT | Stock | 26.7895 | 26.89 | 26.59 | 26.63 | 5023595.0 |
| 2003-07-17 15:00:00 | MSFT | Stock | 26.63 | 26.82 | 26.61 | 26.8 | 3506956.0 |
| 2003-07-17 15:30:00 | MSFT | Stock | 26.81 | 26.81 | 26.54 | 26.69 | 9297818.0 |
| 2003-07-17 16:00:00 | MSFT | Stock | 26.69 | 27.29 | 26.52 | 27.27 | 4447403.0 |
| 2003-07-17 16:30:00 | MSFT | Stock | 27.28 | 27.52 | 26.78 | 27.2 | 3292369.0 |
| 2003-07-17 17:00:00 | MSFT | Stock | 27.2 | 27.2 | 26.701 | 26.997 | 868706.0 |
| 2003-07-17 17:30:00 | MSFT | Stock | 27.0 | 27.1 | 26.81 | 27.07 | 488070.0 |
| 2003-07-17 18:00:00 | MSFT | Stock | 27.089 | 27.1 | 26.7 | 26.76 | 363287.0 |
| 2003-07-17 08:00:00 | NVDA | Stock | 0.189 | 0.1892 | 0.1864 | 0.1878 | 540000.0 |
| 2003-07-17 08:30:00 | NVDA | Stock | 0.1878 | 0.1883 | 0.1878 | 0.1883 | 807000.0 |
| 2003-07-17 09:00:00 | NVDA | Stock | 0.1883 | 0.1892 | 0.1875 | 0.1875 | 2943600.0 |
| 2003-07-17 09:30:00 | NVDA | Stock | 0.1872 | 0.1891 | 0.1862 | 0.189 | 70779480.0 |
| 2003-07-17 10:00:00 | NVDA | Stock | 0.1891 | 0.1896 | 0.1864 | 0.1867 | 55768080.0 |
| 2003-07-17 10:30:00 | NVDA | Stock | 0.1867 | 0.1868 | 0.1842 | 0.1848 | 83751120.0 |
| 2003-07-17 11:00:00 | NVDA | Stock | 0.1848 | 0.1855 | 0.1847 | 0.1853 | 61847760.0 |
| 2003-07-17 11:30:00 | NVDA | Stock | 0.1852 | 0.1865 | 0.1852 | 0.1858 | 37993200.0 |
> showing 50 of 37,237 rows — these rows as CSV