PREVIEW / stock_30min / 2004-01-05
file: by_date/stock_30min/2004/2004-01-05.parquet size: 773 KB rows: 40,958 symbols: 1,718
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-05 08:00:00 | AAPL | Stock | 0.3813 | 0.3841 | 0.3813 | 0.3841 | 67200.0 |
| 2004-01-05 08:30:00 | AAPL | Stock | 0.3848 | 0.3848 | 0.3813 | 0.3839 | 127568.0 |
| 2004-01-05 09:00:00 | AAPL | Stock | 0.3839 | 0.3866 | 0.38 | 0.3839 | 802032.0 |
| 2004-01-05 09:30:00 | AAPL | Stock | 0.3841 | 0.388 | 0.3839 | 0.3875 | 26904864.0 |
| 2004-01-05 10:00:00 | AAPL | Stock | 0.3875 | 0.3893 | 0.3861 | 0.3888 | 17919160.0 |
| 2004-01-05 10:30:00 | AAPL | Stock | 0.3888 | 0.3929 | 0.3877 | 0.3929 | 32452728.0 |
| 2004-01-05 11:00:00 | AAPL | Stock | 0.3927 | 0.3939 | 0.3918 | 0.3921 | 28435680.0 |
| 2004-01-05 11:30:00 | AAPL | Stock | 0.3921 | 0.393 | 0.3914 | 0.3929 | 23795632.0 |
| 2004-01-05 12:00:00 | AAPL | Stock | 0.3929 | 0.3998 | 0.3929 | 0.3991 | 52098648.0 |
| 2004-01-05 12:30:00 | AAPL | Stock | 0.3993 | 0.3996 | 0.3982 | 0.3995 | 25095896.0 |
| 2004-01-05 13:00:00 | AAPL | Stock | 0.3995 | 0.3996 | 0.3979 | 0.3979 | 27666576.0 |
| 2004-01-05 13:30:00 | AAPL | Stock | 0.3979 | 0.3984 | 0.3961 | 0.3975 | 32056528.0 |
| 2004-01-05 14:00:00 | AAPL | Stock | 0.3975 | 0.3995 | 0.3971 | 0.3989 | 16088856.0 |
| 2004-01-05 14:30:00 | AAPL | Stock | 0.3989 | 0.3989 | 0.3945 | 0.3946 | 17332728.0 |
| 2004-01-05 15:00:00 | AAPL | Stock | 0.3946 | 0.3973 | 0.3946 | 0.3966 | 33166112.0 |
| 2004-01-05 15:30:00 | AAPL | Stock | 0.3964 | 0.3966 | 0.3932 | 0.3952 | 33343520.0 |
| 2004-01-05 16:00:00 | AAPL | Stock | 0.395 | 0.3998 | 0.3946 | 0.3979 | 5202400.0 |
| 2004-01-05 16:30:00 | AAPL | Stock | 0.3959 | 0.3973 | 0.3946 | 0.3955 | 683200.0 |
| 2004-01-05 17:00:00 | AAPL | Stock | 0.3959 | 0.3973 | 0.3959 | 0.3973 | 992208.0 |
| 2004-01-05 17:30:00 | AAPL | Stock | 0.3979 | 0.3998 | 0.3979 | 0.3998 | 235200.0 |
| 2004-01-05 18:00:00 | AAPL | Stock | 0.4 | 0.4002 | 0.397 | 0.4002 | 123200.0 |
| 2004-01-05 08:00:00 | MSFT | Stock | 27.42 | 27.85 | 27.42 | 27.7 | 375780.0 |
| 2004-01-05 08:30:00 | MSFT | Stock | 27.72 | 27.75 | 27.7 | 27.73 | 50994.0 |
| 2004-01-05 09:00:00 | MSFT | Stock | 27.75 | 27.77 | 27.46 | 27.74 | 313880.0 |
| 2004-01-05 09:30:00 | MSFT | Stock | 27.73 | 27.95 | 27.72 | 27.92 | 9627861.0 |
| 2004-01-05 10:00:00 | MSFT | Stock | 27.92 | 27.98 | 27.85 | 27.97 | 5157877.0 |
| 2004-01-05 10:30:00 | MSFT | Stock | 27.97 | 28.001 | 27.92 | 27.97 | 6325606.0 |
| 2004-01-05 11:00:00 | MSFT | Stock | 27.97 | 27.98 | 27.89 | 27.9 | 3601415.0 |
| 2004-01-05 11:30:00 | MSFT | Stock | 27.9 | 27.96 | 27.88 | 27.93 | 3442644.0 |
| 2004-01-05 12:00:00 | MSFT | Stock | 27.92 | 28.1 | 27.92 | 28.0 | 7604262.0 |
| 2004-01-05 12:30:00 | MSFT | Stock | 28.0 | 28.06 | 27.96 | 28.01 | 3290607.0 |
| 2004-01-05 13:00:00 | MSFT | Stock | 28.01 | 28.15 | 28.0 | 28.11 | 3120683.0 |
| 2004-01-05 13:30:00 | MSFT | Stock | 28.11 | 28.15 | 28.05 | 28.08 | 2154965.0 |
| 2004-01-05 14:00:00 | MSFT | Stock | 28.08 | 28.1 | 28.04 | 28.09 | 3027356.0 |
| 2004-01-05 14:30:00 | MSFT | Stock | 28.1 | 28.1 | 28.04 | 28.07 | 2356327.0 |
| 2004-01-05 15:00:00 | MSFT | Stock | 28.08 | 28.14 | 28.07 | 28.11 | 3464576.0 |
| 2004-01-05 15:30:00 | MSFT | Stock | 28.12 | 28.15 | 28.05 | 28.13 | 6355772.0 |
| 2004-01-05 16:00:00 | MSFT | Stock | 28.12 | 28.2 | 27.9874 | 28.18 | 1724849.0 |
| 2004-01-05 16:30:00 | MSFT | Stock | 28.18 | 28.19 | 28.14 | 28.14 | 217385.0 |
| 2004-01-05 17:00:00 | MSFT | Stock | 28.14 | 28.17 | 28.11 | 28.15 | 51878.0 |
| 2004-01-05 17:30:00 | MSFT | Stock | 28.16 | 28.18 | 28.14 | 28.15 | 11619.0 |
| 2004-01-05 18:00:00 | MSFT | Stock | 28.15 | 28.18 | 28.15 | 28.18 | 1892.0 |
| 2004-01-05 08:30:00 | NVDA | Stock | 0.195 | 0.195 | 0.195 | 0.195 | 240000.0 |
| 2004-01-05 09:00:00 | NVDA | Stock | 0.1948 | 0.1952 | 0.1942 | 0.1952 | 876000.0 |
| 2004-01-05 09:30:00 | NVDA | Stock | 0.1952 | 0.1964 | 0.1935 | 0.1956 | 65352480.0 |
| 2004-01-05 10:00:00 | NVDA | Stock | 0.1956 | 0.1968 | 0.1952 | 0.1964 | 89124840.0 |
| 2004-01-05 10:30:00 | NVDA | Stock | 0.1963 | 0.1969 | 0.1955 | 0.1965 | 46737480.0 |
| 2004-01-05 11:00:00 | NVDA | Stock | 0.1965 | 0.1966 | 0.1949 | 0.1956 | 27799320.0 |
| 2004-01-05 11:30:00 | NVDA | Stock | 0.1957 | 0.1967 | 0.1957 | 0.1962 | 42493320.0 |
| 2004-01-05 12:00:00 | NVDA | Stock | 0.1962 | 0.1965 | 0.1959 | 0.1962 | 12391320.0 |
> showing 50 of 40,958 rows — these rows as CSV