PREVIEW / stock_30min / 2004-01-06
file: by_date/stock_30min/2004/2004-01-06.parquet size: 754 KB rows: 39,434 symbols: 1,707
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 |
|---|---|---|---|---|---|---|---|
| 2004-01-06 08:00:00 | AAPL | Stock | 0.3961 | 0.3964 | 0.3943 | 0.3952 | 263200.0 |
| 2004-01-06 08:30:00 | AAPL | Stock | 0.3959 | 0.3973 | 0.3959 | 0.3973 | 414400.0 |
| 2004-01-06 09:00:00 | AAPL | Stock | 0.3964 | 0.3973 | 0.3963 | 0.397 | 5951344.0 |
| 2004-01-06 09:30:00 | AAPL | Stock | 0.3973 | 0.3991 | 0.3889 | 0.3921 | 64941016.0 |
| 2004-01-06 10:00:00 | AAPL | Stock | 0.392 | 0.393 | 0.3877 | 0.3907 | 34851096.0 |
| 2004-01-06 10:30:00 | AAPL | Stock | 0.3909 | 0.3925 | 0.3905 | 0.392 | 14321888.0 |
| 2004-01-06 11:00:00 | AAPL | Stock | 0.392 | 0.397 | 0.3918 | 0.3964 | 57429736.0 |
| 2004-01-06 11:30:00 | AAPL | Stock | 0.3964 | 0.3982 | 0.3961 | 0.3973 | 29040592.0 |
| 2004-01-06 12:00:00 | AAPL | Stock | 0.397 | 0.4004 | 0.397 | 0.3988 | 27568744.0 |
| 2004-01-06 12:30:00 | AAPL | Stock | 0.3986 | 0.3988 | 0.3938 | 0.3939 | 18951856.0 |
| 2004-01-06 13:00:00 | AAPL | Stock | 0.3938 | 0.3957 | 0.3929 | 0.3934 | 18824064.0 |
| 2004-01-06 13:30:00 | AAPL | Stock | 0.3934 | 0.3975 | 0.393 | 0.3971 | 15759072.0 |
| 2004-01-06 14:00:00 | AAPL | Stock | 0.3973 | 0.3975 | 0.3957 | 0.3971 | 31942344.0 |
| 2004-01-06 14:30:00 | AAPL | Stock | 0.397 | 0.3984 | 0.3966 | 0.398 | 31014760.0 |
| 2004-01-06 15:00:00 | AAPL | Stock | 0.3977 | 0.398 | 0.3963 | 0.3973 | 17522288.0 |
| 2004-01-06 15:30:00 | AAPL | Stock | 0.3971 | 0.3977 | 0.3932 | 0.3939 | 61003768.0 |
| 2004-01-06 16:00:00 | AAPL | Stock | 0.3946 | 0.3973 | 0.3921 | 0.3929 | 26509056.0 |
| 2004-01-06 16:30:00 | AAPL | Stock | 0.3946 | 0.3946 | 0.392 | 0.3927 | 1184400.0 |
| 2004-01-06 17:00:00 | AAPL | Stock | 0.3921 | 0.3945 | 0.3916 | 0.3925 | 292544.0 |
| 2004-01-06 17:30:00 | AAPL | Stock | 0.3925 | 0.3946 | 0.3925 | 0.3946 | 420000.0 |
| 2004-01-06 18:00:00 | AAPL | Stock | 0.3945 | 0.3945 | 0.3945 | 0.3945 | 5600.0 |
| 2004-01-06 08:00:00 | MSFT | Stock | 28.16 | 28.16 | 28.15 | 28.15 | 26300.0 |
| 2004-01-06 08:30:00 | MSFT | Stock | 28.14 | 28.16 | 28.13 | 28.14 | 22260.0 |
| 2004-01-06 09:00:00 | MSFT | Stock | 28.15 | 28.18 | 28.09 | 28.1 | 113740.0 |
| 2004-01-06 09:30:00 | MSFT | Stock | 28.08 | 28.19 | 28.07 | 28.17 | 5376362.0 |
| 2004-01-06 10:00:00 | MSFT | Stock | 28.17 | 28.19 | 28.11 | 28.15 | 4117671.0 |
| 2004-01-06 10:30:00 | MSFT | Stock | 28.14 | 28.23 | 28.13 | 28.2 | 6153447.0 |
| 2004-01-06 11:00:00 | MSFT | Stock | 28.19 | 28.23 | 28.159 | 28.18 | 3330527.0 |
| 2004-01-06 11:30:00 | MSFT | Stock | 28.19 | 28.23 | 28.15 | 28.15 | 2519664.0 |
| 2004-01-06 12:00:00 | MSFT | Stock | 28.15 | 28.181 | 28.14 | 28.16 | 1586450.0 |
| 2004-01-06 12:30:00 | MSFT | Stock | 28.16 | 28.21 | 28.15 | 28.15 | 1736837.0 |
| 2004-01-06 13:00:00 | MSFT | Stock | 28.16 | 28.23 | 28.13 | 28.14 | 2477226.0 |
| 2004-01-06 13:30:00 | MSFT | Stock | 28.15 | 28.21 | 28.13 | 28.2 | 1095445.0 |
| 2004-01-06 14:00:00 | MSFT | Stock | 28.19 | 28.22 | 28.15 | 28.17 | 2420801.0 |
| 2004-01-06 14:30:00 | MSFT | Stock | 28.16 | 28.22 | 28.16 | 28.209 | 2882887.0 |
| 2004-01-06 15:00:00 | MSFT | Stock | 28.2 | 28.28 | 28.2 | 28.24 | 4684952.0 |
| 2004-01-06 15:30:00 | MSFT | Stock | 28.24 | 28.26 | 28.18 | 28.25 | 4184743.0 |
| 2004-01-06 16:00:00 | MSFT | Stock | 28.25 | 28.25 | 28.1847 | 28.1847 | 680313.0 |
| 2004-01-06 16:30:00 | MSFT | Stock | 28.25 | 28.25 | 28.2 | 28.21 | 547152.0 |
| 2004-01-06 17:00:00 | MSFT | Stock | 28.21 | 28.25 | 28.1327 | 28.23 | 10145.0 |
| 2004-01-06 17:30:00 | MSFT | Stock | 28.23 | 28.23 | 28.2 | 28.2 | 5106.0 |
| 2004-01-06 18:00:00 | MSFT | Stock | 28.23 | 28.23 | 28.2 | 28.2 | 3200.0 |
| 2004-01-06 18:30:00 | MSFT | Stock | 28.2 | 28.2 | 28.2 | 28.2 | 100.0 |
| 2004-01-06 08:00:00 | NVDA | Stock | 0.1982 | 0.1982 | 0.1982 | 0.1982 | 120000.0 |
| 2004-01-06 08:30:00 | NVDA | Stock | 0.1986 | 0.1987 | 0.1986 | 0.1987 | 60000.0 |
| 2004-01-06 09:00:00 | NVDA | Stock | 0.1979 | 0.1979 | 0.1976 | 0.1977 | 3211200.0 |
| 2004-01-06 09:30:00 | NVDA | Stock | 0.198 | 0.2022 | 0.1977 | 0.1997 | 97155360.0 |
| 2004-01-06 10:00:00 | NVDA | Stock | 0.1997 | 0.2015 | 0.1971 | 0.2013 | 173022840.0 |
| 2004-01-06 10:30:00 | NVDA | Stock | 0.2013 | 0.2087 | 0.201 | 0.2085 | 210840000.0 |
| 2004-01-06 11:00:00 | NVDA | Stock | 0.2085 | 0.2089 | 0.2045 | 0.2057 | 113908800.0 |
> showing 50 of 39,434 rows — these rows as CSV