PREVIEW / stock_30min / 2001-01-29
file: by_date/stock_30min/2001/2001-01-29.parquet size: 545 KB rows: 27,663 symbols: 1,274
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 |
|---|---|---|---|---|---|---|---|
| 2001-01-29 08:00:00 | AAPL | Stock | 0.3516 | 0.3516 | 0.3482 | 0.3493 | 134400.0 |
| 2001-01-29 08:30:00 | AAPL | Stock | 0.3504 | 0.3504 | 0.3504 | 0.3504 | 28000.0 |
| 2001-01-29 09:00:00 | AAPL | Stock | 0.346 | 0.3482 | 0.346 | 0.3482 | 414400.0 |
| 2001-01-29 09:30:00 | AAPL | Stock | 0.3493 | 0.3638 | 0.3493 | 0.3616 | 62132000.0 |
| 2001-01-29 10:00:00 | AAPL | Stock | 0.3616 | 0.3661 | 0.3605 | 0.365 | 36758400.0 |
| 2001-01-29 10:30:00 | AAPL | Stock | 0.365 | 0.3694 | 0.3616 | 0.3683 | 119554400.0 |
| 2001-01-29 11:00:00 | AAPL | Stock | 0.3672 | 0.3728 | 0.3672 | 0.3705 | 83910400.0 |
| 2001-01-29 11:30:00 | AAPL | Stock | 0.3705 | 0.3717 | 0.3683 | 0.3705 | 36327200.0 |
| 2001-01-29 12:00:00 | AAPL | Stock | 0.3705 | 0.3772 | 0.3694 | 0.375 | 75079200.0 |
| 2001-01-29 12:30:00 | AAPL | Stock | 0.375 | 0.3783 | 0.3717 | 0.3728 | 47499200.0 |
| 2001-01-29 13:00:00 | AAPL | Stock | 0.3728 | 0.375 | 0.3717 | 0.3739 | 33448800.0 |
| 2001-01-29 13:30:00 | AAPL | Stock | 0.375 | 0.3817 | 0.3728 | 0.3817 | 44693600.0 |
| 2001-01-29 14:00:00 | AAPL | Stock | 0.3806 | 0.3884 | 0.3795 | 0.3873 | 110891200.0 |
| 2001-01-29 14:30:00 | AAPL | Stock | 0.3862 | 0.3884 | 0.3817 | 0.3828 | 36915200.0 |
| 2001-01-29 15:00:00 | AAPL | Stock | 0.3828 | 0.3839 | 0.3806 | 0.3828 | 34367200.0 |
| 2001-01-29 15:30:00 | AAPL | Stock | 0.3839 | 0.3884 | 0.3828 | 0.3873 | 75336800.0 |
| 2001-01-29 16:00:00 | AAPL | Stock | 0.3878 | 0.3906 | 0.3711 | 0.3862 | 8344000.0 |
| 2001-01-29 16:30:00 | AAPL | Stock | 0.3862 | 0.3873 | 0.3862 | 0.3873 | 1086400.0 |
| 2001-01-29 17:00:00 | AAPL | Stock | 0.3873 | 0.3873 | 0.3873 | 0.3873 | 560000.0 |
| 2001-01-29 17:30:00 | AAPL | Stock | 0.3862 | 0.3867 | 0.385 | 0.385 | 229600.0 |
| 2001-01-29 18:00:00 | AAPL | Stock | 0.3839 | 0.3839 | 0.3839 | 0.3839 | 5600.0 |
| 2001-01-29 08:00:00 | MSFT | Stock | 31.7031 | 31.9844 | 31.5 | 31.5312 | 49000.0 |
| 2001-01-29 08:30:00 | MSFT | Stock | 31.625 | 31.8125 | 31.625 | 31.75 | 21600.0 |
| 2001-01-29 09:00:00 | MSFT | Stock | 31.75 | 32.0 | 31.75 | 31.7812 | 176400.0 |
| 2001-01-29 09:30:00 | MSFT | Stock | 31.7812 | 31.9375 | 31.5625 | 31.7812 | 7926600.0 |
| 2001-01-29 10:00:00 | MSFT | Stock | 31.7812 | 31.8125 | 31.5938 | 31.6875 | 3764600.0 |
| 2001-01-29 10:30:00 | MSFT | Stock | 31.6875 | 31.8438 | 31.625 | 31.7812 | 3324800.0 |
| 2001-01-29 11:00:00 | MSFT | Stock | 31.75 | 32.125 | 31.6875 | 32.0938 | 4468200.0 |
| 2001-01-29 11:30:00 | MSFT | Stock | 32.125 | 32.25 | 32.0 | 32.1562 | 3636000.0 |
| 2001-01-29 12:00:00 | MSFT | Stock | 32.1875 | 32.2188 | 31.875 | 31.9688 | 3470000.0 |
| 2001-01-29 12:30:00 | MSFT | Stock | 31.9375 | 32.0312 | 31.9062 | 31.9375 | 2585000.0 |
| 2001-01-29 13:00:00 | MSFT | Stock | 31.9375 | 32.0625 | 31.9062 | 32.0 | 3488200.0 |
| 2001-01-29 13:30:00 | MSFT | Stock | 32.0 | 32.0938 | 31.9688 | 32.0312 | 3573400.0 |
| 2001-01-29 14:00:00 | MSFT | Stock | 32.0312 | 32.1875 | 32.0 | 32.1406 | 5756600.0 |
| 2001-01-29 14:30:00 | MSFT | Stock | 32.125 | 32.1562 | 32.0312 | 32.0625 | 5320200.0 |
| 2001-01-29 15:00:00 | MSFT | Stock | 32.0625 | 32.0938 | 31.8281 | 32.0312 | 8579600.0 |
| 2001-01-29 15:30:00 | MSFT | Stock | 32.0312 | 32.3125 | 31.9375 | 32.2812 | 11628600.0 |
| 2001-01-29 16:00:00 | MSFT | Stock | 32.2812 | 32.375 | 31.6562 | 32.3125 | 4648400.0 |
| 2001-01-29 16:30:00 | MSFT | Stock | 32.2812 | 32.3125 | 31.6562 | 32.25 | 88000.0 |
| 2001-01-29 17:00:00 | MSFT | Stock | 32.1875 | 32.2812 | 32.1875 | 32.25 | 57800.0 |
| 2001-01-29 17:30:00 | MSFT | Stock | 32.25 | 32.375 | 32.25 | 32.375 | 8007000.0 |
| 2001-01-29 18:00:00 | MSFT | Stock | 32.3438 | 32.3438 | 32.1875 | 32.1875 | 2200.0 |
| 2001-01-29 08:30:00 | NVDA | Stock | 0.2104 | 0.2104 | 0.2104 | 0.2104 | 24000.0 |
| 2001-01-29 09:00:00 | NVDA | Stock | 0.2099 | 0.2099 | 0.2052 | 0.2057 | 144000.0 |
| 2001-01-29 09:30:00 | NVDA | Stock | 0.2052 | 0.2094 | 0.1979 | 0.2026 | 50592000.0 |
| 2001-01-29 10:00:00 | NVDA | Stock | 0.2022 | 0.2043 | 0.1995 | 0.2023 | 21648000.0 |
| 2001-01-29 10:30:00 | NVDA | Stock | 0.2026 | 0.2042 | 0.2016 | 0.2042 | 9384000.0 |
| 2001-01-29 11:00:00 | NVDA | Stock | 0.2036 | 0.2039 | 0.1979 | 0.2018 | 31800000.0 |
| 2001-01-29 11:30:00 | NVDA | Stock | 0.2018 | 0.2063 | 0.2018 | 0.2055 | 26424000.0 |
| 2001-01-29 12:00:00 | NVDA | Stock | 0.2052 | 0.2055 | 0.2021 | 0.2034 | 6624000.0 |
> showing 50 of 27,663 rows — these rows as CSV